Application Programming Interface (API) is a PL/SQL packaged procedure which can be used as an alternative to traditional Application online form.
Using APIs give users an advantage of adding data to the system is that user can enter new information or alter existing data without entering information manually into the application.
APIs insures the integrity of the interrelationship of Oracle Applications tables. User can modify application information without being aware of every feature of the database structure. It also depends on the API to update all the interrelated tables.
