APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_LANGUAGE_INT_ALL

Line 895: UPDATE igs_ad_language_int_all adli

891: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_LAN');
892: END IF;
893:
894: -- Populating the child interface table with the interface_run_id value.
895: UPDATE igs_ad_language_int_all adli
896: SET
897: interface_run_id=l_interface_run_id
898: WHERE adli.status='2' AND
899: EXISTS (SELECT 1

Line 908: tabname => 'IGS_AD_LANGUAGE_INT_ALL',

904: ai.interface_run_id=l_interface_run_id);
905:
906: -- gather statistics for the table after populating it's interface_run_id
907: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
908: tabname => 'IGS_AD_LANGUAGE_INT_ALL',
909: cascade => TRUE);
910: UPDATE IGS_AD_LANGUAGE_INT_all il
911: SET STATUS = '1'
912: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 910: UPDATE IGS_AD_LANGUAGE_INT_all il

906: -- gather statistics for the table after populating it's interface_run_id
907: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
908: tabname => 'IGS_AD_LANGUAGE_INT_ALL',
909: cascade => TRUE);
910: UPDATE IGS_AD_LANGUAGE_INT_all il
911: SET STATUS = '1'
912: WHERE MATCH_IND = '22' AND STATUS = '2'
913: AND INTERFACE_RUN_ID = l_interface_run_id;
914:

Line 1538: DELETE FROM IGS_AD_LANGUAGE_INT_all WHERE

1534:
1535: IF g_person_lang_inc THEN
1536: pe_cat_stats('PERSON_LANGUAGES');
1537: -- new logic to delete processed records from interface table
1538: DELETE FROM IGS_AD_LANGUAGE_INT_all WHERE
1539: STATUS = '1' AND interface_run_id = l_interface_run_id;
1540:
1541: END IF;
1542:

Line 1598: OR EXISTS (SELECT 1 FROM igs_ad_language_int_all 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));
1602:

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

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:
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:

Line 3466: l_tab := 'IGS_AD_LANGUAGE_INT_ALL';

3462: l_warning := 0;
3463: END IF;
3464:
3465: l_total_rec := l_success + l_error + l_warning;
3466: l_tab := 'IGS_AD_LANGUAGE_INT_ALL';
3467: INSERT INTO IGS_AD_IMP_STATS
3468: (
3469: INTERFACE_RUN_ID,
3470: SRC_CAT_CODE,