Search Results csp_picklist_headers_pkg




Overview
Explore in AI Chat

Overview

CSP_PICKLIST_HEADERS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated against the ETRM reference for release 12.1.1 and 12.2.2. It belongs to the CSP module, the component of Oracle EBS responsible for the Consolidation and Shipping/Receiving functionality used in warehouse logistics and supply chain operations. The package functions as a low-level data access layer for picklist header records — the top-level documents that group a set of items to be picked from inventory in fulfillment of a sales order or transfer.

The object is classified under the API classification "OTHER," meaning it is not registered as a formally supported public API. Its documented procedures are row-level DML operations rather than business-process APIs, indicating it is intended to support internal processing rather than direct external integration. The package is validated and marked VALID in the data dictionary, confirming that it compiles and resolves its dependencies correctly.

Key Procedures and Functions

ETRM documents four procedures and functions within CSP_PICKLIST_HEADERS_PKG, all of which perform direct manipulation of picklist header data:

  • INSERT_ROW — Inserts a new picklist header record, establishing the top-level identity of a picklist document in the CSP_PICKLIST_HEADERS table.
  • UPDATE_ROW — Modifies attributes of an existing picklist header record, used when header-level information such as status, dates, or organizational assignments changes during processing.
  • LOCK_ROW — Acquires a row-level lock on a picklist header, typically invoked before an update or delete to guarantee data consistency in a multi-user environment.
  • DELETE_ROW — Removes a picklist header record, commonly applied when a picklist is cancelled or purged.

No parameter signatures are documented in the ETRM metadata, and they are therefore not enumerated here. Based on the naming convention and the tables involved, these procedures operate against a single logical row keyed to the picklist header identifier.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • CSP_PICKLIST_HEADERS — The primary table storing picklist header records. All four procedures perform their DML against this table.
  • CSP_PICKLIST_HEADERS_S1 — A secondary schema object, most likely a supplementary or staging table used in conjunction with header maintenance.

The package also depends on SYS.STANDARD, reflecting the use of standard PL/SQL language constructs and built-in functions.

Usage Notes

Because CSP_PICKLIST_HEADERS_PKG is classified as "OTHER" rather than as a public API, it is intended for internal consumption within the CSP module. The ETRM dependency report confirms this: the package is referenced by CSP_PICKLIST_HEADER_PVT, a private package that encapsulates the business logic for picklist header maintenance. In typical EBS architecture, PKG-level row handlers are invoked by the corresponding _PVT layer rather than by external code.

Typical invocation paths include:

  • Warehouse management forms and OAF pages within the CSP/Shipping module that create, modify, or cancel picklists.
  • Concurrent programs such as picklist generation, confirmation, or purge routines that process picklist headers in bulk.
  • Back-end PL/SQL invoked by CSP_PICKLIST_HEADER_PVT, which is the recommended entry point for any custom extension.

Customizations should not call this package directly, as its interface is undocumented and unsupported. Developers requiring picklist header maintenance should use the PVT-layer package, which enforces business validation, and should restrict direct calls to CSP_PICKLIST_HEADERS_PKG to diagnostic or migration scripts executed under controlled change management.