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_GEN_011 dependencies on IGS_PS_OFR_OPT

Line 352: FROM IGS_PS_OFR_OPT coo

348: -- Local procedure to process the transfer of course offering option.
349: DECLARE
350: CURSOR c_coo IS
351: SELECT coo.coo_id
352: FROM IGS_PS_OFR_OPT coo
353: WHERE coo.course_cd = p_course_cd AND
354: coo.version_number = p_to_crs_version_number AND
355: coo.cal_type = p_to_acad_cal_type AND
356: coo.location_cd = p_to_location_cd AND

Line 380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,

376: susa.student_confirmed_ind = 'Y' AND
377: susa.end_dt IS NULL;
378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,

Line 381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,

377: susa.end_dt IS NULL;
378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,
385: IGS_PS_OFR_OPT coo

Line 382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS

378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,
385: IGS_PS_OFR_OPT coo
386: WHERE

Line 385: IGS_PS_OFR_OPT coo

381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,
385: IGS_PS_OFR_OPT coo
386: WHERE
387: cous.unit_set_cd = cp_unit_set_cd and
388: cous.us_version_number = cp_us_version_number and
389: coo.coo_id = cp_coo_id and

Line 579: -- Check if the IGS_PS_UNIT set allowed in the IGS_PS_OFR_OPT.

575: IF p_course_attempt_status <> 'UNCONFIRM' THEN
576: -- Check if any IGS_PS_UNIT sets are not permitted within the new course
577: -- offering option. If so, report error.
578: FOR v_susa_rec IN c_susa LOOP
579: -- Check if the IGS_PS_UNIT set allowed in the IGS_PS_OFR_OPT.
580: OPEN c_coousv(
581: v_susa_rec.unit_set_cd,
582: v_susa_rec.us_version_number,
583: v_coo_rec.coo_id);