APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_AS_GRD_SCH_TRN

Line 31: v_translated_grading_schema_cd igs_as_grd_sch_trn_all.to_grading_schema_cd%TYPE;

27: v_use_most_recent_unit_attempt igs_en_rep_process.use_most_recent_unit_attempt%TYPE;
28: v_use_best_grade_attempt igs_en_rep_process.use_best_grade_attempt%TYPE;
29: v_external_formula igs_en_rep_process.external_formula%TYPE;
30: v_new_outcome_dt DATE;
31: v_translated_grading_schema_cd igs_as_grd_sch_trn_all.to_grading_schema_cd%TYPE;
32: v_translated_version_number igs_as_grd_sch_trn_all.to_version_number%TYPE;
33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;
34: v_translated_dt DATE;
35: v_rowid VARCHAR2 (25);

Line 32: v_translated_version_number igs_as_grd_sch_trn_all.to_version_number%TYPE;

28: v_use_best_grade_attempt igs_en_rep_process.use_best_grade_attempt%TYPE;
29: v_external_formula igs_en_rep_process.external_formula%TYPE;
30: v_new_outcome_dt DATE;
31: v_translated_grading_schema_cd igs_as_grd_sch_trn_all.to_grading_schema_cd%TYPE;
32: v_translated_version_number igs_as_grd_sch_trn_all.to_version_number%TYPE;
33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;
34: v_translated_dt DATE;
35: v_rowid VARCHAR2 (25);
36: v_best_prev_rank igs_as_grd_sch_grade.RANK%TYPE;

Line 33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;

29: v_external_formula igs_en_rep_process.external_formula%TYPE;
30: v_new_outcome_dt DATE;
31: v_translated_grading_schema_cd igs_as_grd_sch_trn_all.to_grading_schema_cd%TYPE;
32: v_translated_version_number igs_as_grd_sch_trn_all.to_version_number%TYPE;
33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;
34: v_translated_dt DATE;
35: v_rowid VARCHAR2 (25);
36: v_best_prev_rank igs_as_grd_sch_grade.RANK%TYPE;
37: v_best_prev_ci_end_dt igs_as_su_stmptout_all.ci_end_dt%TYPE;

Line 1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;

1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;
1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE;
1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE;
1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
1157: v_key_allow_invalid_ind igs_as_entry_conf.key_allow_invalid_ind%TYPE;
1158: CURSOR c_sua_sca_uoo_pop (
1159: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
1160: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE

Line 1205: FROM igs_as_grd_sch_trn gsgt

1201: cp_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,
1202: cp_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE
1203: ) IS
1204: SELECT gsgt.to_grade
1205: FROM igs_as_grd_sch_trn gsgt
1206: WHERE gsgt.grading_schema_cd = p_grading_schema_cd
1207: AND gsgt.version_number = p_version_number
1208: AND gsgt.grade = p_grade
1209: AND gsgt.to_grading_schema_cd = cp_pop_grading_schema_cd