APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_ACADHIS_INT_ALL

Line 1144: UPDATE igs_ad_acadhis_int_all a

1140: p_token_value => l_meaning);
1141: END IF;
1142:
1143: -- Populating the interface table with the interface_run_id value
1144: UPDATE igs_ad_acadhis_int_all a
1145: SET interface_run_id = l_interface_run_id,
1146: person_id = (SELECT person_id
1147: FROM igs_ad_interface_all
1148: WHERE interface_id = a.interface_id)

Line 1157: tabname => 'IGS_AD_ACADHIS_INT_ALL',

1153: AND status IN ('1','4'));
1154:
1155: -- Gather statistics of the table
1156: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1157: tabname => 'IGS_AD_ACADHIS_INT_ALL',
1158: cascade => TRUE);
1159:
1160: -- Call category entity import procedure
1161: igs_ad_imp_013.prc_pe_acad_hist (p_interface_run_id => l_interface_run_id,

Line 1554: DELETE FROM IGS_AD_ACADHIS_INT_ALL WHERE

1550:
1551: IF g_acad_hist_inc THEN
1552: pe_cat_stats('PERSON_ACADEMIC_HISTORY');
1553:
1554: DELETE FROM IGS_AD_ACADHIS_INT_ALL WHERE
1555: STATUS = '1' AND interface_run_id = l_interface_run_id;
1556:
1557: END IF;
1558:

Line 1600: OR EXISTS (SELECT 1 FROM igs_ad_acadhis_int_all 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:
1603: -- Commit all the transactions
1604: COMMIT;

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

1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1993:
1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1995: SELECT count(*) count1,status FROM igs_ad_acadhis_int_all WHERE interface_run_id = p_interface_run_id GROUP BY status;
1996:
1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1998: SELECT count(*) count1,status FROM igs_pe_privacy_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1999:

Line 4108: l_tab := 'IGS_AD_ACADHIS_INT_ALL';

4104: IF l_warning IS NULL THEN
4105: l_warning := 0;
4106: END IF;
4107: l_total_rec := l_success + l_error + l_warning;
4108: l_tab := 'IGS_AD_ACADHIS_INT_ALL';
4109: INSERT INTO IGS_AD_IMP_STATS
4110: (
4111: INTERFACE_RUN_ID,
4112: SRC_CAT_CODE,