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_IMP_OFF_RESP_DATA dependencies on IGS_AD_APPL_ALL

Line 203: appl_rec IN igs_ad_appl_all%ROWTYPE,

199: p_status IN igs_ad_offresp_int.status%TYPE ,
200: p_prpsd_commencement_date IN igs_ad_offresp_int.prpsd_commencement_date%TYPE,
201: p_adm_offer_defr_status OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
202: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
203: appl_rec IN igs_ad_appl_all%ROWTYPE,
204: acaiv_rec IN cur_ad_ps_appl_inst%ROWTYPE,
205: p_yes_no IN VARCHAR2,
206: p_validation_success OUT NOCOPY VARCHAR2) IS
207: ---------------------------------------------------------------------------------------------------------------------------------------

Line 297: CURSOR c_valid_adm_cals( cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,

293: acad_ciav.cal_type asc
294: ,acad_ciav.start_dt desc;
295:
296: --Cursor to select the valid Deferred Admission Calendars for the given Academic Calendar
297: CURSOR c_valid_adm_cals( cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
298: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
299: cp_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
300: cp_def_acad_ci_seq_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
301: cp_adm_ci_end_dt igs_ca_inst.end_dt%TYPE

Line 298: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE,

294: ,acad_ciav.start_dt desc;
295:
296: --Cursor to select the valid Deferred Admission Calendars for the given Academic Calendar
297: CURSOR c_valid_adm_cals( cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
298: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
299: cp_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
300: cp_def_acad_ci_seq_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
301: cp_adm_ci_end_dt igs_ca_inst.end_dt%TYPE
302: ) IS

Line 340: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,

336: AND nominated_course_cd = p_nominated_course_cd
337: AND sequence_number = p_sequence_number;
338:
339: -- Following cursors added as part of Single Response build Bug:3132406
340: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
341: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
342: SELECT admprd.single_response_flag
343: FROM igs_ad_prd_ad_prc_ca admprd,
344: igs_ad_appl_all appl,

Line 341: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS

337: AND sequence_number = p_sequence_number;
338:
339: -- Following cursors added as part of Single Response build Bug:3132406
340: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
341: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
342: SELECT admprd.single_response_flag
343: FROM igs_ad_prd_ad_prc_ca admprd,
344: igs_ad_appl_all appl,
345: igs_ad_ps_appl_inst_all aplinst

Line 344: igs_ad_appl_all appl,

340: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
341: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
342: SELECT admprd.single_response_flag
343: FROM igs_ad_prd_ad_prc_ca admprd,
344: igs_ad_appl_all appl,
345: igs_ad_ps_appl_inst_all aplinst
346: WHERE appl.person_id = p_person_id
347: AND appl.admission_appl_number = p_admission_appl_number
348: AND appl.person_id = aplinst.person_id

Line 358: FROM igs_ad_appl_all appl,

354:
355:
356: CURSOR get_aplinst_response_accepted IS
357: SELECT distinct appl.application_id, aplinst.nominated_course_cd
358: FROM igs_ad_appl_all appl,
359: igs_ad_ps_appl_inst aplinst,
360: igs_ad_prd_ad_prc_ca admprd
361: WHERE appl.person_id = aplinst.person_id
362: AND appl.admission_appl_number = aplinst.admission_appl_number

Line 416: l_application_id igs_ad_appl_all.application_id%TYPE;

412: v_appl_dt igs_ad_appl.appl_dt%TYPE;
413: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
414: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
415: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
416: l_application_id igs_ad_appl_all.application_id%TYPE;
417: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
418: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
419: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
420:

Line 956: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,

952: igs_ad_offresp_int ofresp
953: WHERE
954: ofresp.offresp_int_id = p_offresp_id;
955:
956: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
957: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
958: SELECT appl.*
959: FROM igs_ad_appl_all appl
960: WHERE person_id = cp_person_id AND

Line 957: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

953: WHERE
954: ofresp.offresp_int_id = p_offresp_id;
955:
956: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
957: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
958: SELECT appl.*
959: FROM igs_ad_appl_all appl
960: WHERE person_id = cp_person_id AND
961: admission_appl_number = cp_admission_appl_number;

Line 959: FROM igs_ad_appl_all appl

955:
956: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
957: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
958: SELECT appl.*
959: FROM igs_ad_appl_all appl
960: WHERE person_id = cp_person_id AND
961: admission_appl_number = cp_admission_appl_number;
962:
963: --Cursor to check if there is any Pending or Error interface Offer Response record is present in IGS_AD_OFFRESP_INT;

Line 985: l_appl_rec igs_ad_appl_all%ROWTYPE;

981: l_processed_Rec_Stat igs_ad_offresp_int.status%TYPE;
982: l_adm_offer_defr_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE;
983: l_validation_success VARCHAR2(1);
984: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
985: l_appl_rec igs_ad_appl_all%ROWTYPE;
986: l_calc_actual_ofr_resp_dt igs_ad_offresp_int.actual_offer_response_dt%TYPE;
987: l_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE;
988: l_conc_description fnd_concurrent_programs_vl.description%TYPE;
989: l_space_string VARCHAR2(300);