Search Results validate_uom

Overview

QP_CATEGORY_MAPPING_RULE is an Oracle Applications (APPS) PL/SQL package that belongs to the Oracle Advanced Pricing (QP) module. Its principal business function is to resolve the item category associated with a given inventory item so that pricing and attribute-mapping logic can operate against the correct category context. In Oracle EBS, pricing attributes such as item category are essential for building qualifiers, price lists, and modifier rules that target specific product categories rather than individual items. This package encapsulates the category lookup so that pricing engines and attribute-mapping routines can retrieve a category value in a consistent, reusable manner.

The package header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, and it exposes a single public function. Its source header tag (QPXPSICS.pls) and the reference to bug 4753707 indicate a maintenance history typical of long-lived pricing utilities in the 11i/12.x lineage. The package is classified in ETRM as an "OTHER" API and is referenced by one other package, confirming it acts as a supporting utility rather than a top-level public API.

Key Procedures and Functions

• GET_ITEM_CATEGORY — The sole documented function. It accepts an inventory item identifier and returns a multi-record collection of type QP_Attr_Mapping_PUB.t_MultiRecord. Its purpose is to derive the category (or set of category values) mapped to the supplied item, returning the result in the pricing attribute-mapping structure used elsewhere in Advanced Pricing.

The header also contains a commented-out function, VALIDATE_UOM, which was disabled for bug 4753707 and is therefore not part of the active interface. No other procedures or functions are exposed.

Tables Accessed

Through APPS synonyms, the package references the following objects:

• MTL_ITEM_CATEGORIES — the primary assignment table linking inventory items to categories.
• MTL_CATEGORIES_B, MTL_CATEGORY_SETS_B, MTL_DEFAULT_CATEGORY_SETS — category definitions, category sets, and the default category set used to restrict the lookup to the appropriate functional category set.
• ENI_DENORM_HIERARCHIES — a denormalized hierarchy structure that supports hierarchical category resolution.
• QP_PTE_REQUEST_TYPES_B, QP_PTE_SOURCE_SYSTEMS, QP_SOURCESYSTEM_FNAREA_MAP — pricing transaction entity (PTE) setup tables that govern how the source system and function area map to pricing request types.
• PLITBLM — a PL/SQL table utility (index-by table) used internally for collection handling.

Usage Notes

QP_CATEGORY_MAPPING_RULE is typically invoked indirectly rather than by end users. It is called by pricing attribute-mapping routines — most notably within the QP_Attr_Mapping_PUB family — that need to translate an inventory item into its category for qualifier or attribute evaluation during pricing. This makes it relevant to price list and modifier processing, where category-based qualifiers must be resolved at runtime.

The return type, t_MultiRecord, indicates the function can yield multiple category records, so callers must iterate the collection rather than assume a single value. In 12.1.1 and 12.2.2 the package behavior is stable; the only structural change of note is the removal of VALIDATE_UOM. Custom code should call GET_ITEM_CATEGORY only through supported interfaces and should not modify the package, as it is an APPS-owned object and referenced by dependent pricing packages.