Search Results add_template_to_quote

Overview

The ASO_QUOTE_TMPL_INT package body is part of the Oracle E-Business Suite (EBS) Advanced Supply Chain / Order Capture module, specifically within the Oracle Quoting (ASO) schema. Its primary business function is to provide a programmatic integration interface for applying predefined quote templates to an existing quote header. The package name suffix "_INT" denotes that it serves as an integration-layer utility, allowing callers to seamlessly associate one or more templates with a quote without directly manipulating the underlying quoting tables. The header comment indicates the package was shipped as part of the ASO quoting infrastructure (file asoiqtmb.pls), and the API classification is documented as "OTHER" in the ETRM registry for release 12.2.2.

The user search term "add_template_to_quote" corresponds directly to the primary documented procedure, ADD_TEMPLATE_TO_QUOTE, which is the sole public entry point exposed by this package body.

Key Procedures and Functions

The ETRM metadata documents two overloaded variants of a single procedure, ADD_TEMPLATE_TO_QUOTE. These overloads fulfill complementary roles:

• ADD_TEMPLATE_TO_QUOTE (header-id variant) — This overload accepts a quote header identifier (P_QUOTE_HEADER_ID) and a collection of template identifiers (P_TEMPLATE_ID_TBL), retrieves the full quote header record via ASO_UTILITY_PVT.Query_Header_Row, and then delegates to the second overload. It acts as a convenience wrapper that resolves the header record internally before performing the actual template association logic.
• ADD_TEMPLATE_TO_QUOTE (record variant) — This overload accepts a populated ASO_QUOTE_PUB.Qte_Header_Rec_Type record alongside the template identifier collection, performing the substantive validation and insertion work. It follows the standard EBS PL/SQL API conventions, exposing the standard X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA output parameters for consistent error handling.

Both overloads observe the shared API parameters P_API_VERSION_NUMBER, P_INIT_MSG_LIST, P_COMMIT, P_VALIDATION_LEVEL, and P_CONTROL_REC, consistent with the Oracle Application Object Library (AOL) API framework.

Tables Accessed

The excerpt provided does not enumerate the base tables modified by this package. Based on the procedure's stated purpose and standard Oracle Quoting architecture, the package operates against the ASO quote-template relationship tables (such as ASO_QUOTE_HEADERS and the underlying template association entities) by way of ASO_QUOTE_PUB record types and ASO_UTILITY_PVT query helpers. The metadata explicitly notes that no APPS synonyms are documented for direct table references, indicating that data access is encapsulated through other ASO packages rather than through standalone SQL within this body.

Usage Notes

ASO_QUOTE_TMPL_INT is referenced by three other packages within the ETRM registry, confirming its role as a reusable integration utility rather than a standalone entry point. Typical invocation scenarios include:

• Called from Oracle Quoting forms or related UI flows when an end user applies a template during quote creation or maintenance.
• Invoked by other ASO packages and concurrent programs that need to programmatically stamp templates onto quotes as part of bulk or automated processing.
• Called from custom extensions or integration code that must associate templates with quote headers in a supported, validation-aware manner.

Developers should always invoke the record or header-id overload through the AOL API standard, checking X_RETURN_STATUS for error conditions and honoring the P_COMMIT and P_INIT_MSG_LIST flags to control transaction boundaries and message stack behavior. Because the package is classified as "OTHER" rather than a formally certified public API, it should be used with awareness of Oracle's support policy for non-public interfaces in EBS 12.1.1 and 12.2.2.