894: ci2.sequence_number
895: AND ci.start_dt <= ci2.start_dt)));
896:
897: CURSOR c_gsg(
898: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
899: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
900: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
901: SELECT s_result_type,
902: gpa_val
895: AND ci.start_dt <= ci2.start_dt)));
896:
897: CURSOR c_gsg(
898: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
899: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
900: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
901: SELECT s_result_type,
902: gpa_val
903: FROM igs_as_grd_sch_grade gsg
896:
897: CURSOR c_gsg(
898: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
899: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
900: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
901: SELECT s_result_type,
902: gpa_val
903: FROM igs_as_grd_sch_grade gsg
904: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
899: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
900: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
901: SELECT s_result_type,
902: gpa_val
903: FROM igs_as_grd_sch_grade gsg
904: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
905: AND gsg.version_number = cp_gs_version_number
906: AND gsg.grade = cp_grade;
907:
1137:
1138: -- This cursor fetches the gpa_value for the Grading Schema Code
1139: -- ijeddy, bug 3489388 added show_in_earned_crdt_indto the cursor.
1140: CURSOR c_grad_schema_gpa(
1141: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1142: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1143: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
1144: SELECT gsg.gpa_val,
1145: NVL (gsg.show_in_earned_crdt_ind, 'N') show_in_earned_crdt_ind
1138: -- This cursor fetches the gpa_value for the Grading Schema Code
1139: -- ijeddy, bug 3489388 added show_in_earned_crdt_indto the cursor.
1140: CURSOR c_grad_schema_gpa(
1141: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1142: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1143: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
1144: SELECT gsg.gpa_val,
1145: NVL (gsg.show_in_earned_crdt_ind, 'N') show_in_earned_crdt_ind
1146: FROM igs_as_grd_sch_grade gsg
1139: -- ijeddy, bug 3489388 added show_in_earned_crdt_indto the cursor.
1140: CURSOR c_grad_schema_gpa(
1141: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1142: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1143: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
1144: SELECT gsg.gpa_val,
1145: NVL (gsg.show_in_earned_crdt_ind, 'N') show_in_earned_crdt_ind
1146: FROM igs_as_grd_sch_grade gsg
1147: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
1142: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1143: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
1144: SELECT gsg.gpa_val,
1145: NVL (gsg.show_in_earned_crdt_ind, 'N') show_in_earned_crdt_ind
1146: FROM igs_as_grd_sch_grade gsg
1147: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
1148: AND gsg.version_number = cp_gs_version_number
1149: AND gsg.grade = cp_grade;
1150:
1159: l_uv_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1160: l_unit_cp NUMBER := 0;
1161: l_result_type VARCHAR2(20);
1162: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
1163: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1164: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1165: l_grade igs_as_grd_sch_grade.grade%TYPE;
1166: l_mark igs_as_su_stmptout.mark%TYPE;
1167: l_gsg_gpa_value NUMBER;
1160: l_unit_cp NUMBER := 0;
1161: l_result_type VARCHAR2(20);
1162: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
1163: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1164: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1165: l_grade igs_as_grd_sch_grade.grade%TYPE;
1166: l_mark igs_as_su_stmptout.mark%TYPE;
1167: l_gsg_gpa_value NUMBER;
1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%TYPE;
1161: l_result_type VARCHAR2(20);
1162: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
1163: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1164: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1165: l_grade igs_as_grd_sch_grade.grade%TYPE;
1166: l_mark igs_as_su_stmptout.mark%TYPE;
1167: l_gsg_gpa_value NUMBER;
1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%TYPE;
1169: l_origin_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1164: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1165: l_grade igs_as_grd_sch_grade.grade%TYPE;
1166: l_mark igs_as_su_stmptout.mark%TYPE;
1167: l_gsg_gpa_value NUMBER;
1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%TYPE;
1169: l_origin_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1170: BEGIN
1171: -- Initialize message list if p_init_msg_list is set to TRUE.
1172: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN