Search Results update_k_article

Overview

OKL_VP_K_ARTICLE_PUB is the public application programming interface (API) for managing knowledge article records within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. The package belongs to the ETRM (Enterprise Transaction and Reference Management) family of APIs and is classified as a PUB (public) package, indicating that it is intended for external invocation by other application code, forms, and custom extensions. It is declared with AUTHID CURRENT_USER, meaning that privileges are evaluated against the invoking schema rather than the owning APPS schema.

The package acts as the entry point for creating, updating, and deleting knowledge article entities. It delegates the substantive business logic to the companion private package OKL_VP_K_ARTICLE_PVT, from which it inherits the catv_rec_type and catv_tbl_type subtypes. These subtypes support both single-record and table-based (bulk) DML operations, allowing callers to process one article or a set of articles in a single API call. A global record variable, g_catv_rec, exposes user-hook customization points for extensions.

Key Procedures and Functions

The documented API surface comprises the following procedures and functions:

• ADD_LANGUAGE — Populates or maintains the language-specific (translated) rows associated with knowledge article data, supporting the multi-language architecture used throughout Oracle EBS.
• CREATE_K_ARTICLE — Inserts a new knowledge article. The package provides overloaded variants, allowing the caller to pass either a single record (via catv_rec_type) or a collection (via catv_tbl_type), with corresponding output records.
• UPDATE_K_ARTICLE — Modifies an existing knowledge article, again available in both single-record and table-based overloaded forms.
• DELETE_K_ARTICLE — Removes a knowledge article, provided in single-record and table-based overloads.
• STD_ART_NAME — Derives or standardizes an article name according to internal naming conventions, ensuring consistency across article records.
• COPY_ARTICLES_TEXT — Copies article text content, typically used when duplicating or propagating article text between records or languages. This function relates directly to the user search term "copy_articles_text."

All DML procedures follow the standard EBS API convention, returning x_return_status, x_msg_count, and x_msg_data to communicate success, error, or warning states to the caller. The p_init_msg_list parameter controls whether the message list is initialized at the start of the call.

Tables Accessed

The package operates against the following tables, accessed through APPS synonyms:

• OKL_VP_ASSOCIATIONS — Stores association records linking knowledge article entities to related objects. This table is central to the article lifecycle managed by this API.
• PLITBLM — The standard EBS message table used by the message-handling framework to retrieve and store API error and informational messages.

Usage Notes

OKL_VP_K_ARTICLE_PUB is typically invoked from EBS forms, concurrent programs, or custom PL/SQL code that needs to manage knowledge articles. Because it is a PUB-classified API, it is the supported integration point; custom code should call this package rather than writing directly to the underlying tables. The package is referenced by four other packages, confirming its role as a shared dependency.

The header comment indicates a version lineage traceable to OKLPCARS.pls (version 120.1, dated 2005), reflecting the package's long-standing stability across 12.1.1 and 12.2.2. When invoking the DML routines, callers must always check x_return_status and, when it equals OKC_API.G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR, iterate the message list to surface diagnostics.