APPS.IGS_AD_IMP_003 dependencies on IGS_AD_SPL_INTERESTS

Line 939: AND EXISTS (SELECT 1 FROM igs_ad_spl_interests b

935: error_text = l_error_text1
936: WHERE
937: interface_run_id = p_interface_run_id
938: AND status = '2'
939: AND EXISTS (SELECT 1 FROM igs_ad_spl_interests b
940: WHERE b.person_id = a.person_id
941: AND b.admission_appl_number = a.admission_appl_number
942: AND b.special_interest_type_id = a.special_interest_type_id);
943:

Line 974: igs_ad_spl_interests_pkg.insert_row (

970: l_error_text := NULL;
971:
972: ELSE
973: l_rowid := NULL;
974: igs_ad_spl_interests_pkg.insert_row (
975: x_rowid => l_rowid,
976: x_spl_interest_id => l_spl_int_id ,
977: x_person_id => l_spl_intrst_rec.person_id ,
978: x_admission_appl_number => l_spl_intrst_rec.admission_appl_number ,