Search Results get_product_desc




Overview
Explore in AI Chat

Overview

QP_MASS_MAINTAIN_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the Oracle Advanced Pricing mass maintenance feature set by providing shared helper logic that resolves pricing attribute values, product descriptions, units of measure, and flexfield value set queries for price list and modifier maintenance operations. The package is classified as a UTIL object in the ETRM repository, indicating that it is not itself an end-user API but a supporting utility layer consumed by other pricing components. Its header identifies the package as QP_MASS_MAINTAIN_UTIL and records a source revision date of 2008/07/28, reflecting the long-standing stability of this code base across the 12.x family.

Key Procedures and Functions

  • CHECK_SS_PTE_CODES_MATCH — Returns a VARCHAR2 indicator used to determine whether the source system code and pricing transaction entity (PTE) code associated with a passed list header identifier match the corresponding profile option values. The documentation explicitly notes the inverted return convention: the function returns 'N' when the codes match and 'Y' when they do not, a deliberate design choice that callers must observe.
  • GET_PRODUCT_DESC — Returns the product description for a given pricing attribute context, attribute name, and attribute value combination. It allows mass maintenance logic to present a readable description rather than a raw identifier.
  • GET_PRODUCT_UOM_CODE — Returns the unit of measure code for a product identified by a list line identifier together with a pricing attribute context and attribute. This is the function most relevant to users searching for get_product_uom_code; it enables callers to derive the UOM associated with the product on a given price list line without directly querying product master data.
  • GET_VALUESET_SELECT — A procedure that retrieves the SQL SELECT statement associated with a given context code and segment code, returning it through an OUT parameter. Optional parameters accommodate segment map columns and hierarchical category handling for PTE and source system segments.

Tables Accessed

The package references the following tables through APPS synonyms:

  • FND_FLEX_VALUE_SETS — Consulted by GET_VALUESET_SELECT to resolve the value set definitions associated with pricing context and segment codes.
  • QP_LIST_HEADERS_B — The base price list header table, used by CHECK_SS_PTE_CODES_MATCH to retrieve the source system and PTE codes for a given list header.
  • QP_PRC_CONTEXTS_B — Provides pricing context definitions that map contexts to their underlying value set and segment structures.
  • QP_PRICING_ATTRIBUTES — Supplies attribute metadata needed to interpret context and attribute combinations passed to the description and UOM functions.
  • QP_SEGMENTS_B — Holds segment definitions used together with context codes when resolving value set SELECT statements.

Usage Notes

QP_MASS_MAINTAIN_UTIL is invoked indirectly rather than directly by end users. It is referenced by three other packages within the pricing module, which call its functions to resolve product descriptions, UOM codes, and value set queries during mass maintenance of price lists and modifiers. The package is typically executed in the context of the Oracle Advanced Pricing forms and concurrent programs that perform bulk updates to list lines, where resolving descriptive and UOM information for each line is necessary. Custom extensions that need to replicate mass maintenance behavior may call these functions directly from PL/SQL, but should account for the inverted return logic of CHECK_SS_PTE_CODES_MATCH and the OUT parameter pattern of GET_VALUESET_SELECT. Because the package operates on base tables and profile options, callers should ensure that the correct operating unit and pricing context are established before invocation.