APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_ELEMENTS_TL

Line 556: DELETE FROM CS_KB_ELEMENTS_TL WHERE ELEMENT_ID = P_STMT_TBL(a).element_id;

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);
559:
560: END LOOP;

Line 676: INSERT INTO CS_KB_ELEMENTS_TL (

672: -1351,
673: -1351,
674: P_STMT_TBL(i1).content_type );
675:
676: INSERT INTO CS_KB_ELEMENTS_TL (
677: element_id,
678: name,
679: creation_date,
680: created_by,

Line 700: FROM CS_KB_ELEMENTS_TL t

696: FROM FND_LANGUAGES l
697: WHERE l.installed_flag IN ('I', 'B')
698: AND NOT EXISTS
699: (SELECT NULL
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,

Line 777: DELETE FROM CS_KB_ELEMENTS_TL WHERE ELEMENT_ID = l_element_id;

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;
781: if fnd_api.to_boolean( p_commit ) then