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_CA_INST

Line 180: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,

176: SELECT person_number, full_name
177: FROM igs_pe_person_base_v
178: WHERE person_id = p_person_id;
179:
180: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
181: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
182: SELECT alternate_code
183: FROM igs_ca_inst
184: WHERE cal_type = p_cal_type

Line 181: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS

177: FROM igs_pe_person_base_v
178: WHERE person_id = p_person_id;
179:
180: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
181: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
182: SELECT alternate_code
183: FROM igs_ca_inst
184: WHERE cal_type = p_cal_type
185: AND sequence_number = p_sequence_number;

Line 183: FROM igs_ca_inst

179:
180: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
181: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
182: SELECT alternate_code
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,

Line 231: l_acad_alt_code igs_ca_inst.alternate_code%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;
234:
235: BEGIN

Line 232: l_adm_alt_code igs_ca_inst.alternate_code%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;
234:
235: BEGIN
236: IF funcmode='RUN' THEN