Search Results pl_to_sql23




Overview
Explore in AI Chat

Overview

DPP_BPEL_UPDATELISTPRICE is a PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Advanced Pricing (formerly Oracle Pricing) and ETRM (Enterprise Territory and Price Management) modules. Its central responsibility is to provide the database-side implementation that allows list price data to be updated through a BPEL (Business Process Execution Language) service interface, effectively bridging external web-service invocations with the internal pricing engine. The package is classified as OTHER within the ETRM 12.2.2 metadata, meaning it is an internal supporting program rather than a public, documented API. It depends on DPP_LISTPRICE_PVT, the core private pricing package that encapsulates the business rules for creating and maintaining price list lines, and exposes the logic required to translate externally supplied data structures into the calls expected by the pricing engine.

Key Procedures and Functions

The documented package exposes seven procedures and functions, which fall into two functional groups:

  • PL_TO_SQL22, PL_TO_SQL23, PL_TO_SQL24 — Utility routines that convert PL/SQL data structures into SQL-consumable form. In the context of BPEL integration, these are used to marshal complex nested pricing data so that it can be persisted or passed to the pricing engine.
  • SQL_TO_PL22, SQL_TO_PL23 (and the related SQL_TO_PL24) — The inverse routines, reconstructing PL/SQL collections and records from SQL result sets retrieved from the pricing tables.
  • DPP_LISTPRICE_PVT$UPDATE_LIST — The principal worker procedure. It serves as the wrapper that invokes the pricing engine's list price update logic, delegating to DPP_LISTPRICE_PVT and its dependent transaction handlers (DPP_LISTPRICE_PVT_DPP_TXN_H12, L13, L14) to apply the requested list price changes.

No parameter lists are documented, and none should be assumed.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM, an Oracle Applications special-purpose table used to store PL/SQL index-by tables during a session. It is commonly used by the pricing packages to stage collection data temporarily while processing updates across transaction boundaries, enabling the conversion routines (PL_TO_SQL and SQL_TO_PL) to persist and retrieve intermediate results. All other persistence for list price information is handled indirectly through the DPP_LISTPRICE_PVT package rather than by direct SQL against the base pricing tables.

Usage Notes

DPP_BPEL_UPDATELISTPRICE is not intended for direct invocation by end users or through standard Oracle EBS forms or concurrent programs. It is invoked programmatically, typically from a BPEL or SOA-based integration flow that accepts a list price update request for external or internal consumption. Because the package is not referenced by any other database object (per the ETRM dependency report), it functions as an entry point located at the outer edge of the pricing integration stack. Developers extending pricing interfaces should treat it as an internal implementation detail and rely instead on the documented DPP_LISTPRICE_PVT API for custom development. Its behavior is version-sensitive: the same object is present in both EBS 12.1.1 and 12.2.2, but the DPP_LISTPRICE_PVT transaction handlers it depends on vary between releases.