Search Results vert_get_award_id

Overview

APPS.PA_GMS_API is a PL/SQL package body that acts as the integration bridge between Oracle Projects and Oracle Grants Management (GMS) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal purpose is to allow the Projects transaction engine to query the Grants vertical application when it must decide whether expenditure adjustments, transfers, and related actions should be permitted. Rather than embedding Grants-specific logic directly in the Projects code path, the package exposes a stable set of Boolean-returning entry points that are conditionally delegated to GMS_PA_API when the Grants application is installed.

The package is classified in the ETRM repository as an API, is owned by APPS, and is referenced by ten other packages, indicating its role as a shared dependency rather than an end-user executable object. The internal flag VERT_INSTALL governs delegation: when it is true, the Grants implementation is invoked; when it is false, the wrapper returns a neutral result so that Projects functionality proceeds without Grants semantics. This design allows a single Projects code line to serve both non-Grants and Grants-enabled installations.

Key Procedures and Functions

The documented program units number nineteen, spanning installation checks, adjustment authorization, transaction processing, and award resolution. Notable units include:

• VERT_INSTALL — reports whether the vertical (Grants) application is installed, driving the conditional delegation used throughout the package.
• VERT_ALLOW_ADJUSTMENTS and VERT_ALLOW_ACTION — determine whether adjustments or other actions are permitted for a given expenditure item or context.
• VERT_TRANSFER, VERT_ADJUST_ITEMS, VERT_SI_ADJ, VERT_PAAP_SI_ADJUSTMENTS, and VERT_TRX_INTERFACE — support adjustment processing and transaction interface handling on behalf of Grants.
• VERT_APP_VALIDATE — performs validation of the application or transaction context before a vertical action proceeds.
• IS_SPONSORED_PROJECT — identifies whether a project is sponsored, a key discriminator for applying Grants rules.
• VERT_GET_AWARD_ID, VERT_GET_EI_AWARD_ID, VERT_GET_SRC_DEST_AWARD_ID, VERT_GET_AWARD_NUMBER, and VERT_EI_AWD_EQUALS_SRC_AWD — resolve award identifiers and numbers from the expenditure item, source, or destination context, and compare award associations.
• VERT_SET_ADJUST_ACTION, VERT_SET_PROJECT_ID, and VERT_SET_AWARD_ID — set internal state used by subsequent processing.
• VERT_IS_AWARD_WITHIN_RANGE — evaluates whether an award falls within a defined range, supporting eligibility and validation logic.

The user search term vert_get_award_id corresponds directly to VERT_GET_AWARD_ID, the function used to derive the award identifier associated with a Projects transaction.

Tables Accessed

The package accesses two documented tables through APPS synonyms. GMS_AWARDS_ALL is the Grants award master, consulted to resolve and validate award identifiers and numbers referenced by the VERT_GET_* and range-checking functions. PA_EXPENDITURE_ITEMS_ALL is the Projects expenditure item table, used to associate a given expenditure item with its award and to evaluate adjustment eligibility for that item.

Usage Notes

PA_GMS_API is not normally invoked by end users. It is called internally by Oracle Projects forms, concurrent programs, and transaction-processing packages whenever an adjustment, transfer, or interface action requires a Grants decision. Because the package is referenced by ten other packages, any alteration to its signatures or behavior can have wide-reaching effects across the Projects and Grants integration surface. Customizations should therefore avoid modifying the package directly and instead rely on the documented interfaces, particularly VERT_GET_AWARD_ID when award resolution is required in extension code.