Search Results gms_award

Overview

The APPS.GMS_CLIENT_EXTN_PO package is a public Oracle Grants Accounting (GMS) extension point that controls whether internal requisitions are permitted when processing purchasing activity against grant awards. It belongs to the GMS_AWARD business entity, is classified as OTHER under the ETRM API taxonomy, and is marked with an active lifecycle and S (supported) compatibility. The package header carries the repository display name "Allow Internal Requisitions," reflecting its single, narrowly scoped responsibility: returning a boolean-style decision (Y or equivalent) indicating whether internal requisition sourcing is allowed. It was introduced under header version gmspoces.pls 120.3 (dated 2006/07/28) and remains available in Oracle EBS 12.1.1 and 12.2.2. This extension effectively acts as a client-side hook layered atop standard GMS and Purchasing integration, allowing organizations to enforce policy on whether awards can be fulfilled through internal requisitions rather than external supplier purchases.

Key Procedures and Functions

The package exposes one documented callable element:

• ALLOW_INTERNAL_REQ (function returning VARCHAR2) — Returns the value 'Y' when internal requisitions should be allowed for the GMS award context; any other returned value suppresses that behavior. The extension point exists specifically so that customers can override default behavior by returning the appropriate indicator. Per the ETRM metadata, the function is public, active, and supported.

No other procedures or functions are documented, and parameter lists are not published in the metadata; the interface is defined solely by its return value.

Tables Accessed

No tables are documented as being referenced directly through APPS synonyms by this package. In practice, a client extension of this nature typically evaluates static configuration, a profile option, or a lookup rather than querying award tables directly, which is consistent with the absence of documented table references. Any data inspected by ALLOW_INTERNAL_REQ is therefore expected to come from configuration sources rather than base GMS or PO tables within this package's documented scope.

Usage Notes

• Invocation context: The function is called by Oracle Grants Accounting or Purchasing logic when determining whether internal requisition sourcing is valid for award-related transactions. It is not intended to be launched from a form or concurrent program directly.
• Client extension model: GMS_CLIENT_EXTN_PO is a seeded client extension; implementers modify the body to return the desired outcome. The documented default body returns Y, per the source excerpt.
• Dependencies: ETRM records that this package is referenced by one other package, confirming it functions as an extension point consumed by GMS framework code.
• Version applicability: Compatible with Oracle EBS 12.1.1 and 12.2.2; documented under 120gmsug.pdf, the Oracle Grants Accounting User's Guide.
• Customization caution: Because it is a client extension, changes must be reapplied after patching or upgrade, and any modification should preserve the documented VARCHAR2 return contract.