DBA Data[Home] [Help]

APPS.OTA_LPM_BUS dependencies on OTA_LEARNING_PATH_MEMBERS

Line 32: , ota_learning_path_members lpm

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_path_members lpm
33: where lpm.learning_path_member_id = p_learning_path_member_id
34: and pbg.business_group_id = lpm.business_group_id;
35: --
36: -- Declare local variables

Line 102: , ota_learning_path_members lpm

98: --
99: cursor csr_leg_code is
100: select pbg.legislation_code
101: from per_business_groups_perf pbg
102: , ota_learning_path_members lpm
103: where lpm.learning_path_member_id = p_learning_path_member_id
104: and pbg.business_group_id = lpm.business_group_id;
105: --
106: -- Declare local variables

Line 250: ,p_descflex_name => 'OTA_LEARNING_PATH_MEMBERS'

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_PATH_MEMBERS'
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 394: ,p_duration IN ota_learning_path_members.duration%TYPE

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: --
398: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';

Line 395: ,p_notify_days_before_target IN ota_learning_path_members.notify_days_before_target%TYPE)

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: --
398: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';
399: l_api_updating boolean;

Line 444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

440: -- |-------------------------------------------------|
441: -- ----------------------------------------------------------------------------
442: --
443: PROCEDURE chk_activity_version_id (
444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE

Line 445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE

441: -- ----------------------------------------------------------------------------
442: --
443: PROCEDURE chk_activity_version_id (
444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
449: ) IS

Line 446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE

442: --
443: PROCEDURE chk_activity_version_id (
444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
449: ) IS
450: --

Line 447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE

443: PROCEDURE chk_activity_version_id (
444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
449: ) IS
450: --
451: --

Line 448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE

444: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
445: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
446: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
447: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
448: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
449: ) IS
450: --
451: --
452: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';

Line 454: l_business_group_id ota_learning_path_members.business_group_id%TYPE;

450: --
451: --
452: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
453: l_api_updating BOOLEAN;
454: l_business_group_id ota_learning_path_members.business_group_id%TYPE;
455: l_exists VARCHAR2(1);
456:
457: --
458:

Line 474: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'

470: --
471: hr_utility.set_location(' Step:'|| l_proc, 10);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
475: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN
476:
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc

Line 475: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN

471: hr_utility.set_location(' Step:'|| l_proc, 10);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
475: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN
476:
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc
479: ,p_argument => 'p_business_group_id'

Line 528: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN

524:
525: WHEN app_exception.application_exception THEN
526:
527: IF hr_multi_message.exception_add
528: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN
529:
530: hr_utility.set_location(' Leaving:'||l_proc, 42);
531: RAISE;
532:

Line 545: (p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE

541: -- |-----------------------------------------------------|
542: -- ----------------------------------------------------------------------------
543: --
544: PROCEDURE chk_learning_path_id
545: (p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
546: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
547: ) IS
548: --
549: l_exists VARCHAR2(1);

Line 546: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE

542: -- ----------------------------------------------------------------------------
543: --
544: PROCEDURE chk_learning_path_id
545: (p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
546: ,p_business_group_id IN ota_learning_path_members.business_group_id%TYPE
547: ) IS
548: --
549: l_exists VARCHAR2(1);
550: l_proc VARCHAR2(72) := g_package|| 'chk_learning_path_id';

Line 596: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN

592:
593: WHEN app_exception.application_exception THEN
594:
595: IF hr_multi_message.exception_add
596: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN
597:
598: hr_utility.set_location(' Leaving:'||l_proc, 92);
599: RAISE;
600: END IF;

Line 611: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

607: -- |-------------------------------------------------------|
608: -- ----------------------------------------------------------------------------
609: --
610: PROCEDURE chk_unique_course
611: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
612: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
613: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
614: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
615: ) IS

Line 612: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE

608: -- ----------------------------------------------------------------------------
609: --
610: PROCEDURE chk_unique_course
611: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
612: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
613: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
614: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
615: ) IS
616: --

Line 613: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE

609: --
610: PROCEDURE chk_unique_course
611: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
612: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
613: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
614: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
615: ) IS
616: --
617: l_proc VARCHAR2(72) := g_package|| 'chk_unique';

Line 614: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE

610: PROCEDURE chk_unique_course
611: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
612: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
613: ,p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE
614: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
615: ) IS
616: --
617: l_proc VARCHAR2(72) := g_package|| 'chk_unique';
618: l_exists VARCHAR2(1);

Line 623: FROM OTA_LEARNING_PATH_MEMBERS

619: l_api_updating boolean;
620: --
621: CURSOR csr_unique IS
622: SELECT NULL
623: FROM OTA_LEARNING_PATH_MEMBERS
624: WHERE learning_path_id = p_learning_path_id
625: AND (p_activity_version_id IS NOT NULL AND
626: p_activity_version_id = activity_version_id)
627: AND (p_learning_path_member_id IS NULL

Line 637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'

633: --
634: hr_utility.set_location(' Step:'|| l_proc, 30);
635:
636: IF hr_multi_message.no_exclusive_error
637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
641:

Line 638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'

634: hr_utility.set_location(' Step:'|| l_proc, 30);
635:
636: IF hr_multi_message.no_exclusive_error
637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
641:
642:

Line 639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'

635:
636: IF hr_multi_message.no_exclusive_error
637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
641:
642:
643: hr_api.mandatory_arg_error

Line 640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN

636: IF hr_multi_message.no_exclusive_error
637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
639: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
640: ,p_associated_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
641:
642:
643: hr_api.mandatory_arg_error
644: (p_api_name => l_proc

Line 684: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN

680:
681: WHEN app_exception.application_exception THEN
682:
683: IF hr_multi_message.exception_add
684: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN
685:
686: hr_utility.set_location(' Leaving:'||l_proc, 92);
687: RAISE;
688:

Line 702: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

698: -- |------------------------------------------------------|
699: -- ----------------------------------------------------------------------------
700: --
701: PROCEDURE chk_unique_sequence
702: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
703: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
704: ,p_course_sequence IN ota_learning_path_members.course_sequence%TYPE
705: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
706: ) IS

Line 703: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE

699: -- ----------------------------------------------------------------------------
700: --
701: PROCEDURE chk_unique_sequence
702: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
703: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
704: ,p_course_sequence IN ota_learning_path_members.course_sequence%TYPE
705: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
706: ) IS
707: --

Line 704: ,p_course_sequence IN ota_learning_path_members.course_sequence%TYPE

700: --
701: PROCEDURE chk_unique_sequence
702: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
703: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
704: ,p_course_sequence IN ota_learning_path_members.course_sequence%TYPE
705: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
706: ) IS
707: --
708: l_proc VARCHAR2(72) := g_package|| 'chk_unique';

Line 705: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE

701: PROCEDURE chk_unique_sequence
702: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
703: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
704: ,p_course_sequence IN ota_learning_path_members.course_sequence%TYPE
705: ,p_learning_path_id IN ota_learning_path_members.learning_path_id%TYPE
706: ) IS
707: --
708: l_proc VARCHAR2(72) := g_package|| 'chk_unique';
709: l_exists VARCHAR2(1);

Line 714: FROM OTA_LEARNING_PATH_MEMBERS

710: l_api_updating boolean;
711: --
712: CURSOR csr_unique IS
713: SELECT NULL
714: FROM OTA_LEARNING_PATH_MEMBERS
715: WHERE learning_path_id = p_learning_path_id
716: AND (p_course_sequence IS NOT NULL AND
717: p_course_sequence = course_sequence)
718: AND (p_learning_path_member_id IS NULL

Line 728: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'

724: --
725: hr_utility.set_location(' Step:'|| l_proc, 30);
726:
727: IF hr_multi_message.no_exclusive_error
728: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
729: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
730:
731:
732: hr_api.mandatory_arg_error

Line 729: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN

725: hr_utility.set_location(' Step:'|| l_proc, 30);
726:
727: IF hr_multi_message.no_exclusive_error
728: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
729: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN
730:
731:
732: hr_api.mandatory_arg_error
733: (p_api_name => l_proc

Line 773: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.COURSE_SEQUENCE') THEN

769:
770: WHEN app_exception.application_exception THEN
771:
772: IF hr_multi_message.exception_add
773: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.COURSE_SEQUENCE') THEN
774:
775: hr_utility.set_location(' Leaving:'||l_proc, 92);
776: RAISE;
777:

Line 793: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

789: -- |-------------------------------------------------------------|
790: -- ----------------------------------------------------------------------------
791: --
792: PROCEDURE chk_duration
793: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
794: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
795: ,p_duration IN ota_learning_path_members.duration%TYPE
796: ,p_duration_units IN ota_learning_path_members.duration_units%TYPE
797: ) IS

Line 794: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE

790: -- ----------------------------------------------------------------------------
791: --
792: PROCEDURE chk_duration
793: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
794: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
795: ,p_duration IN ota_learning_path_members.duration%TYPE
796: ,p_duration_units IN ota_learning_path_members.duration_units%TYPE
797: ) IS
798: --

Line 795: ,p_duration IN ota_learning_path_members.duration%TYPE

791: --
792: PROCEDURE chk_duration
793: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
794: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
795: ,p_duration IN ota_learning_path_members.duration%TYPE
796: ,p_duration_units IN ota_learning_path_members.duration_units%TYPE
797: ) IS
798: --
799: l_proc VARCHAR2(72) := g_package|| 'chk_duration';

Line 796: ,p_duration_units IN ota_learning_path_members.duration_units%TYPE

792: PROCEDURE chk_duration
793: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
794: ,p_object_version_number IN ota_learning_path_members.object_version_number%TYPE
795: ,p_duration IN ota_learning_path_members.duration%TYPE
796: ,p_duration_units IN ota_learning_path_members.duration_units%TYPE
797: ) IS
798: --
799: l_proc VARCHAR2(72) := g_package|| 'chk_duration';
800: l_exists VARCHAR2(1);

Line 812: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'

808: --
809: hr_utility.set_location(' Step:'|| l_proc, 30);
810:
811: IF hr_multi_message.no_exclusive_error
812: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
813: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID' ) THEN
814:
815:
816: hr_utility.set_location(' Step:'|| l_proc, 40);

Line 813: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID' ) THEN

809: hr_utility.set_location(' Step:'|| l_proc, 30);
810:
811: IF hr_multi_message.no_exclusive_error
812: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
813: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID' ) THEN
814:
815:
816: hr_utility.set_location(' Step:'|| l_proc, 40);
817:

Line 855: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN

851:
852: WHEN app_exception.application_exception THEN
853:
854: IF hr_multi_message.exception_add
855: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN
856:
857: hr_utility.set_location(' Leaving:'||l_proc, 92);
858: RAISE;
859:

Line 921: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION_UNITS') THEN

917:
918: WHEN app_exception.application_exception THEN
919:
920: IF hr_multi_message.exception_add
921: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION_UNITS') THEN
922:
923: hr_utility.set_location(' Leaving:'||l_proc, 42);
924: RAISE;
925: END IF;