APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_IMMU_DTL_INT

Line 593: UPDATE igs_pe_immu_dtl_int pidi

589: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HLTH_INS');
590: END IF;
591:
592: -- Populating the child interface table with the interface_run_id value.
593: UPDATE igs_pe_immu_dtl_int pidi
594: SET
595: interface_run_id=l_interface_run_id
596: WHERE pidi.status='2' AND
597: EXISTS (SELECT 1

Line 606: tabname => 'IGS_PE_IMMU_DTL_INT',

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:
610: UPDATE igs_pe_immu_dtl_int

Line 610: UPDATE igs_pe_immu_dtl_int

606: tabname => 'IGS_PE_IMMU_DTL_INT',
607: cascade => TRUE);
608:
609:
610: UPDATE igs_pe_immu_dtl_int
611: SET status = '1'
612: WHERE match_ind = '22' AND
613: status = '2' AND
614: INTERFACE_RUN_ID = l_interface_run_id;

Line 1379: -- Delete from the table igs_pe_immu_dtl_int

1375: -- Delete from the table IGS_AD_HLTH_INS_INT
1376: DELETE FROM IGS_AD_HLTH_INS_INT_all WHERE
1377: STATUS = '1' AND interface_run_id = l_interface_run_id;
1378:
1379: -- Delete from the table igs_pe_immu_dtl_int
1380: DELETE FROM igs_pe_immu_dtl_int WHERE
1381: STATUS = '1' AND interface_run_id = l_interface_run_id;
1382:
1383: END IF;

Line 1380: DELETE FROM igs_pe_immu_dtl_int WHERE

1376: DELETE FROM IGS_AD_HLTH_INS_INT_all WHERE
1377: STATUS = '1' AND interface_run_id = l_interface_run_id;
1378:
1379: -- Delete from the table igs_pe_immu_dtl_int
1380: DELETE FROM igs_pe_immu_dtl_int WHERE
1381: STATUS = '1' AND interface_run_id = l_interface_run_id;
1382:
1383: END IF;
1384:

Line 1586: OR EXISTS (SELECT 1 FROM igs_pe_immu_dtl_int ai WHERE ad.interface_id = ai.interface_id)

1582: OR EXISTS (SELECT 1 FROM igs_pe_passport_int ai WHERE ad.interface_id = ai.interface_id)
1583: OR EXISTS (SELECT 1 FROM igs_pe_citizen_int ai WHERE ad.interface_id = ai.interface_id)
1584: OR EXISTS (SELECT 1 FROM igs_pe_fund_src_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)

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

1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1932: SELECT count(*) count1,status FROM IGS_PE_FUND_SRC_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1933:
1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1935: SELECT count(*) count1,status FROM IGS_PE_IMMU_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1936:
1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1939:

Line 3085: l_tab := 'IGS_PE_IMMU_DTL_INT';

3081: l_warning := 0;
3082: END IF;
3083:
3084: l_total_rec := l_success + l_error + l_warning;
3085: l_tab := 'IGS_PE_IMMU_DTL_INT';
3086: INSERT INTO IGS_AD_IMP_STATS
3087: (
3088: INTERFACE_RUN_ID,
3089: SRC_CAT_CODE,