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_LPS_BUS

Line 1: Package Body ota_lps_bus as

1: Package Body ota_lps_bus as
2: /* $Header: otlpsrhi.pkb 120.0 2005/05/29 07:24:04 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_lps_bus.'; -- Global package name

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

Line 123: if ( nvl(ota_lps_bus.g_learning_path_id, hr_api.g_number)

119: ,p_argument => 'learning_path_id'
120: ,p_argument_value => p_learning_path_id
121: );
122: --
123: if ( nvl(ota_lps_bus.g_learning_path_id, hr_api.g_number)
124: = p_learning_path_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_lps_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_lps_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_lps_bus.g_learning_path_id := p_learning_path_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_lps_bus.g_learning_path_id := p_learning_path_id;
155: ota_lps_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_lps_bus.g_legislation_code := l_legislation_code;

151: -- available for the next call to this function.
152: --
153: close csr_leg_code;
154: ota_lps_bus.g_learning_path_id := p_learning_path_id;
155: ota_lps_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 1107: ota_lps_bus.chk_path_source_code(

1103: -- Validate Dependent Attributes
1104: --
1105: --
1106: hr_utility.set_location(' Step:'|| l_proc, 10);
1107: ota_lps_bus.chk_path_source_code(
1108: p_learning_path_id => p_rec.learning_path_id
1109: ,p_object_version_number => p_rec.object_version_number
1110: ,p_path_source_code => p_rec.path_source_code
1111: ,p_effective_date => p_effective_date);

Line 1113: ota_lps_bus.chk_notify_days_before_target(

1109: ,p_object_version_number => p_rec.object_version_number
1110: ,p_path_source_code => p_rec.path_source_code
1111: ,p_effective_date => p_effective_date);
1112:
1113: ota_lps_bus.chk_notify_days_before_target(
1114: p_path_source_code => p_rec.path_source_code
1115: ,p_duration => p_rec.duration
1116: ,p_notify_days_before_target => p_rec.notify_days_before_target);
1117:

Line 1118: ota_lps_bus.chk_competency_update_level (p_learning_path_id => p_rec.learning_path_id

1114: p_path_source_code => p_rec.path_source_code
1115: ,p_duration => p_rec.duration
1116: ,p_notify_days_before_target => p_rec.notify_days_before_target);
1117:
1118: ota_lps_bus.chk_competency_update_level (p_learning_path_id => p_rec.learning_path_id
1119: ,p_object_version_number => p_rec.object_version_number
1120: ,p_competency_update_level => p_rec.competency_update_level
1121: ,p_effective_date => p_effective_date);
1122:

Line 1126: ota_lps_bus.chk_duration_units(

1122:
1123: IF p_rec.path_source_code = 'CATALOG' THEN
1124:
1125:
1126: ota_lps_bus.chk_duration_units(
1127: p_learning_path_id => p_rec.learning_path_id
1128: ,p_object_version_number => p_rec.object_version_number
1129: ,p_duration_units => p_rec.duration_units
1130: ,p_effective_date => p_effective_date);

Line 1132: ota_lps_bus.chk_duration(

1128: ,p_object_version_number => p_rec.object_version_number
1129: ,p_duration_units => p_rec.duration_units
1130: ,p_effective_date => p_effective_date);
1131:
1132: ota_lps_bus.chk_duration(
1133: p_learning_path_id => p_rec.learning_path_id
1134: ,p_object_version_number => p_rec.object_version_number
1135: ,p_duration => p_rec.duration
1136: ,p_duration_units => p_rec.duration_units);

Line 1138: ota_lps_bus.check_start_end_dates(p_rec.start_date_active

1134: ,p_object_version_number => p_rec.object_version_number
1135: ,p_duration => p_rec.duration
1136: ,p_duration_units => p_rec.duration_units);
1137:
1138: ota_lps_bus.check_start_end_dates(p_rec.start_date_active
1139: ,p_rec.end_date_active);
1140:
1141: -- enable dff validation for only Catalog Learning Paths
1142: ota_lps_bus.chk_df(p_rec);

Line 1142: ota_lps_bus.chk_df(p_rec);

1138: ota_lps_bus.check_start_end_dates(p_rec.start_date_active
1139: ,p_rec.end_date_active);
1140:
1141: -- enable dff validation for only Catalog Learning Paths
1142: ota_lps_bus.chk_df(p_rec);
1143:
1144: ELSIF p_rec.path_source_code = 'TALENT_MGMT' THEN
1145:
1146: ota_lps_bus.chk_source_function_code(

Line 1146: ota_lps_bus.chk_source_function_code(

1142: ota_lps_bus.chk_df(p_rec);
1143:
1144: ELSIF p_rec.path_source_code = 'TALENT_MGMT' THEN
1145:
1146: ota_lps_bus.chk_source_function_code(
1147: p_learning_path_id => p_rec.learning_path_id
1148: ,p_object_version_number => p_rec.object_version_number
1149: ,p_source_function_code => p_rec.source_function_code
1150: ,p_effective_date => p_effective_date);

Line 1206: ota_lps_bus.chk_path_source_code(

1202: (p_effective_date => p_effective_date
1203: ,p_rec => p_rec
1204: );
1205: --
1206: ota_lps_bus.chk_path_source_code(
1207: p_learning_path_id => p_rec.learning_path_id
1208: ,p_object_version_number => p_rec.object_version_number
1209: ,p_path_source_code => p_rec.path_source_code
1210: ,p_effective_date => p_effective_date);

Line 1212: ota_lps_bus.chk_notify_days_before_target(

1208: ,p_object_version_number => p_rec.object_version_number
1209: ,p_path_source_code => p_rec.path_source_code
1210: ,p_effective_date => p_effective_date);
1211:
1212: ota_lps_bus.chk_notify_days_before_target(
1213: p_path_source_code => p_rec.path_source_code
1214: ,p_duration => p_rec.duration
1215: ,p_notify_days_before_target => p_rec.notify_days_before_target);
1216:

Line 1217: ota_lps_bus.chk_competency_update_level (p_learning_path_id => p_rec.learning_path_id

1213: p_path_source_code => p_rec.path_source_code
1214: ,p_duration => p_rec.duration
1215: ,p_notify_days_before_target => p_rec.notify_days_before_target);
1216:
1217: ota_lps_bus.chk_competency_update_level (p_learning_path_id => p_rec.learning_path_id
1218: ,p_object_version_number => p_rec.object_version_number
1219: ,p_competency_update_level => p_rec.competency_update_level
1220: ,p_effective_date => p_effective_date);
1221:

Line 1224: ota_lps_bus.chk_duration_units(

1220: ,p_effective_date => p_effective_date);
1221:
1222: IF p_rec.path_source_code = 'CATALOG' THEN
1223:
1224: ota_lps_bus.chk_duration_units(
1225: p_learning_path_id => p_rec.learning_path_id
1226: ,p_object_version_number => p_rec.object_version_number
1227: ,p_duration_units => p_rec.duration_units
1228: ,p_effective_date => p_effective_date);

Line 1230: ota_lps_bus.chk_duration(

1226: ,p_object_version_number => p_rec.object_version_number
1227: ,p_duration_units => p_rec.duration_units
1228: ,p_effective_date => p_effective_date);
1229:
1230: ota_lps_bus.chk_duration(
1231: p_learning_path_id => p_rec.learning_path_id
1232: ,p_object_version_number => p_rec.object_version_number
1233: ,p_duration => p_rec.duration
1234: ,p_duration_units => p_rec.duration_units);

Line 1257: ota_lps_bus.chk_df(p_rec);

1253: END IF;
1254: END IF;
1255: --
1256: -- enable dff validation for only Catalog Learning Paths
1257: ota_lps_bus.chk_df(p_rec);
1258:
1259: ELSIF p_rec.path_source_code = 'TALENT_MGMT' THEN
1260:
1261: ota_lps_bus.chk_source_function_code(

Line 1261: ota_lps_bus.chk_source_function_code(

1257: ota_lps_bus.chk_df(p_rec);
1258:
1259: ELSIF p_rec.path_source_code = 'TALENT_MGMT' THEN
1260:
1261: ota_lps_bus.chk_source_function_code(
1262: p_learning_path_id => p_rec.learning_path_id
1263: ,p_object_version_number => p_rec.object_version_number
1264: ,p_source_function_code => p_rec.source_function_code
1265: ,p_effective_date => p_effective_date);

Line 1301: end ota_lps_bus;

1297: End delete_validate;
1298:
1299:
1300: --
1301: end ota_lps_bus;