Search Results gms_awards_dist_pkg




Overview
Explore in AI Chat

Overview

GMS_AWARDS_DIST_PKG is an Oracle Application Object Library (APPS) PL/SQL package body shipped with the Oracle Grants Management (GMS) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to manage Award Distribution Lines (ADLs) — the records stored in GMS_AWARD_DISTRIBUTIONS that allocate awarded, funded, or budgeted amounts across projects, tasks, and expenditure categories for a grant award. These distributions drive encumbrance creation, billing, and cost allocation logic that flows into Oracle Projects and Oracle Payables.

The package is classified as a general-purpose data management API (API classification: OTHER) rather than a public open interface. It is marked VALID in the 12.2.2 ETRM metadata and is referenced by 20 other database objects, making it a central utility within the Grants Management schema. It is not referenced by any external database object outside APPS.

Key Procedures and Functions

The documented API exposes 11 procedures and functions:

  • GET_AWARD_SET_ID — Retrieves the award set identifier associated with an award, typically from the GMS_ADLS_AWARD_SET_ID_S sequence or lookup, and is used to key ADL records.
  • CREATE_ADLS — Creates new Award Distribution Lines for a given award, inserting rows into GMS_AWARD_DISTRIBUTIONS.
  • VERIFY_CREATE_ADLS — Validates the conditions and data required before an ADL creation attempt, returning success or raising an error through GMS_ERROR_PKG.
  • UPDATE_ADLS — Modifies existing ADL records, including amounts, percentages, and distribution attributes.
  • DELETE_ADLS — Removes ADL rows, respecting referential and business-rule constraints.
  • CLEAN_DANGLING_ADLS — Identifies and removes ADLs that are no longer linked to a valid parent award, project, or funding source.
  • COPY_ADLS — Duplicates an existing set of ADLs, commonly used when cloning award structures or templates.
  • COPY_EXP_ADLS — Copies expenditure-related ADLs, extending the copy logic to expenditure items and cost distribution lines.
  • INSSI_ITEMS — Inserts summary-installment items associated with awards, working with GMS_INSTALLMENTS and GMS_SUMMARY_PROJECT_FUNDINGS.
  • UPDATE_BILLABLE_FLAG — Updates the billable indicator on ADL records, affecting downstream billing in Oracle Projects and Payables.
  • GET_AWARD_SET_ID and related helpers — Support award-set identification for sequence generation and lookup.

Tables Accessed

The package reads and writes the following documented tables:

Usage Notes

GMS_AWARDS_DIST_PKG is typically invoked indirectly through Oracle Grants Management forms such as the Award Management and Award Distributions windows, and through concurrent programs that process award funding, encumbrance generation, and billing. Custom code should call the documented procedures (CREATE_ADLS, UPDATE_ADLS, DELETE_ADLS, COPY_ADLS, COPY_EXP_ADLS, CLEAN_DANGLING_ADLS, INSSI_ITEMS, UPDATE_BILLABLE_FLAG, VERIFY_CREATE_ADLS, GET_AWARD_SET_ID) rather than modifying GMS_AWARD_DISTRIBUTIONS directly, because the package enforces validation rules, raises messages via FND_MESSAGE and APP_EXCEPTION, and logs errors through GMS_ERROR_PKG. Because error handling and validation are embedded in the package, any bypass of the API risks dangling ADLs, incorrect billable flags, and downstream encumbrance or billing mismatches. Upgrade testing between 12.1.1 and 12.2.2 should verify any custom calls against the maintained metadata, since the package remains VALID across both releases.