Search Results batch_pricing




Overview
Explore in AI Chat

Overview

ASO_CONC_REQ_INT is a public PL/SQL package in the APPS schema that acts as the concurrent request integration layer for Oracle Quoting (Oracle Order Capture / ASO). Its central purpose is to mediate between the Quoting user interface and the concurrent manager: when a user requests price and tax calculation for a quote, this package assembles the request parameters and submits the pricing and taxation program set rather than performing the calculation synchronously in the form session. The package is declared AUTHID CURRENT_USER, so its unqualified references resolve against the invoking schema's privileges, which allows it to be called safely from both the Quoting forms runtime and from custom concurrent or batch code. The source header identifies the file as asoiprqs.pls, and the package has been part of the ASO integration layer since at least the 11i-era 120.1 revision, remaining available unchanged through EBS 12.1.1 and 12.2.2. In ETRM it is classified as an OTHER API rather than a supported public interface, which is an important distinction for upgrade and customization planning.

Key Procedures and Functions

  • SUBMIT_PRICE_TAX_REQ — The procedure matching the search term submit_price_tax_req. It accepts a Quoting header record, a control record, and an API version number, then submits the pricing and tax concurrent request for that quote header. It returns the concurrent request_id together with the standard FND_API return status, message count, and message data, allowing the caller to track the request or surface validation and submission errors.
  • BATCH_PRICING — A concurrent-program entry point with the standard errbuf and retcode OUT parameters. It drives pricing for a single quote header identified by p_quote_header_id, accepting flags that control tax calculation, freight charge calculation, pricing request type, price mode, automatic versioning, and options for copying tasks, notes, and attachments, along with pricing, tax, dependency, and defaulting status indicators.
  • CANCEL_PRICE_TAX_REQ — Cancels a previously submitted price and tax request for a given quote header record, using the same header/control record pattern and returning the standard FND_API status outputs.
  • GET_WORKFLOW_ROLE — Resolves the workflow role and notification preference for a supplied p_user_id, used to determine who receives workflow notifications generated by the pricing process.
  • UPDATE_PRICE_REQ_ID — Writes the concurrent request identifier back onto the quote so that the Quoting UI can later correlate the quote with its pricing request.
  • SEND_NOTIFICATION — Raises the workflow notification associated with the pricing outcome.
  • LOCK_EXISTS — Checks whether a pricing lock already exists for the quote, guarding against concurrent submission.
  • QUOTE_DETAIL_URL and QTE_DETAIL_URL — Build the deep-link URLs used in notifications so recipients can navigate directly to the quote or quote detail in the Quoting application.

Tables Accessed

The package works against a small, well-defined set of APPS synonyms. ASO_QUOTE_HEADERS_ALL is the primary table: it is read to validate the quote and to retrieve header context, and it is updated with the request identifier and status indicators produced by the submission. ASO_WFNOTIFICATION_S2 supports the notification and workflow-role functionality used by SEND_NOTIFICATION and GET_WORKFLOW_ROLE. FND_USER supplies the user identity needed to resolve the workflow role and notification preference for a given p_user_id. HZ_CUST_ACCOUNTS and HZ_PARTIES are referenced to derive customer and party context, typically for notification addressing and URL construction. DUAL is used for single-row lookups and simple evaluations.

Usage Notes

ASO_CONC_REQ_INT is invoked primarily from the Oracle Quoting pricing and taxation flows, where a user action triggers asynchronous price and tax calculation. The typical lifecycle is: LOCK_EXISTS verifies no request is already in flight, SUBMIT_PRICE_TAX_REQ submits the concurrent request and returns the request_id, UPDATE_PRICE_REQ_ID stores that identifier on ASO_QUOTE_HEADERS_ALL, and SEND_NOTIFICATION, using GET_WORKFLOW_ROLE and the QUOTE_DETAIL_URL or QTE_DETAIL_URL helpers, informs the appropriate user when the request completes. BATCH_PRICING serves as the concurrent program target itself, and because it exposes errbuf/retcode, it can be registered on a concurrent program definition and scheduled independently of the form. CANCEL_PRICE_TAX_REQ provides the compensating action when a user abandons or re-prices a quote. The package is referenced by eleven other ASO packages, confirming it is an internal integration hub rather than a standalone utility. Because ETRM classifies it as OTHER rather than a supported public API, custom code should call it with care: parameter signatures are not governed by Oracle's public API compatibility policy, and any direct dependency should be revalidated during 12.1.1 to 12.2.2 upgrades.