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_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_CRSE_DETS

Line 2557: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,

2553: WHERE system_code = p_system
2554: AND ucas_cycle = p_cycle;
2555:
2556: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
2557: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
2558: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
2559: p_inst igs_uc_crse_dets.institute%TYPE,
2560: p_system igs_uc_crse_dets.system_code%TYPE) IS
2561: SELECT oss_program_code,

Line 2558: p_campus igs_uc_crse_dets.ucas_campus%TYPE,

2554: AND ucas_cycle = p_cycle;
2555:
2556: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
2557: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
2558: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
2559: p_inst igs_uc_crse_dets.institute%TYPE,
2560: p_system igs_uc_crse_dets.system_code%TYPE) IS
2561: SELECT oss_program_code,
2562: oss_program_version,

Line 2559: p_inst igs_uc_crse_dets.institute%TYPE,

2555:
2556: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
2557: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
2558: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
2559: p_inst igs_uc_crse_dets.institute%TYPE,
2560: p_system igs_uc_crse_dets.system_code%TYPE) IS
2561: SELECT oss_program_code,
2562: oss_program_version,
2563: oss_location,

Line 2560: p_system igs_uc_crse_dets.system_code%TYPE) IS

2556: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
2557: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
2558: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
2559: p_inst igs_uc_crse_dets.institute%TYPE,
2560: p_system igs_uc_crse_dets.system_code%TYPE) IS
2561: SELECT oss_program_code,
2562: oss_program_version,
2563: oss_location,
2564: oss_attendance_mode,

Line 2566: FROM igs_uc_crse_dets

2562: oss_program_version,
2563: oss_location,
2564: oss_attendance_mode,
2565: oss_attendance_type
2566: FROM igs_uc_crse_dets
2567: WHERE System_Code = p_system
2568: AND ucas_program_code = p_course
2569: AND ucas_campus = p_campus
2570: AND Institute = p_inst;

Line 3294: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,

3290: WHERE system_code = p_system
3291: AND ucas_cycle = p_cycle;
3292:
3293: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
3294: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
3295: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
3296: p_inst igs_uc_crse_dets.institute%TYPE,
3297: p_system igs_uc_crse_dets.system_code%TYPE) IS
3298: SELECT oss_program_code,

Line 3295: p_campus igs_uc_crse_dets.ucas_campus%TYPE,

3291: AND ucas_cycle = p_cycle;
3292:
3293: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
3294: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
3295: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
3296: p_inst igs_uc_crse_dets.institute%TYPE,
3297: p_system igs_uc_crse_dets.system_code%TYPE) IS
3298: SELECT oss_program_code,
3299: oss_program_version,

Line 3296: p_inst igs_uc_crse_dets.institute%TYPE,

3292:
3293: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
3294: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
3295: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
3296: p_inst igs_uc_crse_dets.institute%TYPE,
3297: p_system igs_uc_crse_dets.system_code%TYPE) IS
3298: SELECT oss_program_code,
3299: oss_program_version,
3300: oss_location,

Line 3297: p_system igs_uc_crse_dets.system_code%TYPE) IS

3293: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
3294: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
3295: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
3296: p_inst igs_uc_crse_dets.institute%TYPE,
3297: p_system igs_uc_crse_dets.system_code%TYPE) IS
3298: SELECT oss_program_code,
3299: oss_program_version,
3300: oss_location,
3301: oss_attendance_mode,

Line 3303: FROM igs_uc_crse_dets

3299: oss_program_version,
3300: oss_location,
3301: oss_attendance_mode,
3302: oss_attendance_type
3303: FROM igs_uc_crse_dets
3304: WHERE System_Code = p_system
3305: AND ucas_program_code = p_course
3306: AND ucas_campus = p_campus
3307: AND Institute = p_inst;

Line 5721: p_system igs_uc_crse_dets.system_code%TYPE) IS

5717: -- validate Course value
5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,
5719: p_campus igs_uc_istarz1_ints.campus%TYPE,
5720: p_inst igs_uc_istarz1_ints.inst%TYPE,
5721: p_system igs_uc_crse_dets.system_code%TYPE) IS
5722: SELECT 'X'
5723: FROM igs_uc_crse_dets
5724: WHERE ucas_program_code = p_course
5725: AND institute = p_inst

Line 5723: FROM igs_uc_crse_dets

5719: p_campus igs_uc_istarz1_ints.campus%TYPE,
5720: p_inst igs_uc_istarz1_ints.inst%TYPE,
5721: p_system igs_uc_crse_dets.system_code%TYPE) IS
5722: SELECT 'X'
5723: FROM igs_uc_crse_dets
5724: WHERE ucas_program_code = p_course
5725: AND institute = p_inst
5726: AND ucas_campus = p_campus
5727: AND system_code = p_system;

Line 5754: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,

5750: AND uacc.choice_no = 9;
5751:
5752:
5753: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
5754: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
5755: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
5756: p_inst igs_uc_crse_dets.institute%TYPE,
5757: p_system igs_uc_crse_dets.system_code%TYPE) IS
5758: SELECT oss_program_code,

Line 5755: p_campus igs_uc_crse_dets.ucas_campus%TYPE,

5751:
5752:
5753: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
5754: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
5755: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
5756: p_inst igs_uc_crse_dets.institute%TYPE,
5757: p_system igs_uc_crse_dets.system_code%TYPE) IS
5758: SELECT oss_program_code,
5759: oss_program_version,

Line 5756: p_inst igs_uc_crse_dets.institute%TYPE,

5752:
5753: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
5754: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
5755: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
5756: p_inst igs_uc_crse_dets.institute%TYPE,
5757: p_system igs_uc_crse_dets.system_code%TYPE) IS
5758: SELECT oss_program_code,
5759: oss_program_version,
5760: oss_location,

Line 5757: p_system igs_uc_crse_dets.system_code%TYPE) IS

5753: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
5754: CURSOR get_oss_prog_cur (p_course igs_uc_crse_dets.ucas_program_code%TYPE,
5755: p_campus igs_uc_crse_dets.ucas_campus%TYPE,
5756: p_inst igs_uc_crse_dets.institute%TYPE,
5757: p_system igs_uc_crse_dets.system_code%TYPE) IS
5758: SELECT oss_program_code,
5759: oss_program_version,
5760: oss_location,
5761: oss_attendance_mode,

Line 5763: FROM igs_uc_crse_dets

5759: oss_program_version,
5760: oss_location,
5761: oss_attendance_mode,
5762: oss_attendance_type
5763: FROM igs_uc_crse_dets
5764: WHERE System_Code = p_system
5765: AND ucas_program_code = p_course
5766: AND ucas_campus = p_campus
5767: AND Institute = p_inst;

Line 6309: p_system igs_uc_crse_dets.system_code%TYPE) IS

6305: -- validate Course value/get OSS Program details
6306: CURSOR validate_Course (p_course igs_uc_istarz2_ints.course%TYPE,
6307: p_campus igs_uc_istarz2_ints.campus%TYPE,
6308: p_inst igs_uc_istarz2_ints.inst%TYPE,
6309: p_system igs_uc_crse_dets.system_code%TYPE) IS
6310: SELECT oss_program_code,
6311: oss_program_version,
6312: oss_attendance_type,
6313: oss_attendance_mode,

Line 6315: FROM igs_uc_crse_dets

6311: oss_program_version,
6312: oss_attendance_type,
6313: oss_attendance_mode,
6314: oss_location
6315: FROM igs_uc_crse_dets
6316: WHERE ucas_program_code = p_course
6317: AND institute = p_inst
6318: AND ucas_campus = p_campus
6319: AND system_code = p_system;