1452: course_cd ,
1453: sequence_number ,
1454: tracking_id
1455: FROM
1456: igs_ad_aplins_admreq
1457: WHERE
1458: person_id = cp_person_id and
1459: course_cd = cp_nominated_course_cd and
1460: sequence_number = cp_sequence_number and
1871:
1872:
1873: 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
1874: l_last_error := 'IGS_AD_CHILD_TRACK';
1875: IGS_AD_APLINS_ADMREQ_pkg.INSERT_ROW(
1876: X_ROWID => l_rowid,
1877: X_APLINS_ADMREQ_ID => l_primary_key,
1878: X_PERSON_ID => c_tracking_rec.person_id,
1879: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,