APPS.ICX_POR_EXT_TEST dependencies on ICX_CAT_CATEGORIES_TL

Line 659: 'Delete test data from icx_cat_categories_tl');

655:
656: BEGIN
657: xErrLoc:= 100;
658: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
659: 'Delete test data from icx_cat_categories_tl');
660: xErrLoc:= 120;
661: OPEN cTestRows FOR
662: SELECT ROWID FROM icx_cat_categories_tl
663: WHERE last_updated_by = TEST_USER_ID;

Line 662: SELECT ROWID FROM icx_cat_categories_tl

658: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
659: 'Delete test data from icx_cat_categories_tl');
660: xErrLoc:= 120;
661: OPEN cTestRows FOR
662: SELECT ROWID FROM icx_cat_categories_tl
663: WHERE last_updated_by = TEST_USER_ID;
664: xErrLoc := 140;
665: LOOP
666: xRowIds.DELETE;

Line 675: DELETE icx_cat_categories_tl

671: EXIT WHEN xRowIds.COUNT = 0;
672: xRowCount := xRowCount + xRowIds.COUNT;
673: xErrLoc := 180;
674: FORALL i IN 1..xRowIds.COUNT
675: DELETE icx_cat_categories_tl
676: WHERE rowid = xRowIds(i);
677: COMMIT;
678: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
679: 'Processed records: ' || xRowCount);

Line 1239: FROM icx_cat_categories_tl

1235: BEGIN
1236: xErrLoc:= 100;
1237: SELECT 1
1238: INTO xResult
1239: FROM icx_cat_categories_tl
1240: WHERE key = p_category_key
1241: AND category_name = p_category_name
1242: AND ROWNUM = 1;
1243: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 1245: p_category_name || '] exists in ICX_CAT_CATEGORIES_TL');

1241: AND category_name = p_category_name
1242: AND ROWNUM = 1;
1243: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1244: 'Category[Key: ' || p_category_key || ', Name: ' ||
1245: p_category_name || '] exists in ICX_CAT_CATEGORIES_TL');
1246:
1247: xErrLoc:= 140;
1248: SELECT 2
1249: INTO xResult

Line 1297: FROM icx_cat_categories_tl

1293: BEGIN
1294: xErrLoc:= 100;
1295: SELECT 0
1296: INTO xResult
1297: FROM icx_cat_categories_tl
1298: WHERE key = p_category_key
1299: AND ROWNUM = 1;
1300: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1301: 'Category[Key: ' || p_category_key || '] exists in ICX_CAT_CATEGORIES_TL');

Line 1301: 'Category[Key: ' || p_category_key || '] exists in ICX_CAT_CATEGORIES_TL');

1297: FROM icx_cat_categories_tl
1298: WHERE key = p_category_key
1299: AND ROWNUM = 1;
1300: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1301: 'Category[Key: ' || p_category_key || '] exists in ICX_CAT_CATEGORIES_TL');
1302: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
1303: 'Category[Key: ' || p_category_key || '] exist');
1304:
1305: xErrLoc:= 200;

Line 1330: FROM icx_cat_categories_tl

1326: BEGIN
1327: xErrLoc:= 100;
1328: SELECT 1
1329: INTO xResult
1330: FROM icx_cat_categories_tl
1331: WHERE key = p_category_key
1332: AND category_name = p_category_name
1333: AND language = p_language
1334: AND ROWNUM = 1;

Line 1338: '] exists in ICX_CAT_CATEGORIES_TL');

1334: AND ROWNUM = 1;
1335: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1336: 'Category[Key: ' || p_category_key || ', Name: ' ||
1337: p_category_name || ', Language: ' || p_language ||
1338: '] exists in ICX_CAT_CATEGORIES_TL');
1339:
1340: xErrLoc:= 200;
1341: RETURN TRUE;
1342: EXCEPTION