Search Results ibe_price_pvt




Overview
Explore in AI Chat

Overview

APPS.IBE_PRICE_PVT is a private PL/SQL package within the Oracle iStore (IBE) application module of Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the pricing engine logic that supports the iStore storefront, most notably the runtime pricing of catalog items, quote lines, and shopping cart entries presented to customers. The package operates as a "PVT" classified API, meaning it is intended for internal invocation by other IBE packages rather than as a publicly documented interface for customer extensions. Its central responsibility is to accept pricing requests, resolve the applicable price lists and qualifiers for a given customer and item context, call into the Oracle Advanced Pricing (QP) engine where required, and return the resolved price and associated request line and header attributes to the calling layer.

The dependency metadata confirms that IBE_PRICE_PVT is referenced by APPS.IBE_CATALOG_PVT, which is the catalog browsing and display package that surfaces items and their prices on storefront pages. This establishes IBE_PRICE_PVT as a supporting engine beneath the catalog presentation tier rather than a top-level entry point.

Key Procedures and Functions

The documented interface consists of sixteen procedures and functions. The principal named entry points are:

  • GETPRICE — Resolves a price for a single item or line context, returning the applicable price to the caller. This is the primary single-item pricing entry point.
  • GETPRICES — A bulk variant of GETPRICE that resolves prices for multiple items or lines in one invocation, reducing round trips during catalog or cart rendering.
  • PRICE_REQUEST — Establishes and processes a pricing request against the Advanced Pricing engine, orchestrating qualifier and price list evaluation for the submitted context.
  • GETREQLINEATTRANDQUAL — Retrieves the request line attributes together with the matching qualifiers that apply to a specific request line, supplying the input context the pricing engine requires.
  • GETREQHEADERATTRANDQUAL — Performs the equivalent retrieval at the request header level, gathering header attributes and qualifiers.

Consistent with the PL/SQL exposed-cursor convention documented in the ETRM metadata, the package publishes these procedures and functions along with the relevant type declarations needed by callers.

Tables Accessed

The package references the following objects, primarily through APPS synonyms:

  • HZ_CUST_ACCOUNTS — Read to resolve the customer account context, which drives customer-specific price lists, agreements, and qualifiers.
  • OE_SYSTEM_PARAMETERS_ALL — Read to obtain Order Management system parameters that influence pricing behavior, such as currency and pricing-related defaults.
  • DBMS_UTILITY — Oracle-supplied utility package used for internal PL/SQL operations.
  • PLITBLM — Oracle-supplied PL/SQL table package family used for collection handling.

Pricing computations themselves are delegated to QP_PREQ_GRP, the Advanced Pricing request-group engine, which IBE_PRICE_PVT calls to evaluate qualifiers and derive the final price. Other dependencies include the standard FND_API error-handling framework and the JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_300 collection types used to pass attribute and qualifier arrays between procedures.

Usage Notes

IBE_PRICE_PVT is invoked indirectly through iStore storefront flows. When a customer browses the catalog, IBE_CATALOG_PVT calls IBE_PRICE_PVT to obtain the displayed price for each item. During shopping cart and checkout processing, the package is called again to recompute prices with current qualifiers and customer context. Because it is a private package, it is not documented for direct customer invocation; however, custom iStore extensions that need to reproduce storefront pricing behavior may call it, provided they observe the same argument conventions used by IBE_CATALOG_PVT. Any customization should be validated against both 12.1.1 and 12.2.2, since APPS-private packages are not covered by Oracle's public API compatibility guarantees.