APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_PS_APPL_INST_INT

Line 60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%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
64: CURSOR c_match_adm_appl(cp_app_no igs_uc_app_choices.app_no%TYPE ,

Line 134: SELECT igs_ad_ps_appl_inst_int_s.NEXTVAL appl_inst_int_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
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

Line 544: INSERT INTO igs_ad_ps_appl_inst_int

540: l_update_adm_seq_number := c_match_adm_appl_inst_rec.sequence_number ;
541: END IF ;
542: CLOSE c_match_adm_appl_inst ;
543:
544: INSERT INTO igs_ad_ps_appl_inst_int
545: ( interface_appl_id
546: ,interface_ps_appl_inst_id
547: ,nominated_course_cd
548: ,req_for_adv_standing_ind

Line 2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

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

Line 2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

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