API

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


manipulation.


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_PROGRAM.DELETE_EXECUTABLE( )

FND_PROGRAM.REGISTER( )

FND_PROGRAM.DELETE_PROGRAM( )

FND_PROGRAM.PARAMETER( )

FND_PROGRAM.DELETE_PARAMETER( )

FND_PROGRAM.INCOMPATIBILITY( )

FND_PROGRAM.DELETE_INCOMPATIBILITY( )

FND_PROGRAM.REQUEST_GROUP( )

FND_PROGRAM.DELETE_GROUP( )

FND_PROGRAM.ADD_TO_GROUP( )

FND_PROGRAM.REMOVE_FROM_GROUP( )

FND_REQUEST.SUBMIT_REQUEST( )

FND_CONCURRENT.WAIT_FOR_REQUEST( )

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_GLOBAL.LOGIN_ID

FND_GLOBAL.CONC_LOGIN_ID

FND_GLOBAL.PROG_APPL_ID

FND_GLOBAL.CONC_PROGRAM_ID

FND_GLOBAL.CONC_REQUEST_ID

FND_PROFILE.PUT(name,value)

FND_PROFILE.GET(name IN varchar2,value out varchar2)

API’S IN APPS

PO

PO_CUSTOM_PRICE_PUB

PO_DOCUMENT_CONTROL_PUB

PO_DOC_MANAGER_PUB

PO_WFDS_PUB

AP

AP_NOTES_PUB

AP_WEB_AUDIT_LIST_PUB

INV

INV_COST_GROUP_PUB

INV_ITEM_CATALOG_ELEM_PUB

INV_ITEM_CATEGORY_PUB

INV_ITEM_PUB

INV_ITEM_REVISION_PUB

INV_ITEM_STATUS_PUB

INV_LOT_API_PUB

INV_MATERIAL_STATUS_PUB

INV_MOVEMENT_STATISTICS_PUB

INV_MOVE_ORDER_PUB

INV_PICK_RELEASE_PUB

INV_PICK_WAVE_PICK_CONFIRM_PUB

INV_RESERVATION_PUB

INV_SERIAL_NUMBER_PUB

INV_SHIPPING_TRANSACTION_PUB