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.

APPS.IGS_EN_SUA_API dependencies on IGS_PS_USO_CLAS_MEET

Line 136: FROM igs_ps_uso_clas_meet ucm,

132:
133: -- Cursor to check whether the unit section belongs to any Meet With Class or not.
134: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
135: SELECT grp.max_enr_group, ucm.class_meet_group_id
136: FROM igs_ps_uso_clas_meet ucm,
137: igs_ps_uso_cm_grp grp
138: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
139: AND ucm.uoo_id = l_uoo_id;
140:

Line 157: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS

153:
154: -- Cursor to get the Actual enrollment of all the unit sections that
155: -- belong to the Meet With Class.
156: CURSOR c_actual_enr_meet_cls(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
157: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
158: SELECT SUM(enrollment_actual)
159: FROM igs_ps_unit_ofr_opt uoo,
160: igs_ps_uso_clas_meet ucls
161: WHERE uoo.uoo_id = ucls.uoo_id

Line 160: igs_ps_uso_clas_meet ucls

156: CURSOR c_actual_enr_meet_cls(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
157: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
158: SELECT SUM(enrollment_actual)
159: FROM igs_ps_unit_ofr_opt uoo,
160: igs_ps_uso_clas_meet ucls
161: WHERE uoo.uoo_id = ucls.uoo_id
162: AND ucls.uoo_id <> l_uoo_id
163: AND ucls.class_meet_group_id = l_class_meet_group_id;
164:

Line 181: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,

177:
178:
179: -- Cursor to get the unit section details that belongs to the Meet with class.
180: CURSOR c_meet_with_cls_details(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
181: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
182: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
183: SELECT uoo.rowid, uoo.*
184: FROM igs_ps_unit_ofr_opt_all uoo,
185: igs_ps_uso_clas_meet ucls

Line 185: igs_ps_uso_clas_meet ucls

181: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
182: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
183: SELECT uoo.rowid, uoo.*
184: FROM igs_ps_unit_ofr_opt_all uoo,
185: igs_ps_uso_clas_meet ucls
186: WHERE uoo.uoo_id = ucls.uoo_id
187: AND ucls.uoo_id <> l_uoo_id
188: AND ucls.class_meet_group_id = l_class_meet_group_id
189: AND uoo.unit_section_status <> l_unit_section_status;