[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT eis.exam_cal_type,
eis.exam_ci_sequence_number,
eis.dt_alias,
eis.dai_sequence_number,
eis.start_time,
eis.end_time
FROM igs_as_exm_ins_spvsr eis,
igs_as_exam_session_v esev
WHERE eis.person_id = p_person_id
AND eis.exam_cal_type = esev.exam_cal_type
AND eis.exam_ci_sequence_number = esev.exam_ci_sequence_number
AND eis.dt_alias = esev.dt_alias
AND eis.dai_sequence_number = esev.dai_sequence_number
AND eis.start_time = esev.start_time
AND ((NVL (p_exam_cal_type, 'NULL') = 'NULL')
OR (eis.exam_cal_type = p_exam_cal_type)
)
AND ((NVL (p_exam_ci_sequence_number, 0) = 0)
OR (eis.exam_ci_sequence_number = p_exam_ci_sequence_number)
)
AND esev.alias_val < v_sysdate
UNION
SELECT DISTINCT esvs.exam_cal_type,
esvs.exam_ci_sequence_number,
esvs.dt_alias,
esvs.dai_sequence_number,
esvs.start_time,
esvs.end_time
FROM igs_as_exm_ses_vn_sp esvs,
igs_as_exam_session_v esev
WHERE esvs.person_id = p_person_id
AND esvs.exam_cal_type = esev.exam_cal_type
AND esvs.exam_ci_sequence_number = esev.exam_ci_sequence_number
AND esvs.dt_alias = esev.dt_alias
AND esvs.dai_sequence_number = esev.dai_sequence_number
AND esvs.start_time = esev.start_time
AND ((NVL (p_exam_cal_type, 'NULL') = 'NULL')
OR (esvs.exam_cal_type = p_exam_cal_type)
)
AND ((NVL (p_exam_ci_sequence_number, 0) = 0)
OR (esvs.exam_ci_sequence_number = p_exam_ci_sequence_number)
)
AND esev.alias_val < v_sysdate;
p_logical_delete_dt IN DATE,
p_uoo_id IN NUMBER
) RETURN VARCHAR2 IS
gv_other_detail VARCHAR2 (255);
p_logical_delete_dt,
p_message_name,
p_uoo_id
) = TRUE THEN
RETURN NULL;
SELECT s_student_todo_type,
sequence_number,
reference_number
FROM igs_pe_std_todo_ref
WHERE person_id = p_person_id
AND s_student_todo_type IN ('ASS_INSERT', 'ASS_STATUS', 'ASS_CHANGE')
AND logical_delete_dt IS NULL
AND course_cd = p_course_cd
AND uoo_id = p_uoo_id;
SELECT ROWID,
tracking_id
FROM igs_as_su_atmpt_itm
WHERE person_id = p_person_id
AND course_cd = p_course_cd
AND uoo_id = p_uoo_id
FOR UPDATE OF tracking_id NOWAIT;
igs_as_su_atmpt_itm_pkg.delete_row (c_del_suaai_rec.ROWID);
SELECT suaai.ROWID row_id,
suaai.*
FROM igs_as_su_atmpt_itm suaai,
igs_en_su_attempt_all sua
WHERE suaai.person_id = p_person_id
AND suaai.course_cd = p_course_cd
AND suaai.uoo_id = p_uoo_id
AND (((NVL (p_ass_id, 0) = 0)
AND suaai.s_default_ind = 'Y'
)
OR (suaai.ass_id = p_ass_id
AND (suaai.unit_section_ass_item_id = p_unit_ass_id
OR suaai.unit_ass_item_id = p_unit_ass_id))
)
AND suaai.logical_delete_dt IS NULL
AND sua.person_id = suaai.person_id
AND sua.course_cd = suaai.course_cd
AND sua.uoo_id = suaai.uoo_id
AND sua.unit_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'WAITLISTED');
igs_as_su_atmpt_itm_pkg.update_row (
x_mode => 'R',
x_rowid => c_suaai_rec.row_id,
x_person_id => c_suaai_rec.person_id,
x_course_cd => c_suaai_rec.course_cd,
x_unit_cd => c_suaai_rec.unit_cd,
x_cal_type => c_suaai_rec.cal_type,
x_ci_sequence_number => c_suaai_rec.ci_sequence_number,
x_ass_id => c_suaai_rec.ass_id,
x_creation_dt => c_suaai_rec.creation_dt,
x_attempt_number => c_suaai_rec.attempt_number,
x_outcome_dt => c_suaai_rec.outcome_dt,
x_override_due_dt => c_suaai_rec.override_due_dt,
x_tracking_id => c_suaai_rec.tracking_id,
x_logical_delete_dt => SYSDATE,
x_s_default_ind => c_suaai_rec.s_default_ind,
x_ass_pattern_id => c_suaai_rec.ass_pattern_id,
x_grading_schema_cd => c_suaai_rec.grading_schema_cd,
x_gs_version_number => c_suaai_rec.gs_version_number,
x_grade => c_suaai_rec.grade,
x_outcome_comment_code => c_suaai_rec.outcome_comment_code,
x_mark => c_suaai_rec.mark,
x_attribute_category => c_suaai_rec.attribute_category,
x_attribute1 => c_suaai_rec.attribute1,
x_attribute2 => c_suaai_rec.attribute2,
x_attribute3 => c_suaai_rec.attribute3,
x_attribute4 => c_suaai_rec.attribute4,
x_attribute5 => c_suaai_rec.attribute5,
x_attribute6 => c_suaai_rec.attribute6,
x_attribute7 => c_suaai_rec.attribute7,
x_attribute8 => c_suaai_rec.attribute8,
x_attribute9 => c_suaai_rec.attribute9,
x_attribute10 => c_suaai_rec.attribute10,
x_attribute11 => c_suaai_rec.attribute11,
x_attribute12 => c_suaai_rec.attribute12,
x_attribute13 => c_suaai_rec.attribute13,
x_attribute14 => c_suaai_rec.attribute14,
x_attribute15 => c_suaai_rec.attribute15,
x_attribute16 => c_suaai_rec.attribute16,
x_attribute17 => c_suaai_rec.attribute17,
x_attribute18 => c_suaai_rec.attribute18,
x_attribute19 => c_suaai_rec.attribute19,
x_attribute20 => c_suaai_rec.attribute20,
x_uoo_id => c_suaai_rec.uoo_id,
x_unit_section_ass_item_id => c_suaai_rec.unit_section_ass_item_id,
x_unit_ass_item_id => c_suaai_rec.unit_ass_item_id,
x_sua_ass_item_group_id => c_suaai_rec.sua_ass_item_group_id,
x_midterm_mandatory_type_code => c_suaai_rec.midterm_mandatory_type_code,
x_midterm_weight_qty => c_suaai_rec.midterm_weight_qty,
x_final_mandatory_type_code => c_suaai_rec.final_mandatory_type_code,
x_final_weight_qty => c_suaai_rec.final_weight_qty,
x_submitted_date => c_suaai_rec.submitted_date,
x_waived_flag => c_suaai_rec.waived_flag,
x_penalty_applied_flag => c_suaai_rec.penalty_applied_flag
);
cst_delete_lock CONSTANT VARCHAR2 (30) := 'DELETE_LOCK';
cst_ass_insert CONSTANT VARCHAR2 (30) := 'ASS_INSERT';
IF (p_s_student_todo_type = cst_ass_insert) THEN
RETURN ('IGS_AS_CREATE_DFLT_ASSITEMS');
IF (p_s_student_todo_type = cst_ass_insert) THEN
RETURN ('IGS_AS_LOGDEL_STUD_TODO_ITEM');
IF (p_action_type = cst_delete_lock) THEN
RETURN ('IGS_AS_LOGDEL_SFLT_STUD_SUAI');
SELECT assessment_type
FROM igs_as_assessmnt_itm ai
WHERE ai.ass_id = cp_ass_id;
SELECT 'x'
FROM igs_ad_adm_unit_stat aus
WHERE aus.administrative_unit_status = p_administrative_unit_status
AND aus.show_on_offic_ntfctn_ind = 'N';
SELECT 'x'
FROM igs_as_grd_sch_grade gsg
WHERE gsg.grading_schema_cd = cp_grading_schema_cd
AND gsg.version_number = cp_version_number
AND gsg.grade = cp_grade
AND gsg.show_on_official_ntfctn_ind = 'N';
SELECT 'x'
FROM igs_ps_ver crv,
igs_ps_type ct
WHERE crv.course_cd = p_course_cd
AND crv.version_number = p_version_number
AND ct.course_type = crv.course_type
AND ct.research_type_ind = 'Y';
SELECT 'x'
FROM igs_ps_unit_ver uv
WHERE uv.unit_cd = p_unit_cd
AND uv.research_unit_ind = 'Y';
SELECT 'x'
FROM igs_ps_unit_category uc
WHERE uc.unit_cd = p_unit_cd
AND uc.unit_cat = p_exclude_unit_category;
SELECT 'x'
FROM igs_ca_inst ci,
igs_ca_stat cs
WHERE ci.cal_type = cp_acad_cal_type
AND ci.sequence_number = cp_acad_ci_seq_no
AND ci.cal_status = cs.cal_status
AND cs.s_cal_status = cst_active;
SELECT secc.effect_enr_strt_dt_alias
FROM igs_en_cal_conf secc
WHERE secc.s_control_num = 1;
SELECT igs_ca_gen_001.calp_set_alias_value (
absolute_val,
igs_ca_gen_002.cals_clc_dt_from_dai (ci_sequence_number, cal_type, dt_alias, sequence_number)
) alias_val
FROM igs_ca_da_inst daiv
WHERE daiv.cal_type = cp_acad_cal_type
AND daiv.ci_sequence_number = cp_acad_ci_seq_no
AND daiv.dt_alias = cp_effect_dt_alias;