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                             => 32979,

p_information_type                 => ‘PQH_ROLE_USERS’,

p_pei_information_category    => ‘PQH_ROLE_USERS’,

p_pei_information3                 => ‘1’,

p_pei_information4                 => ‘N’,

p_pei_information5                 => ‘N’,

    — Output data elements

p_person_extra_info_id          => ln_person_extra_info_id,

p_object_version_number     => ln_object_version_number

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;