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_GEN_015 dependencies on IGS_PS_UNIT_OFR_OPT

Line 280: FROM igs_ps_unit_ofr_opt

276: SELECT unit_cd,
277: version_number,
278: cal_type,
279: ci_sequence_number
280: FROM igs_ps_unit_ofr_opt
281: WHERE uoo_id = p_uoo_id;
282: --
283: -- Local Variables for the function validation_step_is_overridden:
284: --

Line 478: igs_ps_unit_ofr_opt uoo

474: SELECT NVL (usec.enrollment_maximum, uv.enrollment_maximum) enrollment_maximum,
475: uoo.enrollment_actual enrollment_actual
476: FROM igs_ps_usec_lim_wlst usec,
477: igs_ps_unit_ver uv,
478: igs_ps_unit_ofr_opt uoo
479: WHERE uoo.unit_cd = uv.unit_cd
480: AND uoo.version_number = uv.version_number
481: AND uoo.uoo_id = usec.uoo_id (+)
482: AND uoo.uoo_id = p_uoo_id;

Line 490: FROM igs_ps_unit_ofr_opt

486: CURSOR cur_org_priorities IS
487: SELECT rsv_org_unit_pri_id
488: FROM igs_ps_rsv_ogpri
489: WHERE org_unit_cd = (SELECT owner_org_unit_cd
490: FROM igs_ps_unit_ofr_opt
491: WHERE uoo_id = p_uoo_id);
492: --
493: -- Cursor to find all the Organization Preferences for the passed Organization Priority.
494: --

Line 516: FROM igs_ps_unit_ofr_opt

512: ci_sequence_number) = (SELECT unit_cd,
513: version_number,
514: cal_type,
515: ci_sequence_number
516: FROM igs_ps_unit_ofr_opt
517: WHERE uoo_id = p_uoo_id);
518: --
519: -- Cursor to find all the Unit Offering Pattern Preferences for the passed Unit Offering
520: -- Pattern Priority.

Line 690: CURSOR c_unit_section_status (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

686: ------------------------------------------------------------------------------------------------------------------*/
687: --
688: -- Cursor to find the Unit Section Status,Actual Enrollment,Actual Waitlist and Reserve seating allowed indicator
689: --
690: CURSOR c_unit_section_status (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
691: SELECT unit_section_status,enrollment_actual, waitlist_actual,reserved_seating_allowed
692: FROM igs_ps_unit_ofr_opt
693: WHERE uoo_id = cp_uoo_id;
694:

Line 692: FROM igs_ps_unit_ofr_opt

688: -- Cursor to find the Unit Section Status,Actual Enrollment,Actual Waitlist and Reserve seating allowed indicator
689: --
690: CURSOR c_unit_section_status (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
691: SELECT unit_section_status,enrollment_actual, waitlist_actual,reserved_seating_allowed
692: FROM igs_ps_unit_ofr_opt
693: WHERE uoo_id = cp_uoo_id;
694:
695: -- cursor to fetch the override enrollment maximum value defined at unit level
696: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 696: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

692: FROM igs_ps_unit_ofr_opt
693: WHERE uoo_id = cp_uoo_id;
694:
695: -- cursor to fetch the override enrollment maximum value defined at unit level
696: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
697: SELECT override_enrollment_max, enrollment_maximum
698: FROM igs_ps_unit_ver
699: WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
700: FROM igs_ps_unit_ofr_opt

Line 700: FROM igs_ps_unit_ofr_opt

696: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
697: SELECT override_enrollment_max, enrollment_maximum
698: FROM igs_ps_unit_ver
699: WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
700: FROM igs_ps_unit_ofr_opt
701: WHERE uoo_id = p_uoo_id);
702:
703: -- Cursor to fetch the Override enrollment Maximum value defined at Unit Section level
704: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 704: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

700: FROM igs_ps_unit_ofr_opt
701: WHERE uoo_id = p_uoo_id);
702:
703: -- Cursor to fetch the Override enrollment Maximum value defined at Unit Section level
704: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
705: SELECT override_enrollment_max, enrollment_maximum
706: FROM igs_ps_usec_lim_wlst
707: WHERE uoo_id = p_uoo_id;
708:

Line 717: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

713: course_cd = p_course_cd;
714:
715:
716: -- Cursor to get the enrollment maximum in cross listed group
717: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
718: SELECT grp.max_enr_group, grp.max_ovr_group, grpmem.usec_x_listed_group_id
719: FROM igs_ps_usec_x_grpmem grpmem,
720: igs_ps_usec_x_grp grp
721: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id

Line 726: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

722: AND grpmem.uoo_id = l_uoo_id;
723:
724:
725: -- Cursor to get the enrollment maximum in Meet with class group
726: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
727: SELECT grp.max_enr_group, grp.max_ovr_group, ucm.class_meet_group_id
728: FROM igs_ps_uso_clas_meet ucm,
729: igs_ps_uso_cm_grp grp
730: WHERE grp.class_meet_group_id = ucm.class_meet_group_id

Line 738: FROM igs_ps_unit_ofr_opt uoo,

734: -- Cursor to get the actual enrollment of all the unit sections that belong
735: -- to this class listed group.
736: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
737: SELECT SUM(enrollment_actual)
738: FROM igs_ps_unit_ofr_opt uoo,
739: igs_ps_usec_x_grpmem ugrp
740: WHERE uoo.uoo_id = ugrp.uoo_id
741: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
742:

Line 748: FROM igs_ps_unit_ofr_opt uoo,

744: -- Cursor to get the actual enrollment of all the unit sections that belong
745: -- to this meet with class group.
746: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
747: SELECT SUM(enrollment_actual)
748: FROM igs_ps_unit_ofr_opt uoo,
749: igs_ps_uso_clas_meet ucls
750: WHERE uoo.uoo_id = ucls.uoo_id
751: AND ucls.class_meet_group_id = l_class_meet_group_id;
752:

Line 767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;

763: l_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE;
764: l_version_number igs_ps_ver.version_number%TYPE;
765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;
766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;
767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
768: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE;
769: l_rsv_allowed VARCHAR2(10);
770: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
771: l_enr_cal_type VARCHAR2(20);

Line 768: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE;

764: l_version_number igs_ps_ver.version_number%TYPE;
765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;
766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;
767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
768: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE;
769: l_rsv_allowed VARCHAR2(10);
770: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
771: l_enr_cal_type VARCHAR2(20);
772: l_enr_ci_seq NUMBER(20);

Line 816: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

812: WHERE cal_type = cp_cal_type;
813: --
814: -- Cursor to Check if Waitlisting is allowed at the unit section level .
815: --
816: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
817: SELECT waitlist_allowed , max_students_per_waitlist
818: FROM igs_ps_usec_lim_wlst
819: WHERE uoo_id = cp_uoo_id ;
820: --

Line 823: CURSOR c_wait_allow_unit_offering ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

819: WHERE uoo_id = cp_uoo_id ;
820: --
821: -- cursor check if waitlisting is allowed at the unit offering level .
822: --
823: CURSOR c_wait_allow_unit_offering ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
824: SELECT uop.waitlist_allowed, uop.max_students_per_waitlist
825: FROM igs_ps_unit_ofr_pat uop,
826: igs_ps_unit_ofr_opt uoo
827: WHERE uop.unit_cd = uoo.unit_cd

Line 826: igs_ps_unit_ofr_opt uoo

822: --
823: CURSOR c_wait_allow_unit_offering ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
824: SELECT uop.waitlist_allowed, uop.max_students_per_waitlist
825: FROM igs_ps_unit_ofr_pat uop,
826: igs_ps_unit_ofr_opt uoo
827: WHERE uop.unit_cd = uoo.unit_cd
828: AND uop.version_number = uoo.version_number
829: AND uop.cal_type = uoo.cal_type
830: AND uop.ci_sequence_number = uoo.ci_sequence_number

Line 1497: FROM IGS_PS_UNIT_OFR_OPT

1493: SELECT unit_cd,
1494: version_number,
1495: cal_type,
1496: ci_sequence_number
1497: FROM IGS_PS_UNIT_OFR_OPT
1498: WHERE uoo_id = p_uoo_id;
1499:
1500: -- Cursor to get the Load Calendar of the given Teach Calendar.
1501: CURSOR cur_load_dtl_of_uoo_id (p_cal_type IGS_CA_TYPE.cal_type%TYPE , p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

Line 1999: FROM igs_ps_unit_ofr_opt

1995: -- smaddali 8-mar-06 Modified for bug#5091847
1996: -------------------------------------------------------------------------------------
1997: CURSOR cur_chk_sp_allowed( p_uoo_id NUMBER) IS
1998: SELECT special_permission_ind, cal_type, ci_sequence_number
1999: FROM igs_ps_unit_ofr_opt
2000: WHERE uoo_id = p_uoo_id;
2001:
2002: CURSOR cur_sp_exists( p_person_id NUMBER, p_uoo_id NUMBER) IS
2003: SELECT approval_status, Transaction_type

Line 2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;

2027:
2028:
2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;
2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;

Line 2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;

2028:
2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;
2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;

Line 2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;
2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

Line 2302: FROM igs_ps_unit_ofr_opt

2298: -- smaddali 8-mar-06 Modified for bug#5091847
2299: -------------------------------------------------------------------------------------
2300: CURSOR c_chk_audit_allowed( p_uoo_id NUMBER) IS
2301: SELECT NVL(auditable_ind, 'N'), NVL(audit_permission_ind, 'N')
2302: FROM igs_ps_unit_ofr_opt
2303: WHERE uoo_id = p_uoo_id;
2304:
2305:
2306: CURSOR c_audit_perm_exists( p_person_id NUMBER, p_uoo_id NUMBER) IS

Line 2366: v_ap_allowed igs_ps_unit_ofr_opt.AUDITABLE_IND%TYPE;

2362: eru.enr_method_type = cp_enr_method AND
2363: ( eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL' )
2364: ORDER BY eru.step_order_num;
2365:
2366: v_ap_allowed igs_ps_unit_ofr_opt.AUDITABLE_IND%TYPE;
2367: v_ap_required igs_ps_unit_ofr_opt.AUDIT_PERMISSION_IND%TYPE;
2368: v_staff_step_def_rec c_staff_step_def%ROWTYPE;
2369: v_stud_step_def_rec c_stud_step_def%ROWTYPE;
2370: v_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE;

Line 2367: v_ap_required igs_ps_unit_ofr_opt.AUDIT_PERMISSION_IND%TYPE;

2363: ( eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL' )
2364: ORDER BY eru.step_order_num;
2365:
2366: v_ap_allowed igs_ps_unit_ofr_opt.AUDITABLE_IND%TYPE;
2367: v_ap_required igs_ps_unit_ofr_opt.AUDIT_PERMISSION_IND%TYPE;
2368: v_staff_step_def_rec c_staff_step_def%ROWTYPE;
2369: v_stud_step_def_rec c_stud_step_def%ROWTYPE;
2370: v_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE;
2371: v_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;