[Home] [Help]
175: ,p_period_of_service_id in number
176: ,p_object_version_number in out nocopy number
177: ,p_actual_termination_date in date
178: ,p_last_standard_process_date in out nocopy date
179: ,p_person_type_id in number default hr_api.g_number
180: ,p_assignment_status_type_id in number default hr_api.g_number
181: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
182: ,p_supervisor_warning out nocopy boolean
183: ,p_event_warning out nocopy boolean
176: ,p_object_version_number in out nocopy number
177: ,p_actual_termination_date in date
178: ,p_last_standard_process_date in out nocopy date
179: ,p_person_type_id in number default hr_api.g_number
180: ,p_assignment_status_type_id in number default hr_api.g_number
181: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
182: ,p_supervisor_warning out nocopy boolean
183: ,p_event_warning out nocopy boolean
184: ,p_interview_warning out nocopy boolean
177: ,p_actual_termination_date in date
178: ,p_last_standard_process_date in out nocopy date
179: ,p_person_type_id in number default hr_api.g_number
180: ,p_assignment_status_type_id in number default hr_api.g_number
181: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
182: ,p_supervisor_warning out nocopy boolean
183: ,p_event_warning out nocopy boolean
184: ,p_interview_warning out nocopy boolean
185: ,p_review_warning out nocopy boolean
204: then
205: /* No LSPD has been passed. To preserve the previous
206: ** behaviour we need to pass g_date to the latest ATE API.
207: */
208: l_last_std_process_date_in := hr_api.g_date;
209: else
210: /* Otherwise pass through the value provided.
211: */
212: l_last_std_process_date_in := p_last_standard_process_date;
252: ,p_period_of_service_id in number
253: ,p_object_version_number in out nocopy number
254: ,p_actual_termination_date in date
255: ,p_last_standard_process_date in out nocopy date
256: ,p_person_type_id in number default hr_api.g_number
257: ,p_assignment_status_type_id in number default hr_api.g_number
258: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
259: --
260: -- 120.2 (START)
253: ,p_object_version_number in out nocopy number
254: ,p_actual_termination_date in date
255: ,p_last_standard_process_date in out nocopy date
256: ,p_person_type_id in number default hr_api.g_number
257: ,p_assignment_status_type_id in number default hr_api.g_number
258: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
259: --
260: -- 120.2 (START)
261: --
254: ,p_actual_termination_date in date
255: ,p_last_standard_process_date in out nocopy date
256: ,p_person_type_id in number default hr_api.g_number
257: ,p_assignment_status_type_id in number default hr_api.g_number
258: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
259: --
260: -- 120.2 (START)
261: --
262: ,p_atd_new in number default hr_api.g_true_num
258: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
259: --
260: -- 120.2 (START)
261: --
262: ,p_atd_new in number default hr_api.g_true_num
263: ,p_lspd_new in number default hr_api.g_true_num
264: --
265: -- 120.2 (END)
266: --
259: --
260: -- 120.2 (START)
261: --
262: ,p_atd_new in number default hr_api.g_true_num
263: ,p_lspd_new in number default hr_api.g_true_num
264: --
265: -- 120.2 (END)
266: --
267: ,p_supervisor_warning out nocopy boolean
295: then
296: /* No LSPD has been passed. To preserve the previous
297: ** behaviour we need to pass g_date to the latest ATE API.
298: */
299: l_last_std_process_date_in := hr_api.g_date;
300: else
301: /* Otherwise pass through the value provided.
302: */
303: l_last_std_process_date_in := p_last_standard_process_date;
359: ,p_effective_date in date
360: ,p_period_of_service_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_actual_termination_date in date
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
360: ,p_period_of_service_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_actual_termination_date in date
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
361: ,p_object_version_number in out nocopy number
362: ,p_actual_termination_date in date
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
362: ,p_actual_termination_date in date
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
396: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
397: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
398: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
399: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
400: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
401: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
402: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
403: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
404: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
405: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
406: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
407: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
408: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
409: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
410: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
411: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
419: ,p_last_std_process_date_out out nocopy date
412: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
419: ,p_last_std_process_date_out out nocopy date
420: ,p_supervisor_warning out nocopy boolean
413: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
419: ,p_last_std_process_date_out out nocopy date
420: ,p_supervisor_warning out nocopy boolean
421: ,p_event_warning out nocopy boolean
414: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
415: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
416: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
417: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
418: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
419: ,p_last_std_process_date_out out nocopy date
420: ,p_supervisor_warning out nocopy boolean
421: ,p_event_warning out nocopy boolean
422: ,p_interview_warning out nocopy boolean
524: ,p_effective_date in date
525: ,p_period_of_service_id in number
526: ,p_object_version_number in out nocopy number
527: ,p_actual_termination_date in date
528: ,p_last_standard_process_date in date default hr_api.g_date
529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --
525: ,p_period_of_service_id in number
526: ,p_object_version_number in out nocopy number
527: ,p_actual_termination_date in date
528: ,p_last_standard_process_date in date default hr_api.g_date
529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --
533: -- 120.2 (START)
526: ,p_object_version_number in out nocopy number
527: ,p_actual_termination_date in date
528: ,p_last_standard_process_date in date default hr_api.g_date
529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --
533: -- 120.2 (START)
534: --
527: ,p_actual_termination_date in date
528: ,p_last_standard_process_date in date default hr_api.g_date
529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --
533: -- 120.2 (START)
534: --
535: ,p_atd_new in number default hr_api.g_true_num
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --
533: -- 120.2 (START)
534: --
535: ,p_atd_new in number default hr_api.g_true_num
536: ,p_lspd_new in number default hr_api.g_true_num
537: --
538: -- 120.2 (END)
539: --
532: --
533: -- 120.2 (START)
534: --
535: ,p_atd_new in number default hr_api.g_true_num
536: ,p_lspd_new in number default hr_api.g_true_num
537: --
538: -- 120.2 (END)
539: --
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
536: ,p_lspd_new in number default hr_api.g_true_num
537: --
538: -- 120.2 (END)
539: --
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
537: --
538: -- 120.2 (END)
539: --
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
538: -- 120.2 (END)
539: --
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
539: --
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
541: ,p_attribute1 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
542: ,p_attribute2 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
543: ,p_attribute3 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
544: ,p_attribute4 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
545: ,p_attribute5 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
546: ,p_attribute6 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
547: ,p_attribute7 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
548: ,p_attribute8 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
549: ,p_attribute9 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
550: ,p_attribute10 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
551: ,p_attribute11 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
552: ,p_attribute12 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
553: ,p_attribute13 in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
554: ,p_attribute14 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
555: ,p_attribute15 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
556: ,p_attribute16 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
557: ,p_attribute17 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
558: ,p_attribute18 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
559: ,p_attribute19 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
560: ,p_attribute20 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
569: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
570: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
571: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
572: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
573: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
574: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
575: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
576: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
577: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
578: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
579: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
580: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
581: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
582: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
583: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
591: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
584: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
591: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
592: ,p_last_std_process_date_out out nocopy date
585: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
591: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
592: ,p_last_std_process_date_out out nocopy date
593: ,p_supervisor_warning out nocopy boolean
586: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
591: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
592: ,p_last_std_process_date_out out nocopy date
593: ,p_supervisor_warning out nocopy boolean
594: ,p_event_warning out nocopy boolean
587: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
588: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
589: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
590: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
591: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
592: ,p_last_std_process_date_out out nocopy date
593: ,p_supervisor_warning out nocopy boolean
594: ,p_event_warning out nocopy boolean
595: ,p_interview_warning out nocopy boolean
964: l_pds_object_version_number := p_object_version_number;
965: l_person_type_id := p_person_type_id;
966: l_actual_termination_date := trunc(p_actual_termination_date);
967: l_effective_date := trunc(p_effective_date);
968: l_applicant_number := hr_api.g_varchar2;
969: --
970: hr_utility.set_location(l_proc, 20);
971: --
972: -- Validation in addition to Table Handlers
972: -- Validation in addition to Table Handlers
973: --
974: -- Check period of service and get business group details for validation.
975: --
976: hr_api.mandatory_arg_error
977: (p_api_name => l_proc
978: ,p_argument => 'period_of_service_id'
979: ,p_argument_value => p_period_of_service_id
980: );
978: ,p_argument => 'period_of_service_id'
979: ,p_argument_value => p_period_of_service_id
980: );
981: --
982: hr_api.mandatory_arg_error
983: (p_api_name => l_proc
984: ,p_argument => 'actual_termination_date'
985: ,p_argument_value => l_actual_termination_date
986: );
1036: if (l_src_bg_rec.PERMANENT = 'N'
1037: and l_src_bg_rec.status = 'ACTIVE')
1038: -- Commented for bug 5607315
1039: /* and (p_actual_termination_date between l_src_bg_rec.START_DATE
1040: and nvl(l_src_bg_rec.END_DATE,hr_api.g_eot))) */
1041: then
1042:
1043: hr_utility.set_message(800, 'HR_449770_GLD_SRC_BG');
1044: hr_utility.raise_error;
1052: if (l_dest_bg_rec.PERMANENT = 'N'
1053: and l_dest_bg_rec.status = 'ACTIVE')
1054: -- Commented for bug 5607315
1055: /* and (p_actual_termination_date between l_dest_bg_rec.START_DATE
1056: and nvl(l_dest_bg_rec.END_DATE,hr_api.g_eot))) */
1057: then
1058:
1059: hr_utility.set_message(800, 'HR_449771_GLD_DEST_BG');
1060: hr_utility.raise_error;
1143: ,p_pds_information29 => p_pds_information29
1144: ,p_pds_information30 => p_pds_information30
1145: );
1146: exception
1147: when hr_api.cannot_find_prog_unit then
1148: hr_api.cannot_find_prog_unit_error
1149: (p_module_name => 'ACTUAL_TERMINATION_EMP',
1150: p_hook_type => 'BP'
1151: );
1144: ,p_pds_information30 => p_pds_information30
1145: );
1146: exception
1147: when hr_api.cannot_find_prog_unit then
1148: hr_api.cannot_find_prog_unit_error
1149: (p_module_name => 'ACTUAL_TERMINATION_EMP',
1150: p_hook_type => 'BP'
1151: );
1152: end;
1166: l_last_standard_process_date is not null then
1167: --
1168: -- We are processing a save to LSPD as a separate call to this API.
1169: --
1170: if p_last_standard_process_date = hr_api.g_date
1171: then
1172: hr_utility.set_location(l_proc, 60);
1173: --
1174: -- Last standard process date is the default value i.e.
1429: -- for l_last_standard_process_date or it will be NULL. It can only be
1430: -- NULL if explicitly passed as such to the API.
1431: --
1432: if l_last_standard_process_date is not null and
1433: l_last_standard_process_date <> hr_api.g_date
1434: then
1435: --
1436: hr_utility.set_location(l_proc, 210);
1437: --
1445: --
1446: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1447: hr_utility.raise_error;
1448: end if;
1449: elsif l_last_standard_process_date = hr_api.g_date then
1450: --
1451: hr_utility.set_location(l_proc, 230);
1452: --
1453: -- Last standard process date is the default value i.e.
1543: fetch min_start_date into l_start_date,l_person_type_id2;
1544: close min_start_date;
1545:
1546: if l_start_date = l_actual_termination_date + 1 then
1547: l_datetrack_mode := hr_api.g_correction;
1548:
1549: hr_utility.set_location(l_proc, 283);
1550: if hr_person_type_usage_info.GetSystemPersonType(l_person_type_id2) = 'EMP_APL' then
1551: hr_utility.set_location(l_proc, 285);
1561: end if;
1562: else
1563: hr_utility.set_location(l_proc, 287);
1564: g_fpt_termination := 'Y';
1565: l_datetrack_mode := hr_api.g_update_change_insert;
1566: end if;
1567: else
1568: hr_utility.set_location(l_proc, 288);
1569: l_datetrack_mode := 'UPDATE';
2053: ,p_business_group_id => l_business_group_id
2054: ,p_person_id => l_person_id2
2055: );
2056: exception
2057: when hr_api.cannot_find_prog_unit then
2058: hr_api.cannot_find_prog_unit_error
2059: (p_module_name => 'ACTUAL_TERMINATION_EMP',
2060: p_hook_type => 'AP'
2061: );
2054: ,p_person_id => l_person_id2
2055: );
2056: exception
2057: when hr_api.cannot_find_prog_unit then
2058: hr_api.cannot_find_prog_unit_error
2059: (p_module_name => 'ACTUAL_TERMINATION_EMP',
2060: p_hook_type => 'AP'
2061: );
2062: --
2066: --
2067: -- When in validation only mode raise the Validate_Enabled exception
2068: --
2069: if p_validate then
2070: raise hr_api.validate_enabled;
2071: end if;
2072: --
2073: -- Set all output arguments
2074: --
2088: --
2089: --
2090: hr_utility.set_location(' Leaving:'||l_proc, 440);
2091: exception
2092: when hr_api.validate_enabled then
2093: --
2094: -- As the Validate_Enabled exception has been raised
2095: -- we must rollback to the savepoint
2096: --
2252: ,p_object_version_number => p_object_version_number
2253: ,p_final_process_date => l_final_process_date
2254: );
2255: exception
2256: when hr_api.cannot_find_prog_unit then
2257: hr_api.cannot_find_prog_unit_error
2258: (p_module_name => 'FINAL_PROCESS_EMP',
2259: p_hook_type => 'BP'
2260: );
2253: ,p_final_process_date => l_final_process_date
2254: );
2255: exception
2256: when hr_api.cannot_find_prog_unit then
2257: hr_api.cannot_find_prog_unit_error
2258: (p_module_name => 'FINAL_PROCESS_EMP',
2259: p_hook_type => 'BP'
2260: );
2261: end;
2265: -- Validation in addition to Table Handlers
2266: --
2267: -- Check period of service.
2268: --
2269: hr_api.mandatory_arg_error
2270: (p_api_name => l_proc
2271: ,p_argument => 'period_of_service_id'
2272: ,p_argument_value => p_period_of_service_id
2273: );
2273: );
2274: --
2275: -- Check Object version number.
2276: --
2277: hr_api.mandatory_arg_error
2278: (p_api_name => l_proc
2279: ,p_argument => 'object_version_number'
2280: ,p_argument_value => p_object_version_number
2281: );
2562: ,p_asg_future_changes_warning => l_asg_future_changes_warning
2563: ,p_entries_changed_warning => l_entries_changed_warning
2564: );
2565: exception
2566: when hr_api.cannot_find_prog_unit then
2567: hr_api.cannot_find_prog_unit_error
2568: (p_module_name => 'FINAL_PROCESS_EMP',
2569: p_hook_type => 'AP'
2570: );
2563: ,p_entries_changed_warning => l_entries_changed_warning
2564: );
2565: exception
2566: when hr_api.cannot_find_prog_unit then
2567: hr_api.cannot_find_prog_unit_error
2568: (p_module_name => 'FINAL_PROCESS_EMP',
2569: p_hook_type => 'AP'
2570: );
2571: end;
2575: --
2576: -- When in validation only mode raise the Validate_Enabled exception
2577: --
2578: if p_validate then
2579: raise hr_api.validate_enabled;
2580: end if;
2581: --
2582: -- Set all output arguments
2583: --
2588: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
2589: --
2590: hr_utility.set_location(' Leaving:'||l_proc, 400);
2591: exception
2592: when hr_api.validate_enabled then
2593: --
2594: -- As the Validate_Enabled exception has been raised
2595: -- we must rollback to the savepoint
2596: --
2635: (p_validate in boolean default false
2636: ,p_effective_date in date
2637: ,p_period_of_service_id in number
2638: ,p_object_version_number in out nocopy number
2639: ,p_termination_accepted_person in number default hr_api.g_number
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2636: ,p_effective_date in date
2637: ,p_period_of_service_id in number
2638: ,p_object_version_number in out nocopy number
2639: ,p_termination_accepted_person in number default hr_api.g_number
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2644: ,p_projected_termination_date in date default hr_api.g_date
2637: ,p_period_of_service_id in number
2638: ,p_object_version_number in out nocopy number
2639: ,p_termination_accepted_person in number default hr_api.g_number
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2644: ,p_projected_termination_date in date default hr_api.g_date
2645: ) is
2638: ,p_object_version_number in out nocopy number
2639: ,p_termination_accepted_person in number default hr_api.g_number
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2644: ,p_projected_termination_date in date default hr_api.g_date
2645: ) is
2646: --
2639: ,p_termination_accepted_person in number default hr_api.g_number
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2644: ,p_projected_termination_date in date default hr_api.g_date
2645: ) is
2646: --
2647: -- Declare cursors and local variables
2640: ,p_accepted_termination_date in date default hr_api.g_date
2641: ,p_comments in varchar2 default hr_api.g_varchar2
2642: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2643: ,p_notified_termination_date in date default hr_api.g_date
2644: ,p_projected_termination_date in date default hr_api.g_date
2645: ) is
2646: --
2647: -- Declare cursors and local variables
2648: --
2676: ,p_notified_termination_date => p_notified_termination_date
2677: ,p_projected_termination_date => p_projected_termination_date
2678: );
2679: exception
2680: when hr_api.cannot_find_prog_unit then
2681: hr_api.cannot_find_prog_unit_error
2682: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2683: p_hook_type => 'BP'
2684: );
2677: ,p_projected_termination_date => p_projected_termination_date
2678: );
2679: exception
2680: when hr_api.cannot_find_prog_unit then
2681: hr_api.cannot_find_prog_unit_error
2682: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2683: p_hook_type => 'BP'
2684: );
2685: end;
2717: ,p_notified_termination_date => p_notified_termination_date
2718: ,p_projected_termination_date => p_projected_termination_date
2719: );
2720: exception
2721: when hr_api.cannot_find_prog_unit then
2722: hr_api.cannot_find_prog_unit_error
2723: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2724: p_hook_type => 'AP'
2725: );
2718: ,p_projected_termination_date => p_projected_termination_date
2719: );
2720: exception
2721: when hr_api.cannot_find_prog_unit then
2722: hr_api.cannot_find_prog_unit_error
2723: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2724: p_hook_type => 'AP'
2725: );
2726: end;
2725: );
2726: end;
2727: --
2728: if p_validate then
2729: raise hr_api.validate_enabled;
2730: end if;
2731: --
2732: hr_utility.set_location(' Leaving:'||l_proc, 8);
2733: --
2731: --
2732: hr_utility.set_location(' Leaving:'||l_proc, 8);
2733: --
2734: exception
2735: when hr_api.validate_enabled then
2736: --
2737: -- As the Validate_Enabled exception has been raised
2738: -- we must rollback to the savepoint
2739: --
2803: WHERE asg.person_id = p_person_id
2804: AND act.assignment_id = asg.assignment_id
2805: AND pac.payroll_action_id = act.payroll_action_id
2806: AND pac.action_type NOT IN ('X','BEE')
2807: AND pac.effective_date > nvl(p_fpr_date,hr_api.g_eot));
2808: EXCEPTION
2809: when NO_DATA_FOUND then null;
2810: END;
2811: --
2870: ,p_actual_termination_date => p_actual_termination_date
2871: ,p_clear_details => p_clear_details
2872: );
2873: exception
2874: when hr_api.cannot_find_prog_unit then
2875: hr_api.cannot_find_prog_unit_error
2876: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2877: p_hook_type => 'BP'
2878: );
2871: ,p_clear_details => p_clear_details
2872: );
2873: exception
2874: when hr_api.cannot_find_prog_unit then
2875: hr_api.cannot_find_prog_unit_error
2876: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2877: p_hook_type => 'BP'
2878: );
2879: end;
2898: ,p_actual_termination_date => p_actual_termination_date
2899: ,p_clear_details => p_clear_details
2900: );
2901: exception
2902: when hr_api.cannot_find_prog_unit then
2903: hr_api.cannot_find_prog_unit_error
2904: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2905: p_hook_type => 'AP'
2906: );
2899: ,p_clear_details => p_clear_details
2900: );
2901: exception
2902: when hr_api.cannot_find_prog_unit then
2903: hr_api.cannot_find_prog_unit_error
2904: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2905: p_hook_type => 'AP'
2906: );
2907: end;
2906: );
2907: end;
2908:
2909: if p_validate then
2910: raise hr_api.validate_enabled;
2911: end if;
2912: --
2913: hr_utility.set_location(' Leaving:'||l_proc, 20);
2914: --
2912: --
2913: hr_utility.set_location(' Leaving:'||l_proc, 20);
2914: --
2915: exception
2916: when hr_api.validate_enabled then
2917: --
2918: -- As the Validate_Enabled exception has been raised
2919: -- we must rollback to the savepoint
2920: --