DBA Data[Home] [Help]

APPS.OTA_LEARNING_PATH_API dependencies on HR_API

Line 124: when hr_api.cannot_find_prog_unit then

120: ,p_public_flag => p_public_flag
121: ,p_competency_update_level => p_competency_update_level
122: );
123: exception
124: when hr_api.cannot_find_prog_unit then
125: hr_api.cannot_find_prog_unit_error
126: (p_module_name => 'CREATE_LEARNING_PATH'
127: ,p_hook_type => 'BP'
128: );

Line 125: hr_api.cannot_find_prog_unit_error

121: ,p_competency_update_level => p_competency_update_level
122: );
123: exception
124: when hr_api.cannot_find_prog_unit then
125: hr_api.cannot_find_prog_unit_error
126: (p_module_name => 'CREATE_LEARNING_PATH'
127: ,p_hook_type => 'BP'
128: );
129: end;

Line 243: when hr_api.cannot_find_prog_unit then

239: ,p_competency_update_level => p_competency_update_level
240: );
241:
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'CREATE_LEARNING_PATH'
246: ,p_hook_type => 'AP'
247: );

Line 244: hr_api.cannot_find_prog_unit_error

240: );
241:
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'CREATE_LEARNING_PATH'
246: ,p_hook_type => 'AP'
247: );
248: end;

Line 254: raise hr_api.validate_enabled;

250: --
251: -- When in validation only mode raise the Validate_Enabled exception
252: --
253: if p_validate then
254: raise hr_api.validate_enabled;
255: end if;
256:
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception

Line 259: when hr_api.validate_enabled then

255: end if;
256:
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --

Line 292: p_path_name in varchar2 default hr_api.g_varchar2,

288: (
289: p_effective_date in date,
290: p_learning_path_id in number,
291: p_object_version_number in out nocopy number,
292: p_path_name in varchar2 default hr_api.g_varchar2,
293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,

Line 293: p_description in varchar2 default hr_api.g_varchar2,

289: p_effective_date in date,
290: p_learning_path_id in number,
291: p_object_version_number in out nocopy number,
292: p_path_name in varchar2 default hr_api.g_varchar2,
293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,

Line 294: p_objectives in varchar2 default hr_api.g_varchar2,

290: p_learning_path_id in number,
291: p_object_version_number in out nocopy number,
292: p_path_name in varchar2 default hr_api.g_varchar2,
293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 295: p_keywords in varchar2 default hr_api.g_varchar2,

291: p_object_version_number in out nocopy number,
292: p_path_name in varchar2 default hr_api.g_varchar2,
293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,

Line 296: p_purpose in varchar2 default hr_api.g_varchar2,

292: p_path_name in varchar2 default hr_api.g_varchar2,
293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,

Line 297: p_duration in number default hr_api.g_number,

293: p_description in varchar2 default hr_api.g_varchar2,
294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 298: p_duration_units in varchar2 default hr_api.g_varchar2,

294: p_objectives in varchar2 default hr_api.g_varchar2,
295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 299: p_start_date_active in date default hr_api.g_date,

295: p_keywords in varchar2 default hr_api.g_varchar2,
296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 300: p_end_date_active in date default hr_api.g_date,

296: p_purpose in varchar2 default hr_api.g_varchar2,
297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 301: p_attribute_category in varchar2 default hr_api.g_varchar2,

297: p_duration in number default hr_api.g_number,
298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 302: p_attribute1 in varchar2 default hr_api.g_varchar2,

298: p_duration_units in varchar2 default hr_api.g_varchar2,
299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 303: p_attribute2 in varchar2 default hr_api.g_varchar2,

299: p_start_date_active in date default hr_api.g_date,
300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 304: p_attribute3 in varchar2 default hr_api.g_varchar2,

300: p_end_date_active in date default hr_api.g_date,
301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 305: p_attribute4 in varchar2 default hr_api.g_varchar2,

301: p_attribute_category in varchar2 default hr_api.g_varchar2,
302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 306: p_attribute5 in varchar2 default hr_api.g_varchar2,

302: p_attribute1 in varchar2 default hr_api.g_varchar2,
303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 307: p_attribute6 in varchar2 default hr_api.g_varchar2,

303: p_attribute2 in varchar2 default hr_api.g_varchar2,
304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 308: p_attribute7 in varchar2 default hr_api.g_varchar2,

304: p_attribute3 in varchar2 default hr_api.g_varchar2,
305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 309: p_attribute8 in varchar2 default hr_api.g_varchar2,

305: p_attribute4 in varchar2 default hr_api.g_varchar2,
306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 310: p_attribute9 in varchar2 default hr_api.g_varchar2,

306: p_attribute5 in varchar2 default hr_api.g_varchar2,
307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 311: p_attribute10 in varchar2 default hr_api.g_varchar2,

307: p_attribute6 in varchar2 default hr_api.g_varchar2,
308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 312: p_attribute11 in varchar2 default hr_api.g_varchar2,

308: p_attribute7 in varchar2 default hr_api.g_varchar2,
309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 313: p_attribute12 in varchar2 default hr_api.g_varchar2,

309: p_attribute8 in varchar2 default hr_api.g_varchar2,
310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 314: p_attribute13 in varchar2 default hr_api.g_varchar2,

310: p_attribute9 in varchar2 default hr_api.g_varchar2,
311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 315: p_attribute14 in varchar2 default hr_api.g_varchar2,

311: p_attribute10 in varchar2 default hr_api.g_varchar2,
312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 316: p_attribute15 in varchar2 default hr_api.g_varchar2,

312: p_attribute11 in varchar2 default hr_api.g_varchar2,
313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 317: p_attribute16 in varchar2 default hr_api.g_varchar2,

313: p_attribute12 in varchar2 default hr_api.g_varchar2,
314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 318: p_attribute17 in varchar2 default hr_api.g_varchar2,

314: p_attribute13 in varchar2 default hr_api.g_varchar2,
315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,

Line 319: p_attribute18 in varchar2 default hr_api.g_varchar2,

315: p_attribute14 in varchar2 default hr_api.g_varchar2,
316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,

Line 320: p_attribute19 in varchar2 default hr_api.g_varchar2,

316: p_attribute15 in varchar2 default hr_api.g_varchar2,
317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,

Line 321: p_attribute20 in varchar2 default hr_api.g_varchar2,

317: p_attribute16 in varchar2 default hr_api.g_varchar2,
318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,

Line 322: p_business_group_id in number default hr_api.g_number,

318: p_attribute17 in varchar2 default hr_api.g_varchar2,
319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,

Line 323: p_path_source_code in varchar2 default hr_api.g_varchar2,

319: p_attribute18 in varchar2 default hr_api.g_varchar2,
320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,

Line 324: p_source_function_code in varchar2 default hr_api.g_varchar2,

320: p_attribute19 in varchar2 default hr_api.g_varchar2,
321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,

Line 325: p_assignment_id in number default hr_api.g_number,

321: p_attribute20 in varchar2 default hr_api.g_varchar2,
322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,

Line 326: p_source_id in number default hr_api.g_number,

322: p_business_group_id in number default hr_api.g_number,
323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,

Line 327: p_notify_days_before_target in number default hr_api.g_number,

323: p_path_source_code in varchar2 default hr_api.g_varchar2,
324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,

Line 328: p_person_id in number default hr_api.g_number,

324: p_source_function_code in varchar2 default hr_api.g_varchar2,
325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,
332: p_validate in boolean default false

Line 329: p_contact_id in number default hr_api.g_number,

325: p_assignment_id in number default hr_api.g_number,
326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,
332: p_validate in boolean default false
333: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

Line 330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,

326: p_source_id in number default hr_api.g_number,
327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,
332: p_validate in boolean default false
333: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
334: ) is

Line 331: p_public_flag in varchar2 default hr_api.g_varchar2,

327: p_notify_days_before_target in number default hr_api.g_number,
328: p_person_id in number default hr_api.g_number,
329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,
332: p_validate in boolean default false
333: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
334: ) is
335: --

Line 333: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

329: p_contact_id in number default hr_api.g_number,
330: p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
331: p_public_flag in varchar2 default hr_api.g_varchar2,
332: p_validate in boolean default false
333: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
334: ) is
335: --
336: -- Declare cursors and local variables
337: --

Line 400: when hr_api.cannot_find_prog_unit then

396: );
397:
398:
399: exception
400: when hr_api.cannot_find_prog_unit then
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'UPDATE_LEARNING_PATH'
403: ,p_hook_type => 'BP'
404: );

Line 401: hr_api.cannot_find_prog_unit_error

397:
398:
399: exception
400: when hr_api.cannot_find_prog_unit then
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'UPDATE_LEARNING_PATH'
403: ,p_hook_type => 'BP'
404: );
405: end;

Line 517: when hr_api.cannot_find_prog_unit then

513: );
514:
515:
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'UPDATE_LEARNING_PATH'
520: ,p_hook_type => 'AP'
521: );

Line 518: hr_api.cannot_find_prog_unit_error

514:
515:
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'UPDATE_LEARNING_PATH'
520: ,p_hook_type => 'AP'
521: );
522: end;

Line 529: raise hr_api.validate_enabled;

525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: -- Set all output arguments
533: --

Line 536: when hr_api.validate_enabled then

532: -- Set all output arguments
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 70);
535: exception
536: when hr_api.validate_enabled then
537: --
538: -- As the Validate_Enabled exception has been raised
539: -- we must rollback to the savepoint
540: --

Line 592: when hr_api.cannot_find_prog_unit then

588: (p_learning_path_id => p_learning_path_id
589: ,p_object_version_number => p_object_version_number
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'DELETE_LEARNING_PATH'
595: ,p_hook_type => 'BP'
596: );

Line 593: hr_api.cannot_find_prog_unit_error

589: ,p_object_version_number => p_object_version_number
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'DELETE_LEARNING_PATH'
595: ,p_hook_type => 'BP'
596: );
597: end;

Line 619: when hr_api.cannot_find_prog_unit then

615: (p_learning_path_id => p_learning_path_id
616: ,p_object_version_number => p_object_version_number
617: );
618: exception
619: when hr_api.cannot_find_prog_unit then
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'DELETE_LEARNING_PATH'
622: ,p_hook_type => 'AP'
623: );

Line 620: hr_api.cannot_find_prog_unit_error

616: ,p_object_version_number => p_object_version_number
617: );
618: exception
619: when hr_api.cannot_find_prog_unit then
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'DELETE_LEARNING_PATH'
622: ,p_hook_type => 'AP'
623: );
624: end;

Line 630: raise hr_api.validate_enabled;

626: --
627: -- When in validation only mode raise the Validate_Enabled exception
628: --
629: if p_validate then
630: raise hr_api.validate_enabled;
631: end if;
632: --
633: -- Set all output arguments
634: --

Line 638: when hr_api.validate_enabled then

634: --
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 170);
637: exception
638: when hr_api.validate_enabled then
639: --
640: -- As the Validate_Enabled exception has been raised
641: -- we must rollback to the savepoint
642: --