Search Results sel_flexdata




Overview
Explore in AI Chat

Overview

GL_GLXRLMAB_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program associated with the GLXRLMAB report in the General Ledger module. The package name itself follows the standard EBS naming convention for XML Publisher report packages: the "XMLP_PKG" suffix identifies a package automatically produced by the XML Publisher report definition generator ("Oracle Report to XML Publisher" conversion), and the "GL_" prefix identifies General Ledger as the owning product. The report itself is a General Ledger listing structured around the Accounting Flexfield ("GLLE" key flexfield), and the package exists to supply report-level initialization logic, formula functions, and accessor functions (placeholders) that the underlying report definition references at runtime.

The three-character source header ("GLXRLMABB.pls") and the Version 120.0 registry stamp dated 2007/12/27 indicate the file is a shipped, matured seed object rather than a patched one. Notably, the package version is shared across the 12.1.1 and 12.2.2 releases; the R12.2 online patching architecture (adop, edition-based redefinition) does not alter the package logic itself, but the object is compiled and executed under an editioning context in 12.2.2.

Key Procedures and Functions

  • BEFOREREPORT — The report initialization function invoked before the main query executes. It performs two principal operations: it rewrites the SEL_FLEXDATA placeholder by replacing the token LEDGER_SEGMENT with an NVL expression resolving target ledger short name over ledger short name, and it queries FND_ID_FLEX_STRUCTURES to retrieve the concatenated segment delimiter for the GLLE key flexfield structure identified by P_STRUCT_NUM, defaulting to a single space if none is found. It returns TRUE on successful initialization.
  • AFTERREPORT — The teardown function invoked after report completion. In this implementation it is a stub that returns TRUE.
  • C_STANDARD_FORMULAFORMULA — A formula function returning the arithmetic expression 'A * B/C'. It is a standard XML Publisher formula helper used for percentage/ratio columns in the report layout.
  • ACCOUNT_ACTION_CODEFORMULA — A formula function that composes a display string from a ledger action code and a segment types key, delimited by the DELIMITER value resolved during BeforeReport. It returns NULL when AMOUNT is not NULL, meaning the composite string is only generated for rows with no amount.
  • SEL_FLEXDATA_P — The placeholder accessor for the SEL_FLEXDATA global, returning the (possibly rewritten) flexfield data select fragment.
  • DELIMITER_P — The placeholder accessor for the DELIMITER global, returning the concatenated segment delimiter string used by other formulas.

Tables Accessed

The package reads a single documented table, FND_ID_FLEX_STRUCTURES (referenced through the APPS synonym). The query filters on application_id = 101 (General Ledger), id_flex_code = 'GLLE', and id_flex_num = P_STRUCT_NUM, and selects the maximum CONCATENATED_SEGMENT_DELIMITER for the matching flexfield structure. The retrieved delimiter drives the ACCOUNT_ACTION_CODEFORMULA output and the display of accounting flexfield values throughout the report.

Usage Notes

This package is not intended to be called directly by custom code. It is invoked implicitly by the Oracle Reports/XML Publisher runtime when the GLXRLMAB concurrent program or its report definition executes. The documented metadata records zero referencing packages, confirming that its callers are the report engine and the report definition metadata rather than other PL/SQL objects. Customizations should not alter the generated body; instead, the underlying XML Publisher data template (the SEL_FLEXDATA fragment containing the LEDGER_SEGMENT token) and report parameters such as P_STRUCT_NUM are the supported extension points. Because the package is seeded as an Apps object with output published via the XMLP architecture, recreation by the XML Publisher generator will overwrite manual edits. In 12.2.2, the package is resolved per edition through ADOP, so any local modification must be applied to an editioned file and compiled accordingly.