Search Results gl_get_ledger_info

Overview

APPS.GL_GLXRLTCL_XMLP_PKG is the supporting PL/SQL package body for the Oracle General Ledger XML Publisher concurrent report GLXRLTCL (commonly the "Ledger/Translation" or Chart of Accounts listing report). It is an "OTHER"-classified package rather than a formal public API, meaning it is not intended as a callable integration interface; instead it supplies the server-side logic that the report's data template and XML Publisher definition depend upon. Its header comment identifies it as a General Ledger module file (GLXRLTCLB.pls) last revised in December 2007, placing it in the heritage of Oracle Reports-to-XML Publisher conversions in Release 12.

The package's central responsibility is validating and resolving General Ledger accounting flexfield context before the report executes. In particular, it resolves the ledger (set of books), the chart of accounts structure, and the natural account value set from a single input parameter, P_SET_OF_BOOKS_ID, so that the query layer can filter correctly. The search term "gl_get_ledger_info" refers directly to one of this package's documented functions, which performs that ledger resolution and returns the chart of accounts identifier, ledger name, and functional currency.

Key Procedures and Functions

• BEFOREREPORT — Fires before the report is rendered. It captures the concurrent request ID via FND_GLOBAL, calls GL_GET_LEDGER_INFO to resolve ledger context, populates the package-level STRUCT_NUM and SET_OF_BOOKS_NAME globals, and then queries the flexfield metadata tables to derive the natural account segment column and its value set ID. Errors are routed through GET_MESSAGE rather than halting with a raw exception.
• AFTERREPORT — Cleanup handler invoked after report completion; returns control to the report framework.
• GL_GET_LEDGER_INFO — The function named in the user's search. Resolves the ledger details for the supplied set of books identifier, returning the chart of accounts ID, ledger name, and functional currency, plus an error buffer when resolution fails.
• GL_GET_PERIOD_DATES, GL_GET_FIRST_PERIOD, GL_GET_FIRST_PERIOD_OF_QUARTER — Derive accounting period boundaries used to constrain the report's data range.
• GL_GET_BUD_OR_ENC_NAME, GL_GET_CONSOLIDATION_INFO, GL_GET_LOOKUP_VALUE — Resolve budget or encumbrance names, consolidation metadata, and General Ledger lookup meanings for display.
• SET_OF_BOOKS_NAME_P, STRUCT_NUM_P, VALUE_SET_ID_P, PAGENO_P — Parameter getter functions returning the package globals to the report's data template.
• SET_LANGUAGE, GET_MESSAGE, MSG_TKN_EXPAND — FND message-stack utilities for localized error and token substitution output.

Tables Accessed

Two application tables are documented as accessed through APPS synonyms. FND_SEGMENT_ATTRIBUTE_VALUES is queried for the key flexfield structure identified by STRUCT_NUM with ID_FLEX_CODE 'GL#', selecting the application column name where the segment attribute type is GL_ACCOUNT, thereby locating the natural account segment. FND_ID_FLEX_SEGMENTS is then queried using that column name to retrieve the FLEX_VALUE_SET_ID for the enabled segment, which is stored in the VALUE_SET_ID global for the report.

Usage Notes

This package is internal to the GLXRLTCL XML Publisher concurrent program and is executed on the concurrent manager tier when that report is submitted. It is not referenced by any other documented package and exposes no supported API surface. Customizations should avoid direct invocation; instead, developers requiring ledger resolution logic should use the supported GL public APIs. Any modification to this package body risks invalidating the seeded report definition and should be avoided or handled through the standard EBS patching mechanism.