Search Results create_baseline_budget

Overview

APPS.PA_AGREEMENT_PUB is a public PL/SQL API package in Oracle Projects (PA) that provides the supported programmatic interface for creating, maintaining, and deleting project agreements and their associated funding records. An agreement in Oracle Projects captures the contractual or internal funding arrangement under which a project or project template is executed, and the funding records attached to an agreement define the specific customers, amounts, and revenue or invoice distributions that apply. This package encapsulates the validation, flexfield processing, and table maintenance logic required to manage that data consistently, shielding callers from the underlying PA_AGREEMENTS_ALL, PA_PROJECT_FUNDINGS, and related structures.

The package body declares global constants, including G_PKG_NAME and G_AGREEMENT_CODE, and captures the runtime session context through the package globals G_USER_ID and G_LOGIN_ID, populated from FND_GLOBAL. The source header identifies the file as PAAFAPBB.pls, with the most recent revision noted at version 120.14.12020000.4 dated 23 April 2013, establishing it as a stable interface across the EBS 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes eighteen documented subprograms. The core agreement lifecycle procedures are:

• CREATE_AGREEMENT — creates an agreement for an existing project or template, accepting agreement and funding input records and returning agreement and funding output records. It invokes supporting subprograms including PA_INTERFACE_UTILS_PUB.map_new_amg_msg, check_create_agreement_ok, PA_AGREEMENT_UTILS.validate_flex_fields, PA_AGREEMENT_PVT.convert_ag_ref_to_id, PA_AGREEMENT_UTILS.create_agreement, and ADD_FUNDING.
• UPDATE_AGREEMENT — modifies an existing agreement's attributes.
• DELETE_AGREEMENT — removes an agreement, subject to the validation performed by CHECK_DELETE_AGREEMENT_OK.
• INIT_AGREEMENT and CLEAR_AGREEMENT — initialize and reset the agreement record structures used across the API.
• LOAD_AGREEMENT and LOAD_FUNDING — load agreement and funding data into the internal working structures.
• EXECUTE_CREATE_AGREEMENT and EXECUTE_UPDATE_AGREEMENT — internal drivers that perform the actual create and update processing once validation has been completed.

Funding maintenance is handled by ADD_FUNDING, UPDATE_FUNDING, and DELETE_FUNDING, each guarded by a corresponding CHECK_ procedure (CHECK_ADD_FUNDING_OK, CHECK_UPDATE_FUNDING_OK, CHECK_DELETE_FUNDING_OK), with FETCH_FUNDING retrieving existing funding records. The procedure CREATE_BASELINE_BUDGET creates a baseline budget in association with the agreement, operating against PA_BUDGET_VERSIONS to establish the approved budget version.

Tables Accessed

The package reads and writes the principal Projects agreement and funding tables through APPS synonyms. PA_AGREEMENTS_ALL stores the agreement header records. PA_PROJECT_FUNDINGS and PA_SUMMARY_PROJECT_FUNDINGS hold funding detail and summarized funding data respectively. PA_PROJECTS_ALL and PA_TASKS provide the project and task context against which agreements and baselines are validated. PA_BUDGET_VERSIONS supports baseline budget creation. PA_RESOURCE_LIST_MEMBERS is consulted for resource list validation, PA_IMPLEMENTATIONS supplies installation-level configuration, and DUAL and PLITBLM are used for utility lookups and message handling.

Usage Notes

PA_AGREEMENT_PUB is the sanctioned interface for agreement maintenance and is referenced by three other packages within Oracle Projects. It is typically invoked from the Projects forms, from concurrent programs that bulk-load agreements and funding, and from custom extensions that must create or update agreements without directly manipulating the underlying tables. Callers should follow the standard Oracle API conventions: pass an API version number, a commit flag, an initialization flag, and inspect the returned message count, message data, and return status. Because the package maintains session globals and performs flexfield validation, direct table DML against the agreement and funding tables should be avoided in favor of this supported API.