734: --
735: hr_multi_message.end_validation_set;
736: --
737: --
738: ota_general.check_domain_value(
739: p_domain_type => 'OTA_LP_SECTION_COMPLETION_TYPE',
740: p_domain_value => p_rec.completion_type_code);
741: --
742: IF p_rec.completion_type_code = 'O' THEN
762: --
763: l_proc varchar2(72) := g_package||'update_validate';
764: --
765: l_completion_type_changed BOOLEAN
766: := ota_general.value_changed(ota_lpc_shd.g_old_rec.completion_type_code,
767: p_rec.completion_type_code);
768:
769: l_no_of_courses_changed BOOLEAN
770: := ota_general.value_changed(ota_lpc_shd.g_old_rec.no_of_mandatory_courses,
766: := ota_general.value_changed(ota_lpc_shd.g_old_rec.completion_type_code,
767: p_rec.completion_type_code);
768:
769: l_no_of_courses_changed BOOLEAN
770: := ota_general.value_changed(ota_lpc_shd.g_old_rec.no_of_mandatory_courses,
771: p_rec.no_of_mandatory_courses);
772:
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
792: (p_effective_date => p_effective_date
793: ,p_rec => p_rec
794: );
795: --
796: ota_general.check_domain_value(
797: p_domain_type => 'OTA_LP_SECTION_COMPLETION_TYPE',
798: p_domain_value => p_rec.completion_type_code);
799: --
800: IF p_rec.completion_type_code = 'O' THEN