Results for “dpp_purchaseprice_pvt_dpp_p13”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

DPP_BPEL_GETPODATA is an APPS-owned PL/SQL package classified under the OTHER API category within Oracle E-Business Suite. It is part of the pricing and procurement integration infrastructure associated with the DPP (Advanced Pricing / Procurement Pricing) module family. The package functions as an interoperability bridge between the PL/SQL runtime and the BPEL (Business Process Execution Language) web services layer, exposing purchase order pricing data to external business process orchestration. Its principal role is to marshal complex PL/SQL record and collection types defined in DPP_PURCHASEPRICE_PVT into SQL-compatible structures that can be serialized and consumed by BPEL callouts, and conversely to convert inbound SQL representations back into native PL/SQL types.

The package header declares AUTHID CURRENT_USER, meaning resolution of referenced objects occurs under the privileges of the invoking schema. The header carries no ship flag, reflecting its role as an internal integration utility rather than a published public API.

Key Procedures and Functions

The package exposes eleven documented program units, ten of which are paired conversion functions and one of which is the consuming business procedure.

• PL_TO_SQL11 / SQL_TO_PL11 — Bidirectional conversion between the PL/SQL record type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE and its SQL-level counterpart DPP_PURCHASEPRICE_PVT_DPP_PO_.
• PL_TO_SQL13 / SQL_TO_PL13 — Conversion pair for the DPP_PO_DETAILS_REC_TYPE record and the DPP_PURCHASEPRICE_PVT_DPP_P13 SQL type.
• PL_TO_SQL14 / SQL_TO_PL14 — Conversion pair for the DPP_PO_DETAILS_TBL_TYPE collection and the DPPPURCHASEPRICEPVTDPPP11_DPP SQL type.
• PL_TO_SQL15 / SQL_TO_PL15 — Conversion pair for the DPP_PO_NOTIFY_ITEM_REC_TYPE record and the DPP_PURCHASEPRICE_PVT_DPP_P11 SQL type.
• PL_TO_SQL12 / SQL_TO_PL12 — Conversion pair for the DPP_PO_NOTIFY_ITEM_TBL_TYPE collection and the DPP_PURCHASEPRICE_PVT_DPP_PO10 SQL type.
• DPP_PURCHASEPRICE_PVT$NOTIFY_ — A wrapped-interface procedure accepting an API version, an initialization message list flag, and additional parameters. It performs the substantive notify operation that persists or transmits purchase order price notification data processed through the conversion functions above.

Tables Accessed

The package references a single documented table through APPS synonyms: PLITBLM. This table is associated with the procurement and pricing notification flow, supporting the storage or staging of line and item level data consumed by DPP_PURCHASEPRICE_PVT$NOTIFY_. No other base tables are documented within the package metadata.

Usage Notes

DPP_BPEL_GETPODATA is not referenced by any other documented database package, indicating it is invoked externally rather than from within the PL/SQL package hierarchy. Typical invocation paths include BPEL process manager callouts through the database adapter, concurrent programs, and custom integration code in Oracle EBS 12.1.1 and 12.2.2 environments. Because the package operates under AUTHID CURRENT_USER, callers must possess the necessary object privileges on the underlying DPP_PURCHASEPRICE_PVT types and the PLITBLM synonym target. Developers integrating with this package should treat the conversion functions as the sanctioned mechanism for moving PO pricing records and collections across the PL/SQL-to-SQL boundary, and should invoke DPP_PURCHASEPRICE_PVT$NOTIFY_ only with a correctly versioned API version argument.