Results for “autocreate_deliveries”

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

Overview

The APPS.WSH_DELIVERY_DETAILS_PUB package body is the public PL/SQL API within Oracle E-Business Suite Shipping Execution (WSH) that governs the lifecycle of delivery detail records. A delivery detail represents a single order or line-level item assigned to a delivery, and this package provides the supported interface through which callers create, modify, split, and progress those records. It is classified as a PUB API, meaning it is intended for external invocation by Oracle forms, concurrent programs, and customer extensions rather than being restricted to internal use. The body is VALID in the APPS schema and conforms to the FND_API error-handling and message-stack conventions, as evidenced by its dependencies on FND_API, FND_MESSAGE, and FND_MSG_PUB. It is referenced by ten other packages, confirming its role as a foundational shipping component.

Key Procedures and Functions

ETRM documents nine procedures and functions. DETAIL_TO_DELIVERY associates delivery detail records with a delivery, forming the core assignment operation. SPLIT_LINE divides a delivery detail line into separate records, supporting partial shipments and quantity redistribution. INIT_CHANGED_ATTRIBUTE_REC initializes the changed-attribute record structure used to track which columns have been modified during an update. UPDATE_SHIPPING_ATTRIBUTES applies shipping-related changes to existing delivery details. GET_DETAIL_STATUS returns the current status of a delivery detail. AUTOCREATE_DELIVERIES drives the automatic creation of deliveries from eligible source documents, and AUTOCREATE_DEL_TRIP extends that automation to trip assignment. All routines follow the standard FND_API signature conventions, returning a success flag and populating the message stack on error.

Tables Accessed

The package operates primarily against WSH_DELIVERY_DETAILS, the base table holding delivery line records, which it reads and writes during assignment, update, and split operations. WSH_NEW_DELIVERIES is used to retrieve delivery header information during detail-to-delivery association and automatic delivery creation. PLITBLM serves as the PL/SQL index-by table of character strings used internally to pass message and identifier lists. The package also depends on the view WSH_DELIVERY_ASSIGNMENTS_V and supporting packages including WSH_DELIVERY_DETAILS_PKG, WSH_TRIPS_PVT, WSH_UTIL_CORE, and WSH_DEBUG_INTERFACE, which provide lower-level data manipulation, trip interaction, and debugging support.

Usage Notes

This package is invoked from the Oracle Shipping Transactions form, from shipping-related concurrent programs such as those driving automatic delivery and trip creation, and from custom code developed by implementers extending shipping functionality. Because it is a PUB API, custom callers should initialize the FND message stack, invoke the relevant procedure, and inspect the returned status before committing. Debugging behavior is controlled through the WSH debug interfaces that the package references. Oracle EBS 12.1.1 and 12.2.2 share the same core signature set, though schema and editioning considerations apply in 12.2.x. Direct DML against WSH_DELIVERY_DETAILS should be avoided in favor of these documented entry points to preserve data integrity and delivery assignment logic.