APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_CATEGORIES

Line 1587: FROM CS_KB_SET_CATEGORIES

1583: IS
1584:
1585: CURSOR Is_Linked (cp_set_id NUMBER) IS
1586: SELECT count(1)
1587: FROM CS_KB_SET_CATEGORIES
1588: WHERE Set_Id = cp_set_id
1589: AND Category_Id = P_DEST_CAT_ID;
1590:
1591: CURSOR Is_Category_Existing (cp_cat_id NUMBER) IS

Line 1635: delete from cs_kb_set_categories

1631: l_set_id := p_set_ids(i);
1632:
1633: --Remove old link.
1634: If P_SRC_CAT_ID <> -1 Then
1635: delete from cs_kb_set_categories
1636: where set_id = l_set_id and category_id = P_SRC_CAT_ID;
1637: If SQL%notfound Then
1638: l_cat_id := P_SRC_CAT_ID;
1639: Raise INVALID_SET_CATEGORY_LINK;

Line 1650: insert into cs_kb_set_categories

1646: Close Is_Linked;
1647:
1648: --If not linked create this link.
1649: if(l_count = 0) then
1650: insert into cs_kb_set_categories
1651: (
1652: set_id,
1653: category_id,
1654: creation_date,

Line 1766: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;

1762: x_entity_name => 'CS_KB_SETS_B',
1763: x_pk1_value => TO_CHAR(p_set_id),
1764: x_delete_document_flag => 'Y'
1765: ) ;
1766: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;
1767: DELETE FROM CS_KB_SET_PRODUCTS WHERE set_id = p_set_id;
1768: DELETE FROM CS_KB_SET_PLATFORMS WHERE set_id = p_set_id;
1769: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1770: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;