Search Results dpp_bpel_getoutboundpl




Overview
Explore in AI Chat

Overview

DPP_BPEL_GETOUTBOUNDPL is an Oracle EBS Advanced Pricing (formerly Oracle Pricing) package owned by the APPS schema. Its name indicates a bridge role between the Business Process Execution Language (BPEL) integration layer and outbound price list publication logic in the Pricing module. In ETRM 12.2.2 the package is classified under the API classification OTHER, meaning it is an internal helper rather than a formally published open interface. It operates as a supporting routine behind the outbound notification mechanism that Advanced Pricing uses to publish price list changes to external systems or downstream Oracle applications.

The package is closely tied to DPP_PRICING_PVT, the central pricing private package. The documented dependency listing shows DPP_BPEL_GETOUTBOUNDPL referencing DPP_PRICING_PVT and several generated PL/SQL notification wrappers (DPP_PRICING_PVT_DPP_PL_NOTIF6, NOTIF7, NOTIF8) plus the synonym DPPPRICINGPVTDPPPLNOTIF8_DPP_. These artifacts are the outbound price list notification handlers that construct and emit payloads to BPEL. The package therefore sits in the integration path between pricing data maintenance and outbound messaging.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions. They fall into two mirrored families, each appearing under two index variants:

  • PL_TO_SQL7, PL_TO_SQL8, PL_TO_SQL9, PL_TO_SQL10 — conversion routines that translate price list expression or payload data from PL/SQL form into SQL-compatible form. The numeric suffixes correspond to the individual notification handler variants exposed by DPP_PRICING_PVT for outbound price lists.
  • SQL_TO_PL7, SQL_TO_PL8, SQL_TO_PL9, SQL_TO_PL10 — the inverse conversion routines, transforming SQL-stored price list data back into PL/SQL structures for outbound processing.
  • DPP_PRICING_PVT$NOTIFY_OUTBOU — a truncated name in the metadata representing the outbound notify entry point invoked for a price list event. It is the orchestrating routine that the notification wrappers call to dispatch an outbound price list message.

No parameter signatures are documented in ETRM for these units; the numeric suffixes and naming convention indicate parallel, per-notification-handler conversion and dispatch logic rather than a single generic API.

Tables Accessed

The only documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is a pricing-related interface or staging table used by Advanced Pricing for bulk price list processing. In this context it serves as the persistent store that the PL_TO_SQL and SQL_TO_PL conversion routines read from and write to while assembling outbound price list payloads. The package does not appear to touch core pricing tables directly; those accesses are delegated to DPP_PRICING_PVT and its notification handlers.

Usage Notes

DPP_BPEL_GETOUTBOUNDPL is not an end-user-callable interface. It is invoked internally, normally triggered when Advanced Pricing publishes price list changes through the BPEL integration flow. The notification wrappers in DPP_PRICING_PVT call into this package to convert the price list data and dispatch the outbound message. ETRM records zero packages referencing it, confirming that it is a leaf-level internal utility rather than a dependency of other pricing APIs.

Because the package sits inside the outbound BPEL path, it may be exercised during price list creation, update, or deletion events that are configured for external publication. Customizations should treat it as internal and non-contractual; the safe integration point remains DPP_PRICING_PVT and the documented public pricing APIs. Any troubleshooting of failed outbound price list messages should begin by confirming the package status is VALID and that PLITBLM staging rows are being populated as expected. Its presence in both 12.1.1 and 12.2.2 follows the same internal design, with the notification handler variants reflecting the multiple outbound price list message formats supported by the integration.