[Home] [Help]
1598: WHERE uoo_id=p_uooid;
1599: --Cursor to fetch the limits from Unit Section
1600: CURSOR cur_get_usec_maxmin_limits IS
1601: SELECT enrollment_minimum,enrollment_maximum
1602: FROM igs_ps_usec_lim_wlst_v
1603: WHERE uoo_id =p_uooid;
1604: --Cursor to fetch the limits for Unit Code
1605: CURSOR cur_get_unit_maxmin_limits IS
1606: SELECT enrollment_minimum,enrollment_maximum
1914: --Change History:
1915: --Who When What
1916: -- pradhakr 30-Dec-02 Changed the data type of the variable l_max from
1917: -- igs_ps_usec_x_grp.max_enr_group to
1918: -- igs_ps_usec_lim_wlst.enrollment_maximum.
1919: -------------------------------------------------------------------------------------
1920:
1921: -- Cursor to get the enrollment maximum in cross listed group
1922: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1964:
1965: -- Cursor to fetch the enrollment Maximum value defined at Unit Section level
1966: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1967: SELECT enrollment_maximum
1968: FROM igs_ps_usec_lim_wlst
1969: WHERE uoo_id = p_uoo_id;
1970:
1971: -- cursor to fetch the enrollment maximum value defined at unit level
1972: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1985: WHERE uoo_id = cp_uoo_id;
1986:
1987:
1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;
1989: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
1990: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
1991: l_total_enrollment NUMBER;
1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;
1993: l_meet_meaning igs_lookups_view.meaning%TYPE;
2885: IS
2886:
2887: Cursor c_check(cp_uoo_id NUMBER) IS
2888: select max_students_per_waitlist
2889: from igs_ps_usec_lim_wlst
2890: where uoo_id=cp_uoo_id;
2891:
2892: Cursor c_check2(cp_unit_cd VARCHAR2, cp_version NUMBER,
2893: cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS
2929: p_version IN NUMBER) RETURN NUMBER
2930: IS
2931: Cursor c_check1(cp_uooid NUMBER) IS
2932: select enrollment_maximum
2933: from igs_ps_usec_lim_wlst
2934: where uoo_id=cp_uooid;
2935:
2936: Cursor c_check2(cp_unit_cd VARCHAR2,
2937: cp_version NUMBER) IS
2939: from igs_ps_unit_ver
2940: where unit_cd=cp_unit_cd
2941: and version_number=cp_version;
2942:
2943: l_result igs_ps_usec_lim_wlst.enrollment_maximum%TYPE DEFAULT NULL;
2944: BEGIN
2945: OPEN c_check1(p_uooid);
2946: FETCH c_check1 INTO l_result;
2947: CLOSE c_check1;
2963: p_version IN NUMBER) RETURN NUMBER
2964: IS
2965: Cursor c_check1(cp_uooid NUMBER) IS
2966: select enrollment_minimum
2967: from igs_ps_usec_lim_wlst
2968: where uoo_id=cp_uooid;
2969:
2970: Cursor c_check2(cp_unit_cd VARCHAR2,
2971: cp_version NUMBER) IS
2973: from igs_ps_unit_ver
2974: where unit_cd=cp_unit_cd
2975: and version_number=cp_version;
2976:
2977: l_result igs_ps_usec_lim_wlst.enrollment_minimum%TYPE DEFAULT NULL;
2978: BEGIN
2979: OPEN c_check1(p_uooid);
2980: FETCH c_check1 INTO l_result;
2981: CLOSE c_check1;
3952:
3953: -- Cursor to fetch the enrollment Maximum value defined at Unit Section level
3954: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3955: SELECT enrollment_maximum
3956: FROM igs_ps_usec_lim_wlst
3957: WHERE uoo_id = p_uoo_id;
3958:
3959: -- cursor to fetch the enrollment maximum value defined at unit level
3960: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3971: SELECT enrollment_actual
3972: FROM igs_ps_unit_ofr_opt
3973: WHERE uoo_id = cp_uoo_id;
3974:
3975: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
3976: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
3977: l_setup_found NUMBER;
3978: l_cross_listed_row c_cross_listed%ROWTYPE;
3979: l_meet_with_cls_row c_meet_with_cls%ROWTYPE;