Search Results orderby_all_p

Overview

GL_GLXETB_XMLP_PKG is the Oracle E-Business Suite 12.1.1 / 12.2.2 server-side PL/SQL package that backs the General Ledger XML Publisher report commonly identified as the GLXETB (Encumbrance Trial Balance) concurrent program. Declared with AUTHID CURRENT_USER, the package executes under the privileges of the calling APPS schema and is registered with an API classification of OTHER, meaning Oracle does not expose it as a formally published API but does install and document it as an internal report driver.

Functionally, the package supplies the runtime plumbing for the report's XML Publisher template: it declares the concurrent request parameters, constructs the dynamic SELECT and ORDER BY fragments used to build the account segment display, formats currency output, and governs report-level grouping and page breaking. It exists solely to support that single report; the metadata records zero dependent packages that call it.

Key Procedures and Functions

The 26 documented program units divide cleanly into three categories. Report lifecycle units — BEFOREREPORT and AFTERREPORT — handle initialization (parameter retrieval, defaults) and post-processing cleanup before and after the XML output is produced. One unit, ENCUMBRANCE_TYPEFORMULA, is the most directly relevant to the user's search term: this is the report formula that derives the encumbrance type value displayed on the output, driven by the package-level variable P_ENCUMBRANCE_TYPE_ID.

A second group consists of the packaged getters and setters for the report's global variables. These include STRUCT_NUM_P, SELECT_BAL_P, SELECT_ALL_P, ORDERBY_BAL_P, ORDERBY_ACCT_P, ORDERBY_ALL_P, SELECT_ACCT_P, ORDERBY_BAL2_P, ORDERBY_ACCT2_P, and ACCESS_SET_NAME_P. Each exposes a package-level constant or variable — for example, the SELECT_ALL fragment concatenating cc.segment1 through cc.segment30, or the balanced order-by defaulting to cc.segment11.

A third group contains report logic helpers: END_BALFORMULA (the closing balance computation), GL_FORMAT_CURRENCY (currency formatting for the template), WHERE_DAS_P and PARAM_LEDGER_CURR_P (dependent access set and ledger currency parameters), and the group filter functions G_PAGE_BREAKGROUPFILTER, G_ACCT_DATAGROUPFILTER, and G_BALANCESGROUPFILTER, which control page breaks and grouping in the XML Publisher data model.

Tables Accessed

The package references three objects through APPS synonyms. GL_ACCESS_SETS supplies the Access Set ID and Access Set Name used to restrict the report to the appropriate data access set. GL_LEDGERS provides ledger identification and ledger currency, supporting the PARAM_LEDGER_CURR_P logic. DUAL is used for single-row lookups and parameter derivations. The account combinations and balances themselves are read by the underlying report SQL rather than by this package directly.

Usage Notes

GL_GLXETB_XMLP_PKG is invoked exclusively by the GLXETB concurrent program when a user submits the Encumbrance Trial Balance report from the Submit Request window or from a report scheduling tool. Setting the request's encumbrance type parameter causes ENCUMBRANCE_TYPEFORMULA and the related P_ENCUMBRANCE_TYPE_ID variable to resolve the encumbrance type shown on the output. Customers should not call this package from custom code; use the Standard Request Submission interface or the GL_ACCESS_SETS and GL_LEDGERS views directly for bespoke encumbrance reporting.