APPS.IGS_EN_SUA_API dependencies on IGS_PS_USEC_X_GRP

Line 128: FROM igs_ps_usec_x_grpmem grpmem,

124:
125: -- Cursor to check whether the unit section belongs to any cross listed group or not.
126: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
127: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
128: FROM igs_ps_usec_x_grpmem grpmem,
129: igs_ps_usec_x_grp grp
130: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
131: AND grpmem.uoo_id = l_uoo_id;
132:

Line 129: igs_ps_usec_x_grp grp

125: -- Cursor to check whether the unit section belongs to any cross listed group or not.
126: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
127: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
128: FROM igs_ps_usec_x_grpmem grpmem,
129: igs_ps_usec_x_grp grp
130: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
131: AND grpmem.uoo_id = l_uoo_id;
132:
133: -- Cursor to check whether the unit section belongs to any Meet With Class or not.

Line 145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

141:
142: -- Cursor to get the Actual enrollment of all the unit sections that
143: -- belong to the class listed group.
144: CURSOR c_actual_enr_crs_lst(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
146: SELECT SUM(enrollment_actual)
147: FROM igs_ps_unit_ofr_opt uoo,
148: igs_ps_usec_x_grpmem ugrp
149: WHERE uoo.uoo_id = ugrp.uoo_id

Line 148: igs_ps_usec_x_grpmem ugrp

144: CURSOR c_actual_enr_crs_lst(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
146: SELECT SUM(enrollment_actual)
147: FROM igs_ps_unit_ofr_opt uoo,
148: igs_ps_usec_x_grpmem ugrp
149: WHERE uoo.uoo_id = ugrp.uoo_id
150: AND ugrp.uoo_id <> l_uoo_id
151: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
152:

Line 168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,

164:
165:
166: -- Cursor to get the unit section details that belongs to the cross listed group.
167: CURSOR c_cross_lst_details(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
169: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
170: SELECT uoo.rowid, uoo.*
171: FROM igs_ps_unit_ofr_opt uoo,
172: igs_ps_usec_x_grpmem ugrp

Line 172: igs_ps_usec_x_grpmem ugrp

168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
169: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
170: SELECT uoo.rowid, uoo.*
171: FROM igs_ps_unit_ofr_opt uoo,
172: igs_ps_usec_x_grpmem ugrp
173: WHERE uoo.uoo_id = ugrp.uoo_id
174: AND ugrp.uoo_id <> l_uoo_id
175: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id
176: AND uoo.unit_section_status <> l_unit_section_status;

Line 199: v_grp_max igs_ps_usec_x_grp.max_enr_group%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;
198: l_usec_partof_group BOOLEAN;
199: v_grp_max igs_ps_usec_x_grp.max_enr_group%TYPE;
200: v_grp_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
201: l_setup_found NUMBER;
202: l_dir_enr igs_ps_unit_ofr_opt_all.dir_enrollment%TYPE;
203: l_enr_from_wlst igs_ps_unit_ofr_opt_all.enr_from_wlst%TYPE ;