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 IGS_AD_INTERFACE_ALL

Line 88: tabname => 'IGS_AD_INTERFACE_ALL',

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 :
92: -- 1. The interface_run_id is updated in all tables and the statistics are gathered.

Line 99: (SELECT interface_id FROM igs_ad_interface_all

95:
96: -- Delete all the records before processing for duplicate check.
97: DELETE FROM igs_ad_imp_near_mtch_all
98: WHERE interface_id IN
99: (SELECT interface_id FROM igs_ad_interface_all
100: WHERE interface_run_id = l_interface_run_id AND
101: status='2');
102:
103: -- Populating the child interface table with the interface_run_id value.

Line 108: FROM igs_ad_interface_all ai

104: UPDATE igs_ad_api_int_all aapi
105: SET interface_run_id=l_interface_run_id
106: WHERE aapi.status='2' AND
107: EXISTS (SELECT 1
108: FROM igs_ad_interface_all ai
109: WHERE
110: ai.interface_id=aapi.interface_id AND
111: ai.status IN ('1','2') AND
112: ai.interface_run_id=l_interface_run_id);

Line 123: FROM igs_ad_interface_all ai

119: UPDATE igs_ad_stat_int_all adi
120: SET interface_run_id=l_interface_run_id
121: WHERE adi.status='2' AND
122: EXISTS (SELECT 1
123: FROM igs_ad_interface_all ai
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:

Line 138: FROM igs_ad_interface_all ai

134: SET
135: interface_run_id=l_interface_run_id
136: WHERE ait.status='2' AND
137: EXISTS (SELECT 1
138: FROM igs_ad_interface_all ai
139: WHERE
140: ai.interface_id=ait.interface_id AND
141: ai.status IN ('1','2') AND
142: ai.interface_run_id=l_interface_run_id);

Line 165: UPDATE IGS_AD_INTERFACE_all SET STATUS = '1'

161: cascade => TRUE);
162:
163: -- Update records with match_ind '22' to status = '1'
164: -- Person Details
165: UPDATE IGS_AD_INTERFACE_all SET STATUS = '1'
166: WHERE PERSON_MATCH_IND = '22' AND STATUS = '2'
167: AND SOURCE_TYPE_ID = P_SOURCE_TYPE_ID
168: AND BATCH_ID = P_BATCH_ID;
169:

Line 211: FROM igs_ad_interface_all ai

207: UPDATE igs_pe_type_int pti
208: SET interface_run_id=l_interface_run_id
209: WHERE pti.status='2' AND
210: EXISTS (SELECT 1
211: FROM igs_ad_interface_all ai
212: WHERE
213: ai.interface_id=pti.interface_id AND
214: ai.status IN ('1','4') AND
215: ai.interface_run_id=l_interface_run_id);

Line 244: FROM igs_ad_interface_all ai

240: SET
241: interface_run_id=l_interface_run_id
242: WHERE pei.status='2' AND
243: EXISTS (SELECT 1
244: FROM igs_ad_interface_all ai
245: WHERE
246: ai.interface_id=pei.interface_id AND
247: ai.status IN ('1','4') AND
248: ai.interface_run_id=l_interface_run_id);

Line 261: FROM igs_ad_interface_all ai

257: SET
258: interface_run_id=l_interface_run_id
259: WHERE adli.status='2' AND
260: EXISTS (SELECT 1
261: FROM igs_ad_interface_all ai
262: WHERE
263: ai.interface_id=adli.interface_id AND
264: ai.status IN ('1','4') AND
265: ai.interface_run_id=l_interface_run_id);

Line 314: FROM igs_ad_interface_all ai

310: SET
311: interface_run_id=l_interface_run_id
312: WHERE adai.status='2' AND
313: EXISTS (SELECT 1
314: FROM igs_ad_interface_all ai
315: WHERE
316: ai.interface_id=adai.interface_id AND
317: ai.status IN ('1','4') AND
318: ai.interface_run_id=l_interface_run_id);

Line 355: FROM igs_ad_interface_all ai

351: UPDATE igs_ad_disablty_int_all adi
352: SET interface_run_id=l_interface_run_id
353: WHERE adi.status='2' AND
354: EXISTS (SELECT 1
355: FROM igs_ad_interface_all ai
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:

Line 373: FROM igs_ad_interface_all ai,

369: UPDATE igs_pe_sn_srvce_int snci
370: SET interface_run_id=l_interface_run_id
371: WHERE snci.status='2' AND
372: EXISTS (SELECT 1
373: FROM igs_ad_interface_all ai,
374: igs_ad_disablty_int_all adi
375: WHERE ai.interface_id=adi.interface_id AND
376: adi.INTERFACE_DISABLTY_ID=snci.INTERFACE_DISABLTY_ID AND
377: ai.status IN ('1','4') AND

Line 396: FROM igs_ad_interface_all ai,

392: SET
393: interface_run_id=l_interface_run_id
394: WHERE psci.status='2' AND
395: EXISTS (SELECT 1
396: FROM igs_ad_interface_all ai,
397: igs_ad_disablty_int_all adi
398: WHERE
399: ai.interface_id=adi.interface_id AND
400: adi.INTERFACE_DISABLTY_ID=psci.INTERFACE_DISABLTY_ID AND

Line 431: FROM igs_ad_interface_all ai

427: SET
428: interface_run_id=l_interface_run_id
429: WHERE admpi.status='2' AND
430: EXISTS (SELECT 1
431: FROM igs_ad_interface_all ai
432: WHERE
433: ai.interface_id=admpi.interface_id AND
434: ai.status IN ('1','4') AND
435: ai.interface_run_id=l_interface_run_id);

Line 463: FROM igs_ad_interface_all ai

459: SET
460: interface_run_id=l_interface_run_id
461: WHERE pvi.status IN ('1','2') AND
462: EXISTS (SELECT 1
463: FROM igs_ad_interface_all ai
464: WHERE
465: ai.interface_id=pvi.interface_id AND
466: ai.status IN ('1','4') AND
467: ai.interface_run_id=l_interface_run_id);

Line 484: FROM igs_ad_interface_all ai

480: SET
481: interface_run_id=l_interface_run_id
482: WHERE ppi.status='2' AND
483: EXISTS (SELECT 1
484: FROM igs_ad_interface_all ai
485: WHERE
486: ai.interface_id=ppi.interface_id AND
487: ai.status IN ('1','4') AND
488: ai.interface_run_id=l_interface_run_id);

Line 504: FROM igs_ad_interface_all ai,

500: SET
501: interface_run_id=l_interface_run_id
502: WHERE pvhi.status='2' AND
503: EXISTS (SELECT 1
504: FROM igs_ad_interface_all ai,
505: IGS_PE_VISA_INT pi
506: WHERE
507: pi.INTERFACE_VISA_ID=pvhi.INTERFACE_VISA_ID AND
508: ai.interface_id=pi.interface_id AND

Line 528: FROM igs_ad_interface_all ai

524: SET
525: interface_run_id=l_interface_run_id
526: WHERE pei.status='2' AND
527: EXISTS (SELECT 1
528: FROM igs_ad_interface_all ai
529: WHERE
530: ai.interface_id=pei.interface_id AND
531: ai.status IN ('1','4') AND
532: ai.interface_run_id=l_interface_run_id);

Line 548: FROM igs_ad_interface_all ai

544: SET
545: interface_run_id=l_interface_run_id
546: WHERE pci.status='2' AND
547: EXISTS (SELECT 1
548: FROM igs_ad_interface_all ai
549: WHERE
550: ai.interface_id=pci.interface_id AND
551: ai.status IN ('1','4') AND
552: ai.interface_run_id=l_interface_run_id);

Line 568: FROM igs_ad_interface_all ai

564: SET
565: interface_run_id=l_interface_run_id
566: WHERE pfsi.status='2' AND
567: EXISTS (SELECT 1
568: FROM igs_ad_interface_all ai
569: WHERE
570: ai.interface_id=pfsi.interface_id AND
571: ai.status IN ('1','4') AND
572: ai.interface_run_id=l_interface_run_id);

Line 598: FROM igs_ad_interface_all ai

594: SET
595: interface_run_id=l_interface_run_id
596: WHERE pidi.status='2' AND
597: EXISTS (SELECT 1
598: FROM igs_ad_interface_all ai
599: WHERE
600: ai.interface_id=pidi.interface_id AND
601: ai.status IN ('1','4') AND
602: ai.interface_run_id=l_interface_run_id);

Line 622: FROM igs_ad_interface_all ai

618: SET
619: interface_run_id=l_interface_run_id
620: WHERE adhi.status='2' AND
621: EXISTS (SELECT 1
622: FROM igs_ad_interface_all ai
623: WHERE
624: ai.interface_id=adhi.interface_id AND
625: ai.status IN ('1','4') AND
626: ai.interface_run_id=l_interface_run_id);

Line 653: FROM igs_ad_interface_all ai

649: SET
650: interface_run_id=l_interface_run_id
651: WHERE admi.status='2' AND
652: EXISTS (SELECT 1
653: FROM igs_ad_interface_all ai
654: WHERE
655: ai.interface_id=admi.interface_id AND
656: ai.status IN ('1','4') AND
657: ai.interface_run_id=l_interface_run_id);

Line 687: FROM igs_ad_interface_all ai

683: SET
684: interface_run_id=l_interface_run_id
685: WHERE adei.status='2' AND
686: EXISTS (SELECT 1
687: FROM igs_ad_interface_all ai
688: WHERE
689: ai.interface_id=adei.interface_id AND
690: ai.status IN ('1','4') AND
691: ai.interface_run_id=l_interface_run_id);

Line 717: FROM igs_ad_interface_all ai

713: UPDATE IGS_AD_RELATIONS_INT_ALL ari
714: SET interface_run_id=l_interface_run_id
715: WHERE ari.status='2' AND
716: EXISTS (SELECT 1
717: FROM igs_ad_interface_all ai
718: WHERE
719: ai.interface_id=ari.interface_id AND
720: ai.status IN ('1','4') AND
721: ai.interface_run_id=l_interface_run_id);

Line 738: FROM igs_ad_interface_all ai,

734: UPDATE igs_ad_reladdr_int_all ari1
735: SET interface_run_id=l_interface_run_id
736: WHERE ari1.status='2' AND
737: EXISTS (SELECT 1
738: FROM igs_ad_interface_all ai,
739: IGS_AD_RELATIONS_INT_ALL adi
740: WHERE
741: adi.INTERFACE_RELATIONS_ID=ari1.INTERFACE_RELATIONS_ID AND
742: ai.interface_id=adi.interface_id AND

Line 762: FROM igs_ad_interface_all ai,

758: UPDATE igs_ad_relemp_int_all ari2
759: SET interface_run_id=l_interface_run_id
760: WHERE ari2.status='2' AND
761: EXISTS (SELECT 1
762: FROM igs_ad_interface_all ai,
763: IGS_AD_RELATIONS_INT_ALL adi
764: WHERE adi.INTERFACE_RELATIONS_ID=ari2.INTERFACE_RELATIONS_ID AND
765: ai.interface_id=adi.interface_id AND
766: ai.status IN ('1','4') AND

Line 787: FROM igs_ad_interface_all ai,

783: UPDATE Igs_Ad_Relacad_Int_all ari3
784: SET interface_run_id=l_interface_run_id
785: WHERE ari3.status='2' AND
786: EXISTS (SELECT 1
787: FROM igs_ad_interface_all ai,
788: IGS_AD_RELATIONS_INT_ALL adi
789: WHERE adi.INTERFACE_RELATIONS_ID=ari3.INTERFACE_RELATIONS_ID AND
790: ai.interface_id=adi.interface_id AND
791: ai.status IN ('1','4') AND

Line 812: FROM igs_ad_interface_all ai,

808: SET
809: interface_run_id=l_interface_run_id
810: WHERE ari4.status='2' AND
811: EXISTS (SELECT 1
812: FROM igs_ad_interface_all ai,
813: IGS_AD_RELATIONS_INT_ALL adi
814: WHERE
815: adi.INTERFACE_RELATIONS_ID=ari4.INTERFACE_RELATIONS_ID AND
816: ai.interface_id=adi.interface_id AND

Line 847: FROM igs_ad_interface_all ai

843: SET
844: interface_run_id=l_interface_run_id
845: WHERE adli.status='2' AND
846: EXISTS (SELECT 1
847: FROM igs_ad_interface_all ai
848: WHERE
849: ai.interface_id=adli.interface_id AND
850: ai.status IN ('1','4') AND
851: ai.interface_run_id=l_interface_run_id);

Line 869: FROM igs_ad_interface_all ai

865: SET
866: interface_run_id=l_interface_run_id
867: WHERE adli.status='2' AND
868: EXISTS (SELECT 1
869: FROM igs_ad_interface_all ai
870: WHERE
871: ai.interface_id=adli.interface_id AND
872: ai.status IN ('1','4') AND
873: ai.interface_run_id=l_interface_run_id);

Line 900: FROM igs_ad_interface_all ai

896: SET
897: interface_run_id=l_interface_run_id
898: WHERE adli.status='2' AND
899: EXISTS (SELECT 1
900: FROM igs_ad_interface_all ai
901: WHERE
902: ai.interface_id=adli.interface_id AND
903: ai.status IN ('1','4') AND
904: ai.interface_run_id=l_interface_run_id);

Line 933: FROM igs_ad_interface_all ai

929: SET
930: interface_run_id=l_interface_run_id
931: WHERE adci.status='2' AND
932: EXISTS (SELECT 1
933: FROM igs_ad_interface_all ai
934: WHERE
935: ai.interface_id=adci.interface_id AND
936: ai.status IN ('1','4') AND
937: ai.interface_run_id=l_interface_run_id);

Line 966: FROM igs_ad_interface_all ai

962: SET
963: interface_run_id=l_interface_run_id
964: WHERE pfi.status='2' AND
965: EXISTS (SELECT 1
966: FROM igs_ad_interface_all ai
967: WHERE
968: ai.interface_id=pfi.interface_id AND
969: ai.status IN ('1','4') AND
970: ai.interface_run_id=l_interface_run_id);

Line 985: FROM igs_ad_interface_all ai

981: SET
982: interface_run_id=l_interface_run_id
983: WHERE phi.status='2' AND
984: EXISTS (SELECT 1
985: FROM igs_ad_interface_all ai
986: WHERE
987: ai.interface_id=phi.interface_id AND
988: ai.status IN ('1','4') AND
989: ai.interface_run_id=l_interface_run_id);

Line 1016: FROM igs_ad_interface_all ai

1012: SET
1013: interface_run_id=l_interface_run_id
1014: WHERE phi.status='2' AND
1015: EXISTS (SELECT 1
1016: FROM igs_ad_interface_all ai
1017: WHERE
1018: ai.interface_id=phi.interface_id AND
1019: ai.status IN ('1','4') AND
1020: ai.interface_run_id=l_interface_run_id);

Line 1049: FROM igs_ad_interface_all ai

1045: SET
1046: interface_run_id=l_interface_run_id
1047: WHERE ahi.status='2' AND
1048: EXISTS (SELECT 1
1049: FROM igs_ad_interface_all ai
1050: WHERE
1051: ai.interface_id=ahi.interface_id AND
1052: ai.status IN ('1','4') AND
1053: ai.interface_run_id=l_interface_run_id);

Line 1083: FROM igs_ad_interface_all ai

1079: SET
1080: interface_run_id=l_interface_run_id
1081: WHERE rdi.status='2' AND
1082: EXISTS (SELECT 1
1083: FROM igs_ad_interface_all ai
1084: WHERE
1085: ai.interface_id=rdi.interface_id AND
1086: ai.status IN ('1','4') AND
1087: ai.interface_run_id=l_interface_run_id);

Line 1117: FROM igs_ad_interface_all

1113: -- Populating the interface table with the interface_run_id value
1114: UPDATE igs_pe_Cred_int a
1115: SET interface_run_id = l_interface_run_id
1116: WHERE EXISTS (SELECT 1
1117: FROM igs_ad_interface_all
1118: WHERE interface_run_id = l_interface_run_id
1119: AND interface_id = a.interface_id
1120: AND status IN ('1','4'));
1121:

Line 1147: FROM igs_ad_interface_all

1143: -- Populating the interface table with the interface_run_id value
1144: UPDATE igs_ad_acadhis_int_all a
1145: SET interface_run_id = l_interface_run_id,
1146: person_id = (SELECT person_id
1147: FROM igs_ad_interface_all
1148: WHERE interface_id = a.interface_id)
1149: WHERE EXISTS (SELECT 1
1150: FROM igs_ad_interface_all
1151: WHERE interface_run_id = l_interface_run_id

Line 1150: FROM igs_ad_interface_all

1146: person_id = (SELECT person_id
1147: FROM igs_ad_interface_all
1148: WHERE interface_id = a.interface_id)
1149: WHERE EXISTS (SELECT 1
1150: FROM igs_ad_interface_all
1151: WHERE interface_run_id = l_interface_run_id
1152: AND interface_id = a.interface_id
1153: AND status IN ('1','4'));
1154:

Line 1179: FROM igs_ad_interface_all

1175: -- Populating the interface table with the interface_run_id value
1176: UPDATE igs_pe_privacy_int a
1177: SET interface_run_id = l_interface_run_id
1178: WHERE EXISTS (SELECT 1
1179: FROM igs_ad_interface_all
1180: WHERE interface_run_id = l_interface_run_id
1181: AND interface_id = a.interface_id
1182: AND status IN ('1','4'));
1183:

Line 1215: pkpatel 11-DEC-2003 Bug 2863933 (Removed the individual UPDATE of IGS_AD_INTERFACE_ALL and made it single UPDATE)

1211: Know limitations, enhancements or remarks
1212: Change History
1213: Who When What
1214: vrathi 08-Jul-2003 Bug:3038248 Delete record from igs_ad_addrusage_int before deleting from igs_ad_addr_int
1215: pkpatel 11-DEC-2003 Bug 2863933 (Removed the individual UPDATE of IGS_AD_INTERFACE_ALL and made it single UPDATE)
1216: Added 3 intermediate COMMIT statements.
1217: nsidana 6/21/2004 Bug 3533035 : First need to update the records in relations_int table to 4 in case any child did not process
1218: successfully. Then we need to delete from relations_int table, the records with status 1.
1219: Previously, the reverse was happening, so the record in parent relations_int table was getting deleted even though

Line 1255: UPDATE igs_ad_interface_all

1251: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1252: END IF;
1253:
1254: -- update record status of all the records in igs_AD_interface with current interface_run_id to '1'
1255: UPDATE igs_ad_interface_all
1256: SET record_status = '1'
1257: WHERE interface_run_id = l_interface_run_id;
1258:
1259: -- call the procedure to store statistics in igs_ad_imp_stats

Line 1568: UPDATE igs_ad_interface_all ad

1564:
1565: END IF;
1566:
1567:
1568: UPDATE igs_ad_interface_all ad
1569: SET record_status = '3'
1570: WHERE ad.interface_run_id = l_interface_run_id AND
1571: ( EXISTS (SELECT 1 FROM igs_ad_interface_all ai WHERE ad.interface_id = ai.interface_id AND status = '3')
1572: OR EXISTS (SELECT 1 FROM igs_ad_stat_int_all ai WHERE ad.interface_id = ai.interface_id)

Line 1571: ( EXISTS (SELECT 1 FROM igs_ad_interface_all ai WHERE ad.interface_id = ai.interface_id AND status = '3')

1567:
1568: UPDATE igs_ad_interface_all ad
1569: SET record_status = '3'
1570: WHERE ad.interface_run_id = l_interface_run_id AND
1571: ( EXISTS (SELECT 1 FROM igs_ad_interface_all ai WHERE ad.interface_id = ai.interface_id AND status = '3')
1572: OR EXISTS (SELECT 1 FROM igs_ad_stat_int_all ai WHERE ad.interface_id = ai.interface_id)
1573: OR EXISTS (SELECT 1 FROM igs_ad_addr_int_all ai WHERE ad.interface_id = ai.interface_id)
1574: OR EXISTS (SELECT 1 FROM igs_ad_api_int_all ai WHERE ad.interface_id = ai.interface_id)
1575: OR EXISTS (SELECT 1 FROM igs_pe_race_int ai WHERE ad.interface_id = ai.interface_id)

Line 1716: p_interface_id IN igs_ad_interface_all.interface_id%TYPE

1712:
1713: END set_stat_matc_rvw_pers_rcds;
1714:
1715: PROCEDURE prc_pe_imp_record_sts(
1716: p_interface_id IN igs_ad_interface_all.interface_id%TYPE
1717: )
1718: AS
1719: /*************************************************************
1720: Created By :pkpatel

Line 1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1986: SELECT count(*) count1,status FROM IGS_AD_RELEMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1987:
1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1990:
1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1993:

Line 2042: l_tab := 'IGS_AD_INTERFACE_ALL';

2038: l_warning := 0;
2039: END IF;
2040:
2041: l_total_rec := l_success + l_error + l_warning;
2042: l_tab := 'IGS_AD_INTERFACE_ALL';
2043: INSERT INTO IGS_AD_IMP_STATS
2044: (
2045: INTERFACE_RUN_ID,
2046: SRC_CAT_CODE,