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_002 dependencies on IGS_EN_STDNT_PS_ATT

Line 213: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

209: WHERE ca.person_id = p_person_id AND
210: ca.sequence_number = p_ca_sequence_number;
211: v_ca_rec c_ca%ROWTYPE;
212: CURSOR c_sca(
213: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
214: IS
215: SELECT sca.course_attempt_status,
216: sca.version_number,
217: sca.commencement_dt

Line 218: FROM IGS_EN_STDNT_PS_ATT sca

214: IS
215: SELECT sca.course_attempt_status,
216: sca.version_number,
217: sca.commencement_dt
218: FROM IGS_EN_STDNT_PS_ATT sca
219: WHERE sca.person_id = p_person_id AND
220: sca.course_cd = cp_course_cd;
221: v_sca_rec c_sca%ROWTYPE;
222: v_sca_rec1 c_sca%ROWTYPE;

Line 378: -- IGS_EN_STDNT_PS_ATT.commencement_dt

374: v_sca_rec.version_number,
375: v_research_type_ind);
376: IF v_research_type_ind = 'Y' THEN
377: -- Set start date to
378: -- IGS_EN_STDNT_PS_ATT.commencement_dt
379: RETURN v_sca_rec.commencement_dt;
380: ELSE
381: -- Set start date to earliest research IGS_PS_UNIT
382: -- enrolment.

Line 525: FROM IGS_EN_STDNT_PS_ATT sca,

521: CURSOR c_sca IS
522: SELECT sca.adm_admission_appl_number,
523: sca.adm_nominated_course_cd,
524: sca.adm_sequence_number
525: FROM IGS_EN_STDNT_PS_ATT sca,
526: IGS_RE_CANDIDATURE ca
527: WHERE sca.person_id = p_person_id AND
528: sca.course_cd = p_course_cd AND
529: ca.person_id = sca.person_id AND

Line 588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
590: v_record_found BOOLEAN DEFAULT FALSE;
591: v_cah2_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
592: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
590: v_record_found BOOLEAN DEFAULT FALSE;
591: v_cah2_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
592: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
593: v_tp_days NUMBER;

Line 626: FROM IGS_EN_STDNT_PS_ATT sca,

622: ca.sca_course_cd = p_course_cd;
623: CURSOR c_sca IS
624: SELECT sca.attendance_type,
625: sca.commencement_dt
626: FROM IGS_EN_STDNT_PS_ATT sca,
627: IGS_PS_VER crv
628: WHERE sca.person_id = p_person_id AND
629: sca.course_cd = p_course_cd;
630: CURSOR c_cah1 (

Line 1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

1133: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:
1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.
1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:
1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.
1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;

Line 1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;

Line 1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;
1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;

Line 1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;
1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;
1405: v_mil_sequence_number IGS_PR_MILESTONE.sequence_number%TYPE;

Line 1430: FROM IGS_EN_STDNT_PS_ATT sca

1426: CURSOR c_sca (
1427: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS
1428: SELECT sca.version_number,
1429: sca.attendance_type
1430: FROM IGS_EN_STDNT_PS_ATT sca
1431: WHERE sca.person_id = p_person_id AND
1432: sca.course_cd = cp_sca_course_cd;
1433: CURSOR c_acai (
1434: cp_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,