Search Results format_mask_width

Overview

The package body APPS.GL_RGXCOLD_XMLP_PKG underpins the Oracle General Ledger "RGXCOLD" (Report Generator XML Publisher Column Detail) concurrent report. It is a report logic container generated by Oracle Reports and published into the database, providing the PL/SQL entry and exit points, dynamic column-formatting formulas, and profile-driven parameter derivation used by the XML Publisher (BI Publisher) template associated with the program. Its central purpose is to resolve the correct key flexfield structure and segment prompt configuration for the ledger being reported on, so that the report can format account segment columns and their flexfield value prompts correctly at runtime. The package is classified as an "OTHER" public API in ETRM, meaning it is not part of Oracle's supported external interface contract; it is internal report-supporting code that may be regenerated by Oracle patches.

Key Procedures and Functions

• BEFOREREPORT — The main pre-report trigger function. It derives the chart of accounts identifier from GL_ACCESS_SETS, sets the structure number (C_STRUCT_NUM), defaults the flexfield code to 'GLLE', conditionally switches it to 'GLAT' when the Industry profile is 'G' and the Attribute Reporting profile is 'Y', concatenates segmented flexfield low/high ranges, types and prompts, and rewrites the ledger segment tokens to the GLLED alias.
• AFTERREPORT — A cleanup/termination trigger that returns TRUE after report completion. The original FND SRWEXIT call is commented out, so it is effectively a no-op in this release.
• C_FLEX_LOWFORMULA — Dynamic format-mask style formula returning the flexfield low-value string for the column.
• C_FLEX_HIGHFORMULA — Formula returning the flexfield high-value string.
• C_FLEX_TYPEFORMULA — Formula resolving the flexfield qualifier/type string for the column.
• DISPLAY_FORMAT_DSPFORMULA — Formula controlling the display format mask width applied to the flexfield column values.
• C_STRUCT_NUM_P, C_ID_FLEX_CODE_P, C_INDUSTRY_TYPE_P, C_ATTRIBUTE_FLAG_P — Parameter accessor functions that expose the internal package variables (structure number, ID flex code, industry type, attribute flag) to the report layout.

Tables Accessed

The only documented table reference is GL_ACCESS_SETS, accessed through an APPS synonym. BEFOREREPORT performs a single-row SELECT of CHART_OF_ACCOUNTS_ID where ACCESS_SET_ID equals the incoming P_ACCESS_SET_ID parameter. This lookup binds the report run to the correct accounting flexfield structure, ensuring subsequent flexfield value resolution and column formatting target the right chart of accounts. No inserts, updates, or deletes are performed by the documented code.

Usage Notes

This package is invoked indirectly by the RGXCOLD concurrent program infrastructure rather than called by user code. At runtime the Report/XML Publisher engine calls BEFOREREPORT before generating output, evaluates the flexfield formulas per column, and calls AFTERREPORT at completion. Because it is auto-generated and internally classified, direct invocation from custom code is not supported. The user search term "format_mask_width" relates to DISPLAY_FORMAT_DSPFORMULA and the flexfield prompt/type formulas, which govern how account segment columns are sized and formatted in report output. The package is referenced by no other packages, confirming its position as a leaf-level report support object regenerated by Oracle adpatch cycles.