Oracle HRMS API's

HRMS API's

1.     Updating the Per_periods_of_service table using

               hr_ex_employee_api.update_term_details_emp

2.     Terminating using

               hr_ex_employee_api.actual_termination_emp

3.     Applying the final process in the shared instance using hr_ex_employee_api.final_process_emp

4.     Re - Hire

                 hr_employee_api.re_hire_ex_employee

5.     Updation On Already Existing Records

               hr_person_api.update_us_person

6.     New Hire

              hr_employee_api.create_us_employee

7.     Costing

             pay_cost_allocation_api.create_cost_allocation

8.     Load Update Assign

                hr_assignment_api.update_us_emp_asg

9.     Load Update Assign Criteria

                  hr_assignment_api.update_emp_asg_criteria

10.                        IF CONTACT PERSON ALREADY CREATED AND ONLY RELATION SHIP IS TO BE CREATED -

               Note : Contact Person Id Is To Be Passed

               hr_contact_rel_api.create_contact

11.                        If Contact Person Already Not Created

              Note : Contact Person Id is passed as Null(default of API)

               hr_contact_rel_api.create_contact

12.                        Load Phones

             hr_phone_api.create_phone

             hr_person_address_api.update_person_address

13.                        Load Addresses

hr_person_address_api.update_person_address

hr_person_address_api.create_person_address

14.                        Load Payment Methods

hr_personal_pay_method_api.create_us_personal_pay_method

15.                        Element Loading

py_element_entry_api.create_element_entry

py_element_entry_api.update_element_entry

16.                        Load Salaries

hr_upload_proposal_api.upload_salary_proposal

17.                        Approve Salary Proposal

hr_maintain_proposal_api.approve_salary_proposal

18.                        Starts To Validate/Load Federal Tax For A Person pay_federal_tax_rule_api.update_fed_tax_rule

19.                        State tax rules

pay_state_tax_rule_api.create_state_tax_rule

pay_state_tax_rule_api.update_state_tax_rule

20.                        County Tax Rules

pay_county_tax_rule_api.create_county_tax_rule

pay_county_tax_rule_api.update_county_tax_rule

21.                        City Tax Rules

pay_city_tax_rule_api.create_city_tax_rule

pay_city_tax_rule_api.update_city_tax_rule

22.                        Schools and Colleges

per_esa_upd.upd

per_esa_ins.ins

23.                        Performance Reviews

hr_perf_review_api.create_perf_review

hr_perf_review_api.update_perf_review

24.                        State Information Taxes

hr_sit_api.update_sit

hr_sit_api.create_sit

25.                        Qualifications

per_qualifications_api.create_qualification

per_qualifications_api.update_qualification

26.                        Locations

hr_location_api.update_location

hr_location_api.create_location

27.                        Organization

hr_organization_api.update_organization

hr_organization_api.create_org_classification

28.                        If any Change in Organization information.

if information2 = 'Y' then

hr_organization_api.enable_org_classification

If any Change in Organization information.

29.                        if information2 = 'N' then

hr_organization_api.disable_org_classification

30.                        If Organization does not exist in instance

hr_organization_api.create_organization api

31.                        Jobs

hr_job_api.update_job

hr_job_api.create_job

32.                        Positions

hr_position_api.update_position

hr_position_api.create_position

The query to get the list of HRMS API's in Oracle is as follows:

select * from all_objects where object_name like 'HR%\_API' escape '\' and object_type = 'PACKAGE'

union

select * from all_objects where object_name like 'PAY%\_API' escape '\' and object_type = 'PACKAGE'

union

select * from all_objects where object_name like 'PER%\_API' escape '\' and object_type = 'PACKAGE'