APPS.ICX_POR_EXT_PURGE dependencies on ICX_CAT_CATEGORIES_TL

Line 10: key ICX_CAT_CATEGORIES_TL.KEY%TYPE,

6: --------------------------------------------------------------
7:
8: TYPE tClassification IS RECORD (
9: rt_category_id NUMBER,
10: key ICX_CAT_CATEGORIES_TL.KEY%TYPE,
11: type NUMBER);
12:
13: TYPE tClassCursorType IS REF CURSOR;
14:

Line 185: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORIES_TL');

181: END LOOP;
182:
183: xErrLoc := 500;
184: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
185: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORIES_TL');
186: END IF;
187: FORALL i IN 1..gRtCategoryIds.COUNT
188: DELETE FROM icx_cat_categories_tl
189: WHERE rt_category_id = gRtCategoryIds(i);

Line 188: DELETE FROM icx_cat_categories_tl

184: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
185: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORIES_TL');
186: END IF;
187: FORALL i IN 1..gRtCategoryIds.COUNT
188: DELETE FROM icx_cat_categories_tl
189: WHERE rt_category_id = gRtCategoryIds(i);
190:
191: xErrLoc := 600;
192: ICX_POR_EXT_UTL.extAFCommit;

Line 331: 'FROM icx_cat_categories_tl cat ' ||

327:
328: xErrLoc := 210;
329: xString :=
330: 'SELECT cat.rt_category_id, cat.key, cat.type ' ||
331: 'FROM icx_cat_categories_tl cat ' ||
332: 'WHERE title = ''Oracle'' ' ||
333: 'AND language = ''' || ICX_POR_EXTRACTOR.gBaseLang || ''' ' ||
334: 'AND ((type = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' AND '||
335: ' NOT EXISTS (SELECT ''active template header'' ';

Line 409: FROM icx_cat_categories_tl cat

405: ELSIF (pMode = ALL_MODE) THEN
406: xErrLoc := 300;
407: OPEN pCursor FOR
408: SELECT cat.rt_category_id, cat.key, cat.type
409: FROM icx_cat_categories_tl cat
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,

Line 422: FROM icx_cat_categories_tl cat

418: ELSIF (pMode = CATEGORY_MODE) THEN
419: xErrLoc := 300;
420: OPEN pCursor FOR
421: SELECT cat.rt_category_id, cat.key, cat.type
422: FROM icx_cat_categories_tl cat
423: WHERE cat.title = 'Oracle'
424: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang
425: AND key = to_char(pInvCatId)
426: AND NOT EXISTS (SELECT 'Bulkloaded items'