APPS.ICX_POR_EXT_PURGE dependencies on ICX_CAT_CATEGORY_ITEMS

Line 83: FROM icx_cat_category_items

79: PROCEDURE deleteCategories IS
80:
81: CURSOR cCatItems(p_rt_category_id IN NUMBER) IS
82: SELECT rt_item_id
83: FROM icx_cat_category_items
84: WHERE rt_category_id = p_rt_category_id;
85:
86: xRtItemIds DBMS_SQL.NUMBER_TABLE;
87: xErrLoc PLS_INTEGER := 100;

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

160: ELSIF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE) THEN
161:
162: xErrLoc := 450;
163: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
164: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');
165: END IF;
166: FORALL j IN 1..xRtItemIds.COUNT
167: DELETE FROM icx_cat_category_items
168: WHERE rt_item_id = xRtItemIds(j)

Line 167: DELETE FROM icx_cat_category_items

163: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
164: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');
165: END IF;
166: FORALL j IN 1..xRtItemIds.COUNT
167: DELETE FROM icx_cat_category_items
168: WHERE rt_item_id = xRtItemIds(j)
169: AND rt_category_id = gRtCategoryIds(i);
170:
171: END IF;

Line 414: icx_cat_category_items ci

410: WHERE cat.title = 'Oracle'
411: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang
412: AND NOT EXISTS (SELECT 'Bulkloaded items'
413: FROM icx_cat_items_b i,
414: icx_cat_category_items ci
415: WHERE ci.rt_category_id = cat.rt_category_id
416: AND ci.rt_item_id = i.rt_item_id
417: AND NVL(i.extractor_updated_flag, 'N') = 'N');
418: ELSIF (pMode = CATEGORY_MODE) THEN

Line 428: icx_cat_category_items ci

424: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang
425: AND key = to_char(pInvCatId)
426: AND NOT EXISTS (SELECT 'Bulkloaded items'
427: FROM icx_cat_items_b i,
428: icx_cat_category_items ci
429: WHERE ci.rt_category_id = cat.rt_category_id
430: AND ci.rt_item_id = i.rt_item_id
431: AND NVL(i.extractor_updated_flag, 'N') = 'N');
432: