Search Results execute_open_rule

Overview

APPS.WMS_RULE_PUT_PKG3 is a PL/SQL package in the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. It belongs to the putaway rule engine, the component that determines where incoming material should be directed within a warehouse based on user-defined putaway rules. The package exposes an API classification of OTHER within ETRM, meaning it is not a formally published public interface but an internal implementation unit consumed by higher-level WMS rule processing logic.

The central role of WMS_RULE_PUT_PKG3 is to manage the lifecycle of a cursor-driven evaluation of putaway rules. Rather than evaluating an entire rule set in a single call, the package implements an open/fetch/close pattern that allows callers — most notably the parent packages in the WMS_RULE_PVT family — to open a rule cursor, iterate through candidate putaway destinations one row at a time, and release resources when evaluation completes. This pattern is important in WMS because putaway rule evaluation can involve large numbers of candidate subinventories and locators, and row-by-row processing permits the caller to apply additional constraints or short-circuit processing once a satisfactory destination is found.

Key Procedures and Functions

The package declares three documented procedures, all public within the package specification.

• EXECUTE_OPEN_RULE — Opens the putaway rule cursor for a specific rule and organization context. It accepts a cursor variable as an IN OUT NOCOPY parameter, the rule identifier, the organization, the inventory item, the transaction type, the subinventory code, the locator, a putaway transaction temporary identifier, restriction codes for subinventories and locators, and project/task identifiers. It returns a result status. This is the procedure referenced by the search term "execute_open_rule," and it is the entry point for putaway rule evaluation.
• EXECUTE_FETCH_RULE — Fetches the next candidate putaway destination from a cursor previously opened by EXECUTE_OPEN_RULE. It returns the subinventory code, locator identifier, project identifier, task identifier, and a return status for the fetch operation.
• EXECUTE_CLOSE_RULE — Closes the putaway rule cursor associated with a given rule identifier, releasing the associated resources. This procedure takes the rule identifier and the cursor variable.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables; the documented metadata records no tables referenced via APPS synonyms. In practice, putaway rule processing in WMS reads rule definition and rule detail tables (such as WMS_RULES and its detail tables) along with inventory organization, item, subinventory, and locator data. Because the metadata does not document these accesses explicitly, the table list should be confirmed through the package body or through runtime tracing rather than assumed from the rule engine's general behavior.

Usage Notes

WMS_RULE_PUT_PKG3 is not intended for direct invocation from Oracle Forms or concurrent programs. The ETRM metadata indicates it is referenced by one other package, which is consistent with its design as a helper unit for the WMS putaway rule processing stack. Customizations and extensions should call the higher-level WMS_RULE_PVT entry points rather than this package, unless the customization is specifically replicating the open/fetch/close cursor pattern for a bespoke putaway scenario.

Because the procedures expose NOCOPY cursor and OUT parameters, callers must initialize the cursor and rule identifier correctly and must always pair EXECUTE_OPEN_RULE with EXECUTE_CLOSE_RULE to avoid leaking cursor resources. The result and return status values returned by the open and fetch procedures should be checked before proceeding, in line with standard Oracle EBS API error-handling conventions. The package is present in both 12.1.1 and 12.2.2; no online patching-specific behavioral differences are documented in the metadata provided.