Search Results c_industry_type

Overview

APPS.GL_RGXRORDD_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Reports executable RGXRORDD, a General Ledger reporting program delivered in Oracle E-Business Suite 12.1.1 and 12.2.2. Like all _XMLP_PKG packages produced by the Oracle Reports to XML Publisher conversion utility, it encapsulates the report's BeforeReport and AfterReport trigger logic together with a set of accessor functions that expose report-level placeholders to the report runtime. The package body is the implementation half of the specification declared as GL_RGXRORDD_XMLP_PKG; the ETRM classifies it as API type OTHER, indicating it is an internal, non-public construct rather than a callable business API.

The highlighted token in the user's search, c_industry_type, is a package-level global that this body consumes during report initialization. The value is populated by the FND GETPROFILE user exit, which retrieves the Industry profile option for the reporting responsibility, and is then evaluated against the constant 'G' to determine whether the ledger uses the governmental chart of accounts.

Key Procedures and Functions

• BEFOREREPORT — The primary initialization routine. It resolves the chart of accounts identifier by querying GL_ACCESS_SETS when an access set is supplied, assigns the resulting chart_of_accounts_id to the C_STRUCTURE_ID placeholder, and defaults C_ID_FLEX_CODE to 'GLLE'. When the industry profile resolves to 'G', it conditionally reads the ATTRIBUTE_REPORTING profile and, if that flag equals 'Y', switches the key flexfield code to 'GLAT'. It returns boolean TRUE.
• AFTERREPORT — The cleanup routine invoked at report termination. Its body is effectively a no-op in this converted version (the SRWEXIT call is commented out) and returns boolean TRUE.
• C_STRUCTURE_ID_P — Accessor returning the C_STRUCTURE_ID placeholder, i.e. the resolved chart of accounts identifier used by the report query.
• C_ID_FLEX_CODE_P — Accessor returning C_ID_FLEX_CODE, the key flexfield code (GLLE or GLAT) that governs how accounting flexfield segments are interpreted.
• C_INDUSTRY_TYPE_P — Accessor returning C_INDUSTRY_TYPE, the Industry profile value central to the user's search. Downstream report logic and conditional formatting reference this value through the accessor rather than the global directly.
• C_ATTRIBUTE_FLAG_P — Accessor returning C_ATTRIBUTE_FLAG, the Attribute Reporting profile flag that gates the governmental attribute flexfield path.

Tables Accessed

The only documented table reference is GL_ACCESS_SETS, accessed through its APPS synonym. The BeforeReport trigger performs a single-row lookup of chart_of_accounts_id filtered by access_set_id, which is supplied by the report parameter P_ACCESS_SET_ID. This read binds the report to the correct chart of accounts when a data access set is in force, and the resulting identifier is cached in C_STRUCTURE_ID for the duration of the report run. No inserts, updates, or deletes are documented.

Usage Notes

The package is not designed for direct invocation by application code. It is executing only within the Oracle Reports runtime, where the report engine calls BeforeReport and AfterReport as trigger points and invokes the *_P accessors to resolve placeholder references in the report layout and query. Typical invocation is therefore through the concurrent program definition associated with the RGXRORDD report, scheduled from a General Ledger responsibility. The profile option values consumed here are resolved through the FND profile machinery in the original Reports build; in the converted XML Publisher form, equivalent values are passed as report parameters. Because the package is bound to the APPS schema and is referenced by zero other packages, customizations should avoid modifying it directly; extensions should instead be implemented through a supported report or concurrent program customization. Behavior differences between 12.1.1 and 12.2.2 are limited to the underlying profile and access set infrastructure, not to this package's interface.