APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SET_ELES

Line 548: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SOLN_REC.Set_id;

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:
552: WHILE a IS NOT NULL LOOP

Line 704: INSERT INTO CS_KB_SET_ELES (SET_ID,

700: FROM CS_KB_ELEMENTS_TL t
701: WHERE t.element_id = P_STMT_TBL(i1).element_id
702: AND t.language = l.language_code);
703:
704: INSERT INTO CS_KB_SET_ELES (SET_ID,
705: ELEMENT_ID,
706: ELEMENT_ORDER,
707: CREATION_DATE,
708: CREATED_BY,

Line 762: FROM CS_KB_SET_ELES

758: P_SET_ID IN NUMBER)
759: IS
760: CURSOR Get_Elements IS
761: SELECT ELEMENT_ID
762: FROM CS_KB_SET_ELES
763: WHERE SET_ID = P_SET_ID;
764: l_element_id NUMBER;
765: BEGIN
766: --Remove Solution

Line 778: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SET_ID and ELEMENT_ID = l_element_id;

774: FETCH Get_Elements INTO l_element_id;
775: EXIT WHEN Get_Elements%NOTFOUND;
776: DELETE FROM CS_KB_ELEMENTS_B WHERE ELEMENT_ID = l_element_id;
777: DELETE FROM CS_KB_ELEMENTS_TL WHERE ELEMENT_ID = l_element_id;
778: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SET_ID and ELEMENT_ID = l_element_id;
779: END LOOP;
780: CLOSE Get_Elements;
781: if fnd_api.to_boolean( p_commit ) then
782: commit;