Search Results get_cust_class_attrib

Overview

QP_UTIL is a utility package in the Oracle E-Business Suite Advanced Pricing module (QP). It provides shared helper routines that other pricing APIs, forms, and concurrent programs depend on for resolving descriptive flexfield context metadata, validating pricing attributes and qualifiers, determining the operational status of the pricing engine, and translating internal entity identifiers into their user-facing names. Its source header (QPXUTILS.pls 120.9) indicates it has been a long-standing component, and the documented metadata lists 52 procedures and functions plus references from 111 other packages, confirming its role as a foundational library rather than an end-user API. The package is classified as UTIL under the APPS schema in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The GET_ENTITYNAME function, the object most commonly located by name, accepts an entity identifier and returns its descriptive name, allowing callers to convert stored foreign keys into human-readable labels. GET_ENTITYVALUE performs the complementary lookup by returning a numeric identifier for a given attribute code.

• GET_SCHEMA — returns the schema name used by the pricing module, supporting dynamic SQL and installation validation.
• IS_VALID_CATEGORY — indicates whether an item belongs to a valid pricing category, addressing a documented defect fix (Bug 5523416).
• ATTRMGR_INSTALLED — determines whether the attribute manager component is present, allowing conditional logic in dependent code.
• GET_SOURCING_INFO — returns sourcing enablement, status, and method for a supplied context type, context, and attribute.
• GET_CONTEXT, GET_CONTEXT_TYPE, GET_CONTEXT_ATTRIBUTE — resolve descriptive flexfield context and attribute metadata for a given flexfield or attribute code.
• IS_PRICINGATTR, IS_QUALIFIER — classify an attribute code as a pricing attribute or a qualifier.
• GET_CUST_CONTEXT, GET_SOLD_TO_ATTRIB, GET_CUST_CLASS_ATTRIB, GET_SITE_USE_ATTRIB — return standard customer-related context and attribute identifiers.
• GET_QP_STATUS — reports the current status of the pricing module.
• VALIDATE_QP_FLEXFIELD, VALIDATE_CONTEXT_CODE, VALIDATE_ATTRIBUTE_NAME, GET_VALUESET_ID — provide flexfield validation and value set resolution services.

Tables Accessed

QP_UTIL reads metadata from FND_DESCR_FLEX_CONTEXTS, FND_DESCR_FLEX_COLUMN_USAGES, and FND_FLEX_VALUE_SETS to resolve flexfield structure, context types, and value sets. QP_LIST_HEADERS_B, QP_LIST_LINES, QP_PRC_CONTEXTS_B, QP_PRC_CONTEXTS_TL, QP_CURRENCY_DETAILS, QP_LIMITS, and QP_LIMIT_ATTRIBUTES supply pricing list, context, currency, and limit definitions. AK_OBJECT_ATTRIBUTES_TL and OE_AK_OBJ_ATTR_EXT provide attribute manager and order-entry attribute metadata used for entity and attribute resolution. FND_APPLICATION and FND_USER support application and user lookups, while MTL_SYSTEM_ITEMS_B underpins item category validation. All access occurs through APPS synonyms.

Usage Notes

QP_UTIL is invoked primarily by other PL/SQL packages, pricing forms, and concurrent programs rather than by end users directly. Typical custom-code scenarios include resolving an entity name during report generation, checking pricing module status before invoking pricing APIs, validating flexfield context values prior to insert, and determining whether a code represents a qualifier or a pricing attribute. Because the package is referenced by 111 other packages and is documented as an internal utility, direct modification is not supported; callers should treat its signatures as stable interfaces and rely on the documented procedures for metadata resolution.