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_ITEM_PRICES

Line 847: 'Delete test data from icx_cat_item_prices');

843: CLOSE cTestRows;
844:
845: xErrLoc:= 800;
846: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
847: 'Delete test data from icx_cat_item_prices');
848: xErrLoc:= 820;
849: xRowCount := 0;
850: OPEN cTestRows FOR
851: SELECT ROWID FROM icx_cat_item_prices

Line 851: SELECT ROWID FROM icx_cat_item_prices

847: 'Delete test data from icx_cat_item_prices');
848: xErrLoc:= 820;
849: xRowCount := 0;
850: OPEN cTestRows FOR
851: SELECT ROWID FROM icx_cat_item_prices
852: WHERE last_updated_by = TEST_USER_ID;
853: xErrLoc := 840;
854: LOOP
855: xRowIds.DELETE;

Line 864: DELETE icx_cat_item_prices

860: EXIT WHEN xRowIds.COUNT = 0;
861: xRowCount := xRowCount + xRowIds.COUNT;
862: xErrLoc := 880;
863: FORALL i IN 1..xRowIds.COUNT
864: DELETE icx_cat_item_prices
865: WHERE rowid = xRowIds(i);
866: COMMIT;
867: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
868: 'Processed records: ' || xRowCount);

Line 3339: FROM icx_cat_item_prices p

3335: AND (internal_item_num IS NULL AND p_internal_item_num IS NULL OR
3336: internal_item_num = p_internal_item_num)
3337: AND extractor_updated_flag = p_extractor_updated_flag
3338: AND EXISTS (SELECT NULL
3339: FROM icx_cat_item_prices p
3340: WHERE p.rt_item_id = i.rt_item_id
3341: AND p.search_type = xSearchType);
3342:
3343: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 3418: FROM icx_cat_item_prices p

3414: supplier_part_num = p_supplier_part_num)
3415: AND (internal_item_id IS NULL AND p_internal_item_id IS NULL OR
3416: internal_item_id = p_internal_item_id)
3417: AND EXISTS (SELECT NULL
3418: FROM icx_cat_item_prices p
3419: WHERE p.rt_item_id = i.rt_item_id
3420: AND p.search_type = xSearchType);
3421:
3422: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 3793: FROM icx_cat_item_prices

3789: BEGIN
3790: xErrLoc:= 100;
3791: SELECT local_rt_item_id
3792: INTO xRtItemId
3793: FROM icx_cat_item_prices
3794: WHERE rt_item_id = p_rt_item_id
3795: AND org_id = p_org_id
3796: AND price_type = p_price_type
3797: AND active_flag = p_active_flag

Line 3854: '] exists in ICX_CAT_ITEM_PRICES');

3850: ', SUPPLIER_SITE_CODE: ' || p_supplier_site_code ||
3851: ', CONTRACT_NUM: ' || p_contract_num ||
3852: ', CONTRACT_LINE_NUM: ' || p_contract_line_num ||
3853: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
3854: '] exists in ICX_CAT_ITEM_PRICES');
3855:
3856: xErrLoc:= 200;
3857: RETURN TRUE;
3858: ELSE

Line 3880: '] does not exist in ICX_CAT_ITEM_PRICES');

3876: ', SUPPLIER_SITE_CODE: ' || p_supplier_site_code ||
3877: ', CONTRACT_NUM: ' || p_contract_num ||
3878: ', CONTRACT_LINE_NUM: ' || p_contract_line_num ||
3879: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
3880: '] does not exist in ICX_CAT_ITEM_PRICES');
3881: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3882: 'ItemPrices[RT_ITEM_ID: ' || p_rt_item_id ||
3883: ', ORG_ID: ' || p_org_id ||
3884: ', PRICE_TYPE: ' || p_price_type ||

Line 3902: '] does not exist in ICX_CAT_ITEM_PRICES');

3898: ', SUPPLIER_SITE_CODE: ' || p_supplier_site_code ||
3899: ', CONTRACT_NUM: ' || p_contract_num ||
3900: ', CONTRACT_LINE_NUM: ' || p_contract_line_num ||
3901: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
3902: '] does not exist in ICX_CAT_ITEM_PRICES');
3903: RETURN FALSE;
3904: END IF;
3905: EXCEPTION
3906: WHEN OTHERS THEN

Line 3930: FROM icx_cat_item_prices

3926: BEGIN
3927: xErrLoc:= 100;
3928: SELECT 0
3929: INTO xResult
3930: FROM icx_cat_item_prices
3931: WHERE rt_item_id = p_rt_item_id
3932: AND org_id = p_org_id
3933: AND price_type = p_price_type
3934: AND active_flag = p_active_flag

Line 3953: '] exists in ICX_CAT_ITEM_PRICES');

3949: ', CONTRACT_LINE_ID: ' || p_contract_line_id ||
3950: ', TEMPLATE_ID: ' || p_template_id ||
3951: ', TEMPLATE_LINE_ID: ' || p_template_line_id ||
3952: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
3953: '] exists in ICX_CAT_ITEM_PRICES');
3954: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3955: 'ItemPrices[RT_ITEM_ID: ' || p_rt_item_id ||
3956: ', ORG_ID: ' || p_org_id ||
3957: ', PRICE_TYPE: ' || p_price_type ||

Line 3965: '] exists in ICX_CAT_ITEM_PRICES');

3961: ', CONTRACT_LINE_ID: ' || p_contract_line_id ||
3962: ', TEMPLATE_ID: ' || p_template_id ||
3963: ', TEMPLATE_LINE_ID: ' || p_template_line_id ||
3964: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
3965: '] exists in ICX_CAT_ITEM_PRICES');
3966:
3967: xErrLoc:= 200;
3968: RETURN FALSE;
3969: EXCEPTION

Line 3983: '] does not exist in ICX_CAT_ITEM_PRICES');

3979: ', CONTRACT_LINE_ID: ' || p_contract_line_id ||
3980: ', TEMPLATE_ID: ' || p_template_id ||
3981: ', TEMPLATE_LINE_ID: ' || p_template_line_id ||
3982: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
3983: '] does not exist in ICX_CAT_ITEM_PRICES');
3984: RETURN TRUE;
3985: WHEN OTHERS THEN
3986: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.notExistItemPrices-'||
3987: xErrLoc||' '||SQLERRM);

Line 4015: FROM icx_cat_item_prices

4011: BEGIN
4012: xErrLoc:= 100;
4013: SELECT local_rt_item_id
4014: INTO xRtItemId
4015: FROM icx_cat_item_prices
4016: WHERE rt_item_id = p_rt_item_id
4017: AND org_id = p_org_id
4018: AND price_type = p_price_type
4019: AND active_flag = p_active_flag

Line 4049: '] exists in ICX_CAT_ITEM_PRICES');

4045: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
4046: ', MTL_CATEGORY_ID: ' || p_mtl_category_id ||
4047: ', SUGGESTED_QUANTITY: ' || p_suggested_quantity ||
4048: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
4049: '] exists in ICX_CAT_ITEM_PRICES');
4050:
4051: xErrLoc:= 200;
4052: RETURN TRUE;
4053: ELSE

Line 4065: '] does not exist in ICX_CAT_ITEM_PRICES');

4061: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
4062: ', MTL_CATEGORY_ID: ' || p_mtl_category_id ||
4063: ', SUGGESTED_QUANTITY: ' || p_suggested_quantity ||
4064: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
4065: '] does not exist in ICX_CAT_ITEM_PRICES');
4066: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
4067: 'ItemPrices[RT_ITEM_ID: ' || p_rt_item_id ||
4068: ', ORG_ID: ' || p_org_id ||
4069: ', PRICE_TYPE: ' || p_price_type ||

Line 4077: '] does not exist in ICX_CAT_ITEM_PRICES');

4073: ', INVENTORY_ITEM_ID: ' || p_inventory_item_id ||
4074: ', MTL_CATEGORY_ID: ' || p_mtl_category_id ||
4075: ', SUGGESTED_QUANTITY: ' || p_suggested_quantity ||
4076: ', LOCAL_RT_ITEM_ID: ' || p_local_rt_item_id ||
4077: '] does not exist in ICX_CAT_ITEM_PRICES');
4078: RETURN FALSE;
4079: END IF;
4080: EXCEPTION
4081: WHEN OTHERS THEN