170: ,p_eligibility_status => p_eligibility_status
171: ,p_eligibility_eval_date => p_eligibility_eval_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_SCORECARD'
177: ,p_hook_type => 'BP'
178: );
171: ,p_eligibility_eval_date => p_eligibility_eval_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_SCORECARD'
177: ,p_hook_type => 'BP'
178: );
179: end;
287: ,p_eligibility_status => p_eligibility_status
288: ,p_eligibility_eval_date => p_eligibility_eval_date
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SCORECARD'
294: ,p_hook_type => 'AP'
295: );
288: ,p_eligibility_eval_date => p_eligibility_eval_date
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SCORECARD'
294: ,p_hook_type => 'AP'
295: );
296: end;
299: --
300: -- When in validation only mode raise the Validate_Enabled exception
301: --
302: if p_validate then
303: raise hr_api.validate_enabled;
304: end if;
305: --
306: -- Set all IN OUT and OUT parameters with out values
307: --
342:
343: END IF;
344:
345: exception
346: when hr_api.validate_enabled then
347: --
348: -- As the Validate_Enabled exception has been raised
349: -- we must rollback to the savepoint
350: --
384: (p_validate in boolean default false
385: ,p_effective_date in date
386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_effective_date in date
386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --
432: -- Declare cursors and local variables
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --
432: -- Declare cursors and local variables
433: --
533: ,p_eligibility_status => p_eligibility_status
534: ,p_eligibility_eval_date => p_eligibility_eval_date
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_SCORECARD'
540: ,p_hook_type => 'BP'
541: );
534: ,p_eligibility_eval_date => p_eligibility_eval_date
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_SCORECARD'
540: ,p_hook_type => 'BP'
541: );
542: end;
645: ,p_eligibility_status => p_eligibility_status
646: ,p_eligibility_eval_date => p_eligibility_eval_date
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'UPDATE_SCORECARD'
652: ,p_hook_type => 'AP'
653: );
646: ,p_eligibility_eval_date => p_eligibility_eval_date
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'UPDATE_SCORECARD'
652: ,p_hook_type => 'AP'
653: );
654: end;
657: --
658: -- When in validation only mode raise the Validate_Enabled exception
659: --
660: if p_validate then
661: raise hr_api.validate_enabled;
662: end if;
663: --
664: -- Set all IN OUT and OUT parameters with out values
665: --
694:
695: END IF;
696:
697: exception
698: when hr_api.validate_enabled then
699: --
700: -- As the Validate_Enabled exception has been raised
701: -- we must rollback to the savepoint
702: --
790: ,p_object_version_number => l_object_version_number
791: ,p_status_code => p_status_code
792: );
793: exception
794: when hr_api.cannot_find_prog_unit then
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'UPDATE_SCORECARD_STATUS'
797: ,p_hook_type => 'BP'
798: );
791: ,p_status_code => p_status_code
792: );
793: exception
794: when hr_api.cannot_find_prog_unit then
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'UPDATE_SCORECARD_STATUS'
797: ,p_hook_type => 'BP'
798: );
799: end;
821: ,p_object_version_number => l_object_version_number
822: ,p_status_code => p_status_code
823: );
824: exception
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_SCORECARD_STATUS'
828: ,p_hook_type => 'AP'
829: );
822: ,p_status_code => p_status_code
823: );
824: exception
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_SCORECARD_STATUS'
828: ,p_hook_type => 'AP'
829: );
830: end;
833: --
834: -- When in validation only mode raise the Validate_Enabled exception
835: --
836: if p_validate then
837: raise hr_api.validate_enabled;
838: end if;
839: --
840: -- Set all IN OUT and OUT parameters with out values
841: --
861:
862: END IF;
863:
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised
868: -- we must rollback to the savepoint
869: --
944: (p_scorecard_id => p_scorecard_id
945: ,p_object_version_number => p_object_version_number
946: );
947: exception
948: when hr_api.cannot_find_prog_unit then
949: hr_api.cannot_find_prog_unit_error
950: (p_module_name => 'DELETE_SCORECARD'
951: ,p_hook_type => 'BP'
952: );
945: ,p_object_version_number => p_object_version_number
946: );
947: exception
948: when hr_api.cannot_find_prog_unit then
949: hr_api.cannot_find_prog_unit_error
950: (p_module_name => 'DELETE_SCORECARD'
951: ,p_hook_type => 'BP'
952: );
953: end;
972: ,p_object_version_number => p_object_version_number
973: ,p_created_by_plan_warning => l_created_by_plan_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'DELETE_SCORECARD'
979: ,p_hook_type => 'AP'
980: );
973: ,p_created_by_plan_warning => l_created_by_plan_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'DELETE_SCORECARD'
979: ,p_hook_type => 'AP'
980: );
981: end;
984: --
985: -- When in validation only mode raise the Validate_Enabled exception
986: --
987: if p_validate then
988: raise hr_api.validate_enabled;
989: end if;
990: --
991: -- Set all IN OUT and OUT parameters with out values
992: --
1020:
1021: END IF;
1022:
1023: exception
1024: when hr_api.validate_enabled then
1025: --
1026: -- As the Validate_Enabled exception has been raised
1027: -- we must rollback to the savepoint
1028: --