Search Results okl_qpy_pvt




Overview
Explore in AI Chat

Overview

OKL_QPY_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Lease and Finance Management (OLFM) quote party infrastructure. The name follows the ORACLE E-Business Suite convention in which the _PVT suffix denotes a private API layer intended to be invoked by other APIs and internal components rather than directly by external callers. In the ETRM (Enterprise Transaction and Resource Management) product family, quote parties represent the customers, lessees, guarantors, and other role-bearing entities associated with a lease or financing quote. The package provides the low-level create, read, update, delete, and validation primitives that the public quote APIs and the OKL Quote Parties form rely upon to keep the OKL_QUOTE_PARTIES and OKL_TRX_QUOTES_V data consistent.

Key Procedures and Functions

The ETRM metadata documents thirteen program units within OKL_QPY_PVT. The principal row-level operations are INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and VALIDATE_ROW. INSERT_ROW creates a new quote party record; UPDATE_ROW modifies an existing one; DELETE_ROW removes a quote party; LOCK_ROW obtains a concurrency lock so that concurrent sessions cannot modify the same row simultaneously; and VALIDATE_ROW enforces business rules on party data prior to persistence. A CHANGE_VERSION procedure supports Oracle EBS object-versioning conventions, allowing a committed record to be superseded by a new version without losing history. API_COPY duplicates an existing quote party, a common requirement when a quote is revised or a new version is generated from a template. QC is a quality-control routine used to verify internal consistency of the party data. Helper routines complete the package, calling OKC_API, OKL_API, OKL_UTIL, and FND_API for error handling, message stacking, and standard API return conventions.

Tables Accessed

The package operates primarily against OKL_QUOTE_PARTIES, which stores quote party assignments, and the OKL_QUOTE_PARTIES_V and OKL_TRX_QUOTES_V views, which expose quote and party information in denormalized form for validation and display. OKL_QUOTE_PARTIES_V is referenced to resolve party identifiers and role information, while OKC_K_PARTY_ROLES_V supplies the party-role definitions inherited from the Oracle Contracts foundation. JTF_OBJECTS_VL provides the object registry entries used to classify quote entities. PLITBLM is the standard Oracle PL/SQL table used for parameter and message passing.

Usage Notes

OKL_QPY_PVT is not intended to be called directly from custom code or concurrent programs. It is invoked internally by public OLFM APIs, most notably the OKL quote API layer, and by the Oracle Forms-based Quote Parties maintenance forms. Because the metadata records that OKL_QPY_PVT is referenced by seventeen other database objects, changes to its behavior can cascade across the quoting, contracting, and party modules. Developers extending OLFM functionality should call the public API surface instead, and should apply the ORACLE EBS customization standards — the OAF/Forms personalization and API guidelines described in the Oracle Proprietary, Confidential Information Legal Notices — rather than modifying this package body directly. The package is valid in both the 12.1.1 and 12.2.2 releases, with behavior consistent across both.