APPS.OTA_LPM_BUS dependencies on OTA_LEARNING_PATHS

Line 364: v_path_source_code ota_learning_paths.path_source_code%TYPE;

360: --
361: Function is_catalog_lp(p_learning_path_id IN NUMBER)
362: RETURN BOOLEAN is
363: --
364: v_path_source_code ota_learning_paths.path_source_code%TYPE;
365: l_return boolean := FALSE;
366: v_proc varchar2(72) := g_package||'is_catalog_lp';
367: --
368: cursor csr_is_catalog_lp is

Line 370: from ota_learning_paths lps

366: v_proc varchar2(72) := g_package||'is_catalog_lp';
367: --
368: cursor csr_is_catalog_lp is
369: select path_source_code
370: from ota_learning_paths lps
371: where lps.learning_path_id = p_learning_path_id;
372: --
373: Begin
374: --

Line 393: PROCEDURE chk_notify_days_before_target(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE

389: --
390: -- ----------------------------------------------------------------------------
391: -- |-------------------------------------------|
392: -- ----------------------------------------------------------------------------
393: PROCEDURE chk_notify_days_before_target(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
394: ,p_duration IN ota_learning_path_members.duration%TYPE
395: ,p_notify_days_before_target IN ota_learning_path_members.notify_days_before_target%TYPE)
396: IS
397: --

Line 429: (p_associated_column1 => 'OTA_LEARNING_PATHS.NOTIFY_DAYS_BEFORE_TARGET') THEN

425:
426: WHEN app_exception.application_exception THEN
427:
428: IF hr_multi_message.exception_add
429: (p_associated_column1 => 'OTA_LEARNING_PATHS.NOTIFY_DAYS_BEFORE_TARGET') THEN
430:
431: hr_utility.set_location(' Leaving:'||l_proc, 42);
432: RAISE;
433: END IF;

Line 554: FROM OTA_LEARNING_PATHS

550: l_proc VARCHAR2(72) := g_package|| 'chk_learning_path_id';
551: --
552: CURSOR csr_learning_path_id IS
553: SELECT NULL
554: FROM OTA_LEARNING_PATHS
555: WHERE learning_path_id = p_learning_path_id
556: AND business_group_id = p_business_group_id;
557: BEGIN
558: --