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_SUA_LGCY_PUB dependencies on IGS_CA_INST

Line 1142: CURSOR c_get_term_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,

1138: FROM igs_ps_unit_ofr_opt
1139: WHERE uoo_id = cp_uoo_id);
1140:
1141: -- Cursor to select the Term Calendar associated with a Teaching Calendar.
1142: CURSOR c_get_term_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,
1143: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1144: SELECT load_cal_type, load_ci_sequence_number,load_end_dt
1145: FROM IGS_CA_TEACH_TO_LOAD_V
1146: WHERE teach_cal_type = cp_cal_type

Line 1143: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1139: WHERE uoo_id = cp_uoo_id);
1140:
1141: -- Cursor to select the Term Calendar associated with a Teaching Calendar.
1142: CURSOR c_get_term_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,
1143: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1144: SELECT load_cal_type, load_ci_sequence_number,load_end_dt
1145: FROM IGS_CA_TEACH_TO_LOAD_V
1146: WHERE teach_cal_type = cp_cal_type
1147: AND teach_ci_sequence_number = cp_sequence_number

Line 1869: l_ci_start_dt igs_ca_inst.start_dt%TYPE;

1865: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
1866: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1867: l_cal_type igs_en_su_attempt.cal_type%TYPE;
1868: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
1869: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
1870:
1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
1872: l_version_number igs_en_su_attempt.version_number%TYPE;
1873: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;

Line 1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;

1867: l_cal_type igs_en_su_attempt.cal_type%TYPE;
1868: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
1869: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
1870:
1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
1872: l_version_number igs_en_su_attempt.version_number%TYPE;
1873: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
1874: l_program_attempt_status igs_en_Stdnt_ps_Att.course_attempt_status%TYPE;
1875: l_career_model_enabled VARCHAR2(1);