Search Results consolidation_ledger_flag_p

Overview

GL_GLYRLJGE_XMLP_PKG is the generated PL/SQL package that supports the Oracle General Ledger XML Publisher (BI Publisher) report commonly identified as the "Journals - General Ledger" or "YRL/JGE" journal listing program. The package name follows the Oracle XML Publisher report package naming convention, where _XMLP_PKG designates the PL/SQL package automatically generated from a report definition template. It encapsulates the data retrieval, formatting, and conditional display logic required to produce the journal entries listing output in Oracle E-Business Suite 12.1.1 and 12.2.2.

Functionally, the package serves the General Ledger reporting layer by accepting report parameters, deriving internal date and where-clause values, resolving ledger and access-set context, and formatting currency, entry, and indicator columns for presentation. The parameter consolidation_ledger_flag_p referenced by the user corresponds to the internal switch CONSOLIDATION_LEDGER_FLAG (initialized to 'S'), which governs whether the report operates against a standard or consolidation ledger. This flag influences the ledger type and currency determination used throughout the report, distinguishing ledgers whose journal entries are consolidated from primary ledgers.

Key Procedures and Functions

The package exposes 36 documented program units. The principal report lifecycle functions are BeforeReport and AfterReport, which initialize report-level variables and clean up after execution. Formatting and derived-value functions include c_curr_nameformula, c_bal_lpromptformula, c_entryformula, c_messageformula, and zero_indicatorformula, all of which compute display strings for specific report columns. The functions set_display_for_core and set_display_for_gov toggle display behavior between the core (commercial) and government (Federal) editions of the report, while get_industry_code derives the industry context consumed by those switches.

Data-filtering functions include g_journalgroupfilter, g_company_mastergroupfilter, g_journal_entriesgroupfilter, and g_batchesgroupfilter, which apply security and selection predicates to the journal, batch, and company master groups. Helper functions c_where_p, c_chart_of_accts_id_p, c_start_date_p, company_lprompt_ndformula, betweenpage, and gl_format_currency resolve where-clause fragments, chart-of-accounts identifiers, date parameters, company prompts, page breaks, and currency masks. The consolidation_ledger_flag_p parameter is consumed within these internal routines to determine ledger type and related formatting decisions.

Tables Accessed

The package reads from the following APPS synonyms: GL_ACCESS_SETS, to resolve access-set name and security where-clause (C_ACCESS_SET_NAME, C_ACCESS_WHERE); GL_LEDGERS, to obtain ledger name, ledger type, and currency for the selected ledger and the consolidation flag logic; GL_PERIODS, to derive period start and end dates (C_START_DATE, C_END_DATE) and validate the period range; GL_SYSTEM_USAGES, to determine the industry/application context used by get_industry_code; and DUAL, for singleton value computations. These accesses are read-oriented and support parameter derivation and report filtering rather than data modification.

Usage Notes

This package is invoked indirectly by the Oracle XML Publisher concurrent program/request that executes the associated journal report. It is not intended for direct invocation from forms or custom code. Administrators and technical consultants interact with it primarily during report output diagnosis, when report parameters such as consolidation_ledger_flag_p require tracing, or when extending the underlying XML template. The ETRM metadata records zero packages referencing it, confirming its role as a terminal report-support package. Customization should be avoided because the package is regenerated whenever the report definition is recompiled.