Search Results csd_logistics_util




Overview
Explore in AI Chat

Overview

CSD_LOGISTICS_PUB is the public application programming interface (API) for logistics line processing within the Oracle E-Business Suite Order Management and Shipping Execution product family. The package belongs to the CSD module, which governs the logistics and transportation data associated with order lines, deliveries, and shipments. As a public (PUB) classification package, it forms part of the supported integration surface exposed to customer and partner code, in contrast to the private (PVT) packages that implement the underlying business logic and are not intended for direct invocation.

The package is registered as VALID in the APPS schema and is documented in the ETRM repository for releases 12.1.1 and 12.2.2. Its principal responsibility is to provide a stable, encapsulated entry point through which logistics information—such as logistics lines and default logistics attributes—can be created and maintained programmatically, without requiring external callers to interact directly with the underlying private implementation.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions exposed by CSD_LOGISTICS_PUB:

  • CREATE_LOGISTICS_LINE — Creates a new logistics line record. This is the primary API for programmatically inserting logistics detail associated with a shipment, delivery, or order line.
  • CREATE_DEFAULT_LOGISTICS — Establishes default logistics attributes, allowing the caller to seed or derive standard logistics values rather than supplying each attribute explicitly.
  • UPDATE_LOGISTICS_LINE — Modifies an existing logistics line, supporting maintenance and correction of logistics records created through the create API or through standard application flows.

Each API is designed to be invoked within a PL/SQL caller's transaction. Parameter signatures are intentionally not reproduced here; callers should reference the ETRM or the package specification in the database directly, as parameter lists are subject to change across releases and patch levels.

Tables Accessed

The published ETRM documentation for CSD_LOGISTICS_PUB does not enumerate specific base tables accessed through APPS synonyms. This indicates that the package does not directly manipulate logistics base tables; instead, it delegates persistence and validation to the private implementation layer. The dependency listing confirms that CSD_LOGISTICS_PUB references APPS.CSD_PROCESS_PVT, the private processing package, along with the standard FND_API error-handling and message framework. Consequently, the actual table reads and writes are performed within CSD_PROCESS_PVT and its subordinate packages, preserving a clean separation between the public API contract and the underlying data model.

Usage Notes

CSD_LOGISTICS_PUB is invoked programmatically rather than through a dedicated form. It is referenced by CSD_LOGISTICS_PVT and CSD_LOGISTICS_UTIL, which indicates that the utility and private layers both call into the public API. Customizations, extensions, and third-party integrations should likewise call the PUB package rather than the PVT packages. Callers must observe standard Oracle EBS API conventions: the FND_API global variables and message stack should be initialized before invocation, results should be checked via the returned status, and the calling process must handle commit and rollback explicitly. Typical invocation contexts include order management extensions, shipping confirmation routines, and concurrent programs that generate or amend logistics data in bulk.