APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_CATEGORY_ITEMS

Line 61: FROM icx_cat_category_items

57: --item_cursor CursorType;
58:
59: CURSOR item_cursor(c_rt_category_id IN NUMBER) IS
60: SELECT rt_item_id
61: FROM icx_cat_category_items
62: WHERE rt_category_id = c_rt_category_id;
63:
64: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;
65:

Line 472: ** Desc : Deletes the data from ICX_CAT_CATEGORY_ITEMS

468: END delFavoriteList;
469:
470: /**
471: ** Proc : delCategoryItems
472: ** Desc : Deletes the data from ICX_CAT_CATEGORY_ITEMS
473: **/
474: PROCEDURE delCategoryItems(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
475: IS
476: xErrLoc PLS_INTEGER := 0;

Line 480: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');

476: xErrLoc PLS_INTEGER := 0;
477: xContinue BOOLEAN := TRUE;
478:
479: BEGIN
480: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');
481: xErrLoc := 100;
482: WHILE xContinue LOOP
483: FORALL i IN 1..pRtItemIds.COUNT
484: DELETE FROM icx_cat_category_items

Line 484: DELETE FROM icx_cat_category_items

480: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');
481: xErrLoc := 100;
482: WHILE xContinue LOOP
483: FORALL i IN 1..pRtItemIds.COUNT
484: DELETE FROM icx_cat_category_items
485: WHERE rt_item_id = pRtItemIds(i)
486: AND rownum <= gCommitSize ;
487:
488: xErrLoc := 200;

Line 637: -- before ICX_CAT_CATEGORY_ITEMS, or the other way.

633: xErrLoc := 180;
634: delFavoriteList(pRtItemIds);
635:
636: -- Based on pDeleteOrder, we have to delete ICX_CAT_ITEMS_B
637: -- before ICX_CAT_CATEGORY_ITEMS, or the other way.
638: -- The reason: if pRtItemIds is seleced based on ICX_CAT_ITEMS_B,
639: -- we have to delete ICX_CAT_ITEMS_B last, otherwise if exception
640: -- happens, next time we won't get correct pRtItemIds, which would
641: -- cause data corruption. Same reason for ICX_CAT_CATEGORY_ITEMS.

Line 641: -- cause data corruption. Same reason for ICX_CAT_CATEGORY_ITEMS.

637: -- before ICX_CAT_CATEGORY_ITEMS, or the other way.
638: -- The reason: if pRtItemIds is seleced based on ICX_CAT_ITEMS_B,
639: -- we have to delete ICX_CAT_ITEMS_B last, otherwise if exception
640: -- happens, next time we won't get correct pRtItemIds, which would
641: -- cause data corruption. Same reason for ICX_CAT_CATEGORY_ITEMS.
642: IF (pDeleteOrder = ITEM_TABLE_LAST) THEN
643: xErrLoc := 200;
644: delCategoryItems(pRtItemIds);
645: xErrLoc := 240;