APPS.IGS_PR_ACAD_DETAILS dependencies on IGS_AS_GRD_SCH_GRADE

Line 30: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

26: v_init_msg_list VARCHAR2(20):= FND_API.G_TRUE;
27: v_return_status VARCHAR2(1);
28: v_msg_count NUMBER;
29: v_msg_data VARCHAR2(2000);
30: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
31: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
32: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
33: v_grade igs_as_grd_sch_grade.grade%TYPE;
34: v_mark igs_as_su_stmptout.mark%TYPE;

Line 31: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

27: v_return_status VARCHAR2(1);
28: v_msg_count NUMBER;
29: v_msg_data VARCHAR2(2000);
30: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
31: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
32: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
33: v_grade igs_as_grd_sch_grade.grade%TYPE;
34: v_mark igs_as_su_stmptout.mark%TYPE;
35: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

Line 32: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;

28: v_msg_count NUMBER;
29: v_msg_data VARCHAR2(2000);
30: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
31: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
32: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
33: v_grade igs_as_grd_sch_grade.grade%TYPE;
34: v_mark igs_as_su_stmptout.mark%TYPE;
35: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
36: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;

Line 33: v_grade igs_as_grd_sch_grade.grade%TYPE;

29: v_msg_data VARCHAR2(2000);
30: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
31: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
32: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
33: v_grade igs_as_grd_sch_grade.grade%TYPE;
34: v_mark igs_as_su_stmptout.mark%TYPE;
35: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
36: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
37: v_dummy VARCHAR2(1);

Line 40: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

36: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
37: v_dummy VARCHAR2(1);
38: --
39: CURSOR c_gsg (
40: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
41: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
42: cp_grade igs_as_grd_sch_grade.grade%TYPE
43: ) IS
44: SELECT 'X'

Line 41: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,

37: v_dummy VARCHAR2(1);
38: --
39: CURSOR c_gsg (
40: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
41: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
42: cp_grade igs_as_grd_sch_grade.grade%TYPE
43: ) IS
44: SELECT 'X'
45: FROM igs_as_grd_sch_grade gsg

Line 42: cp_grade igs_as_grd_sch_grade.grade%TYPE

38: --
39: CURSOR c_gsg (
40: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
41: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
42: cp_grade igs_as_grd_sch_grade.grade%TYPE
43: ) IS
44: SELECT 'X'
45: FROM igs_as_grd_sch_grade gsg
46: WHERE cp_grading_schema_cd = gsg.grading_schema_cd

Line 45: FROM igs_as_grd_sch_grade gsg

41: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
42: cp_grade igs_as_grd_sch_grade.grade%TYPE
43: ) IS
44: SELECT 'X'
45: FROM igs_as_grd_sch_grade gsg
46: WHERE cp_grading_schema_cd = gsg.grading_schema_cd
47: AND cp_version_number = gsg.version_number
48: AND cp_grade = gsg.grade
49: AND gsg.show_on_official_ntfctn_ind = 'Y';

Line 146: v_load_gpa igs_as_grd_sch_grade.gpa_val%TYPE;

142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
144: ) AS
145: --
146: v_load_gpa igs_as_grd_sch_grade.gpa_val%TYPE;
147: v_load_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
148: v_load_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE;
149: v_load_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
150: v_load_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;