Search Results pa_agreements_pkg




Overview
Explore in AI Chat

Overview

PA_AGREEMENTS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It provides the foundational data-maintenance layer for project agreements — the contractual instruments that govern billing terms, revenue recognition, funding limits, invoice formats, and customer invoicing relationships attached to a project or award. In Oracle EBS 12.1.1 and 12.2.2, agreements are maintained in the Projects (PA) module and, in the grants and public-sector context, are shared with the Grants Management (GMS) module. The package encapsulates the canonical insert, lock, update, and delete operations against the agreement tables, ensuring that row-level locking and multi-org (ALL/S) table synchronization are handled consistently. It acts as the low-level persistence mechanism invoked by higher-level agreement maintenance logic rather than being a standalone concurrent submission target.

Key Procedures and Functions

The ETRM documentation identifies four procedures/functions, classified as an "OTHER" application-programming-interface type. Parameter lists are not published in the available metadata and are therefore not reproduced here.

  • INSERT_ROW — Creates a new agreement record, populating the agreement tables with the attributes required for billing, funding, and revenue setup.
  • LOCK_ROW — Acquires a row-level lock on the target agreement to serialize concurrent modification and prevent lost updates before a change is committed.
  • UPDATE_ROW — Applies changes to an existing agreement record, maintaining consistency across the agreement tables.
  • DELETE_ROW — Removes an agreement record as part of agreement maintenance or purge activity.

These four operations form a standard maintenance-API pattern; INSERT_ROW, UPDATE_ROW, and DELETE_ROW are the mutating operations, while LOCK_ROW supports optimistic-safe concurrency control.

Tables Accessed

The documented tables accessed through APPS synonyms are PA_AGREEMENTS, PA_AGREEMENTS_ALL, and PA_AGREEMENTS_S.

  • PA_AGREEMENTS — the core agreements table holding the principal agreement definition and its billing/funding attributes.
  • PA_AGREEMENTS_ALL — the multi-organization variant, covering agreements across operating units in a Multi-Org configuration.
  • PA_AGREEMENTS_S — the "S" (security/sequence-enabled) copy used in multi-org, row-level security and set-of-books environments.

The maintenance routines in this package are the mechanism by which the ALL and S tables are kept synchronized with the base table during agreement creation, change, and removal.

Usage Notes

PA_AGREEMENTS_PKG references APPS.PA_INTERFACE_UTILS_PUB, indicating that agreement records can be staged or processed through the interface utilities used for importing and transforming agreement data. It is referenced by GMS_AWARD_PVT, GMS_MULTI_FUNDING, PA_AGREEMENTS_PKG itself (recursive/overload use), and PA_AGREEMENT_CORE. This dependency pattern confirms that the package underlies both Projects agreement maintenance and Grants award/funding processing, where award agreements are created and funded. It is typically invoked indirectly — from the Projects agreement maintenance forms, from award and multi-funding business logic in GMS, and from PL/SQL blocks in custom extensions that need to create, lock, update, or delete agreements. Because it is an internal, low-level persistence package rather than a public API with documented parameter signatures, direct invocation from custom code should account for the ALL/S table synchronization and row-locking responsibilities performed by the package.