Search Results okl_khr_pvt




Overview
Explore in AI Chat

Overview

OKL_KHR_PVT is a private PL/SQL package body in the APPS schema that supports Oracle E-Business Suite's Enterprise Telecommunications Resource Manager (ETRM) module, formerly known as Oracle Lease Management (OKL). The package encapsulates the business logic that governs the lifecycle of contract header records stored in the OKL_K_HEADERS table and its associated history and version tables. As a private (PVT) API, it is not intended for direct invocation by external or customer-facing code; instead it functions as an internal processing layer consumed by the public OKL_KHR_PUB package and by other ETRM components that must create, propagate, and validate contract header versions.

The package depends on a broad set of shared ETRM and Oracle foundation utilities, including FND_API and FND_GLOBAL for the standard API error-handling and multi-org context, OKC_API, OKC_UTIL, OKC_VERSION_PVT, and OKC_P_UTIL for contract core and versioning services, OKL_API, OKL_DFLEX_UTIL_PVT, and OKL_LEGAL_ENTITY_UTIL for lease-specific operations, and STANDARD for standard date and messaging utilities. This dependency footprint confirms the package's role as an integration point between the contract core, lease management, and legal entity subsystems.

Key Procedures and Functions

  • QC — Quality-control validation routine used to verify the integrity of contract header data before or after persistence.
  • CHANGE_VERSION — Advances a contract header from one version to another, orchestrating the version switch at the header level.
  • API_COPY — Copies contract header data, typically as part of version creation or contract duplication.
  • INSERT_ROW — Inserts a new contract header record into OKL_K_HEADERS.
  • UPDATE_ROW — Updates an existing contract header record.
  • DELETE_ROW — Removes a contract header record.
  • VALIDATE_ROW — Applies business validation rules to a header row prior to DML.
  • LOCK_ROW — Acquires a lock on the header row to protect against concurrent modification.
  • CREATE_VERSION — Establishes a new version of the contract header, writing version history.
  • RESTORE_VERSION — Reinstates a previously saved version of the header.

Together these routines implement the standard ETRM row-level API pattern: validate, lock, insert/update/delete, and manage version lineage.

Tables Accessed

The package reads and writes OKL_K_HEADERS and its history counterpart OKL_K_HEADERS_H, with supporting access through OKL_K_HEADERS_V. It references OKC_K_HEADERS_B for contract core header attributes, GL_DAILY_CONVERSION_TYPES for currency conversion data, OKL_PRODUCTS to resolve leasing product definitions, OKL_VP_CHANGE_REQUESTS for change-request tracking, and PLITBLM for PL/SQL table handling. These tables supply the currency, product, and contract-core context required to validate and version header rows.

Usage Notes

OKL_KHR_PVT is invoked indirectly through ETRM forms and concurrent processes, particularly lease and contract maintenance flows that save, version, or restore a contract header. It is referenced by 48 other database objects, so customization should be limited to wrapper logic in OKL_KHR_PUB or other public APIs. Direct calls are unsupported and may bypass validation, locking, and version-control rules.