Search Results wms_rule_put_pkg3

Overview

APPS.WMS_RULE_PUT_PKG3 is a public PL/SQL package within the Oracle Warehouse Management System (WMS) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It supports the putaway rule engine that determines where received inventory should be directed within the warehouse. The package provides the low-level cursor control routines that open, fetch, and close the underlying putaway rule evaluation cursor defined by the WMS_RULE_PVT package type cv_put_type. This cursor encapsulates the set of candidate putaway destinations produced by the WMS rule engine, and the procedures in WMS_RULE_PUT_PKG3 allow a caller to iterate through those candidates, retrieve each matching subinventory, locator, project, and task combination, and release the cursor when processing is complete.

The package is classified in the ETRM repository as an "OTHER" API object rather than a formal business API. It functions as an internal helper used by higher-level WMS putaway processing rather than as a user-facing integration point.

Key Procedures and Functions

The package exposes three documented procedures, each addressing one phase of cursor lifecycle management for putaway rule evaluation:

• EXECUTE_OPEN_RULE — Opens and positions the putaway cursor for a specific rule. It accepts the caller's cursor variable along with the rule identifier and a set of contextual inputs describing the item being put away, including organization, inventory item, transaction type, subinventory, locator, temporary transaction identifier, subinventory/locator restriction codes, project, and task. It returns a result indicator through an OUT parameter. This procedure establishes the working set of candidate putaway locations.
• EXECUTE_FETCH_RULE — Fetches the next matching destination from the cursor opened by EXECUTE_OPEN_RULE. It returns the resolved subinventory code, locator identifier, project identifier, and task identifier through OUT parameters, along with a return status. This is the procedure most relevant to the search term "execute_fetch_rule," as it is the per-row iteration routine invoked repeatedly to enumerate eligible putaway targets.
• EXECUTE_CLOSE_RULE — Closes the putaway cursor associated with the given rule, releasing resources once iteration is complete.

Tables Accessed

The ETRM metadata does not enumerate specific base tables or APPS synonyms accessed by this package. Based on the parameter set and the nature of putaway rule evaluation, the package operates against the WMS rule and putaway definition data — including rule configuration, item-subinventory and item-locator relationships, and locator-level capacity and restriction attributes — as surfaced through the PL/SQL cursor declared in WMS_RULE_PVT. Because it works through a strongly typed cursor rather than direct DML, the exact underlying tables are resolved within the cursor definition and associated rule engine packages.

Usage Notes

WMS_RULE_PUT_PKG3 is not intended to be called directly by end users. It is invoked by other WMS packages that implement putaway rule selection, particularly the rules engine that builds and consumes the cv_put_type cursor. The metadata records that the package is referenced by one other package, consistent with its role as a supporting routine within the putaway subsystem. In practice, it is engaged during receiving and putaway transactions processed through the WMS mobile forms and related putaway logic, as well as by any custom code that must programmatically resolve a valid putaway destination for an item. The standard pattern is to call EXECUTE_OPEN_RULE once, loop over EXECUTE_FETCH_RULE until no further rows are returned, and then call EXECUTE_CLOSE_RULE to clean up. Because the procedures use NOCOPY OUT parameters, callers should treat returned values as valid only for the duration of the fetch cycle and should not rely on them after the cursor is closed.