Search Results sql_to_pl10




Overview
Explore in AI Chat

Overview

DPP_BPEL_GETOUTBOUNDPL is an Oracle EBS Advanced Pricing (DPP) package body owned by the APPS schema. It functions as a data-conversion bridge that translates outbound pricing notification records between two different data representations: PL/SQL record types and SQL/object types. The package exists to support outbound notification flows for pricing events, such as price list changes, where the runtime PL/SQL structures must be marshalled into database object types registered with SQL (and vice versa) so that they can be persisted, queried, or exposed to external integration layers such as BPEL-based business event and messaging infrastructure.

The name reflects its role: "BPEL" indicates the business process integration context, and "GETOUTBOUNDPL" indicates retrieval and preparation of outbound price list notification data. The package header revision history (dppvbonb.pls 120.2, dated 2007/12/12) shows it is an older, stable component whose interface has been frozen for backward compatibility across the 12.1.1 and 12.2.2 releases. It is classified as an "OTHER" API rather than a public or private API, meaning it is an internal implementation utility not intended for general customer invocation.

Key Procedures and Functions

The package exposes nine documented functions, organized as conversion pairs keyed by object shape. Each pair converts one representation to another.

  • PL_TO_SQL7 — Converts a single outbound price list notification from a PL/SQL record type (DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE) into the corresponding SQL object type (DPP_PRICING_PVT_DPP_PL_NOTIF6), copying the transaction number, effectivity date, organization, vendor, vendor site, and operating unit attributes.
  • SQL_TO_PL7 — Performs the reverse mapping, converting the SQL object type back into the PL/SQL record type.
  • PL_TO_SQL9 and SQL_TO_PL9 — Convert between a PL/SQL collection (DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE) and the corresponding SQL object table type, extending the collection to match the source count.
  • PL_TO_SQL10 and SQL_TO_PL10 — A further conversion pair, likely corresponding to a differently shaped notification or a second collection type used in the outbound flow.
  • PL_TO_SQL8 and SQL_TO_PL8 — An additional conversion pair handling another variant of the notification structure.
  • DPP_PRICING_PVT$NOTIFY_OUTBOU — The truncated-named wrapper entry point that drives the outbound notification, invoking the appropriate conversion routines and dispatching the result to the outbound integration layer.

Tables Accessed

The package references the table PLITBLM through an APPS synonym. This is an internal pricing interface table associated with price list item processing, used to stage or read the outbound price list line data that is subsequently converted and published. No other tables are documented against this package.

Usage Notes

DPP_BPEL_GETOUTBOUNDPL is not intended for direct invocation by forms, concurrent programs, or customer-written code. It is called internally by the Advanced Pricing notification processing logic when outbound price list events require the PL/SQL runtime structures to be transformed into SQL object types for integration with Business Events and BPEL workflows. The package is referenced by zero other documented packages, confirming its narrow, leaf-level role in the dependency tree. Because it remains unchanged between 12.1.1 and 12.2.2, customizations should treat it as read-only and rely instead on the supported Advanced Pricing public APIs for any price list notification extension.