Search Results are_there_breaks




Overview
Explore in AI Chat

Overview

QP_VIEW_UTIL is a utility PL/SQL package owned by APPS in the Oracle E-Business Suite Advanced Pricing module. It supports the presentation and interpretation of pricing entities stored in Oracle Advanced Pricing, particularly pricing list lines, qualifiers, and pricing attributes. The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, which is typical of Oracle EBS utility packages intended to be called from forms, concurrent programs, and other PL/SQL APIs.

The package provides helper functions that translate internal pricing identifiers into human-readable entity identifiers and values, detect pricing breaks, and resolve pricing attribute context information. In release 12.1.1 and 12.2.2, these capabilities are used where the pricing UI or downstream logic must interpret list line data without directly querying the underlying pricing tables.

Key Procedures and Functions

The documented interface consists of seven functions and one procedure:

  • Get_Entity_Id — Returns the entity identifier associated with a given pricing list line. This is the function most relevant to the user's search for "get_entity_id," since it resolves the entity ID for a list line record.
  • Get_Entity_Value — Returns the entity value corresponding to a pricing list line.
  • Are_There_Breaks — Indicates whether pricing breaks exist for a given list line, supporting break-based price determination logic.
  • Get_Price_List_Attribute — Returns the price list attribute descriptor.
  • Get_Price_List_Context — Returns the price list context descriptor.
  • Get_Parent_Discount_Line_Id — Returns the parent discount line identifier for a given list line, used in discount hierarchy resolution.
  • Get_Attribute_Code — Resolves an attribute code from a supplied context and attribute name.
  • Get_Context_Attributes — Outputs context, attribute, product flag, and qualifier flag information for a given entity ID.

Tables Accessed

The package references the QP_PRICING_ATTRIBUTES and QP_QUALIFIERS tables through APPS synonyms. QP_PRICING_ATTRIBUTES stores the pricing attribute definitions and context information used by the context and attribute resolution functions. QP_QUALIFIERS stores qualifier definitions that determine when pricing rules and list lines apply. The package reads these tables to resolve entity IDs, entity values, contexts, attribute codes, and qualifier flags.

Usage Notes

QP_VIEW_UTIL is classified as a UTIL package and is referenced by five other packages within the Advanced Pricing schema. It is typically invoked from Oracle Forms-based pricing screens, concurrent programs, and custom PL/SQL code that needs to interpret pricing list line data. Because the package runs with invoker's rights, callers must have appropriate privileges on the referenced tables. When resolving Get_Entity_Id, callers supply a list line ID and receive the entity identifier as a VARCHAR2, which can then be used with companion functions such as Get_Entity_Value or Get_Context_Attributes. Developers extending pricing logic should treat this package as a read-oriented utility rather than a transactional API.