Search Results cf_flex_low




Overview
Explore in AI Chat

Overview

IGI_IGIGBRCL_XMLP_PKG is an Oracle E-Business Suite package body owned by the APPS schema that supports the concurrent-program report identified by the "XMLP" suffix and the "IGIGBRCL" module designation. The package provides the server-side PL/SQL callbacks and global-variable accessors that the Oracle Reports/BI Publisher runtime invokes when the report is executed as a concurrent request. Its principal responsibility is to drive Oracle EBS concurrent manager integration and Oracle Application Object Library (AOL) flexfield value resolution for the GL accounting flexfield, gated by the parameter P_RUN_AOL.

The P_RUN_AOL parameter acts as the runtime switch that distinguishes execution inside the concurrent manager (value 'Y') from direct or non-AOL execution. All conditional logic in the package is wrapped inside checks of this parameter, ensuring that AOL-specific initialization and value-set lookups occur only when the report is genuinely running under the concurrent manager.

Key Procedures and Functions

  • AFTERREPORT — Cleanup function invoked at the completion of report execution. When P_RUN_AOL equals 'Y', it triggers the FND SRWEXIT user exit (shown commented in the source) to terminate the AOL session. It unconditionally returns TRUE.
  • BEFOREREPORT — Initialization function invoked before report output. When P_RUN_AOL equals 'Y', it assigns the concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID to P_CONC_REQUEST_ID, then invokes FND SRWINIT to initialize the AOL session and FND FLEXRSQL against the GL# key flexfield structure (P_STRUCT_NUM, application SQLGL) to populate CP_FLEX for the RANGES table alias.
  • CF_FLEX_HIGHFORMULA — Formula-level function that resolves the display value for the high end of the accounting flexfield range. When P_RUN_AOL equals 'Y', it references P_STRUCT_NUM and HIGH_RANGE and calls FND FLEXRIDVAL against structure P_STRUCT_NUM to expand HIGH_RANGE into CF_FLEX_HIGH.
  • CF_FLEX_LOWFORMULA — Companion formula function resolving the low end of the flexfield range. Under P_RUN_AOL = 'Y' it references P_STRUCT_NUM and LOW_RANGE and calls FND FLEXRIDVAL to expand LOW_RANGE into CF_FLEX_LOW.
  • CP_FLEX_LOW_P — Accessor function returning the value of the CP_FLEX_LOW package-level variable.
  • CP_FLEX_HIGH_P — Accessor function returning the value of the CP_FLEX_HIGH package-level variable.

Tables Accessed

The documented ETRM metadata lists no tables referenced through APPS synonyms for this package. All data access implied by the source is performed indirectly through the Oracle Reports user exits (FND SRWEXIT, FND SRWINIT, FND FLEXRSQL, and FND FLEXRIDVAL) and through FND_GLOBAL for the concurrent request identifier. The GL# accounting flexfield structure is resolved dynamically by the FND FLEXRSQL and FND FLEXRIDVAL calls rather than through static SQL in the package body.

Usage Notes

This package is not intended for direct invocation by forms, custom code, or other PL/SQL packages; the ETRM metadata records zero packages referencing it. It is an internal component of the IGI_IGIGBRCL XML Publisher report, binding the report's Before Report and After Report triggers and its formula columns to the concurrent manager lifecycle and the GL accounting flexfield. The effective runtime sequence is BEFOREREPORT during initialization, CF_FLEX_HIGHFORMULA and CF_FLEX_LOWFORMULA during report data formatting to expand the flexfield range values, CP_FLEX_LOW_P and CP_FLEX_HIGH_P to expose those values, and AFTERREPORT upon completion. Because the AOL user exits are commented out in the 12.1.1/12.2.2 source, the package largely serves as a compatibility shim for XML Publisher reports migrated from earlier Oracle Reports technology.