Search Results get_unit_name

Overview

OE_PRICE_LIST_PVT is a private PL/SQL package body in the Oracle E-Business Suite Order Management (OM) schema, owned by APPS. It encapsulates the pricing logic that resolves list prices for order lines and returns them to calling APIs. The package name carries the _PVT suffix, which by Oracle EBS convention identifies it as an internal, non-public implementation package rather than a formally published API. Its existence is tied to the Order Management price list and list-line configuration, where price list headers defined in SO_PRICE_LISTS are resolved against detail rows in SO_PRICE_LIST_LINES to derive a unit list price for a given inventory item, unit of measure, and optional pricing attributes.

The package body declares a global constant, G_PKG_NAME, used by the messaging routines in the event of an unexpected error, and a global counter, G_Fetch_Level, which tracks the current fetch level so the package can suppress the "no list price found" message for non-primary price lists. That design note reflects a specific functional requirement: the missing-list-price message is emitted only for the primary price list.

Key Procedures and Functions

The ETRM documentation records a single classified procedure for this package: FETCH_LIST_PRICE. This is the principal entry point of the package body. It follows the standard Oracle EBS API calling convention, accepting a version number, initialization flag, and validation level, and returning status, message count, and message data to the caller. Its input parameters include the price list identifier, inventory item identifier, unit code, service duration, item type code, price method code, and a set of generic pricing attributes (PRICING_ATTRIBUTE1 through at least PRICING_ATTRIBUTE9) used to discriminate among qualified list lines.

In addition to FETCH_LIST_PRICE, the package body source declares several private utility functions that support the main API. These include Get_Sec_Price_List, which resolves a secondary price list; Get_Price_List_Name, which returns the descriptive name for a given price list identifier; Get_Item_Description, which returns descriptive text for an inventory item; and Get_Unit_Name, which converts a unit-of-measure code into its display name. The functions are declared for internal use by the fetch routine and are not exposed as public APIs.

Tables Accessed

The package operates against four documented base tables, referenced through APPS synonyms: SO_PRICE_LISTS and SO_PRICE_LIST_LINES supply the price list header and the qualifying detail lines from which list prices are read; MTL_SYSTEM_ITEMS provides item validation and description information used by the fetch and item-description logic; and MTL_UNITS_OF_MEASURE supplies the unit-of-measure name resolved by Get_Unit_Name. Reads against the pricing tables are the core of the package; the inventory master tables are consulted for reference data.

Usage Notes

Because OE_PRICE_LIST_PVT is a private package, it is not intended for direct invocation by external custom code. It is called internally by the Order Management pricing modules and is referenced by one other package within the EBS schema. Typical callers are the higher-level Order Management order-entry and pricing APIs that need a list price before applying modifiers, discounts, and charges. When extending or diagnosing pricing behavior in EBS 12.1.1 or 12.2.2, the package should be treated as an implementation dependency: changes to its logic can affect every caller that relies on FETCH_LIST_PRICE, and customizations should be directed at supported public APIs rather than this private body.