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_EN_SU_ATTEMPT

Line 35: FUNCTION chk_if_excluded_unit (p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

31: -- called by the main public program units
32:
33: -- ===============Utilities Method Section Begins================
34:
35: FUNCTION chk_if_excluded_unit (p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
36: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
37: p_version_number igs_en_su_attempt_all.version_number%TYPE)
38: RETURN VARCHAR2
39: IS

Line 36: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,

32:
33: -- ===============Utilities Method Section Begins================
34:
35: FUNCTION chk_if_excluded_unit (p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
36: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
37: p_version_number igs_en_su_attempt_all.version_number%TYPE)
38: RETURN VARCHAR2
39: IS
40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

Line 37: p_version_number igs_en_su_attempt_all.version_number%TYPE)

33: -- ===============Utilities Method Section Begins================
34:
35: FUNCTION chk_if_excluded_unit (p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
36: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
37: p_version_number igs_en_su_attempt_all.version_number%TYPE)
38: RETURN VARCHAR2
39: IS
40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,

Line 40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

36: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
37: p_version_number igs_en_su_attempt_all.version_number%TYPE)
38: RETURN VARCHAR2
39: IS
40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)
43: IS
44: SELECT 'X'

Line 41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,

37: p_version_number igs_en_su_attempt_all.version_number%TYPE)
38: RETURN VARCHAR2
39: IS
40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)
43: IS
44: SELECT 'X'
45: FROM igs_ps_usec_ref_cd refcd,

Line 42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)

38: RETURN VARCHAR2
39: IS
40: CURSOR C1 (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)
43: IS
44: SELECT 'X'
45: FROM igs_ps_usec_ref_cd refcd,
46: igs_ps_usec_ref usecref,

Line 159: p_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE,

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,
163: p_override_achievable_cp NUMBER DEFAULT NULL,

Line 270: FROM igs_en_su_attempt_all sua,

266: sua.override_achievable_cp,
267: sua.override_enrolled_cp
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

Line 381: cp_person_id igs_en_su_attempt.person_id%TYPE,

377: -- not available from the set up table
378: CURSOR c_total_unt_lvl_cp_alt (
379: cp_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE,
380: cp_course_cd igs_pr_ul_mark_cnfg.course_cd%TYPE,
381: cp_person_id igs_en_su_attempt.person_id%TYPE,
382: cp_include VARCHAR2
383: )
384: IS
385: SELECT SUM (

Line 399: FROM igs_en_su_attempt_all sua,

395: sua.override_achievable_cp,
396: sua.override_enrolled_cp
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

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 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 607: igs_en_su_attempt_all sua,

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
611: WHERE suao.person_id = cp_person_id

Line 1317: FROM igs_en_su_attempt_all sua ,

1313: WHERE award_cd = cp_award_cd
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

Line 1340: CURSOR c_load_dtls (cp_person_id igs_en_su_attempt.person_id%TYPE,

1336:
1337: rec_stat_dtls c_stat_dtls%ROWTYPE;
1338:
1339: -- cursor to get the load cal tpe and sequence_number
1340: CURSOR c_load_dtls (cp_person_id igs_en_su_attempt.person_id%TYPE,
1341: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS
1342: SELECT load_cal_type,
1343: load_ci_sequence_number
1344: FROM igs_ca_teach_to_load_v

Line 1341: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS

1337: rec_stat_dtls c_stat_dtls%ROWTYPE;
1338:
1339: -- cursor to get the load cal tpe and sequence_number
1340: CURSOR c_load_dtls (cp_person_id igs_en_su_attempt.person_id%TYPE,
1341: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS
1342: SELECT load_cal_type,
1343: load_ci_sequence_number
1344: FROM igs_ca_teach_to_load_v
1345: WHERE (teach_cal_type,teach_ci_sequence_number)

Line 1348: FROM igs_en_su_attempt

1344: FROM igs_ca_teach_to_load_v
1345: WHERE (teach_cal_type,teach_ci_sequence_number)
1346: IN( SELECT cal_type, ci_sequence_number
1347: FROM (SELECT cal_type, ci_sequence_number
1348: FROM igs_en_su_attempt
1349: WHERE course_cd = cp_course_cd
1350: AND person_id = cp_person_id
1351: AND unit_attempt_status IN ('COMPLETED','DUPLICATE','ENROLLED')
1352: ORDER BY ci_start_dt DESC)