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_TERMINATION_SS dependencies on HR_API

Line 65: -- Core HR API will not support update of field Rehire Recommendation

61: END update_object_version;
62:
63: -- Bug 2098595 Fix Ends
64: --
65: -- Core HR API will not support update of field Rehire Recommendation
66: -- and Rehire Reason. Hence we make following call to Person API
67: -- to update the Fields.
68: PROCEDURE update_per_details(
69: p_validate in number default 0

Line 73: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

69: p_validate in number default 0
70: ,p_effective_date in date
71: ,p_period_of_service_id in number
72: ,p_actual_termination_date in date
73: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
74: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
75: ) IS
76:
77: l_person_id per_all_people_f.person_id%TYPE;

Line 74: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

70: ,p_effective_date in date
71: ,p_period_of_service_id in number
72: ,p_actual_termination_date in date
73: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
74: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
75: ) IS
76:
77: l_person_id per_all_people_f.person_id%TYPE;
78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

Line 161: hr_api_transaction_steps.transaction_step_id%type

157: ||=======================================================================
158: */
159: FUNCTION get_termination_details (
160: p_transaction_step_id IN
161: hr_api_transaction_steps.transaction_step_id%type
162: )
163: RETURN hr_termination_ss.rt_termination;
164:
165: /*

Line 174: hr_api_transaction_steps.transaction_step_id%type

170: ||=======================================================================
171: */
172: FUNCTION get_term_flex_detail (
173: p_transaction_step_id IN
174: hr_api_transaction_steps.transaction_step_id%type
175: )
176: RETURN hr_termination_ss.t_flex_table;
177:
178: /*

Line 421: ,p_person_type_id in number default hr_api.g_number

417: ,p_period_of_service_id in number
418: ,p_object_version_number in out nocopy number
419: ,p_actual_termination_date in date
420: ,p_last_standard_process_date in out nocopy date
421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 422: ,p_assignment_status_type_id in number default hr_api.g_number

418: ,p_object_version_number in out nocopy number
419: ,p_actual_termination_date in date
420: ,p_last_standard_process_date in out nocopy date
421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number

Line 423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

419: ,p_actual_termination_date in date
420: ,p_last_standard_process_date in out nocopy date
421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date

Line 424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

420: ,p_last_standard_process_date in out nocopy date
421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2

Line 425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date

Line 426: ,p_termination_accepted_person in number default hr_api.g_number

422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date

Line 427: ,p_accepted_termination_date in date default hr_api.g_date

423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date

Line 428: ,p_comments in varchar2 default hr_api.g_varchar2

424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 429: ,p_notified_termination_date in date default hr_api.g_date

425: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 430: ,p_projected_termination_date in date default hr_api.g_date

426: ,p_termination_accepted_person in number default hr_api.g_number
427: ,p_accepted_termination_date in date default hr_api.g_date
428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 432: ,p_attribute_category in varchar2 default hr_api.g_varchar2

428: ,p_comments in varchar2 default hr_api.g_varchar2
429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 433: ,p_attribute1 in varchar2 default hr_api.g_varchar2

429: ,p_notified_termination_date in date default hr_api.g_date
430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 434: ,p_attribute2 in varchar2 default hr_api.g_varchar2

430: ,p_projected_termination_date in date default hr_api.g_date
431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 435: ,p_attribute3 in varchar2 default hr_api.g_varchar2

431: ,p_final_process_date in out nocopy date
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 436: ,p_attribute4 in varchar2 default hr_api.g_varchar2

432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 437: ,p_attribute5 in varchar2 default hr_api.g_varchar2

433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 438: ,p_attribute6 in varchar2 default hr_api.g_varchar2

434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 439: ,p_attribute7 in varchar2 default hr_api.g_varchar2

435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 440: ,p_attribute8 in varchar2 default hr_api.g_varchar2

436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 441: ,p_attribute9 in varchar2 default hr_api.g_varchar2

437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 442: ,p_attribute10 in varchar2 default hr_api.g_varchar2

438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 443: ,p_attribute11 in varchar2 default hr_api.g_varchar2

439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 444: ,p_attribute12 in varchar2 default hr_api.g_varchar2

440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 445: ,p_attribute13 in varchar2 default hr_api.g_varchar2

441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 446: ,p_attribute14 in varchar2 default hr_api.g_varchar2

442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 447: ,p_attribute15 in varchar2 default hr_api.g_varchar2

443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 448: ,p_attribute16 in varchar2 default hr_api.g_varchar2

444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 449: ,p_attribute17 in varchar2 default hr_api.g_varchar2

445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 450: ,p_attribute18 in varchar2 default hr_api.g_varchar2

446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 451: ,p_attribute19 in varchar2 default hr_api.g_varchar2

447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 452: ,p_attribute20 in varchar2 default hr_api.g_varchar2

448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

453: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

454: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

455: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

456: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

457: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

458: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

459: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

460: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

461: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

462: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

463: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

464: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

465: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

466: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

467: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

468: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

469: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

470: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

471: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

472: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

473: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

474: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

475: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

476: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
484: ,p_supervisor_warning out nocopy number

Line 481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

477: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
484: ,p_supervisor_warning out nocopy number
485: ,p_event_warning out nocopy number

Line 482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

478: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
484: ,p_supervisor_warning out nocopy number
485: ,p_event_warning out nocopy number
486: ,p_interview_warning out nocopy number

Line 483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

479: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
480: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
481: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
482: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
483: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
484: ,p_supervisor_warning out nocopy number
485: ,p_event_warning out nocopy number
486: ,p_interview_warning out nocopy number
487: ,p_review_warning out nocopy number

Line 578: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);

574:
575: hr_utility.trace('checking FR legislation ' || l_proc);
576: --
577: l_legislation_code :=
578: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
579: --
580: if l_legislation_code = 'FR' then
581: if p_actual_termination_date is not null and
582: (p_pds_information10 = hr_api.g_varchar2

Line 582: (p_pds_information10 = hr_api.g_varchar2

578: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
579: --
580: if l_legislation_code = 'FR' then
581: if p_actual_termination_date is not null and
582: (p_pds_information10 = hr_api.g_varchar2
583: or p_pds_information10 is null ) then
584: l_pds_information10
585: := fnd_date.date_to_canonical(p_actual_termination_date);
586: l_pds_information_category := l_legislation_code;

Line 662: -- Core HR API will not support update of field Rehire Recommendation

658: -- Moved this piece of code "update rehire" info
659: -- before calling "hr_ex_employee_api.actual_termination_emp"
660:
661:
662: -- Core HR API will not support update of field Rehire Recommendation
663: -- and Rehire Reason. Hence we make following call to Person API
664: -- to update the Fields.
665: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
666: -- moved cursor definitions to new procedure , which can be called from

Line 820: ,p_termination_accepted_person in number default hr_api.g_number

816: PROCEDURE update_pds_details
817: (p_validate in number default 0
818: ,p_effective_date in date
819: ,p_period_of_service_id in number
820: ,p_termination_accepted_person in number default hr_api.g_number
821: ,p_accepted_termination_date in date default hr_api.g_date
822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 821: ,p_accepted_termination_date in date default hr_api.g_date

817: (p_validate in number default 0
818: ,p_effective_date in date
819: ,p_period_of_service_id in number
820: ,p_termination_accepted_person in number default hr_api.g_number
821: ,p_accepted_termination_date in date default hr_api.g_date
822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date

Line 823: ,p_comments in varchar2 default hr_api.g_varchar2

819: ,p_period_of_service_id in number
820: ,p_termination_accepted_person in number default hr_api.g_number
821: ,p_accepted_termination_date in date default hr_api.g_date
822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

820: ,p_termination_accepted_person in number default hr_api.g_number
821: ,p_accepted_termination_date in date default hr_api.g_date
822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 825: ,p_notified_termination_date in date default hr_api.g_date

821: ,p_accepted_termination_date in date default hr_api.g_date
822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 826: ,p_projected_termination_date in date default hr_api.g_date

822: ,p_object_version_number in out nocopy number
823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 827: ,p_attribute_category in varchar2 default hr_api.g_varchar2

823: ,p_comments in varchar2 default hr_api.g_varchar2
824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 828: ,p_attribute1 in varchar2 default hr_api.g_varchar2

824: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 829: ,p_attribute2 in varchar2 default hr_api.g_varchar2

825: ,p_notified_termination_date in date default hr_api.g_date
826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 830: ,p_attribute3 in varchar2 default hr_api.g_varchar2

826: ,p_projected_termination_date in date default hr_api.g_date
827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 831: ,p_attribute4 in varchar2 default hr_api.g_varchar2

827: ,p_attribute_category in varchar2 default hr_api.g_varchar2
828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 832: ,p_attribute5 in varchar2 default hr_api.g_varchar2

828: ,p_attribute1 in varchar2 default hr_api.g_varchar2
829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 833: ,p_attribute6 in varchar2 default hr_api.g_varchar2

829: ,p_attribute2 in varchar2 default hr_api.g_varchar2
830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 834: ,p_attribute7 in varchar2 default hr_api.g_varchar2

830: ,p_attribute3 in varchar2 default hr_api.g_varchar2
831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 835: ,p_attribute8 in varchar2 default hr_api.g_varchar2

831: ,p_attribute4 in varchar2 default hr_api.g_varchar2
832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 836: ,p_attribute9 in varchar2 default hr_api.g_varchar2

832: ,p_attribute5 in varchar2 default hr_api.g_varchar2
833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 837: ,p_attribute10 in varchar2 default hr_api.g_varchar2

833: ,p_attribute6 in varchar2 default hr_api.g_varchar2
834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 838: ,p_attribute11 in varchar2 default hr_api.g_varchar2

834: ,p_attribute7 in varchar2 default hr_api.g_varchar2
835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 839: ,p_attribute12 in varchar2 default hr_api.g_varchar2

835: ,p_attribute8 in varchar2 default hr_api.g_varchar2
836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 840: ,p_attribute13 in varchar2 default hr_api.g_varchar2

836: ,p_attribute9 in varchar2 default hr_api.g_varchar2
837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 841: ,p_attribute14 in varchar2 default hr_api.g_varchar2

837: ,p_attribute10 in varchar2 default hr_api.g_varchar2
838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 842: ,p_attribute15 in varchar2 default hr_api.g_varchar2

838: ,p_attribute11 in varchar2 default hr_api.g_varchar2
839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 843: ,p_attribute16 in varchar2 default hr_api.g_varchar2

839: ,p_attribute12 in varchar2 default hr_api.g_varchar2
840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 844: ,p_attribute17 in varchar2 default hr_api.g_varchar2

840: ,p_attribute13 in varchar2 default hr_api.g_varchar2
841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 845: ,p_attribute18 in varchar2 default hr_api.g_varchar2

841: ,p_attribute14 in varchar2 default hr_api.g_varchar2
842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 846: ,p_attribute19 in varchar2 default hr_api.g_varchar2

842: ,p_attribute15 in varchar2 default hr_api.g_varchar2
843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 847: ,p_attribute20 in varchar2 default hr_api.g_varchar2

843: ,p_attribute16 in varchar2 default hr_api.g_varchar2
844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

844: ,p_attribute17 in varchar2 default hr_api.g_varchar2
845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

845: ,p_attribute18 in varchar2 default hr_api.g_varchar2
846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

846: ,p_attribute19 in varchar2 default hr_api.g_varchar2
847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

847: ,p_attribute20 in varchar2 default hr_api.g_varchar2
848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

848: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

849: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

850: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

851: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

852: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

853: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

854: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

855: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

856: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

857: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

858: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

859: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

860: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

861: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

862: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

863: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

864: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

865: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

866: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

867: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

868: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

869: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

870: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

871: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
879: )

Line 876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

872: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
879: )
880: IS

Line 877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

873: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
879: )
880: IS
881: l_proc constant varchar2(100) := g_package || ' update_pds_details';

Line 878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

874: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
875: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
876: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
877: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
878: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
879: )
880: IS
881: l_proc constant varchar2(100) := g_package || ' update_pds_details';
882: BEGIN

Line 992: ,p_effective_date in varchar2 default hr_api.g_varchar2

988: PROCEDURE process_save
989: (p_item_type in wf_items.item_type%TYPE
990: ,p_item_key in wf_items.item_key%TYPE
991: ,p_actid in varchar2
992: ,p_effective_date in varchar2 default hr_api.g_varchar2
993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2

Line 993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2

989: (p_item_type in wf_items.item_type%TYPE
990: ,p_item_key in wf_items.item_key%TYPE
991: ,p_actid in varchar2
992: ,p_effective_date in varchar2 default hr_api.g_varchar2
993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 994: ,p_object_version_number in varchar2 default hr_api.g_varchar2

990: ,p_item_key in wf_items.item_key%TYPE
991: ,p_actid in varchar2
992: ,p_effective_date in varchar2 default hr_api.g_varchar2
993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2

Line 995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2

991: ,p_actid in varchar2
992: ,p_effective_date in varchar2 default hr_api.g_varchar2
993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number

Line 996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2

992: ,p_effective_date in varchar2 default hr_api.g_varchar2
993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number
1000: ,p_person_id in number

Line 997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

993: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number
1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 998: ,p_comments in varchar2 default hr_api.g_varchar2

994: ,p_object_version_number in varchar2 default hr_api.g_varchar2
995: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
996: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number
1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2

997: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number
1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2

998: ,p_comments in varchar2 default hr_api.g_varchar2
999: ,p_login_person_id in number
1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2

999: ,p_login_person_id in number
1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1000: ,p_person_id in number
1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1001: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1002: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1003: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1004: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1005: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1006: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1007: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1008: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1009: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1010: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1011: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1012: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1013: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1014: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2

Line 1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1015: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1016: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1017: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2

1018: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

1019: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

1020: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

1021: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

1022: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

1023: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

1024: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

1025: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

1026: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

1027: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

1028: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

1029: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

1030: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

1031: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

1032: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

1033: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

1034: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

1035: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

1036: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

1037: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

1038: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

1039: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

1040: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

1041: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

1042: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

1043: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

1044: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

1045: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

1046: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number

Line 1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

1047: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number

Line 1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

1048: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

Line 1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

1049: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 1054: ,p_person_type_id in number default hr_api.g_number

1050: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 1055: ,p_assignment_status_type_id in number default hr_api.g_number

1051: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2

Line 1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

1052: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2

Line 1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

1053: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2

Line 1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

1054: ,p_person_type_id in number default hr_api.g_number
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1062: )

Line 1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2

1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1062: )
1063:

Line 1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2

1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1062: )
1063:
1064: IS

Line 1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2

1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1062: )
1063:
1064: IS
1065:

Line 1070: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

1066: li_count INTEGER ;
1067: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
1068: ln_transaction_id NUMBER;
1069: lv_result VARCHAR2(100);
1070: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1071: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1072: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;
1073: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
1074: ln_trans_step_rows NUMBER default 0;

Line 1072: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;

1068: ln_transaction_id NUMBER;
1069: lv_result VARCHAR2(100);
1070: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1071: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1072: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;
1073: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
1074: ln_trans_step_rows NUMBER default 0;
1075: ln_supervisor_count NUMBER;
1076:

Line 2016: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);

2012: from per_periods_of_service
2013: where period_of_service_id = ln_period_of_service_id;
2014: --
2015: l_legislation_code :=
2016: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
2017: --
2018: if l_legislation_code = 'FR' then
2019: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
2020: if ld_actual_term_date is not null and

Line 2021: (lt_term_flex(30) = hr_api.g_varchar2

2017: --
2018: if l_legislation_code = 'FR' then
2019: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
2020: if ld_actual_term_date is not null and
2021: (lt_term_flex(30) = hr_api.g_varchar2
2022: or lt_term_flex(30) is null ) then
2023: lt_term_flex(30)
2024: := fnd_date.date_to_canonical(ld_actual_term_date);
2025: lv_pds_information_category := l_legislation_code;

Line 2118: -- Core HR API will not support update of field Rehire Recommendation

2114: -- Fix for the bug 13846099 Starts
2115: -- Moved this piece of code "update rehire" info
2116: -- before calling "hr_ex_employee_api.actual_termination_emp"
2117:
2118: -- Core HR API will not support update of field Rehire Recommendation
2119: -- and Rehire Reason. Hence we make following call to Person API
2120: -- to update the Fields.
2121: update_per_details(
2122: p_validate => 0, -- false

Line 2263: hr_api_transaction_steps.transaction_step_id%type

2259: ||=======================================================================
2260: */
2261: FUNCTION get_termination_details (
2262: p_transaction_step_id IN
2263: hr_api_transaction_steps.transaction_step_id%type
2264: )
2265: RETURN hr_termination_ss.rt_termination
2266: IS
2267: lrt_termination hr_termination_ss.rt_termination;

Line 2365: hr_api_transaction_steps.transaction_step_id%type

2361: ||=======================================================================
2362: */
2363: FUNCTION get_term_flex_detail (
2364: p_transaction_step_id IN
2365: hr_api_transaction_steps.transaction_step_id%type
2366: )
2367: RETURN hr_termination_ss.t_flex_table
2368: IS
2369: lt_term_flex hr_termination_ss.t_flex_table;