APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_ATH_PRG_INT

Line 864: UPDATE igs_pe_ath_prg_int adli

860: WHERE match_ind = '22' AND status = '2' AND
861: INTERFACE_RUN_ID = l_interface_run_id;
862:
863: -- Populating the child interface table with the interface_run_id value.
864: UPDATE igs_pe_ath_prg_int adli
865: SET
866: interface_run_id=l_interface_run_id
867: WHERE adli.status='2' AND
868: EXISTS (SELECT 1

Line 877: tabname => 'IGS_PE_ATH_PRG_INT',

873: ai.interface_run_id=l_interface_run_id);
874:
875: -- gather statistics for the table after populating it's interface_run_id
876: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
877: tabname => 'IGS_PE_ATH_PRG_INT',
878: cascade => TRUE);
879: UPDATE igs_pe_ath_prg_int
880: SET status = '1'
881: WHERE match_ind = '22' AND status = '2'

Line 879: UPDATE igs_pe_ath_prg_int

875: -- gather statistics for the table after populating it's interface_run_id
876: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
877: tabname => 'IGS_PE_ATH_PRG_INT',
878: cascade => TRUE);
879: UPDATE igs_pe_ath_prg_int
880: SET status = '1'
881: WHERE match_ind = '22' AND status = '2'
882: AND INTERFACE_RUN_ID = l_interface_run_id;
883:

Line 1497: -- Delete from the table igs_pe_ath_prg_int

1493:
1494: DELETE FROM igs_pe_ath_dtl_int WHERE
1495: STATUS = '1' AND interface_run_id = l_interface_run_id;
1496:
1497: -- Delete from the table igs_pe_ath_prg_int
1498: DELETE FROM igs_pe_ath_prg_int WHERE
1499: STATUS = '1' AND interface_run_id = l_interface_run_id;
1500:
1501: END IF;

Line 1498: DELETE FROM igs_pe_ath_prg_int WHERE

1494: DELETE FROM igs_pe_ath_dtl_int WHERE
1495: STATUS = '1' AND interface_run_id = l_interface_run_id;
1496:
1497: -- Delete from the table igs_pe_ath_prg_int
1498: DELETE FROM igs_pe_ath_prg_int WHERE
1499: STATUS = '1' AND interface_run_id = l_interface_run_id;
1500:
1501: END IF;
1502:

Line 1593: OR EXISTS (SELECT 1 FROM igs_pe_ath_prg_int 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)
1594: OR EXISTS (SELECT 1 FROM igs_pe_housing_int ai WHERE ad.interface_id = ai.interface_id)
1595: OR EXISTS (SELECT 1 FROM igs_pe_flny_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1596: OR EXISTS (SELECT 1 FROM igs_pe_hear_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1597: OR EXISTS (SELECT 1 FROM igs_ad_contacts_int_all ai WHERE ad.interface_id = ai.interface_id)

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

1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1950: SELECT count(*) count1,status FROM IGS_PE_ATH_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1951:
1952: CURSOR cur_person_ath_prg_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1953: SELECT count(*) count1,status FROM IGS_PE_ATH_PRG_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1954:
1955: CURSOR cur_person_lang_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1956: SELECT count(*) count1,status FROM IGS_AD_LANGUAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1957:

Line 3412: l_tab := 'IGS_PE_ATH_PRG_INT';

3408: l_warning := 0;
3409: END IF;
3410:
3411: l_total_rec := l_success + l_error + l_warning;
3412: l_tab := 'IGS_PE_ATH_PRG_INT';
3413: INSERT INTO IGS_AD_IMP_STATS
3414: (
3415: INTERFACE_RUN_ID,
3416: SRC_CAT_CODE,