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_SEVIS dependencies on IGS_CA_INST_ALL

Line 96: CURSOR c_auth_person(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS

92: p_log_creation_dt OUT NOCOPY DATE) is
93:
94:
95: -- Cursor to get the authorized persons for the passed calander.
96: CURSOR c_auth_person(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
97: SELECT person_id, SEVIS_AUTHORIZATION_CODE
98: FROM igs_en_svs_auth auth,
99: igs_en_svs_auth_cal sac
100: WHERE auth.sevis_auth_id = sac.sevis_auth_id

Line 117: CURSOR c_cal_type(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS

113: SELECT party_number, person_first_name||' '||person_middle_name||' '||person_last_name full_name
114: FROM hz_parties
115: WHERE party_id = l_person_id;
116:
117: CURSOR c_cal_type(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
118: SELECT alternate_code, start_dt, end_dt
119: FROM igs_ca_inst_all
120: WHERE cal_type = l_cal_type
121: AND sequence_number = l_sequence_number;

Line 119: FROM igs_ca_inst_all

115: WHERE party_id = l_person_id;
116:
117: CURSOR c_cal_type(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
118: SELECT alternate_code, start_dt, end_dt
119: FROM igs_ca_inst_all
120: WHERE cal_type = l_cal_type
121: AND sequence_number = l_sequence_number;
122:
123: CURSOR c_cal_cat(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS

Line 123: CURSOR c_cal_cat(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS

119: FROM igs_ca_inst_all
120: WHERE cal_type = l_cal_type
121: AND sequence_number = l_sequence_number;
122:
123: CURSOR c_cal_cat(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
124: SELECT s_cal_cat
125: FROM igs_ca_type
126: WHERE cal_type = l_cal_type;
127:

Line 154: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS

150: ORDER BY load_start_dt asc;
151:
152:
153: -- Cursor to get the attendance type for the maximum enrollment load
154: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
155: SELECT attendance_type FROM igs_en_atd_type_load
156: WHERE cal_type = l_cal_type
157: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
158: FROM igs_en_atd_type_load

Line 162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;

158: FROM igs_en_atd_type_load
159: WHERE cal_type = l_cal_type);
160:
161: rec_teach_to_load cur_teach_to_load%ROWTYPE;
162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;
163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;

159: WHERE cal_type = l_cal_type);
160:
161: rec_teach_to_load cur_teach_to_load%ROWTYPE;
162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;
163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;
167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;

Line 164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;

160:
161: rec_teach_to_load cur_teach_to_load%ROWTYPE;
162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;
163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;
167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
168: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;

Line 165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;

161: rec_teach_to_load cur_teach_to_load%ROWTYPE;
162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;
163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;
167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
168: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
169: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;

Line 166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;

162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;
163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;
167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
168: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
169: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
170: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;

Line 167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;

163: v_begin_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
164: v_begin_term_cal_type igs_ca_inst_all.cal_type%TYPE;
165: v_begin_term_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
166: v_return_cal_type igs_ca_inst_all.cal_type%TYPE;
167: v_return_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
168: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
169: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
170: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
171: l_person_name_row c_person_name%ROWTYPE;

Line 176: l_description igs_ca_inst_all.description%TYPE;

172: l_cal_type_row c_cal_type%ROWTYPE;
173: l_sevis_meaning igs_lookups_view.meaning%TYPE;
174: v_creation_dt DATE;
175: l_api_person_id igs_pe_alt_pers_id_v.api_person_id%TYPE;
176: l_description igs_ca_inst_all.description%TYPE;
177: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
178: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
179:
180:

Line 407: CURSOR c_ret_to_ft_note_dtls ( p_cal_type igs_ca_inst_all.cal_type%TYPE,

403: --Where Person note is of type Return to Full Time Load.
404: --Start date of the person note should be more or same as the Term start date,
405: --And if End date exists for the person note then it should be less or same as
406: --the End date of the term.
407: CURSOR c_ret_to_ft_note_dtls ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
408: p_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
409: SELECT gn.note_text,
410: pn.start_date,
411: pn.end_date,

Line 408: p_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

404: --Start date of the person note should be more or same as the Term start date,
405: --And if End date exists for the person note then it should be less or same as
406: --the End date of the term.
407: CURSOR c_ret_to_ft_note_dtls ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
408: p_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
409: SELECT gn.note_text,
410: pn.start_date,
411: pn.end_date,
412: pn.pe_note_type

Line 429: CURSOR c_att_type ( p_cal_type igs_ca_inst_all.cal_type%TYPE ) IS

425:
426: --Cursor to get the Full Time Attendance Type
427: --This is the way to get the Attendance Type for the Maximum lower enrollment load range
428: --in the provided load calendar, Which will be treated as the Full Time Attendance Type
429: CURSOR c_att_type ( p_cal_type igs_ca_inst_all.cal_type%TYPE ) IS
430: SELECT attendance_type
431: FROM igs_en_atd_type_load
432: WHERE cal_type = p_cal_type
433: AND lower_enr_load_range = ( SELECT MAX(lower_enr_load_range)

Line 438: l_cal_type igs_ca_inst_all.cal_type%TYPE;

434: FROM igs_en_atd_type_load
435: WHERE cal_type = p_cal_type );
436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;
439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
440: l_description igs_ca_inst_all.description%TYPE;
441: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
442: l_credit_points NUMBER;

Line 439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;

435: WHERE cal_type = p_cal_type );
436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;
439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
440: l_description igs_ca_inst_all.description%TYPE;
441: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
442: l_credit_points NUMBER;
443: l_fte NUMBER;

Line 440: l_description igs_ca_inst_all.description%TYPE;

436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;
439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
440: l_description igs_ca_inst_all.description%TYPE;
441: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
442: l_credit_points NUMBER;
443: l_fte NUMBER;
444: