Search Results get_quote_number




Overview
Explore in AI Chat

Overview

ASO_QUOTE_LINES_PVT is the private implementation package for quote line processing within the Oracle EBS Order Capture (ASO) module. In the Oracle Application Architecture, private (PVT) packages contain the actual business logic and data manipulation routines that are exposed to callers through a corresponding public (PUB) package—in this case, ASO_QUOTE_PUB. This package is responsible for the create, read, update, and delete operations against quote line and its associated child entities, including pricing adjustments, payments, shipments, tax details, freight charges, line details, and price attributes.

The package header history notes a significant change introduced in 2004 with the BC4J (Business Components for Java) implementation, whereby the primary key for all input parameters in the Create_Quote and Update_Quote APIs is passed by the caller and preserved rather than nulled before being handed to the table handlers. This reflects the shift toward Java-based quoting clients that require the surrogate keys to be retained for object identity. A performance fix recorded in 2002 also indicates that this package has been periodically tuned for high-volume quoting operations.

Key Procedures and Functions

  • INSERT_QUOTE_LINE_ROWS — Inserts rows into the various quote line child tables. It is designed to be called by the copy quote function, which needs to bypass certain validations that a normal create would enforce. The routine accepts record and table type parameters covering line, control, payment, price adjustment, line detail, shipment, tax detail, freight charge, and price attribute data.
  • CREATE_QUOTE_LINES — Handles the creation of one or more quote lines, populating the parent line row together with its dependent child records.
  • UPDATE_QUOTE_LINE — Applies modifications to an existing quote line and its associated child tables.
  • DELETE_QUOTE_LINE — Removes a quote line and its dependent child rows.
  • GET_QUOTE_LINE — Retrieves quote line and child entity data into the caller's record structures; this is the routine typically invoked when a quoting form or API needs to populate a quote line for display or further processing.
  • SERVICE_ITEM_QTY_UPDATE — Adjusts quantities related to service items, working in conjunction with service line and installed base item data.

Tables Accessed

The package reads and writes a broad set of ASO, CSI, OE, and MTL tables through APPS synonyms. The core quote entities are ASO_QUOTE_LINES_ALL, ASO_QUOTE_LINE_DETAILS, ASO_QUOTE_HEADERS_ALL, and ASO_QUOTE_STATUSES_B. Child or related quotation data is held in ASO_PAYMENTS, ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_RELATIONSHIPS, ASO_SHIPMENTS, and ASO_LINE_RELATIONSHIPS. Service and installed base integration relies on CSI_ITEM_INSTANCES, CSI_T_TRANSACTION_LINES, CSI_T_TXN_LINE_DETAILS, and CS_LINE_INST_DETAILS. Inventory item validation uses MTL_SYSTEM_ITEMS_B, and order line linkage uses OE_ORDER_LINES_ALL.

Usage Notes

ASO_QUOTE_LINES_PVT is not intended to be called directly by custom code. External callers should invoke the public ASO_QUOTE_PUB APIs, which delegate to this private package. The package is referenced by eight other packages, confirming its role as a shared internal utility layer rather than an entry point. It is invoked primarily during quote entry and maintenance from the Order Capture and Quoting forms, during copy-quote operations where validation is intentionally bypassed, and during service item quantity adjustments that reconcile the quote with installed base instances. Custom integrations requiring quote line creation, update, deletion, or retrieval should route requests through the corresponding public APIs to preserve validation, defaulting, and concurrency behavior.