APPS.IGS_AD_IMP_010 dependencies on IGS_AD_APPL_NOTES

Line 157: igs_ad_appl_notes_pkg.INSERT_ROW(

153: BEGIN
154: SAVEPOINT before_create;
155: l_msg_at_index := igs_ge_msg_stack.count_msg;
156:
157: igs_ad_appl_notes_pkg.INSERT_ROW(
158: X_ROWID => l_Rowid,
159: X_APPL_NOTES_ID => l_Appl_Notes_Id,
160: x_Person_Id => notes_rec.person_id,
161: X_Admission_Appl_Number => notes_rec.Admission_Appl_Number,

Line 277: FROM igs_ad_appl_notes mn_rec

273: , error_text = cst_et_val_E678
274: WHERE interface_run_id = p_interface_run_id
275: AND status = cst_s_val_2
276: AND EXISTS ( SELECT 1
277: FROM igs_ad_appl_notes mn_rec
278: WHERE mn_rec.person_id = in_rec.person_id
279: AND mn_rec.admission_appl_number = in_rec.admission_appl_number
280: AND mn_rec.nominated_course_cd = in_rec.nominated_course_cd
281: AND mn_rec.note_type_id = in_rec.note_type_id