Search Results delete_wip_ps_tbl

Overview

The APPS.INV_PR_PICK_SLIP_NUMBER package is a Shipping-related PL/SQL package in Oracle E-Business Suite that is responsible for determining how pick slips are grouped and for generating pick slip numbers during the order picking and shipping process. Its stated purpose is twofold: it initializes the variables used to determine how pick slips should be grouped, and it returns the pick slip number along with an indication of whether a pick slip should be printed. The package is explicitly documented as being used only by Shipping-related functionality, and it is referenced by seven other packages, indicating that it sits at a low level in the picking and shipment-confirmation call stack. The current header revision (120.2) is marked noship, denoting a non-shipped, internal-use object rather than a public API.

Key Procedures and Functions

The package exposes five documented procedures and functions:

• GET_PICK_SLIP_NUMBER — Returns the pick slip number and indicates whether a pick slip should be printed. This is an overloaded procedure used by Shipping, with behavior governed by parameters including pick slip print mode (Immediate or Deferred), pick grouping rule, organization, order header, customer, and ship method context.
• GET_PICK_SLIP_NUMBER_PARALLEL — A parallel variant of the pick slip number generation logic, supporting concurrent processing of pick slip assignment across large order volumes.
• PRINT_PICK_SLIP — Invoked to produce or trigger the printing of the pick slip based on the result of the number retrieval logic.
• DELETE_WIP_PS_TBL — Removes work-in-process pick slip table records, supporting cleanup of transient data used during pick slip generation.
• Additional grouping logic — The package also defines the record and table types (keyrectyp, keytabtyp) and grouping constants (order, zone, cluster, and bulk pick methods) that drive how keys are aggregated. Four columns—dest_subinventory, dest_locator_id, project_id, and task_id—were added to the key record type to support FP-J PAR replenishment counting.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• MTL_PICK_SLIP_NUMBERS and MTL_PICK_SLIP_NUMBERS_S — Store and sequence generated pick slip numbers.
• WSH_PICK_GROUPING_RULES — Provides the grouping rule definitions that determine how orders are consolidated into a single pick slip.
• WSH_PICK_SLIP_NUMBERS_S — Sequence source for pick slip numbering in the Shipping schema.
• WSH_SHIPPING_PARAMETERS — Supplies shipping-level configuration such as pick slip print mode.
• DBMS_UTILITY, DUAL, and PLITBLM — Utility and helper objects used for key hashing, singleton queries, and index-by table manipulation.

Usage Notes

INV_PR_PICK_SLIP_NUMBER is an internal Shipping package rather than a general-purpose public API. It is invoked indirectly during pick release and pick slip generation, typically through Shipping forms, concurrent programs, and higher-level Shipping packages that call GET_PICK_SLIP_NUMBER to obtain the next pick slip number and decide whether a slip should be printed immediately or deferred. Because it is marked noship and is referenced by other packages rather than exposed directly, customizations should avoid calling it directly where a supported Shipping API exists. When extension is unavoidable, developers should respect the grouping method constants and the key record structure, since changes to grouping keys affect pick slip consolidation behavior across the entire picking flow.