DBA Data[Home] [Help]

APPS.IGS_AS_GEN_005 dependencies on IGS_AS_GRD_SCH_TRN

Line 86: -- ? No grade mapping specified in IGS_AS_GRD_SCH_TRN.

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;
90: v_suao_exists BOOLEAN DEFAULT FALSE;

Line 89: v_to_grade igs_as_grd_sch_trn.to_grade%TYPE;

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;
90: v_suao_exists BOOLEAN DEFAULT FALSE;
91: v_alt_cd VARCHAR2 (10);
92: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
93: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 133: FROM igs_as_grd_sch_trn 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
135: AND gsgt.version_number = p_version_number
136: AND gsgt.grade = p_grade
137: AND gsgt.to_grading_schema_cd = cp_grading_schema_cd