Search Results inv_minmax_helper_pvt

Overview

INV_MINMAX_HELPER_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API within the ETRM repository. Its name identifies it as a helper package associated with the Oracle Inventory min-max planning functionality, which is used to replenish inventory items by comparing on-hand quantities against minimum and maximum stocking levels. The package is declared with AUTHID CURRENT_USER, meaning its executable privileges and name resolution are evaluated in the context of the calling user rather than the definer, a pattern commonly used for internal utility code that runs under the caller's schema privileges.

The header comment ($Header: INVMMXDS.pls 115.0 2001/02/12 17:51:18 pkm ship $) indicates the package dates to the early 11i code line and has remained essentially unchanged through the 12.1.1 and 12.2.2 releases. As a private package, it is not exposed as a published integration point and is not intended to be called directly by external applications or custom code.

Key Procedures and Functions

The ETRM documentation records a single documented function in this package:

• GET_SHIPPED_QTY — Returns the shipped quantity for a given inventory item within an organization, scoped to a specific order line. The function accepts an organization identifier, an inventory item identifier, and an order line identifier, and returns a numeric shipped quantity value. Its purpose is to support min-max planning logic by supplying the quantity already shipped against the referenced order line, which the planning calculation uses when evaluating replenishment requirements and net demand.

No other procedures or functions are documented for this package in the ETRM metadata. Consistent with its private helper designation, the package exposes no public API surface intended for third-party invocation.

Tables Accessed

The package references one documented table through an APPS synonym:

• MTL_MATERIAL_TRANSACTIONS — The Inventory transaction table, which records all material movements including shipments, receipts, issues, and transfers. GET_SHIPPED_QTY reads this table to derive the shipped quantity associated with the specified organization, item, and order line, filtering on transaction types that represent shipping activity.

No additional tables are documented in the ETRM metadata for this package.

Usage Notes

INV_MINMAX_HELPER_PVT is referenced by zero other packages according to the ETRM metadata, indicating that it is either invoked only from within the min-max planning code path at a level not captured as a package-to-package dependency, or that it is legacy helper code retained for backward compatibility. Typical invocation contexts for a package of this type include the Inventory min-max planning concurrent program (such as the Min-Max Planning Report), Oracle Inventory forms that perform replenishment calculations, and internal planning routines that need to net shipped quantities against supply.

Because the package is classified as PVT and is not documented as a public API, it should not be called from custom concurrent programs, forms personalizations, or integration code. Customizations requiring min-max shipped quantity data should instead query MTL_MATERIAL_TRANSACTIONS directly using supported views such as MTL_MATERIAL_TRANSACTIONS_V or the corresponding public Inventory APIs. Direct calls to private packages risk breakage during patching or upgrade, since Oracle does not guarantee signature stability for PVT-classified objects between releases.