eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_015 dependencies on FND_STATS

Line 187: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

183: WHERE interface_run_id = p_interface_run_id
184: AND status IN ('1','4'));
185:
186: -- Gather statistics of the table
187: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
188: tabname => 'IGS_UC_QUAL_INTS',
189: cascade => TRUE);
190:
191: -- Call category entity import procedure

Line 219: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

215: WHERE interface_run_id = p_interface_run_id
216: AND status IN ('1','4'));
217:
218: -- Gather statistics of the table
219: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
220: tabname => 'IGS_AD_RECRUIT_INT',
221: cascade => TRUE);
222:
223: -- Call category entity import procedure

Line 292: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

288: AND error_code = 'E347'
289: AND status = '4';
290:
291: -- Gather statistics of the table
292: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
293: tabname => 'IGS_AD_TEST_INT',
294: cascade => TRUE);
295:
296: UPDATE igs_ad_test_segs_int

Line 304: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

300: WHERE interface_run_id = p_interface_run_id
301: AND status IN ('1','2','4'));
302:
303: -- Gather statistics of the table
304: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
305: tabname => 'IGS_AD_TEST_SEGS_INT',
306: cascade => TRUE);
307:
308: -- Call category entity import procedure

Line 389: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

385: AND error_code = 'E347'
386: AND status = '4';
387:
388: -- Gather statistics of the table
389: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
390: tabname => 'IGS_AD_TXCPT_INT',
391: cascade => TRUE);
392:
393: -- Call category entity import procedure

Line 431: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

427: AND error_code = 'E347'
428: AND status = '4';
429:
430: -- Gather statistics of the table
431: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
432: tabname => 'IGS_AD_APL_INT',
433: cascade => TRUE);
434:
435: UPDATE igs_ad_ps_appl_inst_int a

Line 454: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

450: AND error_code = 'E347'
451: AND status = '4';
452:
453: -- Gather statistics of the table
454: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
455: tabname => 'IGS_AD_PS_APPL_INST_INT',
456: cascade => TRUE);
457:
458: -- ONLY required to identify presence of history records for which application/instance is being updated

Line 521: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

517: WHERE interface_run_id = p_interface_run_id
518: AND status IN ('1','4'));
519:
520: -- Gather statistics of the table
521: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
522: tabname => 'IGS_AD_APPHIST_INT',
523: cascade => TRUE);
524:
525: UPDATE igs_ad_insthist_int a

Line 537: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

533: WHERE interface_run_id = p_interface_run_id
534: AND status IN ('1','4'));
535:
536: -- Gather statistics of the table
537: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
538: tabname => 'IGS_AD_INSTHIST_INT',
539: cascade => TRUE);
540:
541: -- Call category entity import procedure

Line 574: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

570: WHERE interface_run_id = p_interface_run_id
571: AND status IN ('1','4'));
572:
573: -- Gather statistics of the table
574: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
575: tabname => 'IGS_AD_OTHINST_INT',
576: cascade => TRUE);
577:
578: -- Call category entity import procedure

Line 608: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

604: WHERE interface_run_id = p_interface_run_id
605: AND status IN ('1','4'));
606:
607: -- Gather statistics of the table
608: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
609: tabname => 'IGS_AD_ACADINT_INT',
610: cascade => TRUE);
611:
612: -- Call category entity import procedure

Line 642: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

638: WHERE interface_run_id = p_interface_run_id
639: AND status IN ('1','4'));
640:
641: -- Gather statistics of the table
642: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
643: tabname => 'IGS_AD_APPINT_INT',
644: cascade => TRUE);
645:
646: -- Call category entity import procedure

Line 676: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

672: WHERE interface_run_id = p_interface_run_id
673: AND status IN ('1','4'));
674:
675: -- Gather statistics of the table
676: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
677: tabname => 'IGS_AD_SPLINT_INT',
678: cascade => TRUE);
679:
680: -- Call category entity import procedure

Line 710: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

706: WHERE interface_run_id = p_interface_run_id
707: AND status IN ('1','4'));
708:
709: -- Gather statistics of the table
710: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
711: tabname => 'IGS_AD_SPLTAL_INT',
712: cascade => TRUE);
713:
714: -- Call category entity import procedure

Line 744: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

740: WHERE interface_run_id = p_interface_run_id
741: AND status IN ('1','4'));
742:
743: -- Gather statistics of the table
744: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
745: tabname => 'IGS_AD_PERSTMT_INT',
746: cascade => TRUE);
747:
748: -- Call category entity import procedure

Line 777: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

773: WHERE interface_run_id = p_interface_run_id
774: AND status IN ('1','4'));
775:
776: -- Gather statistics of the table
777: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
778: tabname => 'IGS_AD_FEE_INT',
779: cascade => TRUE);
780:
781: -- Call category entity import procedure

Line 811: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

807: WHERE interface_run_id = p_interface_run_id
808: AND status IN ('1','4'));
809:
810: -- Gather statistics of the table
811: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
812: tabname => 'IGS_AD_NOTES_INT',
813: cascade => TRUE);
814:
815: -- Call category entity import procedure

Line 845: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

841: WHERE interface_run_id = p_interface_run_id
842: AND status IN ('1','4'));
843:
844: -- Gather statistics of the table
845: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
846: tabname => 'IGS_AD_UNITSETS_INT',
847: cascade => TRUE);
848:
849: -- Call category entity import procedure

Line 879: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

875: WHERE interface_run_id = p_interface_run_id
876: AND status IN ('1','4'));
877:
878: -- Gather statistics of the table
879: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
880: tabname => 'IGS_AD_EDUGOAL_INT',
881: cascade => TRUE);
882:
883: -- Call category entity import procedure