[Home] [Help]
32: Known limitations,enhancements,remarks:
33: Change History
34: Who When What
35: --smaddali ,bug2643048 UCFD102 build. Modified procedure to add check for igs_uc_defaults.system_code
36: -- and modified insert row of igs_ad_apl_int to insert values for columns alt_appl_id and admission_application_type
37: -- and to get the admission and academic calendars set up in igs_uc_defaults for the application choice system
38: --pmarada 22-aug-2003 REmoved the insert row call to igs_ad_stat_int table, this is not required.bug 3094409
39: --jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code
40: --jchakrab 10-Oct-2005 Modified for 4424068 - added CANCEL functionality for prog version change
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;
60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;
61:
62: -- Get the admission application corresponding to the passed choice record
63: -- Smaddali modified this cursor to add check for c.alt_appl_id , bug 2643048 UCFD012
125: c_int_id_rec c_int_id%ROWTYPE;
126:
127: -- Get application interface ID
128: CURSOR c_int_appl_id IS
129: SELECT igs_ad_apl_int_s.NEXTVAL int_appl_id
130: FROM dual;
131: c_int_appl_id_rec c_int_appl_id%ROWTYPE;
132: -- Get application instance interface id
133: CURSOR c_appl_inst_int_id IS
465: FETCH c_int_appl_id INTO c_int_appl_id_rec;
466: CLOSE c_int_appl_id;
467:
468: -- smaddali added new columns admission_application_type and alt_appl_id for bug 2643048
469: INSERT INTO igs_ad_apl_int
470: ( interface_appl_id
471: ,interface_id
472: ,appl_dt
473: ,acad_cal_type
2260: CURSOR c_appl_int( cp_batch_id igs_uc_app_choices.batch_id%TYPE,
2261: cp_app_no igs_uc_app_choices.app_no%TYPE ,
2262: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
2263: SELECT a.interface_id -- if application details import fails
2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2265: igs_uc_app_choices ch , igs_uc_applicants ap
2266: WHERE a.batch_id = cp_batch_id AND
2267: a.interface_id = b.interface_id AND
2268: b.choice_number = ch.choice_no AND
2274: ch.app_no = cp_app_no AND
2275: ch.choice_no = cp_choice_no
2276: UNION -- if person or person details import fail
2277: SELECT a.interface_id
2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2279: igs_uc_app_choices ch , igs_uc_applicants ap
2280: WHERE a.batch_id = cp_batch_id AND
2281: a.interface_id = b.interface_id AND
2282: b.choice_number = ch.choice_no AND