APPS.ICX_POR_EXT_PURGE dependencies on ICX_POR_EXTRACTOR

Line 333: 'AND language = ''' || ICX_POR_EXTRACTOR.gBaseLang || ''' ' ||

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

Line 411: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang

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,
414: icx_cat_category_items ci
415: WHERE ci.rt_category_id = cat.rt_category_id

Line 424: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang

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'
427: FROM icx_cat_items_b i,
428: icx_cat_category_items ci