Search Results dpp_utility_pvt




Overview
Explore in AI Chat

Overview

APPS.DPP_UTILITY_PVT is a private (PVT) PL/SQL utility package within the Oracle E-Business Suite Distribution and Pricing (DPP) module. It is not an end-user facing API; rather, it is an internal helper package whose sole purpose is to centralize reusable lookup, search, and retrieval logic that other DPP packages consume. In Oracle EBS 12.1.1 and 12.2.2, the DPP schema supports supplier claims, transaction claims, covered inventory, and pricing-related processing. The utility package abstracts common data access patterns — vendor, customer, item, warehouse, price, and inventory lookups — so that the surrounding business logic packages remain focused on workflow and validation.

Because the package is classified as a PVT package and depends on FND_API and FND_MSG_PUB, it participates in the standard Oracle EBS API error-handling and messaging conventions. Errors raised by the utility routines are surfaced to calling packages through the common message stack rather than through direct SQL exceptions.

Key Procedures and Functions

DPP_UTILITY_PVT exposes 28 documented procedures and functions, which fall into three functional groups. The SEARCH_* routines provide flexible lookup by name, number, or description: SEARCH_VENDORS, SEARCH_VENDOR_SITES, SEARCH_VENDOR_CONTACTS, SEARCH_ITEMS, SEARCH_CUSTOMER_ITEMS, SEARCH_CUSTOMER_ITEMS_ALL, SEARCH_WAREHOUSES, SEARCH_CUSTOMERS, and SEARCH_CUSTOMERS_ALL. These routines supply the query capability behind selection lists and LOVs presented during claim entry.

The GET_* routines retrieve specific records once an identifier is known: GET_VENDOR, GET_VENDOR_SITE, GET_VENDOR_CONTACT, GET_WAREHOUSE, and GET_CUSTOMER resolve party entities, while GET_PRODUCT, GET_LISTPRICE, and GET_LASTPRICE return item and pricing information. GET_COVEREDINVENTORY, GET_INVENTORYDETAILS, and GET_CUSTOMERINVENTORY return inventory positions relevant to claim eligibility and reconciliation. Collectively these routines enforce consistent single-record retrieval across all DPP callers, avoiding duplicated SQL.

Tables Accessed

The package reads and writes through APPS synonyms across several ownership domains. Supplier data is sourced from AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL. Customer data is drawn from DPP_CUSTOMER_CLAIMS_ALL, while claim and inventory detail transactions are stored in DPP_TRANSACTION_HEADERS_ALL, DPP_TRANSACTION_LINES_ALL, DPP_TRANSACTION_CLAIMS_ALL, DPP_INVENTORY_DETAILS_ALL, and DPP_INVENTORY_DETAILS_ADJ_ALL. Execution and logging are supported by DPP_EXECUTION_PROCESSES, DPP_LOG_MESSAGES, and the DPP_DEBUG_LOG_ID_SEQ sequence. Surrogate keys for inventory detail inserts come from DPP_INVENTORY_DETAILS_SEQ and DPP_INV_DETAILS_ADJ_ID_SEQ. Financial and organizational defaults are read from FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL.

Usage Notes

DPP_UTILITY_PVT is referenced by 19 other DPP packages, including DPP_APPROVAL_PVT, DPP_CLAIMS_PVT, DPP_COVEREDINVENTORY_PVT, DPP_CUSTOMERCLAIMS_PVT, DPP_ERROR_PVT, DPP_EXECUTIONDETAILS_PVT, DPP_ITEMCOST_PVT, DPP_LISTPRICE_PVT, DPP_LOG_PVT, DPP_NOTIFICATION_PVT, DPP_PRICING_PVT, DPP_PURCHASEPRICE_PVT, DPP_REQUEST_STATUS_PVT, DPP_PURCHASEPRICE_PVT, DPP_SLA_CLAIM_EXTRACT_PUB, DPP_TRANSACTION_PVT, DPP_UIWRAPPER_PVT, and DPP_BUSINESSEVENTS_PVT. Because it is part of the DPP application’s private implementation layer, direct invocation from customer extensions is not supported; any custom code requiring equivalent lookups should call the corresponding public DPP package or the underlying Oracle APIs instead. Modifications to its behavior should only come from Oracle patches, as DPP upgrades assume its interface remains stable.