Search Results update_logistics_line

Overview

CSD_LOGISTICS_PVT is a private PL/SQL package in the APPS schema that supports the logistics-processing layer of Oracle E-Business Suite's Enterprise Asset Management / Depot Repair (CSD) module. It is an internal (PVT) package that operates behind the public API surface, orchestrating the creation, defaulting, and maintenance of logistics lines associated with repair orders and return material authorizations. In Oracle EBS 12.1.1 and 12.2.2, logistics lines represent the shipment-related details (freight carriers, ship-to and bill-to information, shipping method, and related transactional data) required to move repaired or replaced goods between operational locations.

CSD_LOGISTICS_PVT does not expose a directly callable public interface in the manner of a _PUB package. Instead, it provides the implementation logic consumed by CSD_LOGISTICS_PUB, which serves as the supported entry point for external callers. This separation of public and private packages reflects the standard Oracle EBS API architecture: the _PUB layer validates inputs, manages savepoints, and translates user-facing errors, while the _PVT layer executes the actual database manipulations against repair and logistics data.

Key Procedures and Functions

The package exposes four documented program units, all centered on logistics line and product transaction management:

• CREATE_LOGISTICS_LINE — Creates a new logistics line record for a repair or return transaction, populating the shipment and shipping attributes required for downstream fulfillment processing.
• CREATE_DEFAULT_LOGISTICS — Establishes default logistics attributes when explicit values are not supplied by the caller, applying system-derived defaults for shipping method, carrier, or related logistic parameters.
• UPDATE_LOGISTICS_LINE — Modifies an existing logistics line, allowing correction or refinement of shipping details after initial creation.
• UPDATE_PRODUCT_TXN — Updates the product transaction record associated with the logistics line, ensuring the transactional inventory data remains consistent with the logistics attributes.

These procedures are called in sequence by the public API layer to enforce referential and functional consistency between the repair transaction and its logistics representation.

Tables Accessed

CSD_LOGISTICS_PVT reads and writes the following tables via APPS synonyms:

• CSD_REPAIRS — The core depot repair table. The package references repair records to associate logistics lines with a specific repair order, ensuring that shipping details are tied to the correct transaction context.
• QP_LIST_HEADERS_B — The Oracle Advanced Pricing price list header table. Logistics processing may reference pricing lists to derive or validate shipping charges and freight-related pricing structures associated with the logistics line.

The relatively narrow table footprint confirms the package's focused role as a logistics-line maintenance utility rather than a broad transactional processor.

Usage Notes

CSD_LOGISTICS_PVT is not intended for direct invocation by end users or custom code. It is referenced by CSD_LOGISTICS_PUB, which is the supported public entry point, and is also referenced internally by CSD_REPAIRS_PUB and by itself (recursive or internal cross-procedure calls). Customizations or integrations should always target CSD_LOGISTICS_PUB and never call the private package directly, since the _PVT layer carries no public API guarantee and its signature may change across patches or upgrades.

The package typically executes in the context of Depot Repair forms and concurrent programs when repair orders are created, updated, or processed for shipment. It depends on FND_API for the standard API error-handling and message framework, and on CSD_PROCESS_PVT for repair processing logic. Because it is documented as VALID in ETRM for 12.2.2 and is compatible with 12.1.1, it remains a stable internal component of the CSD module's logistics infrastructure.