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

Line 271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE

267: cp_location_cd igs_ad_location.location_cd%TYPE,
268: cp_unit_mode igs_as_unit_class.unit_mode%TYPE,
269: cp_unit_class igs_as_unit_class.unit_class%TYPE,
270: cp_assessable_type igs_as_assessmnt_typ.assessment_type%TYPE,
271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE
272: ) IS
273: SELECT sua.person_id,
274: sua.course_cd,
275: sua.unit_cd,

Line 285: FROM igs_en_su_attempt_all sua,

281: sua.ci_start_dt,
282: sua.ci_end_dt,
283: sua.uoo_id,
284: sua.no_assessment_ind
285: FROM igs_en_su_attempt_all sua,
286: igs_ps_unit_ver_all uv,
287: igs_as_unit_class_all uc
288: WHERE ((cp_assess_cal_type IS NOT NULL
289: AND EXISTS (

Line 373: p_person_id igs_en_su_attempt.person_id%TYPE,

369: --
370: --
371: --
372: PROCEDURE assp_insertgrade (
373: p_person_id igs_en_su_attempt.person_id%TYPE,
374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

Line 374: p_course_cd igs_en_su_attempt.course_cd%TYPE,

370: --
371: --
372: PROCEDURE assp_insertgrade (
373: p_person_id igs_en_su_attempt.person_id%TYPE,
374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,

Line 375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,

371: --
372: PROCEDURE assp_insertgrade (
373: p_person_id igs_en_su_attempt.person_id%TYPE,
374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,

Line 376: p_cal_type igs_en_su_attempt.cal_type%TYPE,

372: PROCEDURE assp_insertgrade (
373: p_person_id igs_en_su_attempt.person_id%TYPE,
374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,

Line 377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

373: p_person_id igs_en_su_attempt.person_id%TYPE,
374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,

Line 378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,

374: p_course_cd igs_en_su_attempt.course_cd%TYPE,
375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

Line 379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,

375: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
376: p_cal_type igs_en_su_attempt.cal_type%TYPE,
377: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
378: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
379: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
380: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
381: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,

Line 386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE

382: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
383: p_version_number igs_as_su_stmptout.version_number%TYPE,
384: p_grade igs_as_su_stmptout.grade%TYPE,
385: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
386: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
387: ) IS
388: --
389: CURSOR cur_person_detail (cp_person_id NUMBER) IS
390: SELECT party_number

Line 520: p_person_id igs_en_su_attempt.person_id%TYPE,

516: --
517: --
518: --
519: PROCEDURE assp_findgrade (
520: p_person_id igs_en_su_attempt.person_id%TYPE,
521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

Line 521: p_course_cd igs_en_su_attempt.course_cd%TYPE,

517: --
518: --
519: PROCEDURE assp_findgrade (
520: p_person_id igs_en_su_attempt.person_id%TYPE,
521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,

Line 522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,

518: --
519: PROCEDURE assp_findgrade (
520: p_person_id igs_en_su_attempt.person_id%TYPE,
521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,

Line 523: p_cal_type igs_en_su_attempt.cal_type%TYPE,

519: PROCEDURE assp_findgrade (
520: p_person_id igs_en_su_attempt.person_id%TYPE,
521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,

Line 524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

520: p_person_id igs_en_su_attempt.person_id%TYPE,
521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,

Line 525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,

521: p_course_cd igs_en_su_attempt.course_cd%TYPE,
522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,

Line 526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,

522: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
523: p_cal_type igs_en_su_attempt.cal_type%TYPE,
524: p_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
525: p_ci_start_dt igs_en_su_attempt.ci_start_dt%TYPE,
526: p_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
527: p_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE,
528: p_s_grade_creation_method_type igs_as_su_stmptout.s_grade_creation_method_type%TYPE,
529: p_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
530: p_version_number igs_as_su_stmptout.version_number%TYPE,

Line 534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE

530: p_version_number igs_as_su_stmptout.version_number%TYPE,
531: p_grade igs_as_su_stmptout.grade%TYPE,
532: p_finalised_outcome_ind igs_as_su_stmptout.finalised_outcome_ind%TYPE,
533: j BINARY_INTEGER,
534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
535: ) IS
536: --
537: CURSOR c_grading_schema_grade (
538: cp_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE,

Line 1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,

1120:
1121: CURSOR c_enrolled_students (
1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1128: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

Line 1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1121: CURSOR c_enrolled_students (
1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1128: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
1129: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,

Line 1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%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,

Line 1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%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,

Line 1128: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%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,

Line 1129: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,

1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%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

Line 1131: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%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

Line 1154: igs_en_su_attempt sua,

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
1158: (cp_person_id IS NULL OR suaai.person_id = cp_person_id)

Line 1242: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1238: ORDER BY suaai.person_id, suaai.unit_cd;
1239:
1240: -- Fetch all those records
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,

Line 1243: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1239:
1240: -- Fetch all those records
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,

Line 1244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1240: -- Fetch all those records
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)

Line 1336: IGS_EN_SU_ATTEMPT sua,

1332: SELECT
1333: uv.version_number,
1334: uv.short_title
1335: FROM
1336: IGS_EN_SU_ATTEMPT sua,
1337: IGS_PS_UNIT_VER uv
1338: WHERE
1339: sua.person_id = cp_person_id AND
1340: sua.course_cd = cp_course_cd AND

Line 1374: v_last_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE := 0;

1370: SELECT description
1371: FROM IGS_AS_ASSESSMNT_ITM
1372: WHERE ass_id = cp_ass_id;
1373:
1374: v_last_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE := 0;
1375: v_last_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE := NULL;
1376: v_last_unit_cd IGS_EN_SU_ATTEMPT.UNIT_CD%TYPE := NULL;
1377: v_first_record BOOLEAN := TRUE;
1378: v_ignore_rec BOOLEAN DEFAULT TRUE;

Line 1375: v_last_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE := NULL;

1371: FROM IGS_AS_ASSESSMNT_ITM
1372: WHERE ass_id = cp_ass_id;
1373:
1374: v_last_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE := 0;
1375: v_last_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE := NULL;
1376: v_last_unit_cd IGS_EN_SU_ATTEMPT.UNIT_CD%TYPE := NULL;
1377: v_first_record BOOLEAN := TRUE;
1378: v_ignore_rec BOOLEAN DEFAULT TRUE;
1379: v_log_dt DATE := NULL;

Line 1376: v_last_unit_cd IGS_EN_SU_ATTEMPT.UNIT_CD%TYPE := NULL;

1372: WHERE ass_id = cp_ass_id;
1373:
1374: v_last_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE := 0;
1375: v_last_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE := NULL;
1376: v_last_unit_cd IGS_EN_SU_ATTEMPT.UNIT_CD%TYPE := NULL;
1377: v_first_record BOOLEAN := TRUE;
1378: v_ignore_rec BOOLEAN DEFAULT TRUE;
1379: v_log_dt DATE := NULL;
1380: v_suv_rec c_suv%ROWTYPE;

Line 1790: IGS_EN_SU_ATTEMPT sua

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
1793: sua.course_cd = suaai.course_cd AND
1794: sua.uoo_id = suaai.uoo_id AND