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

APPS.HR_APPRAISALS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 111: hr_api.constant_to_boolean

107: --
108: -- Convert constant values to their corresponding boolean value
109: --
110: l_validate :=
111: hr_api.constant_to_boolean
112: (p_constant_value => p_validate);
113: --
114: -- Register Surrogate ID or user key values
115: --

Line 249: (p_validate in number default hr_api.g_false_num

245: -- ----------------------------------------------------------------------------
246: -- |---------------------------< delete_appraisal >---------------------------|
247: -- ----------------------------------------------------------------------------
248: PROCEDURE delete_appraisal
249: (p_validate in number default hr_api.g_false_num
250: ,p_appraisal_id in number
251: ,p_object_version_number in number
252: ,p_return_status out nocopy varchar2
253: ) is

Line 292: hr_api.constant_to_boolean

288: --
289: -- Convert constant values to their corresponding boolean value
290: --
291: l_validate :=
292: hr_api.constant_to_boolean
293: (p_constant_value => p_validate);
294:
295:
296: open cs_apr_status;

Line 404: (p_validate in number default hr_api.g_false_num

400: -- ----------------------------------------------------------------------------
401: -- |---------------------------< update_appraisal >---------------------------|
402: -- ----------------------------------------------------------------------------
403: PROCEDURE update_appraisal
404: (p_validate in number default hr_api.g_false_num
405: ,p_effective_date in date
406: ,p_appraisal_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_appraiser_person_id in number default hr_api.g_number

Line 408: ,p_appraiser_person_id in number default hr_api.g_number

404: (p_validate in number default hr_api.g_false_num
405: ,p_effective_date in date
406: ,p_appraisal_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_appraiser_person_id in number default hr_api.g_number
409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2

Line 409: ,p_appraisal_date in date default hr_api.g_date

405: ,p_effective_date in date
406: ,p_appraisal_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_appraiser_person_id in number default hr_api.g_number
409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date

Line 410: ,p_appraisal_period_end_date in date default hr_api.g_date

406: ,p_appraisal_id in number
407: ,p_object_version_number in out nocopy number
408: ,p_appraiser_person_id in number default hr_api.g_number
409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2

Line 411: ,p_appraisal_period_start_date in date default hr_api.g_date

407: ,p_object_version_number in out nocopy number
408: ,p_appraiser_person_id in number default hr_api.g_number
409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2

Line 412: ,p_type in varchar2 default hr_api.g_varchar2

408: ,p_appraiser_person_id in number default hr_api.g_number
409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number

Line 413: ,p_next_appraisal_date in date default hr_api.g_date

409: ,p_appraisal_date in date default hr_api.g_date
410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2

Line 414: ,p_status in varchar2 default hr_api.g_varchar2

410: ,p_appraisal_period_end_date in date default hr_api.g_date
411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 415: ,p_comments in varchar2 default hr_api.g_varchar2

411: ,p_appraisal_period_start_date in date default hr_api.g_date
412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 416: ,p_overall_performance_level_id in number default hr_api.g_number

412: ,p_type in varchar2 default hr_api.g_varchar2
413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 417: ,p_open in varchar2 default hr_api.g_varchar2

413: ,p_next_appraisal_date in date default hr_api.g_date
414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 418: ,p_attribute_category in varchar2 default hr_api.g_varchar2

414: ,p_status in varchar2 default hr_api.g_varchar2
415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 419: ,p_attribute1 in varchar2 default hr_api.g_varchar2

415: ,p_comments in varchar2 default hr_api.g_varchar2
416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 420: ,p_attribute2 in varchar2 default hr_api.g_varchar2

416: ,p_overall_performance_level_id in number default hr_api.g_number
417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 421: ,p_attribute3 in varchar2 default hr_api.g_varchar2

417: ,p_open in varchar2 default hr_api.g_varchar2
418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 422: ,p_attribute4 in varchar2 default hr_api.g_varchar2

418: ,p_attribute_category in varchar2 default hr_api.g_varchar2
419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 423: ,p_attribute5 in varchar2 default hr_api.g_varchar2

419: ,p_attribute1 in varchar2 default hr_api.g_varchar2
420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 424: ,p_attribute6 in varchar2 default hr_api.g_varchar2

420: ,p_attribute2 in varchar2 default hr_api.g_varchar2
421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 425: ,p_attribute7 in varchar2 default hr_api.g_varchar2

421: ,p_attribute3 in varchar2 default hr_api.g_varchar2
422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 426: ,p_attribute8 in varchar2 default hr_api.g_varchar2

422: ,p_attribute4 in varchar2 default hr_api.g_varchar2
423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 427: ,p_attribute9 in varchar2 default hr_api.g_varchar2

423: ,p_attribute5 in varchar2 default hr_api.g_varchar2
424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 428: ,p_attribute10 in varchar2 default hr_api.g_varchar2

424: ,p_attribute6 in varchar2 default hr_api.g_varchar2
425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 429: ,p_attribute11 in varchar2 default hr_api.g_varchar2

425: ,p_attribute7 in varchar2 default hr_api.g_varchar2
426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 430: ,p_attribute12 in varchar2 default hr_api.g_varchar2

426: ,p_attribute8 in varchar2 default hr_api.g_varchar2
427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 431: ,p_attribute13 in varchar2 default hr_api.g_varchar2

427: ,p_attribute9 in varchar2 default hr_api.g_varchar2
428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 432: ,p_attribute14 in varchar2 default hr_api.g_varchar2

428: ,p_attribute10 in varchar2 default hr_api.g_varchar2
429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 433: ,p_attribute15 in varchar2 default hr_api.g_varchar2

429: ,p_attribute11 in varchar2 default hr_api.g_varchar2
430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 434: ,p_attribute16 in varchar2 default hr_api.g_varchar2

430: ,p_attribute12 in varchar2 default hr_api.g_varchar2
431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 435: ,p_attribute17 in varchar2 default hr_api.g_varchar2

431: ,p_attribute13 in varchar2 default hr_api.g_varchar2
432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2

Line 436: ,p_attribute18 in varchar2 default hr_api.g_varchar2

432: ,p_attribute14 in varchar2 default hr_api.g_varchar2
433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2

Line 437: ,p_attribute19 in varchar2 default hr_api.g_varchar2

433: ,p_attribute15 in varchar2 default hr_api.g_varchar2
434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2

Line 438: ,p_attribute20 in varchar2 default hr_api.g_varchar2

434: ,p_attribute16 in varchar2 default hr_api.g_varchar2
435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number

Line 439: ,p_system_type in varchar2 default hr_api.g_varchar2

435: ,p_attribute17 in varchar2 default hr_api.g_varchar2
436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number

Line 440: ,p_system_params in varchar2 default hr_api.g_varchar2

436: ,p_attribute18 in varchar2 default hr_api.g_varchar2
437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date

Line 441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2

437: ,p_attribute19 in varchar2 default hr_api.g_varchar2
438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number

Line 442: ,p_main_appraiser_id in number default hr_api.g_number

438: ,p_attribute20 in varchar2 default hr_api.g_varchar2
439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number

Line 443: ,p_assignment_id in number default hr_api.g_number

439: ,p_system_type in varchar2 default hr_api.g_varchar2
440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number

Line 444: ,p_assignment_start_date in date default hr_api.g_date

440: ,p_system_params in varchar2 default hr_api.g_varchar2
441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number

Line 445: ,p_asg_business_group_id in number default hr_api.g_number

441: ,p_appraisee_access in varchar2 default hr_api.g_varchar2
442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number

Line 446: ,p_assignment_organization_id in number default hr_api.g_number

442: ,p_main_appraiser_id in number default hr_api.g_number
443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2

Line 447: ,p_assignment_job_id in number default hr_api.g_number

443: ,p_assignment_id in number default hr_api.g_number
444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2

Line 448: ,p_assignment_position_id in number default hr_api.g_number

444: ,p_assignment_start_date in date default hr_api.g_date
445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2

Line 449: ,p_assignment_grade_id in number default hr_api.g_number

445: ,p_asg_business_group_id in number default hr_api.g_number
446: ,p_assignment_organization_id in number default hr_api.g_number
447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2

Line 451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2

447: ,p_assignment_job_id in number default hr_api.g_number
448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2

Line 452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2

448: ,p_assignment_position_id in number default hr_api.g_number
449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number

Line 453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2

449: ,p_assignment_grade_id in number default hr_api.g_number
450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

Line 454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2

450: ,p_return_status out nocopy varchar2
451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

Line 455: ,p_potential_details in varchar2 default hr_api.g_varchar2

451: ,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

Line 456: ,p_event_id in number default hr_api.g_number

452: ,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

Line 457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

453: ,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

Line 458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

454: ,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

Line 459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

455: ,p_potential_details in varchar2 default hr_api.g_varchar2
456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

Line 460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

456: ,p_event_id in number default hr_api.g_number
457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

Line 461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

457: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2

Line 462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

458: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

Line 463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

459: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2

Line 464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2

Line 465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2

461: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2

Line 466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

462: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2
470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix

Line 467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2

463: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2
470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
471: ) is

Line 468: ,p_offline_status in varchar2 default hr_api.g_varchar2

464: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2
470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
471: ) is
472: --

Line 469: ,p_retention_potential in varchar2 default hr_api.g_varchar2

465: ,p_update_appraisal in varchar2 default hr_api.g_varchar2
466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2
470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
471: ) is
472: --
473: -- Variables for API Boolean parameters

Line 470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix

466: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
467: ,p_appraisee_comments in varchar2 default hr_api.g_varchar2
468: ,p_offline_status in varchar2 default hr_api.g_varchar2
469: ,p_retention_potential in varchar2 default hr_api.g_varchar2
470: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
471: ) is
472: --
473: -- Variables for API Boolean parameters
474: l_validate boolean;

Line 499: hr_api.constant_to_boolean

495: --
496: -- Convert constant values to their corresponding boolean value
497: --
498: l_validate :=
499: hr_api.constant_to_boolean
500: (p_constant_value => p_validate);
501: --
502: -- Register Surrogate ID or user key values
503: --

Line 632: ,p_validate in number default hr_api.g_false_num

628:
629: Procedure process_api
630: (p_document in CLOB
631: ,p_return_status out nocopy VARCHAR2
632: ,p_validate in number default hr_api.g_false_num
633: ,p_effective_date in date default null
634: )
635: IS
636: l_postState VARCHAR2(2);