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_DELETE_CATALOG dependencies on ICX_CAT_PRICE_HISTORY

Line 292: ** Desc : Deletes the data from ICX_CAT_PRICE_HISTORY

288: END delete_supplier_catalog_opUnit;
289:
290: /**
291: ** Proc : delPriceHistory
292: ** Desc : Deletes the data from ICX_CAT_PRICE_HISTORY
293: **/
294: PROCEDURE delPriceHistory(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
295: IS
296: xErrLoc PLS_INTEGER := 0;

Line 300: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_HISTORY');

296: xErrLoc PLS_INTEGER := 0;
297: xContinue BOOLEAN := TRUE;
298:
299: BEGIN
300: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_HISTORY');
301: xErrLoc := 100;
302: WHILE xContinue LOOP
303: FORALL i IN 1..pRtItemIds.COUNT
304: DELETE FROM icx_cat_price_history

Line 304: DELETE FROM icx_cat_price_history

300: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_HISTORY');
301: xErrLoc := 100;
302: WHILE xContinue LOOP
303: FORALL i IN 1..pRtItemIds.COUNT
304: DELETE FROM icx_cat_price_history
305: WHERE rt_item_id = pRtItemIds(i)
306: AND rownum <= gCommitSize ;
307:
308: xErrLoc := 200;