HRMS API's

 HRMS APIs

Usage	API Name
Update Per_periods_of_service table	hr_ex_employee_api.update_term_details_emp
Terminate user	hr_ex_employee_api.actual_termination_emp
Apply the final process in the shared instance	hr_ex_employee_api.final_process_emp
Re - Hire	hr_employee_api.re_hire_ex_employee
Update On Existing Records	hr_person_api.update_us_person
New Hire	hr_employee_api.create_us_employee
Costing	pay_cost_allocation_api.create_cost_allocation
Load Update Assign	hr_assignment_api.update_us_emp_asg
Load Update Assign Criteria	hr_assignment_api.update_emp_asg_criteria
Contact Person exists already but Relationship needs to be created	hr_contact_rel_api.create_contact Pass Contact Person Id
Contact person not created already	hr_contact_rel_api.create_contact Pass Contact Person Id as NULL
Load Phone	hr_phone_api.create_phone hr_person_address_api.update_person_address
Load Address	hr_person_address_api.update_person_address hr_person_address_api.create_person_address
Load Payment Method	hr_personal_pay_method_api.create_us_personal_pay_method
Element Loading	py_element_entry_api.create_element_entry py_element_entry_api.update_element_entry
Load Salary	hr_upload_proposal_api.upload_salary_proposal
Approve Salary Proposal	hr_maintain_proposal_api.approve_salary_proposal
Starts To Validate/Load Federal Tax for A Person	pay_federal_tax_rule_api.update_fed_tax_rule
State tax rules	pay_state_tax_rule_api.create_state_tax_rule pay_state_tax_rule_api.update_state_tax_rule
County Tax Rules	pay_county_tax_rule_api.create_county_tax_rule pay_county_tax_rule_api.update_county_tax_rule
City Tax Rules	pay_city_tax_rule_api.create_city_tax_rule pay_city_tax_rule_api.update_city_tax_rule
Schools and Colleges	per_esa_upd.upd per_esa_ins.ins
Performance Reviews	hr_perf_review_api.create_perf_review hr_perf_review_api.update_perf_review
State Information Taxes	hr_sit_api.update_sit hr_sit_api.create_sit
Qualifications	per_qualifications_api.create_qualification per_qualifications_api.update_qualification
Locations	hr_location_api.update_location hr_location_api.create_location
Organization	hr_organization_api.update_organization hr_organization_api.create_org_classification
Enable Organization classification	hr_organization_api.enable_org_classification
Disable Organization classification	hr_organization_api.disable_org_classification
Create Organization	hr_organization_api.create_organization
Jobs	hr_job_api.update_job hr_job_api.create_job
Positions	hr_position_api.update_position hr_position_api.create_position

Query to get the list of HRMS API's in Oracle:

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'