Search Results dpp_txn_line_rec_type




Overview
Explore in AI Chat

Overview

DPP_LISTPRICE_PVT is a private PL/SQL package in the APPS schema that supports list price update processing within Oracle E-Business Suite. The package belongs to the DPP product family, which handles Advanced Pricing and pricing-related integration logic. Its API classification as a private (PVT) package indicates that it is not intended for direct invocation by external applications; rather, it provides implementation logic consumed by an associated public package, DPP_LISTPRICE_PVT and the business process execution layer package DPP_BPEL_UPDATELISTPRICE.

The business purpose of this package is to accept incoming list price update data, typically delivered as XML through Oracle's Business Process Execution Language (BPEL) integration framework, and apply those updates to item pricing records. Because it is a private package, its procedures are designed to be called from within the pricing integration flow rather than exposed directly to end users or external systems. The package leverages Oracle's FND_API error handling framework and standard PL/SQL utilities to ensure transactional consistency during price list maintenance.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

  • UPDATE_LISTPRICE — The core procedure responsible for processing and applying list price updates. It serves as the central entry point for the incoming pricing data and orchestrates the update logic within the package. Its internal processing includes parsing the incoming XML payload and mapping it to item pricing attributes. The procedure handles both the parsing of XML content and the validation of the price adjustments before committing changes to the underlying pricing tables.

As a private package, UPDATE_LISTPRICE is not intended to be invoked directly by custom code. It is designed to be called through the DPP_LISTPRICE_PVT public wrapper or through DPP_BPEL_UPDATELISTPRICE, which manages the BPEL integration flow.

Tables Accessed

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

  • DPP_OUTPUT_XML_GT — A global temporary table used to hold the output XML generated or processed during the list price update operation.
  • FINANCIALS_SYSTEM_PARAMS_ALL — Provides financial system parameter configuration, likely for currency or organizational defaults during pricing.
  • FND_NEW_MESSAGES — Supports message retrieval and error reporting through the FND message framework.
  • MTL_PARAMETERS — Supplies inventory organization parameters, required to determine the correct operating unit context for price updates.
  • MTL_SYSTEM_ITEMS_KFV — The key flexfield view of item master records, used to resolve item identifiers associated with incoming price updates.
  • DUAL — Used for simple SQL value retrievals.
  • PLITBLM — A standard Oracle utility table typically used for CLOB/BLOB handling and PL/SQL table management in XML processing.

The package also depends on the DBMS_XMLQUERY PL/SQL utility for XML generation capabilities, along with FND_API and the STANDARD package.

Usage Notes

DPP_LISTPRICE_PVT is typically invoked indirectly through the pricing integration infrastructure rather than by end users via forms. Its primary invocation path is through DPP_BPEL_UPDATELISTPRICE, which handles the BPEL-based list price update process. When an external system (such as a CRM or e-commerce application) sends a list price update request, the BPEL process routes the payload to DPP_BPEL_UPDATELISTPRICE, which in turn calls the public DPP_LISTPRICE_PVT package, ultimately executing the UPDATE_LISTPRICE procedure.

Because it is a VALID object in the APPS schema, it is supported on both Oracle EBS 12.1.1 and 12.2.2. Customizations should not call the private package directly; developers requiring list price update functionality should use the public DPP_LISTPRICE_PVT package or the BPEL service interface instead. Organizations should also recognize that the API is governed by Oracle's Advanced Pricing licensing and the Oracle Proprietary, Confidential Information terms.