Search Results dpp_bpel_updatepo




Overview
Explore in AI Chat

Overview

APPS.DPP_PURCHASEPRICE_PVT is a private PL/SQL package that forms part of the Oracle E-Business Suite procurement and payables data model, specifically the procurement-to-payment integration layer associated with the EBS-to-ETRM and supplier-network messaging framework (the DPP_ prefix denotes packages belonging to this procurement integration schema). The package is classified as a "PVT" (private) API, meaning it is an internal implementation package not intended for direct customer invocation; it exposes entry points that are consumed exclusively by other DPP packages, principally the BPEL integration packages DPP_BPEL_GETPODATA and DPP_BPEL_UPDATEPO, as well as by itself through internal recursion and mutual calls. Its central business purpose in Oracle EBS 12.1.1 and 12.2.2 is to process purchase-order and receipt information flowing between the EBS application modules and external/ETRM-side systems, evaluating whether inbound PO data warrants a price update and generating outbound notifications back toward the trading partner or integration endpoint.

Key Procedures and Functions

The ETRM metadata documents two program units within the package:

  • UPDATE_PURCHASEPRICE — The core business procedure. It validates and applies purchase-price information received against existing purchase-order data, using profile and security context to determine the applicable organization and user, and staging output XML for downstream delivery. It is the routine most directly associated with the package's name.
  • NOTIFY_PO — The notification routine. It assembles and dispatches purchase-order notifications to the appropriate recipients, relying on the FND messaging and XML-generation infrastructure (FND_API, DBMS_XMLQUERY, PLITBLM) referenced by the package.

Both procedures honor the FND_API standard error-handling and messaging conventions. The metadata does not publish parameter lists, and consumers should treat these as internal-only entry points.

Tables Accessed

The package reads and writes across procurement core, receipt, and reference-data tables via APPS synonyms:

Usage Notes

DPP_PURCHASEPRICE_PVT is a private package and is not invoked directly from Oracle Forms, concurrent programs administered through the standard interface, or customer-developed code. It is called from within the DPP procurement integration stack, notably DPP_BPEL_GETPODATA and DPP_BPEL_UPDATEPO, which serve as the BPEL-facing entry points for retrieving and updating purchase-order data. Extensions and diagnostics should therefore target those public wrappers rather than the private package. Because the package interacts with FND_API error handling and writes to a global temporary XML output table, any troubleshooting should focus on profile-option configuration, multi-org security context, and the XML payload staged in DPP_OUTPUT_XML_GT. The object remains VALID in both 12.1.1 and 12.2.2, and its dependency set is stable across those releases.