APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PS_USEC_WLST_PRI

Line 1008: CURSOR cur_wlst_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)

1004: --Who When What
1005: -------------------------------------------------------------------
1006: IS
1007: -- Cursor to select priorities at unit section level
1008: CURSOR cur_wlst_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1009: IS
1010: SELECT unit_sec_waitlist_priority_id, priority_value, priority_number
1011: FROM igs_ps_usec_wlst_pri
1012: WHERE uoo_id = cp_uoo_id

Line 1011: FROM igs_ps_usec_wlst_pri

1007: -- Cursor to select priorities at unit section level
1008: CURSOR cur_wlst_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1009: IS
1010: SELECT unit_sec_waitlist_priority_id, priority_value, priority_number
1011: FROM igs_ps_usec_wlst_pri
1012: WHERE uoo_id = cp_uoo_id
1013: ORDER BY priority_number;
1014:
1015: -- Cursor to select preferences for a given priority Id at unit section level

Line 1024: CURSOR cur_max_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)

1020: WHERE unit_sec_waitlist_priority_id = cp_priority_id
1021: ORDER BY preference_order;
1022:
1023: -- Cursor to select maximum number of priorities at unit section level
1024: CURSOR cur_max_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1025: IS
1026: SELECT count(unit_sec_waitlist_priority_id)
1027: FROM igs_ps_usec_wlst_pri
1028: WHERE uoo_id = cp_uoo_id;

Line 1027: FROM igs_ps_usec_wlst_pri

1023: -- Cursor to select maximum number of priorities at unit section level
1024: CURSOR cur_max_uoo_pri ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1025: IS
1026: SELECT count(unit_sec_waitlist_priority_id)
1027: FROM igs_ps_usec_wlst_pri
1028: WHERE uoo_id = cp_uoo_id;
1029: l_max_uoo_pri NUMBER;
1030:
1031: -- Cursor to select maximum number of preferences among all the priorities at unit section level

Line 1032: CURSOR cur_max_uoo_prf ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)

1028: WHERE uoo_id = cp_uoo_id;
1029: l_max_uoo_pri NUMBER;
1030:
1031: -- Cursor to select maximum number of preferences among all the priorities at unit section level
1032: CURSOR cur_max_uoo_prf ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1033: IS
1034: SELECT count(unit_sec_waitlist_pref_id)
1035: FROM igs_ps_usec_wlst_prf
1036: WHERE unit_sec_waitlist_priority_id IN(SELECT unit_sec_waitlist_priority_id

Line 1037: FROM igs_ps_usec_wlst_pri

1033: IS
1034: SELECT count(unit_sec_waitlist_pref_id)
1035: FROM igs_ps_usec_wlst_prf
1036: WHERE unit_sec_waitlist_priority_id IN(SELECT unit_sec_waitlist_priority_id
1037: FROM igs_ps_usec_wlst_pri
1038: WHERE uoo_id = cp_uoo_id);
1039: l_max_uoo_pref NUMBER;
1040:
1041: -- Cursor to get the unit code, version number and teaching calender associated with the unit section