Search Results igi_igilgccd_xmlp_pkg

Overview

IGI_IGILGCCD_XMLP_PKG is a generated PL/SQL package in the APPS schema that supports the Oracle EBS concurrent program IGI_IGILGCCD, an XML Publisher (BI Publisher) report delivered within the IGI (Intellectual Property/Government, Internal Controls and Grants) product family. The package is an XMLP integration wrapper: its role is to define the report-level global variables and the report trigger functions that the Oracle Reports/XML Publisher concurrent processing engine requires in order to execute the underlying report definition and produce XML output for a template.

The package is part of the standard Oracle EBS 12.1.1 and 12.2.2 installation and is documented with an API classification of OTHER. It is not a callable business API; it is infrastructure code generated automatically when an Oracle Reports executable is registered for XML Publisher output. It owns no business logic of its own and contains no DML statements, no table access and no complex cursors described in the ETRM metadata.

Key Procedures and Functions

Two functions are documented, both of which are standard XML Publisher report-level triggers:

• BEFOREREPORT — Executed once before the report body is processed. In generated XMLP packages this function typically performs setup work such as evaluating the concurrent request parameters, initializing report-level state, and returning a Boolean indicating whether report execution should continue. For IGI_IGILGCCD the relevant parameter is P_NO_DATA, a VARCHAR2(8) package global that governs the no-data handling behaviour of the report.
• AFTERREPORT — Executed once after the report body has completed. It performs post-processing and clean-up, and returns a Boolean success indicator. In most generated XMLP packages AFTERREPORT is deliberately minimal, since the XML output is streamed by the concurrent manager.

The package also declares the global variables P_NO_DATA (VARCHAR2(8)), P_CONC_REQUEST_ID (NUMBER), P_RUN_AOL (VARCHAR2(1), default 'Y') and P_DEBUG_SWITCH (VARCHAR2(1), default 'N'). These are populated by the XML Publisher runtime and are read by the report query and triggers.

Tables Accessed

The ETRM metadata records no referenced tables for this package. This is consistent with its role as a report trigger container: the data extraction for the IGI_IGILGCCD report is performed by the report's own query, not by the PL/SQL package. Any table access associated with the report (for example, IGI-managed grant, award or cost-related entities implied by the IGILGCCD naming) occurs in the report SQL rather than in this package. Because no DML is documented, the package can be treated as read-only with respect to application data.

Usage Notes

IGI_IGILGCCD_XMLP_PKG is invoked implicitly by the Oracle EBS concurrent processing framework whenever the associated XML Publisher report is submitted. It is referenced by zero other PL/SQL packages, confirming that no application code calls it directly; it should not be invoked from forms, custom concurrent programs or ad hoc PL/SQL. The source header records version 120.0.12010000.1, dated 29 July 2008, and the package has not been customised in the documented delivery.

The parameter most relevant to users searching for "p_no_data" is the package global P_NO_DATA. It is set by the XML Publisher runtime based on the concurrent program's no-data parameter, and it controls how the report behaves when the extract returns no rows. When P_NO_DATA is set to values such as 'N', the report suppresses output rather than emitting an empty XML document; alternative settings allow the empty report to be produced. This variable should therefore be checked when diagnosing reports that terminate silently or produce empty output. Because the value is derived from the concurrent program definition, corrections are made by amending the concurrent program parameter defaults rather than by modifying the package.