Search Results select_coveredinventory

Overview

The APPS.DPP_COVEREDINVENTORY_PVT package is a private PL/SQL API within the Oracle E-Business Suite Distribution and Pricing/Advanced Pricing Processing (DPP) module. Its documented purpose is to manage "covered inventory" — inventory units that are subject to supplier trade profile agreements, rebate eligibility, or coverage-based pricing arrangements. In this context, "coverage" refers to the linkage between on-hand inventory and supplier programs that determine which units qualify for specific pricing, accrual, or settlement treatment.

The package is classified as a PVT (private) API, meaning it is internal to the DPP application and is not intended for direct invocation by external or customer extensions. It follows the standard Oracle EBS API packaging convention, depending on FND_API for the common API framework and FND_MSG_PUB for message stack handling, indicating that its procedures return status codes and error messages through the standard EBS API error-handling mechanism. The package is valid across Oracle EBS 12.1.1 and 12.2.2 and resides in the APPS schema.

Key Procedures and Functions

The package exposes three documented procedures that form a complete lifecycle for covered inventory processing:

• SELECT_COVEREDINVENTORY — Retrieves covered inventory records based on defined filter criteria. This is the query entry point used to identify which inventory units are subject to coverage, likely invoked before population or update operations to establish the working set.
• POPULATE_COVEREDINVENTORY — Creates covered inventory records, deriving coverage associations from supplier trade profiles and on-hand inventory. This procedure performs the initial build of covered inventory data.
• UPDATE_COVEREDINVENTORY — Modifies existing covered inventory records, supporting adjustments to coverage as inventory or supplier program terms change.

Because this is a private package, the exact parameter lists are not published in the ETRM documentation and should not be assumed. The procedures follow standard EBS private API conventions, accepting p_init_msg_list, returning x_return_status, and populating the message stack via FND_MSG_PUB.

Tables Accessed

The package references a substantial set of tables, organized by functional area:

• DPP application tables — DPP_INVENTORY_DETAILS_ALL, DPP_INVENTORY_DETAILS_ADJ_ALL, DPP_TRANSACTION_HEADERS_ALL, DPP_TRANSACTION_LINES_ALL, and DPP_EXECUTION_DETAILS. These hold the core DPP inventory and transaction data that coverage processing operates upon.
• Sequences — DPP_INVENTORY_DETAILS_SEQ and DPP_INV_DETAILS_ADJ_ID_SEQ supply primary keys for newly populated inventory and adjustment records.
• Oracle Inventory tables — MTL_ONHAND_QUANTITIES_DETAIL, MTL_PARAMETERS, and MTL_SYSTEM_ITEMS provide on-hand quantities, organization parameters, and item master attributes essential for identifying eligible inventory.
• Supplier/pricing reference — OZF_SUPP_TRD_PRFLS_ALL supplies supplier trade profile definitions that govern coverage eligibility.
• Utility objects — DUAL, PLITBLM (a PL/SQL index-by table type), and XMLTYPE support query mechanics and structured data processing.

Usage Notes

This package is not intended for direct customer invocation. It is referenced by three other packages within the DPP module, notably DPP_BPEL_POPCOVINV and DPP_BPEL_SELCOVINV — Business Process Execution Language (BPEL) integration packages that orchestrate covered inventory population and selection. It is also referenced by DPP_TRANSACTION_PVT and recursively by itself, indicating internal modular reuse. Typical invocation occurs through concurrent programs and BPEL-based integration flows triggered by pricing or supplier program events. Developers extending DPP functionality should call the higher-level referencing APIs rather than this private package, to preserve supportability across 12.1.1 and 12.2.2.