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_PS_UNIT_OFR_OPT

Line 62: igs_ps_unit_ofr_opt_all opt,

58: AND rct.s_reference_cd_type = 'SUMMEAS'
59: AND NOT EXISTS ( SELECT refcd.reference_code_type
60: FROM igs_ps_usec_ref_cd refcd,
61: igs_ps_usec_ref usecref,
62: igs_ps_unit_ofr_opt_all opt,
63: igs_ge_ref_cd_type rct
64: WHERE usecref.uoo_id = cp_uoo_id
65: AND usecref.unit_section_reference_id =
66: refcd.unit_section_reference_id

Line 73: igs_ps_unit_ofr_opt_all opt,

69: UNION
70: SELECT 'X'
71: FROM igs_ps_us_req_ref_cd refcd,
72: igs_ps_usec_ref usecref,
73: igs_ps_unit_ofr_opt_all opt,
74: igs_ge_ref_cd_type rct
75: WHERE usecref.uoo_id = cp_uoo_id
76: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id
77: AND refcd.reference_cd_type = rct.reference_cd_type

Line 89: igs_ps_unit_ofr_opt_all opt,

85: AND rct.s_reference_cd_type = 'SUMMEAS'
86: AND NOT EXISTS ( SELECT refcd.reference_cd_type
87: FROM igs_ps_us_req_ref_cd refcd,
88: igs_ps_usec_ref usecref,
89: igs_ps_unit_ofr_opt_all opt,
90: igs_ge_ref_cd_type rct
91: WHERE usecref.uoo_id = cp_uoo_id
92: AND usecref.unit_section_reference_id =
93: refcd.unit_section_reference_id

Line 138: FUNCTION get_unit_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)

134: RETURN l_mark;
135: END get_mark;
136:
137:
138: FUNCTION get_unit_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
139: RETURN NUMBER
140: IS
141: -- cursor to get the unit version number
142: CURSOR c_unit_ver (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 142: CURSOR c_unit_ver (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

138: FUNCTION get_unit_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
139: RETURN NUMBER
140: IS
141: -- cursor to get the unit version number
142: CURSOR c_unit_ver (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
143: SELECT version_number
144: FROM igs_ps_unit_ofr_opt
145: WHERE uoo_id = cp_uoo_id;
146: l_unit_ver igs_ps_unit_ofr_opt.version_number%TYPE := 1;

Line 144: FROM igs_ps_unit_ofr_opt

140: IS
141: -- cursor to get the unit version number
142: CURSOR c_unit_ver (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
143: SELECT version_number
144: FROM igs_ps_unit_ofr_opt
145: WHERE uoo_id = cp_uoo_id;
146: l_unit_ver igs_ps_unit_ofr_opt.version_number%TYPE := 1;
147:
148: BEGIN

Line 146: l_unit_ver igs_ps_unit_ofr_opt.version_number%TYPE := 1;

142: CURSOR c_unit_ver (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
143: SELECT version_number
144: FROM igs_ps_unit_ofr_opt
145: WHERE uoo_id = cp_uoo_id;
146: l_unit_ver igs_ps_unit_ofr_opt.version_number%TYPE := 1;
147:
148: BEGIN
149: OPEN c_unit_ver (p_uoo_id);
150: FETCH c_unit_ver INTO l_unit_ver;

Line 162: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%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,
164: p_override_enrolled_cp NUMBER DEFAULT NULL)
165: RETURN NUMBER IS
166: -- cursor to get the cp defined at sua

Line 167: CURSOR c_sua_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

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

Line 179: igs_ps_unit_ofr_opt uoo,

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(+)
183: AND uv.unit_cd = cp_unit_cd

Line 567: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

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;
571: l_wam_weight igs_ps_unit_lvl.wam_weighting%TYPE;