Search Results inv_invirdst_xmlp_pkg

Overview

APPS.INV_INVIRDST_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Reports-based concurrent program for the Inventory Distribution report (internally designated INV_INVIRDST). The "_XMLP_PKG" suffix identifies it as an Oracle XML Publisher (BI Publisher) report package auto-generated when a report is converted to the XML Publisher/XMLP engine. In EBS 12.1.1 and 12.2.2, this package acts as the report's program unit container, housing the data model and control logic that the report triggers invoke at runtime.

The package itself is oriented toward report generation rather than transactional business processing. It does not expose a public API for external application logic; instead, it serves the report definition by assembling query logic, applying user-supplied report parameters, and controlling report lifecycle events.

Key Procedures and Functions

ETRM documents three procedures/functions for this package:

• C_WHEREFORMULA — A function that dynamically constructs the WHERE clause fragment used by the report's SQL data model. It resolves the report parameters (such as organization, date range, and item filters) into a SQL predicate, enabling the main query to return only the distribution records matching the user's selection.
• BEFOREREPORT — The before-report trigger routine. It executes at the start of report execution to initialize package state, derive or validate report parameters, and prepare values required by the data model and layout.
• AFTERREPORT — The after-report trigger routine. It runs after the report completes, typically to finalize or clean up local package variables and release resources used during report generation.

These three routines form the standard XML Publisher report package pattern, in which C_WHEREFORMULA supplies dynamic filtering while BEFOREREPORT and AFTERREPORT handle pre- and post-generation setup and teardown.

Tables Accessed

The documented ETRM metadata for this package lists no direct base-table references and records no views accessed via APPS synonyms. This is consistent with XML Publisher report packages, which typically direct all data access through the report's SQL query (group/select statements) rather than through procedural DML inside the package body. The C_WHEREFORMULA routine contributes predicate text that is incorporated into that query, but it does not itself read or write table data.

Because no tables are documented, the package should be regarded as non-transactional. Its processing is read-only with respect to the schema, and its output is limited to the report dataset and layout.

Usage Notes

INV_INVIRDST_XMLP_PKG is invoked indirectly when the associated Inventory distribution report concurrent program is submitted. The report engine calls BEFOREREPORT, executes the data model query using the predicate produced by C_WHEREFORMULA, and then calls AFTERREPORT on completion. The package is therefore not intended for direct invocation from forms, custom concurrent programs, or ad hoc PL/SQL.

The ETRM metadata records that this package is referenced by zero other packages, confirming that it is a leaf dependency within the APPS schema; no other PL/SQL unit depends on it. It references only SYS.STANDARD and the standard PL/SQL runtime, indicating a self-contained report-support package. Customization should be avoided, since the package body is regenerated by the XML Publisher report definition; functional changes belong in the report definition or its parameters rather than in the package.