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,
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:
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;
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;
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