724: IF c_get_pending_hist%FOUND THEN
725:
726: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
727:
728: igs_ad_ps_appl_inst_pkg.update_row (
729: X_ROWID => l_get_inst_dtls_rec.ROWID,
730: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
731: x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
732: x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
975: || 'Sequence Number: ' || RPAD(l_get_fut_appl_inst.SEQUENCE_NUMBER,6,' '));
976: l_get_application_id := NULL;
977: /* End Apadegal - 4747281 */
978:
979: igs_ad_ps_appl_inst_pkg.update_row (
980: X_ROWID => l_get_fut_appl_inst.ROWID,
981: x_PERSON_ID => l_get_fut_appl_inst.PERSON_ID,
982: x_ADMISSION_APPL_NUMBER => l_get_fut_appl_inst.ADMISSION_APPL_NUMBER,
983: x_NOMINATED_COURSE_CD => l_get_fut_appl_inst.NOMINATED_COURSE_CD,
1245: IF c_get_pending_hist%FOUND THEN
1246:
1247: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
1248:
1249: igs_ad_ps_appl_inst_pkg.update_row (
1250: X_ROWID => l_get_inst_dtls_rec.ROWID,
1251: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
1252: x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
1253: x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
1534: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(c_pend_fut_rec.NOMINATED_COURSE_CD,6,' ')
1535: || 'Sequence Number: ' || RPAD(c_pend_fut_rec.SEQUENCE_NUMBER,6,' '));
1536: l_get_application_id := NULL;
1537: /* End Apadegal - 4747281 */
1538: igs_ad_ps_appl_inst_pkg.update_row (
1539: X_ROWID => c_pend_fut_rec.ROWID,
1540: x_PERSON_ID => c_pend_fut_rec.PERSON_ID,
1541: x_ADMISSION_APPL_NUMBER => c_pend_fut_rec.ADMISSION_APPL_NUMBER,
1542: x_NOMINATED_COURSE_CD => c_pend_fut_rec.NOMINATED_COURSE_CD,