APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_RES_DTLS_INT

Line 1078: UPDATE igs_pe_res_dtls_int rdi

1074:
1075:
1076: -- Update interface tables for Felony and hearing details.
1077:
1078: UPDATE igs_pe_res_dtls_int rdi
1079: SET
1080: interface_run_id=l_interface_run_id
1081: WHERE rdi.status='2' AND
1082: EXISTS (SELECT 1

Line 1091: tabname => 'IGS_PE_RES_DTLS_INT',

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'
1095: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 1093: UPDATE igs_pe_res_dtls_int iah

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'
1095: WHERE MATCH_IND = '22' AND STATUS = '2'
1096: AND INTERFACE_RUN_ID = l_interface_run_id;
1097:

Line 1414: DELETE FROM IGS_PE_RES_DTLS_INT WHERE

1410: IF g_person_res_dtl_inc THEN
1411:
1412: pe_cat_stats('PERSON_RESIDENCY_DETAILS');
1413:
1414: DELETE FROM IGS_PE_RES_DTLS_INT WHERE
1415: STATUS = '1' AND interface_run_id = l_interface_run_id;
1416:
1417: END IF;
1418:

Line 1589: OR EXISTS (SELECT 1 FROM igs_pe_res_dtls_int ai WHERE ad.interface_id = ai.interface_id)

1585: OR EXISTS (SELECT 1 FROM igs_ad_hlth_ins_int_all ai WHERE ad.interface_id = ai.interface_id)
1586: OR EXISTS (SELECT 1 FROM igs_pe_immu_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1587: OR EXISTS (SELECT 1 FROM igs_ad_military_int_all ai WHERE ad.interface_id = ai.interface_id)
1588: OR EXISTS (SELECT 1 FROM igs_ad_excurr_int_all ai WHERE ad.interface_id = ai.interface_id)
1589: OR EXISTS (SELECT 1 FROM igs_pe_res_dtls_int ai WHERE ad.interface_id = ai.interface_id)
1590: OR EXISTS (SELECT 1 FROM igs_ad_acadhonor_int_all ai WHERE ad.interface_id = ai.interface_id)
1591: OR EXISTS (SELECT 1 FROM igs_ad_relations_int_all ai WHERE ad.interface_id = ai.interface_id)
1592: OR EXISTS (SELECT 1 FROM igs_pe_ath_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1593: OR EXISTS (SELECT 1 FROM igs_pe_ath_prg_int ai WHERE ad.interface_id = ai.interface_id)

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

1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1971: SELECT count(*) count1,status FROM IGS_AD_ACADHONOR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1972:
1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1974: SELECT count(*) count1,status FROM IGS_PE_RES_DTLS_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1975:
1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1977: SELECT count(*) count1,status FROM IGS_AD_RELACAD_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1978:

Line 3790: l_tab := 'IGS_PE_RES_DTLS_INT';

3786: IF l_warning IS NULL THEN
3787: l_warning := 0;
3788: END IF;
3789: l_total_rec := l_success + l_error + l_warning;
3790: l_tab := 'IGS_PE_RES_DTLS_INT';
3791: INSERT INTO IGS_AD_IMP_STATS
3792: (
3793: INTERFACE_RUN_ID,
3794: SRC_CAT_CODE,