Search Results check_link_exists

Overview

CS_KB_ELE_TYPE_LINKS_PKG is an Oracle EBS Application Object Library package body owned by APPS that manages the association records between knowledge base element types and external or related entities. In the Oracle Advanced Product Catalog and Customer Support knowledge base modules, element types represent the reusable building blocks from which knowledge articles, solutions, and catalog objects are constructed. The CS_KB_ELE_TYPE_LINKS table stores the many-to-many relationships connecting an element type to other objects within the application, qualified by an object code, an other-code, and an optional other-id. This package encapsulates the create, update, delete, and bulk-load operations against that link table, ensuring that referential integrity against CS_KB_ELEMENT_TYPES_B is enforced and that duplicate link definitions are not created. The package is classified as OTHER in the ETRM repository and carries the source header tag cskbetlb.pls, version 115.13, last shipped in December 2003, indicating a long-stable interface that has remained compatible across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• CREATE_ELEMENT_TYPE_LINK — Creates a new row in cs_kb_ele_type_links. Before insertion it validates that the mandatory parameters are populated and that the referenced element_type_id exists in cs_kb_element_types_b. The function declares a Check_Link_Exists cursor that counts existing rows matching object_code, element_type_id, other_code, and a null-safe comparison on other_id; when the count is greater than zero the create is rejected as a duplicate.
• UPDATE_ELEMENT_TYPE_LINK — Modifies an existing link record, applying the same validation logic and duplicate detection patterns used during creation.
• DELETE_ELEMENT_TYPE_LINK — Removes a link row, allowing the relationship between an element type and its associated object to be dissolved.
• INSERT_ROW — Performs a direct insert into the link table, typically used by bulk load or migration utilities where full validation is not required.
• UPDATE_ROW — Performs a direct update of an existing link row without the full business validation path.
• LOAD_ROW — Provides an interface for loading or upserting link data, commonly invoked from concurrent data-loading programs and the standard EBS loader framework.

Tables Accessed

• CS_KB_ELE_TYPE_LINKS — The primary transactional table holding the link records. The package inserts, updates, deletes, and reads from it, including the duplicate-detection count query.
• CS_KB_ELE_TYPE_LINKS_S — The sequence table that supplies the link_id primary key value for new records.
• CS_KB_ELEMENT_TYPES_B — The base table of element type definitions, read during parameter validation to confirm the supplied element_type_id is valid.
• DUAL — Used for simple single-row selects within the PL/SQL logic.

Usage Notes

This package is invoked from Oracle Forms, concurrent programs, and custom PL/SQL when knowledge base element type relationships must be maintained. The check_link_exists cursor pattern is the canonical duplicate-prevention mechanism: callers searching for that term will find it implemented here as a private cursor inside CREATE_ELEMENT_TYPE_LINK, where it performs a null-safe comparison on other_id and returns a count used to short-circuit the insert. Because the API is classified as OTHER rather than a public, supported interface, direct modification of the underlying tables is discouraged; integrators should call the documented procedures instead. The package is referenced by one other package in the ETRM repository, confirming its role as a shared dependency within the customer support knowledge module.