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_LPM_BUS dependencies on OTA_LPM_BUS

Line 1: Package Body ota_lpm_bus as

1: Package Body ota_lpm_bus as
2: /* $Header: otlpmrhi.pkb 120.0 2005/05/29 07:22:37 appldev noship $ */
3:
4: --
5: -- ----------------------------------------------------------------------------

Line 9: g_package varchar2(33) := ' ota_lpm_bus.'; -- Global package name

5: -- ----------------------------------------------------------------------------
6: -- | Private Global Definitions |
7: -- ----------------------------------------------------------------------------
8: --
9: g_package varchar2(33) := ' ota_lpm_bus.'; -- Global package name
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

Line 123: if ( nvl(ota_lpm_bus.g_learning_path_member_id, hr_api.g_number)

119: ,p_argument => 'learning_path_member_id'
120: ,p_argument_value => p_learning_path_member_id
121: );
122: --
123: if ( nvl(ota_lpm_bus.g_learning_path_member_id, hr_api.g_number)
124: = p_learning_path_member_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 130: l_legislation_code := ota_lpm_bus.g_legislation_code;

126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := ota_lpm_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: else
133: --
134: -- The ID is different to the last call to this function

Line 154: ota_lpm_bus.g_learning_path_member_id := p_learning_path_member_id;

150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --
153: close csr_leg_code;
154: ota_lpm_bus.g_learning_path_member_id := p_learning_path_member_id;
155: ota_lpm_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;

Line 155: ota_lpm_bus.g_legislation_code := l_legislation_code;

151: -- available for the next call to this function.
152: --
153: close csr_leg_code;
154: ota_lpm_bus.g_learning_path_member_id := p_learning_path_member_id;
155: ota_lpm_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;

Line 964: ota_lpm_bus.chk_learning_path_id(

960: -- Validate Dependent Attributes
961: --
962: --
963: /*
964: ota_lpm_bus.chk_learning_path_id(
965: p_learning_path_id => p_rec.learning_path_id
966: ,p_business_group_id => p_rec.business_group_id);
967: */
968:

Line 971: ota_lpm_bus.chk_notify_days_before_target(

967: */
968:
969: hr_utility.set_location(' Step:'|| l_proc, 20);
970:
971: ota_lpm_bus.chk_notify_days_before_target(
972: p_learning_path_id => p_rec.learning_path_id
973: ,p_duration => p_rec.duration
974: ,p_notify_days_before_target => p_rec.notify_days_before_target);
975:

Line 979: ota_lpm_bus.chk_activity_version_id (

975:
976: --validations based on learning path source
977: IF is_catalog_lp(p_rec.learning_path_id) THEN
978:
979: ota_lpm_bus.chk_activity_version_id (
980: p_learning_path_member_id => p_rec.learning_path_member_id
981: ,p_object_version_number => p_rec.object_version_number
982: ,p_activity_version_id => p_rec.activity_version_id
983: ,p_learning_path_id => p_rec.learning_path_id

Line 986: ota_lpm_bus.chk_unique_course(

982: ,p_activity_version_id => p_rec.activity_version_id
983: ,p_learning_path_id => p_rec.learning_path_id
984: ,p_business_group_id => p_rec.business_group_id);
985:
986: ota_lpm_bus.chk_unique_course(
987: p_learning_path_member_id => p_rec.learning_path_member_id
988: ,p_object_version_number => p_rec.object_version_number
989: ,p_activity_version_id => p_rec.activity_version_id
990: ,p_learning_path_id => p_rec.learning_path_id);

Line 992: ota_lpm_bus.chk_duration_units(

988: ,p_object_version_number => p_rec.object_version_number
989: ,p_activity_version_id => p_rec.activity_version_id
990: ,p_learning_path_id => p_rec.learning_path_id);
991:
992: ota_lpm_bus.chk_duration_units(
993: p_learning_path_member_id => p_rec.learning_path_member_id
994: ,p_object_version_number => p_rec.object_version_number
995: ,p_duration_units => p_rec.duration_units
996: ,p_effective_date => p_effective_date);

Line 998: ota_lpm_bus.chk_duration(

994: ,p_object_version_number => p_rec.object_version_number
995: ,p_duration_units => p_rec.duration_units
996: ,p_effective_date => p_effective_date);
997:
998: ota_lpm_bus.chk_duration(
999: p_learning_path_member_id => p_rec.learning_path_member_id
1000: ,p_object_version_number => p_rec.object_version_number
1001: ,p_duration => p_rec.duration
1002: ,p_duration_units => p_rec.duration_units);

Line 1004: ota_lpm_bus.chk_df(p_rec);

1000: ,p_object_version_number => p_rec.object_version_number
1001: ,p_duration => p_rec.duration
1002: ,p_duration_units => p_rec.duration_units);
1003:
1004: ota_lpm_bus.chk_df(p_rec);
1005: END IF;
1006:
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1044: ota_lpm_bus.chk_notify_days_before_target(

1040: (p_effective_date => p_effective_date
1041: ,p_rec => p_rec
1042: );
1043: --
1044: ota_lpm_bus.chk_notify_days_before_target(
1045: p_learning_path_id => p_rec.learning_path_id
1046: ,p_duration => p_rec.duration
1047: ,p_notify_days_before_target => p_rec.notify_days_before_target);
1048:

Line 1053: ota_lpm_bus.chk_duration_units(

1049: --
1050: --validations based on learning path source
1051: IF is_catalog_lp(p_rec.learning_path_id) THEN
1052:
1053: ota_lpm_bus.chk_duration_units(
1054: p_learning_path_member_id => p_rec.learning_path_member_id
1055: ,p_object_version_number => p_rec.object_version_number
1056: ,p_duration_units => p_rec.duration_units
1057: ,p_effective_date => p_effective_date);

Line 1059: ota_lpm_bus.chk_duration(

1055: ,p_object_version_number => p_rec.object_version_number
1056: ,p_duration_units => p_rec.duration_units
1057: ,p_effective_date => p_effective_date);
1058:
1059: ota_lpm_bus.chk_duration(
1060: p_learning_path_member_id => p_rec.learning_path_member_id
1061: ,p_object_version_number => p_rec.object_version_number
1062: ,p_duration => p_rec.duration
1063: ,p_duration_units => p_rec.duration_units);

Line 1065: ota_lpm_bus.chk_df(p_rec);

1061: ,p_object_version_number => p_rec.object_version_number
1062: ,p_duration => p_rec.duration
1063: ,p_duration_units => p_rec.duration_units);
1064: --
1065: ota_lpm_bus.chk_df(p_rec);
1066: END IF;
1067:
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1091: end ota_lpm_bus;

1087: End delete_validate;
1088:
1089:
1090: --
1091: end ota_lpm_bus;