eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_GEN_002 dependencies on IGS_AS_GRD_SCH_GRADE

Line 80: RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE AS

76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,
79: p_uoo_id IN NUMBER)
80: RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE AS
81: gv_other_detail VARCHAR2(255);
82: BEGIN -- prgp_get_sua_gpa_val
83: -- Get the GPA value for a nominated IGS_PS_UNIT attempt
84: -- Contains the options to search for:

Line 92: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

88: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
89: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
90: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
91: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
92: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
93: v_finalised_ind VARCHAR2(1);
94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

91: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
92: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
93: v_finalised_ind VARCHAR2(1);
94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

Line 96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

92: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
93: v_finalised_ind VARCHAR2(1);
94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
100: v_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;

Line 97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

93: v_finalised_ind VARCHAR2(1);
94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
100: v_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
101: --

Line 100: v_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;

96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
100: v_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
101: --
102: -- kdande; 22-Apr-2003; Bug# 2829262
103: -- Added uoo_id field to the WHERE clause of cursor c_sua.
104: --

Line 116: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,

112: sua.course_cd = p_course_cd AND
113: sua.uoo_id = p_uoo_id;
114: v_sua_rec c_sua%ROWTYPE;
115: CURSOR c_gsg (
116: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
117: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE,
118: cp_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE) IS
119: SELECT gsg.gpa_val
120: FROM IGS_AS_GRD_SCH_GRADE gsg

Line 117: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE,

113: sua.uoo_id = p_uoo_id;
114: v_sua_rec c_sua%ROWTYPE;
115: CURSOR c_gsg (
116: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
117: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE,
118: cp_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE) IS
119: SELECT gsg.gpa_val
120: FROM IGS_AS_GRD_SCH_GRADE gsg
121: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND

Line 118: cp_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE) IS

114: v_sua_rec c_sua%ROWTYPE;
115: CURSOR c_gsg (
116: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
117: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE,
118: cp_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE) IS
119: SELECT gsg.gpa_val
120: FROM IGS_AS_GRD_SCH_GRADE gsg
121: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
122: gsg.version_number = cp_version_number AND

Line 120: FROM IGS_AS_GRD_SCH_GRADE gsg

116: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
117: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE,
118: cp_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE) IS
119: SELECT gsg.gpa_val
120: FROM IGS_AS_GRD_SCH_GRADE gsg
121: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
122: gsg.version_number = cp_version_number AND
123: gsg.grade = cp_grade;
124: FUNCTION prgp_get_best_worst (

Line 140: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

136: gv_other_detail VARCHAR2(255);
137: BEGIN -- prgp_get_best_worst
138: DECLARE
139: v_returned BOOLEAN;
140: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (

Line 141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

137: BEGIN -- prgp_get_best_worst
138: DECLARE
139: v_returned BOOLEAN;
140: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (
145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,

Line 142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;

138: DECLARE
139: v_returned BOOLEAN;
140: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (
145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS

Line 143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;

139: v_returned BOOLEAN;
140: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (
145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
147: SELECT MAX(gsg.gpa_val),

Line 145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,

141: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (
145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
147: SELECT MAX(gsg.gpa_val),
148: MIN(gsg.gpa_val)
149: FROM IGS_AS_GRD_SCH_GRADE gsg

Line 146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS

142: v_max_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
143: v_min_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
144: CURSOR c_gsg (
145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
147: SELECT MAX(gsg.gpa_val),
148: MIN(gsg.gpa_val)
149: FROM IGS_AS_GRD_SCH_GRADE gsg
150: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND

Line 149: FROM IGS_AS_GRD_SCH_GRADE gsg

145: cp_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
146: cp_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
147: SELECT MAX(gsg.gpa_val),
148: MIN(gsg.gpa_val)
149: FROM IGS_AS_GRD_SCH_GRADE gsg
150: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
151: gsg.version_number = cp_version_number AND
152: gsg.gpa_val IS NOT NULL;
153: BEGIN

Line 461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

457: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
458: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
459: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

Line 463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

459: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

Line 464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;

Line 465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;
469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

724: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
725: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
726: cst_abort_WAM CONSTANT NUMBER := -1000000;
727: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

Line 730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

726: cst_abort_WAM CONSTANT NUMBER := -1000000;
727: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

Line 731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

727: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
735: v_finalised_ind VARCHAR2(1);

Line 732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
735: v_finalised_ind VARCHAR2(1);
736: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;