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_EN_WLST_GEN_PROC dependencies on IGS_PS_UOFR_WLST_PRI

Line 1050: CURSOR cur_wlst_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,

1046: WHERE uoo_id = cp_uoo_id;
1047: cur_get_teach_inst_rec cur_get_teach_inst%ROWTYPE;
1048:
1049: -- Cursor to select priorities at unit offering pattern level
1050: CURSOR cur_wlst_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1051: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1054: IS

Line 1051: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,

1047: cur_get_teach_inst_rec cur_get_teach_inst%ROWTYPE;
1048:
1049: -- Cursor to select priorities at unit offering pattern level
1050: CURSOR cur_wlst_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1051: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1054: IS
1055: SELECT unit_ofr_waitlist_priority_id, priority_value, priority_number

Line 1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,

1048:
1049: -- Cursor to select priorities at unit offering pattern level
1050: CURSOR cur_wlst_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1051: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1054: IS
1055: SELECT unit_ofr_waitlist_priority_id, priority_value, priority_number
1056: FROM igs_ps_uofr_wlst_pri

Line 1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)

1049: -- Cursor to select priorities at unit offering pattern level
1050: CURSOR cur_wlst_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1051: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1054: IS
1055: SELECT unit_ofr_waitlist_priority_id, priority_value, priority_number
1056: FROM igs_ps_uofr_wlst_pri
1057: WHERE unit_cd = cp_unit_cd

Line 1056: FROM igs_ps_uofr_wlst_pri

1052: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1053: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1054: IS
1055: SELECT unit_ofr_waitlist_priority_id, priority_value, priority_number
1056: FROM igs_ps_uofr_wlst_pri
1057: WHERE unit_cd = cp_unit_cd
1058: AND version_number = cp_version_number
1059: AND calender_type = cp_cal_type
1060: AND ci_sequence_number = cp_seq_no

Line 1072: CURSOR cur_max_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,

1068: WHERE unit_ofr_waitlist_priority_id = cp_priority_id
1069: ORDER BY preference_order;
1070:
1071: -- Cursor to select maximum number of priorities at unit offering pattern level
1072: CURSOR cur_max_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1073: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1076: IS

Line 1073: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,

1069: ORDER BY preference_order;
1070:
1071: -- Cursor to select maximum number of priorities at unit offering pattern level
1072: CURSOR cur_max_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1073: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1076: IS
1077: SELECT count(unit_ofr_waitlist_priority_id)

Line 1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,

1070:
1071: -- Cursor to select maximum number of priorities at unit offering pattern level
1072: CURSOR cur_max_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1073: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1076: IS
1077: SELECT count(unit_ofr_waitlist_priority_id)
1078: FROM igs_ps_uofr_wlst_pri

Line 1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)

1071: -- Cursor to select maximum number of priorities at unit offering pattern level
1072: CURSOR cur_max_uop_pri ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1073: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1076: IS
1077: SELECT count(unit_ofr_waitlist_priority_id)
1078: FROM igs_ps_uofr_wlst_pri
1079: WHERE unit_cd = cp_unit_cd

Line 1078: FROM igs_ps_uofr_wlst_pri

1074: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1075: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1076: IS
1077: SELECT count(unit_ofr_waitlist_priority_id)
1078: FROM igs_ps_uofr_wlst_pri
1079: WHERE unit_cd = cp_unit_cd
1080: AND version_number = cp_version_number
1081: AND calender_type = cp_cal_type
1082: AND ci_sequence_number = cp_seq_no;

Line 1086: CURSOR cur_max_uop_prf ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,

1082: AND ci_sequence_number = cp_seq_no;
1083: l_max_uop_pri NUMBER;
1084:
1085: -- Cursor to select maximum number of preferences among all the priorities at unit offering pattern level
1086: CURSOR cur_max_uop_prf ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1087: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1090: IS

Line 1087: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,

1083: l_max_uop_pri NUMBER;
1084:
1085: -- Cursor to select maximum number of preferences among all the priorities at unit offering pattern level
1086: CURSOR cur_max_uop_prf ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1087: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1090: IS
1091: SELECT count(unit_ofr_waitlist_pref_id)

Line 1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,

1084:
1085: -- Cursor to select maximum number of preferences among all the priorities at unit offering pattern level
1086: CURSOR cur_max_uop_prf ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1087: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1090: IS
1091: SELECT count(unit_ofr_waitlist_pref_id)
1092: FROM igs_ps_uofr_wlst_prf

Line 1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)

1085: -- Cursor to select maximum number of preferences among all the priorities at unit offering pattern level
1086: CURSOR cur_max_uop_prf ( cp_unit_cd igs_ps_uofr_wlst_pri.unit_cd%TYPE ,
1087: cp_version_number igs_ps_uofr_wlst_pri.version_number%TYPE ,
1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1090: IS
1091: SELECT count(unit_ofr_waitlist_pref_id)
1092: FROM igs_ps_uofr_wlst_prf
1093: WHERE unit_ofr_waitlist_priority_id IN(SELECT unit_ofr_waitlist_priority_id

Line 1094: FROM igs_ps_uofr_wlst_pri

1090: IS
1091: SELECT count(unit_ofr_waitlist_pref_id)
1092: FROM igs_ps_uofr_wlst_prf
1093: WHERE unit_ofr_waitlist_priority_id IN(SELECT unit_ofr_waitlist_priority_id
1094: FROM igs_ps_uofr_wlst_pri
1095: WHERE unit_cd = cp_unit_cd
1096: AND version_number = cp_version_number
1097: AND calender_type = cp_cal_type
1098: AND ci_sequence_number = cp_seq_no);