DBA Data[Home] [Help]

APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_CATEGORY_GROUPS_B

Line 9: insert into CS_KB_CATEGORY_GROUPS_B (

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,

Line 223: DELETE FROM CS_KB_CATEGORY_GROUPS_B WHERE CATEGORY_GROUP_ID = CAT_GROUP_API_TEST_DEFAULT;

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;

Line 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;

Line 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: -------------------------------------------------------------