Search Results igc_igcbdtrr_xmlp_pkg

Overview

IGC_IGCBDTRR_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the execution of an Oracle Reports XML Publisher (XMLP) concurrent program. The package name follows the standard EBS XML Publisher generated-package naming convention, in which the base report name is suffixed with _XMLP_PKG. In this case, the underlying report is IGC_IGCBDTRR, an IGC (Contract Management / Grants) report associated with the balanced trial balance or related transactional reporting area. The package encapsulates the report's PL/SQL execution logic, including its before-report and after-report triggers, so that the report can be run from the Concurrent Manager in the standard Oracle EBS 12.1.1 or 12.2.2 environment. It exists solely to service this one report and is not intended as a reusable API. The object is documented with an API classification of OTHER, indicating it is an internal report-support package rather than a public integration API.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within this package. Their purposes, based on standard XML Publisher report package conventions, are as follows:

• BEFOREREPORT — Executed before the report data model runs. It is typically used to initialize session context, set up global or package-level variables, initialize the Oracle Reports lexical parameters, and prepare any required runtime state for the report query.
• AFTERREPORT — Executed after the report has completed. It is typically used to clean up package state, reset globals, or release resources once the report output has been produced.
• STRUCT_NUM_P — A function or procedure associated with the STRUCT_NUM (structure number) report parameter. It supplies or validates the structure number value used by the report's data retrieval logic.
• SET_OF_BOOKS_NAME_P — Provides or resolves the Set of Books Name parameter. In multi-organization and multi-ledger EBS environments this value is used to filter ledger-specific data within the report query.
• FUNCTIONAL_CURRENCY_P — Supplies the functional currency of the selected ledger or set of books, which is used for currency conversion and display formatting in the report output.
• FLEX_SELECT_ALL_P — Supports the Flexfield Select All parameter behavior, enabling the report to interpret the key flexfield selection range used to filter report data.

These procedures together form the runtime shell around the report query, parameterizing it and preparing session context rather than performing complex business logic.

Tables Accessed

The documented metadata lists no tables directly accessed by this package. This is consistent with the typical behavior of XML Publisher report packages, which generally do not perform direct DML. Instead, the actual data retrieval is delegated to the underlying Oracle Reports data model or to SQL statements executed by the report engine, while this package only manages parameters and session initialization. Any table access occurs indirectly through the report definition rather than through the package's own SQL.

Usage Notes

IGC_IGCBDTRR_XMLP_PKG is not called directly by other packages. The dependency metadata records zero referencing packages, confirming that it is invoked exclusively by its associated concurrent program and the Oracle Reports runtime. When the IGC_IGCBDTRR report concurrent program is submitted, the XML Publisher engine automatically calls BEFOREREPORT before data retrieval and AFTERREPORT after output generation. The remaining procedures supply the individual report parameters (structure number, set of books name, functional currency, and flexfield select-all) required at runtime. Because the package is report-private, it should not be referenced in custom code; customizations should instead extend the report via XML Publisher templates or by adding parameters through the standard report registration. Any modification risks breaking the concurrent program, and the package should be treated as read-only reference material.