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 usinghr_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'