eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPS_BUS dependencies on OTA_LEARNING_PATHS

Line 32: , ota_learning_paths lps

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , ota_learning_paths lps
33: where lps.learning_path_id = p_learning_path_id
34: and pbg.business_group_id = lps.business_group_id;
35: --
36: -- Declare local variables

Line 102: , ota_learning_paths lps

98: --
99: cursor csr_leg_code is
100: select pbg.legislation_code
101: from per_business_groups_perf pbg
102: , ota_learning_paths lps
103: where lps.learning_path_id = p_learning_path_id
104: and pbg.business_group_id = lps.business_group_id;
105: --
106: -- Declare local variables

Line 250: ,p_descflex_name => 'OTA_LEARNING_PATHS'

246: -- b) During insert.
247: --
248: hr_dflex_utility.ins_or_upd_descflex_attribs
249: (p_appl_short_name => 'OTA'
250: ,p_descflex_name => 'OTA_LEARNING_PATHS'
251: ,p_attribute_category => p_rec.attribute_category
252: ,p_attribute1_name => 'ATTRIBUTE1'
253: ,p_attribute1_value => p_rec.attribute1
254: ,p_attribute2_name => 'ATTRIBUTE2'

Line 376: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE

372: -- |-------------------------------------------------------------|
373: -- ----------------------------------------------------------------------------
374: --
375: PROCEDURE chk_duration
376: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
377: ,p_object_version_number IN ota_learning_paths.object_version_number%TYPE
378: ,p_duration IN ota_learning_paths.duration%TYPE
379: ,p_duration_units IN ota_learning_paths.duration_units%TYPE
380: ) IS

Line 377: ,p_object_version_number IN ota_learning_paths.object_version_number%TYPE

373: -- ----------------------------------------------------------------------------
374: --
375: PROCEDURE chk_duration
376: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
377: ,p_object_version_number IN ota_learning_paths.object_version_number%TYPE
378: ,p_duration IN ota_learning_paths.duration%TYPE
379: ,p_duration_units IN ota_learning_paths.duration_units%TYPE
380: ) IS
381: --

Line 378: ,p_duration IN ota_learning_paths.duration%TYPE

374: --
375: PROCEDURE chk_duration
376: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
377: ,p_object_version_number IN ota_learning_paths.object_version_number%TYPE
378: ,p_duration IN ota_learning_paths.duration%TYPE
379: ,p_duration_units IN ota_learning_paths.duration_units%TYPE
380: ) IS
381: --
382: l_proc VARCHAR2(72) := g_package|| 'chk_duration';

Line 379: ,p_duration_units IN ota_learning_paths.duration_units%TYPE

375: PROCEDURE chk_duration
376: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
377: ,p_object_version_number IN ota_learning_paths.object_version_number%TYPE
378: ,p_duration IN ota_learning_paths.duration%TYPE
379: ,p_duration_units IN ota_learning_paths.duration_units%TYPE
380: ) IS
381: --
382: l_proc VARCHAR2(72) := g_package|| 'chk_duration';
383: l_exists VARCHAR2(1);

Line 395: (p_check_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID'

391: --
392: hr_utility.set_location(' Step:'|| l_proc, 30);
393:
394: IF hr_multi_message.no_exclusive_error
395: (p_check_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID'
396: ,p_associated_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID' ) THEN
397:
398:
399: hr_utility.set_location(' Step:'|| l_proc, 40);

Line 396: ,p_associated_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID' ) THEN

392: hr_utility.set_location(' Step:'|| l_proc, 30);
393:
394: IF hr_multi_message.no_exclusive_error
395: (p_check_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID'
396: ,p_associated_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID' ) THEN
397:
398:
399: hr_utility.set_location(' Step:'|| l_proc, 40);
400:

Line 438: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION') THEN

434:
435: WHEN app_exception.application_exception THEN
436:
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION') THEN
439:
440: hr_utility.set_location(' Leaving:'||l_proc, 92);
441: RAISE;
442:

Line 504: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION_UNITS') THEN

500:
501: WHEN app_exception.application_exception THEN
502:
503: IF hr_multi_message.exception_add
504: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION_UNITS') THEN
505:
506: hr_utility.set_location(' Leaving:'||l_proc, 42);
507: RAISE;
508: END IF;

Line 517: PROCEDURE chk_notify_days_before_target(p_path_source_code IN ota_learning_paths.path_source_code%TYPE

513: --
514: -- ----------------------------------------------------------------------------
515: -- |-------------------------------------------|
516: -- ----------------------------------------------------------------------------
517: PROCEDURE chk_notify_days_before_target(p_path_source_code IN ota_learning_paths.path_source_code%TYPE
518: ,p_duration IN ota_learning_paths.duration%TYPE
519: ,p_notify_days_before_target IN ota_learning_paths.notify_days_before_target%TYPE)
520: IS
521: --

Line 518: ,p_duration IN ota_learning_paths.duration%TYPE

514: -- ----------------------------------------------------------------------------
515: -- |-------------------------------------------|
516: -- ----------------------------------------------------------------------------
517: PROCEDURE chk_notify_days_before_target(p_path_source_code IN ota_learning_paths.path_source_code%TYPE
518: ,p_duration IN ota_learning_paths.duration%TYPE
519: ,p_notify_days_before_target IN ota_learning_paths.notify_days_before_target%TYPE)
520: IS
521: --
522: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';

Line 519: ,p_notify_days_before_target IN ota_learning_paths.notify_days_before_target%TYPE)

515: -- |-------------------------------------------|
516: -- ----------------------------------------------------------------------------
517: PROCEDURE chk_notify_days_before_target(p_path_source_code IN ota_learning_paths.path_source_code%TYPE
518: ,p_duration IN ota_learning_paths.duration%TYPE
519: ,p_notify_days_before_target IN ota_learning_paths.notify_days_before_target%TYPE)
520: IS
521: --
522: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';
523: l_api_updating boolean;

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

549:
550: WHEN app_exception.application_exception THEN
551:
552: IF hr_multi_message.exception_add
553: (p_associated_column1 => 'OTA_LEARNING_PATHS.NOTIFY_DAYS_BEFORE_TARGET') THEN
554:
555: hr_utility.set_location(' Leaving:'||l_proc, 42);
556: RAISE;
557: END IF;

Line 617: (p_associated_column1 => 'OTA_LEARNING_PATHS.PATH_SOURCE_CODE') THEN

613:
614: WHEN app_exception.application_exception THEN
615:
616: IF hr_multi_message.exception_add
617: (p_associated_column1 => 'OTA_LEARNING_PATHS.PATH_SOURCE_CODE') THEN
618:
619: hr_utility.set_location(' Leaving:'||l_proc, 42);
620: RAISE;
621: END IF;

Line 683: (p_associated_column1 => 'OTA_LEARNING_PATHS.SOURCE_FUNCTION_CODE') THEN

679:
680: WHEN app_exception.application_exception THEN
681:
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_LEARNING_PATHS.SOURCE_FUNCTION_CODE') THEN
684:
685: hr_utility.set_location(' Leaving:'||l_proc, 42);
686: RAISE;
687: END IF;

Line 748: (p_associated_column1 => 'OTA_LEARNING_PATHS.competency_update_level') THEN

744:
745: WHEN app_exception.application_exception THEN
746:
747: IF hr_multi_message.exception_add
748: (p_associated_column1 => 'OTA_LEARNING_PATHS.competency_update_level') THEN
749:
750: hr_utility.set_location(' Leaving:'||l_proc, 42);
751: RAISE;
752: END IF;

Line 787: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')

783: Exception
784: WHEN app_exception.application_exception THEN
785:
786: IF hr_multi_message.exception_add(
787: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')
788: -- ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')
789: THEN
790:
791: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 788: -- ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')

784: WHEN app_exception.application_exception THEN
785:
786: IF hr_multi_message.exception_add(
787: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')
788: -- ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')
789: THEN
790:
791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;

Line 837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

833: --
834: hr_utility.set_location('Entering:'|| v_proc, 5);
835: --
836: IF hr_multi_message.no_exclusive_error
837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:

Line 838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

834: hr_utility.set_location('Entering:'|| v_proc, 5);
835: --
836: IF hr_multi_message.no_exclusive_error
837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>

Line 839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

835: --
836: IF hr_multi_message.no_exclusive_error
837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN

Line 840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN

836: IF hr_multi_message.no_exclusive_error
837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;

Line 883: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')

879: WHEN app_exception.application_exception THEN
880:
881: IF l_upd_start_date THEN
882: IF hr_multi_message.exception_add(
883: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')
884: THEN
885:
886: hr_utility.set_location(' Leaving:'||v_proc, 22);
887: RAISE;

Line 891: p_associated_column1 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')

887: RAISE;
888: END IF;
889: ELSIF l_upd_end_date THEN
890: IF hr_multi_message.exception_add(
891: p_associated_column1 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')
892: THEN
893:
894: hr_utility.set_location(' Leaving:'||v_proc, 22);
895: RAISE;

Line 945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

941: Begin
942: hr_utility.set_location(' Entering:' || l_proc,10);
943: --
944: IF hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
947: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
948: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
949: ) THEN

Line 946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

942: hr_utility.set_location(' Entering:' || l_proc,10);
943: --
944: IF hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
947: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
948: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
949: ) THEN
950: --

Line 947: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

943: --
944: IF hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
947: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
948: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
949: ) THEN
950: --
951: OPEN cur_cat_start_end_date;

Line 948: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

944: IF hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
947: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
948: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
949: ) THEN
950: --
951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;

Line 987: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

983: hr_utility.set_location(' Leaving:' || l_proc,10);
984: Exception
985: when app_exception.application_exception then
986: IF hr_multi_message.exception_add
987: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
988: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
989: ) THEN
990: hr_utility.set_location(' Leaving:'|| l_proc,20);
991: raise;

Line 988: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

984: Exception
985: when app_exception.application_exception then
986: IF hr_multi_message.exception_add
987: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
988: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
989: ) THEN
990: hr_utility.set_location(' Leaving:'|| l_proc,20);
991: raise;
992: END IF;

Line 1004: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE

1000: -- |----------------------< get_path_source_code >-----------------------------|
1001: -- ----------------------------------------------------------------------------
1002: --
1003: FUNCTION get_path_source_code
1004: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
1005: ) RETURN VARCHAR2 IS
1006: --
1007: l_path_source_code ota_learning_paths.path_source_code%TYPE;
1008: l_proc VARCHAR2(72) := g_package||'get_path_source_code';

Line 1007: l_path_source_code ota_learning_paths.path_source_code%TYPE;

1003: FUNCTION get_path_source_code
1004: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
1005: ) RETURN VARCHAR2 IS
1006: --
1007: l_path_source_code ota_learning_paths.path_source_code%TYPE;
1008: l_proc VARCHAR2(72) := g_package||'get_path_source_code';
1009:
1010: CURSOR csr_get_path_source IS
1011: SELECT path_source_code

Line 1012: FROM ota_learning_paths lps

1008: l_proc VARCHAR2(72) := g_package||'get_path_source_code';
1009:
1010: CURSOR csr_get_path_source IS
1011: SELECT path_source_code
1012: FROM ota_learning_paths lps
1013: WHERE lps.learning_path_id = p_learning_path_id;
1014:
1015:
1016: BEGIN

Line 1040: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE

1036: -- |-------------------------------------------------|
1037: -- ----------------------------------------------------------------------------
1038: --
1039: FUNCTION chk_lp_enrollments_exist
1040: (p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE
1041: ) RETURN BOOLEAN IS
1042: --
1043: l_exists BOOLEAN := FALSE;
1044: l_proc VARCHAR2(72) := g_package||'chk_lp_enrollments_exist';