Search Results dpp_pricing_pvt_dpp_pl_noti14

Overview

APPS.DPP_BPEL_GETPROMOS is a PL/SQL package within the Oracle E-Business Suite Advanced Pricing (DPP) module. Its primary business function is to bridge PL/SQL-native data structures used by the pricing engine with SQL-callable equivalents required by BPEL (Business Process Execution Language) integration flows. The package name and its dominant procedure, DPP_PRICING_PVT$NOTIFY_PROMOT, indicate that it supports the notification of promotion line information between Oracle Pricing and external or BPEL-based orchestration layers.

The package exists because PL/SQL record and table types—in this case those defined inside DPP_PRICING_PVT—cannot be passed directly across certain SQL/BPEL boundaries. To overcome this, DPP_BPEL_GETPROMOS declares wrapper types (visible in type names such as DPP_PRICING_PVT_DPP_PL_NOTI14, DPP_PRICING_PVT_DPP_PL_NOTI15, and DPPPRICINGPVTDPPPLNOTI16_DPP_) and a set of bidirectional conversion functions. This design pattern is typical of EBS pricing integration packages that expose rich PL/SQL structures to BPEL partner links.

Key Procedures and Functions

The documented package exposes nine callable objects: eight conversion functions and one procedure.

• PL_TO_SQL16 / SQL_TO_PL16 — Bidirectional converters between the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE (the promotion notification header record) and its SQL-callable counterpart.
• PL_TO_SQL18 / SQL_TO_PL18 — Bidirectional converters for DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE, a collection of object names.
• PL_TO_SQL19 / SQL_TO_PL19 — Bidirectional converters for DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE, a single promotion notification line record.
• PL_TO_SQL17 / SQL_TO_PL17 — Bidirectional converters for DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE, the nested table of notification lines.
• DPP_PRICING_PVT$NOTIFY_PROMOT — The operational procedure. It accepts the standard EBS API control parameters (API version, initial message list, commit flag, validation level), returns the standard status/count/message outputs, and receives the promotion notification header record and line table as IN OUT parameters using the SQL-compatible types produced by the conversion functions. Its naming convention (a private-style "$" separator) indicates it wraps or delegates to the underlying DPP_PRICING_PVT logic for BPEL invocation.

Tables Accessed

Per the ETRM metadata, the only documented table referenced through APPS synonyms is PLITBLM. This is the pricing line message/interface table used to store or stage promotion notification payloads exchanged during BPEL-driven pricing flows. The package reads and writes this table as part of assembling or persisting the notification header and line data handled by DPP_PRICING_PVT$NOTIFY_PROMOT and its associated conversion functions.

Usage Notes

DPP_BPEL_GETPROMOS is not a user-facing API and is not referenced by any other documented packages. It is invoked indirectly, typically through BPEL integration processes or Oracle Workflow-driven pricing notifications that need to move promotion data across the PL/SQL-to-SQL/BPEL boundary. Custom code should call DPP_PRICING_PVT$NOTIFY_PROMOT only after invoking the appropriate PL_TO_SQL conversion function to marshal the header and line records, and should expect results via the standard X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA outputs along with the IN OUT notification records. Because the conversion types are versioned by suffix (14 through 19), any customization must align with the exact type signatures in the target EBS release, whether 12.1.1 or 12.2.2. Direct dependence on the internal DPP_PRICING_PVT types is discouraged; consumers should treat this package as a compatibility shim for BPEL enablement of promotion notification.