What are APIs?

Application Program Interfaces (APIs) are standard stored procedure, package or functions created for performing specific activities like employee creation, assignment creation, etc There are 3 types of APIs which exists in EBS.

·      Private APIs: Private API's are one which Oracle normally using internal, development purpose only. Details are not provided to anyone outside of the immediate development environment, nor are they intended for use by anyone outside of the e-Business Suite development environment

·      Public APIs: These are designed for customers and Oracle consultants to integrate non-Oracle systems into Oracle e-Business Suite or to extend the functionality of the base products. Oracle does not support public APIs unless they are published in a reference manual

·      Public, published APIs: These are one which Oracle guaranteed to remain valid from release to release, and patches will not alter the API behavior. Public, published APIs are supported by Oracle to the same extent as released software

List of a few Oracle HRMS APIs

Hire New Emp	hr_employee_api.create_employee
Update  Existing Person in system	hr_person_api.update_person
Load  Assignment	hr_assignment_api.update_emp_asg
Load Phones	hr_phone_api.create_phone
Load/Update Addresses	hr_person_address_api.update_person_address  hr_person_address_api.create_person_address
Update per_periods_of_service table	hr_ex_employee_api.update_term_details_emp
Terminate employee	hr_ex_employee_api.actual_termination_emp
Re – Hire Employee	hr_employee_api.re_hire_ex_employee
Organizations	hr_organization_api.create_organization hr_organization_api.update_organization hr_organization_api.create_org_classification
Jobs	hr_job_api.update_job hr_job_api.create_job
Positions	hr_position_api.create_position hr_position_api.update_position

Script to find Oracle APIs for my module

select

substr(a.owner,1,20)Owner,

substr(a.name,1,30)Name,

substr(a.type,1,20)Type,

substr(u.status,1,10)Status,

substr(text,1,80)Description,

u.last_ddl_time

from

dba_source a,

dba_objects u

where 2=2

and a.text like '%Header%'

and u.object_name = a.name

and u.object_type = a.type

order by a.owner, a.name

PREVIOUS POST || NEXT POST