[Home] [Help]
852: c.adm_cal_type = l_adm_cal_type AND
853: c.adm_ci_sequence_number = l_adm_seq_no AND
854: b.app_no = cp_app_no AND
855: b.choice_no = cp_choice_no AND
856: igs_ad_gen_007.Admp_Get_Saas(c.adm_appl_status) <> 'COMPLETED';
857: c_match_adm_appl_rec c_match_adm_appl%ROWTYPE ;
858:
859: -- Get the admission application instance corresponding to the passed application choice
860: -- smaddali added unit set cd and version number parameters and in where clause using these parameters ,bug2630219
924: e.unit_set_cd = cp_unit_set_cd AND
925: e.us_version_number = cp_us_version_number AND
926: b.app_no = cp_app_no AND
927: b.choice_no = cp_choice_no AND
928: igs_ad_gen_007.Admp_Get_Saas(c.adm_appl_status) = 'RECEIVED' AND
929: igs_ad_gen_008.Admp_Get_Saos(e.adm_outcome_status) IN ('PENDING','SUSPEND');
930: c_cancel_appl_rec c_cancel_appl%ROWTYPE;
931:
932:
1115: AND apl.admission_appl_number = aplps.admission_appl_number
1116: AND aplps.person_id = aplinst.person_id
1117: AND aplps.admission_appl_number = aplinst.admission_appl_number
1118: AND aplps.nominated_course_cd = aplinst.nominated_course_cd
1119: AND igs_ad_gen_007.admp_get_saas(apl.adm_appl_status) = 'COMPLETED'
1120: AND igs_ad_gen_008.Admp_Get_Saos(aplinst.adm_outcome_status) <> 'CANCELLED';
1121: cur_comp_app_choice_rec cur_comp_app_choice%ROWTYPE;
1122:
1123: -- Cursor to find any change in the UCAS Application Choice with the OSS Admission