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

Line 109: FUNCTION get_mark (p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

105: END IF;
106: CLOSE c1;
107: END chk_if_excluded_unit;
108:
109: FUNCTION get_mark (p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
110: p_gs_version_number igs_as_su_stmptout.version_number%TYPE,
111: p_grade igs_as_su_stmptout.grade%TYPE)
112: RETURN NUMBER
113: IS

Line 110: p_gs_version_number igs_as_su_stmptout.version_number%TYPE,

106: CLOSE c1;
107: END chk_if_excluded_unit;
108:
109: FUNCTION get_mark (p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
110: p_gs_version_number igs_as_su_stmptout.version_number%TYPE,
111: p_grade igs_as_su_stmptout.grade%TYPE)
112: RETURN NUMBER
113: IS
114:

Line 111: p_grade igs_as_su_stmptout.grade%TYPE)

107: END chk_if_excluded_unit;
108:
109: FUNCTION get_mark (p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
110: p_gs_version_number igs_as_su_stmptout.version_number%TYPE,
111: p_grade igs_as_su_stmptout.grade%TYPE)
112: RETURN NUMBER
113: IS
114:
115: -- cursor to get amrk from outcome table

Line 116: CURSOR c_mark (cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

112: RETURN NUMBER
113: IS
114:
115: -- cursor to get amrk from outcome table
116: CURSOR c_mark (cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
117: cp_gs_version_number igs_as_su_stmptout.version_number%TYPE,
118: cp_grade igs_as_su_stmptout.grade%TYPE) IS
119: SELECT upper_mark_range
120: FROM igs_as_grd_sch_grade

Line 117: cp_gs_version_number igs_as_su_stmptout.version_number%TYPE,

113: IS
114:
115: -- cursor to get amrk from outcome table
116: CURSOR c_mark (cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
117: cp_gs_version_number igs_as_su_stmptout.version_number%TYPE,
118: cp_grade igs_as_su_stmptout.grade%TYPE) IS
119: SELECT upper_mark_range
120: FROM igs_as_grd_sch_grade
121: WHERE grading_schema_cd = cp_grading_schema_cd

Line 118: cp_grade igs_as_su_stmptout.grade%TYPE) IS

114:
115: -- cursor to get amrk from outcome table
116: CURSOR c_mark (cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
117: cp_gs_version_number igs_as_su_stmptout.version_number%TYPE,
118: cp_grade igs_as_su_stmptout.grade%TYPE) IS
119: SELECT upper_mark_range
120: FROM igs_as_grd_sch_grade
121: WHERE grading_schema_cd = cp_grading_schema_cd
122: AND version_number = cp_gs_version_number

Line 155: FUNCTION get_earned_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,

151: CLOSE c_unit_ver;
152: RETURN l_unit_ver;
153: END get_unit_ver;
154:
155: FUNCTION get_earned_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
156: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
157: p_unit_cd igs_as_su_stmptout.unit_cd%TYPE,
158: p_version_number igs_ps_unit_ver.version_number%TYPE,
159: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,

Line 156: p_course_cd igs_as_su_stmptout.course_cd%TYPE,

152: RETURN l_unit_ver;
153: END get_unit_ver;
154:
155: FUNCTION get_earned_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
156: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
157: p_unit_cd igs_as_su_stmptout.unit_cd%TYPE,
158: p_version_number igs_ps_unit_ver.version_number%TYPE,
159: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,
160: p_teach_cal_type igs_ca_inst.cal_type%TYPE,

Line 157: p_unit_cd igs_as_su_stmptout.unit_cd%TYPE,

153: END get_unit_ver;
154:
155: FUNCTION get_earned_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
156: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
157: p_unit_cd igs_as_su_stmptout.unit_cd%TYPE,
158: p_version_number igs_ps_unit_ver.version_number%TYPE,
159: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,
160: p_teach_cal_type igs_ca_inst.cal_type%TYPE,
161: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

Line 191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

187: l_result_type VARCHAR2(200);
188:
189:
190: -- OUT variables for the assp_get_sua_outcomes
191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;
194: l_grade igs_as_su_stmptout.grade%TYPE;
195: l_mark igs_as_su_stmptout.mark%TYPE;

Line 192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;

188:
189:
190: -- OUT variables for the assp_get_sua_outcomes
191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;
194: l_grade igs_as_su_stmptout.grade%TYPE;
195: l_mark igs_as_su_stmptout.mark%TYPE;
196: l_origin_course_cd igs_ps_ver.course_cd%TYPE;

Line 193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;

189:
190: -- OUT variables for the assp_get_sua_outcomes
191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;
194: l_grade igs_as_su_stmptout.grade%TYPE;
195: l_mark igs_as_su_stmptout.mark%TYPE;
196: l_origin_course_cd igs_ps_ver.course_cd%TYPE;
197:

Line 194: l_grade igs_as_su_stmptout.grade%TYPE;

190: -- OUT variables for the assp_get_sua_outcomes
191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;
194: l_grade igs_as_su_stmptout.grade%TYPE;
195: l_mark igs_as_su_stmptout.mark%TYPE;
196: l_origin_course_cd igs_ps_ver.course_cd%TYPE;
197:
198: BEGIN

Line 195: l_mark igs_as_su_stmptout.mark%TYPE;

191: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
192: l_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
193: l_gs_version_number igs_as_su_stmptout.version_number%TYPE;
194: l_grade igs_as_su_stmptout.grade%TYPE;
195: l_mark igs_as_su_stmptout.mark%TYPE;
196: l_origin_course_cd igs_ps_ver.course_cd%TYPE;
197:
198: BEGIN
199: IF p_override_achievable_cp IS NULL THEN

Line 244: FUNCTION get_avail_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,

240: END IF;
241:
242: END get_earned_cp;
243:
244: FUNCTION get_avail_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
245: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
246: p_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
247: p_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE)
248: RETURN NUMBER

Line 245: p_course_cd igs_as_su_stmptout.course_cd%TYPE,

241:
242: END get_earned_cp;
243:
244: FUNCTION get_avail_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
245: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
246: p_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
247: p_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE)
248: RETURN NUMBER
249: IS

Line 251: CURSOR c_avail_cp (cp_person_id igs_as_su_stmptout.person_id%TYPE,

247: p_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE)
248: RETURN NUMBER
249: IS
250: -- cursor to get the sum of available cp
251: CURSOR c_avail_cp (cp_person_id igs_as_su_stmptout.person_id%TYPE,
252: cp_course_cd igs_as_su_stmptout.course_cd%TYPE,
253: cp_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
254: cp_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE) IS
255: SELECT SUM(

Line 252: cp_course_cd igs_as_su_stmptout.course_cd%TYPE,

248: RETURN NUMBER
249: IS
250: -- cursor to get the sum of available cp
251: CURSOR c_avail_cp (cp_person_id igs_as_su_stmptout.person_id%TYPE,
252: cp_course_cd igs_as_su_stmptout.course_cd%TYPE,
253: cp_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
254: cp_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE) IS
255: SELECT SUM(
256: get_earned_cp

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 504: || ' FROM igs_as_su_stmptout stmpt, igs_en_su_attempt sua ,IGS_PS_UNIT_LVL_ALL UL , IGS_PS_UNIT_VER_ALL UV , IGS_PS_UNIT_LEVEL_ALL LVL '

500: || ' sua.cal_type,sua.ci_sequence_number, '
501: || ' sua.uoo_id,sua.override_achievable_cp, '
502: || ' sua.override_enrolled_cp ) earned_cp, '
503: || ' NVL(ul.wam_weighting,NVL( lvl.wam_weighting,1)) wam_weight '
504: || ' FROM igs_as_su_stmptout stmpt, igs_en_su_attempt sua ,IGS_PS_UNIT_LVL_ALL UL , IGS_PS_UNIT_VER_ALL UV , IGS_PS_UNIT_LEVEL_ALL LVL '
505: || ' WHERE stmpt.person_id = :1 AND stmpt.course_cd = :2 '
506: || ' AND stmpt.person_id = sua.person_id '
507: || ' AND stmpt.course_cd = sua.course_cd '
508: || ' AND stmpt.uoo_id = sua.uoo_id '

Line 523: || ' FROM igs_as_su_stmptout suao '

519: || ' AND NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '
520: || ' (stmpt.grading_schema_cd, '
521: || ' stmpt.version_number,stmpt.grade)) IS NOT NULL '
522: || ' AND stmpt.outcome_dt = ( SELECT max(outcome_dt) '
523: || ' FROM igs_as_su_stmptout suao '
524: || ' WHERE suao.person_id = stmpt.person_id '
525: || ' AND suao.course_cd =stmpt.course_cd '
526: || ' AND suao.outcome_dt = stmpt.outcome_dt '
527: || ' AND suao.grading_period_cd = stmpt. grading_period_cd '

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