Search Results update_drop_locator_for_task

Overview

WMS_OP_RUNTIME_PUB_APIS is a public PL/SQL package owned by APPS in Oracle E-Business Suite. It exposes the run-time application programming interfaces for Warehouse Management System (WMS) operation plans, which govern the execution of warehouse tasks such as picking, dropping, and LPN (License Plate Number) movement within the warehouse. The package specification is contained in the source file WMSOPPBS.pls and was originally created in October 2002; the header indicates version 1.0 as the current version. In Oracle EBS 12.1.1 and 12.2.2, this package serves as a callable boundary through which warehouse run-time logic is validated and applied, allowing other Oracle modules and custom extensions to query and update the state of dispatched warehouse tasks without directly manipulating the underlying WMS operation plan tables. The API classification is OTHER, reflecting that it is neither a standard open interface nor a pure validation package, but rather a mixed run-time utility interface.

Key Procedures and Functions

The package exposes three documented procedures. Each follows the Oracle EBS convention of returning status and message out parameters so that callers can detect success or failure without raising exceptions.

• UPDATE_DROP_LOCATOR_FOR_TASK — Updates the drop locator associated with a warehouse task. It returns the return status, a message, and a drop LPN option, and accepts a transfer LPN identifier as input. This procedure is used when the destination (drop) location for an in-flight task must be changed, for example when a transfer LPN is redirected.
• VALIDATE_PICK_DROP_LOCATOR — Validates that a given locator is a permissible pick or drop location for a specific task. It returns status and message, and accepts a task type, task identifier, and locator identifier as inputs. This is typically invoked before confirming a task to ensure the target locator satisfies warehouse rules.
• LOCK_ORG_PROC — A documented procedure used to serialize operations against the warehouse organization, preventing concurrent modification of operation plan data. It is not shown in the source excerpt but is captured in the documented procedure list.

Tables Accessed

The package accesses several base tables through APPS synonyms. WMS_DISPATCHED_TASKS holds the dispatched warehouse tasks that are read and updated during run-time processing, and WMS_OP_PLANS_B and WMS_OP_PLAN_DETAILS store the operation plan header and detail records that drive task execution. MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_PARAMETERS support inventory transaction staging and organization-level parameter validation. WSH_DELIVERY_DETAILS links warehouse tasks to shipping delivery details, ensuring that task updates remain consistent with outbound shipment data. PLITBLM is the standard Oracle PL/SQL integer-indexed table type used internally for bulk parameter handling. Together these tables allow the package to reconcile warehouse execution with inventory and shipping records.

Usage Notes

WMS_OP_RUNTIME_PUB_APIS is invoked at run time rather than as a batch interface. Typical callers include WMS mobile and desktop forms, the warehouse task execution flows, and custom code that must validate or redirect tasks. The package is referenced by two other packages, indicating that it forms part of the internal dependency chain for warehouse execution. Because it is a PUBLIC package with a declared specification, Oracle supports calling the documented procedures from custom PL/SQL; callers should always inspect the returned status and message parameters and should not update the underlying WMS tables directly. The procedures are not designed for high-volume concurrent execution without appropriate locking, which is why LOCK_ORG_PROC is provided. Organizations upgrading from 12.1.1 to 12.2.2 should re-verify behavior, since the package was authored under an earlier WMS code line and its internal dependencies may be patched independently of the specification.