[Home] [Help]
40: SELECT uv.repeatable_ind,
41: rp_org.use_most_recent_unit_attempt,
42: rp_org.use_best_grade_attempt,
43: rp_org.external_formula
44: FROM igs_ps_unit_ofr_opt_all uoo,
45: igs_ps_unit_ver_all uv,
46: igs_en_rep_process rp_org,
47: igs_or_inst_org_base_v hp
48: WHERE uoo.uoo_id = p_uoo_id
55: SELECT uv1.repeatable_ind,
56: rp_inst.use_most_recent_unit_attempt,
57: rp_inst.use_best_grade_attempt,
58: rp_inst.external_formula
59: FROM igs_ps_unit_ofr_opt_all uoo1,
60: igs_ps_unit_ver_all uv1,
61: igs_en_rep_process rp_inst
62: WHERE uoo1.uoo_id = p_uoo_id
63: AND uoo1.unit_cd = uv1.unit_cd
63: AND uoo1.unit_cd = uv1.unit_cd
64: AND uoo1.version_number = uv1.version_number
65: AND rp_inst.org_unit_id IS NULL
66: AND NOT EXISTS ( SELECT 'X'
67: FROM igs_ps_unit_ofr_opt_all uoo2,
68: igs_en_rep_process rp_org,
69: igs_or_inst_org_base_v hp
70: WHERE uoo1.uoo_id = uoo2.uoo_id
71: AND uoo2.owner_org_unit_cd = hp.party_number
1163: gs.version_number,
1164: ec.key_allow_invalid_ind
1165: FROM igs_en_su_attempt sua,
1166: igs_en_stdnt_ps_att spa,
1167: igs_ps_unit_ofr_opt uoo,
1168: igs_as_grd_schema gs,
1169: igs_as_entry_conf ec
1170: WHERE sua.person_id = p_person_id
1171: AND sua.course_cd = p_course_cd
1210: AND gsgt.to_version_number = cp_pop_gs_version_number;
1211: BEGIN
1212: --
1213: -- Translation
1214: -- Verify that the IGS_PS_UNIT_OFR_OPT.grading_schema_prcdnce_ind = 'N' and
1215: -- that IGS_PS_OFR_PAT.grading_schema_cd is not null for the student
1216: -- unit attempt and get the IGS_PS_COURSE offering pattern grading schema that will
1217: -- be used in the translation. Otherwise return NULL as no translation possible.
1218: --