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'

*/

No comments:

Post a Comment