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_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;

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;
1994: l_cross_meaning igs_lookups_view.meaning%TYPE;
1995: l_usec_partof_group BOOLEAN;
1996: l_cat_enr_act varchar2(100);

Line 2726: IGS_PS_UNIT_OFR_OPT_ALL UOO

2722:
2723: CURSOR c_uop (cp_n_uoo_id IN NUMBER) IS
2724: SELECT 1
2725: FROM IGS_PS_UNT_OFR_PAT_N UOP,
2726: IGS_PS_UNIT_OFR_OPT_ALL UOO
2727: WHERE UOO.UNIT_CD = UOP.UNIT_CD
2728: AND UOO.VERSION_NUMBER = UOP.VERSION_NUMBER
2729: AND UOO.CAL_TYPE = UOP.CAL_TYPE
2730: AND UOO.CI_SEQUENCE_NUMBER = UOP.CI_SEQUENCE_NUMBER

Line 2737: IGS_PS_UNIT_OFR_OPT_ALL UOO

2733:
2734: CURSOR c_uo (cp_n_uoo_id IN NUMBER) IS
2735: SELECT 1
2736: FROM IGS_PS_UNIT_OFR_NOTE UO,
2737: IGS_PS_UNIT_OFR_OPT_ALL UOO
2738: WHERE UOO.UNIT_CD = UO.UNIT_CD
2739: AND UOO.VERSION_NUMBER = UO.VERSION_NUMBER
2740: AND UOO.CAL_TYPE = UO.CAL_TYPE
2741: AND UOO.UOO_ID = cp_n_uoo_id

Line 2747: IGS_PS_UNIT_OFR_OPT_ALL UOO

2743:
2744: CURSOR c_uv (cp_n_uoo_id IN NUMBER) IS
2745: SELECT 1
2746: FROM IGS_PS_UNIT_VER_NOTE UV,
2747: IGS_PS_UNIT_OFR_OPT_ALL UOO
2748: WHERE UOO.UNIT_CD = UV.UNIT_CD
2749: AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
2750: AND UOO.UOO_ID = cp_n_uoo_id
2751: AND ROWNUM < 2;

Line 3260: igs_ps_unit_ofr_opt_all US,

3256: DECODE(uso.sunday, 'Y', 'Su', NULL),'TBA') meetings,
3257: TO_CHAR(uso.start_time,'hh:miam') start_time,
3258: TO_CHAR(uso.end_time, 'hh:miam') end_time
3259: FROM igs_ps_usec_occurs_all USO,
3260: igs_ps_unit_ofr_opt_all US,
3261: igs_ca_inst_all CA
3262: WHERE uso.uoo_id = cp_n_uoo_id AND
3263: uso.uoo_id = us.uoo_id AND
3264: us.cal_type = ca.cal_type AND

Line 3305: FROM igs_ps_unit_ofr_opt_all us,

3301: FUNCTION get_dummy_data(p_n_uoo_id IN NUMBER) RETURN VARCHAR2 IS
3302: CURSOR c_uoo(cp_n_uoo_id IN NUMBER) IS
3303: SELECT NVL(us.unit_section_start_date,ca.start_dt) start_date,
3304: NVL(us.unit_section_end_date, ca.end_dt) end_date
3305: FROM igs_ps_unit_ofr_opt_all us,
3306: igs_ca_inst_all ca
3307: WHERE us.uoo_id = cp_n_uoo_id AND
3308: us.cal_type = ca.cal_type AND
3309: us.ci_sequence_number = ca.sequence_number;

Line 3397: FROM igs_ps_unit_ofr_opt_all us,

3393: WHERE t.uoo_id = cp_n_uoo_id;
3394:
3395: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
3396: SELECT uv.title
3397: FROM igs_ps_unit_ofr_opt_all us,
3398: igs_ps_unit_ver_all uv
3399: WHERE us.uoo_id = cp_n_uoo_id
3400: AND us.unit_cd = uv.unit_cd
3401: AND us.version_number = uv.version_number;

Line 3445: igs_ps_unit_ofr_opt_all uoo

3441: --cursor to look up the rule code in unit version rules
3442: CURSOR c_unit_ru(cp_n_uoo_id IN NUMBER, cp_c_rul_call_cd IN VARCHAR2) IS
3443: SELECT ru.rul_sequence_number
3444: FROM igs_ps_unit_ver_ru ru,
3445: igs_ps_unit_ofr_opt_all uoo
3446: WHERE uoo.uoo_id = p_n_uoo_id
3447: AND uoo.unit_cd = ru.unit_cd
3448: AND uoo.version_number = ru.version_number
3449: AND ru.s_rule_call_cd = cp_c_rul_call_cd;

Line 3542: FUNCTION get_billable_credit_points(p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE)

3538: return l_result;
3539:
3540: END get_apor_credits;
3541:
3542: FUNCTION get_billable_credit_points(p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE)
3543: RETURN NUMBER
3544: ------------------------------------------------------------------
3545: --Created by : rvangala
3546: --Date created: 24-May-2005

Line 3670: FROM igs_ps_unit_ofr_opt_all usec

3666: AS
3667: --cursor to check if special permission is setup at unit section level or at unit level
3668: CURSOR cur_usec_details ( cp_uoo_id NUMBER) IS
3669: SELECT NVL(usec.special_permission_ind,'N') special_permission_ind
3670: FROM igs_ps_unit_ofr_opt_all usec
3671: WHERE usec.uoo_id = cp_uoo_id;
3672:
3673:
3674: cur_usec_details_rec cur_usec_details %ROWTYPE;

Line 3713: FROM igs_ps_unit_ofr_opt_all usec

3709: --cursor to check if audit permission is setup at unit section level or at unit level
3710: CURSOR cur_usec_details ( cp_uoo_id NUMBER) IS
3711: SELECT NVL(usec.auditable_ind,'N') auditable_ind,
3712: NVL(usec.audit_permission_ind,'N') audit_permission_ind
3713: FROM igs_ps_unit_ofr_opt_all usec
3714: WHERE usec.uoo_id = cp_uoo_id;
3715:
3716: cur_usec_details_rec cur_usec_details %ROWTYPE;
3717:

Line 3806: FROM igs_ps_unit_ofr_opt_all usec

3802: -- level, if not found checks at unit level
3803:
3804: CURSOR cur_uv_audit_ind (cp_uoo_id NUMBER) IS
3805: Select NVL(usec.auditable_ind,'N') auditable_ind, cal_type,ci_sequence_number
3806: FROM igs_ps_unit_ofr_opt_all usec
3807: WHERE usec.uoo_id = cp_uoo_id;
3808:
3809: CURSOR c_usr_conf (cp_person_type VARCHAR2) IS
3810: SELECT UPD_AUDIT_DT_ALIAS

Line 4115: FROM igs_ps_unit_ofr_opt_all

4111:
4112: -- cursor to check whether unit section is superior unit section.
4113: CURSOR c_sup(cp_n_uoo_id IN NUMBER) IS
4114: SELECT 1
4115: FROM igs_ps_unit_ofr_opt_all
4116: WHERE sup_uoo_id = cp_n_uoo_id
4117: AND rownum <2;
4118:
4119: -- cursor to checks whether subordinate unit section exists in unit attempt status

Line 4126: IGS_PS_UNIT_OFR_OPT_ALL uoo

4122: cp_n_person_id IN NUMBER,
4123: cp_n_uoo_id IN NUMBER) IS
4124: SELECT 1
4125: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4126: IGS_PS_UNIT_OFR_OPT_ALL uoo
4127: WHERE sua.uoo_id = uoo.uoo_id
4128: AND uoo.sup_uoo_id = cp_n_uoo_id
4129: AND sua.course_cd = cp_c_course_cd
4130: AND sua.person_id = cp_n_person_id

Line 4141: IGS_PS_UNIT_OFR_OPT_ALL uoo

4137: cp_n_uoo_id IN NUMBER) IS
4138: SELECT sua.uoo_id,
4139: sua.core_indicator_code
4140: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4141: IGS_PS_UNIT_OFR_OPT_ALL uoo
4142: WHERE sua.uoo_id = uoo.uoo_id
4143: AND uoo.sup_uoo_id = cp_n_uoo_id
4144: AND sua.course_cd = cp_c_course_cd
4145: AND sua.person_id = cp_n_person_id

Line 4467: igs_ps_unit_ofr_opt_all us,

4463:
4464: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
4465: SELECT t.subtitle
4466: FROM igs_ps_unit_subtitle t,
4467: igs_ps_unit_ofr_opt_all us,
4468: igs_ps_unit_ver_all uv
4469: WHERE us.uoo_id = cp_n_uoo_id
4470: AND us.unit_cd = uv.unit_cd
4471: AND us.version_number = uv.version_number

Line 4627: igs_ps_unit_ofr_opt_all US,

4623: CA.START_DT), 'DD MON YYYY') || ' - ' ||
4624: TO_CHAR( NVL( NVL( USO.END_DATE, US.UNIT_SECTION_END_DATE),
4625: CA.END_DT), 'DD MON YYYY') effective_date
4626: FROM igs_ps_usec_occurs_all USO,
4627: igs_ps_unit_ofr_opt_all US,
4628: igs_ca_inst_all CA
4629: WHERE uso.unit_section_occurrence_id = cp_n_uso_id
4630: AND uso.uoo_id = us.uoo_id
4631: AND us.cal_type = ca.cal_type

Line 5071: FROM igs_ps_unit_ofr_opt_all

5067:
5068: CURSOR c_uv(cp_n_uoo_id IN NUMBER) IS
5069: SELECT unit_cd,
5070: version_number
5071: FROM igs_ps_unit_ofr_opt_all
5072: WHERE uoo_id = cp_n_uoo_id;
5073:
5074:
5075: CURSOR c_uv_gen_ref(cp_c_unit_cd IN VARCHAR2, cp_n_version IN NUMBER) IS