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_ITEMS_B

Line 739: 'Delete test data from icx_cat_items_b');

735: CLOSE cTestRows;
736:
737: xErrLoc:= 400;
738: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
739: 'Delete test data from icx_cat_items_b');
740: xErrLoc:= 420;
741: xRowCount := 0;
742: OPEN cTestRows FOR
743: SELECT ROWID FROM icx_cat_items_b

Line 743: SELECT ROWID FROM icx_cat_items_b

739: 'Delete test data from icx_cat_items_b');
740: xErrLoc:= 420;
741: xRowCount := 0;
742: OPEN cTestRows FOR
743: SELECT ROWID FROM icx_cat_items_b
744: WHERE last_updated_by = TEST_USER_ID;
745: xErrLoc := 440;
746: LOOP
747: xRowIds.DELETE;

Line 756: DELETE icx_cat_items_b

752: EXIT WHEN xRowIds.COUNT = 0;
753: xRowCount := xRowCount + xRowIds.COUNT;
754: xErrLoc := 480;
755: FORALL i IN 1..xRowIds.COUNT
756: DELETE icx_cat_items_b
757: WHERE rowid = xRowIds(i);
758: COMMIT;
759: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
760: 'Processed records: ' || xRowCount);

Line 3322: FROM icx_cat_items_b i

3318: END IF;
3319:
3320: SELECT rt_item_id
3321: INTO p_rt_item_id
3322: FROM icx_cat_items_b i
3323: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3324: org_id = p_org_id)
3325: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3326: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =

Line 3352: '] exists in ICX_CAT_ITEMS_B with RT_ITEM_ID: ' || p_rt_item_id);

3348: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3349: ', INTERNAL_ITEM_NUM: ' || p_internal_item_num ||
3350: ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
3351: ', INTERNAL_FLAG: ' || p_internal_flag ||
3352: '] exists in ICX_CAT_ITEMS_B with RT_ITEM_ID: ' || p_rt_item_id);
3353:
3354: xErrLoc:= 200;
3355: RETURN TRUE;
3356: EXCEPTION

Line 3368: '] does not exist in ICX_CAT_ITEMS_B');

3364: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3365: ', INTERNAL_ITEM_NUM: ' || p_internal_item_num ||
3366: ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
3367: ', INTERNAL_FLAG: ' || p_internal_flag ||
3368: '] does not exist in ICX_CAT_ITEMS_B');
3369: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3370: 'ItemsB[ORG_ID: ' || p_org_id ||
3371: ', SUPPLIER_ID: ' || p_supplier_id ||
3372: ', SUPPLIER: ' || p_supplier ||

Line 3378: '] does not exist in ICX_CAT_ITEMS_B');

3374: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3375: ', INTERNAL_ITEM_NUM: ' || p_internal_item_num ||
3376: ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
3377: ', INTERNAL_FLAG: ' || p_internal_flag ||
3378: '] does not exist in ICX_CAT_ITEMS_B');
3379: RETURN FALSE;
3380: WHEN OTHERS THEN
3381: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.existItemsB-'||
3382: xErrLoc||' '||SQLERRM);

Line 3406: FROM icx_cat_items_b i

3402: END IF;
3403:
3404: SELECT 0
3405: INTO xResult
3406: FROM icx_cat_items_b i
3407: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3408: org_id = p_org_id)
3409: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3410: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =

Line 3428: '] exists in ICX_CAT_ITEMS_B');

3424: ', SUPPLIER_ID: ' || p_supplier_id ||
3425: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3426: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3427: ', INTERNAL_FLAG: ' || p_internal_flag ||
3428: '] exists in ICX_CAT_ITEMS_B');
3429: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3430: 'ItemsB[ORG_ID: ' || p_org_id ||
3431: ', SUPPLIER_ID: ' || p_supplier_id ||
3432: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||

Line 3435: '] exists in ICX_CAT_ITEMS_B');

3431: ', SUPPLIER_ID: ' || p_supplier_id ||
3432: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3433: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3434: ', INTERNAL_FLAG: ' || p_internal_flag ||
3435: '] exists in ICX_CAT_ITEMS_B');
3436:
3437: xErrLoc:= 200;
3438: RETURN FALSE;
3439: EXCEPTION

Line 3448: '] does not exist in ICX_CAT_ITEMS_B');

3444: ', SUPPLIER_ID: ' || p_supplier_id ||
3445: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3446: ', INTERNAL_ITEM_ID: ' || p_internal_item_id ||
3447: ', INTERNAL_FLAG: ' || p_internal_flag ||
3448: '] does not exist in ICX_CAT_ITEMS_B');
3449: RETURN TRUE;
3450: WHEN OTHERS THEN
3451: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.notExistItemsB-'||
3452: xErrLoc||' '||SQLERRM);