DBA Data[Home] [Help]

APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on HR_API

Line 139: when hr_api.cannot_find_prog_unit then

135: ,p_creator_person_id => p_creator_person_id
136: ,p_event_id => p_event_id
137: );
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'CREATE_LP_MEMBER_ENROLLMENT'
142: ,p_hook_type => 'BP'
143: );

Line 140: hr_api.cannot_find_prog_unit_error

136: ,p_event_id => p_event_id
137: );
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'CREATE_LP_MEMBER_ENROLLMENT'
142: ,p_hook_type => 'BP'
143: );
144: end;

Line 248: when hr_api.cannot_find_prog_unit then

244: ,p_event_id => p_event_id
245: );
246:
247: exception
248: when hr_api.cannot_find_prog_unit then
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'CREATE_LP_MEMBER_ENROLLMENT'
251: ,p_hook_type => 'AP'
252: );

Line 249: hr_api.cannot_find_prog_unit_error

245: );
246:
247: exception
248: when hr_api.cannot_find_prog_unit then
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'CREATE_LP_MEMBER_ENROLLMENT'
251: ,p_hook_type => 'AP'
252: );
253: end;

Line 259: raise hr_api.validate_enabled;

255: --
256: -- When in validation only mode raise the Validate_Enabled exception
257: --
258: if p_validate then
259: raise hr_api.validate_enabled;
260: end if;
261:
262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: exception

Line 264: when hr_api.validate_enabled then

260: end if;
261:
262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: exception
264: when hr_api.validate_enabled then
265: --
266: -- As the Validate_Enabled exception has been raised
267: -- we must rollback to the savepoint
268: --

Line 296: p_lp_enrollment_id in number default hr_api.g_number,

292: procedure update_lp_member_enrollment
293: ( p_effective_date in date,
294: p_lp_member_enrollment_id in number,
295: p_object_version_number in out nocopy number,
296: p_lp_enrollment_id in number default hr_api.g_number,
297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,

Line 297: p_learning_path_section_id in number default hr_api.g_number,

293: ( p_effective_date in date,
294: p_lp_member_enrollment_id in number,
295: p_object_version_number in out nocopy number,
296: p_lp_enrollment_id in number default hr_api.g_number,
297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,

Line 298: p_learning_path_member_id in number default hr_api.g_number,

294: p_lp_member_enrollment_id in number,
295: p_object_version_number in out nocopy number,
296: p_lp_enrollment_id in number default hr_api.g_number,
297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,
302: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 299: p_member_status_code in varchar2 default hr_api.g_varchar2,

295: p_object_version_number in out nocopy number,
296: p_lp_enrollment_id in number default hr_api.g_number,
297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,
302: p_attribute_category in varchar2 default hr_api.g_varchar2,
303: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 300: p_completion_target_date in date default hr_api.g_date,

296: p_lp_enrollment_id in number default hr_api.g_number,
297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,
302: p_attribute_category in varchar2 default hr_api.g_varchar2,
303: p_attribute1 in varchar2 default hr_api.g_varchar2,
304: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 301: p_completion_date in date default hr_api.g_date,

297: p_learning_path_section_id in number default hr_api.g_number,
298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,
302: p_attribute_category in varchar2 default hr_api.g_varchar2,
303: p_attribute1 in varchar2 default hr_api.g_varchar2,
304: p_attribute2 in varchar2 default hr_api.g_varchar2,
305: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 302: p_attribute_category in varchar2 default hr_api.g_varchar2,

298: p_learning_path_member_id in number default hr_api.g_number,
299: p_member_status_code in varchar2 default hr_api.g_varchar2,
300: p_completion_target_date in date default hr_api.g_date,
301: p_completion_date in date default hr_api.g_date,
302: p_attribute_category in varchar2 default hr_api.g_varchar2,
303: p_attribute1 in varchar2 default hr_api.g_varchar2,
304: p_attribute2 in varchar2 default hr_api.g_varchar2,
305: p_attribute3 in varchar2 default hr_api.g_varchar2,
306: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 303: p_attribute1 in varchar2 default hr_api.g_varchar2,

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

Line 304: p_attribute2 in varchar2 default hr_api.g_varchar2,

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

Line 305: p_attribute3 in varchar2 default hr_api.g_varchar2,

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

Line 306: p_attribute4 in varchar2 default hr_api.g_varchar2,

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

Line 307: p_attribute5 in varchar2 default hr_api.g_varchar2,

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

Line 308: p_attribute6 in varchar2 default hr_api.g_varchar2,

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

Line 309: p_attribute7 in varchar2 default hr_api.g_varchar2,

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

Line 310: p_attribute8 in varchar2 default hr_api.g_varchar2,

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

Line 311: p_attribute9 in varchar2 default hr_api.g_varchar2,

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

Line 312: p_attribute10 in varchar2 default hr_api.g_varchar2,

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

Line 313: p_attribute11 in varchar2 default hr_api.g_varchar2,

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

Line 314: p_attribute12 in varchar2 default hr_api.g_varchar2,

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

Line 315: p_attribute13 in varchar2 default hr_api.g_varchar2,

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

Line 316: p_attribute14 in varchar2 default hr_api.g_varchar2,

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

Line 317: p_attribute15 in varchar2 default hr_api.g_varchar2,

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

Line 318: p_attribute16 in varchar2 default hr_api.g_varchar2,

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

Line 319: p_attribute17 in varchar2 default hr_api.g_varchar2,

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

Line 320: p_attribute18 in varchar2 default hr_api.g_varchar2,

316: p_attribute14 in varchar2 default hr_api.g_varchar2,
317: p_attribute15 in varchar2 default hr_api.g_varchar2,
318: p_attribute16 in varchar2 default hr_api.g_varchar2,
319: p_attribute17 in varchar2 default hr_api.g_varchar2,
320: p_attribute18 in varchar2 default hr_api.g_varchar2,
321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 321: p_attribute19 in varchar2 default hr_api.g_varchar2,

317: p_attribute15 in varchar2 default hr_api.g_varchar2,
318: p_attribute16 in varchar2 default hr_api.g_varchar2,
319: p_attribute17 in varchar2 default hr_api.g_varchar2,
320: p_attribute18 in varchar2 default hr_api.g_varchar2,
321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 322: p_attribute20 in varchar2 default hr_api.g_varchar2,

318: p_attribute16 in varchar2 default hr_api.g_varchar2,
319: p_attribute17 in varchar2 default hr_api.g_varchar2,
320: p_attribute18 in varchar2 default hr_api.g_varchar2,
321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 323: p_attribute21 in varchar2 default hr_api.g_varchar2,

319: p_attribute17 in varchar2 default hr_api.g_varchar2,
320: p_attribute18 in varchar2 default hr_api.g_varchar2,
321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 324: p_attribute22 in varchar2 default hr_api.g_varchar2,

320: p_attribute18 in varchar2 default hr_api.g_varchar2,
321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 325: p_attribute23 in varchar2 default hr_api.g_varchar2,

321: p_attribute19 in varchar2 default hr_api.g_varchar2,
322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 326: p_attribute24 in varchar2 default hr_api.g_varchar2,

322: p_attribute20 in varchar2 default hr_api.g_varchar2,
323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 327: p_attribute25 in varchar2 default hr_api.g_varchar2,

323: p_attribute21 in varchar2 default hr_api.g_varchar2,
324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 328: p_attribute26 in varchar2 default hr_api.g_varchar2,

324: p_attribute22 in varchar2 default hr_api.g_varchar2,
325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 329: p_attribute27 in varchar2 default hr_api.g_varchar2,

325: p_attribute23 in varchar2 default hr_api.g_varchar2,
326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,

Line 330: p_attribute28 in varchar2 default hr_api.g_varchar2,

326: p_attribute24 in varchar2 default hr_api.g_varchar2,
327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,

Line 331: p_attribute29 in varchar2 default hr_api.g_varchar2,

327: p_attribute25 in varchar2 default hr_api.g_varchar2,
328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,
335: p_validate in boolean default false,

Line 332: p_attribute30 in varchar2 default hr_api.g_varchar2,

328: p_attribute26 in varchar2 default hr_api.g_varchar2,
329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,
335: p_validate in boolean default false,
336: p_event_id in number default hr_api.g_number

Line 333: p_creator_person_id in number default hr_api.g_number,

329: p_attribute27 in varchar2 default hr_api.g_varchar2,
330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,
335: p_validate in boolean default false,
336: p_event_id in number default hr_api.g_number
337: ) is

Line 334: p_business_group_id in number default hr_api.g_number,

330: p_attribute28 in varchar2 default hr_api.g_varchar2,
331: p_attribute29 in varchar2 default hr_api.g_varchar2,
332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,
335: p_validate in boolean default false,
336: p_event_id in number default hr_api.g_number
337: ) is
338: --

Line 336: p_event_id in number default hr_api.g_number

332: p_attribute30 in varchar2 default hr_api.g_varchar2,
333: p_creator_person_id in number default hr_api.g_number,
334: p_business_group_id in number default hr_api.g_number,
335: p_validate in boolean default false,
336: p_event_id in number default hr_api.g_number
337: ) is
338: --
339: -- Declare cursors and local variables
340: --

Line 431: when hr_api.cannot_find_prog_unit then

427: );
428:
429:
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
434: ,p_hook_type => 'BP'
435: );

Line 432: hr_api.cannot_find_prog_unit_error

428:
429:
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
434: ,p_hook_type => 'BP'
435: );
436: end;

Line 539: when hr_api.cannot_find_prog_unit then

535: );
536:
537:
538: exception
539: when hr_api.cannot_find_prog_unit then
540: hr_api.cannot_find_prog_unit_error
541: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
542: ,p_hook_type => 'AP'
543: );

Line 540: hr_api.cannot_find_prog_unit_error

536:
537:
538: exception
539: when hr_api.cannot_find_prog_unit then
540: hr_api.cannot_find_prog_unit_error
541: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
542: ,p_hook_type => 'AP'
543: );
544: end;

Line 551: raise hr_api.validate_enabled;

547: --
548: -- When in validation only mode raise the Validate_Enabled exception
549: --
550: if p_validate then
551: raise hr_api.validate_enabled;
552: end if;
553: --
554: -- Set all output arguments
555: --

Line 560: when hr_api.validate_enabled then

556: p_object_version_number := l_object_version_number;
557:
558: hr_utility.set_location(' Leaving:'||l_proc, 70);
559: exception
560: when hr_api.validate_enabled then
561: --
562: -- As the Validate_Enabled exception has been raised
563: -- we must rollback to the savepoint
564: --

Line 615: when hr_api.cannot_find_prog_unit then

611: (p_lp_member_enrollment_id => p_lp_member_enrollment_id
612: ,p_object_version_number => p_object_version_number
613: );
614: exception
615: when hr_api.cannot_find_prog_unit then
616: hr_api.cannot_find_prog_unit_error
617: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
618: ,p_hook_type => 'BP'
619: );

Line 616: hr_api.cannot_find_prog_unit_error

612: ,p_object_version_number => p_object_version_number
613: );
614: exception
615: when hr_api.cannot_find_prog_unit then
616: hr_api.cannot_find_prog_unit_error
617: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
618: ,p_hook_type => 'BP'
619: );
620: end;

Line 639: when hr_api.cannot_find_prog_unit then

635: (p_lp_member_enrollment_id => p_lp_member_enrollment_id
636: ,p_object_version_number => p_object_version_number
637: );
638: exception
639: when hr_api.cannot_find_prog_unit then
640: hr_api.cannot_find_prog_unit_error
641: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
642: ,p_hook_type => 'AP'
643: );

Line 640: hr_api.cannot_find_prog_unit_error

636: ,p_object_version_number => p_object_version_number
637: );
638: exception
639: when hr_api.cannot_find_prog_unit then
640: hr_api.cannot_find_prog_unit_error
641: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
642: ,p_hook_type => 'AP'
643: );
644: end;

Line 650: raise hr_api.validate_enabled;

646: --
647: -- When in validation only mode raise the Validate_Enabled exception
648: --
649: if p_validate then
650: raise hr_api.validate_enabled;
651: end if;
652: --
653: -- Set all output arguments
654: --

Line 658: when hr_api.validate_enabled then

654: --
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 170);
657: exception
658: when hr_api.validate_enabled then
659: --
660: -- As the Validate_Enabled exception has been raised
661: -- we must rollback to the savepoint
662: --