Search Results inv_invtrshs_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.INV_INVTRSHS_XMLP_PKG package body is the server-side PL/SQL implementation that supports the Oracle EBS Inventory transaction history report, internally identified by the concurrent program short name INVTRSHS. The "_XMLP_PKG" suffix indicates that the package is bound to an XML Publisher (BI Publisher) report definition, and the package constitutes the data model logic that the XML Publisher engine invokes at runtime. In EBS 12.1.1 and 12.2.2, the package resides in the APPS schema with a status of VALID and is classified as an OTHER API in the ETRM repository.

Functionally, the package assembles the reporting data set for the Inventory Transaction Historical Summary report. It resolves report parameters, constructs the dynamic WHERE clauses and cursor definitions that drive the main query, computes derived quantities, and controls the optional notification behavior. The package does not expose a general-purpose business API; it is a report-specific data model construct executed by the XML Publisher concurrent program framework.

Key Procedures and Functions

The ETRM metadata documents 20 procedures and functions. They fall into distinct categories:

The naming convention confirms that these are dynamic SQL fragment generators rather than computational APIs. No parameter lists are documented.

Tables Accessed

The ETRM dependency list identifies the following objects referenced by the package:

  • MTL_CATEGORY_SETS — supplies category set definitions used to resolve category set names and to build the category WHERE and FROM clauses.
  • MTL_SECONDARY_INVENTORIES — provides subinventory context, including subinventory-level attributes used in the report restrictions and parameter defaults.
  • MTL_ITEM_QUANTITIES_VIEW — the on-hand quantity view read to compute net quantities and on-hand-only filtering.
  • MFG_LOOKUPS — supplies lookup meanings for report parameter values.
  • FND_GLOBAL — provides the runtime user identity and concurrent request context (user_id, responsibility, org) used throughout the formulas.
  • INV_SHORTCHECKEXEC_PVT and STANDARD — invoked by the SEND routine for output/notification handling.

The package is listed as not referenced by any other database object, confirming it is a terminal report artifact.

Usage Notes

This package is invoked exclusively by the XML Publisher concurrent program architecture. When the INVTRSHS report is submitted, the framework calls BEFOREREPORT to initialize state, calls BEFOREPFORM/AFTERPFORM around parameter entry, evaluates the C_*FORMULA functions to assemble the report SQL, executes the query against MTL_ITEM_QUANTITIES_VIEW with restrictions supplied by MTL_CATEGORY_SETS and MTL_SECONDARY_INVENTORIES, and finally calls SEND for output/notification handling before AFTERREPORT. Because no other database object depends on it, the package should be modified only through the standard report data model definition and only by authorized developers. Direct custom invocation is not supported; any customer extension should target a copy of the report definition rather than the seeded package body in the APPS schema. In 12.2.2 the object retains the same name, owner, and VALID status as in 12.1.1, with the XML Publisher binding unchanged.