101: ,p_attribute20 => p_attribute20
102: ,p_enrollment_date => p_enrollment_date
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_cert_enrollment'
108: ,p_hook_type => 'BP'
109: );
102: ,p_enrollment_date => p_enrollment_date
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_cert_enrollment'
108: ,p_hook_type => 'BP'
109: );
110: end;
194: ,p_enrollment_date => p_enrollment_date
195: );
196:
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'CREATE_cert_enrollment'
201: ,p_hook_type => 'AP'
202: );
195: );
196:
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'CREATE_cert_enrollment'
201: ,p_hook_type => 'AP'
202: );
203: end;
205: --
206: -- When in validation only mode raise the Validate_Enabled exception
207: --
208: if p_validate then
209: raise hr_api.validate_enabled;
210: end if;
211:
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception
210: end if;
211:
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception
214: when hr_api.validate_enabled then
215: --
216: -- As the Validate_Enabled exception has been raised
217: -- we must rollback to the savepoint
218: --
243: (p_effective_date in date
244: ,p_cert_enrollment_id in number
245: ,p_object_version_number in out nocopy number
246: ,p_certification_id in number
247: ,p_person_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
244: ,p_cert_enrollment_id in number
245: ,p_object_version_number in out nocopy number
246: ,p_certification_id in number
247: ,p_person_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
245: ,p_object_version_number in out nocopy number
246: ,p_certification_id in number
247: ,p_person_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
246: ,p_certification_id in number
247: ,p_person_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
247: ,p_person_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
248: ,p_contact_id in number default hr_api.g_number
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
249: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
250: ,p_completion_date in date default hr_api.g_date
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
251: ,p_unenrollment_date in date default hr_api.g_date
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
252: ,p_expiration_date in date default hr_api.g_date
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
253: ,p_earliest_enroll_date in date default hr_api.g_date
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
254: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
256: ,p_attribute_category in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
257: ,p_attribute1 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
258: ,p_attribute2 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
259: ,p_attribute3 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
260: ,p_attribute4 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
261: ,p_attribute5 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
262: ,p_attribute6 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
263: ,p_attribute7 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
264: ,p_attribute8 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
265: ,p_attribute9 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
266: ,p_attribute10 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
267: ,p_attribute11 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
268: ,p_attribute12 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
269: ,p_attribute13 in varchar2 default hr_api.g_varchar2
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
277: ,p_enrollment_date in date default hr_api.g_date
270: ,p_attribute14 in varchar2 default hr_api.g_varchar2
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
277: ,p_enrollment_date in date default hr_api.g_date
278: ,p_validate in boolean default false
271: ,p_attribute15 in varchar2 default hr_api.g_varchar2
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
277: ,p_enrollment_date in date default hr_api.g_date
278: ,p_validate in boolean default false
279: ) is
272: ,p_attribute16 in varchar2 default hr_api.g_varchar2
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
277: ,p_enrollment_date in date default hr_api.g_date
278: ,p_validate in boolean default false
279: ) is
280: --
273: ,p_attribute17 in varchar2 default hr_api.g_varchar2
274: ,p_attribute18 in varchar2 default hr_api.g_varchar2
275: ,p_attribute19 in varchar2 default hr_api.g_varchar2
276: ,p_attribute20 in varchar2 default hr_api.g_varchar2
277: ,p_enrollment_date in date default hr_api.g_date
278: ,p_validate in boolean default false
279: ) is
280: --
281: -- Declare cursors and local variables
331: ,p_enrollment_date => p_enrollment_date
332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'UPDATE_cert_enrollment'
338: ,p_hook_type => 'BP'
339: );
332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'UPDATE_cert_enrollment'
338: ,p_hook_type => 'BP'
339: );
340: end;
423: ,p_enrollment_date => p_enrollment_date
424: );
425:
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'UPDATE_cert_enrollment'
430: ,p_hook_type => 'AP'
431: );
424: );
425:
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'UPDATE_cert_enrollment'
430: ,p_hook_type => 'AP'
431: );
432: end;
435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: if p_validate then
439: raise hr_api.validate_enabled;
440: end if;
441: --
442: -- Set all output arguments
443: --
444: p_object_version_number := l_object_version_number;
445:
446: hr_utility.set_location(' Leaving:'||l_proc, 70);
447: exception
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --
500: (p_cert_enrollment_id => p_cert_enrollment_id
501: ,p_object_version_number => p_object_version_number
502: );
503: exception
504: when hr_api.cannot_find_prog_unit then
505: hr_api.cannot_find_prog_unit_error
506: (p_module_name => 'DELETE_cert_enrollment'
507: ,p_hook_type => 'BP'
508: );
501: ,p_object_version_number => p_object_version_number
502: );
503: exception
504: when hr_api.cannot_find_prog_unit then
505: hr_api.cannot_find_prog_unit_error
506: (p_module_name => 'DELETE_cert_enrollment'
507: ,p_hook_type => 'BP'
508: );
509: end;
524: (p_cert_enrollment_id => p_cert_enrollment_id
525: ,p_object_version_number => p_object_version_number
526: );
527: exception
528: when hr_api.cannot_find_prog_unit then
529: hr_api.cannot_find_prog_unit_error
530: (p_module_name => 'DELETE_cert_enrollment'
531: ,p_hook_type => 'AP'
532: );
525: ,p_object_version_number => p_object_version_number
526: );
527: exception
528: when hr_api.cannot_find_prog_unit then
529: hr_api.cannot_find_prog_unit_error
530: (p_module_name => 'DELETE_cert_enrollment'
531: ,p_hook_type => 'AP'
532: );
533: end;
535: --
536: -- When in validation only mode raise the Validate_Enabled exception
537: --
538: if p_validate then
539: raise hr_api.validate_enabled;
540: end if;
541: --
542: -- Set all output arguments
543: --
543: --
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 170);
546: exception
547: when hr_api.validate_enabled then
548: --
549: -- As the Validate_Enabled exception has been raised
550: -- we must rollback to the savepoint
551: --
994:
995:
996:
997: if p_validate then
998: raise hr_api.validate_enabled;
999: end if;
1000:
1001: exception
1002: when hr_api.validate_enabled then
998: raise hr_api.validate_enabled;
999: end if;
1000:
1001: exception
1002: when hr_api.validate_enabled then
1003: --
1004: --
1005: -- Catch the Multiple Message List exception which
1006: -- indicates API processing has been aborted because