[Home] [Help]
120: c_pe_person_rec c_pe_person%ROWTYPE;
121: -- Get the interface id
122: CURSOR c_int_id IS
123: SELECT igs_ad_interface_s.NEXTVAL int_id
124: FROM dual;
125: c_int_id_rec c_int_id%ROWTYPE;
126:
127: -- Get application interface ID
128: CURSOR c_int_appl_id IS
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
134: SELECT igs_ad_ps_appl_inst_int_s.NEXTVAL appl_inst_int_id
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
134: SELECT igs_ad_ps_appl_inst_int_s.NEXTVAL appl_inst_int_id
135: FROM dual;
136: appl_inst_int_id_rec c_appl_inst_int_id%ROWTYPE;
137: -- Get ucas application source from code classes
138: CURSOR cur_code_id IS
139: SELECT code_id
932:
933: -- Get the interface ctl ID
934: CURSOR c_interface_run_id IS
935: SELECT igs_ad_interface_ctl_s.NEXTVAL
936: FROM dual ;
937: l_interface_run_id NUMBER ;
938:
939: -- Get the application to be voided ,i.e the currently active application instance
940: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
2244:
2245: -- Get the Batch ID for admission application import process
2246: CURSOR c_bat_id IS
2247: SELECT igs_ad_interface_batch_id_s.NEXTVAL
2248: FROM dual;
2249:
2250: -- Get the Source type ID of UCAS for admission import process
2251: CURSOR c_src_type_id IS
2252: SELECT source_type_id