Search Results csp_item_pl_params_s1

Overview

CSP_ITEM_PL_PARAMS_PVT is the private implementation package body for item-level planning parameter maintenance within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It belongs to the CSP product family, which governs supply chain planning engine configuration. The package encapsulates the logic required to create, update, and merge item planning parameters — the attributes that determine how the planning engine treats a specific inventory item during a planning run, such as sourcing rules, planning make-or-buy flags, and demand/supply time fences. It holds the PVT classification, indicating it is an internal private API rather than a public interface: callers are expected to go through a corresponding public wrapper or a concurrent program, not to invoke this body directly. The package is VALID and owned by the APPS schema, consistent with standard EBS database object conventions.

Key Procedures and Functions

ETRM documents a single program unit within this package body:

• MERGE_ITEM_PARAMS — Performs an upsert operation against item planning parameters. It reconciles incoming parameter values with existing rows, inserting new parameter records and updating existing ones as required. Because it is the sole documented procedure and the package is private, MERGE_ITEM_PARAMS serves as the core engine routine that other EBS components or public wrappers invoke when item planning data must be synchronized.

No other procedures or functions are documented in the available ETRM metadata; parameter signatures are not exposed and should not be assumed.

Tables Accessed

The package body references the following tables and objects through APPS synonyms:

• CSP_ITEM_PL_PARAMS — The primary base table storing item planning parameter definitions. MERGE_ITEM_PARAMS reads from and writes to this table.
• CSP_ITEM_PL_PARAMS_S1 — The internal sequence referenced by the package body to generate unique identifiers for new parameter rows, matching the user's search term.
• CSP_PLANNING_PARAMETERS — Supplementary planning parameter configuration sourced during parameter resolution.
• DUAL — Used for single-row select expressions and sequence retrievals.

The dependency listing additionally records references to CSP_ITEM_PL_PARAMS_PVT (self-reference within the body) and CSP_PLAN_DETAILS_PKG, indicating that MERGE_ITEM_PARAMS delegates some planning-detail work to that sibling package. FND_GLOBAL is referenced for EBS session context such as user ID and responsibility. Standard SYS objects (STANDARD, DUAL) are also present.

Usage Notes

CSP_ITEM_PL_PARAMS_PVT is not referenced by any other database object, confirming its private status. It is typically invoked indirectly: through the public API layer that fronts item planning parameters, through ASCP setup forms that maintain planning attributes, or through concurrent programs that bulk-load or refresh item planning data during planning setup. Custom code and extensions should call the public wrapper rather than this private body, as signature stability is not guaranteed. Because the package uses sequence CSP_ITEM_PL_PARAMS_S1 to allocate keys, any direct invocation must respect existing sequence values to avoid primary-key collisions. In 12.1.1 and 12.2.2, the object resides in APPS and is VALID, so no recompilation is required; however, dependency on CSP_PLAN_DETAILS_PKG means invalidation of that package will cascade to this body.