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;