91: ,p_attribute20 => p_attribute20
92: ,p_appr_line_score => p_appr_line_score
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_performance_rating',
98: p_hook_type => 'BP'
99: );
92: ,p_appr_line_score => p_appr_line_score
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_performance_rating',
98: p_hook_type => 'BP'
99: );
100: end;
180: ,p_attribute20 => p_attribute20
181: ,p_appr_line_score => p_appr_line_score
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_performance_rating',
187: p_hook_type => 'AP'
188: );
181: ,p_appr_line_score => p_appr_line_score
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_performance_rating',
187: p_hook_type => 'AP'
188: );
189: end;
192: --
193: -- When in validation only mode raise the Validate_Enabled exception
194: --
195: if p_validate then
196: raise hr_api.validate_enabled;
197: end if;
198: --
199: -- Set all output arguments
200: --
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 50);
205: --
206: exception
207: when hr_api.validate_enabled then
208: --
209: -- As the Validate_Enabled exception has been raised
210: -- we must rollback to the savepoint
211: --
265: p_performance_rating_id => p_performance_rating_id,
266: p_object_version_number => p_object_version_number
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'delete_performance_rating',
272: p_hook_type => 'BP'
273: );
266: p_object_version_number => p_object_version_number
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'delete_performance_rating',
272: p_hook_type => 'BP'
273: );
274: end;
294: p_performance_rating_id => p_performance_rating_id,
295: p_object_version_number => p_object_version_number
296: );
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'delete_performance_rating',
301: p_hook_type => 'AP'
302: );
295: p_object_version_number => p_object_version_number
296: );
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'delete_performance_rating',
301: p_hook_type => 'AP'
302: );
303: end;
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 40);
314: --
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 40);
314: --
315: exception
316: when hr_api.validate_enabled then
317: --
318: -- As the Validate_Enabled exception has been raised
319: -- we must rollback to the savepoint
320: --
345: ,p_effective_date in date
346: ,p_performance_rating_id in number
347: ,p_person_id in number default null
348: ,p_object_version_number in out nocopy number
349: ,p_appraisal_id in number default hr_api.g_number
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
346: ,p_performance_rating_id in number
347: ,p_person_id in number default null
348: ,p_object_version_number in out nocopy number
349: ,p_appraisal_id in number default hr_api.g_number
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
347: ,p_person_id in number default null
348: ,p_object_version_number in out nocopy number
349: ,p_appraisal_id in number default hr_api.g_number
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
348: ,p_object_version_number in out nocopy number
349: ,p_appraisal_id in number default hr_api.g_number
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
349: ,p_appraisal_id in number default hr_api.g_number
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
350: ,p_objective_id in number default hr_api.g_number
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
351: ,p_performance_level_id in number default hr_api.g_number
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
352: ,p_comments in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
353: ,p_attribute_category in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
354: ,p_attribute1 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
355: ,p_attribute2 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
356: ,p_attribute3 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
357: ,p_attribute4 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
358: ,p_attribute5 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
359: ,p_attribute6 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
360: ,p_attribute7 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
361: ,p_attribute8 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
362: ,p_attribute9 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
363: ,p_attribute10 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
364: ,p_attribute11 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
365: ,p_attribute12 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
366: ,p_attribute13 in varchar2 default hr_api.g_varchar2
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
374: ,p_appr_line_score in number default hr_api.g_number
367: ,p_attribute14 in varchar2 default hr_api.g_varchar2
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
374: ,p_appr_line_score in number default hr_api.g_number
375: ) is
368: ,p_attribute15 in varchar2 default hr_api.g_varchar2
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
374: ,p_appr_line_score in number default hr_api.g_number
375: ) is
376: --
369: ,p_attribute16 in varchar2 default hr_api.g_varchar2
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
374: ,p_appr_line_score in number default hr_api.g_number
375: ) is
376: --
377: -- Declare cursors and local variables
370: ,p_attribute17 in varchar2 default hr_api.g_varchar2
371: ,p_attribute18 in varchar2 default hr_api.g_varchar2
372: ,p_attribute19 in varchar2 default hr_api.g_varchar2
373: ,p_attribute20 in varchar2 default hr_api.g_varchar2
374: ,p_appr_line_score in number default hr_api.g_number
375: ) is
376: --
377: -- Declare cursors and local variables
378: --
422: ,p_attribute20 => p_attribute20
423: ,p_appr_line_score => p_appr_line_score
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'update_performance_rating',
429: p_hook_type => 'BP'
430: );
423: ,p_appr_line_score => p_appr_line_score
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'update_performance_rating',
429: p_hook_type => 'BP'
430: );
431: end;
507: ,p_attribute20 => p_attribute20
508: ,p_appr_line_score => p_appr_line_score
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_performance_rating',
514: p_hook_type => 'AP'
515: );
508: ,p_appr_line_score => p_appr_line_score
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_performance_rating',
514: p_hook_type => 'AP'
515: );
516: end;
519: --
520: -- When in validation only mode raise the Validate_Enabled exception
521: --
522: if p_validate then
523: raise hr_api.validate_enabled;
524: end if;
525: --
526: -- Set all output arguments. l_object_version_number now has the new
527: -- object version number as the update was successful
529: p_object_version_number := l_object_version_number;
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 40);
532: exception
533: when hr_api.validate_enabled then
534: --
535: -- As the Validate_Enabled exception has been raised
536: -- we must rollback to the savepoint
537: --