APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_STAT_INT_ALL

Line 119: UPDATE igs_ad_stat_int_all adi

115: tabname => 'IGS_AD_API_INT_ALL',
116: cascade => TRUE);
117:
118: -- Populating the child interface table with the interface_run_id value.
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

Line 129: tabname => 'IGS_AD_STAT_INT_ALL',

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.
133: UPDATE IGS_AD_ADDR_INT_ALL ait

Line 170: UPDATE IGS_AD_STAT_INT_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:
170: UPDATE IGS_AD_STAT_INT_all SET STATUS = '1'
171: WHERE MATCH_IND = '22' AND STATUS = '2'
172: AND INTERFACE_RUN_ID = l_interface_run_id;
173:
174: -- Address Details

Line 1265: DELETE FROM igs_ad_stat_int_all

1261:
1262: -- Delete from the tables for Statistics
1263: pe_cat_stats('PERSON_STATISTICS_STAT');
1264:
1265: DELETE FROM igs_ad_stat_int_all
1266: WHERE status = '1' AND interface_run_id = l_interface_run_id;
1267:
1268: -- Delete from the table IGS_AD_ADDRUSAGE_INT
1269: pe_cat_stats('PERSON_ADDRESS');

Line 1572: OR EXISTS (SELECT 1 FROM igs_ad_stat_int_all ai WHERE ad.interface_id = ai.interface_id)

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)
1576: OR EXISTS (SELECT 1 FROM igs_pe_eit_int ai WHERE ad.interface_id = ai.interface_id)

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

1878: WHERE interface_run_id = p_interface_run_id
1879: GROUP BY status;
1880:
1881: CURSOR cur_person_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1882: SELECT count(*) count1,status FROM IGS_AD_STAT_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1883:
1884: CURSOR cur_person_stat_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1885: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND
1886: information_type IN ('PE_STAT_RES_COUNTRY','PE_STAT_RES_STATE', 'PE_STAT_RES_STATUS') GROUP BY status;

Line 2148: l_tab := 'IGS_AD_STAT_INT_ALL';

2144: l_warning := 0;
2145: END IF;
2146:
2147: l_total_rec := l_success + l_error + l_warning;
2148: l_tab := 'IGS_AD_STAT_INT_ALL';
2149: l_source_category := 'PERSON_STATISTICS';
2150: INSERT INTO IGS_AD_IMP_STATS
2151: (
2152: INTERFACE_RUN_ID,