Search Results jg_get_lookup_value

Overview

JG_INFO is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, shipped as part of the Global Accounting Engine (JG) product family. Its primary business function is to serve as a central utility library that supplies descriptive and contextual information about the General Ledger environment to Global Accounting Engine reports, concurrent programs, and dependent packages. Rather than performing transactional posting itself, JG_INFO acts as a metadata and lookup provider, resolving set of books context, budget and encumbrance nomenclature, lookup values, accounting period boundaries, and currency formatting on behalf of its callers.

The package status is VALID across EBS 12.1.1 and 12.2.2. Its contents comprise a package specification and package body, with six documented procedures and functions. It is referenced by six other packages in the APPS schema, most of which are XML Publisher report logic packages (JE_JENOGEIA_XMLP_PKG, JE_JENOGEIM_XMLP_PKG, JE_JENOGEIS_XMLP_PKG, JG_JGZZARIN_XMLP_PKG, JG_JGZZRCAK_XMLP_PKG and JG_JGZZRDLR_XMLP_PKG), plus JG_INFO itself. This dependency footprint confirms the package is a shared reporting utility rather than an end-user application component.

Key Procedures and Functions

The documented public interface consists of six procedures and functions:

• JG_GET_SET_OF_BOOKS_INFO — Returns descriptive information about a set of books (ledger), allowing reporting logic to resolve ledger-level attributes without querying GL tables directly.
• JG_GET_BUD_OR_ENC_NAME — Retrieves the name of a budget or an encumbrance type, enabling reports to display user-friendly labels for budget versions and encumbrance categories.
• JG_GET_LOOKUP_VALUE — Resolves a value from an Oracle Applications lookup type, providing code-to-meaning conversion for report output.
• JG_GET_FIRST_PERIOD — Returns the first accounting period in a given range, typically the opening period for a reporting window.
• JG_GET_FIRST_PERIOD_OF_QUARTER — Returns the first accounting period of a specified quarter, supporting quarterly statutory and management reporting.
• JG_FORMAT_CURR_AMT — Formats a currency amount for presentation, applying the appropriate precision and display conventions to monetary values used in Global Accounting Engine output.

Tables Accessed

JG_INFO reads from four General Ledger tables, exposed through APPS synonyms:

• GL_BUDGET_VERSIONS — Source of budget version names used by JG_GET_BUD_OR_ENC_NAME.
• GL_ENCUMBRANCE_TYPES — Source of encumbrance type names for the same lookup function.
• GL_PERIOD_STATUSES — Drives JG_GET_FIRST_PERIOD and JG_GET_FIRST_PERIOD_OF_QUARTER, supplying period naming and calendar context.
• GL_CONSOLIDATION — Provides consolidation-related mapping data referenced when resolving set of books information.

All accesses are read-only in nature, consistent with the package's role as an information provider.

Usage Notes

JG_INFO is not intended for direct invocation by end users. It is called internally by Global Accounting Engine and Journal Entry XML Publisher report packages that require consistent ledger context, period resolution, and amount formatting. Typical invocations occur during concurrent program execution of those reports, where the report logic package calls JG_INFO functions to populate report parameters and formatted output columns. Customizations and extensions that mimic standard Global Accounting Engine reporting should call these same functions rather than re-implementing ledger lookups, ensuring consistent behavior across 12.1.1 and 12.2.2. Because JG_INFO is a dependency of six packages, modifications to its specification can cascade widely, so any extension should be additive and validated against the full dependency list.