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

Line 35: IGS_AS_GRD_SCH_GRADE gsg

31: DECLARE
32: CURSOR c_gsg IS
33: SELECT gsg.s_special_grade_type
34: FROM IGS_AS_SU_STMPTOUT suao,
35: IGS_AS_GRD_SCH_GRADE gsg
36: WHERE suao.person_id = p_person_id AND
37: suao.course_cd = p_course_cd AND
38: -- anilk, 22-Apr-2003, Bug# 2829262
39: suao.uoo_id = p_uoo_id AND

Line 54: v_s_special_grade_type IGS_AS_GRD_SCH_GRADE.s_special_grade_type%TYPE;

50:
51: cst_normal CONSTANT VARCHAR2(15) := 'NORMAL';
52: cst_special CONSTANT VARCHAR2(15) := 'SPECIAL';
53: cst_supp CONSTANT VARCHAR2(15) := 'SUPP';
54: v_s_special_grade_type IGS_AS_GRD_SCH_GRADE.s_special_grade_type%TYPE;
55: BEGIN
56: -- If the IGS_PS_UNIT attempt status is not completed then it must be a normal
57: -- examination.
58: IF p_unit_attempt_status <> 'COMPLETED' THEN

Line 233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

229: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
230: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
231: v_finalised_ind VARCHAR2(1);
232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd

Line 234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

230: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
231: v_finalised_ind VARCHAR2(1);
232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

Line 235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

231: v_finalised_ind VARCHAR2(1);
232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number

Line 236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number
240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

Line 242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number
240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

Line 280: IGS_AS_GRD_SCH_GRADE gsg

276: suao.translated_grading_schema_cd,
277: suao.translated_version_number,
278: suao.translated_grade
279: FROM IGS_AS_SU_STMPTOUT suao,
280: IGS_AS_GRD_SCH_GRADE gsg
281: WHERE suao.person_id = cp_person_id AND
282: suao.course_cd = c_v_course_cd AND
283: -- anilk, 22-Apr-2003, Bug# 2829262
284: suao.uoo_id = cp_uoo_id AND

Line 293: FROM IGS_AS_GRD_SCH_GRADE gsg2

289: suao.grade = gsg.grade
290: ORDER BY outcome_dt DESC; -- will put the newest date first.
291: CURSOR c_gsg2 IS
292: SELECT gsg2.s_result_type
293: FROM IGS_AS_GRD_SCH_GRADE gsg2
294: WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
295: gsg2.version_number = v_suao_trans_version_number AND
296: gsg2.grade = v_suao_trans_grade;
297: BEGIN

Line 511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

507: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
508: v_finalised_ind VARCHAR2(1);
509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

Line 512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

508: v_finalised_ind VARCHAR2(1);
509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd

Line 513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

Line 514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number

Line 521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;
524:
525: -- smaddali modified cursor for bug#4666657

Line 553: IGS_AS_GRD_SCH_GRADE gsg

549: suao.translated_version_number,
550: suao.translated_grade,
551: suao.release_date
552: FROM IGS_AS_SU_STMPTOUT suao,
553: IGS_AS_GRD_SCH_GRADE gsg
554: WHERE suao.person_id = p_person_id AND
555: suao.course_cd = cp_course_cd AND
556: -- anilk, 22-Apr-2003, Bug# 2829262
557: suao.uoo_id = p_uoo_id AND

Line 565: FROM IGS_AS_GRD_SCH_GRADE gsg2

561: suao.grade = gsg.grade
562: ORDER BY suao.outcome_dt DESC; -- will put the newest date first.
563: CURSOR c_gsg2 IS
564: SELECT gsg2.s_result_type
565: FROM IGS_AS_GRD_SCH_GRADE gsg2
566: WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
567: gsg2.version_number = v_suao_trans_version_number AND
568: gsg2.grade = v_suao_trans_grade;
569: BEGIN

Line 815: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

811: -- assp_get_trn_sca_dtl.
812: DECLARE
813: v_ret_val VARCHAR2(10);
814: v_outcome_dt DATE;
815: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
816: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
817: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
818: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
819: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;

Line 816: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

812: DECLARE
813: v_ret_val VARCHAR2(10);
814: v_outcome_dt DATE;
815: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
816: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
817: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
818: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
819: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
820: BEGIN

Line 817: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

813: v_ret_val VARCHAR2(10);
814: v_outcome_dt DATE;
815: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
816: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
817: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
818: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
819: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
820: BEGIN
821: v_ret_val := assp_get_sua_outcome(

Line 818: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;

814: v_outcome_dt DATE;
815: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
816: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
817: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
818: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
819: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
820: BEGIN
821: v_ret_val := assp_get_sua_outcome(
822: p_person_id,

Line 1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1621: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1622: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1623: v_finalised_ind VARCHAR2(1);
1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd

Line 1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1622: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1623: v_finalised_ind VARCHAR2(1);
1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

Line 1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1623: v_finalised_ind VARCHAR2(1);
1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number

Line 1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number
1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

Line 1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number
1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

Line 1669: IGS_AS_GRD_SCH_GRADE gsg

1665: suao.translated_grading_schema_cd,
1666: suao.translated_version_number,
1667: suao.translated_grade
1668: FROM IGS_AS_SU_STMPTOUT suao,
1669: IGS_AS_GRD_SCH_GRADE gsg
1670: WHERE suao.person_id = cp_person_id AND
1671: suao.course_cd = c_v_course_cd AND
1672: suao.uoo_id = cp_uoo_id AND
1673: suao.finalised_outcome_ind

Line 1682: FROM IGS_AS_GRD_SCH_GRADE gsg2

1678: nvl(suao.RELEASE_DATE ,sysdate+10) <=sysdate
1679: ORDER BY outcome_dt DESC; -- will put the newest date first.
1680: CURSOR c_gsg2 IS
1681: SELECT gsg2.s_result_type
1682: FROM IGS_AS_GRD_SCH_GRADE gsg2
1683: WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
1684: gsg2.version_number = v_suao_trans_version_number AND
1685: gsg2.grade = v_suao_trans_grade;
1686: BEGIN

Line 1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1813: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1814: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1815: v_finalised_ind VARCHAR2(1);
1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd

Line 1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1814: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1815: v_finalised_ind VARCHAR2(1);
1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

Line 1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1815: v_finalised_ind VARCHAR2(1);
1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number

Line 1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

Line 1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

Line 1863: IGS_AS_GRD_SCH_GRADE gsg

1859: suao.translated_version_number,
1860: suao.translated_grade ,
1861: suao.mark
1862: FROM IGS_AS_SU_STMPTOUT suao,
1863: IGS_AS_GRD_SCH_GRADE gsg
1864: WHERE suao.person_id = cp_person_id AND
1865: suao.course_cd = c_v_course_cd AND
1866: suao.uoo_id = cp_uoo_id AND
1867: suao.finalised_outcome_ind

Line 1876: FROM IGS_AS_GRD_SCH_GRADE gsg2

1872: nvl(suao.RELEASE_DATE ,sysdate+10) <=sysdate
1873: ORDER BY outcome_dt DESC; -- will put the newest date first.
1874: CURSOR c_gsg2 IS
1875: SELECT gsg2.s_result_type
1876: FROM IGS_AS_GRD_SCH_GRADE gsg2
1877: WHERE gsg2.grading_schema_cd = v_suao_trans_grading_schema_cd AND
1878: gsg2.version_number = v_suao_trans_version_number AND
1879: gsg2.grade = v_suao_trans_grade;
1880: BEGIN