Search Results process_lines

Overview

WSH_PR_CUSTOM is a user-customizable PL/SQL package that belongs to the Oracle Warehouse Management / Shipping Execution module and operates under the APPS schema with AUTHID CURRENT_USER privileges. Its business purpose is to expose configurable hooks that govern the behavior of the Pick Release process. Pick Release selects eligible sales order lines for picking and generates move orders that direct warehouse operators to the correct inventory. Because different organizations weigh order selection differently, Oracle provides this package so implementers can alter two critical behaviors without modifying base application code: the value used to compute an outstanding order value for line ordering, and the number of lines fetched in each pick release processing pass. The package also contains a routine to reorder picking lines within a batch, though the source comments mark that routine as not supported in the documented release. The package header carries a restrictive pragma on Outstanding_Order_Value, indicating it may be called from SQL contexts without writing database state.

Key Procedures and Functions

The package exposes three documented public constructs:

• Outstanding_Order_Value — Returns the value of an order given a header identifier. This value is consumed in the ORDER BY clause that Pick Release uses when sequencing order lines for release, allowing an organization to prioritize high-value orders ahead of lower-value ones. A return of zero signals failure of the calculation.
• Process_Lines — Returns the maximum number of lines Pick Release will fetch in a single processing pass. A return of minus one indicates that no value has been specified, in which case the application falls back to its standard default.
• Reorder_Picking_Line — Reorders picking lines associated with a given batch. The return convention is minus one for failure and zero for success. The source header annotates this routine as not supported yet, meaning it is declared for future or restricted use and is not relied upon in standard flows.

No parameter lists are documented beyond the header identifiers and batch identifiers implied above; implementers customizing these routines must preserve the existing signatures to avoid breaking the calling Pick Release code.

Tables Accessed

The package reads from SO_HEADERS_ALL and SO_LINES_ALL, accessed through APPS synonyms. SO_HEADERS_ALL supplies order header attributes, which and the outstanding order value logic reference to determine the monetary weight of an order. SO_LINES_ALL supplies the individual order lines that Pick Release evaluates, sequences, and ultimately converts into picking activity. These are read-oriented references supporting the selection and sequencing logic rather than transactional updates performed directly by this package.

Usage Notes

WSH_PR_CUSTOM is invoked indirectly by the Pick Release concurrent program and by the shipping transaction forms that initiate pick release. Standard practice is to copy the seeded package body into a custom version and modify only the logic inside the documented functions, leaving the specification intact so upstream callers remain valid. At least one other package references it, so changes carry a dependency footprint. The package is a customization extension point and is re-generated or overwritten during patching and upgrades; customizations should therefore be tracked and reapplied, or migrated to supported personalization mechanisms where available. Testing should confirm that Process_Lines returns a sensible batch size and that Outstanding_Order_Value produces the intended release ordering before deployment to production.