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 373: ,p_person_type_id in number default hr_api.g_number

369: ,p_period_of_service_id in number
370: ,p_object_version_number in out nocopy number
371: ,p_actual_termination_date in date
372: ,p_last_standard_process_date in out nocopy date
373: ,p_person_type_id in number default hr_api.g_number
374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 374: ,p_assignment_status_type_id in number default hr_api.g_number

370: ,p_object_version_number in out nocopy number
371: ,p_actual_termination_date in date
372: ,p_last_standard_process_date in out nocopy date
373: ,p_person_type_id in number default hr_api.g_number
374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number

Line 375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

371: ,p_actual_termination_date in date
372: ,p_last_standard_process_date in out nocopy date
373: ,p_person_type_id in number default hr_api.g_number
374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date

Line 376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

372: ,p_last_standard_process_date in out nocopy date
373: ,p_person_type_id in number default hr_api.g_number
374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2

Line 377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

373: ,p_person_type_id in number default hr_api.g_number
374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date

Line 378: ,p_termination_accepted_person in number default hr_api.g_number

374: ,p_assignment_status_type_id in number default hr_api.g_number
375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date

Line 379: ,p_accepted_termination_date in date default hr_api.g_date

375: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date

Line 380: ,p_comments in varchar2 default hr_api.g_varchar2

376: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 381: ,p_notified_termination_date in date default hr_api.g_date

377: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 382: ,p_projected_termination_date in date default hr_api.g_date

378: ,p_termination_accepted_person in number default hr_api.g_number
379: ,p_accepted_termination_date in date default hr_api.g_date
380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 384: ,p_attribute_category in varchar2 default hr_api.g_varchar2

380: ,p_comments in varchar2 default hr_api.g_varchar2
381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 385: ,p_attribute1 in varchar2 default hr_api.g_varchar2

381: ,p_notified_termination_date in date default hr_api.g_date
382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 386: ,p_attribute2 in varchar2 default hr_api.g_varchar2

382: ,p_projected_termination_date in date default hr_api.g_date
383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 387: ,p_attribute3 in varchar2 default hr_api.g_varchar2

383: ,p_final_process_date in out nocopy date
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 388: ,p_attribute4 in varchar2 default hr_api.g_varchar2

384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 389: ,p_attribute5 in varchar2 default hr_api.g_varchar2

385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 390: ,p_attribute6 in varchar2 default hr_api.g_varchar2

386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 391: ,p_attribute7 in varchar2 default hr_api.g_varchar2

387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 392: ,p_attribute8 in varchar2 default hr_api.g_varchar2

388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 393: ,p_attribute9 in varchar2 default hr_api.g_varchar2

389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 394: ,p_attribute10 in varchar2 default hr_api.g_varchar2

390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 395: ,p_attribute11 in varchar2 default hr_api.g_varchar2

391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 396: ,p_attribute12 in varchar2 default hr_api.g_varchar2

392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 397: ,p_attribute13 in varchar2 default hr_api.g_varchar2

393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 398: ,p_attribute14 in varchar2 default hr_api.g_varchar2

394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 399: ,p_attribute15 in varchar2 default hr_api.g_varchar2

395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 400: ,p_attribute16 in varchar2 default hr_api.g_varchar2

396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 401: ,p_attribute17 in varchar2 default hr_api.g_varchar2

397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 402: ,p_attribute18 in varchar2 default hr_api.g_varchar2

398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 403: ,p_attribute19 in varchar2 default hr_api.g_varchar2

399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 404: ,p_attribute20 in varchar2 default hr_api.g_varchar2

400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

405: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

406: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

407: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

408: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

409: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

410: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

411: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

412: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

413: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

414: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

415: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

416: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

417: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

418: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

419: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

420: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

421: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

422: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

423: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

424: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

425: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

426: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

427: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

428: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
436: ,p_supervisor_warning out nocopy number

Line 433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

429: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
436: ,p_supervisor_warning out nocopy number
437: ,p_event_warning out nocopy number

Line 434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

430: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
436: ,p_supervisor_warning out nocopy number
437: ,p_event_warning out nocopy number
438: ,p_interview_warning out nocopy number

Line 435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

431: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
432: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
433: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
434: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
435: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
436: ,p_supervisor_warning out nocopy number
437: ,p_event_warning out nocopy number
438: ,p_interview_warning out nocopy number
439: ,p_review_warning out nocopy number

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

526:
527: hr_utility.trace('checking FR legislation ' || l_proc);
528: --
529: l_legislation_code :=
530: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
531: --
532: if l_legislation_code = 'FR' then
533: if p_actual_termination_date is not null and
534: (p_pds_information10 = hr_api.g_varchar2

Line 534: (p_pds_information10 = hr_api.g_varchar2

530: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
531: --
532: if l_legislation_code = 'FR' then
533: if p_actual_termination_date is not null and
534: (p_pds_information10 = hr_api.g_varchar2
535: or p_pds_information10 is null ) then
536: l_pds_information10
537: := fnd_date.date_to_canonical(p_actual_termination_date);
538: l_pds_information_category := l_legislation_code;

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

651: hr_java_conv_util_ss.get_number(p_boolean => lb_dod_warning);
652:
653: -- Bug 2098595 Fix Ends
654: --
655: -- Core HR API will not support update of field Rehire Recommendation
656: -- and Rehire Reason. Hence we make following call to Person API
657: -- to update the Fields.
658: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
659: -- moved cursor definitions to new procedure , which can be called from

Line 763: ,p_termination_accepted_person in number default hr_api.g_number

759: PROCEDURE update_pds_details
760: (p_validate in number default 0
761: ,p_effective_date in date
762: ,p_period_of_service_id in number
763: ,p_termination_accepted_person in number default hr_api.g_number
764: ,p_accepted_termination_date in date default hr_api.g_date
765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 764: ,p_accepted_termination_date in date default hr_api.g_date

760: (p_validate in number default 0
761: ,p_effective_date in date
762: ,p_period_of_service_id in number
763: ,p_termination_accepted_person in number default hr_api.g_number
764: ,p_accepted_termination_date in date default hr_api.g_date
765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date

Line 766: ,p_comments in varchar2 default hr_api.g_varchar2

762: ,p_period_of_service_id in number
763: ,p_termination_accepted_person in number default hr_api.g_number
764: ,p_accepted_termination_date in date default hr_api.g_date
765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

763: ,p_termination_accepted_person in number default hr_api.g_number
764: ,p_accepted_termination_date in date default hr_api.g_date
765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 768: ,p_notified_termination_date in date default hr_api.g_date

764: ,p_accepted_termination_date in date default hr_api.g_date
765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 769: ,p_projected_termination_date in date default hr_api.g_date

765: ,p_object_version_number in out nocopy number
766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute_category in varchar2 default hr_api.g_varchar2

766: ,p_comments in varchar2 default hr_api.g_varchar2
767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute1 in varchar2 default hr_api.g_varchar2

767: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute2 in varchar2 default hr_api.g_varchar2

768: ,p_notified_termination_date in date default hr_api.g_date
769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 773: ,p_attribute3 in varchar2 default hr_api.g_varchar2

769: ,p_projected_termination_date in date default hr_api.g_date
770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 774: ,p_attribute4 in varchar2 default hr_api.g_varchar2

770: ,p_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 775: ,p_attribute5 in varchar2 default hr_api.g_varchar2

771: ,p_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 776: ,p_attribute6 in varchar2 default hr_api.g_varchar2

772: ,p_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 777: ,p_attribute7 in varchar2 default hr_api.g_varchar2

773: ,p_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 778: ,p_attribute8 in varchar2 default hr_api.g_varchar2

774: ,p_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 779: ,p_attribute9 in varchar2 default hr_api.g_varchar2

775: ,p_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute10 in varchar2 default hr_api.g_varchar2

776: ,p_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 781: ,p_attribute11 in varchar2 default hr_api.g_varchar2

777: ,p_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 782: ,p_attribute12 in varchar2 default hr_api.g_varchar2

778: ,p_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 783: ,p_attribute13 in varchar2 default hr_api.g_varchar2

779: ,p_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 784: ,p_attribute14 in varchar2 default hr_api.g_varchar2

780: ,p_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 785: ,p_attribute15 in varchar2 default hr_api.g_varchar2

781: ,p_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 786: ,p_attribute16 in varchar2 default hr_api.g_varchar2

782: ,p_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute17 in varchar2 default hr_api.g_varchar2

783: ,p_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute18 in varchar2 default hr_api.g_varchar2

784: ,p_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 789: ,p_attribute19 in varchar2 default hr_api.g_varchar2

785: ,p_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 790: ,p_attribute20 in varchar2 default hr_api.g_varchar2

786: ,p_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

787: ,p_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

788: ,p_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

789: ,p_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

790: ,p_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

791: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

792: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

793: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

794: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

795: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

796: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

797: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

798: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

799: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

800: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

801: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

802: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

803: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

804: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

805: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

806: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

807: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

808: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

809: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

810: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

811: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

812: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

813: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

814: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
822: )

Line 819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

815: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
822: )
823: IS

Line 820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

816: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
822: )
823: IS
824: l_proc constant varchar2(100) := g_package || ' update_pds_details';

Line 821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

817: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
818: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
819: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
820: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
821: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
822: )
823: IS
824: l_proc constant varchar2(100) := g_package || ' update_pds_details';
825: BEGIN

Line 935: ,p_effective_date in varchar2 default hr_api.g_varchar2

931: PROCEDURE process_save
932: (p_item_type in wf_items.item_type%TYPE
933: ,p_item_key in wf_items.item_key%TYPE
934: ,p_actid in varchar2
935: ,p_effective_date in varchar2 default hr_api.g_varchar2
936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2

Line 936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2

932: (p_item_type in wf_items.item_type%TYPE
933: ,p_item_key in wf_items.item_key%TYPE
934: ,p_actid in varchar2
935: ,p_effective_date in varchar2 default hr_api.g_varchar2
936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 937: ,p_object_version_number in varchar2 default hr_api.g_varchar2

933: ,p_item_key in wf_items.item_key%TYPE
934: ,p_actid in varchar2
935: ,p_effective_date in varchar2 default hr_api.g_varchar2
936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2

Line 938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2

934: ,p_actid in varchar2
935: ,p_effective_date in varchar2 default hr_api.g_varchar2
936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number

Line 939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2

935: ,p_effective_date in varchar2 default hr_api.g_varchar2
936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number
943: ,p_person_id in number

Line 940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

936: ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number
943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 941: ,p_comments in varchar2 default hr_api.g_varchar2

937: ,p_object_version_number in varchar2 default hr_api.g_varchar2
938: ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
939: ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number
943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 944: ,p_attribute_category in varchar2 default hr_api.g_varchar2

940: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number
943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 945: ,p_attribute1 in varchar2 default hr_api.g_varchar2

941: ,p_comments in varchar2 default hr_api.g_varchar2
942: ,p_login_person_id in number
943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 946: ,p_attribute2 in varchar2 default hr_api.g_varchar2

942: ,p_login_person_id in number
943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 947: ,p_attribute3 in varchar2 default hr_api.g_varchar2

943: ,p_person_id in number
944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 948: ,p_attribute4 in varchar2 default hr_api.g_varchar2

944: ,p_attribute_category in varchar2 default hr_api.g_varchar2
945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 949: ,p_attribute5 in varchar2 default hr_api.g_varchar2

945: ,p_attribute1 in varchar2 default hr_api.g_varchar2
946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 950: ,p_attribute6 in varchar2 default hr_api.g_varchar2

946: ,p_attribute2 in varchar2 default hr_api.g_varchar2
947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 951: ,p_attribute7 in varchar2 default hr_api.g_varchar2

947: ,p_attribute3 in varchar2 default hr_api.g_varchar2
948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 952: ,p_attribute8 in varchar2 default hr_api.g_varchar2

948: ,p_attribute4 in varchar2 default hr_api.g_varchar2
949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 953: ,p_attribute9 in varchar2 default hr_api.g_varchar2

949: ,p_attribute5 in varchar2 default hr_api.g_varchar2
950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 954: ,p_attribute10 in varchar2 default hr_api.g_varchar2

950: ,p_attribute6 in varchar2 default hr_api.g_varchar2
951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 955: ,p_attribute11 in varchar2 default hr_api.g_varchar2

951: ,p_attribute7 in varchar2 default hr_api.g_varchar2
952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 956: ,p_attribute12 in varchar2 default hr_api.g_varchar2

952: ,p_attribute8 in varchar2 default hr_api.g_varchar2
953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 957: ,p_attribute13 in varchar2 default hr_api.g_varchar2

953: ,p_attribute9 in varchar2 default hr_api.g_varchar2
954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 958: ,p_attribute14 in varchar2 default hr_api.g_varchar2

954: ,p_attribute10 in varchar2 default hr_api.g_varchar2
955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 959: ,p_attribute15 in varchar2 default hr_api.g_varchar2

955: ,p_attribute11 in varchar2 default hr_api.g_varchar2
956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 960: ,p_attribute16 in varchar2 default hr_api.g_varchar2

956: ,p_attribute12 in varchar2 default hr_api.g_varchar2
957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 961: ,p_attribute17 in varchar2 default hr_api.g_varchar2

957: ,p_attribute13 in varchar2 default hr_api.g_varchar2
958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2

Line 962: ,p_attribute18 in varchar2 default hr_api.g_varchar2

958: ,p_attribute14 in varchar2 default hr_api.g_varchar2
959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

Line 963: ,p_attribute19 in varchar2 default hr_api.g_varchar2

959: ,p_attribute15 in varchar2 default hr_api.g_varchar2
960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

Line 964: ,p_attribute20 in varchar2 default hr_api.g_varchar2

960: ,p_attribute16 in varchar2 default hr_api.g_varchar2
961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

Line 965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2

961: ,p_attribute17 in varchar2 default hr_api.g_varchar2
962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

Line 966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2

962: ,p_attribute18 in varchar2 default hr_api.g_varchar2
963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

Line 967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2

963: ,p_attribute19 in varchar2 default hr_api.g_varchar2
964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

Line 968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2

964: ,p_attribute20 in varchar2 default hr_api.g_varchar2
965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

Line 969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2

965: ,p_review_proc_call in varchar2 default hr_api.g_varchar2
966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

Line 970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2

966: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

Line 971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2

967: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

Line 972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2

968: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

Line 973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2

969: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

Line 974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2

970: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

Line 975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2

971: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

Line 976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2

972: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

Line 977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2

973: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

Line 978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2

974: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

Line 979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2

975: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

Line 980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2

976: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

Line 981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2

977: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

Line 982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2

978: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

Line 983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2

979: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

Line 984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2

980: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

Line 985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2

981: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

Line 986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2

982: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

Line 987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2

983: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

Line 988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2

984: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

Line 989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2

985: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

Line 990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2

986: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

Line 991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2

987: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

Line 992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2

988: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

Line 993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2

989: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number

Line 994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2

990: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number

Line 995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2

991: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

Line 996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2

992: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 997: ,p_person_type_id in number default hr_api.g_number

993: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 998: ,p_assignment_status_type_id in number default hr_api.g_number

994: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2

Line 999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

995: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2

Line 1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

996: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2

Line 1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

997: ,p_person_type_id in number default hr_api.g_number
998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1005: )

Line 1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2

998: ,p_assignment_status_type_id in number default hr_api.g_number
999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1005: )
1006:

Line 1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2

999: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1005: )
1006:
1007: IS

Line 1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2

1000: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1001: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1002: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1003: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1004: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1005: )
1006:
1007: IS
1008:

Line 1013: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

1009: li_count INTEGER ;
1010: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
1011: ln_transaction_id NUMBER;
1012: lv_result VARCHAR2(100);
1013: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1014: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1015: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;
1016: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
1017: ln_trans_step_rows NUMBER default 0;

Line 1015: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;

1011: ln_transaction_id NUMBER;
1012: lv_result VARCHAR2(100);
1013: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1014: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1015: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE;
1016: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
1017: ln_trans_step_rows NUMBER default 0;
1018: ln_supervisor_count NUMBER;
1019: l_proc constant varchar2(100) := g_package || ' process_save';

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

1871: from per_periods_of_service
1872: where period_of_service_id = ln_period_of_service_id;
1873: --
1874: l_legislation_code :=
1875: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
1876: --
1877: if l_legislation_code = 'FR' then
1878: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
1879: if ld_actual_term_date is not null and

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

1876: --
1877: if l_legislation_code = 'FR' then
1878: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
1879: if ld_actual_term_date is not null and
1880: (lt_term_flex(30) = hr_api.g_varchar2
1881: or lt_term_flex(30) is null ) then
1882: lt_term_flex(30)
1883: := fnd_date.date_to_canonical(ld_actual_term_date);
1884: lv_pds_information_category := l_legislation_code;

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

1994: );
1995:
1996: -- Bug 2098595 Fix Ends
1997: --
1998: -- Core HR API will not support update of field Rehire Recommendation
1999: -- and Rehire Reason. Hence we make following call to Person API
2000: -- to update the Fields.
2001: update_per_details(
2002: p_validate => 0, -- false

Line 2050: hr_api_transaction_steps.transaction_step_id%type

2046: ||=======================================================================
2047: */
2048: FUNCTION get_termination_details (
2049: p_transaction_step_id IN
2050: hr_api_transaction_steps.transaction_step_id%type
2051: )
2052: RETURN hr_termination_ss.rt_termination
2053: IS
2054: lrt_termination hr_termination_ss.rt_termination;

Line 2152: hr_api_transaction_steps.transaction_step_id%type

2148: ||=======================================================================
2149: */
2150: FUNCTION get_term_flex_detail (
2151: p_transaction_step_id IN
2152: hr_api_transaction_steps.transaction_step_id%type
2153: )
2154: RETURN hr_termination_ss.t_flex_table
2155: IS
2156: lt_term_flex hr_termination_ss.t_flex_table;