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_010 dependencies on IGS_PS_UNIT_OFR_OPT

Line 2425: IGS_PS_UNIT_OFR_OPT uoo

2421: acaiu.location_cd,
2422: acaiu.unit_class
2423: FROM IGS_AD_PS_APLINSTUNT acaiu,
2424: IGS_AD_UNIT_OU_STAT auos,
2425: IGS_PS_UNIT_OFR_OPT uoo
2426: WHERE acaiu.person_id = v_acaiv_rec.person_id AND
2427: acaiu.admission_appl_number = v_acaiv_rec.admission_appl_number AND
2428: acaiu.nominated_course_cd = v_acaiv_rec.nominated_course_cd AND
2429: acaiu.acai_sequence_number = v_acaiv_rec.sequence_number AND

Line 2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,

2450: --
2451: -- Cursor to get the Uoo_Id - ptandon, Prevent Dropping Core Units build
2452: --
2453: CURSOR c_uoo_id (
2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS

Line 2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,

2451: -- Cursor to get the Uoo_Id - ptandon, Prevent Dropping Core Units build
2452: --
2453: CURSOR c_uoo_id (
2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
2459: SELECT uoo_id

Line 2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,

2452: --
2453: CURSOR c_uoo_id (
2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
2459: SELECT uoo_id
2460: FROM IGS_PS_UNIT_OFR_OPT

Line 2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

2453: CURSOR c_uoo_id (
2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
2459: SELECT uoo_id
2460: FROM IGS_PS_UNIT_OFR_OPT
2461: WHERE unit_cd = cp_unit_cd

Line 2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS

2454: cp_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE,
2455: cp_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
2459: SELECT uoo_id
2460: FROM IGS_PS_UNIT_OFR_OPT
2461: WHERE unit_cd = cp_unit_cd
2462: AND cal_type = cp_cal_type

Line 2460: FROM IGS_PS_UNIT_OFR_OPT

2456: cp_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
2457: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2458: cp_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE) IS
2459: SELECT uoo_id
2460: FROM IGS_PS_UNIT_OFR_OPT
2461: WHERE unit_cd = cp_unit_cd
2462: AND cal_type = cp_cal_type
2463: AND ci_sequence_number = cp_ci_sequence_number
2464: AND location_cd = cp_location_cd

Line 2467: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2463: AND ci_sequence_number = cp_ci_sequence_number
2464: AND location_cd = cp_location_cd
2465: AND unit_class = cp_unit_class;
2466:
2467: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2468: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
2469: FROM IGS_EN_SU_ATTEMPT sua
2470: WHERE sua.person_id = p_person_id AND
2471: sua.course_cd = p_course_cd AND

Line 2474: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

2470: WHERE sua.person_id = p_person_id AND
2471: sua.course_cd = p_course_cd AND
2472: sua.uoo_id = p_uoo_id;
2473:
2474: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
2475: SELECT cal_type, ci_sequence_number
2476: FROM igs_ps_unit_ofr_opt
2477: WHERE uoo_id = p_uoo_id;
2478:

Line 2476: FROM igs_ps_unit_ofr_opt

2472: sua.uoo_id = p_uoo_id;
2473:
2474: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
2475: SELECT cal_type, ci_sequence_number
2476: FROM igs_ps_unit_ofr_opt
2477: WHERE uoo_id = p_uoo_id;
2478:
2479:
2480: v_sua_rec VARCHAR2(1);

Line 2487: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

2483: v_message_name VARCHAR2(2000);
2484: v_log_creation_dt DATE;
2485: v_ci_start_dt DATE;
2486: v_ci_end_dt DATE;
2487: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2488: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2489: l_uoo_ids VARCHAR2(2000);
2490: l_enr_uoo_ids VARCHAR2(2000);
2491: l_waitlist_flag VARCHAR2(1) := NULL;

Line 2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

2492: l_out_uoo_ids VARCHAR2(2000);
2493: l_waitlist_uoo_ids VARCHAR2(2000);
2494: l_failed_uoo_ids VARCHAR2(2000);
2495: l_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%type;
2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2500: l_unit_cds VARCHAR2(2000);

Line 2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;

2493: l_waitlist_uoo_ids VARCHAR2(2000);
2494: l_failed_uoo_ids VARCHAR2(2000);
2495: l_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%type;
2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2500: l_unit_cds VARCHAR2(2000);
2501:

Line 2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

2494: l_failed_uoo_ids VARCHAR2(2000);
2495: l_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%type;
2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2500: l_unit_cds VARCHAR2(2000);
2501:
2502: BEGIN

Line 2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

2495: l_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%type;
2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2500: l_unit_cds VARCHAR2(2000);
2501:
2502: BEGIN
2503: p_added_ind := 'N';

Line 2760: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2756: ci_sequence_number = cp_ci_sequence_number AND
2757: location_cd = cp_location_cd AND
2758: unit_class = cp_unit_class;
2759:
2760: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2761: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
2762: FROM IGS_EN_SU_ATTEMPT sua
2763: WHERE sua.person_id = p_person_id AND
2764: sua.course_cd = p_course_cd AND

Line 2767: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2763: WHERE sua.person_id = p_person_id AND
2764: sua.course_cd = p_course_cd AND
2765: sua.uoo_id = p_uoo_id;
2766:
2767: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2768: SELECT relation_type
2769: FROM IGS_PS_UNIT_OFR_OPT
2770: WHERE uoo_id = p_uoo_id;
2771:

Line 2769: FROM IGS_PS_UNIT_OFR_OPT

2765: sua.uoo_id = p_uoo_id;
2766:
2767: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2768: SELECT relation_type
2769: FROM IGS_PS_UNIT_OFR_OPT
2770: WHERE uoo_id = p_uoo_id;
2771:
2772: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
2773: SELECT cal_type, ci_sequence_number

Line 2772: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

2768: SELECT relation_type
2769: FROM IGS_PS_UNIT_OFR_OPT
2770: WHERE uoo_id = p_uoo_id;
2771:
2772: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
2773: SELECT cal_type, ci_sequence_number
2774: FROM igs_ps_unit_ofr_opt
2775: WHERE uoo_id = p_uoo_id;
2776:

Line 2774: FROM igs_ps_unit_ofr_opt

2770: WHERE uoo_id = p_uoo_id;
2771:
2772: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
2773: SELECT cal_type, ci_sequence_number
2774: FROM igs_ps_unit_ofr_opt
2775: WHERE uoo_id = p_uoo_id;
2776:
2777: v_am_rec c_am%ROWTYPE;
2778: v_sua_rec VARCHAR2(1);

Line 2786: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

2782: vp_warn_level VARCHAR2(10) := NULL;
2783: v_message_name VARCHAR2(2000);
2784: v_attendance_mode VARCHAR2(3);
2785: v_counter NUMBER := 0;
2786: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2787: v_session_id VARCHAR2(255);
2788: v_ci_start_dt DATE;
2789: v_ci_end_dt DATE;
2790: -- variable used to keep the values on the

Line 2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

2788: v_ci_start_dt DATE;
2789: v_ci_end_dt DATE;
2790: -- variable used to keep the values on the
2791: -- parameter specified units. p_unit_....
2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;

Line 2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

2789: v_ci_end_dt DATE;
2790: -- variable used to keep the values on the
2791: -- parameter specified units. p_unit_....
2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2797:

Line 2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;

2790: -- variable used to keep the values on the
2791: -- parameter specified units. p_unit_....
2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2797:
2798: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

Line 2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;

2791: -- parameter specified units. p_unit_....
2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2797:
2798: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
2799: l_uoo_ids VARCHAR2(2000);

Line 2798: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2797:
2798: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
2799: l_uoo_ids VARCHAR2(2000);
2800: l_enr_uoo_ids VARCHAR2(2000);
2801: l_out_uoo_ids VARCHAR2(2000);
2802: l_waitlist_uoo_ids VARCHAR2(2000);

Line 2804: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

2800: l_enr_uoo_ids VARCHAR2(2000);
2801: l_out_uoo_ids VARCHAR2(2000);
2802: l_waitlist_uoo_ids VARCHAR2(2000);
2803: l_failed_uoo_ids VARCHAR2(2000);
2804: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2805: TYPE t_params_table IS TABLE OF NUMBER(7) INDEX BY BINARY_INTEGER;
2806: t_sup_params t_params_table;
2807: t_sub_params t_params_table;
2808: t_ord_params t_params_table;

Line 2813: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

2809: v_sup_index BINARY_INTEGER := 1;
2810: v_sub_index BINARY_INTEGER := 1;
2811: v_ord_index BINARY_INTEGER := 1;
2812: l_waitlist_flag varchar2(1) := NULL;
2813: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2814: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2815: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2816: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2817: l_unit_cds VARCHAR2(2000);

Line 2814: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;

2810: v_sub_index BINARY_INTEGER := 1;
2811: v_ord_index BINARY_INTEGER := 1;
2812: l_waitlist_flag varchar2(1) := NULL;
2813: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2814: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2815: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2816: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2817: l_unit_cds VARCHAR2(2000);
2818:

Line 2815: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

2811: v_ord_index BINARY_INTEGER := 1;
2812: l_waitlist_flag varchar2(1) := NULL;
2813: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2814: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2815: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2816: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2817: l_unit_cds VARCHAR2(2000);
2818:
2819: BEGIN

Line 2816: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

2812: l_waitlist_flag varchar2(1) := NULL;
2813: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2814: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2815: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2816: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2817: l_unit_cds VARCHAR2(2000);
2818:
2819: BEGIN
2820: p_added_ind := 'N';

Line 4409: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

4405: location_cd = cp_location_cd AND
4406: unit_class = cp_unit_class;
4407:
4408: --cursor to select the unit section status , placements build.
4409: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
4410: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
4411: FROM IGS_EN_SU_ATTEMPT sua
4412: WHERE sua.person_id = p_person_id AND
4413: sua.course_cd = p_course_cd AND

Line 4417: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

4413: sua.course_cd = p_course_cd AND
4414: sua.uoo_id = p_uoo_id;
4415:
4416: --cursor to select check if unit section is sup, sub or none.
4417: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
4418: SELECT relation_type
4419: FROM IGS_PS_UNIT_OFR_OPT
4420: WHERE uoo_id = p_uoo_id;
4421:

Line 4419: FROM IGS_PS_UNIT_OFR_OPT

4415:
4416: --cursor to select check if unit section is sup, sub or none.
4417: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
4418: SELECT relation_type
4419: FROM IGS_PS_UNIT_OFR_OPT
4420: WHERE uoo_id = p_uoo_id;
4421:
4422: --fetch the teach cal of the unit section
4423: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

Line 4423: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

4419: FROM IGS_PS_UNIT_OFR_OPT
4420: WHERE uoo_id = p_uoo_id;
4421:
4422: --fetch the teach cal of the unit section
4423: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
4424: SELECT cal_type, ci_sequence_number
4425: FROM igs_ps_unit_ofr_opt
4426: WHERE uoo_id = p_uoo_id;
4427:

Line 4425: FROM igs_ps_unit_ofr_opt

4421:
4422: --fetch the teach cal of the unit section
4423: CURSOR c_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
4424: SELECT cal_type, ci_sequence_number
4425: FROM igs_ps_unit_ofr_opt
4426: WHERE uoo_id = p_uoo_id;
4427:
4428: v_am_rec c_am%ROWTYPE;
4429: v_sua_rec VARCHAR2(1);

Line 4437: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

4433: vp_warn_level VARCHAR2(10) := NULL;
4434: v_message_name VARCHAR2(2000);
4435: v_attendance_mode VARCHAR2(3);
4436: v_counter NUMBER := 0;
4437: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
4438: v_session_id VARCHAR2(255);
4439: v_ci_start_dt DATE;
4440: v_ci_end_dt DATE;
4441: -- variable used to keep the values on the

Line 4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

4439: v_ci_start_dt DATE;
4440: v_ci_end_dt DATE;
4441: -- variable used to keep the values on the
4442: -- parameter specified units. p_unit_....
4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;

Line 4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

4440: v_ci_end_dt DATE;
4441: -- variable used to keep the values on the
4442: -- parameter specified units. p_unit_....
4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
4448:

Line 4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;

4441: -- variable used to keep the values on the
4442: -- parameter specified units. p_unit_....
4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
4448:
4449: --following vars added as part of placements build.

Line 4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;

4442: -- parameter specified units. p_unit_....
4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
4448:
4449: --following vars added as part of placements build.
4450: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

Line 4450: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
4448:
4449: --following vars added as part of placements build.
4450: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
4451: l_uoo_ids VARCHAR2(2000);
4452: l_enr_uoo_ids VARCHAR2(2000);
4453: l_out_uoo_ids VARCHAR2(2000);
4454: l_waitlist_uoo_ids VARCHAR2(2000);

Line 4456: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

4452: l_enr_uoo_ids VARCHAR2(2000);
4453: l_out_uoo_ids VARCHAR2(2000);
4454: l_waitlist_uoo_ids VARCHAR2(2000);
4455: l_failed_uoo_ids VARCHAR2(2000);
4456: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
4457: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4458: l_unit_cds VARCHAR2(2000);
4459:
4460:

Line 4457: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;

4453: l_out_uoo_ids VARCHAR2(2000);
4454: l_waitlist_uoo_ids VARCHAR2(2000);
4455: l_failed_uoo_ids VARCHAR2(2000);
4456: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
4457: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4458: l_unit_cds VARCHAR2(2000);
4459:
4460:
4461: --pl/sql tables to hold the uooids based on whethere the unit section is superior , sobordinate or none.

Line 4472: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

4468: v_sub_index BINARY_INTEGER := 1;
4469: v_ord_index BINARY_INTEGER := 1;
4470:
4471: l_waitlist_flag varchar2(1);
4472: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4473: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
4474:
4475: BEGIN
4476: p_added_ind := 'N';

Line 4473: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;

4469: v_ord_index BINARY_INTEGER := 1;
4470:
4471: l_waitlist_flag varchar2(1);
4472: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4473: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
4474:
4475: BEGIN
4476: p_added_ind := 'N';
4477: vp_warn_level := NULL;

Line 6026: CURSOR c_get_term_cal(cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,

6022: WHERE cal_type = cp_term_cal_type
6023: AND sequence_number = cp_term_ci_seq_num;
6024:
6025: -- Cursor to get the Term Calendar of the Unit.
6026: CURSOR c_get_term_cal(cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
6027: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6029: IS
6030: SELECT 'X'

Line 6031: FROM igs_ps_unit_ofr_opt uoo,

6027: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
6028: cp_load_ci_seq_num igs_ca_inst.sequence_number%TYPE)
6029: IS
6030: SELECT 'X'
6031: FROM igs_ps_unit_ofr_opt uoo,
6032: igs_ca_teach_to_load_v tl
6033: WHERE tl.teach_cal_type = uoo.cal_type
6034: AND tl.teach_ci_sequence_number = uoo.ci_sequence_number
6035: AND tl.load_cal_type = cp_load_cal_type

Line 8634: SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT

8630: -- primary program
8631: --rvivekan 07-dec-2003 Placements build. Added exception handling block for insert_into_enr_worksheet
8632: ------------------------------------------------------------------------------------------------
8633: CURSOR cur_uoo_id IS
8634: SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT
8635: WHERE unit_cd = p_unit_cd
8636: AND version_number = p_version_number
8637: AND cal_type = p_teach_cal_type
8638: AND ci_sequence_number = p_teach_seq_num

Line 9013: FROM IGS_PS_UNIT_OFR_OPT usec,

9009: usec.CAL_TYPE,
9010: usec.CI_SEQUENCE_NUMBER,
9011: CI.START_DT,
9012: CI.END_DT
9013: FROM IGS_PS_UNIT_OFR_OPT usec,
9014: IGS_CA_INST ci
9015: WHERE usec.UOO_ID = cp_uoo_id
9016: and ci.cal_type = usec.cal_type
9017: and ci.sequence_number = usec.ci_sequence_number;

Line 9297: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;

9293: || smaddali 21-dec-04 Modified for bug#4083358 , to change logic for dropping selected unit attempts across terms
9294: */
9295:
9296:
9297: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
9298: l_message_name VARCHAR2(30);
9299: v_unit_from_past_term BOOLEAN;
9300: v_dummy VARCHAR2(1);
9301: l_cindex NUMBER;

Line 9327: FROM IGS_PS_UNIT_OFR_OPT uoo

9323: CURSOR c_sub_sua_exists( cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9324: cp_source_program_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9325: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9326: SELECT 'X'
9327: FROM IGS_PS_UNIT_OFR_OPT uoo
9328: WHERE uoo.relation_type = 'SUBORDINATE'
9329: AND uoo.sup_uoo_id = cp_uoo_id
9330: AND exists (SELECT 'X'
9331: FROM IGS_EN_SU_ATTEMPT sub_sua

Line 9739: from IGS_PS_UNIT_OFR_OPT where uoo_id=p_uoo_id;

9735: p_course_cd IN VARCHAR2,
9736: p_uoo_id IN NUMBER)
9737: RETURN BOOLEAN IS
9738: CURSOR cur_supuoo_id IS select sup_uoo_id
9739: from IGS_PS_UNIT_OFR_OPT where uoo_id=p_uoo_id;
9740:
9741: CURSOR cur_sua (
9742: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9743: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

Line 9761: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;

9757: WHERE person_id = cp_person_id
9758: AND course_cd = cp_course_cd
9759: AND uoo_id = cp_uoo_id;
9760:
9761: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;
9762: l_sup_unit_Cd IGS_EN_SU_ATTEMPT.SUP_UNIT_CD%TYPE;
9763: l_cur_sua_rec cur_sua%ROWTYPE;
9764: l_result BOOLEAN;
9765: l_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE;

Line 10158: FROM igs_ps_unit_ofr_opt

10154: WHERE person_id = p_person_id AND
10155: course_cd = p_course_cd;
10156: CURSOR c_sua IS
10157: SELECT uoo_id
10158: FROM igs_ps_unit_ofr_opt
10159: WHERE unit_cd = p_unit_cd
10160: AND version_number = p_uv_version_number
10161: AND cal_type = p_cal_type
10162: AND ci_sequence_number = p_ci_sequence_number