DBA Data[Home] [Help]

APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on HR_API

Line 137: when hr_api.cannot_find_prog_unit then

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

Line 138: hr_api.cannot_find_prog_unit_error

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

Line 244: when hr_api.cannot_find_prog_unit then

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

Line 245: hr_api.cannot_find_prog_unit_error

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

Line 255: raise hr_api.validate_enabled;

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

Line 260: when hr_api.validate_enabled then

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

Line 292: p_lp_enrollment_id in number default hr_api.g_number,

288: procedure update_lp_member_enrollment
289: ( p_effective_date in date,
290: p_lp_member_enrollment_id in number,
291: p_object_version_number in out nocopy number,
292: p_lp_enrollment_id in number default hr_api.g_number,
293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,

Line 293: p_learning_path_section_id in number default hr_api.g_number,

289: ( p_effective_date in date,
290: p_lp_member_enrollment_id in number,
291: p_object_version_number in out nocopy number,
292: p_lp_enrollment_id in number default hr_api.g_number,
293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,

Line 294: p_learning_path_member_id in number default hr_api.g_number,

290: p_lp_member_enrollment_id in number,
291: p_object_version_number in out nocopy number,
292: p_lp_enrollment_id in number default hr_api.g_number,
293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 295: p_member_status_code in varchar2 default hr_api.g_varchar2,

291: p_object_version_number in out nocopy number,
292: p_lp_enrollment_id in number default hr_api.g_number,
293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 296: p_completion_target_date in date default hr_api.g_date,

292: p_lp_enrollment_id in number default hr_api.g_number,
293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 297: p_completion_date in date default hr_api.g_date,

293: p_learning_path_section_id in number default hr_api.g_number,
294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 298: p_attribute_category in varchar2 default hr_api.g_varchar2,

294: p_learning_path_member_id in number default hr_api.g_number,
295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 299: p_attribute1 in varchar2 default hr_api.g_varchar2,

295: p_member_status_code in varchar2 default hr_api.g_varchar2,
296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 300: p_attribute2 in varchar2 default hr_api.g_varchar2,

296: p_completion_target_date in date default hr_api.g_date,
297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 301: p_attribute3 in varchar2 default hr_api.g_varchar2,

297: p_completion_date in date default hr_api.g_date,
298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 302: p_attribute4 in varchar2 default hr_api.g_varchar2,

298: p_attribute_category in varchar2 default hr_api.g_varchar2,
299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 303: p_attribute5 in varchar2 default hr_api.g_varchar2,

299: p_attribute1 in varchar2 default hr_api.g_varchar2,
300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 304: p_attribute6 in varchar2 default hr_api.g_varchar2,

300: p_attribute2 in varchar2 default hr_api.g_varchar2,
301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 305: p_attribute7 in varchar2 default hr_api.g_varchar2,

301: p_attribute3 in varchar2 default hr_api.g_varchar2,
302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 306: p_attribute8 in varchar2 default hr_api.g_varchar2,

302: p_attribute4 in varchar2 default hr_api.g_varchar2,
303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 307: p_attribute9 in varchar2 default hr_api.g_varchar2,

303: p_attribute5 in varchar2 default hr_api.g_varchar2,
304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 308: p_attribute10 in varchar2 default hr_api.g_varchar2,

304: p_attribute6 in varchar2 default hr_api.g_varchar2,
305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 309: p_attribute11 in varchar2 default hr_api.g_varchar2,

305: p_attribute7 in varchar2 default hr_api.g_varchar2,
306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 310: p_attribute12 in varchar2 default hr_api.g_varchar2,

306: p_attribute8 in varchar2 default hr_api.g_varchar2,
307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 311: p_attribute13 in varchar2 default hr_api.g_varchar2,

307: p_attribute9 in varchar2 default hr_api.g_varchar2,
308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 312: p_attribute14 in varchar2 default hr_api.g_varchar2,

308: p_attribute10 in varchar2 default hr_api.g_varchar2,
309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 313: p_attribute15 in varchar2 default hr_api.g_varchar2,

309: p_attribute11 in varchar2 default hr_api.g_varchar2,
310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 314: p_attribute16 in varchar2 default hr_api.g_varchar2,

310: p_attribute12 in varchar2 default hr_api.g_varchar2,
311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 315: p_attribute17 in varchar2 default hr_api.g_varchar2,

311: p_attribute13 in varchar2 default hr_api.g_varchar2,
312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 316: p_attribute18 in varchar2 default hr_api.g_varchar2,

312: p_attribute14 in varchar2 default hr_api.g_varchar2,
313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 317: p_attribute19 in varchar2 default hr_api.g_varchar2,

313: p_attribute15 in varchar2 default hr_api.g_varchar2,
314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 318: p_attribute20 in varchar2 default hr_api.g_varchar2,

314: p_attribute16 in varchar2 default hr_api.g_varchar2,
315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 319: p_attribute21 in varchar2 default hr_api.g_varchar2,

315: p_attribute17 in varchar2 default hr_api.g_varchar2,
316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 320: p_attribute22 in varchar2 default hr_api.g_varchar2,

316: p_attribute18 in varchar2 default hr_api.g_varchar2,
317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 321: p_attribute23 in varchar2 default hr_api.g_varchar2,

317: p_attribute19 in varchar2 default hr_api.g_varchar2,
318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 322: p_attribute24 in varchar2 default hr_api.g_varchar2,

318: p_attribute20 in varchar2 default hr_api.g_varchar2,
319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 323: p_attribute25 in varchar2 default hr_api.g_varchar2,

319: p_attribute21 in varchar2 default hr_api.g_varchar2,
320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 324: p_attribute26 in varchar2 default hr_api.g_varchar2,

320: p_attribute22 in varchar2 default hr_api.g_varchar2,
321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 325: p_attribute27 in varchar2 default hr_api.g_varchar2,

321: p_attribute23 in varchar2 default hr_api.g_varchar2,
322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,

Line 326: p_attribute28 in varchar2 default hr_api.g_varchar2,

322: p_attribute24 in varchar2 default hr_api.g_varchar2,
323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,
330: p_business_group_id in number default hr_api.g_number,

Line 327: p_attribute29 in varchar2 default hr_api.g_varchar2,

323: p_attribute25 in varchar2 default hr_api.g_varchar2,
324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,
330: p_business_group_id in number default hr_api.g_number,
331: p_validate in boolean default false

Line 328: p_attribute30 in varchar2 default hr_api.g_varchar2,

324: p_attribute26 in varchar2 default hr_api.g_varchar2,
325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,
330: p_business_group_id in number default hr_api.g_number,
331: p_validate in boolean default false
332: ) is

Line 329: p_creator_person_id in number default hr_api.g_number,

325: p_attribute27 in varchar2 default hr_api.g_varchar2,
326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,
330: p_business_group_id in number default hr_api.g_number,
331: p_validate in boolean default false
332: ) is
333: --

Line 330: p_business_group_id in number default hr_api.g_number,

326: p_attribute28 in varchar2 default hr_api.g_varchar2,
327: p_attribute29 in varchar2 default hr_api.g_varchar2,
328: p_attribute30 in varchar2 default hr_api.g_varchar2,
329: p_creator_person_id in number default hr_api.g_number,
330: p_business_group_id in number default hr_api.g_number,
331: p_validate in boolean default false
332: ) is
333: --
334: -- Declare cursors and local variables

Line 425: when hr_api.cannot_find_prog_unit then

421: );
422:
423:
424: exception
425: when hr_api.cannot_find_prog_unit then
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
428: ,p_hook_type => 'BP'
429: );

Line 426: hr_api.cannot_find_prog_unit_error

422:
423:
424: exception
425: when hr_api.cannot_find_prog_unit then
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
428: ,p_hook_type => 'BP'
429: );
430: end;

Line 531: when hr_api.cannot_find_prog_unit then

527: );
528:
529:
530: exception
531: when hr_api.cannot_find_prog_unit then
532: hr_api.cannot_find_prog_unit_error
533: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
534: ,p_hook_type => 'AP'
535: );

Line 532: hr_api.cannot_find_prog_unit_error

528:
529:
530: exception
531: when hr_api.cannot_find_prog_unit then
532: hr_api.cannot_find_prog_unit_error
533: (p_module_name => 'UPDATE_LP_MEMBER_ENROLLMENT'
534: ,p_hook_type => 'AP'
535: );
536: end;

Line 543: raise hr_api.validate_enabled;

539: --
540: -- When in validation only mode raise the Validate_Enabled exception
541: --
542: if p_validate then
543: raise hr_api.validate_enabled;
544: end if;
545: --
546: -- Set all output arguments
547: --

Line 552: when hr_api.validate_enabled then

548: p_object_version_number := l_object_version_number;
549:
550: hr_utility.set_location(' Leaving:'||l_proc, 70);
551: exception
552: when hr_api.validate_enabled then
553: --
554: -- As the Validate_Enabled exception has been raised
555: -- we must rollback to the savepoint
556: --

Line 607: when hr_api.cannot_find_prog_unit then

603: (p_lp_member_enrollment_id => p_lp_member_enrollment_id
604: ,p_object_version_number => p_object_version_number
605: );
606: exception
607: when hr_api.cannot_find_prog_unit then
608: hr_api.cannot_find_prog_unit_error
609: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
610: ,p_hook_type => 'BP'
611: );

Line 608: hr_api.cannot_find_prog_unit_error

604: ,p_object_version_number => p_object_version_number
605: );
606: exception
607: when hr_api.cannot_find_prog_unit then
608: hr_api.cannot_find_prog_unit_error
609: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
610: ,p_hook_type => 'BP'
611: );
612: end;

Line 631: when hr_api.cannot_find_prog_unit then

627: (p_lp_member_enrollment_id => p_lp_member_enrollment_id
628: ,p_object_version_number => p_object_version_number
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
634: ,p_hook_type => 'AP'
635: );

Line 632: hr_api.cannot_find_prog_unit_error

628: ,p_object_version_number => p_object_version_number
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'DELETE_LP_MEMBER_ENROLLMENT'
634: ,p_hook_type => 'AP'
635: );
636: end;

Line 642: raise hr_api.validate_enabled;

638: --
639: -- When in validation only mode raise the Validate_Enabled exception
640: --
641: if p_validate then
642: raise hr_api.validate_enabled;
643: end if;
644: --
645: -- Set all output arguments
646: --

Line 650: when hr_api.validate_enabled then

646: --
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 170);
649: exception
650: when hr_api.validate_enabled then
651: --
652: -- As the Validate_Enabled exception has been raised
653: -- we must rollback to the savepoint
654: --