[Home] [Help]
166: -- excluding cross listed and meeting with class group usos , which are not to be announced
167: CURSOR cur_time_conflct(cp_start_time DATE , cp_end_time DATE) IS
168: SELECT uso.row_id , uso.unit_section_occurrence_id , uso.monday,uso.tuesday,uso.wednesday,
169: uso.thursday,uso.friday,uso.saturday , uso.sunday,uso.start_date,uso.end_date
170: FROM igs_ps_usec_occurs uso ,
171: igs_ps_uso_instrctrs usoi ,
172: igs_ps_unit_ofr_opt uoo ,
173: igs_ca_inst ci
174: WHERE usoi.instructor_id = p_person_id AND
207:
208: --check if the conflicting record already exists in the temp table before inserting it.
209: -- here if we r trying to insert usec_occur_id1 and 2 then we check to see if
210: -- usec_occur2 , 1 already exists ,because order doesn't matter
211: CURSOR cur_tmp_exists(cp_usec_occur_id2 igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS
212: SELECT 'x' FROM igs_ps_fac_tcft_tmp
213: WHERE person_id = p_person_id AND
214: usec_occur_id1 = cp_usec_occur_id2 AND
215: usec_occur_id2 = p_unit_section_occurrence_id ;
362: uso.start_time ,
363: uso.end_time,
364: uoo.cal_type,
365: uoo.ci_sequence_number
366: FROM igs_ps_usec_occurs uso,
367: igs_ps_uso_instrctrs usoi ,
368: igs_ps_unit_ofr_opt uoo ,
369: igs_ca_inst ci
370: WHERE usoi.instructor_id = p_person_id AND
390: uso.start_time ,
391: uso.end_time,
392: uoo.cal_type,
393: uoo.ci_sequence_number
394: FROM igs_ps_usec_occurs uso,
395: igs_ps_uso_instrctrs usoi ,
396: igs_ps_unit_ofr_opt uoo ,
397: igs_ca_inst ci
398: WHERE usoi.instructor_id > -1 AND