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_SESSION_VALIDITY dependencies on IGS_EN_PLAN_UNITS

Line 194: CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,

190:
191: /**
192: Cursor to select rowid of error carts for deleting.
193: */
194: CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,
195: p_person_id igs_en_plan_units.person_id%TYPE,
196: p_course_cd igs_en_plan_units.course_cd%TYPE,
197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
198: SELECT ROWID

Line 195: p_person_id igs_en_plan_units.person_id%TYPE,

191: /**
192: Cursor to select rowid of error carts for deleting.
193: */
194: CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,
195: p_person_id igs_en_plan_units.person_id%TYPE,
196: p_course_cd igs_en_plan_units.course_cd%TYPE,
197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
198: SELECT ROWID
199: FROM igs_en_plan_units

Line 196: p_course_cd igs_en_plan_units.course_cd%TYPE,

192: Cursor to select rowid of error carts for deleting.
193: */
194: CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,
195: p_person_id igs_en_plan_units.person_id%TYPE,
196: p_course_cd igs_en_plan_units.course_cd%TYPE,
197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
198: SELECT ROWID
199: FROM igs_en_plan_units
200: WHERE person_id = p_person_id

Line 197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS

193: */
194: CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,
195: p_person_id igs_en_plan_units.person_id%TYPE,
196: p_course_cd igs_en_plan_units.course_cd%TYPE,
197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
198: SELECT ROWID
199: FROM igs_en_plan_units
200: WHERE person_id = p_person_id
201: AND course_cd = p_course_cd

Line 199: FROM igs_en_plan_units

195: p_person_id igs_en_plan_units.person_id%TYPE,
196: p_course_cd igs_en_plan_units.course_cd%TYPE,
197: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
198: SELECT ROWID
199: FROM igs_en_plan_units
200: WHERE person_id = p_person_id
201: AND course_cd = p_course_cd
202: AND uoo_id = p_uoo_id
203: AND cart_error_flag = 'Y'

Line 209: CURSOR c_cal_type( p_person_id igs_en_plan_units.person_id%TYPE,

205:
206: /**
207: Cursor to select value of term_cal_type and term_ci_sequence_number.
208: */
209: CURSOR c_cal_type( p_person_id igs_en_plan_units.person_id%TYPE,
210: p_course_cd igs_en_plan_units.course_cd%TYPE,
211: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
212: SELECT term_cal_type, term_ci_sequence_number
213: FROM igs_en_plan_units

Line 210: p_course_cd igs_en_plan_units.course_cd%TYPE,

206: /**
207: Cursor to select value of term_cal_type and term_ci_sequence_number.
208: */
209: CURSOR c_cal_type( p_person_id igs_en_plan_units.person_id%TYPE,
210: p_course_cd igs_en_plan_units.course_cd%TYPE,
211: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
212: SELECT term_cal_type, term_ci_sequence_number
213: FROM igs_en_plan_units
214: WHERE person_id = p_person_id

Line 211: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS

207: Cursor to select value of term_cal_type and term_ci_sequence_number.
208: */
209: CURSOR c_cal_type( p_person_id igs_en_plan_units.person_id%TYPE,
210: p_course_cd igs_en_plan_units.course_cd%TYPE,
211: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
212: SELECT term_cal_type, term_ci_sequence_number
213: FROM igs_en_plan_units
214: WHERE person_id = p_person_id
215: AND course_cd = p_course_cd

Line 213: FROM igs_en_plan_units

209: CURSOR c_cal_type( p_person_id igs_en_plan_units.person_id%TYPE,
210: p_course_cd igs_en_plan_units.course_cd%TYPE,
211: p_uoo_id igs_en_plan_units.uoo_id%TYPE ) IS
212: SELECT term_cal_type, term_ci_sequence_number
213: FROM igs_en_plan_units
214: WHERE person_id = p_person_id
215: AND course_cd = p_course_cd
216: AND uoo_id = p_uoo_id;
217:

Line 230: FROM igs_en_plan_units

226: -- added by ckasu as a part of bug#4673919
227:
228: CURSOR all_plan_session IS
229: SELECT DISTINCT session_id
230: FROM igs_en_plan_units
231: WHERE cart_error_flag= 'Y';
232:
233: CURSOR c_get_all_plan_error_units(p_session_id IGS_EN_PLAN_UNITS.SESSION_ID%TYPE) IS
234: SELECT ROWID

Line 233: CURSOR c_get_all_plan_error_units(p_session_id IGS_EN_PLAN_UNITS.SESSION_ID%TYPE) IS

229: SELECT DISTINCT session_id
230: FROM igs_en_plan_units
231: WHERE cart_error_flag= 'Y';
232:
233: CURSOR c_get_all_plan_error_units(p_session_id IGS_EN_PLAN_UNITS.SESSION_ID%TYPE) IS
234: SELECT ROWID
235: FROM igs_en_plan_units
236: WHERE session_id = p_session_id
237: AND cart_error_flag = 'Y';

Line 235: FROM igs_en_plan_units

231: WHERE cart_error_flag= 'Y';
232:
233: CURSOR c_get_all_plan_error_units(p_session_id IGS_EN_PLAN_UNITS.SESSION_ID%TYPE) IS
234: SELECT ROWID
235: FROM igs_en_plan_units
236: WHERE session_id = p_session_id
237: AND cart_error_flag = 'Y';
238:
239: l_purge_admin_cart BOOLEAN;

Line 294: AND EXISTS ( SELECT pl.uoo_id FROM igs_en_plan_units pl WHERE pl.person_id=spa.person_id AND pl.course_cd = spa.program_cd AND

290: AND spa.person_id = c_stud_cart_rec.person_id
291: AND spa.program_cd = c_stud_cart_rec.course_cd
292: AND spa.term_cal_type = c_cal_type_rec.term_cal_type
293: AND spa.term_sequence_number = c_cal_type_rec.term_ci_sequence_number
294: AND EXISTS ( SELECT pl.uoo_id FROM igs_en_plan_units pl WHERE pl.person_id=spa.person_id AND pl.course_cd = spa.program_cd AND
295: pl.term_cal_type = spa.term_cal_type AND pl.term_ci_sequence_number = spa.term_sequence_number AND pl.uoo_id =c_stud_cart_rec.uoo_id);
296:
297: -- After updating exit the loop.
298: EXIT;

Line 307: igs_en_plan_units_pkg.delete_row(c_plan_error_rec.rowid) ;

303: c_stud_cart_rec.person_id,
304: c_stud_cart_rec.course_cd,
305: c_stud_cart_rec.uoo_id)
306: LOOP
307: igs_en_plan_units_pkg.delete_row(c_plan_error_rec.rowid) ;
308: END LOOP;
309:
310: END IF;
311: EXCEPTION

Line 343: igs_en_plan_units_pkg.delete_row(c_get_all_plan_error_units_rec.rowid);

339:
340: BEGIN
341:
342: SAVEPOINT SP_PLAN_ERROR_REC;
343: igs_en_plan_units_pkg.delete_row(c_get_all_plan_error_units_rec.rowid);
344:
345:
346: EXCEPTION
347: WHEN OTHERS THEN