APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_ELEMENTS_B

Line 554: DELETE FROM CS_KB_ELEMENTS_B WHERE ELEMENT_ID = P_STMT_TBL(a).element_id;

550: a := P_STMT_TBL.FIRST;
551:
552: WHILE a IS NOT NULL LOOP
553:
554: DELETE FROM CS_KB_ELEMENTS_B WHERE ELEMENT_ID = P_STMT_TBL(a).element_id;
555:
556: DELETE FROM CS_KB_ELEMENTS_TL WHERE ELEMENT_ID = P_STMT_TBL(a).element_id;
557:
558: a := P_STMT_TBL.NEXT(a);

Line 651: INSERT INTO CS_KB_ELEMENTS_B (

647: i1 := P_STMT_TBL.FIRST;
648:
649: while i1 is not null loop
650:
651: INSERT INTO CS_KB_ELEMENTS_B (
652: element_id,
653: element_number,
654: element_type_id,
655: status,

Line 776: DELETE FROM CS_KB_ELEMENTS_B WHERE ELEMENT_ID = l_element_id;

772: OPEN Get_Elements;
773: LOOP
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;