APPS.IGS_HE_IMPORT_DATA dependencies on IGS_AD_INTERFACE_ALL

Line 1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,

1317: l_person_info_rec c_person_info%ROWTYPE;
1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table
1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id

Line 1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS

1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table
1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id

Line 1324: FROM igs_ad_interface_all a

1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id
1327: AND a.status = '2'
1328: AND a.record_status='2';

Line 1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;

1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id
1327: AND a.status = '2'
1328: AND a.record_status='2';
1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
1330:
1331: -- Get the admission application instance interface records whose import has failed
1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,
1333: cp_person_number igs_pe_person.person_number%TYPE ) IS