Search Results price_quote_line

Overview

ASO_PRICING_FLOWS_PVT is a private PL/SQL package in the Oracle E-Business Suite Order-to-Cash (ASO) product family. Its name reflects its role as the internal pricing engine driver for Oracle Quoting and related sales flows: the "PRICING_FLOWS" component coordinates the sequence of pricing, adjustment, and update operations required to evaluate and apply pricing to quotes and quote lines, while the "PVT" suffix designates it as a private package not intended as a public API contract. The package is declared with AUTHID CURRENT_USER, so it executes under the privileges of the invoking session, and it operates against APPS synonyms in the standard EBS schema model. It serves as the orchestration layer that the public quoting APIs delegate to when prices must be computed for an entire quote, for an individual line, or for a set of changed lines.

Key Procedures and Functions

The documented package exposes four procedures:

• PRICE_ENTIRE_QUOTE — Prices a complete quote, accepting the pricing control record, the quote header record, an optional header shipment record, and a table of quote lines. It returns the processed quote line table along with the standard FND_API return status, message count, and message data outputs. Because free lines require only the quote_line_id during pricing rule processing, the returned line table is used to supply those lines back into the update flow.
• PRICE_QUOTE_LINE — Prices a single quote line, taking the pricing control record, quote header, optional shipment, and a quote line table, and returning the standard FND_API status and message outputs.
• PRICE_QUOTE_WITH_CHANGE_LINES — Performs pricing against a subset of quote lines identified as changed, allowing incremental repricing rather than a full-quote recalculation.
• PRICE_QUOTE_CALCULATE_CALL — Supports the pricing calculation invocation path used within the flow, typically as the entry point for the underlying pricing computation step.

Each procedure follows the EBS API conventions of an API version number, an initialization flag for the message list, and a commit flag.

Tables Accessed

The package reads and writes the core Quoting pricing structures:

• ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL — the quote header and line entities being priced.
• ASO_QUOTE_LINE_DETAILS — line-level detail rows populated or updated during pricing.
• ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_ATTRIBS, and ASO_PRICE_ADJ_RELATIONSHIPS — the price adjustment definitions, their attributes, and their relationships used to evaluate and apply discounts, surcharges, and related qualifiers.
• MTL_SYSTEM_ITEMS_KFV — item information used to resolve the item being priced.
• CSI_ITEM_INSTANCES — installed base instances relevant to service or subscription pricing contexts.
• OE_ORDER_LINES_ALL — order line data referenced when quote lines are linked to or derived from order lines.

PLITBLM and DBMS_UTILITY are referenced for PL/SQL table handling and utility operations respectively. The package is referenced by two other packages within APPS.

Usage Notes

As a private (PVT) package, ASO_PRICING_FLOWS_PVT is not a supported public interface and should not be called directly from custom code. It is invoked internally by the Oracle Quoting forms and by the public ASO_QUOTE_PUB APIs when a user reprices a quote or line, and it may be reached from concurrent program logic that recalculates quote pricing in batch. Customizations requiring pricing behavior should use the documented public quoting APIs, which in turn drive this package. Because the package runs AUTHID CURRENT_USER and manipulates quote and pricing adjustment data directly, any direct invocation risks bypassing validation and message-handling logic that the public API layer supplies. Its header dates to 2005, and the package remains unchanged in the 12.1.1 and 12.2.2 environments described in the ETRM metadata.