Search Results pl_to_sql1

Overview

DPP_BPEL_UPDATEERROR is an Oracle E-Business Suite package body owned by APPS and classified under the ETRM metadata as OTHER. Its header comment ($Header: dppvburb.pls 120.5 2007/12/18 ... assoni noship $) marks it as a non-shipped support object rather than a formal public API. Functionally, the package provides conversion utilities that translate records between two parallel type representations of the same error data: a PL/SQL-side record type (DPP_ERROR_PVT.DPP_ERROR_REC_TYPE and DPP_ERROR_PVT.DPP_LINES_TBL_TYPE) and a SQL-side object type (DPP_ERROR_PVT_DPP_ERROR_REC_T and DPP_ERROR_PVT_DPP_LINES_TBL_T). This bridging role supports the DPP (Oracle Demand Planning / collaborative planning) BPEL integration, where error and execution details captured during provider process execution must be persisted to or retrieved from database tables. The conversion layer isolates the calling code from the structural differences between the PL/SQL collection types used internally and the SQL object types used when the data crosses the PL/SQL-to-SQL boundary.

Key Procedures and Functions

• PL_TO_SQL1 — Converts a PL/SQL-side table of error lines (DPP_LINES_TBL_TYPE) into the corresponding SQL-side object table type (DPP_LINES_TBL_T). It initializes the destination collection, extends it to match the source count, and iterates from the source's FIRST to LAST index, copying each element into a one-based position. This is the function surfaced by the user's search term.
• PL_TO_SQL0 — Converts a single PL/SQL error record into its SQL object type counterpart, mapping all seven attributes: TRANSACTION_HEADER_ID, ORG_ID, EXECUTION_DETAIL_ID, OUTPUT_XML, PROVIDER_PROCESS_ID, PROVIDER_PROCESS_INSTANCE_ID, and LAST_UPDATED_BY.
• SQL_TO_PL0 — Performs the inverse mapping, taking a SQL object record and populating a PL/SQL record with the same seven attributes.
• SQL_TO_PL1 — The list-level inverse of PL_TO_SQL1, converting the SQL object table type back into the PL/SQL table type.
• DPP_ERROR_PVT$UPDATE_ERROR — The package's substantive operation, invoking the DPP_ERROR_PVT error-handling API to record or update error information. The dollar-sign naming indicates a shadow or wrapper routine associated with DPP_ERROR_PVT.

Tables Accessed

The only table referenced through an APPS synonym is PLITBLM (the PL/SQL intermediate table used by Oracle Forms for name-in and list-in operations). Access to this table is consistent with the package's role as a utility layer invoked from Oracle Forms or PL/SQL contexts that pass record groups and line collections. Error detail records themselves are ultimately managed through the DPP_ERROR_PVT API rather than through direct DML in this package body.

Usage Notes

Because DPP_BPEL_UPDATEERROR is a non-shipped object (noship) and reference count shows no other packages depending on it, it is not part of the supported public interface for EBS 12.1.1 or 12.2.2. It is typically invoked indirectly during BPEL-driven demand planning error processing, particularly where error and execution detail records must be persisted after a provider process completes or fails. The conversion functions, including PL_TO_SQL1, may also be called from custom PL/SQL code that needs to move DPP error line data between PL/SQL and SQL object representations. The FOR loop in PL_TO_SQL1 assumes the source collection is densely populated and one-based; sparse or null collections should be normalized before invocation. Implementers should treat these routines as internal and verify behavior against their specific patch level rather than relying on them as a stable API.