107: ,p_attribute19 => p_attribute19
108: ,p_attribute20 => p_attribute20
109: ,p_effective_date => p_effective_date );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_assessment',
114: p_hook_type => 'BP'
115: );
108: ,p_attribute20 => p_attribute20
109: ,p_effective_date => p_effective_date );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_assessment',
114: p_hook_type => 'BP'
115: );
116: end;
209: ,p_attribute19 => p_attribute19
210: ,p_attribute20 => p_attribute20
211: ,p_effective_date => p_effective_date );
212: exception
213: when hr_api.cannot_find_prog_unit then
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'create_assessment',
216: p_hook_type => 'AP'
217: );
210: ,p_attribute20 => p_attribute20
211: ,p_effective_date => p_effective_date );
212: exception
213: when hr_api.cannot_find_prog_unit then
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'create_assessment',
216: p_hook_type => 'AP'
217: );
218: end;
221: --
222: -- When in validation only mode raise the Validate_Enabled exception
223: --
224: if p_validate then
225: raise hr_api.validate_enabled;
226: end if;
227: --
228: -- Set all output arguments
229: --
231: p_object_version_number := l_object_version_number;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 11);
234: exception
235: when hr_api.validate_enabled then
236: --
237: -- As the Validate_Enabled exception has been raised
238: -- we must rollback to the savepoint
239: --
267: --
268: procedure update_assessment
269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
268: procedure update_assessment
269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,
303: p_effective_date in date
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,
303: p_effective_date in date
304: ) is
355: p_object_version_number => p_object_version_number,
356: p_effective_date => p_effective_date
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_assessment',
362: p_hook_type => 'BP'
363: );
356: p_effective_date => p_effective_date
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_assessment',
362: p_hook_type => 'BP'
363: );
364: end;
450: p_object_version_number => l_object_version_number,
451: p_effective_date => p_effective_date
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'update_assessment',
457: p_hook_type => 'AP'
458: );
451: p_effective_date => p_effective_date
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'update_assessment',
457: p_hook_type => 'AP'
458: );
459: end;
462: --
463: -- When in validation only mode raise the Validate_Enabled exception
464: --
465: if p_validate then
466: raise hr_api.validate_enabled;
467: end if;
468: --
469: -- Set all output arguments. l_object_version_number now has the new
470: -- object version number as the update was successful
472: p_object_version_number := l_object_version_number;
473: --
474: hr_utility.set_location(' Leaving:'||l_proc, 11);
475: exception
476: when hr_api.validate_enabled then
477: --
478: -- As the Validate_Enabled exception has been raised
479: -- we must rollback to the savepoint
480: --
534: p_assessment_id => p_assessment_id
535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'delete_assessment',
541: p_hook_type => 'BP'
542: );
535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'delete_assessment',
541: p_hook_type => 'BP'
542: );
543: end;
568: p_assessment_id => p_assessment_id
569: ,p_object_version_number => p_object_version_number
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'delete_assessment',
575: p_hook_type => 'AP'
576: );
569: ,p_object_version_number => p_object_version_number
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'delete_assessment',
575: p_hook_type => 'AP'
576: );
577: end;
580: --
581: -- When in validation only mode raise the Validate_Enabled exception
582: --
583: if p_validate then
584: raise hr_api.validate_enabled;
585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 11);
588: exception
585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 11);
588: exception
589: when hr_api.validate_enabled then
590: --
591: -- As the Validate_Enabled exception has been raised
592: -- we must rollback to the savepoint
593: --