APPS.OTA_LPC_BUS dependencies on OTA_LEARNING_PATHS

Line 521: l_lp_id ota_learning_paths.learning_path_id%TYPE;

517: Function is_last_section
518: (p_learning_path_section_id in ota_lp_sections.learning_path_section_id%TYPE)
519: RETURN BOOLEAN is
520: --
521: l_lp_id ota_learning_paths.learning_path_id%TYPE;
522: l_count_sections NUMBER;
523: l_return boolean := FALSE;
524: v_proc varchar2(72) := g_package||'is_last_section';
525: --

Line 573: v_path_source_code ota_learning_paths.path_source_code%TYPE;

569: Function is_catalog_lp
570: (p_learning_path_id in number)
571: RETURN BOOLEAN is
572: --
573: v_path_source_code ota_learning_paths.path_source_code%TYPE;
574: l_return boolean := FALSE;
575: v_proc varchar2(72) := g_package||'is_catalog_lp';
576: --
577: cursor csr_is_catalog_lp is

Line 579: from ota_learning_paths lps

575: v_proc varchar2(72) := g_package||'is_catalog_lp';
576: --
577: cursor csr_is_catalog_lp is
578: select path_source_code
579: from ota_learning_paths lps
580: where lps.learning_path_id = p_learning_path_id;
581: --
582: Begin
583: --

Line 612: v_path_source_code ota_learning_paths.path_source_code%TYPE;

608: (p_learning_path_section_id in number,
609: p_learning_path_id in number
610: ) is
611: --
612: v_path_source_code ota_learning_paths.path_source_code%TYPE;
613: v_proc varchar2(72) := g_package||'disable_section_dff';
614: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
615: hr_dflex_utility.l_ignore_dfcode_varray();
616: --

Line 619: from ota_learning_paths lps

615: hr_dflex_utility.l_ignore_dfcode_varray();
616: --
617: cursor csr_is_catalog_lp is
618: select path_source_code
619: from ota_learning_paths lps
620: where lps.learning_path_id = p_learning_path_id;
621: --
622: Begin
623: --