Search Results get_worker_records

Overview

WSH_PR_CRITERIA is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is classified as an "OTHER" API rather than a public interface, meaning it is not intended for direct invocation by external or custom code. Its role is to evaluate pick-release criteria for the Warehouse Management (WSH) module, determining which delivery details qualify for release to picking based on user-defined rules. The package is a foundational dependency of the pick-release process, feeding the logic that decides what material enters the picking workflow. It is referenced by four other packages, all of which are directly engaged in pick release, wave planning, or cross-dock processing: INV_PICK_RELEASE_PUB, WMS_XDOCK_CUSTOM_APIS_PUB, WMS_XDOCK_PEGGING_PUB, and WSH_PICK_LIST. The presence of INV_PICK_RELEASE_PUB as a caller is significant, as it confirms WSH_PR_CRITERIA is embedded in the standard pick-release public API path.

Key Procedures and Functions

• INIT — Initializes the package session state, establishing the working context before criteria evaluation proceeds.
• INIT_RULES — Loads the applicable pick-grouping and pick-sequence rules into memory so subsequent processing can apply them consistently.
• GET_WORKER_RECORDS — Retrieves the set of pick workers or work assignments associated with the current criteria evaluation.
• INIT_CURSOR — Opens or prepares the internal cursor used to drive the criteria loop over candidate delivery lines.
• GET_LINES — Extracts the delivery detail lines that satisfy the evaluated criteria, returning them for downstream processing by the calling package.

These five procedures form a sequential pipeline: initialization, rule loading, worker and cursor setup, and finally line retrieval. No parameter lists are documented, so callers should treat the signatures as internal and subject to change within patch levels.

Tables Accessed

• WSH_DELIVERY_DETAILS — The primary source of candidate lines for pick release; also the only table in the dependency list confirmed at both 12.1.1 and 12.2.2.
• MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES — Provide item, locator, and subinventory attributes used to evaluate location-based and item-based criteria.
• MTL_PARAMETERS — Supplies organization-level inventory settings that influence release decisions.
• OE_ORDER_LINES_ALL — Links delivery details to the originating order line, supporting order-driven criteria.
• WSH_PICK_GROUPING_RULES, WSH_PICK_SEQUENCE_RULES, WSH_PICKING_BATCHES, WSH_PR_WORKERS — Drive rule evaluation, batching, and worker assignment logic.
• DBMS_SQL and PLITBLM — Oracle-supplied packages used for dynamic SQL execution and PL/SQL index-by table manipulation, indicating dynamic query construction within the criteria engine.

Usage Notes

WSH_PR_CRITERIA is invoked indirectly. The standard entry point is the Pick Release SRS concurrent program and the shipping transaction forms, both of which ultimately reach the package through INV_PICK_RELEASE_PUB. Customizations should not call WSH_PR_CRITERIA directly; instead, they should invoke INV_PICK_RELEASE_PUB or the documented WSH pick-release APIs, which encapsulate the criteria evaluation. Because the package depends on FND_API and references APPS synonyms, behavior is consistent across 12.1.1 and 12.2.2, though administrators should validate behavior after applied patches, since the procedure signatures are undocumented and may shift.