APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_RACE_INT

Line 256: UPDATE igs_pe_race_int adli

252: tabname => 'IGS_PE_EIT_INT',
253: cascade => TRUE);
254:
255: -- Populating the child interface table with the interface_run_id value.
256: UPDATE igs_pe_race_int adli
257: SET
258: interface_run_id=l_interface_run_id
259: WHERE adli.status='2' AND
260: EXISTS (SELECT 1

Line 268: tabname => 'IGS_PE_RACE_INT',

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
272: SET status = '1'

Line 277: UPDATE igs_pe_race_int

273: WHERE match_ind = '22' AND
274: status = '2' AND
275: INTERFACE_RUN_ID = l_interface_run_id;
276:
277: UPDATE igs_pe_race_int
278: SET status = '1'
279: WHERE match_ind = '22' AND
280: status = '2' AND
281: INTERFACE_RUN_ID = l_interface_run_id;

Line 1289: DELETE FROM igs_pe_race_int WHERE

1285: IF g_person_stat_inc THEN
1286: pe_cat_stats('PERSON_STATISTICS');
1287:
1288: -- new logic to delete processed records from interface table
1289: DELETE FROM igs_pe_race_int WHERE
1290: STATUS = '1' AND interface_run_id = l_interface_run_id;
1291:
1292: DELETE FROM igs_pe_eit_int WHERE
1293: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1575: OR EXISTS (SELECT 1 FROM igs_pe_race_int ai WHERE ad.interface_id = ai.interface_id)

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)
1577: OR EXISTS (SELECT 1 FROM igs_pe_type_int ai WHERE ad.interface_id = ai.interface_id)
1578: OR EXISTS (SELECT 1 FROM igs_ad_alias_int_all ai WHERE ad.interface_id = ai.interface_id)
1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_int_all ai WHERE ad.interface_id = ai.interface_id)

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

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;
1887:
1888: CURSOR cur_person_race_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1889: SELECT count(*) count1,status FROM IGS_PE_RACE_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1890:
1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1892: SELECT count(*) count1,status FROM IGS_AD_ADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1893:

Line 2259: l_tab := 'IGS_PE_RACE_INT';

2255: l_warning := 0;
2256: END IF;
2257:
2258: l_total_rec := l_success + l_error + l_warning;
2259: l_tab := 'IGS_PE_RACE_INT';
2260: INSERT INTO IGS_AD_IMP_STATS
2261: (
2262: INTERFACE_RUN_ID,
2263: SRC_CAT_CODE,