Search Results update_itemcost

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:

• BOM_PARAMETERS — Supplies organizational and costing setup parameters that govern costing behavior.
• CST_COST_TYPES and CST_COST_UPDATES — Define cost types and track cost update activity.
• CST_ITEM_COSTS and CST_ITEM_CST_DTLS_INTERFACE — Hold frozen and pending item cost details, including the interface layer used during cost updates.
• CST_QUANTITY_LAYERS — Records quantity layers used in periodic costing and cost layering.
• DPP_TRANSACTION_LINES_ALL — Captures DPP transaction line data driving the cost update.
• DPP_XLA_HEADERS and DPP_XLA_LINES — Subledger accounting header and line data associated with the transaction.
• DPP_OUTPUT_XML_GT — A global temporary table used to stage output XML for downstream processing.
• DPP_CST_GROUP_ID_SEQ and DPP_MTL_TXN_IFACE_ID_SEQ — Sequences generating unique group and interface identifiers.
• FND_PROFILE_OPTIONS, FND_PROFILE_OPTION_VALUES, and FND_USER — Provide profile option values and user context for security and configuration.

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.