Search Results g_project_id

Overview

WMS_RULE_15 is a rules-engine package in the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. It belongs to the APPS schema and is classified under the ETRM API taxonomy as OTHER, indicating it is not part of the public, documented open interface set but rather an internal implementation artifact used by the WMS rules framework. The package encapsulates a specific picking rule (rule number 15) that the WMS engine evaluates during directed picking, task creation, and allocation processing.

The business purpose of the package is to determine whether a given on-hand source — identified by organization, item, revision, lot, subinventory, locator, cost group, serial range, LPN, and project/task context — satisfies the criteria defined for rule 15. The cursor-based design allows the WMS engine to open a query, iterate over candidate rows, and evaluate applicability without materializing a large result set, which is critical for performance in high-volume warehouse environments.

Key Procedures and Functions

The package exposes four documented procedures:

• OPEN_CURS — Opens and initializes the cursor used to evaluate candidate sources for rule 15. The procedure receives the full set of search criteria from the calling WMS engine, including organization, item, transaction type, revision, lot, subinventory, locator, cost group, serial attributes, LPN, and the project/task identifiers (p_project_id and p_task_id). It performs a series of assignments into package-level variables prefixed with g_ — including g_project_id and g_task_id — which persist the parameter values for use by subsequent fetch operations. An output result indicator is returned to the caller.
• FETCH_ONE_ROW — Retrieves the next qualifying row from the open cursor, returning the source attributes for a single candidate. It supports single-row evaluation semantics used by the rules engine.
• CLOSE_CURS — Closes the cursor and releases associated resources once evaluation is complete.
• FETCH_AVAILABLE_ROWS — Retrieves the full set of available candidate rows from the open cursor, used when the rule must consider multiple sources rather than a single match.

Tables Accessed

The package references the following tables through APPS synonyms:

• MTL_ONHAND_QUANTITIES_DETAIL — provides the on-hand quantities and source inventory dimensions evaluated by the rule.
• MTL_ITEM_LOCATIONS — supplies locator attributes that constrain or qualify the candidate source.
• MTL_LOT_NUMBERS — supports lot-controlled item validation and lot-level filtering.
• MTL_SERIAL_NUMBERS — supports serial-controlled item evaluation across serial ranges.
• MTL_SECONDARY_INVENTORIES — validates the subinventory context of the candidate source.
• PJM_PROJECT_PARAMETERS — validates project and task attributes, linking the g_project_id and g_task_id values to valid project parameters. This is the direct consumer of the user's search term.
• PLITBLM — an internal WMS helper table used by the rules engine, typically for staging or temp data during evaluation.

Usage Notes

WMS_RULE_15 is invoked by the WMS rules engine, not called directly from forms. The engine selects rule packages based on the rule configuration defined for the warehouse and invokes OPEN_CURS, followed by FETCH_ONE_ROW or FETCH_AVAILABLE_ROWS, and finally CLOSE_CURS. The project and task values captured in g_project_id and g_task_id are sourced from the transaction context during directed picking of project-related material. The package is referenced by one other package in the ETRM metadata, indicating a dependency within the WMS rule invocation chain. Customizations should avoid direct calls; instead, rule behavior should be modified through supported WMS setup. Any custom development referencing this package risks breakage on patching, since the API is classified as OTHER (internal).