Search Results dppcoveredinventorypvtdpp2_dp

Overview

APPS.DPP_BPEL_SELCOVINV is a PL/SQL package registered in the Oracle E-Business Suite APPS schema and reported with a status of VALID. It belongs to the ETRM (Enterprise Tax and Regulatory Management, historically distributed as Oracle E-Business Tax / Configuration Manager) functional area and is closely associated with the DPP_COVEREDINVENTORY_PVT family of packages. Its name indicates a Business Process Execution Language (BPEL) selection utility for covered inventory, meaning it exists to support the selection and extraction of covered-inventory data records for downstream processing and integration.

The package is not an end-user facing component. It functions as an integration and data-marshalling layer. In EBS 12.1.1 and 12.2.2, ETRM uses BPEL-based services for certain tax determination, reporting, and inventory-coverage flows, and packages bearing the BPEL prefix typically bridge native PL/SQL business logic with those external service invocations. DPP_BPEL_SELCOVINV provides this bridge for covered inventory selection.

Key Procedures and Functions

The documented metadata lists 15 procedures and functions. Twelve of these follow a paired conversion naming pattern that indicates bidirectional translation of data representations between PL/SQL collections and SQL result sets:

• PL_TO_SQL0 through PL_TO_SQL6 — Seven procedures that convert PL/SQL-side data structures (for example, records assembled from covered-inventory processing) into SQL-accessible form, enabling set-based querying, joining, or streaming of that data.
• SQL_TO_PL0 through SQL_TO_PL6 — Seven complementary procedures that perform the reverse translation, loading SQL query results back into PL/SQL structures for use by the covered-inventory business logic.
• DPP_COVEREDINVENTORY_PVT$SELE — A selection routine associated with the DPP_COVEREDINVENTORY_PVT private package, which is the core covered-inventory engine referenced by this package.

The numeric suffixes 0 through 6 correspond to distinct data shapes or usage scenarios handled by the selection logic. Because the ETRM documentation does not expose parameter signatures for this object, parameter lists are intentionally not reproduced here.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This is consistent with the conversion-oriented procedure names: PLITBLM serves as the staging/interchange structure through which PL/SQL and SQL representations of covered-inventory data are materialized during selection. In practice the package also depends heavily on the DPP_COVEREDINVENTORY_PVT package and its generated variants (DPP_COVEREDINVENTORY_PVT_DPP1, _DPP2, _DPP4, _DPP6, and the DPPCOVEREDINVENTORYPVTDPP2_DP / DPP4_DP dependent objects). These internal dependencies carry the actual querying of covered-inventory tables; DPP_BPEL_SELCOVINV orchestrates the selection and formatting around them.

Usage Notes

DPP_BPEL_SELCOVINV is intended for programmatic invocation rather than interactive use. It is typically called from BPEL-based integration processes, from concurrent programs that prepare covered-inventory data for external services, and from custom extensions that need to reuse ETRM's covered-inventory selection logic. Because it is recorded as referenced by no other packages and references only the covered-inventory private packages plus STANDARD, it is a leaf-level integration utility.

In both 12.1.1 and 12.2.2, the object is delivered in VALID status and should not be modified. Customizations should wrap the package via public APIs or copies. Where diagnostics are required, dependency chains can be traced from DPP_COVEREDINVENTORY_PVT upward to this package, and from this package to the BPEL service definitions that consume its output.