Search Results payment_null_rec_exists

Overview

ASO_QUOTE_HEADERS_PVT is a private PL/SQL package in the Oracle E-Business Suite Order-to-Cash (Advanced Pricing and Oracle Quoting / ASO) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It encapsulates the core business logic for creating, maintaining, validating, and submitting sales quotations stored in the ASO quote schema. Because it is classified as a private (PVT) API, it is intended to be invoked by the public wrapper package ASO_QUOTE_PUB and by other internal ASO packages rather than called directly by external custom code. The package consolidates header-level and related line processing, allowing the Quoting application to persist quote data, enforce security, and manage copied or configured quotes. The documented metadata indicates the package is referenced by 15 other packages, confirming its role as a foundational internal component of the ASO quoting stack in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes 15 documented procedures and functions. GET_QUOTE — the object referenced by the "get_quote" search — retrieves an existing quote's data for display or downstream processing. CREATE_QUOTE inserts a new quote header and its associated rows, using the Qte_Header_Rec_Type record defined in ASO_QUOTE_PUB. UPDATE_QUOTE modifies an existing quote, while DELETE_QUOTE removes quote records. COPY_QUOTE duplicates a quote for reuse, supported by the specialized CONFIG_COPY and SERVICE_COPY procedures that handle configuration and service-oriented copy scenarios. VALIDATE_QUOTE performs business-rule validation prior to commit or submission, and SUBMIT_QUOTE advances a quote into the submission workflow. UPDATE_QUOTE_TOTAL recalculates and stores header-level totals. QUOTE_SECURITY_CHECK enforces access control over quote operations. INSERT_ROWS provides a generic row-insertion helper. The procedures SHIPMENT_NULL_REC_EXISTS, PAYMENT_NULL_REC_EXISTS, and TAX_DETAIL_NULL_REC_EXISTS are null-record existence checks against shipment, payment, and tax detail structures respectively, used to determine whether corresponding records are populated.

Tables Accessed

The package reads from and writes to the principal ASO quote tables through APPS synonyms. ASO_QUOTE_HEADERS_ALL stores quote header information, and ASO_QUOTE_LINES_ALL stores line details; both are central to create, update, copy, and delete operations. ASO_QUOTE_NUMBER_S supplies the sequence used to generate unique quote numbers. ASO_QUOTE_PARTIES and ASO_QUOTE_RELATED_OBJECTS capture the parties and related entity references associated with a quote. ASO_QUOTE_STATUSES_B provides the status definitions driving quote state transitions. Pricing-related data is accessed through ASO_PRICE_ATTRIBUTES, ASO_PRICE_ADJUSTMENTS, and ASO_PRICE_ADJ_ATTRIBS, while ASO_FREIGHT_CHARGES and ASO_PAYMENTS hold freight and payment details. ASO_SALES_CREDITS supports sales credit assignment, ASO_LINE_RELATIONSHIPS maintains line hierarchy relationships, and ASO_QUOTE_LINE_DETAILS together with ASO_QUOTE_LINE_ATTRIBS_EXT store extended line attribute data used during validation and total calculation.

Usage Notes

ASO_QUOTE_HEADERS_PVT is normally invoked indirectly. The Oracle Quoting user interface, implemented through forms and the associated public API ASO_QUOTE_PUB, calls these private procedures to perform quote transactions on behalf of end users. Concurrent programs that process, validate, or submit quotations similarly rely on this package, as do the 15 dependent ASO packages identified in the metadata. Custom development should not call the private package directly; instead, callers should use the public ASO_QUOTE_PUB wrapper, which manages API versioning, message-list initialization, savepoints, and commit control (the internal procedures accept p_api_version_number, p_init_msg_list, and p_commit parameters in keeping with the standard EBS API pattern). Direct invocation risks bypassing validation and security checks such as QUOTE_SECURITY_CHECK. When referencing this package in 12.1.1 or 12.2.2, ensure the file version asovqhds.pls (120.2) is the baseline and that the corresponding ASO public API is used for all supported integrations.