[Home] [Help]
861: course_cd ,
862: sequence_number ,
863: tracking_id
864: FROM
865: igs_ad_aplins_admreq
866: WHERE
867: person_id = cp_person_id and
868: course_cd = cp_nominated_course_cd and
869: sequence_number = cp_sequence_number and
1123:
1124:
1125: FOR c_tracking_rec IN c_tracking_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1126: l_last_error := 'IGS_AD_CHILD_TRACK';
1127: IGS_AD_APLINS_ADMREQ_pkg.INSERT_ROW(
1128: X_ROWID => l_rowid,
1129: X_APLINS_ADMREQ_ID => l_primary_key,
1130: X_PERSON_ID => c_tracking_rec.person_id,
1131: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,