Search Results query_relationships

Overview

ASO_PRICING_CORE_PVT is an internal Oracle E-Business Suite package owned by the APPS schema that serves as the central pricing engine for Oracle Advanced Pricing within the Oracle Quoting (ASO) application. As indicated by the PVT (private) API classification, this package is not intended to be called directly by external consumers; instead it is invoked by the public pricing interfaces and callback packages that comprise the Quoting pricing framework. Its primary responsibility is to orchestrate the retrieval, qualification, and application of price adjustments, promotions, and charges against quote headers and lines during the quote authoring lifecycle.

The package bridges the Oracle Quoting data model (ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL and their detail tables) with the Oracle Advanced Pricing engine objects (QP_PREQ_GRP, QP_LIST_LINES, QP_PREQ_LDETS_TMP_T). This bridging role is reflected in its dependency graph: it references ASO_PRICING_INT, ASO_QUOTE_PUB, FND_API, JTF_NUMBER_TABLE, QP_PREQ_GRP, and STANDARD, and is itself referenced by ASO_PRICING_CALLBACK_PVT, ASO_PRICING_FLOWS_PVT, ASO_PRICING_INT, and ASO_VALIDATE_PRICING_PVT.

Key Procedures and Functions

The package exposes 22 documented procedures and functions. These can be grouped functionally:

• Initialization and global state: INITIALIZE_GLOBAL_TABLES, SET_GLOBAL_REC, MODIFY_GLOBAL_PLSINDEX_TABLE, and MODIFY_GLOBAL_NUMINDEX_TABLE prepare and maintain the in-memory PL/SQL global structures that hold pricing context during a pricing pass.
• Debug and diagnostics: PRINT_G_HEADER_REC, PRINT_G_LINE_REC, PRINT_GLOBAL_DATA_LINES, PRINT_GLOBAL_DATA_ADJUSTMENTS, and PRINT_GLOBAL_DATA_RLTSHIPS emit the contents of the global header, line, adjustment, and relationship records for diagnostic tracing.
• Request assembly: APPEND_ASKED_FOR, COPY_HEADER_TO_REQUEST, and COPY_LINE_TO_REQUEST copy quote header and line attributes into the pricing request structures consumed by the Advanced Pricing engine.
• Pricing retrieval: QUERY_PRICE_ADJ_ALL, QUERY_PRICE_ADJ_HEADER, QUERY_PRICE_ADJUSTMENTS, and QUERY_RELATIONSHIPS retrieve applicable price adjustments, header-level adjustments, and adjustment relationships from the pricing repository.
• Persistence and staging: POPULATE_QP_TEMP_TABLES stages qualifying pricing data into the QP temporary tables; COPY_PRICE_TO_QUOTE writes the resolved prices and adjustments back onto the quote; DELETE_PROMOTION removes promotion records; and PROCESS_CHARGES handles charge-type adjustments.

Tables Accessed

The package operates across two table families. The ASO tables are the transaction-side objects: ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL hold the quote header and line being priced; ASO_QUOTE_LINE_DETAILS, ASO_SHIPMENTS, and ASO_PAYMENTS supply supplementary line, shipping, and payment context that can influence pricing qualification. Pricing configuration and results reside in ASO_PRICE_ADJUSTMENTS and its _S (seed) counterpart, ASO_PRICE_ADJ_ATTRIBS and ASO_PRICE_ADJ_ATTRIBS_S, ASO_PRICE_ADJ_RELATIONSHIPS, ASO_PRICE_ATTRIBUTES, and ASO_PRICE_RELATIONSHIPS_S. On the Advanced Pricing side, the package reads QP_LIST_LINES (price list lines) and QP_PREQ_LDETS_TMP_T (pricing request line details temporary table). FND_LOOKUP_VALUES provides lookup validation and decode values used throughout the logic.

Usage Notes

ASO_PRICING_CORE_PVT is invoked indirectly through the Oracle Quoting pricing call stack. The public entry point is generally the ASO_PRICING_INT interface, which in turn calls the private core package; ASO_PRICING_CALLBACK_PVT and ASO_PRICING_FLOWS_PVT drive it during interactive pricing flows triggered from the Quoting and iStore/Order Capture forms, while ASO_VALIDATE_PRICING_PVT leverages it during pricing validation. It is also reachable from concurrent pricing and repricing programs that process quotes in batch. Because the package is classified as a private API, it is not documented as a supported integration point and its signature may change between releases; customizations and extensions should target the public ASO_QUOTE_PUB or ASO_PRICING_INT interfaces rather than this package. The version is valid and present in both EBS 12.1.1 and 12.2.2.