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_NSC_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 354: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod

350: )
351: OR
352: (cp_nslc_condition = '3'
353: AND course_attempt_status IN('ENROLLED','DISCONTIN', 'LAPSED','COMPLETED', 'INACTIVE')
354: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod
355: WHERE b.person_id = spa.person_id
356: and b.course_cd = spa.course_cd
357: and b.cal_type = lod.teach_cal_type
358: AND b.ci_sequence_number = lod.teach_ci_sequence_number

Line 1344: FROM igs_en_su_attempt

1340:
1341: -- Cursor to fetch the Units
1342: CURSOR c_units(p_person_id NUMBER) IS
1343: SELECT cal_type,ci_sequence_number
1344: FROM igs_en_su_attempt
1345: WHERE person_id = p_person_id
1346: AND unit_attempt_status IN ('COMPLETED','ENROLLED','DUPLICATE')
1347: AND ci_start_dt <= SYSDATE
1348: ORDER by ci_end_dt DESC;

Line 1350: l_cal_type igs_en_su_attempt.cal_type%TYPE;

1346: AND unit_attempt_status IN ('COMPLETED','ENROLLED','DUPLICATE')
1347: AND ci_start_dt <= SYSDATE
1348: ORDER by ci_end_dt DESC;
1349:
1350: l_cal_type igs_en_su_attempt.cal_type%TYPE;
1351: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
1352:
1353: CURSOR c_prev_acad_term(p_cal_type VARCHAR2, p_ci_sequence_number NUMBER) IS
1354: SELECT load_end_dt

Line 1351: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;

1347: AND ci_start_dt <= SYSDATE
1348: ORDER by ci_end_dt DESC;
1349:
1350: l_cal_type igs_en_su_attempt.cal_type%TYPE;
1351: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
1352:
1353: CURSOR c_prev_acad_term(p_cal_type VARCHAR2, p_ci_sequence_number NUMBER) IS
1354: SELECT load_end_dt
1355: FROM igs_ca_teach_to_load_v

Line 1886: FROM igs_as_su_atmpt_itm asv, igs_en_su_attempt asav,

1882: /* Checking for assessment items */
1883: -- smaddali modified for performance bug#4914052
1884: CURSOR c_outcome_dt(p_corresp_prg VARCHAR2) IS
1885: SELECT DISTINCT asv.outcome_dt
1886: FROM igs_as_su_atmpt_itm asv, igs_en_su_attempt asav,
1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt
1888: WHERE asv.person_id = asav.person_id
1889: AND asv.course_cd = asav.course_cd
1890: AND asv.uoo_id = asav.uoo_id

Line 1970: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod

1966: )
1967: OR
1968: (cp_nslc_condition = '3'
1969: AND course_attempt_status IN('ENROLLED','DISCONTIN', 'LAPSED','COMPLETED','INACTIVE')
1970: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod
1971: WHERE b.person_id = pr.person_id
1972: AND b.course_cd = pr.course_cd
1973: AND b.cal_type = lod.teach_cal_type
1974: AND b.ci_sequence_number = lod.teach_ci_sequence_number

Line 2014: FROM igs_En_Su_Attempt

2010:
2011: CURSOR c_sua_disc(cp_course_cd VARCHAR2,cp_intrm_end_dt DATE, cp_wthdrn_dt DATE) IS
2012: SELECT uoo_id, cal_type , ci_sequence_number, discontinued_dt ,administrative_unit_status,
2013: unit_attempt_status, no_assessment_ind
2014: FROM igs_En_Su_Attempt
2015: WHERE person_id = p_student_id
2016: AND course_cd = cp_course_cd
2017: AND unit_attempt_status = 'DISCONTIN'
2018: AND discontinued_dt BETWEEN cp_intrm_end_dt AND cp_wthdrn_dt;

Line 2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,

2075: -- smaddali modified cursor form perf bug#4914052
2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS
2078: SELECT DISTINCT spa.course_cd, spa.version_number
2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,
2080: igs_ca_load_to_teach_v lod
2081: WHERE spa.person_id = p_student_id
2082: AND spa.cal_type = cp_acad_cal_type
2083: AND spa.person_id = sua.person_id

Line 2093: FROM igs_en_su_attempt sua

2089:
2090: -- smaddali added these cursors for but#5440823
2091: CURSOR c_other_sua ( cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE ) IS
2092: SELECT sua.discontinued_dt
2093: FROM igs_en_su_attempt sua
2094: WHERE sua.person_id = p_student_id
2095: AND sua.course_cd = cp_course_cd
2096: AND sua.unit_attempt_status NOT IN ('DROPPED','DISCONTIN')
2097: AND (sua.cal_type,sua.ci_sequence_number) IN

Line 2105: FROM igs_En_Su_Attempt sua

2101: c_other_sua_rec c_other_sua%ROWTYPE;
2102:
2103: CURSOR c_disc_units(cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
2104: SELECT sua.discontinued_dt
2105: FROM igs_En_Su_Attempt sua
2106: WHERE person_id = p_student_id
2107: AND course_cd = cp_course_cd
2108: AND unit_attempt_status IN ( 'DROPPED','DISCONTIN')
2109: AND sua.no_assessment_ind = 'N'

Line 2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;

2646: l_diff_points NUMBER;
2647: l_sign NUMBER;
2648: l_status VARCHAR2(20);
2649:
2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;
2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;
2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;

Line 2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;

2647: l_sign NUMBER;
2648: l_status VARCHAR2(20);
2649:
2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;
2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;
2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;
2655:

Line 2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;

2648: l_status VARCHAR2(20);
2649:
2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;
2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;
2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;
2655:
2656:

Line 2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;

2649:
2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;
2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;
2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;
2655:
2656:
2657: CURSOR c_thresh_limit IS

Line 2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;

2650: l_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
2651: l_ci_seq_num igs_en_su_attempt.ci_sequence_number%TYPE;
2652: l_discont_dt igs_en_su_attempt.discontinued_dt%TYPE;
2653: l_adm_status igs_en_su_attempt.administrative_unit_status%TYPE;
2654: l_unt_atmpt_stat igs_en_su_attempt.unit_attempt_status%TYPE;
2655:
2656:
2657: CURSOR c_thresh_limit IS
2658: SELECT lower_enr_load_range

Line 2678: FROM igs_en_su_attempt ut,

2674: ut.ci_sequence_number teach_seq_number ,
2675: ut.uoo_id uoo_id,
2676: ut.override_enrolled_cp override_enrolled_cp,
2677: ut.override_eftsu override_eftsu
2678: FROM igs_en_su_attempt ut,
2679: igs_en_stdnt_ps_att pr,
2680: igs_ps_ver vers
2681: WHERE (ut.cal_type,ut.ci_sequence_number) IN
2682: (SELECT teach_cal_type,

Line 2726: FROM igs_en_su_attempt_h ut,

2722: ut.uoo_id,
2723: ut.administrative_unit_status,
2724: ut.unit_attempt_status,
2725: ut.discontinued_dt
2726: FROM igs_en_su_attempt_h ut,
2727: igs_en_stdnt_ps_att pr,
2728: igs_ps_ver vers
2729: WHERE ut.cal_type = p_teach_cal_type
2730: AND ut.ci_sequence_number = p_teach_ci_sequence_number

Line 2756: FROM igs_en_su_attempt_h ut

2752: ut.administrative_unit_status,
2753: ut.unit_attempt_status,
2754: ut.no_assessment_ind,
2755: ut.hist_end_dt
2756: FROM igs_en_su_attempt_h ut
2757: WHERE ut.person_id = p_student_id
2758: AND ut.course_cd = p_c_course_cd
2759: AND ut.uoo_id = p_c_uoo_id
2760: AND ut.hist_end_dt > p_c_hist_end_dt

Line 2762: old_hist_end_dt igs_en_su_attempt_h.hist_end_dt%TYPE;

2758: AND ut.course_cd = p_c_course_cd
2759: AND ut.uoo_id = p_c_uoo_id
2760: AND ut.hist_end_dt > p_c_hist_end_dt
2761: ORDER BY ut.hist_end_dt;
2762: old_hist_end_dt igs_en_su_attempt_h.hist_end_dt%TYPE;
2763: -- get the next history record whose assessment_ind is not null
2764: CURSOR c_next_ass_ind (p_c_course_cd VARCHAR2,
2765: p_c_uoo_id NUMBER,
2766: p_c_hist_end_dt DATE ) IS

Line 2768: FROM igs_en_su_attempt_h ut

2764: CURSOR c_next_ass_ind (p_c_course_cd VARCHAR2,
2765: p_c_uoo_id NUMBER,
2766: p_c_hist_end_dt DATE ) IS
2767: SELECT ut.no_assessment_ind
2768: FROM igs_en_su_attempt_h ut
2769: WHERE ut.person_id = p_student_id
2770: AND ut.course_cd = p_c_course_cd
2771: AND ut.uoo_id = p_c_uoo_id
2772: AND ut.hist_end_dt > p_c_hist_end_dt

Line 2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;

2771: AND ut.uoo_id = p_c_uoo_id
2772: AND ut.hist_end_dt > p_c_hist_end_dt
2773: AND ut.no_assessment_ind IS NOT NULL
2774: ORDER BY ut.hist_end_dt;
2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2777:
2778: -- This cursor selects current record to compare enrollment points.
2779:

Line 2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;

2772: AND ut.hist_end_dt > p_c_hist_end_dt
2773: AND ut.no_assessment_ind IS NOT NULL
2774: ORDER BY ut.hist_end_dt;
2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2777:
2778: -- This cursor selects current record to compare enrollment points.
2779:
2780: CURSOR c_orig_units(p_c_course_cd VARCHAR2,

Line 2790: FROM igs_en_su_attempt ut

2786: ut.discontinued_dt,
2787: ut.administrative_unit_status,
2788: ut.unit_attempt_status,
2789: ut.no_assessment_ind
2790: FROM igs_en_su_attempt ut
2791: WHERE ut.person_id = p_student_id
2792: AND ut.course_cd = p_c_course_cd
2793: AND ut.uoo_id = p_c_uoo_id;
2794: c_sua_rec c_orig_units%ROWTYPE;

Line 2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;

2812: l_unit_version NUMBER;
2813: old_load_incur varchar2(1);
2814: new_load_incur varchar2(1);
2815:
2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;
2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;

Line 2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;

2813: old_load_incur varchar2(1);
2814: new_load_incur varchar2(1);
2815:
2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;
2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;
2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;

Line 2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;

2814: new_load_incur varchar2(1);
2815:
2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;
2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;
2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;
2822:

Line 2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;

2815:
2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;
2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;
2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;
2822:
2823: BEGIN

Line 2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;

2816: old_teach_cal_type igs_en_su_Attempt.cal_type%TYPE;
2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;
2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;
2822:
2823: BEGIN
2824:

Line 2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;

2817: old_teach_seq_number igs_en_su_Attempt.ci_sequence_number%TYPE;
2818: old_discontinued_dt igs_en_su_Attempt.discontinued_dt%TYPE;
2819: old_administrative_unit_status igs_en_su_Attempt.administrative_unit_status%TYPE;
2820: old_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%TYPE;
2821: old_no_assessment_ind igs_en_su_Attempt.no_assessment_ind%TYPE;
2822:
2823: BEGIN
2824:
2825: -- Get the current status minimum - this is the threshold level.