APPS.ICX_POR_EXT_PURGE dependencies on ICX_POR_EXT_TEST

Line 337: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

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 ||
339: 'FROM ipo_reqexpress_headers_all templ ';
340: ELSE
341: xString := xString ||

Line 351: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

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 ||
353: 'FROM imtl_categories_kfv mck ';
354: ELSE
355: xString := xString ||

Line 361: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

357: END IF;
358:
359: IF (xValidateFlag = 'Y') THEN
360: xErrLoc := 220;
361: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
362: xString := xString ||
363: ', imtl_category_set_valid_cats mcsvc ';
364: ELSE
365: xString := xString ||

Line 386: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

382: 'AND NVL(mck.start_date_active,SYSDATE)<=SYSDATE ' ||
383: 'AND SYSDATE 384: 'AND SYSDATE 385:
386: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
387: xString := xString ||
388: 'AND cat.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID;
389: END IF;
390:

Line 388: 'AND cat.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID;

384: 'AND SYSDATE 385:
386: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
387: xString := xString ||
388: 'AND cat.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID;
389: END IF;
390:
391: xErrLoc := 270;
392: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN

Line 598: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

594: 'FROM icx_cat_items_b i ' ||
595: 'WHERE i.extractor_updated_flag = ''Y'' ' ||
596: 'AND i.internal_item_id is not null ';
597:
598: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
599: xString := xString ||
600: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
601: END IF;
602:

Line 600: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';

596: 'AND i.internal_item_id is not null ';
597:
598: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
599: xString := xString ||
600: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
601: END IF;
602:
603: xString := xString ||
604: 'AND NOT EXISTS (SELECT ''item deleted from item master'' ';

Line 605: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

601: END IF;
602:
603: xString := xString ||
604: 'AND NOT EXISTS (SELECT ''item deleted from item master'' ';
605: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
606: xString := xString ||
607: 'FROM imtl_system_items_kfv m, '||
608: 'ifinancials_system_params_all fsp ';
609: ELSE

Line 628: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

624: 'icx_cat_item_prices p1 ' ||
625: 'WHERE i.extractor_updated_flag = ''Y'' ' ||
626: 'AND i.internal_item_id is not null ';
627:
628: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
629: xString := xString ||
630: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
631: END IF;
632:

Line 630: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';

626: 'AND i.internal_item_id is not null ';
627:
628: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
629: xString := xString ||
630: 'AND i.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
631: END IF;
632:
633: xString := xString ||
634: -- Check for invalid item category association

Line 638: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

634: -- Check for invalid item category association
635: 'AND i.rt_item_id = p1.rt_item_id ' ||
636: 'AND NOT((p1.contract_line_id <> -2) OR (p1.template_line_id <> -2)) ' ||
637: 'AND NOT EXISTS (SELECT ''Invalid item category association'' ';
638: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
639: xString := xString ||
640: 'FROM imtl_item_categories m, '||
641: 'ifinancials_system_params_all fsp, ';
642: ELSE