Search Results aso_shipment_pvt




Overview
Explore in AI Chat

Overview

ASO_SHIPMENT_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Order Capture / Quoting (ASO) product family and supports the shipment-processing layer of Oracle Quoting. The package encapsulates low-level business logic for creating, maintaining, and deleting shipment records associated with quote lines, and for resolving the various party and site identifiers that determine where goods are shipped from and delivered to. The "PVT" suffix indicates that this is an internal, private API intended for use by other ASO packages and public APIs rather than being called directly from client code.

The package is documented as VALID and is referenced by seven other database objects, confirming its role as a shared utility within the ASO schema. It delegates cross-cutting concerns such as error handling and message stacking to the standard EBS frameworks FND_API and FND_MSG_PUB, and it relies on ASO_DEBUG_PUB for diagnostic output.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions within this package body:

Parameter lists are not documented in the available metadata and should not be assumed; only the purposes above are confirmed.

Tables Accessed

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

Usage Notes

ASO_SHIPMENT_PVT is invoked indirectly through Oracle Quoting forms and public APIs such as ASO_QUOTE_PUB, and through the shipment, reservation, and freight packages that depend on it (ASO_SHIPMENTS_PKG, ASO_RESERVATION_INT, ASO_FREIGHT_CHARGES_PKG, ASO_UTILITY_PVT). Because it is classified as a private package, customizations should call the corresponding public APIs rather than this package directly. Direct invocation should be limited to extension code that cannot be satisfied by the public interface, and must respect the FND_API error-handling and FND_MSG_PUB message-stack conventions used throughout the body.