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_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_UNIT_VER

Line 4184: igs_ps_unit_ver e,

4180: FROM igs_en_su_attempt a,
4181: igs_ps_tch_resp b,
4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt
4187: WHERE a.course_cd = p_course_cd
4188: AND a.person_id = p_person_id

Line 4206: igs_ps_unit_ver e,

4202:
4203: CURSOR c_total_cp IS
4204: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points))) Total_credit_points
4205: FROM igs_en_su_attempt a,
4206: igs_ps_unit_ver e,
4207: igs_ps_usec_cps cps,
4208: igs_he_st_unt_vs_all hunt
4209: WHERE a.course_cd = p_course_cd
4210: AND a.person_id = p_person_id

Line 4399: igs_ps_unit_ver b,

4395: --smaddali modified this cursor to consider unit level credit points also for bug 2415811
4396: CURSOR c_cp IS
4397: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,b.enrolled_credit_points)) ) credit_points, b.unit_level
4398: FROM igs_en_su_attempt a ,
4399: igs_ps_unit_ver b,
4400: igs_ps_usec_cps cps,
4401: igs_he_st_unt_vs_all hunt
4402: WHERE a.course_cd = p_course_cd
4403: AND a.person_id = p_person_id

Line 4416: l_lvl1 igs_ps_unit_ver.unit_level%TYPE;

4412: GROUP BY b.unit_level
4413: ORDER BY credit_points DESC;
4414:
4415: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4416: l_lvl1 igs_ps_unit_ver.unit_level%TYPE;
4417: l_lvl2 igs_ps_unit_ver.unit_level%TYPE;
4418: l_lvl3 igs_ps_unit_ver.unit_level%TYPE;
4419: l_lvl4 igs_ps_unit_ver.unit_level%TYPE;
4420:

Line 4417: l_lvl2 igs_ps_unit_ver.unit_level%TYPE;

4413: ORDER BY credit_points DESC;
4414:
4415: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4416: l_lvl1 igs_ps_unit_ver.unit_level%TYPE;
4417: l_lvl2 igs_ps_unit_ver.unit_level%TYPE;
4418: l_lvl3 igs_ps_unit_ver.unit_level%TYPE;
4419: l_lvl4 igs_ps_unit_ver.unit_level%TYPE;
4420:
4421: BEGIN

Line 4418: l_lvl3 igs_ps_unit_ver.unit_level%TYPE;

4414:
4415: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4416: l_lvl1 igs_ps_unit_ver.unit_level%TYPE;
4417: l_lvl2 igs_ps_unit_ver.unit_level%TYPE;
4418: l_lvl3 igs_ps_unit_ver.unit_level%TYPE;
4419: l_lvl4 igs_ps_unit_ver.unit_level%TYPE;
4420:
4421: BEGIN
4422: IF p_prog_calc = 'N'

Line 4419: l_lvl4 igs_ps_unit_ver.unit_level%TYPE;

4415: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4416: l_lvl1 igs_ps_unit_ver.unit_level%TYPE;
4417: l_lvl2 igs_ps_unit_ver.unit_level%TYPE;
4418: l_lvl3 igs_ps_unit_ver.unit_level%TYPE;
4419: l_lvl4 igs_ps_unit_ver.unit_level%TYPE;
4420:
4421: BEGIN
4422: IF p_prog_calc = 'N'
4423: THEN

Line 6133: igs_ps_unit_ver_all b,

6129: a.version_number,
6130: d.prop_of_teaching_in_welsh,
6131: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6132: FROM igs_en_su_attempt_all a,
6133: igs_ps_unit_ver_all b,
6134: igs_he_st_spa_all c,
6135: igs_he_st_unt_vs_all d,
6136: igs_ps_usec_cps cps
6137: WHERE a.unit_cd = b.unit_cd

Line 6155: igs_ps_unit_ver_all b,

6151: a.version_number,
6152: d.prop_of_teaching_in_welsh,
6153: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6154: FROM igs_en_su_attempt_all a,
6155: igs_ps_unit_ver_all b,
6156: igs_he_st_spa_all c,
6157: igs_he_st_unt_vs_all d,
6158: igs_as_su_stmptout e,
6159: igs_ps_usec_cps cps

Line 6520: (p_enrolled_credit_points IN igs_ps_unit_ver_v.enrolled_credit_points%TYPE,

6516: END isDormant;
6517:
6518:
6519: PROCEDURE get_mod_prop_fte
6520: (p_enrolled_credit_points IN igs_ps_unit_ver_v.enrolled_credit_points%TYPE,
6521: p_unit_level IN igs_ps_unit_ver_v.unit_level%TYPE,
6522: p_prop_of_fte OUT NOCOPY VARCHAR2)
6523:
6524: IS

Line 6521: p_unit_level IN igs_ps_unit_ver_v.unit_level%TYPE,

6517:
6518:
6519: PROCEDURE get_mod_prop_fte
6520: (p_enrolled_credit_points IN igs_ps_unit_ver_v.enrolled_credit_points%TYPE,
6521: p_unit_level IN igs_ps_unit_ver_v.unit_level%TYPE,
6522: p_prop_of_fte OUT NOCOPY VARCHAR2)
6523:
6524: IS
6525: /***************************************************************