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_LISTS

Line 508: ** Desc : Deletes the data from ICX_CAT_PRICE_LISTS

504: END delCategoryItems;
505:
506: /**
507: ** Proc : delPriceLists
508: ** Desc : Deletes the data from ICX_CAT_PRICE_LISTS
509: **/
510: PROCEDURE delPriceLists(pPriceListIds IN DBMS_SQL.NUMBER_TABLE)
511: IS
512: xErrLoc PLS_INTEGER := 0;

Line 514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');

510: PROCEDURE delPriceLists(pPriceListIds IN DBMS_SQL.NUMBER_TABLE)
511: IS
512: xErrLoc PLS_INTEGER := 0;
513: BEGIN
514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');
515: xErrLoc := 100;
516: FORALL i IN 1..pPriceListIds.COUNT
517: DELETE FROM icx_cat_price_lists pl
518: WHERE pl.price_list_id = pPriceListIds(i)

Line 517: DELETE FROM icx_cat_price_lists pl

513: BEGIN
514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');
515: xErrLoc := 100;
516: FORALL i IN 1..pPriceListIds.COUNT
517: DELETE FROM icx_cat_price_lists pl
518: WHERE pl.price_list_id = pPriceListIds(i)
519: AND NOT EXISTS (SELECT 'price line'
520: FROM icx_cat_item_prices p
521: WHERE p.price_list_id = pl.price_list_id);