Search Results dpp_itemcost_pvt




Overview
Explore in AI Chat

Overview

APPS.DPP_ITEMCOST_PVT is a private PL/SQL package within the Oracle E-Business Suite Distributed Process Procurement (DPP) module, commonly associated with ETRM/Advanced Pricing and cost rollup functionality in Release 12.1.1 and 12.2.2. The package is classified as a PVT (private) API, indicating it is intended for internal use by the DPP framework rather than as a public integration interface. Its primary business function is to update item cost information within the cost management and transaction processing infrastructure, acting as a bridge between transactional data captured in DPP staging and interface tables and the authoritative cost tables in Oracle Cost Management.

The package depends on the standard Oracle Application Object Library API FND_API, confirming that it participates in the standard EBS API error-handling and message-stack framework. It is referenced by DPP_BPEL_UPDATECOST, a business process execution layer component, reinforcing its role as a backend worker invoked during cost update processing.

Key Procedures and Functions

ETRM documentation identifies one public procedure within this package:

  • UPDATE_ITEMCOST — The central routine responsible for applying item cost information to the appropriate cost tables. It handles the logic of transferring cost data from DPP interface and transactional sources into the item cost structures, and it interacts with cost types, cost updates, and quantity layers. Because parameter lists are not documented in ETRM metadata, no signature is enumerated here; the procedure should be treated as an internal API invoked with framework-managed arguments.

No additional procedures or functions are documented for this package in the ETRM metadata.

Tables Accessed

The package reads from and writes to several Cost Management, DPP, and application reference tables via APPS synonyms. Key tables include:

Usage Notes

Because DPP_ITEMCOST_PVT is a private package, it is not intended for direct invocation by end users, concurrent program parameters, or custom client code. It is invoked internally by the DPP cost update process, most notably through DPP_BPEL_UPDATECOST, which orchestrates the business process flow for updating item costs. Developers troubleshooting cost update issues in the DPP framework may trace execution into this package through the dependent code listings. Any extension or custom integration should target the public DPP APIs rather than this private package, since its interface and behavior are subject to change without notice. It remains valid in both 12.1.1 and 12.2.2 environments and should be treated as framework-internal infrastructure.