Search Results gl_get_lookup_value

Overview

APPS.GL_INFO is a utility PL/SQL package in Oracle E-Business Suite General Ledger. It supplies shared lookup and metadata retrieval services used by other General Ledger APIs, forms, and concurrent programs. Rather than performing transaction processing itself, the package resolves reference information: it translates identifiers into human-readable names, resolves ledger and chart-of-accounts attributes, returns period boundary dates, and exposes lookup meanings. Because these values are required by a wide range of GL integration points, GL_INFO acts as a centralized, reusable access layer over the core GL tables. The ETRM metadata classifies the package as API classification OTHER and records 7 documented procedures and functions, and the package is referenced by 36 other packages, confirming its role as a foundational dependency within the GL codebase.

Key Procedures and Functions

• GL_GET_PERIOD_DATES — Returns the start and end dates for a ledger and period name, with an error buffer for diagnostic output.
• GL_GET_LEDGER_INFO — Returns the chart-of-accounts ID, the ledger name, and the functional currency for a supplied ledger ID.
• GL_GET_BUD_OR_ENC_NAME — Given an actual type (Actual, Budget, or Encumbrance) and a budget version ID or encumbrance type ID, returns the corresponding budget name or encumbrance type name, or null for Actual.
• GL_GET_LOOKUP_VALUE — Returns the meaning or description of a lookup code for a specified lookup type, based on the requested mode.
• GL_GET_FIRST_PERIOD — Returns the first period associated with a ledger, providing the starting accounting period for downstream processing.
• GL_GET_FIRST_PERIOD_OF_QUARTER — Returns the first period of a quarter for a given ledger, supporting quarterly reporting and period selection logic.
• GL_GET_CONSOLIDATION_INFO — Returns consolidation-related information mapped to the consolidation definition, supporting GL consolidation processing and reporting.

Tables Accessed

The package reads from several core GL tables through APPS synonyms. GL_LEDGERS supplies ledger name, chart of accounts, and functional currency used by GL_GET_LEDGER_INFO and the period retrieval routines. GL_PERIOD_STATUSES provides the period definitions and calendar boundaries used by GL_GET_PERIOD_DATES and the first-period functions. GL_BUDGET_VERSIONS is read by GL_GET_BUD_OR_ENC_NAME to resolve budget version IDs to budget names, and GL_ENCUMBRANCE_TYPES supplies encumbrance type names for the same routine. GL_CONSOLIDATION is accessed by GL_GET_CONSOLIDATION_INFO to return consolidation definition details. Lookup values used by GL_GET_LOOKUP_VALUE are sourced from the standard lookup views. The package is principally read-only against these tables.

Usage Notes

GL_INFO is most commonly invoked from custom PL/SQL, Oracle Forms, and concurrent programs that need to resolve GL reference data without duplicating lookup logic. Typical uses include validating a period name and returning its date range, converting a ledger ID into a display name for reports, and resolving budget or encumbrance identifiers before posting or querying balances. The caller searching for gl_get_first_period is generally seeking the entry point that identifies the earliest open period for a ledger, which is useful when seeding period ranges in custom interfaces. When calling these routines, custom code should supply a sufficiently sized VARCHAR2 error buffer and check its contents for failures, since the procedures return status through OUT parameters rather than raising exceptions. Because the package is referenced by 36 other packages, changes to its behavior should be treated as potentially wide-reaching within the GL application.