Search Results csp_picklist_lines_pkg




Overview
Explore in AI Chat

Overview

APPS.CSP_PICKLIST_LINES_PKG is a PL/SQL package in the Oracle E-Business Suite APPLSYS/APPS schema associated with the Converged/Service Supply Chain (CSP) module. Functionally, it provides the low-level, row-oriented data manipulation layer for the CSP_PICKLIST_LINES entity — the individual line records that make up a picklist used in warehouse picking, material staging, and outbound fulfillment operations. In Oracle EBS 12.1.1 and 12.2.2, the package is classified as "OTHER" in the ETRM (E-Business Suite Technical Reference Manual) repository, meaning it is an internal implementation package rather than a certified public API. Its package body encapsulates the standard CRUD primitives — insert, update, lock, and delete — against the picklist lines base table, isolating the schema-specific SQL from higher-level business logic implemented in the companion package CSP_PICKLIST_LINES_PVT.

Key Procedures and Functions

ETRM documents four procedures and functions in the package:

  • INSERT_ROW — Populates a new row in the picklist lines table. This is the entry point used when a picklist is generated or amended, establishing the picklist line identifier and its associated detail attributes.
  • UPDATE_ROW — Modifies attributes of an existing picklist line, typically reflecting quantity changes, status transitions, or warehouse-driven corrections during picking.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE semantics) on a picklist line to serialize concurrent modifications before an update or delete. This prevents lost updates in multi-user picking or staging environments.
  • DELETE_ROW — Removes a picklist line record, used when lines are cancelled, consolidated, or otherwise purged from the picklist.

These four routines form the standard "_PKG / _PVT" pattern used throughout Oracle EBS: the private package (_PVT) owns the business rules and calls _PKG to perform the physical DML. ETRM does not expose parameter lists, and no signatures should be assumed beyond the functional intent described above.

Tables Accessed

Dependencies show the package references the following objects through APPS synonyms:

  • CSP_PICKLIST_LINES — The base table holding picklist line detail (the primary DML target for INSERT, UPDATE, LOCK, and DELETE operations).
  • CSP_PICKLIST_LINES_S1 — The supporting sequence (or secondary object) used to generate surrogate keys for new picklist line rows during INSERT_ROW.

The sequence ensures that INSERT_ROW can construct a unique line identifier without contending on table-level locks, a standard Oracle EBS design for high-volume transactional tables.

Usage Notes

As an internal package, CSP_PICKLIST_LINES_PKG is not intended to be called directly by end-user code. It is referenced by APPS.CSP_PICKLIST_LINES_PVT, which enforces validation, defaults, and workflow rules before delegating to the physical DML in this package. The dependency list indicates the package references only SYS.STANDARD and is itself referenced by CSP_PICKLIST_LINES_PKG and CSP_PICKLIST_LINES_PVT. In practice, it is invoked from:

  • Oracle Forms — CSP picklist entry and maintenance forms that operate on the picklist lines block.
  • Concurrent programs — Batch picklist generation, confirmation, and purge processes that create or remove lines.
  • Custom integrations and extensions — Any custom PL/SQL that must manipulate picklist lines should call the public _PVT wrapper, not _PKG directly, to remain consistent with EBS coding standards and to preserve business-rule enforcement across 12.1.1 and 12.2.2 environments.

Because the package is marked VALID and proprietary, modifications should be limited to supported extension mechanisms; direct edits to the _PKG body are unsupported and may be overwritten by patching.