APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_ACADHONOR_INT_ALL

Line 1044: UPDATE igs_ad_acadhonor_int_all ahi

1040: END IF;
1041:
1042:
1043: -- Populating the child interface table with the interface_run_id value.
1044: UPDATE igs_ad_acadhonor_int_all ahi
1045: SET
1046: interface_run_id=l_interface_run_id
1047: WHERE ahi.status='2' AND
1048: EXISTS (SELECT 1

Line 1057: tabname => 'IGS_AD_ACADHONOR_INT_ALL',

1053: ai.interface_run_id=l_interface_run_id);
1054:
1055: -- gather statistics for the table after populating it's interface_run_id
1056: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1057: tabname => 'IGS_AD_ACADHONOR_INT_ALL',
1058: cascade => TRUE);
1059: UPDATE IGS_AD_ACADHONOR_INT_all iah
1060: SET STATUS = '1'
1061: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 1059: UPDATE IGS_AD_ACADHONOR_INT_all iah

1055: -- gather statistics for the table after populating it's interface_run_id
1056: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1057: tabname => 'IGS_AD_ACADHONOR_INT_ALL',
1058: cascade => TRUE);
1059: UPDATE IGS_AD_ACADHONOR_INT_all iah
1060: SET STATUS = '1'
1061: WHERE MATCH_IND = '22' AND STATUS = '2'
1062: AND INTERFACE_RUN_ID = l_interface_run_id;
1063:

Line 1424: DELETE FROM IGS_AD_ACADHONOR_INT_all WHERE

1420: IF g_person_acad_honors_inc THEN
1421: -- call the procedure to store statistics in igs_ad_imp_stats
1422: pe_cat_stats('PERSON_ACAD_HONORS');
1423:
1424: DELETE FROM IGS_AD_ACADHONOR_INT_all WHERE
1425: STATUS = '1' AND interface_run_id = l_interface_run_id;
1426:
1427: END IF;
1428:

Line 1590: OR EXISTS (SELECT 1 FROM igs_ad_acadhonor_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)
1594: OR EXISTS (SELECT 1 FROM igs_pe_housing_int ai WHERE ad.interface_id = ai.interface_id)

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

1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1968: SELECT count(*) count1,status FROM IGS_PE_HOUSING_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1969:
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:

Line 3737: l_tab := 'IGS_AD_ACADHONOR_INT_ALL';

3733: l_warning := 0;
3734: END IF;
3735:
3736: l_total_rec := l_success + l_error + l_warning;
3737: l_tab := 'IGS_AD_ACADHONOR_INT_ALL';
3738: INSERT INTO IGS_AD_IMP_STATS
3739: (
3740: INTERFACE_RUN_ID,
3741: SRC_CAT_CODE,