Search Results c_id_flex_code

Overview

GL_RGXCOND_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the XML Publisher (BI Publisher) concurrent program used to generate the GL "Revenue/Expense by Account Condition" style report — internally associated with the RGXCOND report definition. The package encapsulates the report-level logic required by the Oracle Reports/XML Publisher runtime, primarily the BeforeReport and AfterReport trigger handlers and the formula columns that drive the flexfield (key flexfield) segment display logic. Its central responsibility is to resolve the correct accounting key flexfield structure and flexfield code so that ledger segment values, ranges, and prompts presented on the report are read from the appropriate flexfield definition rather than hard-coded.

The user-searched term "c_id_flex_code" refers to a package-level global/variable populated during BeforeReport. In the source excerpt, C_ID_FLEX_CODE is initialized to 'GLLE' (the standard General Ledger ledger flexfield code) and conditionally switched to 'GLAT' (the attribute-reporting flexfield code) when the profile option INDUSTRY equals 'G' and the profile ATTRIBUTE_REPORTING equals 'Y'. This variable is subsequently referenced by the flexfield formula functions and by FND_FLEX_APIS calls.

Key Procedures and Functions

• BEFOREREPORT — The report initialization trigger. It derives the chart of accounts id (C_STRUCT_NUM) from GL_ACCESS_SETS using the P_ACCESS_SET_ID parameter, sets C_ID_FLEX_CODE, reads the INDUSTRY and ATTRIBUTE_REPORTING profile options, conditionally concatenates the multi-part flexfield low/high values and prompts, replaces ledger-segment placeholders with the GLLED.short_name reference, and resolves the segment delimiter via FND_FLEX_APIS.gbl_get_segment_delimiter (defaulting to '-'). Returns TRUE to allow the report to run.
• AFTERREPORT — The report termination trigger. In the documented body it substitutes for the legacy SRW.USER_EXIT('FND SRWEXIT') call and returns TRUE.
• C_FLEX_LOWFORMULA — A formula column function that builds the low-range flexfield value used in the report's WHERE clause, referencing C_ID_FLEX_CODE, the incoming data-low value, and C_STRUCT_NUM.
• C_FLEX_HIGHFORMULA — The parallel formula column function producing the high-range flexfield value.
• C_FLEX_TYPEFORMULA — Formula function that supplies the flexfield "type" (structure/flexfield selector) used by the report query.
• C_STRUCT_NUM_P — Accessor/placeholder function for the C_STRUCT_NUM package variable (the chart of accounts id used as the flexfield structure number).
• C_ID_FLEX_CODE_P — Accessor/placeholder function exposing the C_ID_FLEX_CODE variable (the searched term), reported to the report layout and consumed by flexfield API calls.
• C_INDUSTRY_TYPE_P — Accessor/placeholder function for the C_INDUSTRY_TYPE variable read from the INDUSTRY profile option.
• C_ATTRIBUTE_FLAG_P — Accessor/placeholder function for the C_ATTRIBUTE_FLAG variable read from the ATTRIBUTE_REPORTING profile option, which governs whether the attribute flexfield ('GLAT') is used instead of the ledger flexfield ('GLLE').

Tables Accessed

The package references two documented objects through APPS synonyms. GL_ACCESS_SETS is queried in BeforeReport to translate the P_ACCESS_SET_ID parameter into a chart_of_accounts_id, which becomes the flexfield structure number (C_STRUCT_NUM). DUAL is used as the single-row source for the FND_FLEX_APIS.gbl_get_segment_delimiter function call. No inserts, updates, or deletes are performed; the package is read-only with respect to these tables.

Usage Notes

This package is not a public application programming interface; its API classification is OTHER, and it is referenced by zero other packages. It is invoked exclusively by the XML Publisher / Oracle Reports runtime associated with the GL_RGXCOND report definition. The BeforeReport function executes automatically at report start (taking P_ACCESS_SET_ID and the P_FLEXDATA_* parameters), and the formula functions are called for each report row where flexfield range values must be dereferenced. In both Oracle EBS 12.1.1 and 12.2.2 the profile options INDUSTRY and ATTRIBUTE_REPORTING determine whether the ledger flexfield ('GLLE') or the attribute flexfield ('GLAT') is used. Because C_ID_FLEX_CODE and the other C_* variables are module-level state, they are populated once per report execution and read thereafter. Customizations should avoid modifying the package directly; instead, equivalent logic may be reproduced in a custom XML Publisher data definition or in a custom concurrent program, since the package is a report-specific, non-shared artifact.