Search Results gl_rgxrows_xmlp_pkg

Overview

The APPS.GL_RGXROWS_XMLP_PKG package is a generated Oracle Reports (XML Publisher) supporting package owned by the APPS schema in Oracle E-Business Suite. Its name derives from the "RGXROWS" report identifier associated with the General Ledger responsibility, reflecting its role as the PL/SQL container that supplies report parameters and lifecycle logic to an Oracle Reports executable registered as a concurrent program. The header comment ($Header: RGXROWSS.pls 120.0 2007/12/27) confirms the package body was generated from a report definition rather than hand-authored application code.

Functionally, the package exposes the report's bind and lexical parameters to the Reports runtime and provides the two mandatory report triggers, BeforeReport and AfterReport. It is compiled with AUTHID CURRENT_USER, meaning that at runtime its SQL executes with the privileges of the invoking user rather than the definer, which is standard for these generated wrappers.

Key Procedures and Functions

The documented interface contains six functions, corresponding to the report's parameters plus its two lifecycle hooks:

• BeforeReport — the report-level trigger fired before the main query executes; used to initialize session state and validate parameter combinations prior to data retrieval.
• AfterReport — the report-level trigger fired after report completion; used for cleanup and to return a completion status to the concurrent manager.
• C_STRUCTURE_ID_p — accessor returning the value of the C_STRUCTURE_ID package variable, the key flexfield structure identifier used to constrain the ledger's chart of accounts.
• C_ID_FLEX_CODE_p — accessor returning C_ID_FLEX_CODE, which is initialized to the constant 'GL#', the General Ledger Accounting Flexfield application/ID flex code.
• C_ATTRIBUTE_FLAG_p — accessor returning C_ATTRIBUTE_FLAG, initialized to 'N', controlling whether descriptive flexfield attributes are included in the output.
• C_INDUSTRY_TYPE_p — accessor returning C_INDUSTRY_TYPE, initialized to 'C'. This is the parameter referenced by the user's search term c_industry_type_p; it indicates the operating industry classification applied when the report resolves which segment or row definitions to render.

Tables Accessed

The only documented table reference is GL_ACCESS_SETS, reached through an APPS synonym. The access set defines the set of ledgers, balancing entities, and management segments a responsibility may report on. Reading this table allows the report to restrict its output rows to the data access privileges of the running user, which is essential because the package executes AUTHID CURRENT_USER. The package declares P_ACCESS_SET_ID as a package-level variable to carry the selected access set identifier into that query.

Usage Notes

This package is not called by other PL/SQL packages; the ETRM metadata records zero inbound package references. It is invoked exclusively by the Oracle Reports runtime when the associated concurrent program is submitted from a General Ledger responsibility form or the Submit Requests window. Developers supporting 12.1.1 and 12.2.2 should treat the package as regenerated artifacts: modifications belong in the report definition, not in the PL/SQL, since any patch or recompile of the report will overwrite custom edits. Diagnostic work involving c_industry_type_p should therefore examine the report's parameter form and the underlying query, not the accessor itself.