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_EN_SU_ATTEMPT

Line 550: igs_en_su_attempt

546: SELECT
547: alternative_title title,
548: subtitle
549: FROM
550: igs_en_su_attempt
551: WHERE
552: person_id = p_person_id AND
553: course_cd = p_course_cd AND
554: uoo_id = p_uoo_id;

Line 664: igs_en_su_attempt

660: SELECT
661: alternative_title title,
662: subtitle
663: FROM
664: igs_en_su_attempt
665: WHERE
666: person_id = p_person_id AND
667: course_cd = p_course_cd AND
668: uoo_id = p_uoo_id;

Line 749: igs_en_su_attempt

745: SELECT
746: alternative_title title,
747: subtitle
748: FROM
749: igs_en_su_attempt
750: WHERE
751: person_id = p_person_id AND
752: course_cd = p_course_cd AND
753: uoo_id = p_uoo_id;

Line 847: igs_en_su_attempt sua

843: CURSOR stdnt_usec_grd_sch IS
844: SELECT
845: sua.grading_schema_code
846: FROM
847: igs_en_su_attempt sua
848: WHERE
849: sua.person_id = p_person_id AND
850: sua.uoo_id = p_uoo_id AND
851: sua.course_cd = p_course_cd;

Line 874: l_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;

870: uvgr.unit_code = p_unit_cd AND
871: uvgr.unit_version_number = p_version_number AND
872: uvgr.default_flag = 'Y';
873:
874: l_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
875: l_stdnt_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
876: l_unit_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
877: BEGIN
878: -- get the grading schema at student level

Line 875: l_stdnt_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;

871: uvgr.unit_version_number = p_version_number AND
872: uvgr.default_flag = 'Y';
873:
874: l_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
875: l_stdnt_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
876: l_unit_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
877: BEGIN
878: -- get the grading schema at student level
879: OPEN stdnt_usec_grd_sch;

Line 876: l_unit_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;

872: uvgr.default_flag = 'Y';
873:
874: l_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
875: l_stdnt_usec_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
876: l_unit_grd_sch igs_en_su_attempt.grading_schema_code%TYPE DEFAULT NULL;
877: BEGIN
878: -- get the grading schema at student level
879: OPEN stdnt_usec_grd_sch;
880: FETCH stdnt_usec_grd_sch INTO l_stdnt_usec_grd_sch;

Line 928: igs_en_su_attempt sua

924: CURSOR stdnt_usec_grd_sch IS
925: SELECT
926: sua.gs_version_number
927: FROM
928: igs_en_su_attempt sua
929: WHERE
930: sua.person_id = p_person_id AND
931: sua.uoo_id = p_uoo_id AND
932: sua.course_cd = p_course_cd;

Line 955: l_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;

951: uvgr.unit_code = p_unit_cd AND
952: uvgr.unit_version_number = p_version_number AND
953: uvgr.default_flag = 'Y';
954:
955: l_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
956: l_stdnt_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
957: l_unit_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
958: BEGIN
959: -- get the grading schema at student level

Line 956: l_stdnt_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;

952: uvgr.unit_version_number = p_version_number AND
953: uvgr.default_flag = 'Y';
954:
955: l_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
956: l_stdnt_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
957: l_unit_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
958: BEGIN
959: -- get the grading schema at student level
960: OPEN stdnt_usec_grd_sch;

Line 957: l_unit_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;

953: uvgr.default_flag = 'Y';
954:
955: l_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
956: l_stdnt_usec_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
957: l_unit_grd_sch_ver igs_en_su_attempt.gs_version_number%TYPE DEFAULT NULL;
958: BEGIN
959: -- get the grading schema at student level
960: OPEN stdnt_usec_grd_sch;
961: FETCH stdnt_usec_grd_sch INTO l_stdnt_usec_grd_sch_ver;

Line 999: igs_en_su_attempt sua

995: SELECT
996: sua.grading_schema_code,
997: sua.gs_version_number
998: FROM
999: igs_en_su_attempt sua
1000: WHERE
1001: sua.person_id = cp_n_person_id AND
1002: sua.uoo_id = cp_n_uoo_id AND
1003: sua.course_cd = p_course_cd;

Line 1091: igs_en_su_attempt sua

1087: SELECT
1088: sua.grading_schema_code,
1089: sua.gs_version_number
1090: FROM
1091: igs_en_su_attempt sua
1092: WHERE
1093: sua.person_id = cp_n_person_id AND
1094: sua.uoo_id = cp_n_uoo_id AND
1095: sua.course_cd = p_course_cd;

Line 1202: igs_en_su_attempt sua

1198: CURSOR stdnt_credit_pts IS
1199: SELECT
1200: sua.override_enrolled_cp
1201: FROM
1202: igs_en_su_attempt sua
1203: WHERE
1204: sua.person_id = p_person_id AND
1205: sua.uoo_id = p_uoo_id AND
1206: sua.course_cd= p_course_cd;

Line 1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1651:
1652: --ijeddy modified the cursor for bug 3724930
1653: CURSOR c_term_info_ccd IS
1654: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1656: WHERE ttl.teach_cal_type = sua.cal_type
1657: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1658: AND sua.unit_attempt_status = 'ENROLLED'
1659: AND sua.person_id = p_person_id

Line 1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1662:
1663:
1664: CURSOR c_term_info IS
1665: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1667: WHERE ttl.teach_cal_type = sua.cal_type
1668: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1669: AND sua.unit_attempt_status = 'ENROLLED'
1670: AND sua.person_id = p_person_id

Line 2816: FROM igs_en_su_Attempt

2812: cp_person_id IN NUMBER ,
2813: cp_course_cd IN VARCHAR2,
2814: cp_uoo_id NUMBER) IS
2815: SELECT unit_attempt_status
2816: FROM igs_en_su_Attempt
2817: WHERE person_id = cp_person_id
2818: AND course_cd = cp_course_cd
2819: AND uoo_id = cp_uoo_id;
2820:

Line 4125: FROM IGS_EN_SU_ATTEMPT_ALL sua,

4121: CURSOR c_invalid_sub(cp_c_course_cd IN VARCHAR2,
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

Line 4140: FROM IGS_EN_SU_ATTEMPT_ALL sua,

4136: cp_n_person_id IN NUMBER,
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

Line 4242: FROM IGS_EN_SU_ATTEMPT sua

4238:
4239: CURSOR c_total_unconfirm_credits (cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
4240: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
4241: cp_term_cal_type,cp_term_seq_num)) apor_cp
4242: FROM IGS_EN_SU_ATTEMPT sua
4243: WHERE sua.unit_attempt_status = 'UNCONFIRM'
4244: AND sua.person_id = p_personid
4245: AND sua.course_cd = p_course_cd
4246: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where

Line 5221: FROM igs_en_su_attempt

5217: -- Cursor to find the Unit Code
5218: --
5219: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
5220: SELECT unit_cd, unit_class, CORE_INDICATOR_CODE
5221: FROM igs_en_su_attempt
5222: WHERE person_id = p_person_id
5223: AND course_cd = p_program_cd
5224: AND uoo_id = p_uoo_id;
5225:

Line 5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;

5235:
5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
5238: l_core_meaning igs_lookup_values.meaning%TYPE;
5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;
5240: BEGIN
5241: -- Get the Unit Code
5242: OPEN cur_unit_cd(p_uoo_id);
5243: FETCH cur_unit_cd INTO l_unit_cd,l_unit_class, l_core_ind_cd;

Line 5291: FROM IGS_EN_SU_ATTEMPT sua

5287: --cursor to fetch the total credits for all unconfirmed unit attempts from student unit attempts
5288: CURSOR c_total_unconfirm_credits (cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5289: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
5290: cp_term_cal_type,cp_term_seq_num)) apor_cp
5291: FROM IGS_EN_SU_ATTEMPT sua
5292: WHERE sua.unit_attempt_status = 'UNCONFIRM'
5293: AND sua.person_id = p_personid
5294: AND sua.course_cd = p_course_cd
5295: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where

Line 5549: FROM IGS_EN_SU_ATTEMPT sua

5545:
5546: --cursor to fetch the total unconfirmed unit attempts
5547: CURSOR c_total_unconfirm_units(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5548: SELECT count(uoo_id)
5549: FROM IGS_EN_SU_ATTEMPT sua
5550: WHERE sua.unit_attempt_status = 'UNCONFIRM'
5551: AND sua.person_id = p_personid
5552: AND sua.course_cd = p_course_cd
5553: AND sua.ss_source_ind <> 'S'