Oracle HRMS API – Update Employee Address

Oracle HRMS API – Update Employee Address

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;