APPS.OTA_LP_MEMBER_API dependencies on HR_API

Line 103: when hr_api.cannot_find_prog_unit then

99: ,p_learning_path_section_id => p_learning_path_section_id
100: ,p_notify_days_before_target => p_notify_days_before_target
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_learning_path_member'
106: ,p_hook_type => 'BP'
107: );

Line 104: hr_api.cannot_find_prog_unit_error

100: ,p_notify_days_before_target => p_notify_days_before_target
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_learning_path_member'
106: ,p_hook_type => 'BP'
107: );
108: end;

Line 188: when hr_api.cannot_find_prog_unit then

184: ,p_learning_path_member_id => l_learning_path_member_id
185: ,p_object_version_number => l_object_version_number
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'create_learning_path_member'
191: ,p_hook_type => 'AP'
192: );

Line 189: hr_api.cannot_find_prog_unit_error

185: ,p_object_version_number => l_object_version_number
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'create_learning_path_member'
191: ,p_hook_type => 'AP'
192: );
193: end;

Line 198: raise hr_api.validate_enabled;

194: --
195: -- When in validation only mode raise the Validate_Enabled exception
196: --
197: if p_validate then
198: raise hr_api.validate_enabled;
199: end if;
200: --
201: -- Set all output arguments
202: --

Line 208: when hr_api.validate_enabled then

204: p_object_version_number := l_object_version_number;
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 70);
207: exception
208: when hr_api.validate_enabled then
209: --
210: -- As the Validate_Enabled exception has been raised
211: -- we must rollback to the savepoint
212: --

Line 241: ,p_activity_version_id in number default hr_api.g_number

237: (p_validate in boolean default false
238: ,p_effective_date in date
239: ,p_learning_path_member_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_activity_version_id in number default hr_api.g_number
242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 242: ,p_course_sequence in number default hr_api.g_number

238: ,p_effective_date in date
239: ,p_learning_path_member_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_activity_version_id in number default hr_api.g_number
242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 243: ,p_duration in number default hr_api.g_number

239: ,p_learning_path_member_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_activity_version_id in number default hr_api.g_number
242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 244: ,p_duration_units in varchar2 default hr_api.g_varchar2

240: ,p_object_version_number in out nocopy number
241: ,p_activity_version_id in number default hr_api.g_number
242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute_category in varchar2 default hr_api.g_varchar2

241: ,p_activity_version_id in number default hr_api.g_number
242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute1 in varchar2 default hr_api.g_varchar2

242: ,p_course_sequence in number default hr_api.g_number
243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute2 in varchar2 default hr_api.g_varchar2

243: ,p_duration in number default hr_api.g_number
244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute3 in varchar2 default hr_api.g_varchar2

244: ,p_duration_units in varchar2 default hr_api.g_varchar2
245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute4 in varchar2 default hr_api.g_varchar2

245: ,p_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute5 in varchar2 default hr_api.g_varchar2

246: ,p_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute6 in varchar2 default hr_api.g_varchar2

247: ,p_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute7 in varchar2 default hr_api.g_varchar2

248: ,p_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute8 in varchar2 default hr_api.g_varchar2

249: ,p_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute9 in varchar2 default hr_api.g_varchar2

250: ,p_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute10 in varchar2 default hr_api.g_varchar2

251: ,p_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute11 in varchar2 default hr_api.g_varchar2

252: ,p_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute12 in varchar2 default hr_api.g_varchar2

253: ,p_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute13 in varchar2 default hr_api.g_varchar2

254: ,p_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 259: ,p_attribute14 in varchar2 default hr_api.g_varchar2

255: ,p_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute15 in varchar2 default hr_api.g_varchar2

256: ,p_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute16 in varchar2 default hr_api.g_varchar2

257: ,p_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 262: ,p_attribute17 in varchar2 default hr_api.g_varchar2

258: ,p_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_notify_days_before_target in number default hr_api.g_number

Line 263: ,p_attribute18 in varchar2 default hr_api.g_varchar2

259: ,p_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_notify_days_before_target in number default hr_api.g_number
267: ) is

Line 264: ,p_attribute19 in varchar2 default hr_api.g_varchar2

260: ,p_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_notify_days_before_target in number default hr_api.g_number
267: ) is
268: --

Line 265: ,p_attribute20 in varchar2 default hr_api.g_varchar2

261: ,p_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_notify_days_before_target in number default hr_api.g_number
267: ) is
268: --
269: -- Declare cursors and local variables

Line 266: ,p_notify_days_before_target in number default hr_api.g_number

262: ,p_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_notify_days_before_target in number default hr_api.g_number
267: ) is
268: --
269: -- Declare cursors and local variables
270: --

Line 323: when hr_api.cannot_find_prog_unit then

319: ,p_attribute20 => p_attribute20
320: ,p_notify_days_before_target => p_notify_days_before_target
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'UPDATE_learning_path_MEMBER'
326: ,p_hook_type => 'BP'
327: );

Line 324: hr_api.cannot_find_prog_unit_error

320: ,p_notify_days_before_target => p_notify_days_before_target
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'UPDATE_learning_path_MEMBER'
326: ,p_hook_type => 'BP'
327: );
328: end;

Line 402: when hr_api.cannot_find_prog_unit then

398: ,p_attribute20 => p_attribute20
399: ,p_notify_days_before_target => p_notify_days_before_target
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'UPDATE_learning_path_MEMBER'
405: ,p_hook_type => 'AP'
406: );

Line 403: hr_api.cannot_find_prog_unit_error

399: ,p_notify_days_before_target => p_notify_days_before_target
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'UPDATE_learning_path_MEMBER'
405: ,p_hook_type => 'AP'
406: );
407: end;

Line 412: raise hr_api.validate_enabled;

408: --
409: -- When in validation only mode raise the Validate_Enabled exception
410: --
411: if p_validate then
412: raise hr_api.validate_enabled;
413: end if;
414: --
415: -- Set all output arguments
416: --

Line 421: when hr_api.validate_enabled then

417: p_object_version_number := l_object_version_number;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 70);
420: exception
421: when hr_api.validate_enabled then
422: --
423: -- As the Validate_Enabled exception has been raised
424: -- we must rollback to the savepoint
425: --

Line 519: when hr_api.cannot_find_prog_unit then

515: (p_learning_path_member_id => p_learning_path_member_id
516: ,p_object_version_number => p_object_version_number
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_LEARNING_PATH_MEMBER'
522: ,p_hook_type => 'BP'
523: );

Line 520: hr_api.cannot_find_prog_unit_error

516: ,p_object_version_number => p_object_version_number
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_LEARNING_PATH_MEMBER'
522: ,p_hook_type => 'BP'
523: );
524: end;

Line 547: when hr_api.cannot_find_prog_unit then

543: (p_learning_path_member_id => p_learning_path_member_id
544: ,p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'DELETE_LEARNING_PATH_MEMBER'
550: ,p_hook_type => 'AP'
551: );

Line 548: hr_api.cannot_find_prog_unit_error

544: ,p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'DELETE_LEARNING_PATH_MEMBER'
550: ,p_hook_type => 'AP'
551: );
552: end;

Line 557: raise hr_api.validate_enabled;

553: --
554: -- When in validation only mode raise the Validate_Enabled exception
555: --
556: if p_validate then
557: raise hr_api.validate_enabled;
558: end if;
559: --
560: -- Set all output arguments
561: --

Line 565: when hr_api.validate_enabled then

561: --
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 170);
564: exception
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised
568: -- we must rollback to the savepoint
569: --