APPS.OTA_LP_SECTION_SWI dependencies on OTA_LEARNING_PATHS

Line 57: l_lp_source ota_learning_paths.path_source_code%TYPE;

53: l_learning_path_section_id number;
54: l_proc varchar2(72) := g_package ||'create_lp_section';
55:
56: l_section_name ota_lp_sections_tl.name%TYPE := p_section_name;
57: l_lp_source ota_learning_paths.path_source_code%TYPE;
58: l_lp_source_function ota_learning_paths.source_function_code%TYPE;
59:
60:
61: CURSOR get_lp_source IS

Line 58: l_lp_source_function ota_learning_paths.source_function_code%TYPE;

54: l_proc varchar2(72) := g_package ||'create_lp_section';
55:
56: l_section_name ota_lp_sections_tl.name%TYPE := p_section_name;
57: l_lp_source ota_learning_paths.path_source_code%TYPE;
58: l_lp_source_function ota_learning_paths.source_function_code%TYPE;
59:
60:
61: CURSOR get_lp_source IS
62: SELECT source_function_code,

Line 64: FROM ota_learning_paths

60:
61: CURSOR get_lp_source IS
62: SELECT source_function_code,
63: path_source_code
64: FROM ota_learning_paths
65: WHERE learning_path_id = p_learning_path_id;
66:
67: Begin
68: hr_utility.set_location(' Entering:' || l_proc,10);