Search Results dpp_inv_details_adj_id_seq

Overview

DPP_COVEREDINVENTORY_PVT is an internal (private) PL/SQL package body in the APPS schema that participates in Oracle E-Business Suite's Distribution Profitability Planning (DPP) architecture. DPP provides channel revenue management and profitability analysis for the supply chain and trade management modules. The covered inventory concept reflects goods that are held on hand and subject to supplier trade profiles or channel programs, and this package is the engine that identifies, populates, and maintains the covered inventory records used downstream for profitability calculations.

The "PVT" suffix signals that this is a private helper package. It is not exposed as a public API. The absence of an FND_API standard API declaration, combined with a purely PL/SQL-internal signature, confirms that its procedures are invoked from other DPP packages rather than directly from forms or external integrations. The documented metadata states that the object is VALID and that it is referenced by three other packages, meaning it is a load-bearing component embedded within the DPP package hierarchy.

Key Procedures and Functions

• SELECT_COVEREDINVENTORY — Retrieves covered inventory information by querying on-hand balances, system items, and supplier trade profile data. This is the read side of the package, providing the result set that callers use to evaluate inventory eligibility under trade profiles.
• POPULATE_COVEREDINVENTORY — Inserts new covered inventory detail rows into the inventory details structures. It is responsible for generating primary keys from the DPP_INVENTORY_DETAILS_SEQ sequence and for recording adjustment rows keyed by DPP_INV_DETAILS_ADJ_ID_SEQ, the sequence most commonly surfaced in searches for this object.
• UPDATE_COVEREDINVENTORY — Modifies existing covered inventory records, typically in response to changes in on-hand quantities, transaction lines, or execution detail status. It maintains referential integrity against the transaction header and line records that produced the inventory movement.

The precise parameter lists of these procedures are not published in the ETRM metadata and should be obtained by compiling the source with SHOW DEPENDENT CODE or by querying ALL_SOURCE. No parameters are assumed here.

Tables Accessed

• DPP_INVENTORY_DETAILS_ALL / DPP_INVENTORY_DETAILS_ADJ_ALL — Core insert and update targets for covered inventory and its adjustments. The presence of DPP_INV_DETAILS_ADJ_ID_SEQ as a dependency is expected, as the adjustment table's primary key is drawn from that sequence.
• DPP_EXECUTION_DETAILS, DPP_TRANSACTION_HEADERS_ALL, DPP_TRANSACTION_LINES_ALL — Provide the execution and transaction context from which inventory activity is derived.
• MTL_ONHAND_QUANTITIES_DETAIL, MTL_SYSTEM_ITEMS, MTL_PARAMETERS — Supply quantities, item attributes and organization-level inventory controls.
• OZF_SUPP_TRD_PRFLS_ALL — Supplier trade profiles that define which inventory qualifies as covered.
• ORG_ORGANIZATION_DEFINITIONS — Resolves inventory organization identifiers.
• FND_GLOBAL, FND_PROFILE, FND_MESSAGE, FND_MSG_PUB, FND_LOG, FND_API — Handle session context, messages, and debug logging via DPP_LOG_PVT.

Usage Notes

DPP_COVEREDINVENTORY_PVT is invoked internally by the three DPP packages that reference it, typically during concurrent program execution in the DPP processing cycle, where covered inventory is recalculated against current on-hand balances and trade profiles. Because it is a private package, it should not be called directly from custom forms or extensions without accepting the risk that Oracle may change its signature. Database administrators investigating performance or locking issues around DPP_INV_DETAILS_ADJ_ID_SEQ should note that the sequence dependency originates here and in its sibling inventory detail packages. Diagnostic tracing can be enabled through the DPP_LOG_PVT and FND_LOG dependencies.