API to create Employee Address

DECLARE

ln_address_id                        PER_ADDRESSES.ADDRESS_ID%TYPE;

ln_object_version_number    PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE;

BEGIN

    — Create Employee Address

hr_person_address_api.create_person_address

(    — Input data elements

p_effective_date    => TO_DATE(’01-MAR-2012′),

p_person_id           => 2436,

p_primary_flag       => ‘Y’,

p_style                   => ‘US’,

p_date_from          => TO_DATE(’01-MAR-2012′),

p_address_line1    => ’50 Main Street’,

p_address_line2    => NULL,

p_town_or_city      => ‘White Plains’,

p_region_1           => ‘Westchester’,

p_region_2           => ‘NY’,

p_postal_code      => 10601,

p_country            => ‘US’,

        — Output data elements

p_address_id        => ln_address_id,

p_object_version_number    => ln_object_version_number

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Leave a Reply

Your email address will not be published. Required fields are marked *