Search Results form_pick_confirm

Overview

APPS.GMI_PICK_WAVE_CONFIRM_PVT is a private (PVT) PL/SQL package in Oracle Process Manufacturing (OPM), delivered under the APPS schema and declared with AUTHID CURRENT_USER. Its source file, GMIVPWCS.pls, originates from Oracle's TVP development group in Reading, England, and dates to May 2000. The package encapsulates the private routines that support Pick Wave Confirmation—the process by which staged material movement orders are confirmed as physically picked from inventory and released against a delivery. It sits beneath the public OPM pick-confirmation API surface and is not intended for direct customer invocation.

The packaging of these routines as PVT reflects their role as internal implementation logic: validation, inventory balancing, shipping-tolerance checking, and the orchestration of the move-order line updates that ultimately generate pending inventory transactions. Because the package performs writes to inventory and transaction tables, it is tightly coupled to the OPM inventory schema, the order-management schema, and the shipping (WSH) schema.

Key Procedures and Functions

• PICK_CONFIRM — The principal driver routine. It confirms a pick for a given delivery detail, coordinating validation, quantity derivation, and inventory transaction creation. Bug 2296620 extended it with a manual-pick parameter to support ship-set functionality.
• CHECK_SHIP_SET — Introduced by the same ship-set enhancement. It evaluates whether a pick line belongs to a ship set, enforcing ship-set completeness rules so that all members of a set are confirmed consistently.
• CHECK_REQUIRED — Performs mandatory-field and prerequisite validation for the confirmation request.
• CHECK_SHIPPING_TOLERANCES — Verifies that picked quantities fall within configured shipping tolerance thresholds before confirmation proceeds.
• BALANCE_NONCTL_INV_TRAN — Added under Enhancement 2320442 (Lakshmi Swamy). Balances non-control-lot inventory transactions, returning available quantities and a pending transaction row.
• GET_OPM_CONVERTED_QTY — Returns quantities converted into OPM inventory units of measure for use in downstream confirmation logic.
• FORM_PICK_CONFIRM — A form-oriented entry point that prepares or presents confirmation data for the Pick Confirmation user interface.

Tables Accessed

The package reads and writes a broad inventory footprint. Transaction staging is handled through IC_TRAN_PND, which receives the pending inventory transactions generated during confirmation. Item, warehouse, and location validation rely on IC_ITEM_MST, IC_WHSE_MST, IC_LOCT_MST, and IC_LOCT_INV, with IC_LOCT_INV also supplying on-hand balances. Lot and lot-status handling uses IC_LOTS_MST and IC_LOTS_STS. Movement-order lines are processed via IC_TXN_REQUEST_LINES. Delivery and order context are drawn from WSH_DELIVERY_DETAILS and OE_ORDER_LINES_ALL respectively. PLITBLM is referenced for OPM conversion data, and USER_OBJECTS is queried for existence checks.

Usage Notes

Because this is a PVT package, it is invoked indirectly—typically from the Pick Confirmation form flow (through FORM_PICK_CONFIRM and PICK_CONFIRM), from the public OPM pick-confirmation API, or from concurrent programs that confirm staged picks in batch. Four other packages reference it, indicating reuse across the OPM picking and shipping stack. Customizations should call the supported public API rather than this private package, since the PVT interface is subject to change between releases. The NOCOPY hints on OUT parameters and the AUTHID CURRENT_USER declaration are notable implementation details preserved across 12.1.1 and 12.2.2.