APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_EXT_ITEMS_TLP

Line 364: ** Desc : Deletes the data from ICX_CAT_EXT_ITEMS_TLP

360: END delItemsTLP;
361:
362: /**
363: ** Proc : delExtItemsTLP
364: ** Desc : Deletes the data from ICX_CAT_EXT_ITEMS_TLP
365: **/
366: PROCEDURE delExtItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
367: IS
368: xErrLoc PLS_INTEGER := 0;

Line 372: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_EXT_ITEMS_TLP');

368: xErrLoc PLS_INTEGER := 0;
369: xContinue BOOLEAN := TRUE;
370:
371: BEGIN
372: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_EXT_ITEMS_TLP');
373: xErrLoc := 100;
374: WHILE xContinue LOOP
375: FORALL i IN 1..pRtItemIds.COUNT
376: DELETE FROM icx_cat_ext_items_tlp

Line 376: DELETE FROM icx_cat_ext_items_tlp

372: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_EXT_ITEMS_TLP');
373: xErrLoc := 100;
374: WHILE xContinue LOOP
375: FORALL i IN 1..pRtItemIds.COUNT
376: DELETE FROM icx_cat_ext_items_tlp
377: WHERE rt_item_id = pRtItemIds(i)
378: AND rownum <= gCommitSize ;
379:
380: xErrLoc := 200;