Results for “detail_to_delivery”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.WSH_DELIVERY_DETAILS_PUB package is a public PL/SQL API within Oracle Shipping Execution (WSH) that exposes the core business logic for managing and manipulating delivery detail records. Delivery details represent the individual order lines, move orders, or inventory transactions that have been assigned to a delivery for shipment. In Oracle EBS 12.1.1 and 12.2.2, this package is the supported interface through which forms, concurrent programs, and custom code create, split, update, and autopopulate delivery details without directly writing to the underlying shipping tables.

The package carries an API classification of PUB, indicating that it is part of Oracle's supported public API surface and is intended for external invocation. It relies on shared infrastructure components including FND_API for the standard Oracle Application Object Library API conventions (such as the x_return_status and x_msg_count / x_msg_data error-handling pattern) and WSH_UTIL_CORE and WSH_GLBL_VAR_STRCT_GRP for shipping utility routines and global variable structures.

Key Procedures and Functions

ETRM documents nine procedures and functions within this package. Their intended purposes are as follows:

• DETAIL_TO_DELIVERY — Associates a delivery detail with a delivery, effectively assigning the underlying line to a shipment header.
• SPLIT_LINE — Splits a delivery detail line into multiple details, typically to support partial shipments or to redistribute quantities across deliveries.
• INIT_CHANGED_ATTRIBUTE_REC — Initializes the record structure used to track attributes that have changed on a delivery detail, supporting the attribute-change auditing mechanism.
• UPDATE_SHIPPING_ATTRIBUTES — Updates shipping-related attributes on a delivery detail record.
• GET_DETAIL_STATUS — Returns the current status of a delivery detail, allowing callers to query shipment progress programmatically.
• AUTOCREATE_DELIVERIES — Automatically creates deliveries from eligible delivery details based on shipping parameters and grouping rules.
• AUTOCREATE_DEL_TRIP — Automatically creates trips (and associated delivery groupings) as part of the trip-building and autopack process.

The metadata lists nine documented procedures for the package, of which seven are named above; the remaining entry corresponds to the package's own internal body reference. Parameter lists are not reproduced here; callers should consult the ETRM specification for exact signatures.

Tables Accessed

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

• WSH_DELIVERY_DETAILS — The primary table holding delivery detail records. Most procedures insert, update, or query rows here.
• WSH_NEW_DELIVERIES — Used by the autopopulate and autocreate logic to construct new delivery headers before details are attached.
• PLITBLM — A standard Oracle Applications temporary/collection table used during processing, typically for passing sets of identifiers between PL/SQL and SQL operations.

Usage Notes

WSH_DELIVERY_DETAILS_PUB is invoked by both Oracle's own shipping flows and by customer extensions. Within Oracle EBS it is referenced by ten other packages, including WSH_CONTAINER_PUB, INV_SHIPPING_TRANSACTION_PUB, INV_EXPRESS_PICK_PUB, WMS_SHIPPING_TRANSACTION_PUB, WMS_DIRECT_SHIP_PVT, GML_MOBILE_SHIP_CONFIRM, and CSD_PROCESS_PVT, which covers shipping, inventory, warehouse management, process manufacturing, and field service contexts.

Typical invocation points include the Shipping Transactions and Delivery Detail forms, the Autopack and Trip Building concurrent programs, and custom integrations that need to assign, split, or update delivery details. Because this is a public API, custom code should call it rather than performing direct DML on WSH_DELIVERY_DETAILS, ensuring that validation, attribute-change tracking, and dependent shipping logic are consistently applied.