Search Results flex_nodata_select_bal




Overview
Explore in AI Chat

Overview

APPS.GL_GLXACDAL_XMLP_PKG is the generated PL/SQL package body that backs the Oracle XML Publisher (BI Publisher) report definition for the General Ledger account data extraction program (source file GLXACDALB.pls, header revision 120.0 dated 2007/12/27). The package follows the standard Oracle Reports-to-XML-Publisher conversion pattern, in which report-level placeholders (lexical parameters and bind substitutions) are exposed to the data template through wrapper functions, and report lifecycle events are implemented as BeforeReport and AfterReport entry points.

Its business purpose is to support extraction of General Ledger account and balance information across a specified Accounting Key Flexfield structure, returning rows selected and ordered according to user-supplied segment criteria. In Oracle EBS 12.1.1 and 12.2.2 the package is deployed in the APPS schema and is classified in ETRM as OTHER, reflecting that it is an internal report-support package rather than a published public API.

Key Procedures and Functions

  • BeforeReport — Report initialization function returning a boolean. It resolves the chart of accounts name by calling gl_flexfields_pkg.get_coa_name with the report parameter P_STRUCT_NUM, assigning the result to the COA_NAME placeholder. If no row is found, it retrieves the message GL_PLL_ROUTINE_ERROR from gl_message.get_message and raises application error -20101, aborting the report.
  • AfterReport — Report termination function returning a boolean. Retained for lifecycle symmetry; the legacy SRW exit call is commented out in the converted source.
  • FLEX_SELECT_ALL_p — Returns the FLEX_SELECT_ALL placeholder value, exposing the SELECT clause fragment for the flexfield segments to the report data template.
  • FLEX_WHERE_ALL_p — Returns the FLEX_WHERE_ALL placeholder, providing the WHERE clause fragment constructed from the low/high segment ranges.
  • FLEX_ORDERBY_ALL_p — Returns the FLEX_ORDERBY_ALL placeholder, supplying the ORDER BY fragment that determines reporting sequence.
  • FLEX_NODATA_SELECT_BAL_p — Returns the FLEX_NODATA_SELECT_BAL placeholder. This is the function retrieved by the search term "flex_nodata_select_bal_p" and exposes the selection clause variant used when no segment data is supplied for balance retrieval, allowing the report to execute a default balance query.
  • COA_NAME_p — Returns the resolved COA_NAME value populated during BeforeReport.

Tables Accessed

ETRM metadata lists no direct table references for this package. All data access occurs indirectly: the flexfield placeholder functions return SQL fragments that are assembled and executed by the XML Publisher data engine, and the chart of accounts lookup is performed through gl_flexfields_pkg against the Applications key flexfield definition rather than through direct DML. The package itself performs no inserts, updates, or deletes.

Usage Notes

The package is invoked by the XML Publisher concurrent program associated with the GL account data report; it is not intended for direct invocation from forms or custom code. Customizations should target the report data template and the underlying gl_flexfields_pkg API rather than the generated wrapper bodies, because regenerating or upgrading the report will overwrite modifications to this package. As no other packages reference it, its dependency surface is limited to the flexfield and message utilities it calls during initialization.