APPS.IGS_HE_IMPORT_DATA dependencies on IGS_AD_ACADHIS_INT_ALL

Line 1342: CURSOR c_acadhis_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS

1338: ( a.status IN ('2','3') OR a.record_status='3' ) ;
1339: c_adm_int_rec c_adm_int%ROWTYPE ;
1340:
1341: -- Get the Academic History interface records whose import has failed
1342: CURSOR c_acadhis_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS
1343: SELECT a.interface_acadhis_id
1344: FROM igs_ad_acadhis_int_all a
1345: WHERE a.interface_id = cp_interface_id
1346: AND a.status = '3';

Line 1344: FROM igs_ad_acadhis_int_all a

1340:
1341: -- Get the Academic History interface records whose import has failed
1342: CURSOR c_acadhis_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS
1343: SELECT a.interface_acadhis_id
1344: FROM igs_ad_acadhis_int_all a
1345: WHERE a.interface_id = cp_interface_id
1346: AND a.status = '3';
1347: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%TYPE ;
1348:

Line 1347: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%TYPE ;

1343: SELECT a.interface_acadhis_id
1344: FROM igs_ad_acadhis_int_all a
1345: WHERE a.interface_id = cp_interface_id
1346: AND a.status = '3';
1347: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%TYPE ;
1348:
1349: -- Get the hesa import interface record for the passed person number
1350: -- smaddali modified this cursor to add trim to remove spaces as part of bug fix 2740653
1351: CURSOR c_imp_int IS

Line 2347: INSERT INTO igs_ad_acadhis_int_all ( interface_acadhis_id,

2343: CLOSE c_adm_int_id;
2344:
2345: l_interface_acadhis_id := NULL;
2346: -- Create an Academic History interface record for this person
2347: INSERT INTO igs_ad_acadhis_int_all ( interface_acadhis_id,
2348: interface_id,
2349: institution_code,
2350: current_inst,
2351: end_date,