APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_CATEGORIES

Line 1573: FROM CS_KB_SET_CATEGORIES

1569: IS
1570:
1571: CURSOR Is_Linked (cp_set_id NUMBER) IS
1572: SELECT count(1)
1573: FROM CS_KB_SET_CATEGORIES
1574: WHERE Set_Id = cp_set_id
1575: AND Category_Id = P_DEST_CAT_ID;
1576:
1577: CURSOR Is_Category_Existing (cp_cat_id NUMBER) IS

Line 1621: delete from cs_kb_set_categories

1617: l_set_id := p_set_ids(i);
1618:
1619: --Remove old link.
1620: If P_SRC_CAT_ID <> -1 Then
1621: delete from cs_kb_set_categories
1622: where set_id = l_set_id and category_id = P_SRC_CAT_ID;
1623: If SQL%notfound Then
1624: l_cat_id := P_SRC_CAT_ID;
1625: Raise INVALID_SET_CATEGORY_LINK;

Line 1636: insert into cs_kb_set_categories

1632: Close Is_Linked;
1633:
1634: --If not linked create this link.
1635: if(l_count = 0) then
1636: insert into cs_kb_set_categories
1637: (
1638: set_id,
1639: category_id,
1640: creation_date,

Line 1752: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;

1748: x_entity_name => 'CS_KB_SETS_B',
1749: x_pk1_value => TO_CHAR(p_set_id),
1750: x_delete_document_flag => 'Y'
1751: ) ;
1752: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;
1753: DELETE FROM CS_KB_SET_PRODUCTS WHERE set_id = p_set_id;
1754: DELETE FROM CS_KB_SET_PLATFORMS WHERE set_id = p_set_id;
1755: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1756: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;