Oracle Project Public API - Project Budgets

Package Name: Create Budget

Internal Name: PA_BUDGET_PUB

Description: This package contains the public AMG APIs for Budgets that will be used by the external system for preparing budget and use the API's to interface the budget and budget line into Oracle Projects.

APIs (Functions and Procedures):

Name
Internal Name
Description
Create Budget Line
ADD_BUDGET_LINE
This API is used to add a budget line to a working budget in Oracle Projects for a given project and budget type.
Create Draft Budget
CREATE_DRAFT_BUDGET
This API is used to create a draft budget and its budget lines in Oracle Projects for a given project, using a selected budget type and budget entry method.
Create Multiple Budgets- Load Budget Line
LOAD_BUDGET_LINE
This API is used to load a budget line to a global PL/SQL table.
Create Multiple Budgets-Clear
CLEAR_BUDGET
This API is used clear the global data structures set up during the Initialize step.
Create Multiple Budgets-Create Draft Budget
EXECUTE_CREATE_DRAFT_BUDGET
This API is used to create a budget and its budget lines using the data stored in the global tables during the Load process.
Create Multiple Budgets-Execute Calculate Amounts
EXECUTE_CALCULATE_AMOUNTS
This API is used to calculate the raw cost, burdened cost, and revenue amounts using existing budget lines for a given project and budget type In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Fetch Calculate Amounts
FETCH_CALCULATE_AMOUNTS
This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records updated by the API In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Initialize
INIT_BUDGET
This API is used to set up the global data structures that other Load Execute Fetch procedures use to create a new or update an existing draft budget in Oracle Projects In order to execute this API, the following list of API's should be
Create Multiple Budgets-Initialize Calculate Amounts
INIT_CALCULATE_AMOUNTS
This API issued to set up the global data structures used by the Load Execute Fetch API CALCULATE_AMOUNTS In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Load Fetch Line
FETCH_BUDGET_LINE
This API is used to retrieve the return status returned during the creation of a budget line from a global PL/SQL table.
Delete Budget Line
DELETE_BUDGET_LINE
This API is used to delete a budget line from a working budget in Oracle Projects for a given project and budget type.
Delete Draft Budget
DELETE_DRAFT_BUDGET
This API is used to delete a working budget in Oracle Projects for a given project and budget type.
Fetch Calculate Amounts
FETCH_CALCULATE_AMOUNTS
This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records updated by the API
Get Budget Amounts
CALCULATE_AMOUNTS
Using the PA_CLIENT_EXTN_BUDGET extension, you can use the public API CALCULATE_AMOUNTS to recalculate raw cost, burdened cost, and revenue amounts for existing budget lines.
Update Budget
UPDATE_BUDGET
This API is used to update the working budget with its budget lines in Oracle Projects for a given project.
Update Budget Line
UPDATE_BUDGET_LINE
This API is used to update an existing budget line of a working budget in Oracle Projects for a given project and budget type.
Update Multiple Budgets
EXECUTE_UPDATE_BUDGET
This API is used to update a budget and its budget lines using the data stored in the global tables during the Load process.
Verify Budget Amounts
BASELINE_BUDGET
This API is used to baseline an existing budget in Oracle Projects for a given project and budget type