Create Employee Address Using Oracle HRMS API

Following script can be used to create an Employee Address using oracle HRMS API.

API - hr_person_address_api.create_person_address

Example --
 
DECLARE     ln_address_id                           PER_ADDRESSES.ADDRESS_ID%TYPE;
    ln_object_version_number    PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE;
BEGIN
   -- Create Employee Address
   -- --------------------------------------     hr_person_address_api.create_person_address
    (     -- Input data elements
          -- ------------------------------           p_effective_date                    => TO_DATE('01-JAN-2013'),
          p_person_id                           => 12345,
          p_primary_flag                     => 'Y',
          p_style                                     => 'US',
          p_date_from                           => TO_DATE('01-JAN-2013'),
          p_address_line1                   => '#123, Main Street',
          p_address_line2                   => NULL,
          p_town_or_city                     => 'White Plains',
          p_region_1                              => 'Westchester',
          p_region_2                              => 'NY',
          p_postal_code                        => 10601,
          p_country                                => 'US',
          -- Output data elements
          -- --------------------------------           p_address_id                          => ln_address_id,
          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 Contact Using Oracle HRMS API
2. Create Employee Element Entry Using Oracle HRMS API
3. Create Employee In Oracle Apps Using Oracle HRMS API
4. Create or Update Employee Phone Using Oracle HRMS API
5. Delete Employee Element Entry Using Oracle HRMS API
6. SQL Query To Get Oracle HR Organization Hierarchy
7. Script To Rehire An Employee Using Oracle HRMS API
8. Update An Employee In Oracle Apps Using Oracle HRMS API
9. Update Employee Address Using Oracle HRMS API