8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_appraisal >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_appraisal
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_appraisal_template_id in number
16: ,p_appraisee_person_id in number
105: --
106: -- Convert constant values to their corresponding boolean value
107: --
108: l_validate :=
109: hr_api.constant_to_boolean
110: (p_constant_value => p_validate);
111: --
112: -- Register Surrogate ID or user key values
113: --
241: -- ----------------------------------------------------------------------------
242: -- |---------------------------< delete_appraisal >---------------------------|
243: -- ----------------------------------------------------------------------------
244: PROCEDURE delete_appraisal
245: (p_validate in number default hr_api.g_false_num
246: ,p_appraisal_id in number
247: ,p_object_version_number in number
248: ,p_return_status out nocopy varchar2
249: ) is
284: --
285: -- Convert constant values to their corresponding boolean value
286: --
287: l_validate :=
288: hr_api.constant_to_boolean
289: (p_constant_value => p_validate);
290:
291:
292: open cs_apr_status;
396: -- ----------------------------------------------------------------------------
397: -- |---------------------------< update_appraisal >---------------------------|
398: -- ----------------------------------------------------------------------------
399: PROCEDURE update_appraisal
400: (p_validate in number default hr_api.g_false_num
401: ,p_effective_date in date
402: ,p_appraisal_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_appraiser_person_id in number default hr_api.g_number
400: (p_validate in number default hr_api.g_false_num
401: ,p_effective_date in date
402: ,p_appraisal_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_appraiser_person_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
401: ,p_effective_date in date
402: ,p_appraisal_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_appraiser_person_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
402: ,p_appraisal_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_appraiser_person_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
403: ,p_object_version_number in out nocopy number
404: ,p_appraiser_person_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
404: ,p_appraiser_person_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
405: ,p_appraisal_date in date default hr_api.g_date
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
406: ,p_appraisal_period_end_date in date default hr_api.g_date
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_appraisal_period_start_date in date default hr_api.g_date
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_type in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_next_appraisal_date in date default hr_api.g_date
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_status in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_comments in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_overall_performance_level_id in number default hr_api.g_number
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_open in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_attribute_category in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_attribute1 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_attribute2 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_attribute3 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_attribute4 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_attribute5 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_attribute6 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_attribute7 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_attribute8 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_attribute9 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_attribute10 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_attribute11 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_attribute12 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_attribute13 in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
428: ,p_attribute14 in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
429: ,p_attribute15 in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
430: ,p_attribute16 in varchar2 default hr_api.g_varchar2
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
431: ,p_attribute17 in varchar2 default hr_api.g_varchar2
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
432: ,p_attribute18 in varchar2 default hr_api.g_varchar2
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
433: ,p_attribute19 in varchar2 default hr_api.g_varchar2
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
434: ,p_attribute20 in varchar2 default hr_api.g_varchar2
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
435: ,p_system_type in varchar2 default hr_api.g_varchar2
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
436: ,p_system_params in varchar2 default hr_api.g_varchar2
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
437: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
438: ,p_main_appraiser_id in number default hr_api.g_number
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
439: ,p_assignment_id in number default hr_api.g_number
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
440: ,p_assignment_start_date in date default hr_api.g_date
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
441: ,p_asg_business_group_id in number default hr_api.g_number
442: ,p_assignment_organization_id in number default hr_api.g_number
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
443: ,p_assignment_job_id in number default hr_api.g_number
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
444: ,p_assignment_position_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
445: ,p_assignment_grade_id in number default hr_api.g_number
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
446: ,p_return_status out nocopy varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
447: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
448: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
449: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
450: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
451: ,p_potential_details in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
452: ,p_event_id in number default hr_api.g_number
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
453: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
454: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
455: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
456: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
464: ,p_offline_status in varchar2 default hr_api.g_varchar2
457: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
464: ,p_offline_status in varchar2 default hr_api.g_varchar2
465: ) is
458: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
464: ,p_offline_status in varchar2 default hr_api.g_varchar2
465: ) is
466: --
459: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
464: ,p_offline_status in varchar2 default hr_api.g_varchar2
465: ) is
466: --
467: -- Variables for API Boolean parameters
460: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
461: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
462: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
463: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
464: ,p_offline_status in varchar2 default hr_api.g_varchar2
465: ) is
466: --
467: -- Variables for API Boolean parameters
468: l_validate boolean;
489: --
490: -- Convert constant values to their corresponding boolean value
491: --
492: l_validate :=
493: hr_api.constant_to_boolean
494: (p_constant_value => p_validate);
495: --
496: -- Register Surrogate ID or user key values
497: --
621:
622: Procedure process_api
623: (p_document in CLOB
624: ,p_return_status out nocopy VARCHAR2
625: ,p_validate in number default hr_api.g_false_num
626: ,p_effective_date in date default null
627: )
628: IS
629: l_postState VARCHAR2(2);