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
- Create Employee Contact Using Oracle HRMS API
- Create Employee Element Entry Using Oracle HRMS API
- Create Employee In Oracle Apps Using Oracle HRMS API
- Create or Update Employee Phone Using Oracle HRMS API
- Delete Employee Element Entry Using Oracle HRMS API
- SQL Query To Get Oracle HR Organization Hierarchy
- Script To Rehire An Employee Using Oracle HRMS API
- Update An Employee In Oracle Apps Using Oracle HRMS API
- Update Employee Address Using Oracle HRMS API
COMMENTS