APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SET_CATEGORIES

Line 470: from cs_kb_set_categories sl, cs_kb_sets_b b

466: l_delete_status number;
467: begin
468:
469: select /*+ index(sl) */ count( * ) into n_child_solutions
470: from cs_kb_set_categories sl, cs_kb_sets_b b
471: where sl.category_id = p_category_id
472: and b.set_id = sl.set_id
473: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));
474:

Line 493: delete /*+ index(sl) */ from cs_kb_set_categories sl

489: p_data => X_MSG_DATA);
490:
491: ELSE
492: -- Delete all set category links (which should not be PUBlished versions)
493: delete /*+ index(sl) */ from cs_kb_set_categories sl
494: where sl.category_id = p_category_id;
495:
496: -- Delete this leaf category
497: delete from cs_kb_soln_categories_tl

Line 547: DELETE FROM CS_KB_SET_CATEGORIES WHERE SET_ID = P_SOLN_REC.Set_id;

543: BEGIN
544: dbms_output.put_line('Before Delete');
545: DELETE FROM CS_KB_SETS_B WHERE SET_ID = P_SOLN_REC.Set_id;
546: DELETE FROM CS_KB_SETS_TL WHERE SET_ID = P_SOLN_REC.Set_id;
547: DELETE FROM CS_KB_SET_CATEGORIES WHERE SET_ID = P_SOLN_REC.Set_id;
548: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SOLN_REC.Set_id;
549:
550: a := P_STMT_TBL.FIRST;
551:

Line 727: INSERT INTO CS_KB_SET_CATEGORIES (SET_ID,

723:
724: i2 := p_CAT_TBL.FIRST;
725: while i2 is not null loop
726: dbms_output.put_line('Add Cat'||p_CAT_TBL(i2) );
727: INSERT INTO CS_KB_SET_CATEGORIES (SET_ID,
728: CATEGORY_ID,
729: CREATION_DATE,
730: CREATED_BY,
731: LAST_UPDATE_DATE,

Line 770: DELETE FROM CS_KB_SET_CATEGORIES WHERE SET_ID = P_SET_ID;

766: --Remove Solution
767: DELETE FROM CS_KB_SETS_B WHERE SET_ID = P_SET_ID;
768: DELETE FROM CS_KB_SETS_TL WHERE SET_ID = P_SET_ID;
769: --Remove Solution Category
770: DELETE FROM CS_KB_SET_CATEGORIES WHERE SET_ID = P_SET_ID;
771: --Remove Solution Statements
772: OPEN Get_Elements;
773: LOOP
774: FETCH Get_Elements INTO l_element_id;