Create Person Extra Information API (Sample Script)

DECLARE

   ln_person_extra_info_id    NUMBER;

   ln_object_version_number   NUMBER;

BEGIN

   hr_person_extra_info_api.create_person_extra_info (p_validate                      => FALSE,

                                                      p_person_id                     => 533825,

                                                      p_information_type              => 'XX_NATIONAL_IDENTIFIER',

                                                      p_pei_attribute_category        => 'Mexico',

                                                      p_pei_attribute1                => 'X12345',

                                                      p_pei_attribute2                => 'X67890',

                                                      p_pei_attribute3                => 'ABCDXYZ',

                                                      p_pei_information_category      => 'XX_NATIONAL_IDENTIFIER',

                                                      p_pei_information1              => TO_CHAR (SYSDATE - 9000, 'RRRR/MM/DD HH24:MI:SS'),

                                                      p_pei_information3              => 'Mexico',

                                                      p_person_extra_info_id          => ln_person_extra_info_id,

                                                      p_object_version_number         => ln_object_version_number

                                                     );

   COMMIT;

   DBMS_OUTPUT.put_line ('LN_PERSON_EXTRA_INFO_ID : ' || ln_person_extra_info_id);

EXCEPTION

   WHEN OTHERS

   THEN

      ROLLBACK;

      DBMS_OUTPUT.put_line (SQLERRM);

END;