Search Results service_item_qty_update

Overview

ASO_QUOTE_LINES_PVT is the private (PVT) PL/SQL package in the Oracle E-Business Suite Oracle Order Capture / Oracle Quoting module (ASO schema, APPS owner) responsible for the low-level persistence and manipulation of quote line data. Whereas the public package ASO_QUOTE_PUB exposes the supported API surface for quote creation, the PVT package performs the actual insert, update, delete, and query operations against the ASO quote line tables, invoked internally by the public layer. The package is declared AUTHID CURRENT_USER and dates to release 11i lineage (header revision 120.1, dated 2005), and remains present through EBS 12.1.1 and 12.2.2. Its scope spans quote line header rows as well as the subordinate attribute collections that describe payments, price adjustments, line details, shipments, tax, freight, price attributes, sales credits, and quote parties.

Key Procedures and Functions

The documented API surface comprises six procedures and functions. Because ASO_QUOTE_LINES_PVT is an internal handler, callers should treat these as implementation detail reached primarily through ASO_QUOTE_PUB.

• INSERT_QUOTE_LINE_ROWS — Calls the table handlers to insert quote line rows across the line record and all associated child collections (payments, price adjustments, details, shipments, tax, freight, price attributes, price adjustment attributes, line attributes, sales credits, and quote parties), returning the created quote line record.
• CREATE_QUOTE_LINES — Bulk creation entry point orchestrating quote line creation for a set of lines, delegating to the row insertion logic.
• UPDATE_QUOTE_LINE — Applies modifications to an existing quote line and its dependent records.
• DELETE_QUOTE_LINE — Removes a quote line and its associated child rows.
• GET_QUOTE_LINE — Retrieves a quote line and its related detail records; this is the object of the user's search for quote line retrieval.
• SERVICE_ITEM_QTY_UPDATE — Updates service item quantities on quote lines, supporting service-oriented line types that depend on installed base records.

The package also declares constants G_DEFAULT_NUM_REC_FETCH (30), G_PROMO_GOODS_DISCOUNT ('PRG'), and G_DISCOUNT ('DIS'), reflecting default fetch sizing and pricing adjustment literals used in line processing.

Tables Accessed

The package reads and writes the core ASO quote tables and related cross-module tables:

• ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, ASO_QUOTE_LINE_DETAILS — the primary quote header, line, and line detail entities.
• ASO_PAYMENTS, ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_RELATIONSHIPS, ASO_SHIPMENTS — child collections for payment, pricing adjustment, and shipment attributes.
• ASO_LINE_RELATIONSHIPS, ASO_QUOTE_STATUSES_B — line relationship and status lookups.
• OE_ORDER_LINES_ALL — order line linkage supporting quote-to-order conversion.
• MTL_SYSTEM_ITEMS_B — item validation for quoted products.
• CSI_ITEM_INSTANCES, CSI_T_TRANSACTION_LINES, CSI_T_TXN_LINE_DETAILS, CS_LINE_INST_DETAILS — installed base and service item data supporting SERVICE_ITEM_QTY_UPDATE.

Usage Notes

ASO_QUOTE_LINES_PVT is a private package and is not part of the supported public API. It is invoked by Oracle Quoting forms, concurrent programs, and the public ASO_QUOTE_PUB layer, and is referenced by eight other packages within the EBS codebase. Custom developers needing quote line retrieval should call ASO_QUOTE_PUB rather than GET_QUOTE_LINE directly, as Oracle does not guarantee PVT signatures across patches. Direct calls carry upgrade risk.