Search Results cancel_quick_quote

Overview

OKL_QUICK_QUOTES_PVT is a private PL/SQL package in the Oracle EBS Lease and Finance Management (ETRM) module, owned by APPS and classified as a PVT (private) API. It encapsulates the business logic supporting Quick Quotes, a lightweight quoting facility that allows leasing agents to generate indicative pricing and cash flow estimates for prospective lease transactions before a full lease or lease quote is created. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and it defines a substantial set of PL/SQL subtypes and record types that mirror the structures used elsewhere in the ETRM quoting stack.

These subtypes include qqhv_rec_type and qqlv_rec_type, which map to the Quick Quote header and line record structures maintained by OKL_QQH_PVT and OKL_QQL_PVT respectively. In addition, the package declares cashflow_header_rec_type, cashflow_level_rec_type, and cashflow_level_tbl for interacting with the lease quote cash flow engine (OKL_LEASE_QUOTE_CASHFLOW_PVT), and seven locally defined record types covering payment calculations, rent payments, fee and service payments, and item order estimates. The package also establishes the standard g_pkg_name and g_app_name constants used for error handling and FND logging.

Key Procedures and Functions

The documented public interface consists of seven procedures and functions:

• CREATE_QUICK_QTE — Creates a new Quick Quote, inserting a header and its associated line records and initiating the calculation of indicative pricing.
• UPDATE_QUICK_QTE — Modifies an existing Quick Quote, allowing terms, items, and pricing inputs to be revised and recalculated.
• DELETE_QQL — Removes a Quick Quote line. This is the specific procedure surfaced by the user's search for "delete_qql" and is the entry point for deleting line-level data from the OKL_QUICK_QUOTE_LINES_B table.
• HANDLE_QUICK_QUOTE — Provides the central orchestration logic for Quick Quote processing, coordinating validation, calculation, and persistence across header and line entities.
• CANCEL_QUICK_QUOTE — Cancels an active Quick Quote, updating its status rather than physically deleting the header record.
• DUPLICATE_ESTIMATE — Copies an existing estimate into a new Quick Quote, supporting the common business practice of quoting variants of prior estimates.

Tables Accessed

The package operates against the core Quick Quote tables OKL_QUICK_QUOTES_B and OKL_QUICK_QUOTE_LINES_B, which hold header and line data respectively; DELETE_QQL is the procedure that maintains line-level integrity within the latter. Cash flow calculations write to OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, and OKL_CASH_FLOW_OBJECTS. Reference and rate data are read from OKL_FE_STD_RT_TMP_ALL_B and OKL_FE_STD_RT_TMP_VERS, while FND_CURRENCIES supplies currency validation. FND_LOG_MESSAGES and PLITBLM support diagnostics and bulk processing, and DBMS_TRANSACTION is used to manage transaction control within the API boundary.

Usage Notes

Because OKL_QUICK_QUOTES_PVT is a private package, it is not intended for direct invocation by external custom code. It is called by the ETRM Quick Quote user interface and by the two dependent packages identified in the metadata, which expose the supported public API surface. Developers investigating the "delete_qql" search term should note that DELETE_QQL is the internal line-deletion routine; applications requiring line removal should invoke the corresponding public API rather than call this package directly, and should not bypass the transaction and validation logic the package enforces.