APPS.IGS_AS_GEN_005 dependencies on IGS_PS_OFR_PAT

Line 84: -- ? No IGS_PS_OFR_PAT grading schema specified.

80: -- the translation fields as required.
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);

Line 106: cp_acad_cal_type igs_ps_ofr_pat.cal_type%TYPE,

102: AND suao.uoo_id = p_uoo_id
103: AND suao.outcome_dt < p_outcome_dt
104: AND suao.translated_dt IS NOT NULL;
105: CURSOR c_cop (
106: cp_acad_cal_type igs_ps_ofr_pat.cal_type%TYPE,
107: cp_acad_ci_seq_num igs_ps_ofr_pat.ci_sequence_number%TYPE
108: ) IS
109: SELECT cop.grading_schema_cd,
110: cop.gs_version_number

Line 107: cp_acad_ci_seq_num igs_ps_ofr_pat.ci_sequence_number%TYPE

103: AND suao.outcome_dt < p_outcome_dt
104: AND suao.translated_dt IS NOT NULL;
105: CURSOR c_cop (
106: cp_acad_cal_type igs_ps_ofr_pat.cal_type%TYPE,
107: cp_acad_ci_seq_num igs_ps_ofr_pat.ci_sequence_number%TYPE
108: ) IS
109: SELECT cop.grading_schema_cd,
110: cop.gs_version_number
111: FROM igs_en_su_attempt sua,

Line 114: igs_ps_ofr_pat cop

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
118: AND uoo.uoo_id = sua.uoo_id

Line 129: cp_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,

125: AND cop.grading_schema_cd IS NOT NULL
126: AND cop.gs_version_number IS NOT NULL;
127: v_cop_rec c_cop%ROWTYPE;
128: CURSOR c_gsgt (
129: cp_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,
130: cp_gs_ver_num igs_ps_ofr_pat.gs_version_number%TYPE
131: ) IS
132: SELECT gsgt.to_grade
133: FROM igs_as_grd_sch_trn gsgt

Line 130: cp_gs_ver_num igs_ps_ofr_pat.gs_version_number%TYPE

126: AND cop.gs_version_number IS NOT NULL;
127: v_cop_rec c_cop%ROWTYPE;
128: CURSOR c_gsgt (
129: cp_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,
130: cp_gs_ver_num igs_ps_ofr_pat.gs_version_number%TYPE
131: ) IS
132: SELECT gsgt.to_grade
133: FROM igs_as_grd_sch_trn gsgt
134: WHERE gsgt.grading_schema_cd = p_grading_schema_cd

Line 178: -- and that IGS_PS_OFR_PAT.grading_schema_cd is not null for the

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.
182: OPEN c_cop (v_acad_cal_type, v_acad_ci_sequence_number);

Line 581: igs_ps_ofr_pat cop,

577: )
578: )
579: FROM igs_en_stdnt_ps_att sca,
580: igs_en_su_attempt suav,
581: igs_ps_ofr_pat cop,
582: igs_ca_inst ci
583: WHERE sca.person_id = p_person_id
584: AND sca.course_cd = p_course_cd
585: AND sca.person_id = suav.person_id

Line 666: igs_ps_ofr_pat cop,

662: CURSOR c_sca IS
663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code
664: FROM igs_en_stdnt_ps_att sca,
665: igs_en_su_attempt suav,
666: igs_ps_ofr_pat cop,
667: igs_ca_inst ci
668: WHERE sca.person_id = p_person_id
669: AND sca.course_cd = p_course_cd
670: AND sca.person_id = suav.person_id