Search Results oks_kln_pvt




Overview
Explore in AI Chat

Overview

OKS_KLN_PVT is a private PL/SQL package body in the APPS schema that supports the service contract knowledge base line (K-line) functionality in Oracle E-Business Suite. The "PVT" suffix classifies the package as a private API component within Oracle's API classification scheme, indicating that it is intended for internal consumption by other EBS packages rather than for direct invocation by customer extensions. The package underpins the storage, translation, and lifecycle management of knowledge line records associated with service contracts and related entitlement structures, and it is a core member of the OKS (Service Contracts) module stack.

According to the ETRM metadata for release 12.2.2, the object is VALID and is documented as a PACKAGE BODY owned by APPS. It is referenced by 17 other database packages, confirming its role as a shared internal utility rather than an application-facing API. Its dependencies include FND_API, FND_GLOBAL, FND_LANGUAGES, FND_MSG_PUB, APP_EXCEPTIONS, OKC_API, and OKC_P_UTIL, which collectively provide error handling, multi-language support, message publication, and core contract utilities.

Key Procedures and Functions

The ETRM documentation lists 19 documented procedures and functions for this package body, of which nine are named explicitly. Each serves a distinct purpose within the knowledge line maintenance workflow:

  • QC — A quality-control or validation helper invoked during record processing to enforce data integrity rules before commits.
  • CHANGE_VERSION — Handles versioning of knowledge line records, ensuring that revisions are tracked appropriately when contract content changes.
  • API_COPY — Copies knowledge line data from a source record to a target, supporting duplication scenarios such as contract cloning or template application.
  • ADD_LANGUAGE — Inserts translation rows for supported languages, working in conjunction with FND_LANGUAGES to maintain multi-lingual content.
  • INSERT_ROW — Performs the base insert of a knowledge line record into the underlying base table.
  • LOCK_ROW — Acquires a lock on an existing record to prevent concurrent modification during an update cycle.
  • UPDATE_ROW — Modifies an existing knowledge line record with new attribute values.
  • DELETE_ROW — Removes a knowledge line record, typically subject to referential and business rule validation.
  • VALIDATE_ROW — Applies business rule checks to a record prior to INSERT, UPDATE, or DELETE operations.

These routines follow Oracle's standard table-handler API pattern: validate, lock, insert, update, delete, plus auxiliary copy, translation, and version operations.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

  • OKS_K_LINES_B — The base table holding the primary knowledge line records, targeted by INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • OKS_K_LINES_TL — The translation table storing language-specific descriptive content, maintained by ADD_LANGUAGE and accessed by the multi-lingual retrieval paths.
  • OKS_K_LINES_V — A view over the knowledge line tables used for read operations.
  • FND_LANGUAGES — The Oracle Applications language registry, consulted to determine valid languages for translation inserts.
  • PLITBLM — A PL/SQL internal table used for temporary in-memory storage during processing.

Usage Notes

Because OKS_KLN_PVT is a private package, it is not intended for direct invocation from forms, concurrent programs, or customer-written code. Instead, it is called internally by other OKS and OKC packages — the ETRM metadata confirms it is referenced by 17 other packages, while it is not referenced by any database object itself as a dependency target outside that set. Oracle support and diagnostics reference this object when investigating issues with knowledge line creation, translation, or versioning within Service Contracts. Customizations that manipulate OKS_K_LINES tables directly should be avoided in favour of the corresponding public APIs, since bypassing this package's validation and locking logic can compromise data integrity. The package is present and valid in both 12.1.1 and 12.2.2 releases.