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.

[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_AS_SU_ATMPT_ITM

Line 1028: -- * A tracking item assigned to their IGS_AS_SU_ATMPT_ITM record.

1024: -- This module will create extraction records that will be used for the
1025: -- production of Assignment Coversheets (Attachments).
1026: -- Coversheet details will be produced for all students with the following
1027: -- criteria:
1028: -- * A tracking item assigned to their IGS_AS_SU_ATMPT_ITM record.
1029: -- * The assignment must be valid for the student.
1030: -- * The student is ENROLLED in the unit.
1031: -- * If not re-producing, then student cannot have had a coversheet produced
1032: -- previously for the assignment in this unit and teaching period.

Line 1132: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,

1128: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
1129: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
1130: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE,
1131: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1132: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1133: cp_reproduce VARCHAR2
1134: )
1135: IS
1136: SELECT

Line 1153: igs_as_su_atmpt_itm suaai,

1149: uc.unit_mode,
1150: suaai.tracking_id,
1151: sua.uoo_id
1152: FROM
1153: igs_as_su_atmpt_itm suaai,
1154: igs_en_su_attempt sua,
1155: igs_as_assessmnt_itm ai,
1156: igs_as_unit_class uc
1157: WHERE

Line 1167: IGS_AS_SU_ATMPT_ITM suaai2

1163: =
1164: ( SELECT
1165: MAX(attempt_number)
1166: FROM
1167: IGS_AS_SU_ATMPT_ITM suaai2
1168: WHERE
1169: suaai2.person_id = suaai.person_id AND
1170: suaai2.course_cd = suaai.course_cd AND
1171: suaai2.uoo_id = suaai.uoo_id AND

Line 1245: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,

1241: CURSOR c_suv (
1242: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1243: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1245: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1246: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1247: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1248: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1249: IS

Line 1246: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,

1242: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1243: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1245: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1246: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1247: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1248: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1249: IS
1250: SELECT

Line 1247: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,

1243: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1245: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1246: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1247: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1248: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1249: IS
1250: SELECT
1251: uai_due_dt,

Line 1248: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)

1244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1245: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1246: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1247: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1248: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1249: IS
1250: SELECT
1251: uai_due_dt,
1252: uai_reference

Line 1262: CURSOR c_pe (cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE)

1258: uoo_id = cp_uoo_id AND
1259: ass_id = cp_ass_id AND
1260: uai_logical_delete_dt IS NULL;
1261:
1262: CURSOR c_pe (cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE)
1263: IS
1264: SELECT
1265: title,
1266: surname,

Line 1280: CURSOR c_pa (cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE)

1276: -- Greater than start date and end date is null
1277: -- OR
1278: -- Between the start date and end date
1279:
1280: CURSOR c_pa (cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE)
1281: IS
1282: SELECT
1283: pa.addr_line_1,
1284: pa.addr_line_2,

Line 1307: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,

1303: -- Ordering by correspondence indicator (desc) means that if a
1304: -- correspondence type address exists, then it will be selected first.)
1305:
1306: CURSOR c_crv (
1307: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1308: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE
1309: )
1310: IS
1311: SELECT

Line 1308: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE

1304: -- correspondence type address exists, then it will be selected first.)
1305:
1306: CURSOR c_crv (
1307: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1308: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE
1309: )
1310: IS
1311: SELECT
1312: crv.version_number,

Line 1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,

1320: sca.course_cd = crv.course_cd AND
1321: sca.version_number = crv.version_number;
1322:
1323: CURSOR c_uv (
1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,

Line 1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,

1321: sca.version_number = crv.version_number;
1322:
1323: CURSOR c_uv (
1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE

Line 1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,

1322:
1323: CURSOR c_uv (
1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE
1330: )

Line 1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,

1323: CURSOR c_uv (
1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE
1330: )
1331: IS

Line 1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,

1324: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE
1330: )
1331: IS
1332: SELECT

Line 1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE

1325: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1326: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1327: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1328: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1329: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE
1330: )
1331: IS
1332: SELECT
1333: uv.version_number,

Line 1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,

1347: FROM IGS_AS_UNIT_MODE
1348: WHERE UNIT_MODE = cp_unit_mode;
1349:
1350: CURSOR c_suaav(
1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,

Line 1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,

1348: WHERE UNIT_MODE = cp_unit_mode;
1349:
1350: CURSOR c_suaav(
1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)

Line 1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,

1349:
1350: CURSOR c_suaav(
1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1357: IS

Line 1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,

1350: CURSOR c_suaav(
1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1357: IS
1358: SELECT

Line 1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,

1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,
1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1357: IS
1358: SELECT
1359: acad_alternate_code, -- Year

Line 1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)

1352: cp_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE,
1353: cp_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE,
1354: cp_cal_type IGS_AS_SU_ATMPT_ITM.CAL_TYPE%TYPE,
1355: cp_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE,
1356: cp_uoo_id IGS_AS_SU_ATMPT_ITM.uoo_id%TYPE)
1357: IS
1358: SELECT
1359: acad_alternate_code, -- Year
1360: teach_alternate_code -- Semester

Line 1369: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS

1365: course_cd = cp_course_cd AND
1366: uoo_id = cp_uoo_id;
1367:
1368: CURSOR c_ai(
1369: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS
1370: SELECT description
1371: FROM IGS_AS_ASSESSMNT_ITM
1372: WHERE ass_id = cp_ass_id;
1373:

Line 1785: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS

1781: atyp.ASSESSMENT_TYPE = ai.ASSESSMENT_TYPE AND
1782: NVL(atyp.s_assessment_type, cst_none) = cst_assignment;
1783: CURSOR c_suaai(
1784: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
1785: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS
1786: SELECT suaai.override_due_dt,
1787: trst.completion_dt
1788: FROM IGS_AS_SU_ATMPT_ITM suaai,
1789: IGS_TR_STEP trst,

Line 1788: FROM IGS_AS_SU_ATMPT_ITM suaai,

1784: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
1785: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS
1786: SELECT suaai.override_due_dt,
1787: trst.completion_dt
1788: FROM IGS_AS_SU_ATMPT_ITM suaai,
1789: IGS_TR_STEP trst,
1790: IGS_EN_SU_ATTEMPT sua
1791: WHERE sua.uoo_id = cp_uoo_id AND
1792: sua.person_id = suaai.person_id AND