Search Results c_id_flex_code_p

Overview

APPS.GL_RGXRORDD_XMLP_PKG is a report-support PL/SQL package associated with the Oracle General Ledger XML Publisher reporting framework. The package name follows the standard Oracle E-Business Suite convention for a report-level package (the _XMLP_PKG suffix), in this case backing a General Ledger row-order report defined by the RGXRORDD report code. Its principal business function is to act as a container for the report's bind parameters and static constants and to supply the report lifecycle entry points — BeforeReport and AfterReport — that the Oracle Reports/XML Publisher runtime invokes when the concurrent program executes. The package also exposes getter functions that the report layout and data model use to retrieve the current values of its constant and bind variables, ensuring the report footer and header reflect the correct accounting structure, chart of accounts context, and processing flags.

Key Procedures and Functions

The package specification declares six documented entry points. Two are lifecycle triggers: BeforeReport, which executes prior to the report's main data query to initialize the report environment, and AfterReport, which runs after report completion to finalize or clean up. The remaining four are accessor functions. C_STRUCTURE_ID_p returns the numeric identifier of the accounting structure in use. C_ID_FLEX_CODE_p returns the key flexfield code, which the metadata shows is defaulted to the literal value 'GLLE', the identifying code for the General Ledger Accounting Flexfield. C_INDUSTRY_TYPE_p returns the industry type indicator, defaulted to 'C'. C_ATTRIBUTE_FLAG_p returns an attribute flag, defaulted to 'N'. These getters allow the report definition to reference package state directly, which is useful because attributes and constants declared in the package specification are visible to the report layout without re-declaration.

The package also declares four public data variables used across these routines: P_ACCESS_SET_ID (varchar2), P_ROW_ORDER_ID (number), P_CONC_REQUEST_ID (number, the standard concurrent request identifier), and C_STRUCTURE_ID (number). These variables are populated either by the concurrent manager as report parameters or internally during BeforeReport processing.

Tables Accessed

ETRM metadata records a single referenced table, accessed through an APPS synonym: GL_ACCESS_SETS. Access sets in General Ledger define which ledger and balancing segment values a responsibility or user is permitted to see; the package uses this table to resolve the access set identified by the P_ACCESS_SET_ID bind variable into the structure and flexfield context required for the row-order report. This lookup constrains the report output to the security profile applicable to the requesting user, which is essential in multi-organization, multi-ledger 12.1.1 and 12.2.2 environments. No insert, update, or delete activity against application data tables is documented; the package is read-only with respect to GL_ACCESS_SETS.

Usage Notes

This package is invoked indirectly rather than called by custom code. It executes as part of the Oracle General Ledger concurrent program that runs the RGXRORDD row-order report, with the Oracle Reports or XML Publisher engine calling BeforeReport and AfterReport at the appropriate lifecycle points and the getter functions supplying constant values to the report template. The standard P_CONC_REQUEST_ID variable enables the function to log and retrieve concurrent request context. Because the package is classified as OTHER, it is not part of a published PL/SQL API and should not be called directly by external programs. The ETRM metadata confirms that no other packages reference it, reinforcing that its only consumer is the report definition it was built to support. The user's search term, "c_id_flex_code_p", corresponds to the getter for the flexfield code, whose default value 'GLLE' ties this package specifically to the General Ledger Accounting Flexfield key structure. Any customization should avoid modifying the specification constants, since report data models depend on the returned values remaining stable across Oracle EBS 12.1.1 and 12.2.2 upgrades.