eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CERTIFICATION_API dependencies on HR_API

Line 149: when hr_api.cannot_find_prog_unit then

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: );

Line 150: hr_api.cannot_find_prog_unit_error

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;

Line 274: when hr_api.cannot_find_prog_unit then

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: );

Line 275: hr_api.cannot_find_prog_unit_error

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;

Line 285: raise hr_api.validate_enabled;

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

Line 290: when hr_api.validate_enabled then

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: --

Line 321: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 322: ,p_public_flag 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

Line 323: ,p_initial_completion_date in date default hr_api.g_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
327: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2

Line 324: ,p_initial_completion_duration in number default hr_api.g_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
328: ,p_notify_days_before_expire in number default hr_api.g_number

Line 325: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2

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

Line 326: ,p_renewal_duration in number default hr_api.g_number

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

Line 327: ,p_renewal_duration_units 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
331: ,p_description in varchar2 default hr_api.g_varchar2

Line 328: ,p_notify_days_before_expire in number default hr_api.g_number

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

Line 329: ,p_start_date_active in date default hr_api.g_date

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

Line 330: ,p_end_date_active in date default hr_api.g_date

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

Line 331: ,p_description 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

Line 332: ,p_objectives 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

Line 333: ,p_purpose 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

Line 334: ,p_keywords 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

Line 335: ,p_end_date_comments 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

Line 336: ,p_initial_period_comments 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

Line 337: ,p_renewal_period_comments 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

Line 338: ,p_attribute_category 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

Line 339: ,p_attribute1 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

Line 340: ,p_attribute2 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

Line 341: ,p_attribute3 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

Line 342: ,p_attribute4 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

Line 343: ,p_attribute5 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

Line 344: ,p_attribute6 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

Line 345: ,p_attribute7 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

Line 346: ,p_attribute8 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

Line 347: ,p_attribute9 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

Line 348: ,p_attribute10 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

Line 349: ,p_attribute11 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

Line 350: ,p_attribute12 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

Line 351: ,p_attribute13 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

Line 352: ,p_attribute14 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

Line 353: ,p_attribute15 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

Line 354: ,p_attribute16 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

Line 355: ,p_attribute17 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

Line 356: ,p_attribute18 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
360: ,p_VALIDITY_DURATION in number default hr_api.g_number

Line 357: ,p_attribute19 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
361: ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2

Line 358: ,p_attribute20 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

Line 359: ,p_business_group_id in number default hr_api.g_number

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

Line 360: ,p_VALIDITY_DURATION in number default hr_api.g_number

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

Line 361: ,p_VALIDITY_DURATION_UNITS 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

Line 362: ,p_RENEWABLE_FLAG 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
366: ) is

Line 363: ,p_VALIDITY_START_TYPE 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
367: --

Line 364: ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2

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

Line 435: when hr_api.cannot_find_prog_unit then

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: );

Line 436: hr_api.cannot_find_prog_unit_error

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;

Line 556: when hr_api.cannot_find_prog_unit then

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: );

Line 557: hr_api.cannot_find_prog_unit_error

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;

Line 567: raise hr_api.validate_enabled;

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

Line 572: when hr_api.validate_enabled then

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: --

Line 629: when hr_api.cannot_find_prog_unit then

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: );

Line 630: hr_api.cannot_find_prog_unit_error

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;

Line 654: when hr_api.cannot_find_prog_unit then

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: );

Line 655: hr_api.cannot_find_prog_unit_error

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;

Line 665: raise hr_api.validate_enabled;

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: --

Line 673: when hr_api.validate_enabled then

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: --