Search Results flex_select_all

Overview

IGC_IGCBDTRR_XMLP_PKG is a report-support package body owned by APPS in the Oracle E-Business Oracle Financials/Contracts and Grants (IGC) application. Its name follows the standard Oracle Reports XML Publisher naming convention, where the trailing _XMLP_PKG suffix identifies a generated PL/SQL package used to encapsulate the data model, user-exit logic, and parameter handling for an XML Publisher report. In this case the underlying report is associated with the IGCBDTRR report definition, a Contract Billing detail report. The package serves two principal purposes: (1) to retrieve and expose report parameters that Oracle Reports must publish into the report layout, and (2) to initialize the report run-time environment at execution time, most importantly by resolving the ledger (set of books) and chart of accounts context using the public GL_INFO and GL_MESSAGE APIs.

Key Procedures and Functions

• AFTERREPORT — Executes clean-up logic after the report completes. The body contains only a placeholder NULL statement and returns TRUE, reflecting the generated default where the SRW.USER_EXIT(‘FND SRWEXIT’) call has been commented out.
• STRUCT_NUM_P — Returns the STRUCT_NUM value, which holds the Chart of Accounts ID resolved during report initialization. This accessor makes that value available to the report layout.
• SET_OF_BOOKS_NAME_P — Returns the SET_OF_BOOKS_NAME value, the ledger (set of books) name looked up for the run-time set of books.
• FUNCTIONAL_CURRENCY_P — Returns the FUNCTIONAL_CURRENCY value, the functional currency of the resolved ledger.
• FLEX_SELECT_ALL_P — Returns FLEX_SELECT_ALL, the key flexfield SELECT expression used to constrain the Chart of Accounts segment values in the report query.
• BEFOREREPORT — The primary initialization routine. It declares local variables for the chart of accounts ID, set of books name, and functional currency, then calls GL_INFO.GL_GET_LEDGER_INFO using the report parameter P_SET_OF_BOOKS_ID. The returned values are assigned to STRUCT_NUM, SET_OF_BOOKS_NAME, and FUNCTIONAL_CURRENCY. On error it builds a message via GL_MESSAGE.GET_MESSAGE using the GL_PLL_ROUTINE_ERROR token; the SRW.MESSAGE and RAISE SRW.PROGRAM_ABORT calls are present but commented out.

Tables Accessed

No tables are referenced directly through APPS synonyms in the documented package body. All data retrieval is delegated to the GL_INFO.GL_GET_LEDGER_INFO API, which internally reads the General Ledger set of books / ledger definitions and the associated chart of accounts to return the COA_ID, ledger name, and functional currency. GL_MESSAGE.GET_MESSAGE likewise resolves message text from the FND message repository.

Usage Notes

The package is invoked automatically by the XML Publisher report engine when the IGCBDTRR report is executed as a concurrent program. The report requires the P_SET_OF_BOOKS_ID parameter, which the user supplies or selects on the concurrent program submission form. It is not referenced by any other PL/SQL package, as confirmed by the zero inbound references, and it is not exposed as an API (classification OTHER). Customizations should avoid modifying the package body directly, since it is regenerated from the source .pls file (IGCBDTRRB.pls) during patching; extensions should instead be made to the report definition or via supported ledger APIs. The commented-out FND SRWEXIT, FND SRWINIT, and FND FLEXSQL user-exit calls indicate this is a modernized XML Publisher implementation in which the traditional Oracle Reports user exits have been replaced by direct PL/SQL API calls.