Search Results gl_rgxrowd_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_RGXROWD_XMLP_PKG is the packaged implementation behind the Oracle General Ledger report commonly identified as "RGXROWD" (the Row Order/row definition extract produced through the Oracle Reports XML Publisher integration). In Oracle EBS 12.1.1 and 12.2.2, reports of this class are registered as concurrent programs and executed through the XML Publisher (BI Publisher) engine, with the PL/SQL package serving as the report's server-side logic library rather than as a standalone business API. The package's stated API classification is OTHER, confirming that it is a report-support package rather than a public application programming interface intended for direct customer invocation.

The package's principal responsibility is to resolve the accounting flexfield context and the reporting parameters needed by the report's data model. In the documented BeforeReport function it derives the chart of accounts identifier from the access set supplied by the user, assigns that value to the package variable C_STRUCT_NUM, fixes the key flexfield code, and then conditionally promotes the flexfield to the GAFA/GLLAT style when the Industry profile and Attribute Reporting profile indicate an industry-enabled chart of accounts. It also assembles the low, high, type and prompt flexfield parameters from their individual components and resolves the segment delimiter using the flexfield API.

Key Procedures and Functions

  • BEFOREREPORT — The main initialization function invoked by the report trigger before data retrieval. It resolves COA_ID from GL_ACCESS_SETS, sets C_STRUCT_NUM and C_ID_FLEX_CODE, evaluates the Industry and Attribute Reporting profile options, concatenates the flexfield low/high/type/prompt parameters, substitutes ledger segment tokens, and computes the segment delimiter.
  • AFTERREPORT — Executed following report completion, providing the customary teardown hook (referenced in the documentation as the exit point that pairs with the before-report initialization).
  • C_FLEX_LOWFORMULA, C_FLEX_HIGHFORMULA, C_FLEX_TYPEFORMULA — Column formulas exposed to the report layout that return the low value, high value and flexfield type used to build the flexfield range query.
  • C_STRUCT_NUM_P, C_ID_FLEX_CODE_P, C_INDUSTRY_TYPE_P, C_ATTRIBUTE_FLAG_P — Accessor/placeholder functions for the package-level variables C_STRUCT_NUM (the structure number derived from the access set's chart of accounts), C_ID_FLEX_CODE (the key flexfield code, GLLE or GLAT), C_INDUSTRY_TYPE (the Industry profile value) and C_ATTRIBUTE_FLAG (the ATTRIBUTE_REPORTING profile value).

Tables Accessed

Only two data sources are documented. GL_ACCESS_SETS is queried to map the user-selected access set (P_ACCESS_SET_ID) to its chart_of_accounts_id, which becomes the structure number C_STRUCT_NUM used by the flexfield APIs. DUAL is referenced for the scalar call to FND_FLEX_APIS.gbl_get_segment_delimiter, which returns the delimiter for the resolved key flexfield structure; when the API returns an empty string the package defaults the delimiter to a hyphen. No write operations are documented.

Usage Notes

The package is not intended for direct call by custom code; it is bound to the reports that share the GL_RGXROWD data definition and is invoked by the Reports/XML Publisher runtime whenever the corresponding concurrent program is submitted. The value the user searched for, c_struct_num, is a package-level variable rather than a database column. It holds the structure number (chart of accounts identifier) and is central to every flexfield operation in the report: it is passed to FND_FLEX_APIS.gbl_get_segment_delimiter, referenced through SRW.REFERENCE in the original Oracle Reports implementation, and surfaced to the report layout through the C_STRUCT_NUM_P accessor. No other packages are documented as depending on this package, underscoring its role as a report-local utility rather than a shared component.