[Home] [Help]
267: -- unit attempt assessment item and whether it is later than the due
268: -- date of the unit assessment item. If it is, then set it to be the
269: -- due date for the assessment item, this date will be used to set the
270: -- due date for the tracking item.
271: IF v_uai_due_dt < NVL (v_suaai_rec.override_due_dt, igs_ge_date.igsdate ('1900/01/01 00:00:00')) THEN
272: v_uai_due_dt := v_suaai_rec.override_due_dt;
273: END IF;
274: IF v_uai_due_dt < p_tracking_start_dt THEN
275: -- Do not create a tracking item for this record.
596: || TO_CHAR (v_suaai_rec.ass_id)
597: || '|'
598: || v_uai_reference
599: || '|'
600: || SUBSTR (igs_ge_date.igschardt (v_suaai_rec.creation_dt), 1, 18);
601: IF gv_log_created = FALSE THEN
602: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
603: gv_log_created := TRUE;
604: END IF;
700: IF NVL (p_new_translated_grade, ' ') <> NVL (p_old_translated_grade, ' ') THEN
701: v_suaoh_rec.translated_grade := p_old_translated_grade;
702: v_create_history := TRUE;
703: END IF;
704: IF NVL (p_new_translated_dt, igs_ge_date.igsdate ('1900/01/01')) <>
705: NVL (p_old_translated_dt, igs_ge_date.igsdate ('1900/01/01')) THEN
706: v_suaoh_rec.translated_dt := p_old_translated_dt;
707: v_create_history := TRUE;
708: END IF;
701: v_suaoh_rec.translated_grade := p_old_translated_grade;
702: v_create_history := TRUE;
703: END IF;
704: IF NVL (p_new_translated_dt, igs_ge_date.igsdate ('1900/01/01')) <>
705: NVL (p_old_translated_dt, igs_ge_date.igsdate ('1900/01/01')) THEN
706: v_suaoh_rec.translated_dt := p_old_translated_dt;
707: v_create_history := TRUE;
708: END IF;
709: -- Create a history record if a column has changed value