Search Results igc_igccyrpr_xmlp_pkg




Overview
Explore in AI Chat

Overview

The package APPS.IGC_IGCCYRPR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package that belongs to the IGC (iProcurement / Internet Government Contracting) application module within the APPS schema. Its name follows the standard Oracle Reports XML Publisher (XMLP) naming convention, in which a report executable is paired with a database package suffixed with _XMLP_PKG. This package serves as the PL/SQL support layer for an XML Publisher-based concurrent report, providing the data retrieval logic, bind parameter resolution, and formatting hooks that the Oracle Reports engine invokes at defined points during report execution.

The object holds an ETRM classification of OTHER and is documented as VALID in the APPS schema for releases 12.1.1 and 12.2.2. Because it is an auto-generated report support package rather than a published business API, it is not intended for direct invocation by end users or custom code.

Key Procedures and Functions

The documented metadata identifies eight procedures and functions. Their names correspond to the standard lifecycle hooks emitted by Oracle Reports when a report is registered as an XML Publisher concurrent program:

  • BEFOREREPORT — Fires before the report body is generated. It typically initializes package-level state and prepares the session for data retrieval.
  • AFTERREPORT — Fires after report generation completes, allowing finalization, cleanup, or reset of globals.
  • BEFOREPFORM — Fires before the parameter form is rendered, providing the opportunity to seed or default report parameters.
  • AFTERPFORM — Fires after the parameter form is submitted, used to validate or transform entered parameter values before query execution.
  • BETWEENPAGE — Fires between page breaks, supporting page-level reset or aggregation logic and page numbering context.
  • SET_OF_BOOKS_NAME_P — A function that returns the set of books name associated with the report session, resolving the ledger context for the report output.
  • CURRENCY_CODE_P — A function returning the currency code applied to report amounts, ensuring consistent monetary presentation.
  • ORG_NAME_P — A function returning the operating unit or organization name relevant to the report parameters, used to display organizational context on the report.

No parameter lists are exposed in the ETRM metadata; each of the three _P functions is a parameter value provider typical of generated XML Publisher report packages.

Tables Accessed

The documented metadata for IGC_IGCCYRPR_XMLP_PKG does not enumerate any referenced tables. It lists only a dependency on SYS.STANDARD, which confirms the package relies on base PL/SQL constructs and does not directly name application tables in the ETRM extract. In practice, report support packages of this type read data through the report's SQL query rather than through explicit table references in the package body, so table access is indirect. The package is itself referenced by no other packages, indicating it sits at the top of its dependency chain as an entry point invoked by the report engine.

Usage Notes

This package is invoked automatically by the Oracle Reports runtime when the associated concurrent program is submitted through the Standard Request Submission form or from the concurrent manager. Developers do not call its procedures directly. It is commonly referenced when troubleshooting XML Publisher report errors, since failures in BEFOREREPORT or the _P functions surface as report execution exceptions. Customizations should target the underlying report definition or a copy of the package rather than the shipped object, because the package is regenerated and overwritten during patching. Its presence is consistent across both 12.1.1 and 12.2.2, where it remains a VALID object in the APPS schema.