Search Results c_flex_highformula

Overview

GL_RGXCOLD_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name follows the standard Oracle Reports concurrent program convention, in which the "XMLP" suffix indicates that the package supports an XML Publisher (BI Publisher) report template. The "RGXCOLD" element identifies the associated report — a General Ledger column set / access set reporting program. The package functions as the server-side report logic container that Oracle Reports invokes when the concurrent program is submitted: it declares the report's parameters, computes the lexical substitution strings used to build the General Ledger flexfield display, and supplies the format mask and structural information required to render the Accounting Flexfield segments correctly on the report output.

The package header exposes a set of package-level variables (P_ACCESS_SET_ID, P_COLUMN_SET_ID, P_CONC_REQUEST_ID, P_FLEX_LPROMPT, P_FLEXDATA_LOW, P_FLEXDATA_HIGH, P_FLEXDATA_TYPE) that hold runtime bind values for the submitted concurrent request. The flexdata variables are initialized to long, concatenated expressions that map each Accounting Flexfield segment (SEGMENT1 through SEGMENT30, plus the segment attributes) to a newline-delimited string, which the report uses to display the concatenated key flexfield value for the low and high ranges entered by the user.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions in this package:

• BEFOREREPORT — Executed before the report body runs; typically initializes flexfield structures, resolves the accounting flexfield definition, and populates the package variables that drive the report queries.
• AFTERREPORT — Executed after the report completes; performs any required cleanup or post-processing.
• C_FLEX_LOWFORMULA — Report formula column function that returns the formatted low-range value of the Accounting Flexfield for the report column set.
• C_FLEX_HIGHFORMULA — Report formula column function that returns the formatted high-range value of the Accounting Flexfield for the report column set.
• C_FLEX_TYPEFORMULA — Report formula column function that returns the flexfield type designation used to interpret the segment values.
• DISPLAY_FORMAT_DSPFORMULA — The user-facing display formula. This is the object most commonly sought by report developers and administrators. It governs how the concatenated flexfield segment string is displayed in the report output — the separator, ordering, and formatting applied to the low/high range textual representation. Because the user search term was "display_format_dspformula", this function is the entry point of interest for customizing report column display.
• C_STRUCT_NUM_P — Returns the key flexfield structure number (the accounting flexfield definition identifier).
• C_ID_FLEX_CODE_P — Returns the key flexfield application/ID flex code identifying which flexfield the report is processing.
• C_INDUSTRY_TYPE_P — Returns the industry/application context type used to resolve the correct flexfield definition.
• C_ATTRIBUTE_FLAG_P — Returns the attribute flag controlling whether segment attributes are included in the display string.

Tables Accessed

The only table documented for this package via APPS synonyms is GL_ACCESS_SETS. The package reads this table to resolve the access set specified by the P_ACCESS_SET_ID concurrent program parameter. The access set defines which ledger and accounting flexfield structure, and therefore which segment definitions and value ranges, are valid for the report. This lookup drives the structure number, ID flex code, and segment prompt values returned by the C_STRUCT_NUM_P, C_ID_FLEX_CODE_P, and related functions, enabling the report to build the proper low/high flexdata strings.

Usage Notes

This package is invoked exclusively through the Oracle Reports runtime when the associated RGXCOLD concurrent program (typically the General Ledger column set / access set report) is submitted from the Submit Requests form or the GL standard request submission interface. It is not referenced by any other documented package, confirming its role as a leaf-level, report-scoped package rather than a shared library. Administrators and developers interact with it indirectly: when the report layout requires customization — for example, changing how the accounting flexfield range is displayed — the DISPLAY_FORMAT_DSPFORMULA function is the point of modification. Because the package resides in the APPS schema and carries the standard Oracle Reports generated header (tagged "noship"), any customization should be treated as an applied patch or report-level extension rather than a direct database object modification, and should be preserved through EBS upgrade cycles. The package is compatible with both EBS 12.1.1 and 12.2.2 architectures.