Search Results inv_pick_release_pub




Overview
Explore in AI Chat

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

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.