What is an API?
The Application Programmatic Interface or API is a PL/SQL packaged procedure that can be
used as an alternative to Application online forms for Application data entry and
The advantage of using an API to update application data is that users can maintain HRMS
information without using manual entry in Oracle application forms.
APIs insure the integrity of the interrelationship of Oracle Applications tables. You can
modify application information without detailed knowledge of the database structure, because
the API updates all the interrelated tables.
APIs help protect customer-specific data from database structural changes. As Oracle changes
table structures, the APIs are modified correspondingly, so that data can continue to be
modified without error or code updates.
How do I use an API to upload data?
The API package usually contains multiple procedures to insert, update, or delete application
data; the API procedures are executed when they are called by other PL/SQL modules, by a
direct SQL*Plus call, or through a front end such as the Data Pump.
The APIs do not issue commits. When a user-defined procedure or script calls the API
procedure, the calling module must manage transaction commit statements. The calling
module should also address exception handling and logging to delivered exception tables.
The API package should never be modified. Oracle cannot support modified APIs nor
systems that have used modified APIs, because HRMS data integrity could be compromised.
APIs can be used as building blocks called within an extensive customer-defined package.
Unique functionality can be addressed with API User Hooks or other user code, providing
that Oracle HRMS data is modified only through the call to the delivered API.
Different API's Present in Oracle Applications :
FND_PROGRAM.EXECUTABLE ( )
FND_REQUEST.SET_PRINT_OPTIONS ( )
FND_GLOBAL.USER_IDFND_GLOBAL.APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
FND_PROFILE.GET(name IN varchar2,value out varchar2)
API’S IN APPS