APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_ITEMS_TLP

Line 328: ** Desc : Deletes the data from ICX_CAT_ITEMS_TLP

324: END delPriceHistory;
325:
326: /**
327: ** Proc : delItemsTLP
328: ** Desc : Deletes the data from ICX_CAT_ITEMS_TLP
329: **/
330: PROCEDURE delItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
331: IS
332: xErrLoc PLS_INTEGER := 0;

Line 336: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_TLP');

332: xErrLoc PLS_INTEGER := 0;
333: xContinue BOOLEAN := TRUE;
334:
335: BEGIN
336: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_TLP');
337: xErrLoc := 100;
338: WHILE xContinue LOOP
339: FORALL i IN 1..pRtItemIds.COUNT
340: DELETE FROM icx_cat_items_tlp

Line 340: DELETE FROM icx_cat_items_tlp

336: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_TLP');
337: xErrLoc := 100;
338: WHILE xContinue LOOP
339: FORALL i IN 1..pRtItemIds.COUNT
340: DELETE FROM icx_cat_items_tlp
341: WHERE rt_item_id = pRtItemIds(i)
342: AND rownum <= gCommitSize ;
343:
344: xErrLoc := 200;