Search Results create_set_link

Overview

The APPS.CS_KB_SET_LINKS_PKG package body is a server-side PL/SQL API belonging to the Oracle E-Business Suite Knowledge Base (KB) module, part of the Service (CS) product family. It encapsulates the business logic required to manage associations, or "links," between a Knowledge Base set and external objects such as solutions, documents, or other referenced entities. In the Oracle EBS 12.1.1 and 12.2.2 data models, the Knowledge Base organizes content into sets (stored in CS_KB_SETS_B), and each set may be linked to one or more objects through records stored in the CS_KB_SET_LINKS table. This package provides the programmatic interface for creating, updating, deleting, and duplicating those links while preserving audit columns and raising the appropriate workflow events. It is classified as an OTHER API, indicating it is a supporting utility package rather than a primary public API, though it is referenced by three other packages within the application.

Key Procedures and Functions

• CLONE_LINK — Duplicates all link rows associated with a source set identifier to a new target set identifier. The function validates the source set against CS_KB_SETS_B, retrieves the existing links via a cursor on CS_KB_SET_LINKS, and reinserts them with a new link identifier from the sequence, stamping new creation and update audit information. It returns an OK or error status.
• CREATE_SET_LINK — Creates a new link record between a Knowledge Base set and a referenced object.
• CREATE_SET_EXT_LINK — Creates an extended link record, supporting additional link attributes beyond the base linkage.
• UPDATE_SET_LINK — Modifies an existing set link record.
• DELETE_SET_LINK_W_OBJ_CODE — Deletes a set link by identifying it through the object code.
• DELETE_SET_LINK — Removes a set link record by its primary identifier.
• INSERT_ROW — Low-level table handler that inserts a fully specified row into CS_KB_SET_LINKS, including all descriptive and DFF attribute columns.
• UPDATE_ROW — Low-level table handler that updates an existing row in CS_KB_SET_LINKS.
• RAISE_SOLUTION_LINKED_EVENT — Dispatches a workflow/business event signaling that a solution has been linked to a set.
• RAISE_SOLN_LINK_UPDATED_EVENT — Dispatches the corresponding event when a solution link is updated.

Tables Accessed

• CS_KB_SETS_B — Holds the Knowledge Base set definitions; read during clone validation to confirm the source set exists.
• CS_KB_SET_LINKS — The primary transactional table storing set-to-object associations; subject to insert, update, delete, and query operations.
• CS_KB_SET_LINKS_S — The sequence used to generate new link identifiers via nextval.
• JTF_OBJECT_USAGES — Supports object usage and categorization metadata referenced during link creation.
• WF_PARAMETER_LIST_T — Used to construct parameter lists for raising workflow events.
• DBMS_SQL, DUAL, and PLITBLM — Utility references for dynamic SQL, single-row selection, and PL/SQL index-by table handling.

Usage Notes

This package is typically invoked from Oracle Forms within the Knowledge Base authoring and administration flows, from concurrent programs that maintain solution-to-set associations, and from custom extensions requiring programmatic management of KB links. Because it raises workflow events upon linking or updating solutions, integrations that must trigger downstream notifications or business processes should call the higher-level procedures rather than the low-level INSERT_ROW and UPDATE_ROW handlers, which bypass event dispatch. Callers must supply valid set identifiers and ensure the invoking session initializes FND_GLOBAL so that audit columns populate correctly. Given its classification as a supporting API, direct invocation should be limited to scenarios where no documented public API fulfills the requirement.