Oracle HRMS API – Update Employee Address
- by PRajkumar
API - hr_person_address_api.update_person_address
Example --
Consider Employee having Address Line1 -- "50 Main Street"
Lets Update Address Line1 -- "60 Main Street" using update address API
DECLARE
ln_address_id PER_ADDRESSES.ADDRESS_ID%TYPE;
ln_object_version_number PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE := 1;
BEGIN
-- Update Employee Address
-- ----------------------------------------
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;
