Search Results okl_ins_quote_pvt




Overview
Explore in AI Chat

Overview

OKL_INA_PVT is a private PL/SQL package in the APPS schema within Oracle E-Business Suite, belonging to the Oracle Lease and Finance Management (OKL) module. The suffix _PVT identifies it as a private API package, meaning it is intended for internal consumption by other OKL packages rather than direct invocation by external modules or end users. In the context of the documented ETRM 12.2.2 metadata, OKL_INA_PVT provides the underlying data manipulation and validation logic for insurance asset records. The package operates against the OKL_INS_ASSETS entity, which stores insurance information associated with leased assets. It functions as a supporting layer beneath public packages such as OKL_INS_ASSETS_PUB and OKL_INS_QUOTE_PVT, encapsulating row-level insert, update, delete, lock, and validation operations together with concurrency and versioning support.

Key Procedures and Functions

The documented metadata lists eighteen procedures and functions. The primary procedural entries recorded are:

  • INSERT_ROW — Creates a new insurance asset row in the underlying table.
  • UPDATE_ROW — Modifies an existing insurance asset record.
  • DELETE_ROW — Removes an insurance asset record.
  • LOCK_ROW — Obtains a pessimistic lock on a target row, typically used to serialize concurrent modification.
  • VALIDATE_ROW — Performs business-rule validation prior to persistence.
  • CHANGE_VERSION — Manages the object version number used for optimistic concurrency control.
  • API_COPY — Duplicates an existing record, supporting copy operations within the insurance asset model.
  • QC — A quality-control or quick-check entry point used internally for consistency verification.

These routines collectively implement the standard EBS private API pattern: validation, row locking, version stamping, and DML, with error propagation through the shared FND_API, OKC_API, and OKL_API utility packages.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • OKL_INS_ASSETS — The central insurance asset table; the package reads and writes asset-linked insurance data here.
  • DUAL — Used for single-value evaluations and version or sequence checks.
  • PLITBLM — The PL/SQL index-by table of long messages, used to hold and process multi-row message payloads.

Usage Notes

OKL_INA_PVT is not designed for direct invocation from forms or concurrent programs. It is invoked indirectly through five documented dependents: OKL_AUTO_INSURANCE_PVT, OKL_INS_ASSETS_PUB, OKL_INSURANCE_POLICIES_PVT, OKL_INS_QUOTE_PVT, and OKL_INS_QUOTE_PVT_W. The presence of OKL_INS_QUOTE_PVT and its companion OKL_INS_QUOTE_PVT_W confirms that the package participates in insurance quotation flows, extending the standard OKL insurance asset lifecycle. Because the package depends on FND_API, OKC_API, and OKL_API, callers must ensure these shared APIs are initialized and that the FND global context is set. Customizations should extend the public packages rather than modifying OKL_INA_PVT, preserving upgrade safety across EBS 12.1.1 and 12.2.2.