Search Results gms_utility




Overview
Explore in AI Chat

Overview

GMS_UTILITY is a utility package body in the APPS schema that supports the Oracle Grants Management (GMS) module within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its documented role is to provide shared helper logic used by the Grants Management billing and award processing infrastructure, particularly around the creation and management of billing packets. Billing packets (BC packets) are the internal constructs that group eligible award expenditures so they can be processed into invoices and routed through the Grants accounting cycle. GMS_UTILITY centralizes low-level routines that other Grants components call rather than duplicate. The package is classified as OTHER in the ETRM API registry, meaning it is an internal implementation utility rather than a formally published or supported public API. Its status is VALID, confirming the compiled package body exists and resolves cleanly against the referenced objects in the documented environment.

Key Procedures and Functions

The ETRM metadata documents four callable units within GMS_UTILITY. Parameter lists are not published in the reference material and are therefore deliberately not reproduced here; only their documented names and purposes are described.

  • GET_AWARD_NUMBER — A retrieval routine that returns the award number associated with a given Grants processing context. It allows dependent code to resolve the award identifier without embedding its own lookup logic against award tables.
  • GMS_UTIL_FCK — A Grants utility function whose naming follows the module's "UTIL_" convention. It is an internal helper invoked during billing packet or award processing; the metadata does not expose a formal parameter signature, and it should be treated as an implementation detail.
  • GMS_UTIL_PC_FCK — A parallel helper to GMS_UTIL_FCK, distinguished by the "PC" qualifier, suggesting a variant used in a specific processing context within the same utility family.
  • GMS_UTIL_GL_RETURN_CODE — A routine that handles or returns a General Ledger return code, supporting the hand-off of Grants accounting results into the GL interface. This is consistent with the package body's direct references to GL_BC_PACKETS.

Tables Accessed

The compiled package body references three application tables through APPS synonyms, plus standard Oracle infrastructure objects.

  • GL_BC_PACKETS — The General Ledger billing packet table, used to read or maintain packet records that will be posted or interfaced into GL.
  • GMS_BC_PACKETS — The Grants Management billing packet table, the core container of award billing data processed by the utility routines.
  • GMS_BC_PACKET_ARRIVAL_ORDER — A table that defines the arrival or sequencing order of billing packets, referenced to control processing sequence.
  • DBMS_SQL and DUAL — Oracle-supplied objects; DBMS_SQL indicates the package performs dynamic SQL, while DUAL supports scalar expression evaluation.

The package also depends on FND_INSTALLATION, the Applications installation registry, which is commonly used to detect product installation or patch level before executing feature-dependent logic.

Usage Notes

GMS_UTILITY is an internal utility and is not referenced by any other database object according to the ETRM dependency report, which indicates it is invoked at runtime rather than through static package-level dependencies. In practice, such utilities are called from Grants Management concurrent programs, from Grants forms, or from other Grants PL/SQL code executed during billing generation and award processing. Because it is classified as OTHER and is not a published API, customizations should not call it directly; any dependency on GMS_UTIL_FCK, GMS_UTIL_PC_FCK, GMS_UTIL_GL_RETURN_CODE, or GET_AWARD_NUMBER is unsupported and may break on patching. Developers who encounter this package during debugging should trace it as part of the standard Grants billing packet lifecycle rather than as an entry point.