Search Results po_ga_common_grp




Overview
Explore in AI Chat

Overview

PO_GA_COMMON_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in ETRM as a GRP (group) package. It provides shared utility logic for the Global Agreement feature of Oracle Purchasing. A Global Agreement is a purchasing document that is authored and negotiated centrally by a parent or headquarters organization and then made available for use by multiple operating units or legal entities across the enterprise. Detecting whether a given purchasing document header represents a Global Agreement is a recurring requirement throughout the Purchasing application, and this package centralizes that determination in a single, reusable function.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the definer. Its header comment indicates an original revision date of November 2002 (script POXGACMS.pls), confirming it is long-standing infrastructure that has been carried forward through the 12.1.1 and 12.2.2 releases. In ETRM 12.2.2 the package exposes a single documented program and is referenced by one other package.

Key Procedures and Functions

  • IS_GLOBAL — The sole documented function in the package. It accepts a purchasing document header identifier and returns a BOOLEAN value: TRUE when the identified header is a Global Agreement, and FALSE otherwise. The parameter is typed against PO_HEADERS_ALL.po_header_id%TYPE, anchoring it directly to the primary key of the purchasing document header table and guaranteeing datatype consistency with the underlying column. Because the function returns a BOOLEAN, it is designed for direct use inside PL/SQL conditional logic rather than as a SQL select-list expression.

The comment block in the source associates the descriptive text "is_global_agreement" with this function; that phrase is the functional description of the routine rather than a separate callable program. No other procedures or functions are documented for this package.

Tables Accessed

  • PO_HEADERS_ALL — The purchasing document header table, accessed through an APPS synonym. The function reads this table to evaluate the attributes of the header identified by the supplied po_header_id and determine whether the document qualifies as a Global Agreement. This is the only documented table reference, consistent with a lightweight determination function that inspects header-level information rather than line, shipment, or distribution detail.

Usage Notes

Because the return type is BOOLEAN, IS_GLOBAL is intended for invocation from PL/SQL — forms client-side logic, concurrent program bodies, workflow function activities, or custom packages — where a direct conditional test such as IF po_ga_common_grp.is_global(p_po_header_id) THEN can be evaluated. It cannot be called directly from a SQL statement without wrapping it in a PL/SQL block or a converter function. ETRM records one dependent package that references PO_GA_COMMON_GRP, indicating that the broader Global Agreement code path relies on this determination when deciding how a document may be processed, referenced, or reused across operating units. Customizations that need the same classification should call this package rather than reimplementing the underlying header inspection, preserving consistency with standard Purchasing behavior across 12.1.1 and 12.2.2.