Search Results qot_default_pvt




Overview
Explore in AI Chat

Overview

QOT_DEFAULT_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Quoting (QOT) module of Oracle E-Business Suite. Its business purpose is to resolve default values for quote attributes during quote entry and maintenance. Rather than forcing users to key every field manually, Oracle Quoting calls this package to derive sensible defaults for pricing, address, sales representative, currency, payment terms, and order-related attributes from a hierarchy of sources. These sources include the customer account, customer party, agreement, order type, system profile options, and sales rep assignment.

The package is classified as a private (PVT) API, meaning it is an internal implementation utility. Oracle does not publish it as a public integration interface, and it is not intended to be called directly by customer extensions. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling user, and it carries the package name constant G_PKG_NAME defined as QOT_DEFAULT_PVT. The header comment is dated 2006, and the object remains present in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes twenty-one functions. Most follow a common signature pattern: they accept a database object name and an attribute code, and return either a NUMBER identifier or a DATE value. They are grouped functionally as follows:

Tables Accessed

The package reads from Oracle Quoting, Trading Community Architecture (TCA), and Order Management tables through APPS synonyms. ASO_QUOTE_HEADERS_ALL provides quote header context. HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUSTOMER_PROFILES, HZ_CONTACT_POINTS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES supply party, account, profile, contact, and address data. Sales rep and group information is drawn from JTF_RS_SALESREPS_MO_V, JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, JTF_RS_GROUP_USAGES, and JTF_RS_ROLE_RELATIONS. Product and agreement data comes from MTL_SYSTEM_ITEMS_B and OE_AGREEMENTS_B.

Usage Notes

QOT_DEFAULT_PVT is invoked internally by Oracle Quoting forms and supporting logic when a quote is created or modified, to populate default attribute values. It is not referenced by other documented packages, and no public interface is exposed. Custom code should not call it directly; developers requiring similar defaulting behavior should use supported Oracle Quoting public APIs or profile options. Because the package relies on TCA and resource model views, correct setup of customer profiles, sales rep assignments, and group memberships is a prerequisite for accurate defaulting.