Search Results config_callback_pricing_order




Overview
Explore in AI Chat

Overview

ASO_PRICING_CALLBACK_PVT is a private (PVT) PL/SQL package in the APPS schema that belongs to the Oracle Advanced Pricing and Oracle Quoting (ASO) product family. Its role is to support the pricing callback mechanism used during quote configuration and pricing in Oracle E-Business Suite 12.1.1 and 12.2.2. When a user configures a model or kit within Oracle Quoting, or when quote lines are priced, the pricing engine and the configuration engine must exchange data regarding requested items, attributes, and pricing adjustments. This package provides the internal, non-public routines that implement that exchange: it copies data between quote headers, quote lines, requests, and price adjustment structures, and it performs the configuration-driven call to the pricing engine.

The package header, dated with a header comment referencing asovpcls.pls version 120.1, defines an Index_Link_Tbl_Type PL/SQL table type indexed by BINARY_INTEGER and a global G_MISS_Link_Tbl used for missing-value handling. These constructs support the tabular, collection-based data structures passed through the ASO_QUOTE_PUB and ASO_PRICING_INT APIs.

Key Procedures and Functions

The documented procedures (13 in total, 10 named in the metadata excerpt) are summarized below. Parameter lists are intentionally omitted; only purposes are described.

  • CONFIG_CALLBACK_PRICING_ORDER — The principal entry point. It accepts the pricing control record, quote header, header shipment, price attributes, quote line detail, line relationships, and line shipment collections, and returns updated quote, price adjustment, and price adjustment attribute/relationship collections. It drives configuration-driven pricing callbacks.
  • COPY_ATTRIBS_TO_REQ — Copies pricing attributes into the pricing request structure so they can be evaluated by the pricing engine.
  • COPY_HDR_ATTR_TO_LINE — Propagates header-level pricing attributes down to the line level, ensuring line pricing inherits relevant header context.
  • APPEND_ASKED_FOR — Appends the "asked for" (requested) items or attributes to an existing collection, preserving any values already populated. This is the procedure referenced by the search term.
  • COPY_HEADER_TO_REQUEST — Transfers quote header data into the pricing request structure.
  • COPY_REQ_DTL_TO_PRICE_ADJ — Maps request detail results into price adjustment records returned to the caller.
  • COPY_LINE_TO_REQUEST — Transfers quote line data into the pricing request structure.
  • COPY_REQUEST_TO_QUOTE — Writes pricing request results back to the quote header and line structures.
  • COPY_REQUEST_TO_LINE — Writes request results specifically back to quote line records.
  • UPDATE_QUOTE_ROWS — Persists updated quote rows after pricing and callback processing.

Tables Accessed

The metadata documents two referenced objects via APPS synonyms: ASO_PRICE_ATTRIBUTES, which stores pricing attribute values associated with quote lines and is read and written as attributes flow between headers and lines, and PLITBLM, a standard Oracle Applications internal table used for storing collection and table-type data during PL/SQL processing. Access to these tables supports the attribute propagation and request/response mapping performed by the copy routines.

Usage Notes

As a PVT-classified package, ASO_PRICING_CALLBACK_PVT is not intended for direct customer invocation. It is invoked internally by Oracle Quoting and Advanced Pricing when configuration and pricing callbacks are triggered, typically through the ASO_QUOTE_PUB public API and the ASO_PRICING_INT integration structures. The package is referenced by two other packages, confirming its role as an internal helper rather than a supported public interface. Customizations should avoid calling its procedures directly, since signatures may change between releases; instead, customers should use the documented public ASO_QUOTE_PUB and pricing APIs. The package is relevant when diagnosing quote pricing callbacks, "asked for" attribute handling, and configuration-driven price adjustment behavior.