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_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 100: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT

96: being fetched from cursor, now modified to get it by
97: calling the function igs_ss_enr_details.get_notification.
98: Nishikant 18-OCT-2002 The call to the function Igs_En_Elgbl_Program.eval_min_cp got modified since the signatue
99: got modified. Enrl Elgbl and Validation Build. Bug#2616692.
100: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
101: for Bug 2554109 MINI Waitlist Build for Jan 03 Release
102: ayedubat 11-APR-2002 Changed the cursor,cur_note_flag to add an extra 'OR'
103: condition(eru.s_student_comm_type = 'ALL') for s_student_comm_type as part of the bug fix: 2315245
104: Nishikant 10-Oct-2001 Added the column session_id in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG

Line 104: Nishikant 10-Oct-2001 Added the column session_id in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG

100: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
101: for Bug 2554109 MINI Waitlist Build for Jan 03 Release
102: ayedubat 11-APR-2002 Changed the cursor,cur_note_flag to add an extra 'OR'
103: condition(eru.s_student_comm_type = 'ALL') for s_student_comm_type as part of the bug fix: 2315245
104: Nishikant 10-Oct-2001 Added the column session_id in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG
105: as a part of the bug 2172380.
106: myoganat 16-JUN-2003 Bug# 2855870 Modified ENRP_VAL_APPR_CR_PT procedure by removing the IF clause
107: before the call to EVAL_MIN_CP and EVAL_MAX_CP. Profile IGS_EN_INCL_AUDIT_CP
108: was made obsolete. In the call to igs_en_val_sua.enrp_val_sua_ovrd_cp, the value of

Line 188: CURSOR c_dummy_cur (cp_person_id igs_en_su_attempt_all.person_id%TYPE

184: l_plan_def_query VARCHAR2(4000);
185:
186: cur_sua_def_var cur_sua_def; -- REF cursor variable
187:
188: CURSOR c_dummy_cur (cp_person_id igs_en_su_attempt_all.person_id%TYPE
189: , cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
190: , cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
191: SELECT sua.rowid row_id, sua.*
192: FROM igs_en_su_attempt_all sua

Line 189: , cp_course_cd igs_en_su_attempt_all.course_cd%TYPE

185:
186: cur_sua_def_var cur_sua_def; -- REF cursor variable
187:
188: CURSOR c_dummy_cur (cp_person_id igs_en_su_attempt_all.person_id%TYPE
189: , cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
190: , cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
191: SELECT sua.rowid row_id, sua.*
192: FROM igs_en_su_attempt_all sua
193: WHERE person_id = cp_person_id

Line 190: , cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS

186: cur_sua_def_var cur_sua_def; -- REF cursor variable
187:
188: CURSOR c_dummy_cur (cp_person_id igs_en_su_attempt_all.person_id%TYPE
189: , cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
190: , cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
191: SELECT sua.rowid row_id, sua.*
192: FROM igs_en_su_attempt_all sua
193: WHERE person_id = cp_person_id
194: and course_cd = cp_course_cd

Line 192: FROM igs_en_su_attempt_all sua

188: CURSOR c_dummy_cur (cp_person_id igs_en_su_attempt_all.person_id%TYPE
189: , cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
190: , cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
191: SELECT sua.rowid row_id, sua.*
192: FROM igs_en_su_attempt_all sua
193: WHERE person_id = cp_person_id
194: and course_cd = cp_course_cd
195: and uoo_id = cp_uoo_id;
196: cur_sua_def_var_rec c_dummy_cur%ROWTYPE;

Line 199: l_unit_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

195: and uoo_id = cp_uoo_id;
196: cur_sua_def_var_rec c_dummy_cur%ROWTYPE;
197: l_upd_credit_cp NUMBER := NULL;
198: l_min_upd_credit_cp NUMBER := NULL;
199: l_unit_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
200: l_message VARCHAR2(2000);
201: l_sua_def_query VARCHAR2(4000);
202: l_return_val BOOLEAN := FALSE;
203: l_ret_status VARCHAR2(10);

Line 252: FROM igs_en_su_attempt_all sua

248: -- Override record defined at Unit Section level
249: IF new_references.uoo_id <>-1 THEN
250: -- fetch all Unit Atempts where sua.uoo_id = new_references.uoo_id
251: l_sua_def_query := 'SELECT sua.rowid row_id, sua.*
252: FROM igs_en_su_attempt_all sua
253: WHERE unit_attempt_status IN (''ENROLLED'',''WAITLISTED'') AND uoo_id = :1 AND person_id = :2 AND no_assessment_ind<>''Y''';
254:
255: OPEN cur_sua_def_var FOR l_sua_def_query USING new_references.uoo_id, l_cur_step_cal_rec.person_id;
256:

Line 261: FROM igs_en_su_attempt_all sua

257: -- Override record defined at Unit level
258: ELSIF new_references.unit_cd IS NOT NULL THEN
259: -- fetch all Unit Atempts where sua.unit_cd = new_references.unit_cd
260: l_sua_def_query := 'SELECT sua.rowid row_id, sua.*
261: FROM igs_en_su_attempt_all sua
262: WHERE sua.unit_attempt_status IN (''ENROLLED'',''WAITLISTED'') AND sua.unit_cd = :1 AND sua.version_number = :2 AND person_id = :3 AND
263: ((sua.cal_type = :4 AND
264: sua.ci_sequence_number = :5 ) OR
265: ((sua.cal_type,sua.ci_sequence_number) IN

Line 281: FROM igs_en_su_attempt_all sua

277:
278: -- fetch all Unit Atempts where sua teach cal type is equal to or sub ordinate to the Cal Type
279: -- where Override record is defined.
280: l_sua_def_query := 'SELECT sua.rowid row_id, sua.*
281: FROM igs_en_su_attempt_all sua
282: WHERE sua.unit_attempt_status IN (''ENROLLED'',''WAITLISTED'') AND sua.person_id = :1 AND
283: ((sua.cal_type = :2 AND
284: sua.ci_sequence_number = :3 ) OR
285: ((sua.cal_type,sua.ci_sequence_number) IN