Search Results get_cat_name

Overview

OKL_QUICK_QUOTES_PVT is a private (PVT) PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema. It implements the internal business logic supporting the Quick Quotes feature within Oracle Lease and Finance Management (OKL), part of the ETRM (Enterprise Asset and Transaction Management) product family. The package encapsulates the server-side behavior required to create, modify, duplicate, handle, cancel, and remove quick quote records, which serve as lightweight, rapidly generated sales quotations used to produce estimated pricing and cash flow scenarios before a formal contract or lease is written.

The package body declares local subtypes drawn from OKL_PRICING_UTILS_PVT and OKL_SALES_QUOTE_QA_PVT, reflecting its role as an orchestrator of pricing and quality-analysis utilities. A package-level user_exception is declared for controlled error handling, and the code follows the standard OKL API conventions, using okl_api.g_ret_sts_success, okl_api.handle_exceptions, and okl_api.set_message to populate the FND message stack.

Key Procedures and Functions

• validate_header — A private function that enforces uniqueness of the quick quote reference number. It opens a cursor against OKL_QUICK_QUOTES_B and raises okl_api.g_exception_error with message token OKL_DUPLICATE_CURE_REQUEST when the reference already exists.
• CREATE_QUICK_QTE — Creates a new quick quote record, applying the header validation and persisting the header and associated line data.
• UPDATE_QUICK_QTE — Updates an existing quick quote, re-validating the reference number and modifying the stored attributes.
• DELETE_QQL — Removes quick quote line records associated with a quick quote.
• HANDLE_QUICK_QUOTE — Central dispatch routine that routes quick quote operations through the appropriate internal processing logic.
• CANCEL_QUICK_QUOTE — Cancels an existing quick quote, changing its status without physically deleting the record.
• DUPLICATE_ESTIMATE — Copies an existing estimate into a new quick quote, supporting the common practice of basing a new quote on a prior estimate.

Tables Accessed

• OKL_QUICK_QUOTES_B — Base table holding quick quote header data; read for uniqueness validation and written on create, update, cancel, and duplicate.
• OKL_QUICK_QUOTE_LINES_B — Stores quote line details; manipulated during create, update, and delete operations.
• OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_CASH_FLOW_OBJECTS — Supporting tables for the cash flow schedules generated during quick quote pricing.
• OKL_FE_STD_RT_TMP_ALL_B, OKL_FE_STD_RT_TMP_VERS — Temporary/versioned rate tables used during pricing calculations.
• FND_CURRENCIES — Supplies currency validation information for quote headers.
• FND_LOG_MESSAGES — Receives debug and diagnostic log entries through the FND logging framework.
• DBMS_TRANSACTION and PLITBLM — Used for transaction control and PL/SQL table manipulation during processing.

Usage Notes

As a PVT package, OKL_QUICK_QUOTES_PVT is not intended for direct invocation by external code; it is referenced by two other packages that expose the public API surface. It is typically invoked indirectly through Quick Quotes forms in the Oracle Lease and Finance Management application, and through any concurrent program or custom code that calls the wrapping public APIs. Developers should not call the private functions directly, since their signatures and behavior may change between releases and are not covered by Oracle's public API commitment. Error conditions are surfaced through the standard FND message stack, so callers must inspect the returned status and message count when handling exceptions such as duplicate reference numbers.