APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_EMP_INT_ALL

Line 426: UPDATE igs_ad_emp_int_all admpi

422: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_EMP_DTL');
423: END IF;
424:
425: -- Populating the child interface table with the interface_run_id value.
426: UPDATE igs_ad_emp_int_all admpi
427: SET
428: interface_run_id=l_interface_run_id
429: WHERE admpi.status='2' AND
430: EXISTS (SELECT 1

Line 439: tabname => 'IGS_AD_EMP_INT_ALL',

435: ai.interface_run_id=l_interface_run_id);
436:
437: -- gather statistics for the table after populating it's interface_run_id
438: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
439: tabname => 'IGS_AD_EMP_INT_ALL',
440: cascade => TRUE);
441:
442: UPDATE IGS_AD_EMP_INT_all SET STATUS = '1'
443: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 442: UPDATE IGS_AD_EMP_INT_all SET STATUS = '1'

438: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
439: tabname => 'IGS_AD_EMP_INT_ALL',
440: cascade => TRUE);
441:
442: UPDATE IGS_AD_EMP_INT_all SET STATUS = '1'
443: WHERE MATCH_IND = '22' AND STATUS = '2'
444: AND INTERFACE_RUN_ID = l_interface_run_id;
445:
446: Igs_Ad_Imp_006.PRC_PE_EMPNT_DTLS(

Line 1333: DELETE FROM IGS_AD_EMP_INT_all WHERE

1329: IF g_person_emp_dtl_inc THEN
1330: -- call the procedure to store statistics in igs_ad_imp_stats
1331: pe_cat_stats('PERSON_EMPLOYMENT_DETAILS');
1332:
1333: DELETE FROM IGS_AD_EMP_INT_all WHERE
1334: STATUS = '1' AND interface_run_id = l_interface_run_id;
1335:
1336: END IF;
1337:

Line 1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_int_all ai WHERE ad.interface_id = ai.interface_id)

1576: OR EXISTS (SELECT 1 FROM igs_pe_eit_int ai WHERE ad.interface_id = ai.interface_id)
1577: OR EXISTS (SELECT 1 FROM igs_pe_type_int ai WHERE ad.interface_id = ai.interface_id)
1578: OR EXISTS (SELECT 1 FROM igs_ad_alias_int_all ai WHERE ad.interface_id = ai.interface_id)
1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_int_all ai WHERE ad.interface_id = ai.interface_id)
1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_int_all ai WHERE ad.interface_id = ai.interface_id)
1581: OR EXISTS (SELECT 1 FROM igs_pe_visa_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)

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

1909: CURSOR cur_person_conc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1910: SELECT count(*) count1,status FROM IGS_PE_SN_CONCT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1911:
1912: CURSOR cur_person_emp_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1913: SELECT count(*) count1,status FROM IGS_AD_EMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1914:
1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1917:

Line 2698: l_tab := 'IGS_AD_EMP_INT_ALL';

2694: l_warning := 0;
2695: END IF;
2696:
2697: l_total_rec := l_total_rec + l_success + l_error + l_warning;
2698: l_tab := 'IGS_AD_EMP_INT_ALL';
2699: INSERT INTO IGS_AD_IMP_STATS
2700: (
2701: INTERFACE_RUN_ID,
2702: SRC_CAT_CODE,