Search Results wms_catch_weight_pvt




Overview
Explore in AI Chat

Overview

WMS_CATCH_WEIGHT_PVT is a private PL/SQL package in the APPS schema that supports catch weight (CW) processing within Oracle Warehouse Management. Catch weight items are products whose weight varies from unit to unit — meat, produce, and similar commodities — where the shipping or receiving quantity must be captured in a primary UOM and a secondary (weight) UOM simultaneously. The package provides the internal logic required to validate, derive, and persist that secondary quantity across LPNs, deliveries, and shipping transactions.

The API classification "PVT" indicates that this is a private helper package. It is not intended to be called directly by customer code or standard concurrent programs; rather, it is invoked by public application programming interfaces and by other WMS packages such as INV_LPN_TRX_PUB, INV_TRANSFER_ORDER_PVT, WMS_RFID_DEVICE_PUB, and WMS_SHIPPING_INTERFACE_GRP. It also depends on FND_API, the standard Oracle Application Object Library API infrastructure, indicating that its public entry points follow Oracle's API conventions for return status and message handling.

Key Procedures and Functions

The documented interface contains 21 procedures and functions. These group into five logical areas:

Tables Accessed

The package reads and writes primarily WMS and INV transactional tables through APPS synonyms. MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS, and MTL_SYSTEM_ITEMS_KFV supply item master attributes including catch weight flags. MTL_ONHAND_QUANTITIES_DETAIL, MTL_RESERVATIONS, and MTL_MATERIAL_TRANSACTIONS_TEMP/S provide inventory quantity and reservation context during quantity validation and update. MTL_LOT_NUMBERS, MTL_TRANSACTION_LOTS_TEMP, and MTL_MATERIAL_STATUSES support lot and status-aware processing. MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, and MTL_ITEM_LOCATIONS define organizational and locator context, while MTL_UNITS_OF_MEASURE and MTL_TXN_REQUEST_LINES resolve UOM conversion and move order line data.

Usage Notes

WMS_CATCH_WEIGHT_PVT is invoked indirectly. Typical call paths include LPN transaction processing through INV_LPN_TRX_PUB, transfer order operations through INV_TRANSFER_ORDER_PVT, RFID device handling through WMS_RFID_DEVICE_PUB, and WMS shipping interface activities. In Oracle EBS 12.1.1 and 12.2.2 it participates in mobile receiving, packing, and shipping flows where a secondary quantity must be validated against a tolerance before a transaction is committed. Because the package is classified PVT and its procedures are private, customizations should never call it directly; integrators should instead invoke the supporting public APIs and allow this package to be reached through normal application flow. Where the metadata does not expose parameter signatures, the precise call interface must be confirmed against the deployed package specification in the target instance.