eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_ITEMS_B

Line 142: FROM icx_cat_items_b

138: --item_cursor CursorType;
139:
140: CURSOR item_cursor(c_catalog_name IN VARCHAR2) IS
141: SELECT rt_item_id
142: FROM icx_cat_items_b
143: WHERE catalog_name = c_catalog_name
144: AND extractor_updated_flag = 'N';
145:
146: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;

Line 223: FROM icx_cat_items_b

219:
220: CURSOR item_cursor(c_supplier IN VARCHAR2,
221: c_operating_unit_id IN NUMBER) IS
222: SELECT rt_item_id
223: FROM icx_cat_items_b
224: WHERE supplier = c_supplier
225: AND org_id = c_operating_unit_id
226: AND extractor_updated_flag = 'N';
227:

Line 581: ** Desc : Deletes the data from ICX_CAT_ITEMS_B

577: END delItemPrices;
578:
579: /**
580: ** Proc : delItemsB
581: ** Desc : Deletes the data from ICX_CAT_ITEMS_B
582: **/
583: PROCEDURE delItemsB(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
584: IS
585: xErrLoc PLS_INTEGER := 0;

Line 589: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_B');

585: xErrLoc PLS_INTEGER := 0;
586: xContinue BOOLEAN := TRUE;
587:
588: BEGIN
589: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_B');
590: xErrLoc := 100;
591: WHILE xContinue LOOP
592: FORALL i IN 1..pRtItemIds.COUNT
593: DELETE FROM icx_cat_items_b

Line 593: DELETE FROM icx_cat_items_b

589: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_B');
590: xErrLoc := 100;
591: WHILE xContinue LOOP
592: FORALL i IN 1..pRtItemIds.COUNT
593: DELETE FROM icx_cat_items_b
594: WHERE rt_item_id = pRtItemIds(i)
595: AND rownum <= gCommitSize;
596:
597: xErrLoc := 200;

Line 636: -- Based on pDeleteOrder, we have to delete ICX_CAT_ITEMS_B

632: delItemsCtxTLP(pRtItemIds);
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

Line 638: -- The reason: if pRtItemIds is seleced based on ICX_CAT_ITEMS_B,

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.
642: IF (pDeleteOrder = ITEM_TABLE_LAST) THEN

Line 639: -- we have to delete ICX_CAT_ITEMS_B last, otherwise if exception

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.
642: IF (pDeleteOrder = ITEM_TABLE_LAST) THEN
643: xErrLoc := 200;