APPS.ICX_POR_EXT_PURGE dependencies on ICX_POR_EXT_CLASS

Line 152: IF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.CATEGORY_TYPE) THEN

148: EXIT WHEN xRtItemIds.COUNT = 0;
149:
150: -- For Category, need also delete all assoicated item records
151: -- For Template Header, only delete that category_item association
152: IF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.CATEGORY_TYPE) THEN
153:
154: xErrLoc := 440;
155: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
156: xErrLoc := 445;

Line 160: ELSIF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE) THEN

156: xErrLoc := 445;
157: ICX_POR_DELETE_CATALOG.deleteCommonTables(xRtItemIds,
158: ICX_POR_DELETE_CATALOG.CATITEM_TABLE_LAST);
159:
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');

Line 334: 'AND ((type = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' AND '||

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'' ';
336:
337: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
338: xString := xString ||

Line 348: ' (type = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' AND '||

344:
345: xString := xString ||
346: 'WHERE templ.express_name||''_tmpl'' = cat.key ' ||
347: 'AND (NVL(inactive_date,SYSDATE+1)>SYSDATE))) OR ' ||
348: ' (type = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' AND '||
349: ' NOT EXISTS (SELECT ''active oracle category'' ';
350:
351: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
352: xString := xString ||