Update Employee Address Using Oracle HRMS API

Following script can be used to update an Employee Address using Oracle HRMS employee.

API - hr_person_address_api.update_person_address

Example --
Consider Employee having Address Line1 -- "#123 Main Street"
Lets Update Address Line1 -- "#456 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-JAN-2013'),
         p_address_id                          => 12121,
         p_address_line1                    => '#456 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;