eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AD_OFFRESP_STATUS_WF dependencies on IGS_AD_APPL

Line 187: CURSOR get_single_response (p_person_id igs_ad_appl_all.person_id%TYPE,

183: FROM igs_ca_inst
184: WHERE cal_type = p_cal_type
185: AND sequence_number = p_sequence_number;
186:
187: CURSOR get_single_response (p_person_id igs_ad_appl_all.person_id%TYPE,
188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag

Line 188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,

184: WHERE cal_type = p_cal_type
185: AND sequence_number = p_sequence_number;
186:
187: CURSOR get_single_response (p_person_id igs_ad_appl_all.person_id%TYPE,
188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,

Line 189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,

185: AND sequence_number = p_sequence_number;
186:
187: CURSOR get_single_response (p_person_id igs_ad_appl_all.person_id%TYPE,
188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,
193: igs_ad_appl_all appl,

Line 190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS

186:
187: CURSOR get_single_response (p_person_id igs_ad_appl_all.person_id%TYPE,
188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,
193: igs_ad_appl_all appl,
194: igs_ad_ps_appl_inst_all aplinst

Line 193: igs_ad_appl_all appl,

189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,
193: igs_ad_appl_all appl,
194: igs_ad_ps_appl_inst_all aplinst
195: WHERE appl.person_id = p_person_id
196: AND appl.admission_appl_number = p_admission_appl_number
197: AND appl.person_id = aplinst.person_id

Line 219: v_admission_cat igs_ad_appl.admission_cat%TYPE;

215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

Line 220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

Line 221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

Line 222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;

218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

Line 223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;

Line 224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

Line 225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

Line 226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

222: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
230: l_single_response_flag VARCHAR2(1);

Line 227: v_appl_dt igs_ad_appl.appl_dt%TYPE;

223: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
230: l_single_response_flag VARCHAR2(1);
231: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;

Line 228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

224: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
230: l_single_response_flag VARCHAR2(1);
231: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
232: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;

Line 229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

225: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
226: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
227: v_appl_dt igs_ad_appl.appl_dt%TYPE;
228: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
230: l_single_response_flag VARCHAR2(1);
231: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
232: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
233: l_new_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;