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_PE_PERS_IMP_001 dependencies on FND_STATS

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

83:
84: l_enable_log := igs_ad_imp_001.g_enable_log;
85: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
86:
87: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
88: tabname => 'IGS_AD_INTERFACE_ALL',
89: cascade => TRUE);
90:
91: -- The logic in this procedure is :

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

110: ai.interface_id=aapi.interface_id AND
111: ai.status IN ('1','2') AND
112: ai.interface_run_id=l_interface_run_id);
113:
114: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
115: tabname => 'IGS_AD_API_INT_ALL',
116: cascade => TRUE);
117:
118: -- Populating the child interface table with the interface_run_id value.

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

124: WHERE ai.interface_id=adi.interface_id AND
125: ai.status IN ('1','2') AND
126: ai.interface_run_id=l_interface_run_id);
127:
128: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
129: tabname => 'IGS_AD_STAT_INT_ALL',
130: cascade => TRUE);
131:
132: -- Populating the child interface table with the interface_run_id value.

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

140: ai.interface_id=ait.interface_id AND
141: ai.status IN ('1','2') AND
142: ai.interface_run_id=l_interface_run_id);
143:
144: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
145: tabname => 'IGS_AD_ADDR_INT_ALL',
146: cascade => TRUE);
147:
148: -- Populating the child interface table with the interface_run_id value.

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

155: ai.interface_addr_id = ait.interface_addr_id AND
156: ai.status IN ('1','2') AND
157: ai.interface_run_id=l_interface_run_id);
158:
159: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
160: tabname => 'IGS_AD_ADDRUSAGE_INT_ALL',
161: cascade => TRUE);
162:
163: -- Update records with match_ind '22' to status = '1'

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

213: ai.interface_id=pti.interface_id AND
214: ai.status IN ('1','4') AND
215: ai.interface_run_id=l_interface_run_id);
216:
217: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
218: tabname => 'IGS_PE_TYPE_INT',
219: cascade => TRUE);
220:
221: -- Person Types

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

247: ai.status IN ('1','4') AND
248: ai.interface_run_id=l_interface_run_id);
249:
250:
251: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
252: tabname => 'IGS_PE_EIT_INT',
253: cascade => TRUE);
254:
255: -- Populating the child interface table with the interface_run_id value.

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

263: ai.interface_id=adli.interface_id AND
264: ai.status IN ('1','4') AND
265: ai.interface_run_id=l_interface_run_id);
266:
267: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
268: tabname => 'IGS_PE_RACE_INT',
269: cascade => TRUE);
270:
271: UPDATE igs_pe_eit_int

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

316: ai.interface_id=adai.interface_id AND
317: ai.status IN ('1','4') AND
318: ai.interface_run_id=l_interface_run_id);
319:
320: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
321: tabname => 'IGS_AD_ALIAS_INT_ALL',
322: cascade => TRUE);
323:
324: UPDATE IGS_AD_ALIAS_INT_all SET STATUS = '1'

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

356: WHERE ai.interface_id=adi.interface_id AND
357: ai.status IN ('1','4') AND
358: ai.interface_run_id=l_interface_run_id);
359:
360: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
361: tabname => 'IGS_AD_DISABLTY_INT_ALL',
362: cascade => TRUE);
363:
364: -- pupulate the child table with the interface run ID from the package.

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

376: adi.INTERFACE_DISABLTY_ID=snci.INTERFACE_DISABLTY_ID AND
377: ai.status IN ('1','4') AND
378: ai.interface_run_id=l_interface_run_id);
379:
380: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
381: tabname => 'IGS_PE_SN_SRVCE_INT',
382: cascade => TRUE);
383:
384: -- pupulate the child table with the interface run ID from the package.

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

401: ai.status IN ('1','4') AND
402: ai.interface_run_id=l_interface_run_id);
403:
404: -- gather statistics for the table after populating it's interface_run_id
405: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
406: tabname => 'IGS_PE_SN_CONCT_INT',
407: cascade => TRUE);
408: UPDATE igs_pe_sn_conct_int
409: SET status = '1'

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

434: ai.status IN ('1','4') AND
435: ai.interface_run_id=l_interface_run_id);
436:
437: -- gather statistics for the table after populating it's interface_run_id
438: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
439: tabname => 'IGS_AD_EMP_INT_ALL',
440: cascade => TRUE);
441:
442: UPDATE IGS_AD_EMP_INT_all SET STATUS = '1'

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

466: ai.status IN ('1','4') AND
467: ai.interface_run_id=l_interface_run_id);
468:
469: -- gather statistics for the table after populating it's interface_run_id
470: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
471: tabname => 'IGS_PE_VISA_INT',
472: cascade => TRUE);
473:
474: UPDATE IGS_PE_VISA_INT SET STATUS = '1'

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

487: ai.status IN ('1','4') AND
488: ai.interface_run_id=l_interface_run_id);
489:
490: -- gather statistics for the table after populating it's interface_run_id
491: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
492: tabname => 'IGS_PE_PASSPORT_INT',
493: cascade => TRUE);
494: UPDATE IGS_PE_PASSPORT_INT SET STATUS = '1'
495: WHERE MATCH_IND = '22' AND STATUS = '2'

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

509: ai.status IN ('1','4') AND
510: ai.interface_run_id=l_interface_run_id);
511:
512: -- gather statistics for the table after populating it's interface_run_id
513: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
514: tabname => 'IGS_PE_VST_HIST_INT',
515: cascade => TRUE);
516:
517: UPDATE IGS_PE_VST_HIST_INT SET STATUS = '1'

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

531: ai.status IN ('1','4') AND
532: ai.interface_run_id=l_interface_run_id);
533:
534: -- gather statistics for the table after populating it's interface_run_id
535: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
536: tabname => 'IGS_PE_EIT_INT',
537: cascade => TRUE);
538: UPDATE IGS_PE_EIT_INT SET STATUS = '1'
539: WHERE MATCH_IND = '22' AND STATUS = '2'

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

551: ai.status IN ('1','4') AND
552: ai.interface_run_id=l_interface_run_id);
553:
554: -- gather statistics for the table after populating it's interface_run_id
555: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
556: tabname => 'IGS_PE_CITIZEN_INT',
557: cascade => TRUE);
558:
559: UPDATE igs_pe_citizen_int SET status = '1'

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

571: ai.status IN ('1','4') AND
572: ai.interface_run_id=l_interface_run_id);
573:
574: -- gather statistics for the table after populating it's interface_run_id
575: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
576: tabname => 'IGS_PE_FUND_SRC_INT',
577: cascade => TRUE);
578: UPDATE igs_pe_fund_src_int SET status = '1'
579: WHERE match_ind = '22' AND status = '2'

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

601: ai.status IN ('1','4') AND
602: ai.interface_run_id=l_interface_run_id);
603:
604: -- gather statistics for the table after populating it's interface_run_id
605: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
606: tabname => 'IGS_PE_IMMU_DTL_INT',
607: cascade => TRUE);
608:
609:

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

625: ai.status IN ('1','4') AND
626: ai.interface_run_id=l_interface_run_id);
627:
628: -- gather statistics for the table after populating it's interface_run_id
629: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
630: tabname => 'IGS_AD_HLTH_INS_INT_ALL',
631: cascade => TRUE);
632:
633: UPDATE IGS_AD_HLTH_INS_INT_all SET STATUS = '1'

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

656: ai.status IN ('1','4') AND
657: ai.interface_run_id=l_interface_run_id);
658:
659: -- gather statistics for the table after populating it's interface_run_id
660: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
661: tabname => 'IGS_AD_MILITARY_INT_ALL',
662: cascade => TRUE);
663:
664: UPDATE IGS_AD_MILITARY_INT_all SET STATUS = '1'

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

690: ai.status IN ('1','4') AND
691: ai.interface_run_id=l_interface_run_id);
692:
693: -- gather statistics for the table after populating it's interface_run_id
694: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
695: tabname => 'IGS_AD_EXCURR_INT_ALL',
696: cascade => TRUE);
697:
698: UPDATE IGS_AD_EXCURR_INT_all SET STATUS = '1'

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

720: ai.status IN ('1','4') AND
721: ai.interface_run_id=l_interface_run_id);
722:
723: -- gather statistics for the table after populating it's interface_run_id
724: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
725: tabname => 'IGS_AD_RELATIONS_INT_ALL',
726: cascade => TRUE);
727: UPDATE IGS_AD_RELATIONS_INT_all iar
728: SET STATUS = '1'

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

743: ai.status IN ('1','4') AND
744: ai.interface_run_id=l_interface_run_id);
745:
746: -- gather statistics for the table after populating it's interface_run_id
747: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
748: tabname => 'IGS_AD_RELADDR_INT_ALL',
749: cascade => TRUE);
750: UPDATE IGS_AD_RELADDR_INT_all iara
751: SET STATUS = '1'

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

766: ai.status IN ('1','4') AND
767: ai.interface_run_id=l_interface_run_id);
768:
769: -- gather statistics for the table after populating it's interface_run_id
770: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
771: tabname => 'IGS_AD_RELEMP_INT_ALL',
772: cascade => TRUE);
773: UPDATE IGS_AD_RELEMP_INT_all ire
774: SET STATUS = '1'

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

791: ai.status IN ('1','4') AND
792: ai.interface_run_id=l_interface_run_id);
793:
794: -- gather statistics for the table after populating it's interface_run_id
795: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
796: tabname => 'IGS_AD_RELACAD_INT_ALL',
797: cascade => TRUE);
798: UPDATE IGS_AD_RELACAD_INT_ALL iara
799: SET STATUS = '1'

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

816: ai.interface_id=adi.interface_id AND
817: ai.status IN ('1','4') AND
818: ai.interface_run_id=l_interface_run_id);
819: -- gather statistics for the table after populating it's interface_run_id
820: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
821: tabname => 'IGS_AD_REL_CON_INT_ALL',
822: cascade => TRUE);
823: UPDATE IGS_AD_REL_CON_INT_all iarc
824: SET STATUS = '1'

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

850: ai.status IN ('1','4') AND
851: ai.interface_run_id=l_interface_run_id);
852:
853: -- gather statistics for the table after populating it's interface_run_id
854: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
855: tabname => 'IGS_PE_ATH_DTL_INT',
856: cascade => TRUE);
857:
858: UPDATE igs_pe_ath_dtl_int

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

872: ai.status IN ('1','4') AND
873: ai.interface_run_id=l_interface_run_id);
874:
875: -- gather statistics for the table after populating it's interface_run_id
876: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
877: tabname => 'IGS_PE_ATH_PRG_INT',
878: cascade => TRUE);
879: UPDATE igs_pe_ath_prg_int
880: SET status = '1'

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

903: ai.status IN ('1','4') AND
904: ai.interface_run_id=l_interface_run_id);
905:
906: -- gather statistics for the table after populating it's interface_run_id
907: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
908: tabname => 'IGS_AD_LANGUAGE_INT_ALL',
909: cascade => TRUE);
910: UPDATE IGS_AD_LANGUAGE_INT_all il
911: SET STATUS = '1'

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

936: ai.status IN ('1','4') AND
937: ai.interface_run_id=l_interface_run_id);
938:
939: -- gather statistics for the table after populating it's interface_run_id
940: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
941: tabname => 'IGS_AD_CONTACTS_INT_ALL',
942: cascade => TRUE);
943: UPDATE IGS_AD_CONTACTS_INT_all ic
944: SET STATUS = '1'

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

968: ai.interface_id=pfi.interface_id AND
969: ai.status IN ('1','4') AND
970: ai.interface_run_id=l_interface_run_id);
971: -- gather statistics for the table after populating it's interface_run_id
972: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
973: tabname => 'IGS_PE_FLNY_DTL_INT',
974: cascade => TRUE);
975: UPDATE igs_pe_flny_dtl_int
976: SET status = '1'

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

987: ai.interface_id=phi.interface_id AND
988: ai.status IN ('1','4') AND
989: ai.interface_run_id=l_interface_run_id);
990: -- gather statistics for the table after populating it's interface_run_id
991: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
992: tabname => 'IGS_PE_HEAR_DTL_INT',
993: cascade => TRUE);
994: UPDATE igs_pe_hear_dtl_int
995: SET status = '1'

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

1019: ai.status IN ('1','4') AND
1020: ai.interface_run_id=l_interface_run_id);
1021:
1022: -- gather statistics for the table after populating it's interface_run_id
1023: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1024: tabname => 'IGS_PE_HOUSING_INT',
1025: cascade => TRUE);
1026: UPDATE igs_pe_housing_int
1027: SET status = '1'

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

1052: ai.status IN ('1','4') AND
1053: ai.interface_run_id=l_interface_run_id);
1054:
1055: -- gather statistics for the table after populating it's interface_run_id
1056: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1057: tabname => 'IGS_AD_ACADHONOR_INT_ALL',
1058: cascade => TRUE);
1059: UPDATE IGS_AD_ACADHONOR_INT_all iah
1060: SET STATUS = '1'

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

1086: ai.status IN ('1','4') AND
1087: ai.interface_run_id=l_interface_run_id);
1088:
1089: -- gather statistics for the table after populating it's interface_run_id
1090: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1091: tabname => 'IGS_PE_RES_DTLS_INT',
1092: cascade => TRUE);
1093: UPDATE igs_pe_res_dtls_int iah
1094: SET STATUS = '1'

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

1119: AND interface_id = a.interface_id
1120: AND status IN ('1','4'));
1121:
1122: -- Gather statistics of the table
1123: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1124: tabname => 'IGS_PE_CRED_INT',
1125: cascade => TRUE);
1126:
1127: -- Call category entity import procedure

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

1152: AND interface_id = a.interface_id
1153: AND status IN ('1','4'));
1154:
1155: -- Gather statistics of the table
1156: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1157: tabname => 'IGS_AD_ACADHIS_INT_ALL',
1158: cascade => TRUE);
1159:
1160: -- Call category entity import procedure

Line 1185: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'igs_pe_privacy_int',cascade => TRUE);

1181: AND interface_id = a.interface_id
1182: AND status IN ('1','4'));
1183:
1184: -- Gather statistics of the table
1185: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'igs_pe_privacy_int',cascade => TRUE);
1186:
1187: UPDATE igs_pe_privacy_int iah
1188: SET STATUS = '1'
1189: WHERE MATCH_IND = '22' AND STATUS = '2'