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

p_address_line1        => ’60 Main Street’,

— Output data elements

p_object_version_number    => ln_object_version_number

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Before API Execution –

After API Execution –