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_CALC_AWARD_MARK dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 474: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,

470: ORDER BY priority_num ASC;
471:
472: /* jhanda */
473: CURSOR c_av_ulvl_marks (
474: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
475: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
476: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
477: )
478: IS

Line 475: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,

471:
472: /* jhanda */
473: CURSOR c_av_ulvl_marks (
474: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
475: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
476: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
477: )
478: IS
479: SELECT NVL(SUM (NVL (ulvl.unit_level_mark, 0)),0) avstdmarks,

Line 544: || ' FROM igs_as_su_stmptout_all suao, igs_en_su_attempt_all sua, '

540: || ' sua.version_number,sua.unit_attempt_status, '
541: || ' sua.cal_type,sua.ci_sequence_number, '
542: || ' sua.uoo_id,sua.override_achievable_cp, '
543: || ' sua.override_enrolled_cp ) earned_cp '
544: || ' FROM igs_as_su_stmptout_all suao, igs_en_su_attempt_all sua, '
545: || ' igs_ps_unit_lvl_all ul, igs_ps_unit_ver_all uv , '
546: || ' igs_ps_unit_level_all lvl '
547: || ' WHERE suao.person_id = :1 AND suao.course_cd = :2 '
548: || ' AND suao.person_id= sua.person_id AND suao.course_cd = sua.course_cd '

Line 558: || ' FROM igs_as_su_stmptout_all suao2 '

554: || ' AND lvl.unit_level = uv.unit_level '
555: || ' AND NVL(suao.mark,igs_as_calc_award_mark.get_mark '
556: || ' (suao.grading_schema_cd,suao.version_number,suao.grade)) IS NOT NULL '
557: || ' AND suao.outcome_dt = ( SELECT max(outcome_dt) '
558: || ' FROM igs_as_su_stmptout_all suao2 '
559: || ' WHERE suao2.person_id = suao.person_id '
560: || ' AND suao2.course_cd = suao.course_cd '
561: || ' AND suao2.grading_period_cd = suao.grading_period_cd '
562: || ' AND suao2.uoo_id= suao.uoo_id ) '

Line 569: l_grade igs_as_su_stmptout_all.grade%TYPE;

565: -- local variables to store the output of the ref cursor
566: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
567: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
568: l_mark NUMBER;
569: l_grade igs_as_su_stmptout_all.grade%TYPE;
570: l_earned_cp NUMBER;
571: l_wam_weight igs_ps_unit_lvl.wam_weighting%TYPE;
572: /*jhanda */
573: l_advstnd_cp NUMBER;

Line 577: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,

573: l_advstnd_cp NUMBER;
574:
575: -- cursor to fetch earned cp, mark and wam when there is no setup available
576: CURSOR c_unit_lvl_mark_wo_setup (
577: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
578: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
579: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
580: )
581: IS

Line 578: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,

574:
575: -- cursor to fetch earned cp, mark and wam when there is no setup available
576: CURSOR c_unit_lvl_mark_wo_setup (
577: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
578: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
579: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
580: )
581: IS
582: SELECT sua.unit_cd, sua.uoo_id,

Line 606: FROM igs_as_su_stmptout_all suao,

602: sua.override_achievable_cp,
603: sua.override_enrolled_cp
604: )
605: earned_cp
606: FROM igs_as_su_stmptout_all suao,
607: igs_en_su_attempt_all sua,
608: igs_ps_unit_lvl_all ul,
609: igs_ps_unit_ver_all uv,
610: igs_ps_unit_level_all lvl

Line 632: FROM igs_as_su_stmptout_all suao2

628: suao.grade
629: )
630: ) IS NOT NULL
631: AND suao.outcome_dt = (SELECT MAX (outcome_dt)
632: FROM igs_as_su_stmptout_all suao2
633: WHERE suao2.person_id = suao.person_id
634: AND suao2.course_cd = suao.course_cd
635: AND suao2.grading_period_cd =
636: suao.grading_period_cd