Search Results csp_requirement_lines_pub




Overview
Explore in AI Chat

Overview

The APPS.CSP_REQUIREMENT_LINES_PUB package is a public PL/SQL API within Oracle E-Business Suite that supports the Service Supply Chain / Spares Management requirement line functionality. It belongs to the CSP (Customer Service/Spares) module family and is classified with the PUB designation, indicating that it is intended for external invocation by other APIs, concurrent programs, or custom extensions rather than being restricted to internal use.

The package provides the transactional interface for creating, modifying, and removing requirement line records that represent the individual part or item demands associated with a requirement header. Requirement lines capture the specific items, revisions, and quantities that a service organization needs to fulfill against a given requirement. The package is designed to be invoked by calling applications that have already established the requirement header context, and it enforces the business rules surrounding requirement line maintenance before persisting changes to the underlying tables.

Key Procedures and Functions

The documented public API surface consists of three procedures, each aligned with a standard DML operation:

  • CREATE_REQUIREMENT_LINES — Inserts new requirement line records for an existing requirement header. This procedure is used when new item demands are added to a requirement, capturing the item, revision, and quantity data needed for downstream sourcing or fulfillment processing.
  • UPDATE_REQUIREMENT_LINES — Modifies existing requirement line records. This procedure is invoked when quantities, item references, or other line-level attributes change after initial creation.
  • DELETE_REQUIREMENT_LINES — Removes requirement line records that are no longer required, ensuring that downstream processing does not act on obsolete demand data.

The package follows the Oracle EBS API conventions built on FND_API, which provides standard error handling and message propagation. Parameter lists are not enumerated in the documented metadata; callers should consult the package specification in the EBS instance for the exact signature and required arguments.

Tables Accessed

The package reads from and writes to several tables through APPS synonyms:

  • CSP_REQUIREMENT_HEADERS — The parent header table, consulted to validate that a requirement header exists and to associate each line with its correct parent.
  • CSP_REQ_LINE_DETAILS — The primary table holding requirement line detail records that this package creates, updates, and deletes.
  • MTL_SYSTEM_ITEMS_B and MTL_ITEM_REVISIONS — Item master and revision tables used to validate that referenced items and revisions are valid and enabled.
  • MTL_PARAMETERS — Inventory organization parameters, used to validate organization-level context and defaults for the item demands.
  • PLITBLM — A PL/SQL index-by table construct used internally for bulk data handling within the package logic.

Usage Notes

CSP_REQUIREMENT_LINES_PUB is typically invoked from Oracle Forms, concurrent programs, or custom PL/SQL code that manages requirement lifecycle processing. The documented dependency information shows it is referenced by CSP_CREATE_PARTS_REQ_PKG and CSP_REQUIREMENT_HEADERS_PUB, indicating that header-level operations and parts requirement creation both flow through this line-level API.

Developers extending requirement functionality should call these public procedures rather than performing direct DML against CSP_REQ_LINE_DETAILS, so that validation logic and FND_API-based error handling remain intact. The package is identical in behavior across EBS 12.1.1 and 12.2.2; the object status is documented as VALID in the ETRM repository.