Oracle HRMS API: Update Employee Assignment API HRMS

Oracle HRMS API: Update Employee Assignment API

Aamir March 17, 2018

/* Formatted on 12-Mar-18 3:40:47 PM (QP5 v5.114.809.3010) */ DECLARE    l_object_version_number          NUMBER;    l_special_ceiling_step_id   …

Read more
How to - Oracle HRMS API: Create Positions API Oracle EBS

How to - Oracle HRMS API: Create Positions API

Aamir March 17, 2018

Oracle HRMS Employee Create API Script DECLARE    l_eff_start_date            date;    l_eff_end_date              date;    l_effective_date      …

Read more
Oracle HRMS API: Create Employee Contact API HRMS

Oracle HRMS API: Create Employee Contact API

Aamir March 17, 2018

DECLARE    ln_contact_rel_id             PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE;    ln_ctr_object_ver_num         PER_CONTACT_RELAT…

Read more
Oracle HRMS API: Create Employee Phone Numbers API HRMS

Oracle HRMS API: Create Employee Phone Numbers API

Aamir March 17, 2018

/* Formatted on 08-Mar-18 6:02:18 PM (QP5 v5.114.809.3010) */ DECLARE ln_phone_id                PER_PHONES.PHONE_ID%TYPE; ln_object_version_numbe…

Read more
Oracle HRMS API: Create Employee Address API HRMS

Oracle HRMS API: Create Employee Address API

Aamir March 16, 2018

DECLARE ln_address_id PER_ADDRESSES.ADDRESS_ID%TYPE; ln_object_version_number PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE; l_primary_flag PER_ADDRESS…

Read more
Oracle HRMS API: Create Employee API HRMS

Oracle HRMS API: Create Employee API

Aamir March 16, 2018

DECLARE    lc_employee_number            PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;    ln_person_id                  PER_ALL_PEOPLE_F.PERSON_ID%TYPE; …

Read more