[Home] [Help]
183: v_credit_point_total NUMBER;
184: v_advanced_standing NUMBER;
185: v_last_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
186: v_result_type IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
187: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
188: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
189: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
190: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
191: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
187: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
188: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
189: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
190: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
191: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
192: v_origin_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
193:
194: CURSOR c_sua_uv IS
195: SELECT sua.person_id,
301: -- c_suao_find_details modified w.r.t. bug number 2829262
302: -------------------------------------------------------------------------------------------
303: BEGIN
304: DECLARE
305: --v_suao_rec IGS_AS_SU_STMPTOUT%ROWTYPE;
306: CURSOR c_suao_find_details
307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
311: SELECT rowid
312: FROM IGS_AS_SU_STMPTOUT
313: WHERE person_id = cp_person_id AND
314: course_cd = cp_course_cd AND
315: uoo_id = cp_uoo_id AND
316: TRUNC(outcome_dt) = TRUNC(cp_discontinued_dt) AND
326: FETCH c_suao_find_details INTO l_rowid;
327: -- check if a record has been found
328: -- if so, the record can be deleted.
329: IF (c_suao_find_details%FOUND) THEN
330: IGS_AS_SU_STMPTOUT_PKG.DELETE_ROW(l_rowid);
331: CLOSE c_suao_find_details;
332: ELSE
333: CLOSE c_suao_find_details;
334: END IF;