Search Results wms_rule_10




Overview
Explore in AI Chat

Overview

WMS_RULE_10 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, holding a VALID status in both the 12.1.1 and 12.2.2 releases. It belongs to the warehouse management execution layer and participates in the rule-based processing framework used by Oracle Warehouse Management (WMS). The package encapsulates a self-contained querying construct, sometimes referred to as a cursor package, whose primary role is to isolate and deliver a specific data retrieval operation required by the WMS rule engine. Rather than exposing a broad API surface, WMS_RULE_10 provides a narrow, purpose-built cursor primitive invoked by higher-level rule evaluation logic to select item, subinventory, and locator data needed during directed picking, put-away, or inventory movement decisions.

Key Procedures and Functions

The documented program units for this package body are three in number and are tightly coupled, forming the open-fetch-close pattern typical of explicit cursor handling.

  • OPEN_CURS — Opens the package's internal cursor, binding any required parameters and initiating the result set that the rule engine will consume. It establishes the active context for subsequent row retrieval.
  • FETCH_ONE_ROW — Retrieves a single row from the open cursor, returning the selected column values to the caller. This granular retrieval supports rule evaluation that iterates row by row until a qualifying record is identified.
  • CLOSE_CURS — Closes the cursor and releases associated resources once the caller has completed its fetch loop or has determined that no further evaluation is required.

No parameter lists are documented in the ETRM metadata, and none are inferred here. The API classification is listed as OTHER, indicating the package is not exposed as a public business API but rather as an internal implementation aid.

Tables Accessed

WMS_RULE_10 references five application tables through APPS synonyms, all of which are standard inventory and warehouse configuration entities:

Collectively these tables provide the dimensional data (item, subinventory, locator) that the cursor selects and returns.

Usage Notes

WMS_RULE_10 is not referenced by any database object other than its documented dependency WMS_RULE_PVT, which supplies reusable rule-engine utilities such as WMS_PARAMETER_PVT. Because the package is not called directly by forms, concurrent programs, or public APIs, it functions as a subordinate helper invoked during runtime rule evaluation on mobile RF devices and warehouse execution transactions. Developers extending or troubleshooting WMS rule behavior should recognize that customizations should target WMS_RULE_PVT or the rule configuration tables rather than this internal cursor package, since changes here risk breaking the fetch contract expected by the calling rule framework.