Search Results csp_item_pl_params_pvt




Overview
Explore in AI Chat

Overview

CSP_ITEM_PL_PARAMS_PVT is a private PL/SQL package owned by the APPS schema within the Oracle E-Business Suite. Its classification as a PVT (private) API indicates that it is an internal implementation package, intended to be invoked by other packages and forms within the same functional product rather than called directly by external integrations. The package belongs to the Oracle Enterprise Asset Management and Advanced Supply Chain Planning (ASCP) family, specifically the "CSP" application namespace, which governs item-level planning parameters used by the Collaborative Planning and Supply Chain Planning modules.

The business function of CSP_ITEM_PL_PARAMS_PVT is to maintain the planning parameter attributes defined against inventory items so that planning engines can consume consistent, up-to-date values. These parameters drive demand forecasting, safety stock calculations, replenishment policies, and sourcing rules. By centralizing the persistence logic in a single private package, the product ensures that all callers apply the same validation and merge semantics when item planning parameters are created or updated.

Key Procedures and Functions

The documented metadata identifies a single program unit exposed by this package:

  • MERGE_ITEM_PARAMS — Performs the insert-or-update (upsert) logic for item planning parameter rows. Its name follows the standard EBS convention for merge procedures, which apply a row to the target table when one does not already exist and update the existing row otherwise. In the context of this package, MERGE_ITEM_PARAMS synchronizes the planning parameter values supplied by a caller into the underlying item planning parameter store. Because this is a private package, the procedure is not designed as a public API entry point; it is called internally by higher-level public packages and by the forms that maintain item planning attributes. No parameter list is published in the documentation set, and callers should not rely on a fixed signature.

Tables Accessed

The package reads and writes the following tables, resolving them through APPS synonyms:

  • CSP_ITEM_PL_PARAMS — The primary base table holding item-level planning parameter values. MERGE_ITEM_PARAMS inserts new rows and updates existing rows here.
  • CSP_ITEM_PL_PARAMS_S1 — A supplementary table associated with the item planning parameters. The "_S1" suffix in EBS naming typically denotes a reference or setup table used to validate or expand values before they are committed to the base table.
  • CSP_PLANNING_PARAMETERS — The planning parameter definition table, which supplies the valid set of planning attributes and their allowed values. It is accessed to validate that item-level values conform to the global planning parameter definitions.
  • DUAL — The standard Oracle single-row pseudo-table, used for lightweight lookups, sequence value retrieval, or date/constant evaluation during the merge.

Usage Notes

As a private package, CSP_ITEM_PL_PARAMS_PVT is not intended for direct invocation from custom code. The documented dependency metadata shows no other packages reference it, indicating its calls are confined to the internal CSP product layer and the associated Oracle Forms module that maintains item planning parameters. In a 12.1.1 or 12.2.2 environment, the package is typically exercised when a user creates or amends planning parameters for an item through the Planning Parameters or Item Master forms, or when a concurrent program or internal planning process refreshes parameter data. Custom extensions that need to modify item planning parameters should call the public CSP planning APIs rather than this private package, preserving upgrade safety and ensuring validation rules continue to be enforced.