Search Results qp_view_util




Overview
Explore in AI Chat

Overview

QP_VIEW_UTIL is a utility package body in the APPS schema that supports Oracle Advanced Pricing (formerly Oracle Pricing) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to service the display, resolution, and interpretation of pricing entities — price lists, qualifiers, pricing attributes, and discount lines — for user-facing pricing views and forms. The package abstracts the retrieval of entity identifiers, entity values, attribute codes, and context attributes so that pricing UI components, concurrent processes, and dependent PL/SQL units can resolve pricing metadata without duplicating lookup logic.

Per ETRM 12.2.2, QP_VIEW_UTIL is classified as a UTIL (utility) API, is VALID, and exposes eight documented procedures/functions. It depends on FND_API, QP_PRICING_ATTRIBUTES, QP_QUALIFIERS, QP_UTIL, and the STANDARD package, and it is referenced by five other database objects. It is not referenced by any object outside the APPS schema in the dependency extract, confirming its role as an internal pricing-layer helper rather than a public integration API.

Key Procedures and Functions

The package exposes the following documented entry points:

  • GET_ENTITY_ID — Resolves the internal identifier for a pricing entity, allowing callers to map a view-level entity reference to its underlying primary key.
  • GET_ENTITY_VALUE — Returns the display or stored value associated with a pricing entity, supporting view rendering and validation.
  • ARE_THERE_BREAKS — Determines whether pricing breaks (price breaks or qualifying breaks) exist for a given context, enabling conditional UI behavior and pricing evaluation logic.
  • GET_PRICE_LIST_ATTRIBUTE — Retrieves a specific attribute value associated with a price list, used when displaying or evaluating price list attribute data.
  • GET_PRICE_LIST_CONTEXT — Returns the pricing context for a price list, allowing callers to establish the attribute/qualifier context in which pricing is evaluated.
  • GET_PARENT_DISCOUNT_LINE_ID — Resolves the parent discount line identifier for a given discount line, supporting hierarchical discount (modifier) relationships.
  • GET_ATTRIBUTE_CODE — Returns the attribute code corresponding to a pricing attribute, used to translate internal attribute identifiers into pricing attribute codes.
  • GET_CONTEXT_ATTRIBUTES — Retrieves the set of context attributes applicable to a pricing context, supporting dynamic attribute resolution in views and forms.

No parameter lists are documented in the ETRM extract; callers should reference the package specification in the target instance before invoking these procedures from custom code.

Tables Accessed

QP_VIEW_UTIL accesses two core pricing tables via APPS synonyms:

  • QP_PRICING_ATTRIBUTES — Stores pricing attribute definitions and values. The package reads this table to resolve attribute codes and price list attribute values.
  • QP_QUALIFIERS — Stores qualifier definitions and qualifier groupings. The package reads this table to determine context attributes and to support qualifier/break evaluation.

These accesses support the utility functions that translate between entity identifiers, attribute codes, and view-ready values.

Usage Notes

QP_VIEW_UTIL is typically invoked from Oracle Advanced Pricing forms and pricing view logic where pricing attributes, qualifiers, price list contexts, and discount line hierarchies must be resolved for display. Because it is an internal UTIL package, it is not intended as a public integration API; nevertheless, custom Oracle EBS extensions may reference it when building pricing-related UI or validation routines. It is referenced by five other packages, indicating reuse across the pricing module rather than direct external integration. When invoking from custom code, verify the current package specification, as signatures are instance-version dependent and not fully documented in the ETRM extract.