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_AS_GEN_002 dependencies on IGS_AS_GRD_SCH_GRADE

Line 131: v_ret_val igs_as_grd_sch_grade.grade%TYPE DEFAULT NULL;

127: -- Routine to get the default grade within a nominated grading schema
128: -- which applies to a nominated mark.
129: DECLARE
130: v_rec_found BOOLEAN DEFAULT FALSE;
131: v_ret_val igs_as_grd_sch_grade.grade%TYPE DEFAULT NULL;
132:
133: CURSOR c_gsg IS
134: SELECT grade
135: FROM igs_as_grd_sch_grade

Line 135: FROM igs_as_grd_sch_grade

131: v_ret_val igs_as_grd_sch_grade.grade%TYPE DEFAULT NULL;
132:
133: CURSOR c_gsg IS
134: SELECT grade
135: FROM igs_as_grd_sch_grade
136: WHERE grading_schema_cd = p_grading_schema_cd
137: AND version_number = p_gs_version_number
138: AND (lower_mark_range IS NOT NULL
139: OR upper_mark_range IS NOT NULL

Line 232: -- by the value in the special grade type in the IGS_AS_GRD_SCH_GRADE table.

228: RETURN VARCHAR2 IS
229: gv_other_detail VARCHAR2 (255);
230: BEGIN -- assp_get_gsg_cncd
231: -- Get whether a nominated grade is a 'conceded' pass grade, as indicated
232: -- by the value in the special grade type in the IGS_AS_GRD_SCH_GRADE table.
233: DECLARE
234: cst_conceded_pass CONSTANT VARCHAR2 (15) := 'CONCEDED-PASS';
235: v_s_special_grade_type igs_as_grd_sch_grade.s_special_grade_type%TYPE;
236: CURSOR c_gsg IS

Line 235: v_s_special_grade_type igs_as_grd_sch_grade.s_special_grade_type%TYPE;

231: -- Get whether a nominated grade is a 'conceded' pass grade, as indicated
232: -- by the value in the special grade type in the IGS_AS_GRD_SCH_GRADE table.
233: DECLARE
234: cst_conceded_pass CONSTANT VARCHAR2 (15) := 'CONCEDED-PASS';
235: v_s_special_grade_type igs_as_grd_sch_grade.s_special_grade_type%TYPE;
236: CURSOR c_gsg IS
237: SELECT gsg.s_special_grade_type
238: FROM igs_as_grd_sch_grade gsg
239: WHERE gsg.grading_schema_cd = p_grading_schema_cd

Line 238: FROM igs_as_grd_sch_grade gsg

234: cst_conceded_pass CONSTANT VARCHAR2 (15) := 'CONCEDED-PASS';
235: v_s_special_grade_type igs_as_grd_sch_grade.s_special_grade_type%TYPE;
236: CURSOR c_gsg IS
237: SELECT gsg.s_special_grade_type
238: FROM igs_as_grd_sch_grade gsg
239: WHERE gsg.grading_schema_cd = p_grading_schema_cd
240: AND gsg.version_number = p_version_number
241: AND gsg.grade = p_grade;
242: BEGIN

Line 276: -- a grading schema from the IGS_AS_GRD_SCH_GRADE table.

272: RETURN NUMBER IS
273: gv_other_detail VARCHAR2 (255);
274: BEGIN -- assp_get_gsg_rank
275: -- This module fetches the value for the rank for a grade within
276: -- a grading schema from the IGS_AS_GRD_SCH_GRADE table.
277: DECLARE
278: v_gsg_rank igs_as_grd_sch_grade.RANK%TYPE;
279: CURSOR c_gsg IS
280: SELECT gsg.RANK

Line 278: v_gsg_rank igs_as_grd_sch_grade.RANK%TYPE;

274: BEGIN -- assp_get_gsg_rank
275: -- This module fetches the value for the rank for a grade within
276: -- a grading schema from the IGS_AS_GRD_SCH_GRADE table.
277: DECLARE
278: v_gsg_rank igs_as_grd_sch_grade.RANK%TYPE;
279: CURSOR c_gsg IS
280: SELECT gsg.RANK
281: FROM igs_as_grd_sch_grade gsg
282: WHERE gsg.grading_schema_cd = p_grading_schema_cd

Line 281: FROM igs_as_grd_sch_grade gsg

277: DECLARE
278: v_gsg_rank igs_as_grd_sch_grade.RANK%TYPE;
279: CURSOR c_gsg IS
280: SELECT gsg.RANK
281: FROM igs_as_grd_sch_grade gsg
282: WHERE gsg.grading_schema_cd = p_grading_schema_cd
283: AND gsg.version_number = p_version_number
284: AND gsg.grade = p_grade;
285: BEGIN

Line 315: v_gsg_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

311: RETURN VARCHAR2 IS
312: gv_other_detail VARCHAR2 (255);
313: BEGIN -- assp_get_gsg_result
314: DECLARE
315: v_gsg_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
316: CURSOR c_gsg IS
317: SELECT gsg.s_result_type
318: FROM igs_as_grd_sch_grade gsg
319: WHERE gsg.grading_schema_cd = p_grading_schema_cd

Line 318: FROM igs_as_grd_sch_grade gsg

314: DECLARE
315: v_gsg_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
316: CURSOR c_gsg IS
317: SELECT gsg.s_result_type
318: FROM igs_as_grd_sch_grade gsg
319: WHERE gsg.grading_schema_cd = p_grading_schema_cd
320: AND gsg.version_number = p_version_number
321: AND gsg.grade = p_grade;
322: BEGIN

Line 355: FROM igs_as_grd_sch_grade

351: DECLARE
352: CURSOR c_gsg IS
353: SELECT lower_mark_range,
354: upper_mark_range
355: FROM igs_as_grd_sch_grade
356: WHERE grading_schema_cd = p_grading_schema_cd
357: AND version_number = p_version_number
358: AND grade = p_grade;
359: v_gsg_rec c_gsg%ROWTYPE;