145: ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
146: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_CERTIFICATION'
152: ,p_hook_type => 'BP'
153: );
146: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_CERTIFICATION'
152: ,p_hook_type => 'BP'
153: );
154: end;
270: ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
271: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'CREATE_CERTIFICATION'
277: ,p_hook_type => 'AP'
278: );
271: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'CREATE_CERTIFICATION'
277: ,p_hook_type => 'AP'
278: );
279: end;
281: --
282: -- When in validation only mode raise the Validate_Enabled exception
283: --
284: if p_validate then
285: raise hr_api.validate_enabled;
286: end if;
287:
288: hr_utility.set_location(' Leaving:'||l_proc, 70);
289: exception
286: end if;
287:
288: hr_utility.set_location(' Leaving:'||l_proc, 70);
289: exception
290: when hr_api.validate_enabled then
291: --
292: -- As the Validate_Enabled exception has been raised
293: -- we must rollback to the savepoint
294: --
317: procedure update_certification
318: (p_effective_date in date
319: ,p_certification_id in number
320: ,p_object_version_number in out nocopy number
321: ,p_name in varchar2 default hr_api.g_varchar2
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
318: (p_effective_date in date
319: ,p_certification_id in number
320: ,p_object_version_number in out nocopy number
321: ,p_name in varchar2 default hr_api.g_varchar2
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
319: ,p_certification_id in number
320: ,p_object_version_number in out nocopy number
321: ,p_name in varchar2 default hr_api.g_varchar2
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_name in varchar2 default hr_api.g_varchar2
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
321: ,p_name in varchar2 default hr_api.g_varchar2
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
322: ,p_public_flag in varchar2 default hr_api.g_varchar2
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
323: ,p_initial_completion_date in date default hr_api.g_date
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
324: ,p_initial_completion_duration in number default hr_api.g_number
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
326: ,p_renewal_duration in number default hr_api.g_number
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
328: ,p_notify_days_before_expire in number default hr_api.g_number
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
329: ,p_start_date_active in date default hr_api.g_date
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
330: ,p_end_date_active in date default hr_api.g_date
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
331: ,p_description in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
332: ,p_objectives in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
333: ,p_purpose in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
334: ,p_keywords in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
335: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
336: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
337: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
338: ,p_attribute_category in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
339: ,p_attribute1 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
340: ,p_attribute2 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
341: ,p_attribute3 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
342: ,p_attribute4 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
343: ,p_attribute5 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
344: ,p_attribute6 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
345: ,p_attribute7 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
346: ,p_attribute8 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
347: ,p_attribute9 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
348: ,p_attribute10 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
349: ,p_attribute11 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
350: ,p_attribute12 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
351: ,p_attribute13 in varchar2 default hr_api.g_varchar2
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
352: ,p_attribute14 in varchar2 default hr_api.g_varchar2
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
353: ,p_attribute15 in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
354: ,p_attribute16 in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
355: ,p_attribute17 in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
356: ,p_attribute18 in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
357: ,p_attribute19 in varchar2 default hr_api.g_varchar2
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
365: ,p_validate in boolean default false
358: ,p_attribute20 in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
365: ,p_validate in boolean default false
366: ) is
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
365: ,p_validate in boolean default false
366: ) is
367: --
360: ,p_VALIDITY_DURATION in number default hr_api.g_number
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362: ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363: ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
365: ,p_validate in boolean default false
366: ) is
367: --
368: -- Declare cursors and local variables
431: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
432: ,p_validate => p_validate
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'UDPATE_CERTIFICATION'
438: ,p_hook_type => 'BP'
439: );
432: ,p_validate => p_validate
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'UDPATE_CERTIFICATION'
438: ,p_hook_type => 'BP'
439: );
440: end;
552: ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
553: ,p_validate => p_validate
554: );
555: exception
556: when hr_api.cannot_find_prog_unit then
557: hr_api.cannot_find_prog_unit_error
558: (p_module_name => 'UPDATE_CERTIFICATION'
559: ,p_hook_type => 'AP'
560: );
553: ,p_validate => p_validate
554: );
555: exception
556: when hr_api.cannot_find_prog_unit then
557: hr_api.cannot_find_prog_unit_error
558: (p_module_name => 'UPDATE_CERTIFICATION'
559: ,p_hook_type => 'AP'
560: );
561: end;
563: --
564: -- When in validation only mode raise the Validate_Enabled exception
565: --
566: if p_validate then
567: raise hr_api.validate_enabled;
568: end if;
569:
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: exception
568: end if;
569:
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: exception
572: when hr_api.validate_enabled then
573: --
574: -- As the Validate_Enabled exception has been raised
575: -- we must rollback to the savepoint
576: --
625: (p_certification_id => p_certification_id
626: ,p_object_version_number => p_object_version_number
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'DELETE_CERTIFICATION'
632: ,p_hook_type => 'BP'
633: );
626: ,p_object_version_number => p_object_version_number
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'DELETE_CERTIFICATION'
632: ,p_hook_type => 'BP'
633: );
634: end;
650: (p_certification_id => p_certification_id
651: ,p_object_version_number => p_object_version_number
652: );
653: exception
654: when hr_api.cannot_find_prog_unit then
655: hr_api.cannot_find_prog_unit_error
656: (p_module_name => 'DELETE_CERTIFICATION'
657: ,p_hook_type => 'AP'
658: );
651: ,p_object_version_number => p_object_version_number
652: );
653: exception
654: when hr_api.cannot_find_prog_unit then
655: hr_api.cannot_find_prog_unit_error
656: (p_module_name => 'DELETE_CERTIFICATION'
657: ,p_hook_type => 'AP'
658: );
659: end;
661: --
662: -- When in validation only mode raise the Validate_Enabled exception
663: --
664: if p_validate then
665: raise hr_api.validate_enabled;
666: end if;
667: --
668: -- Set all output arguments
669: --
669: --
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 170);
672: exception
673: when hr_api.validate_enabled then
674: --
675: -- As the Validate_Enabled exception has been raised
676: -- we must rollback to the savepoint
677: --