APPS.OTA_ACI_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 411: FROM ota_activity_versions

407: CURSOR csr_course_start_end_date IS
408: SELECT
409: start_date,
410: nvl(end_date, hr_api.g_eot)
411: FROM ota_activity_versions
412: WHERE activity_version_id = p_activity_version_id;
413:
414:
415: --

Line 428: (p_check_column1 => 'ota_activity_versions.START_DATE'

424: Begin
425: hr_utility.set_location(' Entering:' || l_proc,10);
426: --
427: IF hr_multi_message.no_exclusive_error
428: (p_check_column1 => 'ota_activity_versions.START_DATE'
429: ,p_check_column2 => 'ota_activity_versions.END_DATE'
430: ,p_associated_column1 => 'ota_activity_versions.START_DATE'
431: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
432: ) THEN

Line 429: ,p_check_column2 => 'ota_activity_versions.END_DATE'

425: hr_utility.set_location(' Entering:' || l_proc,10);
426: --
427: IF hr_multi_message.no_exclusive_error
428: (p_check_column1 => 'ota_activity_versions.START_DATE'
429: ,p_check_column2 => 'ota_activity_versions.END_DATE'
430: ,p_associated_column1 => 'ota_activity_versions.START_DATE'
431: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
432: ) THEN
433: --

Line 430: ,p_associated_column1 => 'ota_activity_versions.START_DATE'

426: --
427: IF hr_multi_message.no_exclusive_error
428: (p_check_column1 => 'ota_activity_versions.START_DATE'
429: ,p_check_column2 => 'ota_activity_versions.END_DATE'
430: ,p_associated_column1 => 'ota_activity_versions.START_DATE'
431: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
432: ) THEN
433: --
434: OPEN csr_cat_start_end_date;

Line 431: ,p_associated_column2 => 'ota_activity_versions.END_DATE'

427: IF hr_multi_message.no_exclusive_error
428: (p_check_column1 => 'ota_activity_versions.START_DATE'
429: ,p_check_column2 => 'ota_activity_versions.END_DATE'
430: ,p_associated_column1 => 'ota_activity_versions.START_DATE'
431: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
432: ) THEN
433: --
434: OPEN csr_cat_start_end_date;
435: FETCH csr_cat_start_end_date into l_cat_start_date, l_cat_end_date,l_cate_type;

Line 466: (p_associated_column1 => 'ota_activity_versions.START_DATE'

462: hr_utility.set_location(' Leaving:' || l_proc,10);
463: Exception
464: when app_exception.application_exception then
465: IF hr_multi_message.exception_add
466: (p_associated_column1 => 'ota_activity_versions.START_DATE'
467: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
468: ) THEN
469: hr_utility.set_location(' Leaving:'|| l_proc,20);
470: raise;

Line 467: ,p_associated_column2 => 'ota_activity_versions.END_DATE'

463: Exception
464: when app_exception.application_exception then
465: IF hr_multi_message.exception_add
466: (p_associated_column1 => 'ota_activity_versions.START_DATE'
467: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
468: ) THEN
469: hr_utility.set_location(' Leaving:'|| l_proc,20);
470: raise;
471: END IF;

Line 779: from ota_activity_versions tav

775: --
776: cursor sel_check_dates is
777: select start_date
778: , end_date
779: from ota_activity_versions tav
780: where tav.activity_version_id = p_activity_version_id;
781: --
782: Begin
783: --