Search Results c_structure_id

Overview

GL_RGXRPTD_XMLP_PKG is the PL/SQL package body that backs the Oracle E-Business Suite General Ledger XML Publisher report commonly identified as RGXRPTD. The package encapsulates the report-level logic that Oracle Reports previously implemented through SRW user exits, adapting that behavior to the XML Publisher execution model used in EBS 12.1.1 and 12.2.2. Its principal responsibility is to resolve the accounting structure context in which a General Ledger report runs, then expose that context to the report template as bind or placeholder values.

The most significant output of the package is the C_STRUCTURE_ID value. When the report is launched against an access set, the package derives C_STRUCTURE_ID from the chart of accounts associated with that access set. When no access set is supplied, the value remains unset. This variable, together with the flexfield code, drives the delimiter resolution and segment-override behavior used when the report renders accounting flexfield segment values. C_STRUCTURE_ID therefore acts as the link between the report request parameters and the underlying chart of accounts metadata.

Key Procedures and Functions

• BeforeReport — The main initialization routine. It declares local variables for the chart of accounts identifier and functional currency, resolves the chart of accounts from GL_ACCESS_SETS when an access set parameter is provided, assigns that value to C_STRUCTURE_ID, and sets C_ID_FLEX_CODE to the accounting flexfield code GLLE. It also conditionally switches the flexfield code to GLAT when the industry type is General Ledger and attribute reporting is enabled, and finally initializes P_DELIMITER using the FND flexfield extension utility. The routine returns a boolean success indicator.
• AfterReport — The terminating routine. It performs the symmetric teardown step corresponding to report startup and returns a boolean success indicator.
• C_SEGMENT_OVERIRDEFORMULA — A wrapper that accepts a segment override value and delegates to F_OVERRIDE_SEGMENT, returning the overridden segment text as a character value.
• F_OVERRIDE_SEGMENT — Resolves the leading portion of an accounting flexfield segment. It parses the segment string using the configured delimiter, extracts the leading numeric component, and looks up the corresponding ledger short name from GL_LEDGERS. The ledger short name is then concatenated with the remaining segment text, substituting a ledger name for a ledger identifier in the rendered output.
• C_STRUCTURE_ID_P — Returns the package-level C_STRUCTURE_ID value to the report.
• C_ID_FLEX_CODE_P — Returns the resolved key flexfield code (GLLE or GLAT) to the report.
• C_INDUSTRY_TYPE_P — Returns the industry type profile value captured for the report session.
• C_ATTRIBUTE_FLAG_P — Returns the attribute reporting profile flag used to determine whether the attribute flexfield code applies.

Tables Accessed

• GL_ACCESS_SETS — Read during BeforeReport to resolve the chart of accounts identifier from the supplied access set identifier. This is the source of C_STRUCTURE_ID.
• GL_LEDGERS — Read by F_OVERRIDE_SEGMENT to convert a ledger identifier embedded in a segment value into the ledger short name. The query uses an outer join, so segments that do not resolve to a ledger still return the remaining segment text.

Both tables are referenced through APPS synonyms. The package performs read-only access and does not insert, update, or delete data.

Usage Notes

The package is invoked automatically by the XML Publisher report RGXRPTD rather than being called directly by application users. BeforeReport executes at report initialization and AfterReport at completion, while the getter functions serve as placeholders consumed by the report template. Custom code and concurrent program definitions reference C_STRUCTURE_ID indirectly through the report data model, and the ETRM metadata records no other packages as callers. Because the package resolves structure and delimiter information at runtime, any customization that changes access set configuration or ledger assignments immediately affects the report output, including the segment override substitution performed by F_OVERRIDE_SEGMENT.