Search Results csp_packlist_pvt




Overview
Explore in AI Chat

Overview

The APPS.CSP_PACKLIST_PVT package is a private PL/SQL API belonging to the Oracle E-Business Suite (EBS) supply chain execution layer, specifically within the CSP (Consumer Packaged Goods / packaging and shipping) product family. In Oracle EBS 12.1.1 and 12.2.2, the _PVT suffix denotes a private package — one that is not intended for direct invocation by external or customer-facing code, but rather serves as an internal implementation layer consumed by public packages and public views. Its essential business function is to encapsulate the logic required to resolve packing list details — the relationship between picked items and their packaged representations, including quantities and serial/lot controlled inventory — for downstream use in picklist confirmation, shipping, and fulfillment workflows.

The package is documented with the status VALID in the ETRM metadata and is owned by the APPS schema, the standard repository for shared EBS application logic. It lists dependencies on SYS.STANDARD, confirming it uses only core PL/SQL primitives with no unusual external dependencies.

Key Procedures and Functions

The documented metadata lists two procedures or functions within CSP_PACKLIST_PVT:

  • PACKED_QUANTITY — Validates or determines the quantity of an item that has been packed onto a packlist. This procedure supports the aggregation of picked quantities into their packaged form, ensuring the packing list reflects accurate counts for shipped goods.
  • PACKED_SERIAL_LOTS — Handles the serial number and lot number information associated with packed items. This procedure resolves which serials and lots are bound to a packlist, which is essential for inventory accuracy and downstream traceability.

No parameter lists are exposed in the documented metadata; these procedures are internal to the package body and are exposed indirectly through the public packages and views that reference them.

Tables Accessed

The documented tables referenced via APPS synonyms are:

  • CSP_PACKLIST_LINES — Stores the individual lines that make up a packing list, including the packed item, quantity, and related references. PACKED_QUANTITY reads from and/or writes to this table to maintain the packed quantity per line.
  • CSP_PACKLIST_SERIAL_LOTS — Stores the serial number and lot number assignments for packed items. PACKED_SERIAL_LOTS uses this table to resolve and persist the serial/lot detail for a packlist.

These tables form the storage foundation for the packaging and packlist confirmation process within EBS shipping and fulfillment.

Usage Notes

CSP_PACKLIST_PVT is not invoked directly by end users or typical customizations. It is referenced by two other APPS packages — CSP_PICKLIST_LINES_V1 and CSP_PICKLIST_SERIAL_LOTS_V1 — which are public (V1) APIs designed for supported integration and extension. In practice, the private package is invoked indirectly when picklist confirmation, packing, or shipment confirmation occurs, whether through the Oracle Shipping / Packing (WSH) forms, mobile supply chain applications (MSCA), or a concurrent program that processes packlist data.

Because the package is classified as PVT, Oracle does not guarantee its signature across releases. Customizations should avoid calling CSP_PACKLIST_PVT directly; instead, integrations should use the public _V1 packages or supported interfaces. The package is available in both release 12.1.1 and 12.2.2, and its presence remains consistent across the two releases according to the documented metadata. Any modifications to its underlying tables should account for the fact that it participates in transactional packing and shipping logic, where data integrity is critical.