Results for “okl_qte_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_QTE_PVT is the private implementation package body for the Oracle Lease and Finance Management (OKL) quote-processing API in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the APPS schema and carries an API classification of PVT, which designates it as an internal worker package rather than a public interface. Its business purpose is to encapsulate the row-level DML, concurrency control, and validation logic that surrounds lease quotations stored in the OKL_TRX_QUOTES base, translation, and view objects. By centralizing this logic, the package allows public OKL APIs and Oracle Forms to manipulate quote records in a controlled, multilingually aware, and lock-safe manner. The package is deeply integrated with the broader ETRM foundation, depending on OKC_API, OKC_P_UTIL, FND_API, FND_GLOBAL, FND_LANGUAGES, MO_GLOBAL, OKL_API, OKL_UTIL, OKL_ACCOUNTING_UTIL, OKL_AM_UTIL_PVT, and OKL_LEGAL_ENTITY_UTIL. This dependency profile confirms that OKL_QTE_PVT participates in both the common Oracle contract core and the lease-specific transaction, accounting, and asset-management layers.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents fourteen procedures and functions in OKL_QTE_PVT. The core CRUD operations are INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW. INSERT_ROW creates a new quotation record in the base table and its translation row. UPDATE_ROW modifies an existing quotation, while DELETE_ROW removes it and its associated translation data where applicable. LOCK_ROW provides row-level concurrency control, typically using SELECT FOR UPDATE semantics to prevent conflicting updates from concurrent form sessions or API calls.

VALIDATE_ROW applies business validation rules to a quotation record before persistence, enforcing data integrity that cannot be expressed through database constraints alone. API_COPY duplicates an existing quotation, including its language-specific content, to support common business scenarios such as quote versioning or template-based entry. CHANGE_VERSION manages version control for quotation records, allowing multiple revisions of the same quote to coexist. ADD_LANGUAGE inserts translation rows into OKL_TRX_QUOTES_TL for additional installed languages, enabling multilingual quotation content. QC (quality control) is referenced as a procedure within the package and performs an internal consistency or completeness check on the quotation data.

Tables Accessed

OKL_QTE_PVT reads and writes OKL_TRX_QUOTES_B, the base table holding language-independent quotation attributes. It manages translated content in OKL_TRX_QUOTES_TL, the translation table that stores language-specific fields such as quote description and name. FND_LANGUAGES is queried to determine installed and enabled languages during ADD_LANGUAGE and translation row creation. OKL_QTE_SEQ supplies the primary key sequence values used by INSERT_ROW. OKL_TRX_QUOTES_ALL_B provides an org-striped access path across operating units, supporting multi-org aware queries under MO_GLOBAL. DUAL and PLITBLM are utility references, the latter being a standard dictionary table used by FND_API for message and result handling.

Usage Notes

As a PVT-class package, OKL_QTE_PVT is not intended to be called directly by external applications. It is invoked by OKL public API wrappers, by Oracle Forms used in lease quotation entry, and by higher-level ETRM packages that require quotation DML. The metadata shows the body is referenced by 49 other database objects, reflecting its central role in the quotation subsystem. Customization or direct invocation should be avoided; integrators should use the supported public API layer (OKC_API and OKL_API entry points) so that validation, concurrency control, and translation handling are applied consistently. Any modification to this package body would invalidate all 49 dependent objects, requiring careful impact assessment during patching or upgrades.