661: End If;
662: -- CODING FOR NTF PROCESS
663:
664: l_course_start_date_changed
665: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
664: l_course_start_date_changed
665: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:
675: l_location_id_changed
676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:
675: l_location_id_changed
676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
677: temp_var.location_id);
678:
679: l_training_center_id_changed
680: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
677: temp_var.location_id);
678:
679: l_training_center_id_changed
680: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
681: temp_var.training_center_id);
682:
683:
684: if (l_course_start_date_changed or