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

Line 159: FROM IGS_EN_SU_ATTEMPT sua,

155: CURSOR c_sua_um (
156: cp_ci_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
158: SELECT um.s_unit_mode
159: FROM IGS_EN_SU_ATTEMPT sua,
160: IGS_AS_UNIT_CLASS ucl,
161: IGS_AS_UNIT_MODE um
162: WHERE sua.person_id = p_person_id AND
163: sua.course_cd = p_course_cd AND

Line 445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

441: SELECT commence_cutoff_dt_alias
442: FROM IGS_EN_CAL_CONF
443: WHERE s_control_num = 1;
444: CURSOR c_sua_ci(
445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt

Line 446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

442: FROM IGS_EN_CAL_CONF
443: WHERE s_control_num = 1;
444: CURSOR c_sua_ci(
445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,

Line 447: SELECT IGS_EN_SU_ATTEMPT.cal_type,

443: WHERE s_control_num = 1;
444: CURSOR c_sua_ci(
445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST

Line 448: IGS_EN_SU_ATTEMPT.ci_sequence_number,

444: CURSOR c_sua_ci(
445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND

Line 450: FROM IGS_EN_SU_ATTEMPT,

446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND

Line 452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND

448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;

Line 453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND

449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:

Line 454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND

450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

Line 455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number

451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

Line 1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1106: RETURN VARCHAR2 AS
1107: gv_other_detail VARCHAR2(255);
1108: BEGIN
1109: DECLARE
1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

Line 1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1107: gv_other_detail VARCHAR2(255);
1108: BEGIN
1109: DECLARE
1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;

Line 1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1109: DECLARE
1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);

Line 1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);
1118: CURSOR c_sua_ci (

Line 1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;

1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);
1118: CURSOR c_sua_ci (
1119: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;

1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);
1118: CURSOR c_sua_ci (
1119: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1120: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)IS

Line 1119: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);
1118: CURSOR c_sua_ci (
1119: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1120: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)IS
1121: SELECT sua.cal_type,
1122: sua.ci_sequence_number,
1123: ci.alternate_code

Line 1120: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)IS

1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
1117: v_message_name VARCHAR2(30);
1118: CURSOR c_sua_ci (
1119: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1120: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)IS
1121: SELECT sua.cal_type,
1122: sua.ci_sequence_number,
1123: ci.alternate_code
1124: FROM IGS_EN_SU_ATTEMPT sua,

Line 1124: FROM IGS_EN_SU_ATTEMPT sua,

1120: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)IS
1121: SELECT sua.cal_type,
1122: sua.ci_sequence_number,
1123: ci.alternate_code
1124: FROM IGS_EN_SU_ATTEMPT sua,
1125: IGS_CA_INST ci
1126: WHERE sua.person_id = cp_person_id AND
1127: sua.course_cd = cp_course_cd AND
1128: sua.cal_type = ci.cal_type AND

Line 1234: FROM IGS_EN_SU_ATTEMPT sua

1230: SELECT 'x'
1231: FROM sys.dual
1232: WHERE EXISTS (
1233: SELECT 'x'
1234: FROM IGS_EN_SU_ATTEMPT sua
1235: WHERE sua.person_id = p_person_id AND
1236: sua.course_cd = p_course_cd AND
1237: sua.unit_attempt_status = cst_enrolled AND
1238: sua.ci_start_dt <= SYSDATE);