APPS.IGS_EN_GEN_008 dependencies on IGS_AS_SU_STMPTOUT

Line 244: v_grade igs_as_su_stmptout.grade%TYPE;

240: -- w.r.t. bug number 2829262
241: -------------------------------------------------------------------------------------------
242: BEGIN
243: DECLARE
244: v_grade igs_as_su_stmptout.grade%TYPE;
245: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
246: v_version_number igs_as_su_stmptout.version_number%TYPE;
247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:

Line 245: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;

241: -------------------------------------------------------------------------------------------
242: BEGIN
243: DECLARE
244: v_grade igs_as_su_stmptout.grade%TYPE;
245: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
246: v_version_number igs_as_su_stmptout.version_number%TYPE;
247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:
249: CURSOR c_suao (

Line 246: v_version_number igs_as_su_stmptout.version_number%TYPE;

242: BEGIN
243: DECLARE
244: v_grade igs_as_su_stmptout.grade%TYPE;
245: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
246: v_version_number igs_as_su_stmptout.version_number%TYPE;
247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:
249: CURSOR c_suao (
250: cp_person_id igs_en_su_attempt.person_id%TYPE,

Line 257: FROM igs_as_su_stmptout suao

253: SELECT suao.grade,
254: suao.grading_schema_cd,
255: suao.version_number,
256: suao.finalised_outcome_ind
257: FROM igs_as_su_stmptout suao
258: WHERE suao.person_id = cp_person_id AND
259: suao.course_cd = cp_course_cd AND
260: suao.uoo_id = cp_uoo_id
261: ORDER BY suao.outcome_dt;

Line 264: cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

260: suao.uoo_id = cp_uoo_id
261: ORDER BY suao.outcome_dt;
262:
263: CURSOR c_gsg (
264: cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
265: cp_version_number igs_as_su_stmptout.version_number%TYPE,
266: cp_grade igs_as_su_stmptout.grade%TYPE) IS
267: SELECT gsg.s_result_type
268: FROM igs_as_grd_sch_grade gsg

Line 265: cp_version_number igs_as_su_stmptout.version_number%TYPE,

261: ORDER BY suao.outcome_dt;
262:
263: CURSOR c_gsg (
264: cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
265: cp_version_number igs_as_su_stmptout.version_number%TYPE,
266: cp_grade igs_as_su_stmptout.grade%TYPE) IS
267: SELECT gsg.s_result_type
268: FROM igs_as_grd_sch_grade gsg
269: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND

Line 266: cp_grade igs_as_su_stmptout.grade%TYPE) IS

262:
263: CURSOR c_gsg (
264: cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
265: cp_version_number igs_as_su_stmptout.version_number%TYPE,
266: cp_grade igs_as_su_stmptout.grade%TYPE) IS
267: SELECT gsg.s_result_type
268: FROM igs_as_grd_sch_grade gsg
269: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
270: gsg.version_number = cp_version_number AND

Line 277: -- 1. Select the latest finalised grade from the IGS_AS_SU_STMPTOUT

273: -- This function gets the result type of a student IGS_PS_UNIT attempt.
274: -- The routine will determine the latest finalized grade for the UA and
275: -- return it's result type. The valid return values are those in the
276: -- s_result_type table.
277: -- 1. Select the latest finalised grade from the IGS_AS_SU_STMPTOUT
278: -- table.
279: FOR v_suao_row IN c_suao( p_person_id,
280: p_course_cd,
281: p_uoo_id) LOOP