Search Results gms_encumbrance_items_pkg




Overview
Explore in AI Chat

Overview

GMS_ENCUMBRANCE_ITEMS_PKG is an Oracle Applications (APPS) PL/SQL package body that encapsulates the data manipulation logic for grant encumbrance line items within the Oracle Grants Management (GMS) module. Encumbrance items represent the funding commitments and obligations recorded against sponsored awards, projects, and tasks. The package provides the core insert, update, delete, and locking routines used to maintain the GMS_ENCUMBRANCE_ITEMS entity, shielding callers from direct DML against the underlying tables. Its object type is PACKAGE BODY, owned by APPS, and it carries a VALID status in the ETRM 12.2.2 metadata extract. The API classification is OTHER, indicating it is an internal supporting package rather than a formally published public API. This package is foundational to maintaining referential integrity between encumbrance header rows and their associated line items, and it sits within a broader dependency chain that includes grants, projects, and adjustments functionality.

Key Procedures and Functions

The documented package exposes four procedures, corresponding to the standard table-handler pattern used throughout the E-Business Suite:

  • INSERT_ROW — Creates a new encumbrance item record, populating the primary and foreign key columns and mapping caller-supplied attribute values into the target table columns.
  • UPDATE_ROW — Modifies the attributes of an existing encumbrance item, applying changed values while preserving the row's identifying keys.
  • DELETE_ROW — Removes an encumbrance item row, typically the line-level counterpart to a parent encumbrance header, supporting reversal or correction scenarios.
  • LOCK_ROW — Acquires a row-level lock on an encumbrance item, ensuring serialized access during concurrent modification so that dependent updates do not conflict.

The metadata extract lists five documented procedures or functions in total; INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW are the named routines, with the remaining entry associated with the package's internal handler logic. Parameter lists are intentionally omitted from this summary, as they are not present in the ETRM extract.

Tables Accessed

The package references several objects through APPS synonyms, establishing its position in the grants data model:

  • GMS_ENCUMBRANCE_ITEMS — The base table that stores the encumbrance item records this package inserts, updates, deletes, and locks.
  • GMS_ENCUMBRANCE_ITEMS_S — The sequence object used to generate unique primary keys for new encumbrance item rows. This is the object most closely matching the user's search term and explains why queries for the "_S" sequence frequently surface this package.
  • PA_TASKS — The Projects task table, referenced to validate task associations for encumbrance items.
  • PA_ADJUSTMENTS — Referenced by package dependencies, supporting adjustment processing associated with project encumbrances.
  • DUAL and STANDARD — SYS-supplied objects used for internal control-flow and standard package behavior.

Usage Notes

GMS_ENCUMBRANCE_ITEMS_PKG is invoked indirectly by higher-level grants and projects functionality—such as grant encumbrance entry forms, concurrent programs that process or reverse encumbrances, and dependent packages in the grants suite. The ETRM extract records that this package is referenced by three other database objects and does not itself reference any further application package beyond its sibling GMS_ENCUMBRANCE_ITEMS_PKG and PA_ADJUSTMENTS. Because it is classified as OTHER rather than a public API, customizations should generally not call these routines directly; instead, developers should route through the supported public interfaces so that validation and integration logic is preserved. The package is valid in both EBS 12.1.1 and 12.2.2 environments, with no notable divergence reported in the dependency footprint.