Create or Update Employee Phone Using Oracle HRMS API

Following script can be used to create or update and Employee phone number using oracle HRMS API.

API --  hr_phone_api.create_or_update_phone

 
Example --
DECLARE        ln_phone_id                              PER_PHONES.PHONE_ID%TYPE;
       ln_object_version_number    PER_PHONES.OBJECT_VERSION_NUMBER%TYPE;
BEGIN
   -- Create or Update Employee Phone Detail
   -- -----------------------------------------------------------     hr_phone_api.create_or_update_phone
    (   -- Input data elements
        -- -----------------------------         p_date_from                             => TO_DATE('13-JUN-2011'),
        p_phone_type                          => 'W1',
        p_phone_number                   => '9999999',
        p_parent_id                              => 32979,
        p_parent_table                         => 'PER_ALL_PEOPLE_F',
        p_effective_date                       => TO_DATE('12-MAR-2013'),
        -- Output data elements
        -- --------------------------------         p_phone_id                              => ln_phone_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 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. 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