Search Results select_acct_p

Overview

APPS.GL_GLXBTB_XMLP_PKG is the generated PL/SQL package that backs the Oracle General Ledger "Budget Trial Balance" XML Publisher (BI Publisher) concurrent program report, internally identified as GLXBTB. In Oracle EBS 12.1.1 and 12.2.2 the report produces a period-by-period comparison of budget versus actual account balances, translated across ledger and entered currencies, and rendered through an XML Publisher template driven by a data definition and an after-report XSL/RTF layout. The package is generated by the Oracle Reports-to-XML Publisher migration utility and carries the characteristic structure of that generator: a public package specification of global variables bound to the report parameters, and a set of formula functions (identifiable by the FORMULA suffix or the _P naming convention) whose return values are substituted into the report's data model SQL at runtime.

The package resolves ledger context (P_LEDGER_ID, P_LEDGER_CURRENCY, P_ACCESS_SET_ID, ACCESS_SET_NAME), period range (P_FROM_PERIOD_NAME, P_TO_PERIOD_NAME), the budget version identifier (P_BUDGET_VERSION_ID, exposed through BUDGET_NAMEFORMULA), and currency handling (P_CURRENCY_TYPE with P_ENTERED_CURRENCY). Its central design feature is the use of dynamic Account Structure definitions: the STRUCT_NUM global defaults to '50105', and the SELECT_* and ORDERBY_* globals assemble concatenated segment string expressions and ORDER BY clauses that adapt to whether the selected structure uses a balancing or a full accounting flexfield layout.

Key Procedures and Functions

The package exposes 21 documented program units, most of which are XML Publisher "formula" functions returning SQL fragments or display values:

• BEFOREREPORT / AFTERREPORT — standard XML Publisher package hooks that initialize session state and clean up after the report completes.
• SELECT_ACCT_P — returns the SELECT_ACCT expression used to build the account display column; this is the element the user searched for as "select_acct_p". The default expression concatenates the balancing segment and the cost centre segment (segments 11 and 12 in the shipped default) into a multi-line account label.
• SELECT_BAL_P, SELECT_ALL_P — return the SELECT_BAL and SELECT_ALL SQL fragments for balancing-only and full thirty-segment account concatenation respectively.
• ORDERBY_BAL_P, ORDERBY_ACCT_P, ORDERBY_ALL_P — return the ORDER BY clauses corresponding to the balancing, account, and full-segment orderings.
• TRANS_CHECK_BB_P, TRANS_CHECK_BE_P — return the translated-flag predicates that distinguish beginning balances (bb) from ending balances (be), including the outer-join NVL default of 'R'.
• WHERE_DAS_P — returns the WHERE clause fragment used by the Data Access Set driven query.
• PERIOD_ACT_BALFORMULA, BUDGET_NAMEFORMULA, LEDGER_NAMEFORMULA, DISP_BAL_LPROMPT_W_COLONFORMUL — presentation formulas supplying the period activity/balance column heading, the budget version name, the ledger name, and a colon-suffixed balance prompt to the report layout.
• STRUCT_NUM_P, ACCESS_SET_NAME_P — accessors for the account structure number and access set name globals.
• G_BALANCESGROUPFILTER, G_PAGE_BREAKGROUPFILTER, G_ACCT_DATAGROUPFILTER — grouping filter logic applied to the XML data template for the balances, page break, and account data groups.

Tables Accessed

The package references two documented base objects through APPS synonyms:

• GL_ACCESS_SETS — queried to validate and resolve the Data Access Set identified by P_ACCESS_SET_ID and to populate ACCESS_SET_NAME, thereby enforcing ledger and data-access security on the report output.
• GL_LEDGER_RELATIONSHIPS — queried to derive the ledger hierarchy used when the report is run with a Data Access Set spanning parent and child ledgers, so that balances from related ledgers are aggregated correctly.

Balance and budget figures themselves are drawn from the GL balances and budget views referenced by the report's data template rather than by named tables within this package.

Usage Notes

GL_GLXBTB_XMLP_PKG is not intended for direct invocation by custom code. It is instantiated by the XML Publisher engine when the "Budget Trial Balance" concurrent program is submitted, with the concurrent request ID, ledger, access set, budget version, period range, and currency type passed into the package globals. The formula functions are called from the data template and RTF/XSL layout during report generation, and the before/after report hooks bracket the run. Because the package name carries the _XMLP_PKG suffix and the header shows a version of 120.0 with an "noship" designation, it is regenerated whenever the underlying report definition is re-migrated; customization should therefore be applied to a copy or through the template, not to the generated package body. No other packages reference this package, confirming its role as a terminal, report-specific artifact.