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

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 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