APPS.OTA_LEARNING_PATH_SWI dependencies on OTA_LEARNING_PATHS

Line 67: l_path_name ota_learning_paths_tl.name%TYPE := p_path_name;

63: -- Variables for IN/OUT parameters
64: --
65: -- Other variables
66: l_learning_path_id number;
67: l_path_name ota_learning_paths_tl.name%TYPE := p_path_name;
68:
69: l_proc varchar2(72) := g_package ||'create_learning_path';
70:
71: Begin

Line 567: l_business_group_id OTA_LEARNING_PATHS.business_group_id%TYPE;

563: ,p_path_source_code IN VARCHAR2)
564: IS
565:
566:
567: l_business_group_id OTA_LEARNING_PATHS.business_group_id%TYPE;
568:
569: CURSOR csr_ctg_name is
570: SELECT 1
571: FROM OTA_LEARNING_PATHS_VL LPS

Line 571: FROM OTA_LEARNING_PATHS_VL LPS

567: l_business_group_id OTA_LEARNING_PATHS.business_group_id%TYPE;
568:
569: CURSOR csr_ctg_name is
570: SELECT 1
571: FROM OTA_LEARNING_PATHS_VL LPS
572: WHERE rtrim(p_name) = rtrim(lps.name)
573: AND lps.business_group_id = l_business_group_id
574: AND path_source_code = 'CATALOG'
575: AND (p_learning_path_id IS NULL

Line 581: FROM OTA_LEARNING_PATHS_VL LPS

577: AND p_learning_path_id <> lps.learning_path_id)) ;
578:
579: CURSOR csr_emp_name is
580: SELECT 1
581: FROM OTA_LEARNING_PATHS_VL LPS
582: WHERE rtrim(p_name) = rtrim(lps.name)
583: AND lps.business_group_id = l_business_group_id
584: AND person_id = p_person_id
585: AND (p_learning_path_id IS NULL

Line 591: FROM OTA_LEARNING_PATHS_VL LPS

587: AND p_learning_path_id <> lps.learning_path_id)) ;
588:
589: CURSOR csr_ct_name is
590: SELECT 1
591: FROM OTA_LEARNING_PATHS_VL LPS
592: WHERE rtrim(p_name) = rtrim(lps.name)
593: AND lps.business_group_id = l_business_group_id
594: AND contact_id = p_contact_id
595: AND (p_learning_path_id IS NULL

Line 601: FROM OTA_LEARNING_PATHS lps

597: AND p_learning_path_id <> lps.learning_path_id)) ;
598:
599: CURSOR csr_get_bg_id IS
600: SELECT lps.business_group_id
601: FROM OTA_LEARNING_PATHS lps
602: WHERE lps.learning_path_id = p_learning_path_id;
603:
604: l_exists number;
605: l_proc varchar2(72) := g_package ||'check_duplicate_name';

Line 668: (p_associated_column1 => 'OTA_LEARNING_PATHS.NAME') THEN

664:
665: WHEN app_exception.application_exception THEN
666:
667: IF hr_multi_message.exception_add
668: (p_associated_column1 => 'OTA_LEARNING_PATHS.NAME') THEN
669:
670: hr_utility.set_location(' Leaving:'||l_proc, 92);
671: RAISE;
672: