[Home] [Help]
81: --
82: -- Conditions where no translation occurs:
83: --
84: -- ? No IGS_PS_OFR_PAT grading schema specified.
85: -- ? IGS_PS_UNIT_OFR_OPT.grading_schema_prcdnce_ind = 'Y'
86: -- ? No grade mapping specified in IGS_AS_GRD_SCH_TRN.
87: DECLARE
88: v_suao_rec_exists VARCHAR2 (1);
89: v_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
109: SELECT cop.grading_schema_cd,
110: cop.gs_version_number
111: FROM igs_en_su_attempt sua,
112: igs_en_stdnt_ps_att sca,
113: igs_ps_unit_ofr_opt uoo,
114: igs_ps_ofr_pat cop
115: WHERE sua.person_id = p_person_id
116: AND sua.course_cd = p_course_cd
117: AND sua.uoo_id = p_uoo_id
173: IF v_message_name IS NOT NULL THEN
174: p_message_name := v_message_name;
175: RETURN FALSE;
176: END IF;
177: -- Verify that the IGS_PS_UNIT_OFR_OPT.grading_schema_prcdnce_ind = 'N'
178: -- and that IGS_PS_OFR_PAT.grading_schema_cd is not null for the
179: -- student unit attempt and get the course offering pattern grading schema
180: -- that will be used in the translation. Otherwise skip the student unit
181: -- attempt as no translation possible.
267: v_message_name VARCHAR2 (30);
268: v_func_ret_flag BOOLEAN;
269: CURSOR cur_uoo_id IS
270: SELECT uoo_id
271: FROM igs_ps_unit_ofr_opt
272: WHERE unit_cd = p_unit_cd
273: AND version_number = p_version_number
274: AND cal_type = p_cal_type
275: AND ci_sequence_number = p_ci_sequence_number
769: -- Get the Unit Section Identifier
770: --
771: CURSOR cur_uoo_id IS
772: SELECT uoo_id
773: FROM igs_ps_unit_ofr_opt
774: WHERE unit_cd = p_unit_cd
775: AND version_number = p_version_number
776: AND cal_type = p_cal_type
777: AND ci_sequence_number = p_ci_sequence_number;