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_EN_STDNT_PS_ATT

Line 711: FROM igs_en_stdnt_ps_att

707: WHERE uoo_id = p_uoo_id;
708:
709: CURSOR c_prg_ver IS
710: SELECT version_number
711: FROM igs_en_stdnt_ps_att
712: WHERE person_id= p_person_id AND
713: course_cd = p_course_cd;
714:
715:

Line 1209: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

1205: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1206: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
1207: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
1208: l_daiv_rec_found BOOLEAN;
1209: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1210: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;
1211: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;
1212: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;
1213: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 1220: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1216: l_effective_dt DATE;
1217: --
1218: -- Cursor to fetch student course attempt calendar type
1219: --
1220: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1221: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1222: SELECT sca.cal_type
1223: FROM igs_en_stdnt_ps_att sca
1224: WHERE sca.person_id = cp_person_id

Line 1221: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1217: --
1218: -- Cursor to fetch student course attempt calendar type
1219: --
1220: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1221: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1222: SELECT sca.cal_type
1223: FROM igs_en_stdnt_ps_att sca
1224: WHERE sca.person_id = cp_person_id
1225: AND sca.course_cd = cp_course_cd;

Line 1223: FROM igs_en_stdnt_ps_att sca

1219: --
1220: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1221: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1222: SELECT sca.cal_type
1223: FROM igs_en_stdnt_ps_att sca
1224: WHERE sca.person_id = cp_person_id
1225: AND sca.course_cd = cp_course_cd;
1226: --
1227: -- Cursor to fetch load effective date alias.

Line 1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;

1627:
1628: -- Local Variables
1629:
1630: l_achieved_cp NUMBER;
1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;

Line 1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;

1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;

Line 1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1

1660: -- Cursor find the Date at which the Student Program Attempt became 'ACTIVE'
1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS
1663: SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
1665: WHERE SCA1.person_id = SCAH1.person_id(+)
1666: AND SCA1.course_cd = SCAH1.course_cd(+)
1667: AND SCA1.person_id = p_person_id
1668: AND SCA1.course_cd = p_course_cd

Line 1675: CURSOR cur_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1671: ORDER BY NVL(SCAH1.hist_start_dt,SCA1.last_update_date);
1672:
1673:
1674: -- Cursor to fetch student course attempt calendar type
1675: CURSOR cur_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1677: SELECT sca.cal_type
1678: FROM igs_en_stdnt_ps_att sca
1679: WHERE sca.person_id = cp_person_id

Line 1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1672:
1673:
1674: -- Cursor to fetch student course attempt calendar type
1675: CURSOR cur_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1677: SELECT sca.cal_type
1678: FROM igs_en_stdnt_ps_att sca
1679: WHERE sca.person_id = cp_person_id
1680: AND sca.course_cd = cp_course_cd;

Line 1678: FROM igs_en_stdnt_ps_att sca

1674: -- Cursor to fetch student course attempt calendar type
1675: CURSOR cur_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1677: SELECT sca.cal_type
1678: FROM igs_en_stdnt_ps_att sca
1679: WHERE sca.person_id = cp_person_id
1680: AND sca.course_cd = cp_course_cd;
1681: l_cal_type igs_ca_inst.cal_type%TYPE;
1682:

Line 1885: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1881:
1882: --
1883: -- Cursor to fetch student course attempt calendar type
1884: --
1885: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1886: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1887: SELECT sca.cal_type
1888: FROM igs_en_stdnt_ps_att sca
1889: WHERE sca.person_id = cp_person_id

Line 1886: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1882: --
1883: -- Cursor to fetch student course attempt calendar type
1884: --
1885: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1886: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1887: SELECT sca.cal_type
1888: FROM igs_en_stdnt_ps_att sca
1889: WHERE sca.person_id = cp_person_id
1890: AND sca.course_cd = cp_course_cd;

Line 1888: FROM igs_en_stdnt_ps_att sca

1884: --
1885: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1886: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1887: SELECT sca.cal_type
1888: FROM igs_en_stdnt_ps_att sca
1889: WHERE sca.person_id = cp_person_id
1890: AND sca.course_cd = cp_course_cd;
1891:
1892: -- Local Variables

Line 1893: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

1889: WHERE sca.person_id = cp_person_id
1890: AND sca.course_cd = cp_course_cd;
1891:
1892: -- Local Variables
1893: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1894: l_message VARCHAR2(100);
1895:
1896: BEGIN
1897:

Line 2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;

2687: -- LOCAL VARIABLES
2688: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2689: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2690: l_daiv_rec_found BOOLEAN;
2691: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2692: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2693: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2694: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2695: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;

2857:
2858: -- LOCAL VARIABLES
2859: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2860: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
2861: l_cal_type IGS_EN_STDNT_PS_ATT.CAL_TYPE%TYPE;
2862: l_current_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
2863: l_current_load_ci_start_dt IGS_CA_INST.START_DT%TYPE;
2864: l_current_load_ci_end_dt IGS_CA_INST.END_DT%TYPE;
2865: l_current_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 3077: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

3073: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
3074: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
3075: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
3076: l_daiv_rec_found BOOLEAN;
3077: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
3078: l_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE;
3079: l_current_load_cal_type igs_ca_inst.cal_type%TYPE;
3080: l_current_load_sequence_number igs_ca_inst.sequence_number%TYPE;
3081: l_current_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 3088: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

3084: l_effective_dt DATE;
3085: --
3086: -- Cursor to fetch student course attempt calendar type
3087: --
3088: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3089: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3090: SELECT sca.cal_type
3091: FROM igs_en_stdnt_ps_att sca
3092: WHERE sca.person_id = cp_person_id

Line 3089: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

3085: --
3086: -- Cursor to fetch student course attempt calendar type
3087: --
3088: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3089: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3090: SELECT sca.cal_type
3091: FROM igs_en_stdnt_ps_att sca
3092: WHERE sca.person_id = cp_person_id
3093: AND sca.course_cd = cp_course_cd;

Line 3091: FROM igs_en_stdnt_ps_att sca

3087: --
3088: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3089: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3090: SELECT sca.cal_type
3091: FROM igs_en_stdnt_ps_att sca
3092: WHERE sca.person_id = cp_person_id
3093: AND sca.course_cd = cp_course_cd;
3094: --
3095: -- Cursor to fetch load effective date alias.

Line 3282: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

3278:
3279: --
3280: -- Cursor to fetch student course attempt calendar type
3281: --
3282: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3283: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3284: SELECT sca.cal_type
3285: FROM igs_en_stdnt_ps_att sca
3286: WHERE sca.person_id = cp_person_id

Line 3283: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

3279: --
3280: -- Cursor to fetch student course attempt calendar type
3281: --
3282: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3283: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3284: SELECT sca.cal_type
3285: FROM igs_en_stdnt_ps_att sca
3286: WHERE sca.person_id = cp_person_id
3287: AND sca.course_cd = cp_course_cd;

Line 3285: FROM igs_en_stdnt_ps_att sca

3281: --
3282: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
3283: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
3284: SELECT sca.cal_type
3285: FROM igs_en_stdnt_ps_att sca
3286: WHERE sca.person_id = cp_person_id
3287: AND sca.course_cd = cp_course_cd;
3288:
3289: -- Local Variables

Line 3290: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

3286: WHERE sca.person_id = cp_person_id
3287: AND sca.course_cd = cp_course_cd;
3288:
3289: -- Local Variables
3290: l_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
3291: l_message VARCHAR2(100);
3292:
3293: BEGIN
3294: