Search Results g_miss_payment_rec




Overview
Explore in AI Chat

Overview

ASO_QUOTE_PUB is the primary public PL/SQL API for the Oracle E-Business Suite Quoting module (ASO – Oracle Advanced Pricing / Quoting). It exposes a controlled, documented interface through which external callers—forms, concurrent programs, and custom extensions—can create, maintain, validate, and submit sales quotes without writing directly against the underlying quoting tables. The package is classified as a Public (PUB) API in the ETRM metadata for release 12.2.2, meaning its signatures are intended to remain stable across patches. It is referenced by approximately one hundred other packages, confirming that it functions as the central integration point for quote-related business logic in the EBS order-to-cash flow.

The package body (source file asopqteb.pls, version 120.11, last modified 2012/03/13) begins with the standard header comments and a history note recording a bug fix for issue 4046692. It declares package-level constants G_PKG_NAME and G_FILE_NAME for diagnostic and logging purposes, along with global message variables x_msg_count and x_msg_data used to propagate errors from the FND message stack to callers. An example of the internal utility logic is the Convert_Party_To_Id procedure, which resolves party identifiers by either accepting a pre-existing party ID or delegating to ASO_PARTY_INT.Create_Party when name or person attributes are supplied instead. This routine illustrates the package's consistent use of the FND_API.G_MISS_NUM and G_MISS_CHAR sentinel conventions to distinguish "attribute not supplied" from a genuine null. The debug flag is governed by the profile option ASO_ENABLE_DEBUG, read through FND_PROFILE.VALUE at runtime.

Key Procedures and Functions

The documented API surface comprises twenty-six procedures and functions. The core quote lifecycle is handled by CREATE_QUOTE, UPDATE_QUOTE, DELETE_QUOTE, and COPY_QUOTE, which provide full maintenance of quote headers. VALIDATE_QUOTE performs business-rule and data-integrity checks prior to commit, and SUBMIT_QUOTE transitions a validated quote into the workflow-driven approval and publishing process. GET_QUOTE supports retrieval of quote data for display or downstream processing.

Tables Accessed

The package reads and writes the principal quoting entity through the APPS synonym ASO_QUOTE_HEADERS_ALL, which stores header-level quote attributes. OE_SYSTEM_PARAMETERS_ALL supplies Order Management system parameters used to honor profile-driven defaults and validation rules. WF_PARAMETER_LIST_T is used to build Oracle Workflow parameter lists for the submit and approval flows, and PLITBLM serves as the standard PL/SQL integer table type referenced by the API's table-based signature patterns.

Usage Notes

ASO_QUOTE_PUB is typically invoked from the Quoting and Order Management forms, from concurrent programs that process or migrate quotes, and from custom PL/SQL code that must create or modify quotes programmatically. Callers should adhere to the standard EBS API contract: initialize the FND message stack, pass attribute values using the G_MISS_* sentinels only for columns that are not being provided, inspect x_return_status for G_RET_STS_SUCCESS or G_RET_STS_ERROR/UNEXPECTED, and drain the FND message stack on failure. Because the package depends on OE_SYSTEM_PARAMETERS_ALL and workflow structures, it should be called within a properly initialized EBS session rather than from standalone database connections.