Search Results launch_pick_release

Overview

WSH_DPW_PICK_RELEASE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type. Its principal purpose is to provide programmatic support for the Departure Planning Workbench (DPW), a form-based shipping execution tool used to group and release deliveries and departures for outbound logistics. Specifically, the package exposes a single public function, Launch_Pick_Release, which orchestrates the release of material for picking directly from the Departure Planning Workbench form.

The package abstracts the multi-step business process required to move a departure, delivery, or warehouse selection into an active picking state. This includes retrieving the default shipping parameters configured for Pick Release, constructing a picking batch, and submitting the Pick Release concurrent program. By centralizing this logic, the package ensures that the Departure Planning Workbench form behaves consistently with the standalone Pick Release SRS (Concurrent Program) and honors the same shipping parameter defaults. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, allowing it to be safely exposed to form-based invocations where the user's security context should apply.

Key Procedures and Functions

• Launch_Pick_Release — The sole documented function in the package. It accepts inputs identifying the departure to release, the delivery to release, and the warehouse from which the release should occur. Its return value is the request ID of the launched Pick Release concurrent program, allowing callers to track or reference the submitted job. The function performs four discrete operations: it fetches the default shipping parameters applicable to Pick Release, it creates a picking batch, it launches the Pick Release concurrent program, and finally it writes any error messages to the FND message stack for display back to the user through the form.

Tables Accessed

The ETRM metadata excerpt does not enumerate specific base tables referenced through APPS synonyms; the package header confirms the operations rather than the physical schema objects. Functionally, the process requires reading default shipping parameters maintained in the WSHP (shipping parameters) configuration area and inserting into the picking batch tables that underpin the Pick Release workflow, namely the WSH_PICKING_BATCHES and related picking detail tables. The package also indirectly causes records to be created or updated in the delivery and delivery detail tables (WSH_NEW_DELIVERIES, WSH_DELIVERY_ASSIGNMENTS) as delivery lines are reserved and released. Message text for the FND stack is drawn from the FND message repository.

Usage Notes

Typical invocation occurs from the Departure Planning Workbench form, where a user selects a departure or delivery and triggers Pick Release. The form calls Launch_Pick_Release and uses the returned request ID to monitor concurrent processing, while any validation failures are surfaced through the FND message stack. Because the function encapsulates default-parameter lookup, batch creation, and concurrent submission, it is well suited for custom extensions that need to release deliveries programmatically without reimplementing that logic. Callers should be aware that the package is flagged as an "OTHER" API classification, indicating it is not a formally versioned public API with guaranteed backward compatibility; custom code should treat it with the caution appropriate to an internal shipping utility and validate behavior against the target EBS release (12.1.1 or 12.2.2). Since the package publishes only one function and is not referenced by any other documented package, its dependency footprint is narrow and it is intended primarily as a form-layer helper rather than a general-purpose integration API.