APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SETS_B

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 545: DELETE FROM CS_KB_SETS_B WHERE SET_ID = P_SOLN_REC.Set_id;

541: i2 pls_integer;
542:
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:

Line 573: INSERT INTO CS_KB_SETS_B (

569: l_fdi := -1;
570: END IF;
571:
572:
573: INSERT INTO CS_KB_SETS_B (
574: set_id,
575: set_number,
576: set_type_id,
577: status,

Line 767: DELETE FROM CS_KB_SETS_B WHERE SET_ID = P_SET_ID;

763: WHERE SET_ID = P_SET_ID;
764: l_element_id NUMBER;
765: BEGIN
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

Line 799: UPDATE CS_KB_SETS_B SET STATUS = 'OBS' WHERE SET_ID = P_SET_ID;

795: P_SET_ID IN NUMBER)
796: IS
797: BEGIN
798: --Remove Solution
799: UPDATE CS_KB_SETS_B SET STATUS = 'OBS' WHERE SET_ID = P_SET_ID;
800: END Obsolete_Solution;
801:
802: --Get next solution ID from sequence
803: FUNCTION Get_Next_Set_ID