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;

Other Articles Related To Oracle HRMS Module

1. Create Employee Address Using Oracle HRMS API
2. Create Employee Contact Using Oracle HRMS API
3. Create Employee Element Entry Using Oracle HRMS API
4. Create Employee In Oracle Apps Using Oracle HRMS API
5. Create or Update Employee Phone Using Oracle HRMS API
6. Delete Employee Element Entry Using Oracle HRMS API
7. SQL Query To Get Oracle HR Organization Hierarchy
8. Script To Rehire An Employee Using Oracle HRMS API
9. Update An Employee In Oracle Apps Using Oracle HRMS API