Search Results get_lastprice

Overview

DPP_UIWRAPPER_PVT is a private PL/SQL package in the APPS schema that serves as the user interface wrapper layer for the Oracle E-Business Suite Procurement and sourcing modules, particularly the ETRM (Enterprise Taxation and Reporting Management) and sourcing/negotiation flows. Its primary business function is to provide form-based OAF and Forms UI components with a consolidated, reusable set of server-side query and retrieval routines. Rather than embedding complex SQL directly into form logic, the wrapper exposes strongly typed record and table structures that forms and concurrent programs can consume. The package defines a rich set of PL/SQL collection types, including vendor_rec_type, vendor_site_rec_type, vendor_contact_rec_type, customer_rec_type, and matching table types, along with a generic search_criteria_rec_type and search_criteria_tbl_type. These typed structures support the LOV (List of Values) and search-and-select patterns used throughout the sourcing user interface.

Key Procedures and Functions

The package exposes twenty-four documented procedures and functions, all classified as PVT (private) API, meaning they are not part of the public integration surface but are internal callers used by Oracle EBS UI code. The documented search routines include 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 functions populate the collection types using search criteria supplied by the UI, supporting both filtered and unfiltered ("ALL") result sets. The retrieval routines include GET_INVENTORYDETAILS, GET_CUSTOMERINVENTORY, GET_LASTPRICE, GET_LISTPRICE, GET_VENDOR, GET_VENDOR_SITE, GET_VENDOR_CONTACT, GET_WAREHOUSE, GET_CUSTOMER, GET_PRODUCT, and GET_ALLAPPROVERS. The procedure GET_CUSTOMERINVENTORY is of particular interest to callers searching for customer inventory information, providing customer-specific on-hand or consigned stock retrieval. The package also declares exception handling for resource_locked and debug constants derived from FND_MSG_PUB to support FND debug logging.

Tables Accessed

Per the documented metadata, the only explicitly referenced table is PLITBLM, accessed through an APPS synonym. PLITBLM is the multi-organization item master and item-related base table used extensively in Oracle Inventory and purchasing item queries. The wrapper package relies on this table to resolve item information returned by routines such as SEARCH_ITEMS, SEARCH_CUSTOMER_ITEMS, GET_CUSTOMERINVENTORY, and GET_PRODUCT. While the collection types reference vendor, customer, and warehouse attributes that originate from supplier, customer, and inventory tables, those lookups are performed via underlying public APIs or views rather than direct table access within this wrapper.

Usage Notes

DPP_UIWRAPPER_PVT is invoked primarily by Oracle EBS Forms and OA Framework pages during sourcing, negotiation, and procurement transactions. It is also referenced by one other package, indicating it participates in a layered call stack where UI event handlers delegate to this wrapper for LOV population and detail retrieval. Custom code should treat this package as a private implementation detail; direct invocation is possible but unsupported because the API classification is PVT and the package is marked "noship" in its header, meaning it is not shipped as a standalone public API. Developers seeking functionality such as GET_CUSTOMERINVENTORY should prefer the corresponding public Inventory or Order Management APIs, or replicate the wrapper's logic through supported views. Because the package is form-driven, parameter lists and record structures are tightly coupled to the current form version, so they may change without notice across patch levels in 12.1.1 and 12.2.2.