Search Results sql_to_pl6




Overview
Explore in AI Chat

Overview

DPP_BPEL_UPDATEEXECDTLS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API. Its name reflects its role in the Distributed Planning / BPEL (Business Process Execution Language) integration layer, where it supports the update of execution detail records associated with outbound or inbound BPEL process flows. Specifically, the package provides a set of conversion helper functions that translate between two representations of an execution-details row: the PL/SQL record type DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE and the SQL object type DPP_EXECUTIONDETAILS_PVT_DPP_. This bidirectional mapping allows code paths that work with strongly typed PL/SQL records to interoperate with code paths that manipulate SQL objects, which is a common requirement when execution state must be persisted or passed across process boundaries. The package header carries the version stamp $Header: dppvbueb.pls 120.2 2011/08/10 13:56:59 rvkondur ship $, indicating a shipping release of the DPP module. The object is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2, where the same private API structure is registered.

Key Procedures and Functions

The package exposes seven documented program units, all private helper routines rather than public APIs:

  • PL_TO_SQL4 — Converts a PL/SQL execution-details update record into the equivalent SQL object type instance, mapping each field (transaction header, organization, execution detail, output XML, status, end date, provider process identifiers, and audit columns) onto the object attributes.
  • SQL_TO_PL4 — Performs the inverse conversion, populating a PL/SQL update record from a SQL object instance.
  • PL_TO_SQL5 — A variant of the PL/SQL-to-SQL conversion, paired with the type variation used in a different execution-detail context.
  • SQL_TO_PL5 — The corresponding SQL-to-PL/SQL conversion for that variant.
  • PL_TO_SQL6 — The conversion routine specifically referenced in the source excerpt and the object of the user's search; it maps the PL/SQL update record into a SQL object representation, initializing the target object with null attributes before assignment.
  • SQL_TO_PL6 — The inverse of PL_TO_SQL6.
  • DPP_EXECUTIONDETAILS_PVT$UPDA — The update routine that persists changes to execution details, invoking the conversion helpers as needed.

The numeric suffixes (4, 5, 6) distinguish conversion variants, likely corresponding to different record shapes, attribute sets, or call contexts within the DPP execution-details private layer.

Tables Accessed

ETRM metadata records a single referenced table for this package: PLITBLM, accessed through an APPS synonym. PLITBLM is the standard Oracle EBS table used as a temporary store for values passed to and from BPEL or workflow process invocations, effectively serving as a parameter or context buffer. The package reads and writes execution-details state indirectly through this mechanism, coordinating the DPP execution detail update with the surrounding BPEL process integration.

Usage Notes

DPP_BPEL_UPDATEEXECDTLS is a private package body and is not referenced by any other documented package (0 dependents per ETRM). It is therefore invoked within the DPP/BPEL execution-details flow itself—typically from the DPP_EXECUTIONDETAILS_PVT private layer or a BPEL callback—rather than from standard EBS forms or concurrent programs. Developers extending or troubleshooting DPP BPEL integrations, or tracing the PL_TO_SQL6 conversion called out in the source listing, should treat these functions as internal implementation detail. Direct invocation from custom code is not recommended; any extension should instead target the supported public APIs of the DPP module, since these helper routines carry no documented API classification beyond "OTHER" and no upgrade guarantee.