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_RE_GEN_001 dependencies on IGS_EN_ATD_TYPE

Line 219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;

215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
218: v_acai_version_number IGS_PS_VER.version_number%TYPE;
219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
222: v_crv_eftd NUMBER;
223: v_used_eftd_days NUMBER;

Line 220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
218: v_acai_version_number IGS_PS_VER.version_number%TYPE;
219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
222: v_crv_eftd NUMBER;
223: v_used_eftd_days NUMBER;
224: v_eftd_remaining NUMBER;

Line 221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

217: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
218: v_acai_version_number IGS_PS_VER.version_number%TYPE;
219: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
220: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
221: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
222: v_crv_eftd NUMBER;
223: v_used_eftd_days NUMBER;
224: v_eftd_remaining NUMBER;
225: v_remaining_days NUMBER;

Line 273: FROM IGS_EN_ATD_TYPE att

269: crv.version_number = acai.crv_version_number;
270:
271: CURSOR c_att IS
272: SELECT att.research_percentage
273: FROM IGS_EN_ATD_TYPE att
274: WHERE att.attendance_type = NVL(v_sca_attendance_type,v_acai_attendance_type);
275:
276: l_dummy_bool BOOLEAN;
277: l_message_name fnd_new_messages.message_name%TYPE;

Line 498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;

494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
502: v_crv_eftd NUMBER;

Line 500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

496: v_acai_course_cd IGS_PS_VER.course_cd%TYPE;
497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
502: v_crv_eftd NUMBER;
503: v_used_eftd_days NUMBER;
504: v_minimum_eftd NUMBER;

Line 501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

497: v_acai_version_number IGS_PS_VER.version_number%TYPE;
498: v_acai_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
499: v_crv_min_sbmsn_percentage IGS_PS_VER.min_sbmsn_percentage%TYPE;
500: v_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
501: v_att_attendance_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
502: v_crv_eftd NUMBER;
503: v_used_eftd_days NUMBER;
504: v_minimum_eftd NUMBER;
505: v_eftd_remaining NUMBER;

Line 563: FROM IGS_EN_ATD_TYPE att

559: v_sca_version_number,
560: v_acai_version_number);
561: CURSOR c_att IS
562: SELECT att.research_percentage
563: FROM IGS_EN_ATD_TYPE att
564: WHERE att.attendance_type = NVL(
565: v_sca_attendance_type,
566: v_acai_attendance_type);
567:

Line 1038: v_research_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;

1034: v_last_attendance_percentage IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;
1035: v_cah_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1036: v_cah_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1037: v_cah_attendance_percentage IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;
1038: v_research_percentage IGS_EN_ATD_TYPE.research_percentage%TYPE;
1039: v_count_intrmsn_in_time_ind IGS_PS_VER.count_intrmsn_in_time_ind%TYPE;
1040: v_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1041: v_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1042: v_cah_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 1079: FROM IGS_EN_ATD_TYPE att

1075:
1076: CURSOR c_att (
1077: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
1078: SELECT att.research_percentage
1079: FROM IGS_EN_ATD_TYPE att
1080: WHERE att.attendance_type = cp_attendance_type AND
1081: att.closed_ind = 'N';
1082: CURSOR c_crv (
1083: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

Line 1355: FROM IGS_EN_ATD_TYPE att

1351: v_cah_rec c_cah%ROWTYPE;
1352: CURSOR c_att (
1353: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
1354: SELECT att.research_percentage
1355: FROM IGS_EN_ATD_TYPE att
1356: WHERE att.attendance_type = cp_attendance_type;
1357: BEGIN
1358: -- If IGS_RE_CANDIDATURE details have not been passed then load the record
1359: IF p_ca_sequence_number IS NULL OR