Search Results del_id




Overview
Explore in AI Chat

Overview

WSH_SC_DEL_LINES is a shipping-execution package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to maintain shipped-quantity data on picking lines and picking line details in the context of a specific delivery. The package supplies the logic that reconciles what was picked and packed against what the delivery records show, and it is invoked during delivery-related operations such as packing a delivery and backordering. The del_id parameter that appears in the package's procedures is the delivery identifier that scopes every operation; it is the key the user searched for and it determines exactly which picking line details are updated.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package body.

  • UPDATE_SHP_QTY — Accepts a delivery identifier (del_id) and an action code, and updates shipped quantities on the underlying picking data for that delivery. The action code controls the update mode: an "ALL" mode sets the shipped quantity equal to the requested quantity for picking line details whose shipped quantity is still null; an "ENTERED" mode sets the shipped quantity to zero for null rows; and a "BACKORDER_ALL" mode sets the shipped quantity to zero regardless of null state. After the detail-level update, the procedure recalculates and updates the shipped quantity on the picking lines themselves by summing the shipped quantities of the associated picking line details for the delivery.
  • UPDATE_UNREL_LINES — Handles picking lines that are not otherwise related to the delivery being processed, ensuring that shipped quantities for delivered but unassociated picking lines remain consistent. Its documented purpose is to update those unrelated lines so that the shipped quantities referenced by the delivery remain accurate.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • SO_PICKING_LINE_DETAILS — The primary update target. Shipped quantities for detail rows linked to the specified del_id are set based on the action code.
  • SO_PICKING_LINES_ALL — Used to join picking lines to picking line details and to update the header-level shipped quantity from the sum of detail quantities.
  • SO_LINES_ALL and SO_LINE_DETAILS — Referenced for order line context, ensuring shipped quantities align with the associated sales order lines.

Usage Notes

WSH_SC_DEL_LINES is classified as an OTHER API rather than a formal public API. It is invoked internally by shipping execution when a delivery is packed or when shipped quantities must be adjusted, and it is also referenced by one other package in the shipping module. Because the procedures act directly on picking tables without a formal API contract, they should not be called from custom code without careful analysis. Developers working with del_id are advised to use the supported shipping execution APIs and concurrent programs wherever possible, and to treat this package as internal implementation logic whose behaviour is tied to the delivery and action code values passed by the standard shipping flows.