[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT uv.repeatable_ind,
rp_org.use_most_recent_unit_attempt,
rp_org.use_best_grade_attempt,
rp_org.external_formula
FROM igs_ps_unit_ofr_opt_all uoo,
igs_ps_unit_ver_all uv,
igs_en_rep_process rp_org,
igs_or_inst_org_base_v hp
WHERE uoo.uoo_id = p_uoo_id
AND uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uv.owner_org_unit_cd = hp.party_number
AND hp.party_id = rp_org.org_unit_id
AND hp.inst_org_ind = 'O'
UNION ALL
SELECT uv1.repeatable_ind,
rp_inst.use_most_recent_unit_attempt,
rp_inst.use_best_grade_attempt,
rp_inst.external_formula
FROM igs_ps_unit_ofr_opt_all uoo1,
igs_ps_unit_ver_all uv1,
igs_en_rep_process rp_inst
WHERE uoo1.uoo_id = p_uoo_id
AND uoo1.unit_cd = uv1.unit_cd
AND uoo1.version_number = uv1.version_number
AND rp_inst.org_unit_id IS NULL
AND NOT EXISTS ( SELECT 'X'
FROM igs_ps_unit_ofr_opt_all uoo2,
igs_en_rep_process rp_org,
igs_or_inst_org_base_v hp
WHERE uoo1.uoo_id = uoo2.uoo_id
AND uoo2.owner_org_unit_cd = hp.party_number
AND hp.party_id = rp_org.org_unit_id
AND hp.inst_org_ind = 'O');
SELECT suao.person_id,
suao.course_cd,
suao.unit_cd,
suao.cal_type,
suao.ci_sequence_number,
suao.uoo_id,
suao.ROWID,
suao.outcome_dt,
suao.ci_start_dt,
suao.ci_end_dt,
suao.grading_schema_cd,
suao.version_number,
suao.grade,
suao.s_grade_creation_method_type,
suao.mark,
suao.comments,
gsg.repeat_grade,
gsg.RANK,
suao.incomp_deadline_date,
suao.incomp_grading_schema_cd,
suao.incomp_version_number,
suao.incomp_default_grade,
suao.incomp_default_mark,
suao.attribute_category,
suao.attribute1,
suao.attribute2,
suao.attribute3,
suao.attribute4,
suao.attribute5,
suao.attribute6,
suao.attribute7,
suao.attribute8,
suao.attribute9,
suao.attribute10,
suao.attribute11,
suao.attribute12,
suao.attribute13,
suao.attribute14,
suao.attribute15,
suao.attribute16,
suao.attribute17,
suao.attribute18,
suao.attribute19,
suao.attribute20,
suao.mark_capped_flag,
suao.release_date,
suao.manual_override_flag,
suao.show_on_academic_histry_flag
FROM igs_as_su_stmptout_all suao,
igs_as_grd_sch_grade gsg
WHERE suao.uoo_id = p_uoo_id
AND suao.finalised_outcome_ind = 'N'
AND suao.grading_period_cd = 'FINAL'
AND suao.grading_schema_cd = gsg.grading_schema_cd
AND suao.version_number = gsg.version_number
AND suao.grade = gsg.grade
AND NVL(gsg.closed_ind,'N') = 'N'
AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
FROM igs_as_su_stmptout_all suao1
WHERE suao1.person_id = suao.person_id
AND suao1.course_cd = suao.course_cd
AND suao1.uoo_id = suao.uoo_id
AND suao1.grading_period_cd = suao.grading_period_cd);
SELECT suao.person_id,
suao.course_cd,
suao.unit_cd,
suao.cal_type,
suao.ci_sequence_number,
suao.uoo_id,
suao.ROWID,
suao.outcome_dt,
suao.ci_start_dt,
suao.ci_end_dt,
suao.grading_schema_cd,
suao.version_number,
suao.grade,
suao.s_grade_creation_method_type,
suao.mark,
suao.comments,
gsg.repeat_grade,
gsg.RANK,
suao.incomp_deadline_date,
suao.incomp_grading_schema_cd,
suao.incomp_version_number,
suao.incomp_default_grade,
suao.incomp_default_mark,
suao.attribute_category,
suao.attribute1,
suao.attribute2,
suao.attribute3,
suao.attribute4,
suao.attribute5,
suao.attribute6,
suao.attribute7,
suao.attribute8,
suao.attribute9,
suao.attribute10,
suao.attribute11,
suao.attribute12,
suao.attribute13,
suao.attribute14,
suao.attribute15,
suao.attribute16,
suao.attribute17,
suao.attribute18,
suao.attribute19,
suao.attribute20,
suao.mark_capped_flag,
suao.release_date,
suao.manual_override_flag,
suao.show_on_academic_histry_flag
FROM igs_as_su_stmptout_all suao,
igs_as_grd_sch_grade gsg
WHERE suao.person_id = p_person_id
AND suao.course_cd = p_course_cd
AND suao.uoo_id = p_uoo_id
AND suao.finalised_outcome_ind = 'N'
AND suao.grading_period_cd = 'FINAL'
AND suao.grading_schema_cd = gsg.grading_schema_cd
AND suao.version_number = gsg.version_number
AND suao.grade = gsg.grade
AND NVL(gsg.closed_ind,'N') = 'N'
AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
FROM igs_as_su_stmptout_all suao1
WHERE suao1.person_id = suao.person_id
AND suao1.course_cd = suao.course_cd
AND suao1.uoo_id = suao.uoo_id
AND suao1.grading_period_cd = suao.grading_period_cd);
SELECT sua.person_id,
sua.course_cd,
sua.unit_cd,
sua.cal_type,
sua.ci_sequence_number,
-- anilk, 22-Apr-2003, Bug# 2829262
sua.uoo_id,
suao.outcome_dt,
suao.ci_start_dt,
suao.ci_end_dt,
suao.grading_schema_cd,
suao.version_number,
suao.grade,
suao.mark,
suao.incomp_deadline_date,
suao.incomp_grading_schema_cd,
suao.incomp_version_number,
suao.incomp_default_grade,
suao.incomp_default_mark,
suao.comments,
gsg.repeat_grade,
gsg.RANK,
--ijeddy, bug #3027047.
suao.attribute_category,
suao.attribute1,
suao.attribute2,
suao.attribute3,
suao.attribute4,
suao.attribute5,
suao.attribute6,
suao.attribute7,
suao.attribute8,
suao.attribute9,
suao.attribute10,
suao.attribute11,
suao.attribute12,
suao.attribute13,
suao.attribute14,
suao.attribute15,
suao.attribute16,
suao.attribute17,
suao.attribute18,
suao.attribute19,
suao.attribute20,
suao.mark_capped_flag,
suao.release_date,
suao.manual_override_flag,
suao.show_on_academic_histry_flag
FROM igs_en_su_attempt sua,
igs_as_su_stmptout_all suao,
igs_as_grd_sch_grade gsg
WHERE sua.person_id = cp_person_id
AND sua.unit_cd = cp_unit_cd
AND (sua.course_cd <> cp_course_cd
OR sua.cal_type <> cp_cal_type
OR sua.ci_sequence_number <> cp_ci_sequence_number
)
AND suao.person_id = sua.person_id
AND suao.course_cd = sua.course_cd
AND suao.uoo_id = sua.uoo_id
AND suao.incomp_deadline_date IS NULL
AND suao.finalised_outcome_ind = 'Y'
AND suao.grading_period_cd = 'FINAL'
AND suao.grading_schema_cd = gsg.grading_schema_cd
AND suao.version_number = gsg.version_number
AND suao.grade = gsg.grade
AND gsg.incl_in_repeat_process_ind = 'Y'
AND NVL(gsg.closed_ind,'N') = 'N'
AND suao.outcome_dt IN (SELECT MAX (outcome_dt)
FROM igs_as_su_stmptout
WHERE person_id = suao.person_id
AND course_cd = suao.course_cd
AND uoo_id = suao.uoo_id
AND grading_period_cd = suao.grading_period_cd)
ORDER BY gsg.RANK ASC,
suao.ci_end_dt DESC;
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_prev_suao_rec.person_id,
x_course_cd => v_prev_suao_rec.course_cd,
x_unit_cd => v_prev_suao_rec.unit_cd,
x_cal_type => v_prev_suao_rec.cal_type,
x_ci_sequence_number => v_prev_suao_rec.ci_sequence_number,
x_outcome_dt => SYSDATE,
x_ci_start_dt => v_prev_suao_rec.ci_start_dt,
x_ci_end_dt => v_prev_suao_rec.ci_end_dt,
x_grading_schema_cd => v_prev_suao_rec.grading_schema_cd,
x_version_number => v_prev_suao_rec.version_number,
x_grade => v_prev_suao_rec.repeat_grade,
x_attribute_category => v_prev_suao_rec.attribute_category,
x_attribute1 => v_prev_suao_rec.attribute1,
x_attribute2 => v_prev_suao_rec.attribute2,
x_attribute3 => v_prev_suao_rec.attribute3,
x_attribute4 => v_prev_suao_rec.attribute4,
x_attribute5 => v_prev_suao_rec.attribute5,
x_attribute6 => v_prev_suao_rec.attribute6,
x_attribute7 => v_prev_suao_rec.attribute7,
x_attribute8 => v_prev_suao_rec.attribute8,
x_attribute9 => v_prev_suao_rec.attribute9,
x_attribute10 => v_prev_suao_rec.attribute10,
x_attribute11 => v_prev_suao_rec.attribute11,
x_attribute12 => v_prev_suao_rec.attribute12,
x_attribute13 => v_prev_suao_rec.attribute13,
x_attribute14 => v_prev_suao_rec.attribute14,
x_attribute15 => v_prev_suao_rec.attribute15,
x_attribute16 => v_prev_suao_rec.attribute16,
x_attribute17 => v_prev_suao_rec.attribute17,
x_attribute18 => v_prev_suao_rec.attribute18,
x_attribute19 => v_prev_suao_rec.attribute19,
x_attribute20 => v_prev_suao_rec.attribute20,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_mark => v_prev_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_prev_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_prev_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_prev_suao_rec.incomp_version_number,
x_incomp_default_grade => v_prev_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_prev_suao_rec.incomp_default_mark,
x_comments => v_prev_suao_rec.comments,
x_uoo_id => v_prev_suao_rec.uoo_id,
x_mark_capped_flag => v_prev_suao_rec.mark_capped_flag,
x_release_date => v_prev_suao_rec.release_date,
x_manual_override_flag => v_prev_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_prev_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_prev_suao_rec.person_id,
x_course_cd => v_prev_suao_rec.course_cd,
x_unit_cd => v_prev_suao_rec.unit_cd,
x_cal_type => v_prev_suao_rec.cal_type,
x_ci_sequence_number => v_prev_suao_rec.ci_sequence_number,
x_outcome_dt => SYSDATE,
x_ci_start_dt => v_prev_suao_rec.ci_start_dt,
x_ci_end_dt => v_prev_suao_rec.ci_end_dt,
x_grading_schema_cd => v_prev_suao_rec.grading_schema_cd,
x_version_number => v_prev_suao_rec.version_number,
x_grade => v_prev_suao_rec.repeat_grade,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_attribute_category => v_prev_suao_rec.attribute_category,
x_attribute1 => v_prev_suao_rec.attribute1,
x_attribute2 => v_prev_suao_rec.attribute2,
x_attribute3 => v_prev_suao_rec.attribute3,
x_attribute4 => v_prev_suao_rec.attribute4,
x_attribute5 => v_prev_suao_rec.attribute5,
x_attribute6 => v_prev_suao_rec.attribute6,
x_attribute7 => v_prev_suao_rec.attribute7,
x_attribute8 => v_prev_suao_rec.attribute8,
x_attribute9 => v_prev_suao_rec.attribute9,
x_attribute10 => v_prev_suao_rec.attribute10,
x_attribute11 => v_prev_suao_rec.attribute11,
x_attribute12 => v_prev_suao_rec.attribute12,
x_attribute13 => v_prev_suao_rec.attribute13,
x_attribute14 => v_prev_suao_rec.attribute14,
x_attribute15 => v_prev_suao_rec.attribute15,
x_attribute16 => v_prev_suao_rec.attribute16,
x_attribute17 => v_prev_suao_rec.attribute17,
x_attribute18 => v_prev_suao_rec.attribute18,
x_attribute19 => v_prev_suao_rec.attribute19,
x_attribute20 => v_prev_suao_rec.attribute20,
x_mark => v_prev_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_prev_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_prev_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_prev_suao_rec.incomp_version_number,
x_incomp_default_grade => v_prev_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_prev_suao_rec.incomp_default_mark,
x_comments => v_prev_suao_rec.comments,
x_uoo_id => v_prev_suao_rec.uoo_id,
x_mark_capped_flag => v_prev_suao_rec.mark_capped_flag,
x_release_date => v_prev_suao_rec.release_date,
x_manual_override_flag => v_prev_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_prev_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_suao_rec.person_id,
x_course_cd => v_suao_rec.course_cd,
x_unit_cd => v_suao_rec.unit_cd,
x_cal_type => v_suao_rec.cal_type,
x_ci_sequence_number => v_suao_rec.ci_sequence_number,
x_outcome_dt => v_new_outcome_dt,
x_ci_start_dt => v_suao_rec.ci_start_dt,
x_ci_end_dt => v_suao_rec.ci_end_dt,
x_grading_schema_cd => v_suao_rec.grading_schema_cd,
x_version_number => v_suao_rec.version_number,
x_grade => v_suao_rec.repeat_grade,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_attribute_category => v_suao_rec.attribute_category,
x_attribute1 => v_suao_rec.attribute1,
x_attribute2 => v_suao_rec.attribute2,
x_attribute3 => v_suao_rec.attribute3,
x_attribute4 => v_suao_rec.attribute4,
x_attribute5 => v_suao_rec.attribute5,
x_attribute6 => v_suao_rec.attribute6,
x_attribute7 => v_suao_rec.attribute7,
x_attribute8 => v_suao_rec.attribute8,
x_attribute9 => v_suao_rec.attribute9,
x_attribute10 => v_suao_rec.attribute10,
x_attribute11 => v_suao_rec.attribute11,
x_attribute12 => v_suao_rec.attribute12,
x_attribute13 => v_suao_rec.attribute13,
x_attribute14 => v_suao_rec.attribute14,
x_attribute15 => v_suao_rec.attribute15,
x_attribute16 => v_suao_rec.attribute16,
x_attribute17 => v_suao_rec.attribute17,
x_attribute18 => v_suao_rec.attribute18,
x_attribute19 => v_suao_rec.attribute19,
x_attribute20 => v_suao_rec.attribute20,
x_mark => v_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_suao_rec.incomp_version_number,
x_incomp_default_grade => v_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_suao_rec.incomp_default_mark,
x_comments => v_suao_rec.comments,
x_uoo_id => v_suao_rec.uoo_id,
x_mark_capped_flag => v_suao_rec.mark_capped_flag,
x_release_date => v_suao_rec.release_date,
x_manual_override_flag => v_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.update_row (
x_rowid => v_suao_rec.ROWID,
x_person_id => v_suao_rec.person_id,
x_course_cd => v_suao_rec.course_cd,
x_unit_cd => v_suao_rec.unit_cd,
x_cal_type => v_suao_rec.cal_type,
x_ci_sequence_number => v_suao_rec.ci_sequence_number,
x_outcome_dt => v_new_outcome_dt,
x_ci_start_dt => v_suao_rec.ci_start_dt,
x_ci_end_dt => v_suao_rec.ci_end_dt,
x_grading_schema_cd => v_suao_rec.grading_schema_cd,
x_version_number => v_suao_rec.version_number,
x_grade => v_suao_rec.grade,
x_s_grade_creation_method_type => v_suao_rec.s_grade_creation_method_type,
x_finalised_outcome_ind => 'Y',
x_mark => v_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_attribute_category => v_suao_rec.attribute_category,
x_attribute1 => v_suao_rec.attribute1,
x_attribute2 => v_suao_rec.attribute2,
x_attribute3 => v_suao_rec.attribute3,
x_attribute4 => v_suao_rec.attribute4,
x_attribute5 => v_suao_rec.attribute5,
x_attribute6 => v_suao_rec.attribute6,
x_attribute7 => v_suao_rec.attribute7,
x_attribute8 => v_suao_rec.attribute8,
x_attribute9 => v_suao_rec.attribute9,
x_attribute10 => v_suao_rec.attribute10,
x_attribute11 => v_suao_rec.attribute11,
x_attribute12 => v_suao_rec.attribute12,
x_attribute13 => v_suao_rec.attribute13,
x_attribute14 => v_suao_rec.attribute14,
x_attribute15 => v_suao_rec.attribute15,
x_attribute16 => v_suao_rec.attribute16,
x_attribute17 => v_suao_rec.attribute17,
x_attribute18 => v_suao_rec.attribute18,
x_attribute19 => v_suao_rec.attribute19,
x_attribute20 => v_suao_rec.attribute20,
x_incomp_deadline_date => v_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_suao_rec.incomp_version_number,
x_incomp_default_grade => v_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_suao_rec.incomp_default_mark,
x_comments => v_suao_rec.comments,
x_uoo_id => v_suao_rec.uoo_id,
x_mark_capped_flag => v_suao_rec.mark_capped_flag,
x_release_date => v_suao_rec.release_date,
x_manual_override_flag => v_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_prev_suao_rec.person_id,
x_course_cd => v_prev_suao_rec.course_cd,
x_unit_cd => v_prev_suao_rec.unit_cd,
x_cal_type => v_prev_suao_rec.cal_type,
x_ci_sequence_number => v_prev_suao_rec.ci_sequence_number,
x_outcome_dt => SYSDATE,
x_ci_start_dt => v_prev_suao_rec.ci_start_dt,
x_ci_end_dt => v_prev_suao_rec.ci_end_dt,
x_grading_schema_cd => v_prev_suao_rec.grading_schema_cd,
x_version_number => v_prev_suao_rec.version_number,
x_grade => v_prev_suao_rec.repeat_grade,
x_attribute_category => v_prev_suao_rec.attribute_category,
x_attribute1 => v_prev_suao_rec.attribute1,
x_attribute2 => v_prev_suao_rec.attribute2,
x_attribute3 => v_prev_suao_rec.attribute3,
x_attribute4 => v_prev_suao_rec.attribute4,
x_attribute5 => v_prev_suao_rec.attribute5,
x_attribute6 => v_prev_suao_rec.attribute6,
x_attribute7 => v_prev_suao_rec.attribute7,
x_attribute8 => v_prev_suao_rec.attribute8,
x_attribute9 => v_prev_suao_rec.attribute9,
x_attribute10 => v_prev_suao_rec.attribute10,
x_attribute11 => v_prev_suao_rec.attribute11,
x_attribute12 => v_prev_suao_rec.attribute12,
x_attribute13 => v_prev_suao_rec.attribute13,
x_attribute14 => v_prev_suao_rec.attribute14,
x_attribute15 => v_prev_suao_rec.attribute15,
x_attribute16 => v_prev_suao_rec.attribute16,
x_attribute17 => v_prev_suao_rec.attribute17,
x_attribute18 => v_prev_suao_rec.attribute18,
x_attribute19 => v_prev_suao_rec.attribute19,
x_attribute20 => v_prev_suao_rec.attribute20,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_mark => v_prev_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_prev_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_prev_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_prev_suao_rec.incomp_version_number,
x_incomp_default_grade => v_prev_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_prev_suao_rec.incomp_default_mark,
x_comments => v_prev_suao_rec.comments,
x_uoo_id => v_prev_suao_rec.uoo_id,
x_mark_capped_flag => v_prev_suao_rec.mark_capped_flag,
x_release_date => v_prev_suao_rec.release_date,
x_manual_override_flag => v_prev_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_prev_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_prev_suao_rec.person_id,
x_course_cd => v_prev_suao_rec.course_cd,
x_unit_cd => v_prev_suao_rec.unit_cd,
x_cal_type => v_prev_suao_rec.cal_type,
x_ci_sequence_number => v_prev_suao_rec.ci_sequence_number,
x_outcome_dt => SYSDATE,
x_ci_start_dt => v_prev_suao_rec.ci_start_dt,
x_ci_end_dt => v_prev_suao_rec.ci_end_dt,
x_grading_schema_cd => v_prev_suao_rec.grading_schema_cd,
x_version_number => v_prev_suao_rec.version_number,
x_grade => v_prev_suao_rec.repeat_grade,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_attribute_category => v_prev_suao_rec.attribute_category,
x_attribute1 => v_prev_suao_rec.attribute1,
x_attribute2 => v_prev_suao_rec.attribute2,
x_attribute3 => v_prev_suao_rec.attribute3,
x_attribute4 => v_prev_suao_rec.attribute4,
x_attribute5 => v_prev_suao_rec.attribute5,
x_attribute6 => v_prev_suao_rec.attribute6,
x_attribute7 => v_prev_suao_rec.attribute7,
x_attribute8 => v_prev_suao_rec.attribute8,
x_attribute9 => v_prev_suao_rec.attribute9,
x_attribute10 => v_prev_suao_rec.attribute10,
x_attribute11 => v_prev_suao_rec.attribute11,
x_attribute12 => v_prev_suao_rec.attribute12,
x_attribute13 => v_prev_suao_rec.attribute13,
x_attribute14 => v_prev_suao_rec.attribute14,
x_attribute15 => v_prev_suao_rec.attribute15,
x_attribute16 => v_prev_suao_rec.attribute16,
x_attribute17 => v_prev_suao_rec.attribute17,
x_attribute18 => v_prev_suao_rec.attribute18,
x_attribute19 => v_prev_suao_rec.attribute19,
x_attribute20 => v_prev_suao_rec.attribute20,
x_mark => v_prev_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_prev_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_prev_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_prev_suao_rec.incomp_version_number,
x_incomp_default_grade => v_prev_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_prev_suao_rec.incomp_default_mark,
x_comments => v_prev_suao_rec.comments,
x_uoo_id => v_prev_suao_rec.uoo_id,
x_mark_capped_flag => v_prev_suao_rec.mark_capped_flag,
x_release_date => v_prev_suao_rec.release_date,
x_manual_override_flag => v_prev_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_prev_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.insert_row (
x_rowid => v_rowid,
x_org_id => NULL,
x_person_id => v_suao_rec.person_id,
x_course_cd => v_suao_rec.course_cd,
x_unit_cd => v_suao_rec.unit_cd,
x_cal_type => v_suao_rec.cal_type,
x_ci_sequence_number => v_suao_rec.ci_sequence_number,
x_outcome_dt => v_new_outcome_dt,
x_ci_start_dt => v_suao_rec.ci_start_dt,
x_ci_end_dt => v_suao_rec.ci_end_dt,
x_grading_schema_cd => v_suao_rec.grading_schema_cd,
x_version_number => v_suao_rec.version_number,
x_grade => v_suao_rec.repeat_grade,
x_s_grade_creation_method_type => 'SYSTEM',
x_finalised_outcome_ind => 'Y',
x_attribute_category => v_suao_rec.attribute_category,
x_attribute1 => v_suao_rec.attribute1,
x_attribute2 => v_suao_rec.attribute2,
x_attribute3 => v_suao_rec.attribute3,
x_attribute4 => v_suao_rec.attribute4,
x_attribute5 => v_suao_rec.attribute5,
x_attribute6 => v_suao_rec.attribute6,
x_attribute7 => v_suao_rec.attribute7,
x_attribute8 => v_suao_rec.attribute8,
x_attribute9 => v_suao_rec.attribute9,
x_attribute10 => v_suao_rec.attribute10,
x_attribute11 => v_suao_rec.attribute11,
x_attribute12 => v_suao_rec.attribute12,
x_attribute13 => v_suao_rec.attribute13,
x_attribute14 => v_suao_rec.attribute14,
x_attribute15 => v_suao_rec.attribute15,
x_attribute16 => v_suao_rec.attribute16,
x_attribute17 => v_suao_rec.attribute17,
x_attribute18 => v_suao_rec.attribute18,
x_attribute19 => v_suao_rec.attribute19,
x_attribute20 => v_suao_rec.attribute20,
x_mark => v_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_incomp_deadline_date => v_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_suao_rec.incomp_version_number,
x_incomp_default_grade => v_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_suao_rec.incomp_default_mark,
x_comments => v_suao_rec.comments,
x_uoo_id => v_suao_rec.uoo_id,
x_mark_capped_flag => v_suao_rec.mark_capped_flag,
x_release_date => v_suao_rec.release_date,
x_manual_override_flag => v_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_suao_rec.show_on_academic_histry_flag
);
igs_as_su_stmptout_pkg.update_row (
x_rowid => v_suao_rec.ROWID,
x_person_id => v_suao_rec.person_id,
x_course_cd => v_suao_rec.course_cd,
x_unit_cd => v_suao_rec.unit_cd,
x_cal_type => v_suao_rec.cal_type,
x_ci_sequence_number => v_suao_rec.ci_sequence_number,
x_outcome_dt => v_new_outcome_dt,
x_ci_start_dt => v_suao_rec.ci_start_dt,
x_ci_end_dt => v_suao_rec.ci_end_dt,
x_grading_schema_cd => v_suao_rec.grading_schema_cd,
x_version_number => v_suao_rec.version_number,
x_grade => v_suao_rec.grade,
x_s_grade_creation_method_type => v_suao_rec.s_grade_creation_method_type,
x_finalised_outcome_ind => 'Y',
x_mark => v_suao_rec.mark,
x_number_times_keyed => NULL,
x_translated_grading_schema_cd => v_translated_grading_schema_cd,
x_translated_version_number => v_translated_version_number,
x_translated_grade => v_translated_grade,
x_translated_dt => v_translated_dt,
x_mode => 'R',
x_grading_period_cd => 'FINAL',
x_attribute_category => v_suao_rec.attribute_category,
x_attribute1 => v_suao_rec.attribute1,
x_attribute2 => v_suao_rec.attribute2,
x_attribute3 => v_suao_rec.attribute3,
x_attribute4 => v_suao_rec.attribute4,
x_attribute5 => v_suao_rec.attribute5,
x_attribute6 => v_suao_rec.attribute6,
x_attribute7 => v_suao_rec.attribute7,
x_attribute8 => v_suao_rec.attribute8,
x_attribute9 => v_suao_rec.attribute9,
x_attribute10 => v_suao_rec.attribute10,
x_attribute11 => v_suao_rec.attribute11,
x_attribute12 => v_suao_rec.attribute12,
x_attribute13 => v_suao_rec.attribute13,
x_attribute14 => v_suao_rec.attribute14,
x_attribute15 => v_suao_rec.attribute15,
x_attribute16 => v_suao_rec.attribute16,
x_attribute17 => v_suao_rec.attribute17,
x_attribute18 => v_suao_rec.attribute18,
x_attribute19 => v_suao_rec.attribute19,
x_attribute20 => v_suao_rec.attribute20,
x_incomp_deadline_date => v_suao_rec.incomp_deadline_date,
x_incomp_grading_schema_cd => v_suao_rec.incomp_grading_schema_cd,
x_incomp_version_number => v_suao_rec.incomp_version_number,
x_incomp_default_grade => v_suao_rec.incomp_default_grade,
x_incomp_default_mark => v_suao_rec.incomp_default_mark,
x_comments => v_suao_rec.comments,
x_uoo_id => v_suao_rec.uoo_id,
x_mark_capped_flag => v_suao_rec.mark_capped_flag,
x_release_date => v_suao_rec.release_date,
x_manual_override_flag => v_suao_rec.manual_override_flag,
x_show_on_academic_histry_flag => v_suao_rec.show_on_academic_histry_flag
);
SELECT gs.grading_schema_cd,
gs.version_number,
ec.key_allow_invalid_ind
FROM igs_en_su_attempt sua,
igs_en_stdnt_ps_att spa,
igs_ps_unit_ofr_opt uoo,
igs_as_grd_schema gs,
igs_as_entry_conf ec
WHERE sua.person_id = p_person_id
AND sua.course_cd = p_course_cd
AND sua.unit_cd = p_unit_cd
AND sua.cal_type = p_teach_cal_type
AND sua.ci_sequence_number = p_teach_ci_sequence_number
AND uoo.uoo_id = sua.uoo_id
-- anilk, 22-Apr-2003, Bug# 2829262
AND sua.uoo_id = p_uoo_id
AND spa.person_id = sua.person_id
AND spa.course_cd = sua.course_cd
AND (EXISTS ( SELECT 'X'
FROM igs_ps_ofr_pat pop
WHERE pop.coo_id = spa.coo_id
AND pop.cal_type = cp_acad_cal_type
AND pop.ci_sequence_number = cp_acad_ci_sequence_number
AND uoo.grading_schema_prcdnce_ind = 'N'
AND pop.grading_schema_cd IS NOT NULL
AND pop.gs_version_number IS NOT NULL
AND sua.grading_schema_code IS NULL
AND sua.gs_version_number IS NULL
AND pop.grading_schema_cd = gs.grading_schema_cd
AND pop.gs_version_number = gs.version_number)
OR (sua.grading_schema_code = gs.grading_schema_cd
AND sua.gs_version_number = gs.version_number
)
)
AND ec.s_control_num = 1;
SELECT gsgt.to_grade
FROM igs_as_grd_sch_trn gsgt
WHERE gsgt.grading_schema_cd = p_grading_schema_cd
AND gsgt.version_number = p_version_number
AND gsgt.grade = p_grade
AND gsgt.to_grading_schema_cd = cp_pop_grading_schema_cd
AND gsgt.to_version_number = cp_pop_gs_version_number;