DBA Data[Home] [Help]

APPS.IGS_PR_CP_GPA dependencies on IGS_AS_GRD_SCH_GRADE

Line 898: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

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

Line 899: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,

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

Line 900: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS

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

Line 903: FROM igs_as_grd_sch_grade gsg

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:

Line 1141: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

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

Line 1142: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,

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

Line 1143: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS

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

Line 1146: FROM igs_as_grd_sch_grade gsg

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:

Line 1163: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

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;

Line 1164: l_gs_version_number igs_as_grd_sch_grade.version_number%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;
1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%TYPE;

Line 1165: l_grade igs_as_grd_sch_grade.grade%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;

Line 1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%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