The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT unit_section_status
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
Select unit_Attempt_Status
FROM igs_En_su_Attempt
where person_Id = p_person_id
AND course_cd = p_course_cd
AND uoo_id = p_uoo_id;
SELECT igs_en_su_attempt.*
FROM igs_en_su_attempt
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
uoo_id = p_uoo_id;
igs_en_sua_api.update_unit_attempt(
X_ROWID => igs_en_su_attempt_rec.row_id,
X_PERSON_ID => igs_en_su_attempt_rec.person_id,
X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
X_ADMINISTRATIVE_UNIT_STATUS => NULL,
X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
X_DISCONTINUED_DT => NULL,
X_DCNT_REASON_CD => NULL,
X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
X_MODE => 'R',
X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
X_CART => igs_en_su_attempt_rec.CART,
X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );