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_STDNT_PS_ATT

Line 211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
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;

Line 215: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
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;

Line 216: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
214: v_sca_course_attempt_status
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;

Line 243: FROM IGS_EN_STDNT_PS_ATT sca

239: sca.version_number,
240: sca.attendance_type,
241: sca.commencement_dt,
242: sca.course_attempt_status
243: FROM IGS_EN_STDNT_PS_ATT sca
244: WHERE sca.person_id = p_person_id AND
245: sca.course_cd = v_ca_sca_course_cd;
246:
247: CURSOR c_acaiv IS

Line 490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
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;

Line 494: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
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;

Line 495: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
493: v_sca_course_attempt_status
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;

Line 523: FROM IGS_EN_STDNT_PS_ATT sca

519: sca.version_number,
520: sca.attendance_type,
521: sca.commencement_dt,
522: sca.course_attempt_status
523: FROM IGS_EN_STDNT_PS_ATT sca
524: WHERE sca.person_id = p_person_id AND
525: sca.course_cd = v_ca_sca_course_cd;
526:
527: CURSOR c_acaiv IS

Line 821: IGS_EN_STDNT_PS_ATT sca,

817: sua.ci_sequence_number,
818: sua.uoo_id,
819: sua.version_number
820: FROM IGS_EN_SU_ATTEMPT sua,
821: IGS_EN_STDNT_PS_ATT sca,
822: IGS_PS_UNIT_VER uv
823: WHERE sua.person_id = cp_person_id AND
824: sua.course_cd = cp_course_cd AND
825: sua.uoo_id = cp_uoo_id AND

Line 1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

1022: -- also to avoid un-approved intermission records. Bug# 3885804
1023: -------------------------------------------------------------------------------------------
1024: DECLARE
1025: cst_unconfirm CONSTANT
1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1025: cst_unconfirm CONSTANT
1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1033: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;

Line 1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1033: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1034: v_last_attendance_percentage IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;

Line 1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1033: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%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;

Line 1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1033: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%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;

Line 1041: v_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_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;
1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1044: v_today_dt DATE;
1045: v_EFTD_total NUMBER;

Line 1042: v_cah_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%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;
1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1044: v_today_dt DATE;
1045: v_EFTD_total NUMBER;
1046: v_next_rec_flg BOOLEAN;

Line 1061: FROM IGS_EN_STDNT_PS_ATT sca

1057: SELECT sca.course_attempt_status,
1058: sca.commencement_dt,
1059: sca.attendance_type,
1060: sca.version_number
1061: FROM IGS_EN_STDNT_PS_ATT sca
1062: WHERE sca.person_id = p_person_id AND
1063: sca.course_cd = p_course_cd;
1064: CURSOR c_cah (
1065: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE

Line 1077: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS

1073: ORDER BY cah.hist_start_dt ASC;
1074:
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';

Line 1083: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

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
1084: SELECT crv.count_intrmsn_in_time_ind
1085: FROM IGS_PS_VER crv
1086: WHERE crv.course_cd = p_course_cd AND
1087: crv.version_number = cp_version_number;

Line 1329: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

1325: -- determined.
1326: DECLARE
1327: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1328: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1329: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1330: CURSOR c_ca_sca IS
1331: SELECT ca.sequence_number,
1332: ca.attendance_percentage,
1333: sca.attendance_type

Line 1335: IGS_EN_STDNT_PS_ATT sca

1331: SELECT ca.sequence_number,
1332: ca.attendance_percentage,
1333: sca.attendance_type
1334: FROM IGS_RE_CANDIDATURE ca,
1335: IGS_EN_STDNT_PS_ATT sca
1336: WHERE ca.person_id = p_person_id AND
1337: ca.sca_course_cd = p_course_cd AND
1338: sca.course_cd = ca.sca_course_cd AND
1339: sca.person_id = ca.person_id;

Line 1353: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS

1349: cah.hist_end_dt >= cp_effective_dt
1350: ORDER BY cah.hist_start_dt ASC;
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

Line 1419: -- Set to IGS_EN_STDNT_PS_ATT.commencement_dt if it exists.

1415: p_acai_sequence_number IN NUMBER )
1416: RETURN DATE AS
1417: gv_other_detail VARCHAR2(255);
1418: BEGIN -- resp_get_ca_comm
1419: -- Set to IGS_EN_STDNT_PS_ATT.commencement_dt if it exists.
1420: -- Set to derived commencement date if IGS_EN_STDNT_PS_ATT.commencement_dt
1421: -- doesn't exist.
1422: DECLARE
1423: CURSOR c_sca IS

Line 1420: -- Set to derived commencement date if IGS_EN_STDNT_PS_ATT.commencement_dt

1416: RETURN DATE AS
1417: gv_other_detail VARCHAR2(255);
1418: BEGIN -- resp_get_ca_comm
1419: -- Set to IGS_EN_STDNT_PS_ATT.commencement_dt if it exists.
1420: -- Set to derived commencement date if IGS_EN_STDNT_PS_ATT.commencement_dt
1421: -- doesn't exist.
1422: DECLARE
1423: CURSOR c_sca IS
1424: SELECT sca.commencement_dt

Line 1425: FROM IGS_EN_STDNT_PS_ATT sca

1421: -- doesn't exist.
1422: DECLARE
1423: CURSOR c_sca IS
1424: SELECT sca.commencement_dt
1425: FROM IGS_EN_STDNT_PS_ATT sca
1426: WHERE sca.person_id = p_person_id AND
1427: sca.course_cd = p_sca_course_cd;
1428: v_sca_rec c_sca%ROWTYPE;
1429: BEGIN