Search Results get_order_header_id

Overview

The APPS.WSH_PICKING_BATCHES_GRP package body is a group-type PL/SQL API within the Oracle E-Business Suite Warehouse Management (WSH) module. It provides the transactional infrastructure used to consolidate outbound sales order delivery lines into picking batches, drive those batches through the pick-release cycle, and hand off eligible waves to the Warehouse Management System (WMS) for execution. The package operates as a sub-component of the public interface layer, WSH_PICKING_BATCHES_PUB, which exposes the batch and release operations to forms, concurrent programs, and custom integrations while this group package performs the underlying validation, data defaulting, and DML.

In release 12.1.1 and 12.2.2, picking batches are a prerequisite for generating pick slips and for sequenced picking activities on the warehouse floor. The group package therefore represents the boundary between order-management demand and warehouse execution.

Key Procedures and Functions

The ETRM metadata documents three procedures:

• CREATE_BATCH — Validates the supplied batch parameters and creates a picking batch record. It accepts an API version number, a message-list initialization flag, a commit flag, a picking rule identifier and/or picking rule name used for defaulting purposes, a batch information record, and a batch prefix; it returns the standard return status, message count, and message data, plus the newly created batch identifier. The procedure is called from WSH_PICKING_BATCHES_PUB. Current documented version is 1.0.
• RELEASE_BATCH — Releases a previously created picking batch so that its lines become available for picking and downstream pick-slip generation. It is the state-transition counterpart to Create_Batch.
• RELEASE_WMS_WAVE — Releases wave lines to the WMS for warehouse execution, spanning the integration boundary between Oracle EBS picking and the external warehouse management engine.

All three follow the FND_API group-API convention: a version number, p_init_msg_list, p_commit, and the x_return_status, x_msg_count, x_msg_data out-parameters. No alternative parameter lists are documented.

Tables Accessed

The package reads and writes the following APPS-synonym tables:

• WSH_PICKING_BATCHES — the primary batch header table, written by CREATE_BATCH and updated by RELEASE_BATCH.
• WSH_PICKING_RULES — supplies picking-rule defaulting referenced by the rule ID or rule name parameters.
• WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES — delivery and delivery-line detail used to populate and qualify batch contents.
• WMS_WP_WAVE_LINES — wave lines consumed by RELEASE_WMS_WAVE.
• OE_ORDER_HEADERS_ALL, OE_TRANSACTION_TYPES_TL, and OE_SETS — order headers, transaction type translations, and set definitions used for order-level validation and defaulting.
• MTL_SYSTEM_ITEMS, MTL_ITEM_CATEGORIES, MTL_CATEGORY_SETS, and MTL_ITEM_LOCATIONS — item, category, and locator attributes used to filter and validate batching and picking eligibility.
• PLITBLM — the PL/SQL table/message buffer used within the FND message stack.

Usage Notes

The package is not intended for direct invocation. It is called by WSH_PICKING_BATCHES_PUB, which is in turn referenced by five other packages in the ETRM inventory. Typical entry points are the Picking Batches and Release Picking Batches forms, the Pick Release concurrent programs, and Warehouse Management wave-processing flows. Custom code should call the public layer, not this group package, and should honour the p_init_msg_list and p_commit conventions: pass FND_API.G_FALSE to retain messages when the caller must inspect them, and commit only at the outermost transaction boundary. The header comments identify version 1.0 as the initial documented version.