Search Results gl_glxacdal_xmlp_pkg

Overview

APPS.GL_GLXACDAL_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema whose name follows the standard Oracle Reports XML Publisher (XMLP) integration naming convention. The "XMLP_PKG" suffix identifies it as the generated database-side support package that accompanies an Oracle Reports executable converted for XML Publisher output. The "GLXACDAL" token indicates its affiliation with the Oracle General Ledger product family, and the package is documented in ETRM as VALID in both EBS 12.1.1 and 12.2.2. Its business function is to supply the runtime data parameters, flexfield-aware selection logic, and report lifecycle hooks required by the associated General Ledger concurrent report program.

Key Procedures and Functions

Seven documented entry points make up the package interface, combining Oracle Reports trigger hooks with Chart of Accounts flexfield utilities:

• BEFOREREPORT — Executes the pre-report initialization logic, typically populating package-level variables and defaulting parameters before the report query is constructed.
• AFTERREPORT — Runs post-processing logic after the report completes, commonly used to reset package state.
• FLEX_SELECT_ALL_P — Generates the SELECT list fragment used to project key flexfield segment columns in the report query.
• FLEX_WHERE_ALL_P — Builds the WHERE clause fragment that filters report data against the selected key flexfield segment values.
• FLEX_ORDERBY_ALL_P — Produces the ORDER BY fragment that sorts report output by flexfield segments.
• FLEX_NODATA_SELECT_BAL_P — Generates a SELECT fragment for balance-related columns when no detail data rows are returned, supporting zero-balance or empty-result rendering.
• COA_NAME_P — Resolves and returns the Chart of Accounts name associated with the reporting context.

These procedures collectively implement the flexfield-aware query assembly pattern used throughout General Ledger reports, allowing a single report definition to adapt to different Chart of Accounts structures. Per the ETRM metadata, no parameter lists are documented, so the signatures should be confirmed against the live package specification before direct invocation.

Tables Accessed

The ETRM metadata documents no direct table references through APPS synonyms for this package. This is consistent with XMLP report support packages, which typically construct dynamic SQL text returned to the parent Oracle Reports executable rather than issuing DML directly. The flexfield helper procedures operate on the Accounting Key Flexfield structures conceptually, and the report query ultimately reads General Ledger balances and account data, but the package itself does not appear as a direct table consumer. Dependency documentation identifies only SYS.STANDARD as a referenced object, reinforcing that its outward dependencies are minimal and confined to the standard PL/SQL environment.

Usage Notes

This package is not intended for direct invocation by end users or custom code. It is referenced by the General Ledger concurrent program associated with the GLXACDAL report, which drives the BEFOREREPORT hook at submission time and the AFTERREPORT hook at completion. The dependency section confirms the package references SYS.STANDARD and is referenced only by itself within the APPS schema, with zero other packages depending on it. Consequently, modification or recompilation should be treated as a report-level change and governed accordingly. ETRM classifies the object as API classification OTHER, meaning it carries no public API guarantee. Any customization should be limited to wrapping or calling the documented procedures from a custom package, and the package should be recompiled after upgrades in 12.1.1 or 12.2.2 to ensure the generated XMLP support code remains valid.