Oracle Project Public API - Project Billing Agreements

Package Name: Create Agreement
Internal Name: PA_AGREEMENT_PUB
Description: This package contains the public AMG APIs for agreement and Funding procedures that will be used by the external system
APIs (Functions and Procedures):

Name
Internal Name
Description
Create Multiple Project Agreements - Clear
CLEAR_AGREEMENT
This API clears the globals that were set up during initialization
Create Multiple Project Agreements - Execute Create
EXECUTE_CREATE_AGREEMENT
This API creates an agreement with the funding using the data stored in the global tables during the load phase
Create Multiple Project Agreements-Initialize
INIT_AGREEMENT
This API sets the global tables used by load-execute-fetch procedures that create a new agreement or update an existing agreement
Create Multiple Project Agreements-Load
LOAD_AGREEMENT
This API loads an agreement to a PL/SQL record
Create Multiple Project Fundings - Fetch
FETCH_FUNDING
This API gets the return status that was returned during creation of funds and stored in a global PL/SQL table
Create Multiple Project Fundings-load
LOAD_FUNDING
This API loads funding to a PL/SQL table
Create Project Agreement
CREATE_AGREEMENT
This API creates an agreement with associated funds from an external system
Create Project Funding
ADD_FUNDING
This API adds funding to an agreement
Delete Project Agreement
DELETE_AGREEMENT
This API deletes an agreement with associated funds from an external system
Delete Project Funding
DELETE_FUNDING
This API deletes a fund from an agreement
Update Multiple Project   Agreements
EXECUTE_UPDATE_AGREEMENT
This API updates an agreement with the funding using the data stored in the global tables during the load phase In order to execute this API the following list of API's should be executed in the order of sequence.
Update Project Agreement
UPDATE_AGREEMENT
This API updates an agreement and associated funds
Update Project Funding
UPDATE_FUNDING
This API updates a fund for an agreement
Validate Project Agreement Deletion
CHECK_DELETE_AGREEMENT_OK
This API checks whether an agreement can be deleted.
Validate Project Funding Creation
CHECK_ADD_FUNDING_OK
This API checks whether a fund can be added.
Validate Project Funding Deletion
CHECK_DELETE_FUNDING_OK
This API checks whether a fund can be deleted
Validate Project Funding Update
CHECK_UPDATE_FUNDING_OK
This API checks whether a fund can be added.