APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_CATEGORY_GROUPS_TL

Line 24: insert into CS_KB_CATEGORY_GROUPS_TL (

20: sysdate,
21: -1351,
22: -1351 );
23:
24: insert into CS_KB_CATEGORY_GROUPS_TL (
25: CATEGORY_GROUP_ID,
26: NAME,
27: DESCRIPTION,
28: CREATION_DATE,

Line 50: from CS_KB_CATEGORY_GROUPS_TL T

46: from FND_LANGUAGES L
47: where L.INSTALLED_FLAG in ('I', 'B')
48: and not exists
49: (select NULL
50: from CS_KB_CATEGORY_GROUPS_TL T
51: where T.CATEGORY_GROUP_ID = P_ID
52: and T.LANGUAGE = L.LANGUAGE_CODE);
53: END Create_CG;
54:

Line 224: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_DEFAULT;

220: -------------------------------------------------------------
221: -- Create Seeded Category Groups
222: -------------------------------------------------------------
223: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_DEFAULT;
224: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_DEFAULT;
225: Create_CG (P_ID => CAT_GROUP_API_TEST_DEFAULT, P_NAME => 'Api_Test_Default_CG');
226:
227: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;
228: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;

Line 228: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;

224: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_DEFAULT;
225: Create_CG (P_ID => CAT_GROUP_API_TEST_DEFAULT, P_NAME => 'Api_Test_Default_CG');
226:
227: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;
228: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;
229: Create_CG (P_ID => CAT_GROUP_API_TEST_CG1, P_NAME => 'Api_Test_CG1');
230:
231: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG2;
232: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG2;

Line 232: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG2;

228: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG1;
229: Create_CG (P_ID => CAT_GROUP_API_TEST_CG1, P_NAME => 'Api_Test_CG1');
230:
231: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG2;
232: DELETE FROM CS_KB_CATEGORY_GROUPS_TL WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_CG2;
233: Create_CG (P_ID => CAT_GROUP_API_TEST_CG2, P_NAME => 'Api_Test_CG2');
234:
235: -------------------------------------------------------------
236: -- Create Seeded Solution Types