APPS.IGS_EN_SUA_API dependencies on IGS_PS_USEC_LIM_WLST

Line 69: FROM igs_ps_usec_lim_wlst usec,

65: ***************************************************************/
66:
67: CURSOR c_usec_lim (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
68: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,999999) ) enrollment_maximum
69: FROM igs_ps_usec_lim_wlst usec,
70: igs_ps_unit_ver uv,
71: igs_ps_unit_ofr_opt uoo
72: WHERE uoo.unit_cd = uv.unit_cd
73: AND uoo.version_number = uv.version_number

Line 81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v

77: --
78: -- The following three cursors added as part of the bug 2375362. pmarada
79: -- getting maximum students per waitlist in the unit section level.
80: CURSOR c_max_std_per_wait_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v
82: WHERE uoo_id = cp_uoo_id;
83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;
84:
85: -- Getting the maximum students per waitlist from unit offering pattern level.

Line 83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;

79: -- getting maximum students per waitlist in the unit section level.
80: CURSOR c_max_std_per_wait_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v
82: WHERE uoo_id = cp_uoo_id;
83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;
84:
85: -- Getting the maximum students per waitlist from unit offering pattern level.
86: CURSOR c_max_std_per_wait_uofr_pat (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
87: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

Line 112: FROM IGS_PS_USEC_LIM_WLST

108: -- end of the added three cursors. pmarada
109: -- Cursor to Check if Waitlisting is allowed at the unit section level .
110: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
111: SELECT waitlist_allowed
112: FROM IGS_PS_USEC_LIM_WLST
113: WHERE uoo_id = cp_uoo_id ;
114: --
115: -- Cursor Check if Waitlisting is allowed at the unit offering level .
116: --

Line 192: v_enr_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;

188: AND ucls.class_meet_group_id = l_class_meet_group_id
189: AND uoo.unit_section_status <> l_unit_section_status;
190:
191:
192: v_enr_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
193: v_max_std_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;
194: lv_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ;
195: l_waitlist_allowed IGS_PS_UNIT_OFR_PAT.waitlist_allowed%TYPE ;
196: l_cross_listed_row c_cross_listed%ROWTYPE;

Line 193: v_max_std_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;

189: AND uoo.unit_section_status <> l_unit_section_status;
190:
191:
192: v_enr_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
193: v_max_std_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;
194: lv_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ;
195: l_waitlist_allowed IGS_PS_UNIT_OFR_PAT.waitlist_allowed%TYPE ;
196: l_cross_listed_row c_cross_listed%ROWTYPE;
197: l_meet_with_cls_row c_meet_with_cls%ROWTYPE;

Line 580: FROM igs_ps_usec_lim_wlst

576:
577: --Cursor to check the maximum audit enrollments for a unit section
578: CURSOR c_max_auditors_allowed(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
579: SELECT max_auditors_allowed
580: FROM igs_ps_usec_lim_wlst
581: WHERE uoo_id = cp_uoo_id;
582: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
583:
584: --Cursor to get the count of audit attempts

Line 582: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;

578: CURSOR c_max_auditors_allowed(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
579: SELECT max_auditors_allowed
580: FROM igs_ps_usec_lim_wlst
581: WHERE uoo_id = cp_uoo_id;
582: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
583:
584: --Cursor to get the count of audit attempts
585: CURSOR c_audit_attempts_count(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
586: SELECT count(*)