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

Line 39: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

35: AND NVL(end_date, SYSDATE) >= SYSDATE;
36:
37: -- Cursor to check whether authorisation exists or not.
38: CURSOR c_authorisation_exists (cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
39: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
40: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
41: SELECT 'X' FROM igs_en_svs_auth esa
42: WHERE person_id = cp_person_id
43: AND NVL(esa.end_dt, SYSDATE) >= SYSDATE

Line 40: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

36:
37: -- Cursor to check whether authorisation exists or not.
38: CURSOR c_authorisation_exists (cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
39: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
40: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
41: SELECT 'X' FROM igs_en_svs_auth esa
42: WHERE person_id = cp_person_id
43: AND NVL(esa.end_dt, SYSDATE) >= SYSDATE
44: AND exists (select 'x'

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 143: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,

139: FROM igs_pe_person_id_type_v
140: WHERE pe_person_id = l_person_id;
141:
142: -- Cursor to get the corresponding load calander for the passed teaching calander
143: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
144: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
145: SELECT load_cal_type,load_ci_sequence_number
146: FROM IGS_CA_TEACH_TO_LOAD_V
147: WHERE teach_cal_type = p_cal_type AND

Line 144: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

140: WHERE pe_person_id = l_person_id;
141:
142: -- Cursor to get the corresponding load calander for the passed teaching calander
143: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
144: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
145: SELECT load_cal_type,load_ci_sequence_number
146: FROM IGS_CA_TEACH_TO_LOAD_V
147: WHERE teach_cal_type = p_cal_type AND
148: teach_ci_sequence_number = p_sequence_number AND

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 415: igs_ca_inst ci

411: pn.end_date,
412: pn.pe_note_type
413: FROM igs_pe_pers_note pn,
414: igs_ge_note gn,
415: igs_ca_inst ci
416: WHERE ci.cal_type = p_cal_type
417: AND ci.sequence_number = p_seq_num
418: AND pn.person_id = p_person_id
419: AND pn.pe_note_type = 'RET_FULL_LOAD'

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:

Line 760: FROM IGS_CA_INST

756: p_dflt_auth_start_dt OUT NOCOPY DATE,
757: p_dflt_auth_end_dt OUT NOCOPY DATE) IS
758: CURSOR c_cal_dates IS
759: SELECT start_dt, end_dt
760: FROM IGS_CA_INST
761: WHERE cal_type = p_cal_type
762: AND sequence_number = p_ci_sequence_number;
763:
764: