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.

APPS.IGS_AD_OFFRESP_STATUS_WF dependencies on IGS_AD_APPL_ALL

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