Search Results gmi_pick_release_pvt




Overview
Explore in AI Chat

Overview

GMI_Pick_Release_PVT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a private (PVT) API within the Process Manufacturing (GMI) application. Its documented purpose is to encapsulate the business logic associated with the Process Manufacturing pick release process. Pick release is the warehouse operation in which inventory is allocated to demand and staged for shipment; in a process manufacturing context this activity is driven by move orders rather than by the discrete sales order line flow, and GMI_Pick_Release_PVT supplies the procedural machinery that performs the allocation for an individual move order line. The package header carries a version marker of 1.0 and a short history indicating it was created in May 2000, placing it among the earlier components of the Process Manufacturing inventory and order fulfilment stack. Because it is a private API, it is not a supported public interface; Oracle exposes it for use by the GMI application's own forms and concurrent processing, and customers are expected to reach pick release functionality through those supported entry points rather than by calling the package directly.

Key Procedures and Functions

The documented package specification contains a single public program unit, PROCESS_LINE. Its role is to process one move order line through pick release, validating the supplied move order header and line context, applying the grouping rule and print mode supplied by the caller, honouring the partial pick and delete allowances, and returning a count of detail records produced together with the standard FND_API return status, message count, and message data outputs. The parameters are exposed through named record types defined in GMI_Move_Order_Global, namely mo_hdr_rec and mo_line_rec, which pass the move order header and line attributes into the routine. The procedure also accepts an API version number and adopts the conventional FND_API validation and commit flags, meaning the caller controls whether validation is performed and whether the unit of work is committed or left for the calling transaction to manage. No other procedures or functions are documented in the specification.

Tables Accessed

Through APPS synonyms the package touches a focused set of inventory and shipping tables. MTL_SYSTEM_ITEMS and MTL_SECONDARY_INVENTORIES supply item and subinventory validation and attribute information needed to determine whether and from where a line may be picked. MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES provide the transaction type and source type identifiers stamped on the resulting inventory transactions. IC_TRAN_PND is the Process Manufacturing pending transaction interface into which the allocation transactions are staged before posting to the inventory transaction tables. WSH_DELIVERY_DETAILS links the move order line to its shipping delivery detail, connecting pick release to the Oracle Shipping execution model. PLITBLM is a temporary PL/SQL table used for in-process data handling. The write activity concentrates on IC_TRAN_PND, with the remaining tables read largely for validation and derivation.

Usage Notes

This package is invoked by the Process Manufacturing pick release forms and by concurrent programs that drive move order release, and it is referenced by one other package in the ETRM inventory. It is not intended for direct customer invocation, and any custom code should prefer supported public APIs or the standard pick release concurrent programs. Callers that do use it must supply a valid API version, the move order header and line records, an appropriate grouping rule, and the print and partial pick options, and must inspect x_return_status and the message stack before proceeding.