APPS.ICX_POR_DELETE_CATALOG dependencies on POR_FAVORITE_LIST_LINES

Line 436: ** Desc : Deletes the data from POR_FAVORITE_LIST_LINES

432: END delItemsCtxTLP;
433:
434: /**
435: ** Proc : delFavoriteList
436: ** Desc : Deletes the data from POR_FAVORITE_LIST_LINES
437: **/
438: PROCEDURE delFavoriteList(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
439: IS
440: xErrLoc PLS_INTEGER := 0;

Line 444: ICX_POR_EXT_UTL.debug('Delete from POR_FAVORITE_LIST_LINES');

440: xErrLoc PLS_INTEGER := 0;
441: xContinue BOOLEAN := TRUE;
442:
443: BEGIN
444: ICX_POR_EXT_UTL.debug('Delete from POR_FAVORITE_LIST_LINES');
445: xErrLoc := 100;
446: WHILE xContinue LOOP
447: FORALL i IN 1..pRtItemIds.COUNT
448: DELETE FROM por_favorite_list_lines

Line 448: DELETE FROM por_favorite_list_lines

444: ICX_POR_EXT_UTL.debug('Delete from POR_FAVORITE_LIST_LINES');
445: xErrLoc := 100;
446: WHILE xContinue LOOP
447: FORALL i IN 1..pRtItemIds.COUNT
448: DELETE FROM por_favorite_list_lines
449: WHERE rt_item_id = pRtItemIds(i)
450: AND rownum <= gCommitSize ;
451:
452: xErrLoc := 200;