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 –
