Search Results aso_shipments_pkg




Overview
Explore in AI Chat

Overview

ASO_SHIPMENTS_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified as an "OTHER" API within the Order Capture (ASO) module and provides the core database access layer for shipment records maintained in the Oracle Sales and Order Management applications. The package implements the standard insert, update, delete, and locking operations against the ASO_SHIPMENTS entity and its language/translation table ASO_SHIPMENTS_S, and it delegates common error handling and validation to shared Order Capture utilities such as ASO_UTILITY_PVT and the Oracle Application Object Library APIs FND_API and FND_MESSAGE.

Within the ETRM metadata the package is reported with a VALID status. It references APP_EXCEPTION, FND_API, FND_MESSAGE, ASO_UTILITY_PVT, and the STANDARD and DUAL constructs, and is itself referenced by four other database objects. This confirms that ASO_SHIPMENTS_PKG functions as a reusable persistence service rather than an end-user transaction entry point.

Key Procedures and Functions

The documented metadata lists four procedures exposed by this package body. Parameter signatures are not published in the source metadata and are therefore not restated here.

  • INSERT_ROW — Creates a new shipment record in ASO_SHIPMENTS, including the associated multilingual row in ASO_SHIPMENTS_S. It applies the standard API conventions, returning status and error information through the FND_API message stack.
  • UPDATE_ROW — Modifies an existing shipment record, updating both the base table and the language table as required. It relies on FND_API and FND_MESSAGE for validation feedback and error propagation.
  • LOCK_ROW — Obtains a row-level lock on a shipment record to serialize concurrent modification. It is normally called before UPDATE_ROW or DELETE_ROW within a user session.
  • DELETE_ROW — Removes a shipment record and its translated rows from the underlying tables, applying the standard API error handling and exception management through APP_EXCEPTION.

Tables Accessed

The package reads and writes two documented tables accessed through APPS synonyms:

  • ASO_SHIPMENTS — The primary entity table storing shipment header information for order capture and fulfillment transactions. This is the central table for insert, update, lock, and delete operations.
  • ASO_SHIPMENTS_S — The translation (language) table that stores descriptive attributes in multiple installed languages. It is maintained in parallel with ASO_SHIPMENTS to keep translated content synchronized.

Standard constructs such as DUAL and STANDARD, along with APP_EXCEPTION, FND_API, FND_MESSAGE, and ASO_UTILITY_PVT, are used for exception handling and API conventions rather than for persistent data storage.

Usage Notes

ASO_SHIPMENTS_PKG is not intended for direct end-user invocation. It is typically called from within the Order Capture layer, from custom extensions that need to create or maintain shipment records programmatically, and from other packages and forms that manipulate shipment data. Because it is referenced by four other database objects, changes to its logic can affect dependent components; upgrade or customization work should therefore be assessed against those dependents.

When invoking these routines, callers should supply all required parameters and inspect the returned FND_API status and message stack. LOCK_ROW should be executed before update or delete operations to avoid lost updates. For Release 12.1.1 and 12.2.2 the package remains valid and stable, and it should be treated as a low-level utility rather than a public integration API.