eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_TEST dependencies on ICX_CAT_CATEGORY_ITEMS

Line 793: 'Delete test data from icx_cat_category_items');

789: CLOSE cTestRows;
790:
791: xErrLoc:= 600;
792: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
793: 'Delete test data from icx_cat_category_items');
794: xErrLoc:= 620;
795: xRowCount := 0;
796: OPEN cTestRows FOR
797: SELECT ROWID FROM icx_cat_category_items

Line 797: SELECT ROWID FROM icx_cat_category_items

793: 'Delete test data from icx_cat_category_items');
794: xErrLoc:= 620;
795: xRowCount := 0;
796: OPEN cTestRows FOR
797: SELECT ROWID FROM icx_cat_category_items
798: WHERE last_updated_by = TEST_USER_ID;
799: xErrLoc := 640;
800: LOOP
801: xRowIds.DELETE;

Line 810: DELETE icx_cat_category_items

806: EXIT WHEN xRowIds.COUNT = 0;
807: xRowCount := xRowCount + xRowIds.COUNT;
808: xErrLoc := 680;
809: FORALL i IN 1..xRowIds.COUNT
810: DELETE icx_cat_category_items
811: WHERE rowid = xRowIds(i);
812: COMMIT;
813: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
814: 'Processed records: ' || xRowCount);

Line 3615: FROM icx_cat_category_items

3611: BEGIN
3612: xErrLoc:= 100;
3613: SELECT 0
3614: INTO xResult
3615: FROM icx_cat_category_items
3616: WHERE rt_item_id = p_rt_item_id
3617: AND rt_category_id = p_rt_category_id;
3618:
3619: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 3622: '] exists in ICX_CAT_CATEGORY_ITEMS');

3618:
3619: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3620: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3621: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3622: '] exists in ICX_CAT_CATEGORY_ITEMS');
3623:
3624: xErrLoc:= 200;
3625: RETURN TRUE;
3626: EXCEPTION

Line 3632: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

3628: xResult:= 0;
3629: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3630: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3631: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3632: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3633: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3634: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3635: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3636: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

Line 3636: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

3632: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3633: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3634: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3635: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3636: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3637: RETURN FALSE;
3638: WHEN OTHERS THEN
3639: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.existCateoryItems-'||
3640: xErrLoc||' '||SQLERRM);

Line 3654: FROM icx_cat_category_items

3650: BEGIN
3651: xErrLoc:= 100;
3652: SELECT 0
3653: INTO xResult
3654: FROM icx_cat_category_items
3655: WHERE rt_item_id = p_rt_item_id
3656: AND rt_category_id = p_rt_category_id;
3657:
3658: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 3661: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

3657:
3658: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3659: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3660: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3661: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3662: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3663: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3664: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3665: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

Line 3665: '] does not exist in ICX_CAT_CATEGORY_ITEMS');

3661: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3662: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3663: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3664: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3665: '] does not exist in ICX_CAT_CATEGORY_ITEMS');
3666:
3667: xErrLoc:= 200;
3668: RETURN FALSE;
3669: EXCEPTION

Line 3675: '] exists in ICX_CAT_CATEGORY_ITEMS');

3671: xResult:= 0;
3672: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3673: 'CategoryItems[RT_ITEM_ID: ' || p_rt_item_id ||
3674: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3675: '] exists in ICX_CAT_CATEGORY_ITEMS');
3676: RETURN TRUE;
3677: WHEN OTHERS THEN
3678: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.notExistCateoryItems-'||
3679: xErrLoc||' '||SQLERRM);