Search Results aso_submit_quote_pvt




Overview
Explore in AI Chat

Overview

ASO_SUBMIT_QUOTE_PVT is a private PL/SQL package in the Oracle E-Business Suite Order-to-Cash (ASO) module that implements the internal logic used to submit an Oracle Quoting quote for conversion into an order. Within Oracle Quoting, a quote progresses through a lifecycle in which it is authored, priced, and then submitted, at which point the quoting engine transfers the quote data into the order management tables. The Submit_Quote API documented in this package encapsulates that submission step. Because the package is classified as PVT (private), it is not a public integration surface; it is designed to be called by other packages in the ASO schema, principally the public ASO_QUOTE_PUB package, which exposes the supported submission entry point to forms, concurrent programs, and external code.

The package carries an AUTHID CURRENT_USER declaration, meaning its SQL executes with the privileges of the calling schema rather than the definer. The header comment history references a performance fix delivered under bug 5714535 (February 2007), reflecting that the submission path is performance-sensitive because it must gather and validate a large volume of dependent quote data before the order is created.

Key Procedures and Functions

The package exposes one procedure and a set of query functions that assemble the data required during submission.

  • SUBMIT_QUOTE — The core submission routine. It accepts API version, initialization and commit flags, a validation level, a submit control record, and the quote header record, and returns the resulting order header record together with standard API return status, message count, and message data outputs. It orchestrates the validation of the quote and its dependent entities prior to conversion.
  • QUERY_TAX_DETAIL_ROWS — Retrieves tax detail rows for a quote header or line, returning them into the tax detail table type used by the public API.
  • QUERY_SHIPMENT_ROWS — Populates shipment information for a given quote line.
  • QUERY_FREIGHT_CHARGE_ROWS — Gathers freight charge lines associated with shipments on the quote.
  • QUERY_SALES_CREDIT_ROW — Fetches sales credit assignment data for the quote.
  • QUERY_QUOTE_PARTY_ROW — Retrieves the party (customer/contact) records attached to the quote.
  • QUERY_LINE_DTL_ROWS — Returns quote line detail rows.
  • QUERY_LINE_ATTRIBS_EXT_ROWS — Returns extended line attribute rows held in the line attribs extension table.
  • QUERY_PRICE_ATTR_ROWS — Retrieves pricing attribute rows attached to quote lines.
  • QUERY_PRICE_ADJ_ROWS, QUERY_PRICE_ADJ_HDR_ROWS, and QUERY_PRICE_ADJ_RLTSHIP_ROWS — Retrieve price adjustment (modifier) data at the line, header, and relationship-to-shipment levels respectively.
  • RAISE_QUOTE_EVENT — Raises the business event associated with quote submission, supporting workflow and subscription-based integrations.
  • QUOTE_ORDER_HIGH_AVAILABILITY — Supports the high-availability handling of quote-to-order processing.

Tables Accessed

The package reads and writes the principal Oracle Quoting tables through APPS synonyms. Header and line data come from ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL, with subordinate detail in ASO_QUOTE_LINE_DETAILS and ASO_QUOTE_LINE_ATTRIBS_EXT. Pricing is sourced from ASO_PRICE_ATTRIBUTES, ASO_PRICE_ADJUSTMENTS, and ASO_PRICE_ADJ_RELATIONSHIPS. Fulfillment-related data is drawn from ASO_SHIPMENTS and ASO_FREIGHT_CHARGES. Commercial terms and assignments are read from ASO_SALES_CREDITS, ASO_PAYMENTS, ASO_QUOTE_PARTIES, and ASO_LINE_RELATIONSHIPS. Status validation uses ASO_QUOTE_STATUSES_B and ASO_QUOTE_STATUS_TRANSITIONS to confirm the quote is in a submittable state before conversion proceeds.

Usage Notes

Because ASO_SUBMIT_QUOTE_PVT is a private package, it should not be called directly by customer extensions. Supported submission is performed through ASO_QUOTE_PUB, which the Oracle Quoting user interface invokes when a user submits a quote, and which concurrent or programmatic processes call when batch submission is required. The package is referenced by two other packages within the ASO schema, consistent with its role as an internal collaborator. Developers extending quoting functionality should rely on the public API and its documented control and record types rather than on the private procedures listed here; the private package may change between releases without notice. The P_Commit and P_Init_Msg_List parameters follow the standard OAF/PLSQL API conventions, and callers through the public wrapper should set the commit flag according to their transaction management strategy.