Search Results get_award_id

Overview

GMS_ACC_GEN_API is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Grants Management (GMS) module and is classified as a public API. Its principal business function is to resolve the award identifier associated with accounting transactions originating in Grants Management, so that downstream accounting, costing, and distribution logic can attribute each transaction to the correct award. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling user rather than the definer, and the trailing "as" in the source header indicates the specification shown is the package interface that implementers and integrators call.

Key Procedures and Functions

The package specification exposes a single documented program unit, GET_AWARD_ID, implemented as a set of overloaded functions distinguished by their parameter signatures. Each variant returns a NUMBER representing the resolved award identifier. The documented overloads are:

• GET_AWARD_ID (expenditure item / document type / CDL line number with error outputs) — resolves the award from an expenditure item identifier and an associated document type and distribution line number, returning the award identifier and surfacing any failure through the error code and error message OUT parameters.
• GET_AWARD_ID (award set ID / attribute award ID / document type with error outputs) — resolves the award from the award set and a supplied attribute-level award identifier, with the document type defaulting to NULL when not provided, again returning status through the error outputs.
• GET_AWARD_ID (Workflow item type / item key / activity ID / function mode / result out) — the Oracle Workflow–style interface, returning the result as a VARCHAR2 resultout value so it can be consumed within a Workflow activity.
• GET_AWARD_ID (award set ID / document type) — the simplest variant, returning the award identifier directly without error output parameters. RESTRICT_REFERENCES pragmas declaring WNDS and WNPS apply to this overload.
• GET_AWARD_ID (expenditure encumbrance item ID / document type / CDL line) — resolves the award for encumbrance-related expenditure items, similarly governed by WNDS and WNPS pragmas.

No parameter lists beyond those visible in the specification are documented; integrators should treat the published signatures as the supported contract.

Tables Accessed

Two tables are referenced through APPS synonyms. GMS_AWARD_DISTRIBUTIONS holds the linkage between award records and their accounting distributions, and is the primary source used to derive the award identifier for a given distribution or expenditure context. GMS_IMPLEMENTATIONS stores Grants Management installation and configuration data and is consulted to establish the module's operating context. The package is documented as not being referenced by any other package, so it functions as a leaf-level utility invoked by external callers rather than by peers inside the GMS schema.

Usage Notes

Because the specification includes a Workflow-shaped overload, GET_AWARD_ID is typically invoked from Oracle Workflow process definitions where the award must be derived as part of a grants accounting activity. The error-output overloads suit PL/SQL callers such as grants accounting concurrent programs and custom extensions that require explicit error handling, while the minimalist overload returning a bare NUMBER is convenient in straight SQL or simple procedural contexts. The WNDS and WNPS pragmas on selected overloads mark them as safe for read-only database and package state, allowing use in contexts with restricted state requirements. Customizations should call the documented overloads rather than relying on the body, since the package is an APPS-owned API and its internal implementation is subject to change across EBS releases.