Search Results delete_element_type_link




Overview
Explore in AI Chat

Overview

CS_KB_ELE_TYPE_LINKS_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Knowledge Base (KB) component of the Service (CS) product family and encapsulates the business logic for maintaining relationships between knowledge base element types and the entities they are linked to. In the EBS Knowledge Base data model, an element type is a reusable definition that governs how a piece of knowledge content is structured — a solution, a problem, a cause, or a resolution, for example. The link records managed by this package associate such element types with related objects, expressed through a link type, an object code, and an identifier or code for the other side of the relationship. By centralizing the insert, update, and delete operations for these associations, the package shields callers from the underlying table structure and ensures consistent validation and attribute handling. Its header identifies it as an AUTHID CURRENT_USER package, so it executes with the privileges of the invoking user rather than the definer, and it follows the conventional EBS API pattern of returning a numeric status code, using the constants ERROR_STATUS (-1) and OKAY_STATUS (0) for failure and success respectively.

Key Procedures and Functions

The ETRM metadata documents six callable units:

  • CREATE_ELEMENT_TYPE_LINK — Creates a new link row between an element type and a related entity. It accepts a link type, an object code, the element type identifier, an identifier and code for the other side of the relationship, and a standard set of descriptive flexfield attribute columns. It returns a number indicating success or failure, making it the primary entry point sought by the query "create_element_type_link".
  • UPDATE_ELEMENT_TYPE_LINK — Modifies an existing link row identified by its link identifier, applying the same set of link type, object code, element type, other identifier, other code, and descriptive flexfield attributes.
  • DELETE_ELEMENT_TYPE_LINK — Removes a link record, undoing an association previously established by the create routine.
  • INSERT_ROW — The lower-level insert routine used to append a row to the links table.
  • UPDATE_ROW — The lower-level update routine used to change an existing row.
  • LOAD_ROW — A load routine that inserts or updates a row in a single call, typically used for data conversion and seeding.

Tables Accessed

The package operates against the following objects, referenced through APPS synonyms:

  • CS_KB_ELE_TYPE_LINKS — The base table holding the element type link records. It is the primary target of the insert, update, and delete operations.
  • CS_KB_ELE_TYPE_LINKS_S — The sequence used to generate primary key values for new link rows.
  • CS_KB_ELEMENT_TYPES_B — The base table of element type definitions. It is referenced to validate the element type identifier supplied to the create and update routines.
  • DUAL — The standard Oracle single-row table, used for lightweight SQL expressions such as sequence retrieval and validation checks.

Usage Notes

CS_KB_ELE_TYPE_LINKS_PKG is invoked from Knowledge Base setup and maintenance forms, from concurrent programs that load or refresh link data, and from custom PL/SQL that programmatically manages element type associations. Because the create and update functions return a number rather than raising exceptions, calling code should check the return value against OKAY_STATUS (0) and treat ERROR_STATUS (-1) as a failure. The package is documented as referenced by one other package, indicating layered reuse within the Knowledge Base schema. In 12.1.1 and 12.2.2 the implementation is unchanged, so upgrade considerations are limited to the usual EBS caveat that direct DML on the underlying tables should be avoided in favor of these API entry points. The LOAD_ROW and INSERT_ROW procedures are most relevant to migration and seed-data scenarios, while CREATE_ELEMENT_TYPE_LINK remains the standard route for runtime association of an element type with a related knowledge object.