[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT suao.person_id,
suao.course_cd,
suao.unit_cd,
suao.cal_type,
suao.ci_sequence_number,
-- anilk, 22-Apr-2003, Bug# 2829262
suao.uoo_id,
suao.ci_start_dt,
suao.ci_end_dt,
suao.grade,
suao.incomp_grading_schema_cd,
suao.incomp_version_number,
suao.incomp_default_grade,
suao.incomp_default_mark,
uv.title,
uv.short_title,
ci.description
FROM igs_as_suaoa_v suao,
igs_en_su_attempt sua,
igs_ps_unit_ver uv,
igs_ca_inst ci
WHERE suao.person_id = sua.person_id
AND suao.course_cd = sua.course_cd
-- anilk, 22-Apr-2003, Bug# 2829262
AND suao.uoo_id = sua.uoo_id
AND sua.unit_cd = uv.unit_cd
AND sua.version_number = uv.version_number
AND sua.cal_type = ci.cal_type
AND sua.ci_sequence_number = ci.sequence_number
AND TRUNC(suao.incomp_deadline_date) <= TRUNC(SYSDATE)
AND suao.finalised_outcome_ind = 'Y'
AND suao.grading_period_cd = 'FINAL';
SAVEPOINT s_before_insert;
IGS_AS_SU_STMPTOUT_PKG.INSERT_ROW(
X_ROWID => x_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 => l_sysdate,
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.incomp_grading_schema_cd,
X_VERSION_NUMBER => v_suao_rec.incomp_version_number,
X_GRADE => v_suao_rec.incomp_default_grade,
X_S_GRADE_CREATION_METHOD_TYPE => 'SYSTEM',
X_FINALISED_OUTCOME_IND => 'N',
X_MARK => v_suao_rec.incomp_default_mark,
X_NUMBER_TIMES_KEYED => NULL,
X_TRANSLATED_GRADING_SCHEMA_CD => NULL,
X_TRANSLATED_VERSION_NUMBER => NULL,
X_TRANSLATED_GRADE => NULL,
X_TRANSLATED_DT => NULL,
X_MODE => 'R',
X_GRADING_PERIOD_CD => 'FINAL',
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_INCOMP_DEADLINE_DATE => NULL,
X_INCOMP_GRADING_SCHEMA_CD => NULL,
X_INCOMP_VERSION_NUMBER => NULL,
X_INCOMP_DEFAULT_GRADE => NULL,
X_INCOMP_DEFAULT_MARK => NULL,
X_COMMENTS => NULL,
-- anilk, 22-Apr-2003, Bug# 2829262
X_UOO_ID => v_suao_rec.uoo_id,
x_mark_capped_flag => 'N',
x_show_on_academic_histry_flag => 'Y',
x_release_date => NULL,
x_manual_override_flag => 'N'
);
ROLLBACK TO s_before_insert;