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

Line 1746: IGS_PS_UNIT_OFR_OPT uoo,

1742: SELECT ausg.grading_schema_cd,
1743: ausg.version_number,
1744: ausg.grade
1745: FROM IGS_EN_SU_ATTEMPT sua,
1746: IGS_PS_UNIT_OFR_OPT uoo,
1747: IGS_AD_ADM_UT_STA_GD ausg,
1748: IGS_AS_GRD_SCHEMA gs,
1749: igs_as_grd_sch_grade gsg
1750: WHERE sua.person_id = p_person_id AND

Line 2411: FROM igs_ps_unit_ofr_opt

2407: WHERE person_id = p_person_id AND
2408: course_cd = p_course_cd;
2409: CURSOR c_sua IS
2410: SELECT uoo_id
2411: FROM igs_ps_unit_ofr_opt
2412: WHERE unit_cd = p_unit_cd
2413: AND version_number = p_uv_version_number
2414: AND cal_type = p_cal_type
2415: AND ci_sequence_number = p_ci_sequence_number

Line 2998: FROM IGS_PS_UNIT_OFR_OPT

2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS
2997: SELECT offered_ind
2998: FROM IGS_PS_UNIT_OFR_OPT
2999: WHERE unit_cd = p_unit_cd AND
3000: version_number = p_version_number AND
3001: cal_type = p_cal_type AND
3002: ci_sequence_number = p_ci_sequence_number AND

Line 3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';

3001: cal_type = p_cal_type AND
3002: ci_sequence_number = p_ci_sequence_number AND
3003: location_cd = p_location_cd AND
3004: unit_class = p_unit_class;
3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';
3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';
3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';
3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;

Line 3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;

3005: cst_no IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE := 'N';
3006: cst_active IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'ACTIVE';
3007: cst_inactive IGS_PS_UNIT_STAT.s_unit_status%TYPE := 'INACTIVE';
3008: v_uv_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
3009: v_offered_ind IGS_PS_UNIT_OFR_OPT.offered_ind%TYPE;
3010: BEGIN
3011: --- Set the default message number
3012: p_message_name := null;
3013: --- Validate that the unit version is ACTIVE.

Line 3459: SELECT 1 FROM IGS_PS_UNIT_OFR_OPT

3455: --if a subordinate units section is explicitly selected by the user along with the superior units
3456: --then no other sub units are enrolled
3457: -------------------------------------------------------------------------------------------
3458: CURSOR cur_sup is
3459: SELECT 1 FROM IGS_PS_UNIT_OFR_OPT
3460: WHERE uoo_id = p_uoo_id
3461: AND relation_type = 'SUPERIOR' ;
3462:
3463: l_check_sup NUMBER(1);

Line 3473: SELECT * FROM IGS_PS_UNIT_OFR_OPT

3469:
3470: sub_stmt1 VARCHAR2(1000);
3471:
3472: CURSOR get_sub_usecs IS
3473: SELECT * FROM IGS_PS_UNIT_OFR_OPT
3474: WHERE sup_uoo_id = p_uoo_id AND
3475: default_enroll_flag = 'Y' AND
3476: relation_type = 'SUBORDINATE';
3477:

Line 3482: l_sub_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

3478: CURSOR cur_person_number IS
3479: SELECT party_number from hz_parties
3480: WHERE party_id = p_person_id;
3481:
3482: l_sub_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3484: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
3485: l_waitlist_ind VARCHAR2(1);
3486: l_return_status VARCHAR2(1);

Line 3483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

3479: SELECT party_number from hz_parties
3480: WHERE party_id = p_person_id;
3481:
3482: l_sub_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3484: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
3485: l_waitlist_ind VARCHAR2(1);
3486: l_return_status VARCHAR2(1);
3487: l_err_message VARCHAR2(1000);

Line 3484: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;

3480: WHERE party_id = p_person_id;
3481:
3482: l_sub_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3484: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
3485: l_waitlist_ind VARCHAR2(1);
3486: l_return_status VARCHAR2(1);
3487: l_err_message VARCHAR2(1000);
3488: l_message_name VARCHAR2(1000);

Line 3492: sub_stmt := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND

3488: l_message_name VARCHAR2(1000);
3489: l_person_number IGS_PE_PERSON.person_number%TYPE;
3490: l_enroll BOOLEAN;
3491: BEGIN
3492: sub_stmt := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND
3493: relation_type = ''SUBORDINATE'' AND uoo_id in ('||p_enr_uoo_ids||')';
3494:
3495: sub_stmt1 := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND
3496: relation_type = ''SUBORDINATE'' AND uoo_id = :1';

Line 3495: sub_stmt1 := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND

3491: BEGIN
3492: sub_stmt := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND
3493: relation_type = ''SUBORDINATE'' AND uoo_id in ('||p_enr_uoo_ids||')';
3494:
3495: sub_stmt1 := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND
3496: relation_type = ''SUBORDINATE'' AND uoo_id = :1';
3497:
3498: p_uoo_ids := NULL;
3499: p_waitlist_uoo_ids := NULL;

Line 3710: SELECT 1 FROM IGS_PS_UNIT_OFR_OPT

3706: -- who when what
3707: -- ckasu 25-APR-2006 Modfied as a part of bug#5191592.
3708: -------------------------------------------------------------------------------------------
3709: CURSOR cur_sup is
3710: SELECT 1 FROM IGS_PS_UNIT_OFR_OPT
3711: WHERE uoo_id = p_uoo_id
3712: AND relation_type = 'SUPERIOR' ;
3713:
3714: l_check_sup NUMBER(1);

Line 3718: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo

3714: l_check_sup NUMBER(1);
3715:
3716: CURSOR cur_sub_sua IS
3717: SELECT sua.uoo_id sub_uoo_id
3718: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo
3719: WHERE sua.person_id = p_person_id AND
3720: sua.course_cd = p_course_cd AND
3721: sua.uoo_id = uoo.uoo_id AND
3722: uoo.sup_uoo_id = p_uoo_id AND

Line 3733: l_sub_sua IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

3729: AND sca.course_cd = p_course_cd;
3730:
3731: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
3732:
3733: l_sub_sua IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
3734: l_ovrrd_chk VARCHAR2(1);
3735: l_ovrrd_drop VARCHAR2(1);
3736: l_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
3737: l_en_cal_type igs_ca_inst.cal_type%TYPE;

Line 3905: FROM igs_ps_unit_ofr_opt

3901: uoo_id<> cp_uoo_id;
3902:
3903: CURSOR c_usec_exclude_mus_flag (cp_uoo_id NUMBER) IS
3904: SELECT unit_cd,version_number,cal_type,ci_sequence_number,not_multiple_section_flag
3905: FROM igs_ps_unit_ofr_opt
3906: WHERE uoo_id=cp_uoo_id;
3907:
3908: CURSOR c_mus_participate (cp_not_multiple_section_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE,
3909: cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,

Line 3908: CURSOR c_mus_participate (cp_not_multiple_section_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE,

3904: SELECT unit_cd,version_number,cal_type,ci_sequence_number,not_multiple_section_flag
3905: FROM igs_ps_unit_ofr_opt
3906: WHERE uoo_id=cp_uoo_id;
3907:
3908: CURSOR c_mus_participate (cp_not_multiple_section_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE,
3909: cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,
3910: cp_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_uoo_id NUMBER) IS
3911: SELECT 'x'
3912: FROM igs_en_su_attempt sua,

Line 3913: igs_ps_unit_ofr_opt opt

3909: cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,
3910: cp_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_uoo_id NUMBER) IS
3911: SELECT 'x'
3912: FROM igs_en_su_attempt sua,
3913: igs_ps_unit_ofr_opt opt
3914: WHERE sua.person_id=cp_person_id AND
3915: sua.course_cd=cp_course_cd AND
3916: sua.unit_cd=cp_unit_cd AND
3917: sua.cal_type=cp_cal_type AND

Line 3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;

3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;
3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;
3930: l_notused VARCHAR2(1);
3931:
3932:
3933: