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_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_PS_APPL

Line 73: IGS_AD_PS_APPL_INST_ALL APLINST,

69: IGS_UC_APPLICANTS UA,
70: IGS_UC_DEFAULTS UD,
71: IGS_AD_SS_APPL_TYP AAT,
72: IGS_AD_APPL_ALL APL,
73: IGS_AD_PS_APPL_INST_ALL APLINST,
74: IGS_UC_SYS_CALNDRS USC
75: WHERE UAC.APP_NO = CP_APP_NO
76: AND UAC.CHOICE_NO = CP_CHOICE_NO
77: AND UAC.UCAS_CYCLE = CP_UCAS_CYCLE

Line 105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,

101:
102: -- Check the existence of unit set code corresponding to the application instance
103: -- jchin - bug 3691277 and 3691250
104: CURSOR cur_unit_set_cd(
105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

Line 106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,

102: -- Check the existence of unit set code corresponding to the application instance
103: -- jchin - bug 3691277 and 3691250
104: CURSOR cur_unit_set_cd(
105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,

Line 107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

103: -- jchin - bug 3691277 and 3691250
104: CURSOR cur_unit_set_cd(
105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,

Line 108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,

104: CURSOR cur_unit_set_cd(
105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,

Line 110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,

106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
113: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
114: ) IS

Line 111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,

107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
113: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
114: ) IS
115: SELECT US.UNIT_SET_CD,

Line 112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,

108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
113: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
114: ) IS
115: SELECT US.UNIT_SET_CD,
116: US.VERSION_NUMBER US_VERSION_NUMBER

Line 221: -- from the Admission Application,igs_ad_ps_appl_all

217: WHERE adm_outcome_status = p_adm_out_status;
218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind

Line 222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,

218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all

Line 223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,

219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id

Line 224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS

220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id
228: AND admission_appl_number = p_admission_appl_number

Line 226: FROM igs_ad_ps_appl_all

222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id
228: AND admission_appl_number = p_admission_appl_number
229: AND nominated_course_cd = p_nominated_course_code;
230: cur_recons_flag_rec cur_recons_flag%ROWTYPE;

Line 349: l_reconsideration_flag igs_ad_ps_appl.req_for_reconsideration_ind%TYPE;

345: l_error_message fnd_new_messages.message_text%TYPE ;
346: l_description VARCHAR2(2000);
347:
348: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
349: l_reconsideration_flag igs_ad_ps_appl.req_for_reconsideration_ind%TYPE;
350:
351: --Record Type to hold the batch_id created for a system cycle calendars.
352: TYPE batch_det_type IS RECORD
353: ( system_code igs_uc_app_choices.system_code%TYPE,

Line 1502: IGS_AD_PS_APPL_INST_ALL APLINST,

1498: IGS_UC_APPLICANTS UA,
1499: IGS_UC_DEFAULTS UD,
1500: IGS_AD_SS_APPL_TYP AAT,
1501: IGS_AD_APPL_ALL APL,
1502: IGS_AD_PS_APPL_INST_ALL APLINST,
1503: IGS_UC_SYS_CALNDRS USC
1504: WHERE UAC.APP_NO = CP_APP_NO
1505: AND UAC.CHOICE_NO = CP_CHOICE_NO
1506: AND UAC.UCAS_CYCLE = CP_UCAS_CYCLE

Line 1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,

1530:
1531: -- jchin - bug 3691277 and 3691250
1532: -- new cursor Check the existence of unit set code corresponding to the application instance
1533: CURSOR cur_unit_set_cd(
1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

Line 1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,

1531: -- jchin - bug 3691277 and 3691250
1532: -- new cursor Check the existence of unit set code corresponding to the application instance
1533: CURSOR cur_unit_set_cd(
1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,

Line 1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

1532: -- new cursor Check the existence of unit set code corresponding to the application instance
1533: CURSOR cur_unit_set_cd(
1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,

Line 1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,

1533: CURSOR cur_unit_set_cd(
1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,

Line 1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,

1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
1542: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
1543: ) IS

Line 1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,

1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
1542: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
1543: ) IS
1544: SELECT US.UNIT_SET_CD,

Line 1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,

1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
1542: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE
1543: ) IS
1544: SELECT US.UNIT_SET_CD,
1545: US.VERSION_NUMBER US_VERSION_NUMBER