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_EXT_ITEMS_TLP

Line 820: 'Delete test data from icx_cat_ext_items_tlp');

816: CLOSE cTestRows;
817:
818: xErrLoc:= 700;
819: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
820: 'Delete test data from icx_cat_ext_items_tlp');
821: xErrLoc:= 720;
822: xRowCount := 0;
823: OPEN cTestRows FOR
824: SELECT ROWID FROM icx_cat_ext_items_tlp

Line 824: SELECT ROWID FROM icx_cat_ext_items_tlp

820: 'Delete test data from icx_cat_ext_items_tlp');
821: xErrLoc:= 720;
822: xRowCount := 0;
823: OPEN cTestRows FOR
824: SELECT ROWID FROM icx_cat_ext_items_tlp
825: WHERE last_updated_by = TEST_USER_ID;
826: xErrLoc := 740;
827: LOOP
828: xRowIds.DELETE;

Line 837: DELETE icx_cat_ext_items_tlp

833: EXIT WHEN xRowIds.COUNT = 0;
834: xRowCount := xRowCount + xRowIds.COUNT;
835: xErrLoc := 780;
836: FORALL i IN 1..xRowIds.COUNT
837: DELETE icx_cat_ext_items_tlp
838: WHERE rowid = xRowIds(i);
839: COMMIT;
840: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
841: 'Processed records: ' || xRowCount);

Line 3693: FROM icx_cat_ext_items_tlp

3689: BEGIN
3690: xErrLoc:= 100;
3691: SELECT 0
3692: INTO xResult
3693: FROM icx_cat_ext_items_tlp
3694: WHERE rt_item_id = p_rt_item_id
3695: AND rt_category_id = p_rt_category_id
3696: AND ROWNUM = 1;
3697:

Line 3701: '] exists in ICX_CAT_EXT_ITEMS_TLP');

3697:
3698: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3699: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3700: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3701: '] exists in ICX_CAT_EXT_ITEMS_TLP');
3702:
3703: xErrLoc:= 200;
3704: RETURN TRUE;
3705: EXCEPTION

Line 3711: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

3707: xResult:= 0;
3708: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3709: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3710: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3711: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3712: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3713: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3714: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3715: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

Line 3715: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

3711: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3712: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3713: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3714: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3715: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3716: RETURN FALSE;
3717: WHEN OTHERS THEN
3718: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.existExtItemsTLP-'||
3719: xErrLoc||' '||SQLERRM);

Line 3733: FROM icx_cat_ext_items_tlp

3729: BEGIN
3730: xErrLoc:= 100;
3731: SELECT 0
3732: INTO xResult
3733: FROM icx_cat_ext_items_tlp
3734: WHERE rt_item_id = p_rt_item_id
3735: AND rt_category_id = p_rt_category_id
3736: AND ROWNUM = 1;
3737:

Line 3741: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

3737:
3738: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3739: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3740: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3741: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3742: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3743: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3744: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3745: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

Line 3745: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');

3741: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3742: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3743: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3744: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3745: '] does not exist in ICX_CAT_EXT_ITEMS_TLP');
3746:
3747: xErrLoc:= 200;
3748: RETURN FALSE;
3749: EXCEPTION

Line 3755: '] exists in ICX_CAT_EXT_ITEMS_TLP');

3751: xResult:= 0;
3752: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3753: 'ExtItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3754: ', RT_CATEGORY_ID: ' || p_rt_category_id ||
3755: '] exists in ICX_CAT_EXT_ITEMS_TLP');
3756: RETURN TRUE;
3757: WHEN OTHERS THEN
3758: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.notExistExtItemsTLP-'||
3759: xErrLoc||' '||SQLERRM);