APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_ATH_DTL_INT

Line 842: UPDATE igs_pe_ath_dtl_int adli

838: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ATHL');
839: END IF;
840:
841: -- Populating the child interface table with the interface_run_id value.
842: UPDATE igs_pe_ath_dtl_int adli
843: SET
844: interface_run_id=l_interface_run_id
845: WHERE adli.status='2' AND
846: EXISTS (SELECT 1

Line 855: tabname => 'IGS_PE_ATH_DTL_INT',

851: ai.interface_run_id=l_interface_run_id);
852:
853: -- gather statistics for the table after populating it's interface_run_id
854: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
855: tabname => 'IGS_PE_ATH_DTL_INT',
856: cascade => TRUE);
857:
858: UPDATE igs_pe_ath_dtl_int
859: SET status = '1'

Line 858: UPDATE igs_pe_ath_dtl_int

854: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
855: tabname => 'IGS_PE_ATH_DTL_INT',
856: cascade => TRUE);
857:
858: UPDATE igs_pe_ath_dtl_int
859: SET status = '1'
860: WHERE match_ind = '22' AND status = '2' AND
861: INTERFACE_RUN_ID = l_interface_run_id;
862:

Line 1491: -- Delete from the table igs_pe_ath_dtl_int

1487: END IF;
1488:
1489: IF g_person_ath_inc THEN
1490:
1491: -- Delete from the table igs_pe_ath_dtl_int
1492: pe_cat_stats('PERSON_ATHLETICS');
1493:
1494: DELETE FROM igs_pe_ath_dtl_int WHERE
1495: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1494: DELETE FROM igs_pe_ath_dtl_int WHERE

1490:
1491: -- Delete from the table igs_pe_ath_dtl_int
1492: pe_cat_stats('PERSON_ATHLETICS');
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

Line 1592: OR EXISTS (SELECT 1 FROM igs_pe_ath_dtl_int 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)
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)

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

1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1947: SELECT count(*) count1,status FROM IGS_AD_RELATIONS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1948:
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:

Line 3356: l_tab := 'IGS_PE_ATH_DTL_INT';

3352: l_warning := 0;
3353: END IF;
3354:
3355: l_total_rec := l_success + l_error + l_warning;
3356: l_tab := 'IGS_PE_ATH_DTL_INT';
3357: INSERT INTO IGS_AD_IMP_STATS
3358: (
3359: INTERFACE_RUN_ID,
3360: SRC_CAT_CODE,