APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_CONTACTS_INT_ALL

Line 928: UPDATE igs_ad_contacts_int_all adci

924: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_CON');
925: END IF;
926:
927: -- Populating the child interface table with the interface_run_id value.
928: UPDATE igs_ad_contacts_int_all adci
929: SET
930: interface_run_id=l_interface_run_id
931: WHERE adci.status='2' AND
932: EXISTS (SELECT 1

Line 941: tabname => 'IGS_AD_CONTACTS_INT_ALL',

937: ai.interface_run_id=l_interface_run_id);
938:
939: -- gather statistics for the table after populating it's interface_run_id
940: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
941: tabname => 'IGS_AD_CONTACTS_INT_ALL',
942: cascade => TRUE);
943: UPDATE IGS_AD_CONTACTS_INT_all ic
944: SET STATUS = '1'
945: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 943: UPDATE IGS_AD_CONTACTS_INT_all ic

939: -- gather statistics for the table after populating it's interface_run_id
940: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
941: tabname => 'IGS_AD_CONTACTS_INT_ALL',
942: cascade => TRUE);
943: UPDATE IGS_AD_CONTACTS_INT_all ic
944: SET STATUS = '1'
945: WHERE MATCH_IND = '22' AND STATUS = '2'
946: AND INTERFACE_RUN_ID = l_interface_run_id;
947:

Line 1530: DELETE FROM IGS_AD_CONTACTS_INT_all WHERE

1526:
1527: IF g_person_contact_inc THEN
1528: pe_cat_stats('PERSON_CONTACTS');
1529: -- new logic to delete processed records from interface table
1530: DELETE FROM IGS_AD_CONTACTS_INT_all WHERE
1531: STATUS = '1' AND interface_run_id = l_interface_run_id;
1532:
1533: END IF;
1534:

Line 1597: OR EXISTS (SELECT 1 FROM igs_ad_contacts_int_all 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)
1598: OR EXISTS (SELECT 1 FROM igs_ad_language_int_all ai WHERE ad.interface_id = ai.interface_id)
1599: OR EXISTS (SELECT 1 FROM igs_pe_cred_int ai WHERE ad.interface_id = ai.interface_id)
1600: OR EXISTS (SELECT 1 FROM igs_ad_acadhis_int_all ai WHERE ad.interface_id = ai.interface_id)
1601: OR EXISTS (SELECT 1 FROM igs_pe_privacy_int ai WHERE ad.interface_id = ai.interface_id));

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

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:
1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1959: SELECT count(*) count1,status FROM IGS_AD_CONTACTS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1960:
1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1962: SELECT count(*) count1,status FROM IGS_PE_FLNY_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1963:

Line 3520: l_tab := 'IGS_AD_CONTACTS_INT_ALL';

3516: l_warning := 0;
3517: END IF;
3518:
3519: l_total_rec := l_success + l_error + l_warning;
3520: l_tab := 'IGS_AD_CONTACTS_INT_ALL';
3521: INSERT INTO IGS_AD_IMP_STATS
3522: (
3523: INTERFACE_RUN_ID,
3524: SRC_CAT_CODE,