5: -- Create Category Group
6: PROCEDURE Create_CG (P_ID NUMBER, P_NAME VARCHAR2)
7: IS
8: BEGIN
9: insert into CS_KB_CATEGORY_GROUPS_B (
10: CATEGORY_GROUP_ID,
11: CREATION_DATE,
12: CREATED_BY,
13: LAST_UPDATE_DATE,
219: BEGIN
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;
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;
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;
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;
233: Create_CG (P_ID => CAT_GROUP_API_TEST_CG2, P_NAME => 'Api_Test_CG2');
234:
235: -------------------------------------------------------------