Search Results create_quote

Overview

ASO_QUOTE_HEADERS_PVT is the private implementation package body behind the Oracle EBS Advanced Supply Chain (ASO) Quote Management module. It encapsulates the core business logic for creating, maintaining, validating, copying, and submitting sales quotes, operating on the quote header entity in the ASO_QUOTE_HEADERS_ALL table and its dependent child entities. The package is classified as PVT (private), meaning it is not intended to be called directly by external application code; instead, it is invoked by the corresponding public wrapper package ASO_QUOTE_PUB. As documented in the header comments, the file is versioned (asovqhdb.pls) and carries a history of performance fixes and definition changes dating from 2002 onward. The package exposes fifteen documented procedures and functions that collectively implement the quote lifecycle, including validation, security checks, configuration copy, service copy, and total recalculation. Database maintenance activity such as inserting header rows and checking the existence of nullable sub-records is also centralized here. Because the package relies on the FND_API message and value conventions (for example G_MISS_NUM, G_MISS_DATE, G_MISS_CHAR), it participates fully in the standard Oracle Application Object Library API validation framework.

Key Procedures and Functions

The documented entry points cover the complete quote header manipulation surface:

• CREATE_QUOTE — Inserts a new quote header and its associated child records.
• UPDATE_QUOTE — Modifies an existing quote header; per the history notes, the primary key passed by BC4J callers is honored rather than nulled out.
• DELETE_QUOTE — Removes a quote header and dependent data.
• COPY_QUOTE — Duplicates an existing quote header into a new quote.
• VALIDATE_QUOTE — Performs business-rule validation prior to persistence or submission.
• SUBMIT_QUOTE — Drives the quote through its submission workflow.
• GET_QUOTE — Retrieves quote header information.
• UPDATE_QUOTE_TOTAL — Recalculates and writes quote totals.
• CONFIG_COPY — Copies configuration-related components during quote duplication.
• SERVICE_COPY — Copies service-related components during quote duplication.
• QUOTE_SECURITY_CHECK — Enforces user access restrictions on quotes.
• INSERT_ROWS — Performs bulk row insertion into the underlying tables.
• SHIPMENT_NULL_REC_EXISTS, PAYMENT_NULL_REC_EXISTS, TAX_DETAIL_NULL_REC_EXISTS — Utility predicates that detect whether a given sub-record contains only null or "missing" values, used to determine whether child rows should be created or skipped.

Tables Accessed

The package reads and writes a wide set of ASO tables accessed through APPS synonyms. The primary target is ASO_QUOTE_HEADERS_ALL, with detail data held in ASO_QUOTE_LINES_ALL, ASO_QUOTE_LINE_DETAILS, ASO_QUOTE_LINE_ATTRIBS_EXT, and ASO_PRICE_ATTRIBUTES. Quote numbering is drawn from the ASO_QUOTE_NUMBER_S sequence. Party and relationship data reside in ASO_QUOTE_PARTIES and ASO_QUOTE_RELATED_OBJECTS. Pricing and financial detail spans ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_ATTRIBS, ASO_FREIGHT_CHARGES, ASO_PAYMENTS, and ASO_SALES_CREDITS. Status lookup is served by ASO_QUOTE_STATUSES_B, and line-to-line dependencies are tracked in ASO_LINE_RELATIONSHIPS. These accesses support the full write-back of a validated quote.

Usage Notes

ASO_QUOTE_HEADERS_PVT is invoked indirectly through ASO_QUOTE_PUB by the Quote Management forms, concurrent programs, and BC4J-based middle-tier services. It is referenced by fifteen other packages, confirming its role as a shared implementation layer. The inclusion of the "oe_order_types" search phrase reflects that quote and order type metadata is validated or defaulted during quote creation. Customizations should avoid calling this package directly, as its interface is private and subject to change.