Search Results okl_vp_k_article_pub




Overview
Explore in AI Chat

Overview

OKL_VP_K_ARTICLE_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Enterprise Asset Management / Lease and Finance Management (OKL) vertical, specifically the "VP" (vendor program) sub-module dealing with knowledge-base article content. The "_PVT" suffix identifies it as a private implementation package: it is not intended to be called directly by external code but instead is invoked by the corresponding public wrapper OKL_VP_K_ARTICLE_PUB, which the ETRM dependency metadata confirms references this package. In Oracle EBS 12.1.1 and 12.2.2 the package is installed with a VALID status and is part of the standard APPS schema deployment.

The package provides the business logic for maintaining "K_ARTICLE" (knowledge article) records associated with vendor program or lease contracts. It encapsulates the create, read/update, and delete operations plus a language-handling routine, following the standard Oracle Application Object Library (AOL) private/public API pattern used throughout EBS.

Key Procedures and Functions

The documented interface exposes five procedures/functions:

  • CREATE_K_ARTICLE — Inserts a new knowledge-base article record, populating the base article definition and its association to the relevant vendor program entity. This is the primary entry point for new article creation.
  • UPDATE_K_ARTICLE — Modifies the attributes of an existing article, such as its text, status, or association links, preserving the record identity.
  • DELETE_K_ARTICLE — Removes an article record, typically with the logical-delete semantics common in EBS (setting an end-date or inactive flag rather than a physical row delete).
  • ADD_LANGUAGE_K_ARTICLE — Creates or maintains the translation/language-specific version of an article, supporting the multi-language content model used across EBS. This method complements CREATE_K_ARTICLE by handling the language-dependent detail rows.
  • EMPTYCLOB — A utility routine that clears or returns an empty CLOB, used when article content is reset or when a language version needs to be blanked. It supports the DBMS_LOB operations required for large text storage.

No parameter signatures are documented; callers should always go through the OKL_VP_K_ARTICLE_PUB wrapper, which supplies the standard API validation and message-handling conventions.

Tables Accessed

The package reads and writes through APPS synonyms. The documented tables are:

  • OKL_VP_ASSOCIATIONS — The association/relationship table that links knowledge articles to vendor program entities. CREATE, UPDATE and DELETE operations maintain the rows in this table so that an article remains correctly related to its parent contract or program.
  • DBMS_LOB — The Oracle-supplied large-object package, invoked (via EMPTYCLOB) to manipulate the CLOB columns that hold article body text, including clearing or truncating large content.

Additional dependency metadata shows the package references OKC_API and OKL_OKC_MIGRATION_A_PVT, indicating integration with the Oracle Contracts (OKC) API layer and the OKL-to-OKC migration logic, which is expected when article content is migrated or synchronised between the legacy OKL and the newer Contracts model.

Usage Notes

Because this is a private package, it is normally invoked indirectly:

  • Public API wrapper — OKL_VP_K_ARTICLE_PUB, and its worker OKL_VP_K_ARTICLE_PVT_W, call into this package. Forms, OAF pages or concurrent programs that maintain vendor-program knowledge articles should call the PUB package, never the PVT package directly.
  • Internal recursion — The metadata notes the package references itself, which is typical of private packages that use internal helper calls and shared private state.
  • Custom extensions — Developers extending EBS 12.1.1 or 12.2.2 should treat OKL_VP_K_ARTICLE_PVT as internal and prefer the published interface to remain upgrade-safe. Direct calls risk breaking on patching since private APIs carry no support commitment.

In short, OKL_VP_K_ARTICLE_PVT is the private engine behind vendor-program article maintenance, handling creation, update, deletion, multilingual content and CLOB housekeeping for the OKL_VP_ASSOCIATIONS data model.