Search Results thousands_separator

Overview

APPS.GL_GLXETB_XMLP_PKG is the database-side PL/SQL package body that backs the Oracle General Ledger XML Publisher report GLXETB. Its name follows the standard EBS concurrent program/XML Publisher naming convention, in which a report definition (for example GLXETB) is bound to a generated package (GL_GLXETB_XMLP_PKG) that supplies report-level formulas, grouping filters, column formatting logic, lexical parameters, and pre/post-processing hooks. The package is classified as OTHER in the ETRM repository, meaning it is a supporting report component rather than a public-API package. Its principal business function is to produce an enhanced trial balance or account balances style ledger report scoped by an access set, resolving the access set name and chart of accounts identifier, applying data access security to the ledger dimension, and computing derived balances and currency display values for the XML template.

Key Procedures and Functions

The documented interface comprises 26 procedures and functions, most of which exist to satisfy XML Publisher report triggers or to return SQL fragments and grouping values to the report definition.

• ENCUMBRANCE_TYPEFORMULA resolves an encumbrance type name from the encumbrance type identifier parameter, delegating to the GL_INFO utility and raising an application error when the lookup fails.
• BeforeReport initializes the report: it queries GL_ACCESS_SETS to populate ACCESS_SET_NAME and STRUCT_NUM, and builds WHERE_DAS by calling GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE. AfterReport provides the corresponding report completion hook.
• END_BALFORMULA computes an ending balance as beginning balance plus debits minus credits.
• GL_FORMAT_CURRENCY formats monetary amounts for display, and is the routine most closely associated with the user term "thousands_separator," since currency and number formatting in these reports controls how digit group separators are presented in the output.
• The G_*GROUPFILTER functions (G_PAGE_BREAKGROUPFILTER, G_ACCT_DATAGROUPFILTER, G_BALANCESGROUPFILTER) act as XML Publisher group filters that suppress repeated group headers.
• The *_P functions and procedures (STRUCT_NUM_P, SELECT_BAL_P, SELECT_ALL_P, SELECT_ACCT_P, ORDERBY_BAL_P, ORDERBY_ACCT_P, ORDERBY_ALL_P, ORDERBY_BAL2_P, ORDERBY_ACCT2_P, ACCESS_SET_NAME_P, WHERE_DAS_P, PARAM_LEDGER_CURR_P) are lexical/reference helpers that return select lists, order-by clauses, and parameter values to the report query.

Tables Accessed

The package references three objects through APPS synonyms. GL_ACCESS_SETS is read in BeforeReport to translate the access set identifier parameter into the access set name and the associated chart of accounts identifier, and it underpins the security clause used to restrict report rows. GL_LEDGERS is referenced to support ledger and ledger currency parameter resolution, notably through PARAM_LEDGER_CURR_P. DUAL is used for scalar evaluations and parameter defaults. All access is read-only; the package does not write application data.

Usage Notes

GL_GLXETB_XMLP_PKG is invoked implicitly by the XML Publisher engine whenever the GLXETB concurrent program or its report definition is run from the Submit Requests form or the standard concurrent manager. It is not referenced by any other package, so it has no programmatic dependents and should not be treated as a callable API. Customizations should be limited to the XML template or to a cloned package, because the body is a generated report component shipped under the APPS schema. The header comment indicates a 2007 revision, so behavior is consistent across EBS 12.1.1 and 12.2.2, with any differences attributable to the online patching editioning applied to APPS objects in 12.2.