Search Results sql_to_pl11

Overview

DPP_BPEL_POPCOVINV is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its name reflects its role within the DPP (Advanced Planning / Demand Planning) module family, specifically the BPEL integration layer for "POP Covered Inventory" processing. In Oracle EBS 12.1.1 and 12.2.2, the DPP product set supports collaborative planning and supply chain data exchange, and packages bearing the BPEL prefix are responsible for bridging PL/SQL-resident business logic with external BPEL (Business Process Execution Language) orchestration services.

The package is classified under the ETRM "OTHER" API category, indicating it is an internal implementation utility rather than a formally published public API. Its core design pattern is a set of paired type-conversion functions that translate between PL/SQL record types defined in DPP_COVEREDINVENTORY_PVT and SQL object types generated for the integration layer. This conversion is necessary because BPEL web services and XML payloads operate on SQL object types, while the internal planning APIs operate on PL/SQL records. The package therefore acts as a marshalling shim between the two representations.

Key Procedures and Functions

The package exposes fifteen documented subprograms, predominantly bidirectional conversion routines plus one procedural entry point.

• PL_TO_SQL7 — Converts a PL/SQL record of type DPP_COVEREDINVENTORY_PVT.DPP_INV_HDR_REC_TYPE into the corresponding SQL object type DPP_COVEREDINVENTORY_PVT_DPP7. It initializes the object instance and maps each attribute, including TRANSACTION_HEADER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ORG_ID, EXECUTION_DETAIL_ID, OUTPUT_XML, PROVIDER_PROCESS_ID, PROVIDER_PROCESS_INSTANCE_ID, and LAST_UPDATED_BY.
• SQL_TO_PL7 — Performs the inverse mapping, taking a DPP_COVEREDINVENTORY_PVT_DPP7 SQL object and returning a DPP_INV_HDR_REC_TYPE PL/SQL record. It is the counterpart used when inbound data arrives from a BPEL/SQL source.
• PL_TO_SQL8 — Converts a DPP_INV_COV_RCT_REC_TYPE PL/SQL record into the DPP_COVEREDINVENTORY_PVT_DP13 SQL object type, extending the conversion pattern to the covered-inventory receipt record family.
• PL_TO_SQL9, PL_TO_SQL10, PL_TO_SQL11, PL_TO_SQL12, PL_TO_SQL13 — A family of outgoing conversion functions following the same PL/SQL-to-SQL transformation pattern for additional covered-inventory record variants.
• SQL_TO_PL9, SQL_TO_PL10, SQL_TO_PL11, SQL_TO_PL12, SQL_TO_PL13 — The corresponding inbound conversion functions, mapping SQL object types back into PL/SQL record structures.
• SQL_TO_PL8 — The inbound counterpart to PL_TO_SQL8.
• DPP_COVEREDINVENTORY_PVT$POPU — A procedural subprogram (the suffix suggests a populate operation) concerned with populating covered-inventory data structures within the private package scope.

Each conversion function is deliberately mechanical, performing direct attribute assignments without business validation, which preserves data fidelity across the PL/SQL–SQL boundary.

Tables Accessed

The only table referenced through an APPS synonym is PLITBLM. This table is the PL/SQL item/table mapping structure used by the EBS conversion utilities to support bulk data movement between collection types and table structures. In the context of this package, PLITBLM supports the iteration and mapping mechanics that underpin the PL_TO_SQL and SQL_TO_PL conversion routines, particularly where covered-inventory header and receipt records must be traversed. No direct DML against planning business tables is documented within this object; persistence is handled by the covered-inventory private APIs that consume the converted structures.

Usage Notes

DPP_BPEL_POPCOVINV is not intended for direct invocation by end users or standard concurrent programs. It is invoked internally by the BPEL integration framework and by the DPP_COVEREDINVENTORY_PVT package when covered-inventory data must be exchanged with external planning or process-orchestration services. Typical call paths include inbound BPEL callbacks, where the web service layer receives an XML payload that is materialized into SQL object types (for example DPP_COVEREDINVENTORY_PVT_DPP7 or DPP_COVEREDINVENTORY_PVT_DP13) and then converted via the SQL_TO_PL functions into PL/SQL records for validation and processing by the private APIs.

Because the package is categorized as OTHER and carries an internal header, it should be treated as a private implementation detail. Customizations should not call these functions directly; instead, developers should work through the documented DPP_COVEREDINVENTORY_PVT API surface. Any upgrade activity in 12.1.1 or 12.2.2 may replace the conversion signatures as the underlying SQL object types evolve, so direct dependencies on this package risk breakage during patching.