Create Person Address API (Sample Script)

DECLARE

   ln_address_id                NUMBER;

   ln_addr_obj_version_number   NUMBER;

BEGIN

   apps.hr_person_address_api.create_person_address (

----------------------------------------------------------------

-- In Paramenters (HR_PERSON_ADDRESS_API.CREATE_PERSON_ADDRESS)

----------------------------------------------------------------

                                                     p_effective_date               => TRUNC (SYSDATE),

                                                     p_pradd_ovlapval_override      => FALSE,

                                                     p_validate_county              => TRUE,

                                                     p_person_id                    => 533285,

                                                     p_primary_flag                 => 'Y',

                                                     p_style                        => 'US',

                                                     p_date_from                    => TRUNC (SYSDATE),

                                                     p_address_line1                => '50 Main Street',

                                                     p_town_or_city                 => 'White Plains',

                                                     p_region_1                     => 'Westchester',

                                                     p_region_2                     => 'NY',

                                                     p_postal_code                  => 10601,

                                                     p_country                      => 'US',

-----------------------------------------------------------------

-- Out Paramenters (HR_PERSON_ADDRESS_API.CREATE_PERSON_ADDRESS)

-----------------------------------------------------------------

                                                     p_address_id                   => ln_address_id,

                                                     p_object_version_number        => ln_addr_obj_version_number

                                                    );

   DBMS_OUTPUT.put_line ('Address Id: ' || ln_address_id);

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line ('HR_PERSON_ADDRESS_API.CREATE_PERSON_ADDRESS API Error: ' || SQLERRM);

END;