Search Results inv_invircxr_xmlp_pkg

Overview

APPS.INV_INVIRCXR_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite APPS schema that supports the XML Publisher (BI Publisher) report known internally as INV_INVIRCXR_XMLP. The naming convention follows the standard Oracle Reports-to-XML-Publisher migration pattern: the "XMLP" suffix indicates the package accompanies a concurrent program whose output is generated as XML data rather than through the legacy Oracle Reports engine, while the "INV" prefix and the ETRM classification confirm that the object belongs to the Oracle Inventory application family. The package is documented as VALID in both 12.1.1 and 12.2.2, and its API classification is recorded as OTHER, meaning it is not a published public API but an internal report-support package.

In functional terms, the package provides the PL/SQL logic that drives the report's data selection and formatting cycle. It is registered as a concurrent program component, and the XML Publisher runtime invokes its report-level entry points during execution. The metadata shows it depends only on the SYS.STANDARD package (the implicit PL/SQL base package) and is referenced solely by itself, confirming that it is a self-contained report package with no downstream consumers.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions, all of which are standard Oracle XML Publisher report block hooks rather than business API entry points:

• BEFOREREPORT — The before-report trigger. This procedure is invoked once at the start of report execution, before any data or layout groups are processed. It is normally used to initialize package-level variables, resolve report parameters, and set up the runtime environment for the report's queries.
• AFTERREPORT — The after-report trigger. This procedure executes once after all report sections have been generated. It typically handles cleanup, resets package state, or performs any final processing required before the concurrent program completes.
• G_BODYGROUPFILTER — A group filter function associated with the report's data model. In the XML Publisher framework, group filters are evaluated for each row of a data group to determine whether that row should be included in the output. This function implements the filtering logic for the report's body group.

No parameter lists or additional logic are recorded in the documentation, and this article deliberately does not speculate on them.

Tables Accessed

The documented metadata records no table references through APPS synonyms. This is consistent with the observed dependency footprint: the package's only declared reference is to SYS.STANDARD. In practice, a package of this type would read Inventory data through SQL embedded in its report queries, but because no such references are documented, none are asserted here. Consumers should treat the table-access profile as limited to what the underlying report query defines.

Usage Notes

INV_INVIRCXR_XMLP_PKG is not intended to be called from forms, custom code, or other PL/SQL packages. It is invoked by the concurrent manager as part of the associated XML Publisher concurrent program submission. The metadata confirms that zero packages reference it, reinforcing that it is an execution-only report component. Developers investigating an Inventory report issue should treat this package as diagnostic context — confirming the report's packaging and runtime hooks — rather than as an integration point for custom development.