APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_EXCURR_INT_ALL

Line 682: UPDATE igs_ad_excurr_int_all adei

678:
679:
680:
681: -- Populating the child interface table with the interface_run_id value.
682: UPDATE igs_ad_excurr_int_all adei
683: SET
684: interface_run_id=l_interface_run_id
685: WHERE adei.status='2' AND
686: EXISTS (SELECT 1

Line 695: tabname => 'IGS_AD_EXCURR_INT_ALL',

691: ai.interface_run_id=l_interface_run_id);
692:
693: -- gather statistics for the table after populating it's interface_run_id
694: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
695: tabname => 'IGS_AD_EXCURR_INT_ALL',
696: cascade => TRUE);
697:
698: UPDATE IGS_AD_EXCURR_INT_all SET STATUS = '1'
699: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 698: UPDATE IGS_AD_EXCURR_INT_all SET STATUS = '1'

694: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
695: tabname => 'IGS_AD_EXCURR_INT_ALL',
696: cascade => TRUE);
697:
698: UPDATE IGS_AD_EXCURR_INT_all SET STATUS = '1'
699: WHERE MATCH_IND = '22' AND STATUS = '2'
700: AND INTERFACE_RUN_ID = l_interface_run_id;
701:
702: Igs_Ad_Imp_006.PRC_PE_EXTCLR_DTLS(

Line 1403: DELETE FROM IGS_AD_EXCURR_INT_all WHERE

1399: IF g_person_act_inc THEN
1400:
1401: pe_cat_stats('PERSON_ACTIVITIES');
1402:
1403: DELETE FROM IGS_AD_EXCURR_INT_all WHERE
1404: STATUS = '1' AND interface_run_id = l_interface_run_id;
1405:
1406: END IF;
1407:

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

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

1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1942:
1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1944: SELECT count(*) count1,status FROM IGS_AD_EXCURR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1945:
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:

Line 3248: l_tab := 'IGS_AD_EXCURR_INT_ALL';

3244: l_warning := 0;
3245: END IF;
3246:
3247: l_total_rec := l_success + l_error + l_warning;
3248: l_tab := 'IGS_AD_EXCURR_INT_ALL';
3249: INSERT INTO IGS_AD_IMP_STATS
3250: (
3251: INTERFACE_RUN_ID,
3252: SRC_CAT_CODE,