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.

[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_UNIT_VER

Line 158: p_version_number igs_ps_unit_ver.version_number%TYPE,

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,
162: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 168: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,

164: p_override_enrolled_cp NUMBER DEFAULT NULL)
165: RETURN NUMBER IS
166: -- cursor to get the cp defined at sua
167: CURSOR c_sua_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
168: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
169: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
170: SELECT NVL(uc.achievable_credit_points,
171: NVL(uv.achievable_credit_points,
172: NVL(p_override_enrolled_cp,

Line 169: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS

165: RETURN NUMBER IS
166: -- cursor to get the cp defined at sua
167: CURSOR c_sua_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
168: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
169: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
170: SELECT NVL(uc.achievable_credit_points,
171: NVL(uv.achievable_credit_points,
172: NVL(p_override_enrolled_cp,
173: NVL(uc.enrolled_credit_points,uv.enrolled_credit_points

Line 178: FROM igs_ps_unit_ver uv,

174: )
175: )
176: )
177: ) sua_cp
178: FROM igs_ps_unit_ver uv,
179: igs_ps_unit_ofr_opt uoo,
180: igs_ps_usec_cps uc
181: WHERE uoo.uoo_id = cp_uoo_id
182: AND uoo.uoo_id = uc.uoo_id(+)

Line 272: igs_ps_unit_ver_all uv

268: )
269: ) avail_cp
270: FROM igs_en_su_attempt_all sua,
271: igs_ps_unit_lvl_all ul ,
272: igs_ps_unit_ver_all uv
273: WHERE sua.person_id = cp_person_id
274: AND sua.course_cd = p_course_cd
275: AND NVL(sua.core_indicator_code, 'ELECTIVE') = cp_core_ind_code --Core indicator filter
276: AND sua.unit_cd = uv.unit_cd

Line 401: igs_ps_unit_ver_all uv

397: )
398: ) total_cp
399: FROM igs_en_su_attempt_all sua,
400: igs_ps_unit_lvl_all ul,
401: igs_ps_unit_ver_all uv
402: WHERE sua.person_id = cp_person_id
403: AND sua.course_cd = cp_course_cd
404: AND sua.unit_cd = uv.unit_cd
405: AND sua.version_number = uv.version_number

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 545: || ' igs_ps_unit_lvl_all ul, igs_ps_unit_ver_all uv , '

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 '
549: || ' AND suao.uoo_id = sua.uoo_id AND NVL(sua.core_indicator_code, ''ELECTIVE'') = :3 '

Line 566: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

562: || ' AND suao2.uoo_id= suao.uoo_id ) '
563: || ' AND igs_as_calc_award_mark.chk_if_excluded_unit (sua.uoo_id,sua.unit_cd,sua.version_number) = ''TRUE'' ';
564: l_stmt_priority_based_orig VARCHAR2 (4000) := l_stmt_priority_based;
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;

Line 609: igs_ps_unit_ver_all uv,

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
611: WHERE suao.person_id = cp_person_id
612: AND suao.course_cd = cp_course_cd
613: AND suao.person_id = sua.person_id

Line 1318: igs_ps_unit_ver_all uv, igs_ps_unit_lvl_all ul

1314: AND unit_level IS NOT NULL
1315: UNION
1316: SELECT NVL(ul.unit_level, uv.unit_level) AS unit_level, 1 AS weighted_average
1317: FROM igs_en_su_attempt_all sua ,
1318: igs_ps_unit_ver_all uv, igs_ps_unit_lvl_all ul
1319: WHERE
1320: sua.unit_cd = uv.unit_cd AND
1321: sua.version_number = uv.version_number AND
1322: sua.course_cd = ul.course_cd(+) AND