Search Results aso_quote_tmpl_pvt




Overview
Explore in AI Chat

Overview

ASO_QUOTE_TMPL_PVT is a private PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite Quoting (Oracle Advanced Pricing / Oracle Sales) functionality. Its stated purpose, per the package header comments, is centered on the application of quote templates to a quote. The package is classified as a "PVT" (private) API, meaning it is intended for internal use by other Oracle EBS packages rather than as a public extension point. In the ETRM 12.2.2 metadata it is documented as being referenced by two other packages, confirming its role as a supporting utility invoked from within the quoting subsystem rather than from external interfaces. The single source file is asovqtmb.pls, and its header indicates it was last modified in 2006, so the logic has been carried forward into both 12.1.1 and 12.2.2 without substantive change. The package provides the mechanism by which predefined quote templates—collections of lines, line details, and configuration relationships—are projected onto a target quote header.

Key Procedures and Functions

The package exposes two documented procedures:

  • ADD_TEMPLATE_TO_QUOTE — The principal procedure. It accepts a template identifier list along with quote header and control records, and returns quote line and line detail collections together with the standard FND_API return status, message count, and message data outputs. Its responsibility is to expand the supplied templates into the quote structure, applying validation according to the requested validation level and honoring the update and commit flags. It relies on FND_GLOBAL for the user and login context and uses FND_API constants for API versioning and validation control. Internal working variables such as template line counts, configuration header and revision identifiers, and dropped/service flags indicate it manages both simple lines and configured or serviceable items during expansion.
  • VALIDATE_ITEM — A supporting validation routine used to verify that an item referenced during template application is valid before it is added to the quote. This enforces data integrity against the item master prior to line creation.

Tables Accessed

Per the documented metadata, the package references the following tables via APPS synonyms:

  • ASO_QUOTE_HEADERS_ALL — the quote header being updated when a template is applied.
  • ASO_QUOTE_LINES_ALL — the quote lines created or modified to reflect template content.
  • ASO_QUOTE_LINE_DETAILS — the descriptive detail rows associated with each generated quote line.
  • MTL_SYSTEM_ITEMS_B — the item master, consulted to validate items during template expansion.
  • PLITBLM — the PL/SQL index-by table messaging table used by the FND message-handling framework to accumulate error and informational messages.

Usage Notes

Because ASO_QUOTE_TMPL_PVT is a private package, it is not intended to be called directly by customer extensions. It is invoked internally by the public quoting APIs—most notably ASO_QUOTE_PUB—when a user applies a template to a quote within the Oracle Quoting user interface or through the associated concurrent processing. Implementers customizing template behavior should prefer the public ASO_QUOTE_PUB entry points, which in turn delegate to this package. The presence of NOCOPY OUT parameters and standard FND_API conventions means callers must set up the API version, validation level, and commit indicators correctly, and should inspect the returned status and message data to handle validation failures gracefully. Given its age and private classification, the package should be treated as internal plumbing in both 12.1.1 and 12.2.2.