404:
405: CURSOR csr_lp_start_end_date IS
406: SELECT start_date_active,
407: nvl(end_date_active, to_date ('31-12-4712', 'DD-MM-YYYY'))
408: FROM ota_learning_paths
409: WHERE learning_path_id = p_learning_path_id;
410:
411:
412: --
420: Begin
421: hr_utility.set_location(' Entering:' || l_proc,10);
422: --
423: IF hr_multi_message.no_exclusive_error
424: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
425: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
426: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
427: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
428: ) THEN
421: hr_utility.set_location(' Entering:' || l_proc,10);
422: --
423: IF hr_multi_message.no_exclusive_error
424: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
425: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
426: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
427: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
428: ) THEN
429: --
422: --
423: IF hr_multi_message.no_exclusive_error
424: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
425: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
426: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
427: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
428: ) THEN
429: --
430: OPEN csr_cat_start_end_date;
423: IF hr_multi_message.no_exclusive_error
424: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
425: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
426: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
427: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
428: ) THEN
429: --
430: OPEN csr_cat_start_end_date;
431: FETCH csr_cat_start_end_date into l_cat_start_date, l_cat_end_date;
453: hr_utility.set_location(' Leaving:' || l_proc,10);
454: Exception
455: when app_exception.application_exception then
456: IF hr_multi_message.exception_add
457: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
458: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
459: ) THEN
460: hr_utility.set_location(' Leaving:'|| l_proc,20);
461: raise;
454: Exception
455: when app_exception.application_exception then
456: IF hr_multi_message.exception_add
457: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
458: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
459: ) THEN
460: hr_utility.set_location(' Leaving:'|| l_proc,20);
461: raise;
462: END IF;