Search Results f_override_segment

Overview

APPS.GL_RGXRSETD_XMLP_PKG is a server-side PL/SQL package that backs the Oracle General Ledger report set definition XML Publisher (BI Publisher) concurrent program. Its role is to supply the runtime data and derived column values required by an XML report template that renders the structure and contents of General Ledger report sets. The package encapsulates the report-level parameters (concurrent request identifier, access set identifier, report set identifier, and output delimiter), fixes the key flexfield context to the GL account key flexfield ('GLLE'), and exposes a set of package functions that the XML report definition calls during formatting and grouping.

In Oracle EBS 12.1.1 and 12.2.2 the object resides under the APPS schema and is classified as OTHER in ETRM, meaning it is an internal report implementation package rather than a published PL/SQL API. It is not intended for direct invocation by customer code. The $Header comment (RGXRSETDS.pls 120.0, 2007/12/27) indicates the package predates the 12.1.1 release and was carried forward unchanged into 12.2.2, consistent with the stability of the report set feature across both releases.

Key Procedures and Functions

• BeforeReport — Standard Oracle Reports/XML Publisher entry point that executes prior to report data retrieval. It initializes package-level state, resolves the key flexfield structure and context, and prepares parameters such as the delimiter and access set identifiers.
• AfterReport — Post-processing entry point executed after report completion, used for cleanup and final return status.
• f_override_segment — This is the function the user searched on. It takes a single segment string argument and returns a varchar. Its purpose is to override or substitute the displayed value of an account segment (for example, replacing an ID with a descriptive value or applying report-set-specific formatting) before the value is emitted into the XML output. The function is referenced twice in the package specification (once commented, once active), confirming it is exposed to the report template as a group or formula column.
• c_segment_overrideformula — Accepts a segment override string and returns a char. This is the companion formula column that drives segment override logic for the report, working alongside f_override_segment.
• C_ID_FLEX_CODE_p — Returns the key flexfield code constant, initialized to 'GLLE' (the GL Accounting Flexfield).
• C_STRUCTURE_ID_p — Returns the flexfield structure identifier resolved for the report run.
• C_INDUSTRY_TYPE_p — Returns the industry type constant, initialized to 'C'.
• C_ATTRIBUTE_FLAG_p — Returns the attribute flag constant, initialized to 'N'.

Tables Accessed

• GL_ACCESS_SETS — Read to resolve the access set specified by P_ACCESS_SET_ID and to derive the ledgers and report sets visible to the report run, enforcing access set security.
• GL_LEDGERS — Read to obtain ledger context (chart of accounts, currency, and associated accounting flexfield structure) required for segment formatting and to populate the C_STRUCTURE_ID value.

Usage Notes

GL_RGXRSETD_XMLP_PKG is invoked exclusively through the report set definition XML Publisher concurrent program; it is not called from Oracle Forms and is referenced by zero other packages per ETRM (referenced by 0). Customizations should not call this package directly. Where segment display behavior must be changed, the supported extension point is the report template itself, which consumes the output of f_override_segment and c_segment_overrideformula. Because the package is unpinned and under APPS, any direct modification constitutes an unsupported customization in both 12.1.1 and 12.2.2.