This article gives a brief description of the APIs that you can use to integrate project data from an external system with Oracle Projects. The procedures discussed below are located in the public API package PA_PROJECT_PUB.
CREATE_PROJECT is a PL/SQL procedure that creates a project in Oracle Projects using a template or an existing project.
DELETE_PROJECT is a PL/SQL procedure used to delete a project and its tasks from Oracle Projects.
UPDATE_PROJECT is a PL/SQL procedure that updates project and task information from your external system to Oracle Projects to reflect changes you have made in the external system. UPDATE_PROJECT uses composite datatypes.
The following is the list of API’s for Load-Execute-Fetch and should be executed in the order of sequence.