APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SETS_TL

Line 546: DELETE FROM CS_KB_SETS_TL WHERE SET_ID = P_SOLN_REC.Set_id;

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:
550: a := P_STMT_TBL.FIRST;

Line 610: INSERT INTO CS_KB_SETS_TL (

606: 'Y',
607: 0,
608: l_fdi );
609:
610: INSERT INTO CS_KB_SETS_TL (
611: set_id,
612: name,
613: creation_date,
614: created_by,

Line 634: FROM CS_KB_SETS_TL t

630: FROM fnd_languages l
631: WHERE l.installed_flag IN ('I', 'B')
632: AND NOT EXISTS
633: (SELECT NULL
634: FROM CS_KB_SETS_TL t
635: WHERE t.set_id = P_SOLN_REC.set_id
636: AND t.language = l.language_code);
637:
638:

Line 768: DELETE FROM CS_KB_SETS_TL 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
772: OPEN Get_Elements;