Search Results aso_quote_tmpl_int




Overview
Explore in AI Chat

Overview

ASO_QUOTE_TMPL_INT is a PL/SQL integration package in the Oracle E-Business Suite (EBS) Order-to-Cash / Advanced Pricing / Quoting (ASO) module. It is owned by the APPS schema and is declared with AUTHID CURRENT_USER, meaning its procedures execute under the privileges of the calling session rather than the definer. The package provides the template-to-quote integration layer used by Oracle Quoting functionality, enabling callers to attach one or more predefined quote templates to an existing or newly described quote header. It is classified in the ETRM as an "OTHER" API, indicating it is an internal, non-plural, non-business-service interface intended primarily for programmatic consumption by other ASO packages and concurrent processes rather than by end users directly.

The package header carries the legacy CVS ident string $Header: asoiqtms.pls 120.1 2005/06/29 12:35:29 appldev ship $, and the package body is closed by the comment END; -- ASO_QUOTE_TMPL_INT. This places the original coding in the mid-2000s Oracle Quoting development cycle; the same interface remains documented and shipped through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes two published procedures (documented as "2 total" in the ETRM metadata), both overloads of a single procedure name:

The package defines a public collection type LIST_TEMPLATE_TBL_TYPE as a PL/SQL associative array of NUMBER indexed by BINARY_INTEGER, and a package global G_Miss_List_Template_Tbl of that type, used to identify unpopulated or invalid template rows.

Tables Accessed

ETRM documentation for this object does not enumerate the underlying base tables accessed through APPS synonyms. Functionally, the procedure manipulates the ASO quote header and quote line tables and the ASO template definition tables. Because the procedures call into ASO_QUOTE_PUB (ASO_QUOTE_PUB.CONTROL_REC_TYPE and ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE are parameters), the actual DML against ASO_QUOTE_HEADERS, ASO_QUOTE_LINES, and the template application tables is performed by the lower-level ASO_QUOTE_PUB API rather than directly within ASO_QUOTE_TMPL_INT. Readers requiring exact table lineage should inspect the package body and trace ASO_QUOTE_PUB.

Usage Notes

The package is referenced by three other packages in the ETRM repository, confirming that it is a mid-tier integration point rather than a top-level entry called by a form directly. Typical invocations are:

  • From other ASO packages that need to seed a quote from one or more templates as part of quote creation, copy, or re-defaulting logic.
  • From concurrent programs that bulk-apply templates to existing quotes, benefiting from the P_COMMIT and P_INIT_MSG_LIST parameters to control transaction boundaries and message-stack initialization.
  • From custom PL/SQL where a developer needs API-level control over template application without re-implementing quote DML.

Callers should always pass a valid P_API_VERSION_NUMBER, initialize the message list when calling multiple APIs, set P_VALIDATION_LEVEL appropriately, and inspect X_RETURN_STATUS plus X_MSG_DATA after each call. Because the package uses AUTHID CURRENT_USER, the invoking schema must hold execute privilege on ASO_QUOTE_TMPL_INT and the necessary DML rights on the underlying ASO objects.