[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT uso.row_id , uso.unit_section_occurrence_id , uso.monday,uso.tuesday,uso.wednesday,
uso.thursday,uso.friday,uso.saturday , uso.sunday,uso.start_date,uso.end_date
FROM igs_ps_usec_occurs uso ,
igs_ps_uso_instrctrs usoi ,
igs_ps_unit_ofr_opt uoo ,
igs_ca_inst ci
WHERE usoi.instructor_id = p_person_id AND
usoi.unit_section_occurrence_id <> p_unit_section_occurrence_id AND
usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
uoo.uoo_id = uso.uoo_id AND
uoo.cal_type = ci.cal_type AND
uoo.ci_sequence_number = ci.sequence_number AND
( (uso.monday = p_monday AND p_monday = 'Y' ) OR
(uso.tuesday = p_tuesday AND p_tuesday='Y') OR
(uso.wednesday = p_wednesday AND p_wednesday='Y') OR
(uso.thursday = p_thursday AND p_thursday='Y') OR
(uso.friday = p_friday AND p_friday='Y') OR
(uso.saturday = p_saturday AND p_saturday='Y') OR
(uso.sunday = p_sunday AND p_sunday='Y') ) AND
( (NVL(uso.start_date,NVL(uoo.unit_section_start_date,ci.start_dt)) BETWEEN p_start_date AND p_end_date) OR
(NVL(uso.end_date,NVL(uoo.unit_section_end_date,ci.end_dt)) BETWEEN p_start_date AND p_end_date ) OR
(p_start_date BETWEEN NVL(uso.start_date,NVL(uoo.unit_section_start_date,ci.start_dt)) AND
NVL(uso.end_date,NVL(uoo.unit_section_end_date,ci.end_dt)))
) AND
( (TO_DATE(TO_CHAR(uso.start_time,'HH24:MI'),'HH24:MI') BETWEEN cp_start_time AND cp_end_time) OR
(TO_DATE(TO_CHAR(uso.end_time,'HH24:MI'),'HH24:MI') BETWEEN cp_start_time AND cp_end_time) OR
(cp_start_time BETWEEN TO_DATE(TO_CHAR(uso.start_time,'HH24:MI'),'HH24:MI') AND
TO_DATE(TO_CHAR(uso.end_time,'HH24:MI'),'HH24:MI') )
) AND
-- considering boundary conditions as no conflict
( (TO_DATE(TO_CHAR(uso.start_time,'HH24:MI'),'HH24:MI') <> cp_end_time) AND
(TO_DATE(TO_CHAR(uso.end_time,'HH24:MI'),'HH24:MI') <> cp_start_time )
) AND
NVL(uso.to_be_announced,'N') = 'N' AND
NOT EXISTS (SELECT 'x' FROM igs_ps_uso_clas_meet ucm
WHERE ucm.uoo_id = uso.uoo_id ) AND
NOT EXISTS (SELECT 'x' FROM igs_ps_usec_x_grpmem uxg
WHERE uxg.uoo_id = uso.uoo_id)
ORDER BY uso.row_id asc;
SELECT 'x' FROM igs_ps_fac_tcft_tmp
WHERE person_id = p_person_id AND
usec_occur_id1 = cp_usec_occur_id2 AND
usec_occur_id2 = p_unit_section_occurrence_id ;
igs_ps_fac_tcft_tmp_pkg.insert_row (
x_rowid => l_rowid ,
x_person_id => p_person_id ,
x_usec_occur_id1 => p_unit_section_occurrence_id ,
x_usec_occur_id2 => cur_time_conflct_rec.unit_section_occurrence_id ,
x_mode => 'R'
);
SELECT rowid
FROM igs_ps_fac_tcft_tmp ;
SELECT teach_cal_type,teach_ci_sequence_number
FROM igs_ca_load_to_teach_v
WHERE load_cal_type = p_cal_type
AND load_ci_sequence_number = p_sequence_number;
SELECT usoi.instructor_id ,
uso.unit_section_occurrence_id ,
uso.monday,
uso.tuesday,
uso.wednesday ,
uso.thursday ,
uso.friday,
uso.saturday ,
uso.sunday ,
NVL(uso.start_date,NVL(uoo.unit_section_start_date,ci.start_dt)) start_date ,
NVL(uso.end_date ,NVL(uoo.unit_section_end_date,ci.end_dt)) end_date ,
uso.start_time ,
uso.end_time,
uoo.cal_type,
uoo.ci_sequence_number
FROM igs_ps_usec_occurs uso,
igs_ps_uso_instrctrs usoi ,
igs_ps_unit_ofr_opt uoo ,
igs_ca_inst ci
WHERE usoi.instructor_id = p_person_id AND
usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
uso.uoo_id = uoo.uoo_id AND
uoo.cal_type = ci.cal_type AND
uoo.ci_sequence_number = ci.sequence_number AND
NVL(uso.to_be_announced,'N') = 'N' ;
SELECT usoi.instructor_id ,
uso.unit_section_occurrence_id ,
uso.monday,
uso.tuesday,
uso.wednesday ,
uso.thursday ,
uso.friday,
uso.saturday ,
uso.sunday ,
NVL(uso.start_date,NVL(uoo.unit_section_start_date,ci.start_dt)) start_date ,
NVL(uso.end_date ,NVL(uoo.unit_section_end_date,ci.end_dt)) end_date ,
uso.start_time ,
uso.end_time,
uoo.cal_type,
uoo.ci_sequence_number
FROM igs_ps_usec_occurs uso,
igs_ps_uso_instrctrs usoi ,
igs_ps_unit_ofr_opt uoo ,
igs_ca_inst ci
WHERE usoi.instructor_id > -1 AND
usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
uso.uoo_id = uoo.uoo_id AND
uoo.cal_type = ci.cal_type AND
uoo.ci_sequence_number = ci.sequence_number AND
NVL(uso.to_be_announced,'N') = 'N'
ORDER BY usoi.instructor_id , uso.row_id asc ;
IGS_PS_FAC_TCFT_TMP_PKG.DELETE_ROW (X_ROWID => cur_tmp_rec.rowid) ;
teachCalendar_tbl.DELETE;
SELECT s_cal_cat
FROM igs_ca_type
WHERE cal_type = cp_cal_type ;
SELECT person_id , fac_wl_id
FROM igs_ps_fac_wl fw
WHERE fw.cal_type = l_source_cal_type AND
fw.ci_sequence_number = l_source_sequence_number AND
fw.person_id = p_person_id;
SELECT person_id , fac_wl_id
FROM igs_ps_fac_wl fw
WHERE fw.cal_type = l_source_cal_type
AND fw.ci_sequence_number = l_source_sequence_number
AND fw.person_id > -1
ORDER BY person_id ;
SELECT 'x' FROM igs_ps_fac_asg_task
WHERE fac_wl_id = cp_fac_wl_id
AND NVL(num_rollover_period,99) >= 1
AND NVL(rollover_flag,' ') <> 'S';
SELECT fac_wl_id
FROM igs_ps_fac_wl
WHERE person_id = cp_person_id AND
cal_type = l_dest_cal_type AND
ci_sequence_number = l_dest_sequence_number ;
SELECT 'x'
FROM igs_ps_fac_asg_task
WHERE fac_wl_id = cp_fac_wl_id AND
faculty_task_type = cp_faculty_task_type ;
SELECT *
FROM igs_ps_fac_Asg_task_v
WHERE fac_wl_id = cp_fac_wl_id AND
NVL(num_rollover_period,99) >= 1 ;
SELECT rowid,igs_ps_fac_asg_task.*
FROM igs_ps_fac_asg_task
WHERE rowid = cp_rowid
FOR UPDATE OF rollover_flag NOWAIT;
SELECT party_number person_number, party_name person_name
FROM hz_parties
WHERE party_id =cp_person_id;
IGS_PS_FAC_WL_PKG.INSERT_ROW (
X_ROWID => l_rowid ,
X_FAC_WL_ID => l_fac_wl_id ,
X_PERSON_ID => l_tab_person_id(i).person_id ,
X_CALENDAR_CAT => l_dest_cal_cat ,
X_CAL_TYPE => l_dest_cal_type ,
X_CI_SEQUENCE_NUMBER => l_dest_sequence_number ,
X_ATTRIBUTE_CATEGORY => NULL ,
X_ATTRIBUTE1 => NULL ,
X_ATTRIBUTE2 => NULL ,
X_ATTRIBUTE3 => NULL ,
X_ATTRIBUTE4 => NULL ,
X_ATTRIBUTE5 => NULL ,
X_ATTRIBUTE6 => NULL ,
X_ATTRIBUTE7 => NULL ,
X_ATTRIBUTE8 => NULL ,
X_ATTRIBUTE9 => NULL ,
X_ATTRIBUTE10 => NULL ,
X_ATTRIBUTE11 => NULL ,
X_ATTRIBUTE12 => NULL ,
X_ATTRIBUTE13 => NULL ,
X_ATTRIBUTE14 => NULL ,
X_ATTRIBUTE15 => NULL ,
X_ATTRIBUTE16 => NULL ,
X_ATTRIBUTE17 => NULL ,
X_ATTRIBUTE18 => NULL ,
X_ATTRIBUTE19 => NULL ,
X_ATTRIBUTE20 => NULL ,
X_MODE => 'R' ) ;
IGS_PS_FAC_ASG_TASK_PKG.INSERT_ROW(
X_ROWID => l_rowid1 ,
X_FAC_WL_ID => l_fac_wl_id ,
X_FACULTY_TASK_TYPE => cur_source_tasks_rec.faculty_task_type ,
X_CONFIRMED_IND => cur_source_tasks_rec.confirmed_ind,
X_NUM_ROLLOVER_PERIOD => (NVL(cur_source_tasks_rec.num_rollover_period,99) - 1) ,
X_ROLLOVER_FLAG => 'D' ,
X_DEPT_BUDGET_CD => cur_source_tasks_rec.dept_budget_cd ,
X_DEFAULT_WL => cur_source_tasks_rec.default_wl ,
X_MODE => 'R' );
IGS_PS_FAC_ASG_TASK_PKG.UPDATE_ROW(
X_ROWID => cur_upd_src_task_rec.rowid,
X_FAC_WL_ID => cur_upd_src_task_rec.fac_wl_id ,
X_FACULTY_TASK_TYPE => cur_upd_src_task_rec.faculty_task_type ,
X_CONFIRMED_IND => cur_upd_src_task_rec.confirmed_ind,
X_NUM_ROLLOVER_PERIOD => cur_upd_src_task_rec.num_rollover_period,
X_ROLLOVER_FLAG => 'S' ,
X_DEPT_BUDGET_CD => cur_upd_src_task_rec.dept_budget_cd ,
X_DEFAULT_WL => cur_upd_src_task_rec.default_wl ,
X_MODE => 'R' );
END IF; -- source task type is updated