API to Create or Update Employee Extra Info (EIT)

DECLARE ln_object_version_number    PER_PEOPLE_EXTRA_INFO.OBJECT_VERSION_NUMBER%TYPE; ln_person_extra_info_id         PER_PEOPLE_EXTRA_INFO.OBJECT_VERSION_NUMBER%TYPE; BEGIN hr_person_extra_info_api.create_person_extra_info (    — Input data elements p_person_id                       

API to Update Employee

DECLARE     — Local Variables ln_object_version_number    PER_ALL_PEOPLE_F.OBJECT_VERSION_NUMBER%TYPE    := 7; lc_dt_ud_mode                      VARCHAR2(100)                    := NULL; ln_assignment_id           

API to Update Employee Assignment

DECLARE     — Local Variables lc_dt_ud_mode                   VARCHAR2(100)    := NULL; ln_assignment_id               NUMBER        := 33561; ln_supervisor_id 

API to Update STATE TAX

DECLARE lc_dt_ud_mode                     VARCHAR2(100)    := NULL; ln_assignment_id                  NUMBER        := 33561; ln_object_version_number 

API to Rehire Employee

DECLARE ln_per_object_version_number     PER_ALL_PEOPLE_F.OBJECT_VERSION_NUMBER%TYPE        := 5; ln_assg_object_version_number   PER_ALL_ASSIGNMENTS_F.OBJECT_VERSION_NUMBER%TYPE; ln_assignment_id                          PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE; ld_per_effective_start_date       

API to Create State Tax

DECLARE     lc_dt_ud_mode                  VARCHAR2(100)    := NULL;     ln_assignment_id               NUMBER        := 33561;     lb_correction       

API to Create Employee Contact

DECLARE ln_contact_relationship_id           PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE; ln_ctr_object_version_number    PER_CONTACT_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE; ln_contact_person                         PER_ALL_PEOPLE_F.PERSON_ID%TYPE; ln_object_version_number       

API to Update Employee Address

DECLARE ln_address_id                         PER_ADDRESSES.ADDRESS_ID%TYPE; ln_object_version_number    PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE    := 1; BEGIN hr_person_address_api.update_person_address (    — Input data elements p_effective_date        => TO_DATE(’10-JUN-2011′), p_address_id            =>