Search Results aso_pricing_flows_pvt




Overview
Explore in AI Chat

Overview

ASO_PRICING_FLOWS_PVT is a private PL/SQL package body in the Oracle E-Business Suite Order-to-Cash (ASO) module. It encapsulates the pricing engine flows that drive Oracle Advanced Pricing (QP) processing for Oracle Quoting. Its central responsibility is to orchestrate pricing requests against quote headers, quote lines, and changed lines, returning recalculated prices, adjustments, and adjustment attributes to the calling session.

The package is classified as PVT, indicating it is an internal implementation layer rather than a published public API. External consumers should interact with the public ASO_QUOTE_PUB or ASO_PRICING_INT interfaces; ASO_PRICING_FLOWS_PVT is invoked from those higher layers. The most common invocation path is the price mode ENTIRE_QUOTE, in which the engine prices every line of a quote in a single logical flow.

The package supports both interactive and batch pricing. It accepts a pricing control record, header, shipment, and line table inputs, and can operate with an internal call flag for nested or recursive pricing activity. Commit and message-list behavior are governed by the standard FND_API conventions.

Key Procedures and Functions

  • PRICE_ENTIRE_QUOTE — Drives pricing for the complete quote. It takes the pricing control record, quote header, header shipment, and quote line table, and returns the repriced line table plus standard FND_API return status, message count, and message data. It is the primary entry point when the pricing mode covers the entire quote rather than selected lines.
  • PRICE_QUOTE_LINE — Prices an individual quote line, providing a narrower path than the entire-quote flow for single-line recalculation and line-level adjustments.
  • PRICE_QUOTE_WITH_CHANGE_LINES — Prices a quote while accounting for lines that have been modified. This flow reconciles changes before pricing so that adjustments and hierarchy relationships remain consistent with the current quote state.
  • PRICE_QUOTE_CALCULATE_CALL — Performs the underlying pricing calculation call, bridging the ASO quoting structures to the QP pricing request mechanism (QP_PREQ_GRP). It is the innermost pricing operation within the package.

Tables Accessed

The package reads and writes quote and pricing structures through APPS synonyms:

Usage Notes

ASO_PRICING_FLOWS_PVT is normally invoked indirectly. Oracle Quoting forms and the ASO_QUOTE_PUB public package call these procedures during quote save, line entry, and repricing events. The ETRM metadata indicates the package is referenced by two other packages, confirming its role as a shared internal service. Customizations should not call it directly; instead, route pricing through ASO_QUOTE_PUB or the public pricing API. Because the procedures use NOCOPY OUT parameters and FND_API message lists, callers must initialize the message list and inspect the return status before consuming output tables.