APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_ITEMS_CTX_TLP

Line 400: ** Desc : Deletes the data from ICX_CAT_ITEMS_CTX_TLP

396: END delExtItemsTLP;
397:
398: /**
399: ** Proc : delItemsCtxTLP
400: ** Desc : Deletes the data from ICX_CAT_ITEMS_CTX_TLP
401: **/
402: PROCEDURE delItemsCtxTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
403: IS
404: xErrLoc PLS_INTEGER := 0;

Line 408: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_CTX_TLP');

404: xErrLoc PLS_INTEGER := 0;
405: xContinue BOOLEAN := TRUE;
406:
407: BEGIN
408: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_CTX_TLP');
409: xErrLoc := 100;
410: WHILE xContinue LOOP
411: FORALL i IN 1..pRtItemIds.COUNT
412: DELETE FROM icx_cat_items_ctx_tlp

Line 412: DELETE FROM icx_cat_items_ctx_tlp

408: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_CTX_TLP');
409: xErrLoc := 100;
410: WHILE xContinue LOOP
411: FORALL i IN 1..pRtItemIds.COUNT
412: DELETE FROM icx_cat_items_ctx_tlp
413: WHERE rt_item_id = pRtItemIds(i)
414: AND rownum <= gCommitSize ;
415:
416: xErrLoc := 200;