[Home] [Help]
152: ,p_period_of_service_id in number
153: ,p_object_version_number in out nocopy number
154: ,p_actual_termination_date in date
155: ,p_last_standard_process_date in out nocopy date
156: ,p_person_type_id in number default hr_api.g_number
157: ,p_assignment_status_type_id in number default hr_api.g_number
158: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
159: ,p_supervisor_warning out nocopy boolean
160: ,p_event_warning out nocopy boolean
153: ,p_object_version_number in out nocopy number
154: ,p_actual_termination_date in date
155: ,p_last_standard_process_date in out nocopy date
156: ,p_person_type_id in number default hr_api.g_number
157: ,p_assignment_status_type_id in number default hr_api.g_number
158: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
159: ,p_supervisor_warning out nocopy boolean
160: ,p_event_warning out nocopy boolean
161: ,p_interview_warning out nocopy boolean
154: ,p_actual_termination_date in date
155: ,p_last_standard_process_date in out nocopy date
156: ,p_person_type_id in number default hr_api.g_number
157: ,p_assignment_status_type_id in number default hr_api.g_number
158: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
159: ,p_supervisor_warning out nocopy boolean
160: ,p_event_warning out nocopy boolean
161: ,p_interview_warning out nocopy boolean
162: ,p_review_warning out nocopy boolean
181: then
182: /* No LSPD has been passed. To preserve the previous
183: ** behaviour we need to pass g_date to the latest ATE API.
184: */
185: l_last_std_process_date_in := hr_api.g_date;
186: else
187: /* Otherwise pass through the value provided.
188: */
189: l_last_std_process_date_in := p_last_standard_process_date;
229: ,p_period_of_service_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_actual_termination_date in date
232: ,p_last_standard_process_date in out nocopy date
233: ,p_person_type_id in number default hr_api.g_number
234: ,p_assignment_status_type_id in number default hr_api.g_number
235: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
236: --
237: -- 120.2 (START)
230: ,p_object_version_number in out nocopy number
231: ,p_actual_termination_date in date
232: ,p_last_standard_process_date in out nocopy date
233: ,p_person_type_id in number default hr_api.g_number
234: ,p_assignment_status_type_id in number default hr_api.g_number
235: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
236: --
237: -- 120.2 (START)
238: --
231: ,p_actual_termination_date in date
232: ,p_last_standard_process_date in out nocopy date
233: ,p_person_type_id in number default hr_api.g_number
234: ,p_assignment_status_type_id in number default hr_api.g_number
235: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
236: --
237: -- 120.2 (START)
238: --
239: ,p_atd_new in number default hr_api.g_true_num
235: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
236: --
237: -- 120.2 (START)
238: --
239: ,p_atd_new in number default hr_api.g_true_num
240: ,p_lspd_new in number default hr_api.g_true_num
241: --
242: -- 120.2 (END)
243: --
236: --
237: -- 120.2 (START)
238: --
239: ,p_atd_new in number default hr_api.g_true_num
240: ,p_lspd_new in number default hr_api.g_true_num
241: --
242: -- 120.2 (END)
243: --
244: ,p_supervisor_warning out nocopy boolean
272: then
273: /* No LSPD has been passed. To preserve the previous
274: ** behaviour we need to pass g_date to the latest ATE API.
275: */
276: l_last_std_process_date_in := hr_api.g_date;
277: else
278: /* Otherwise pass through the value provided.
279: */
280: l_last_std_process_date_in := p_last_standard_process_date;
336: ,p_effective_date in date
337: ,p_period_of_service_id in number
338: ,p_object_version_number in out nocopy number
339: ,p_actual_termination_date in date
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_period_of_service_id in number
338: ,p_object_version_number in out nocopy number
339: ,p_actual_termination_date in date
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_object_version_number in out nocopy number
339: ,p_actual_termination_date in date
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_actual_termination_date in date
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_last_standard_process_date in date default hr_api.g_date
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_person_type_id in number default hr_api.g_number
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_assignment_status_type_id in number default hr_api.g_number
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
365: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
366: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
367: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
368: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
369: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
370: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
371: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
372: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
373: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
374: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
375: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
376: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
377: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
378: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
379: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
380: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
381: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
382: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
383: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
384: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
385: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
386: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
387: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
388: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
396: ,p_last_std_process_date_out out nocopy date
389: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
396: ,p_last_std_process_date_out out nocopy date
397: ,p_supervisor_warning out nocopy boolean
390: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
396: ,p_last_std_process_date_out out nocopy date
397: ,p_supervisor_warning out nocopy boolean
398: ,p_event_warning out nocopy boolean
391: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
392: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
393: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
394: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
395: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
396: ,p_last_std_process_date_out out nocopy date
397: ,p_supervisor_warning out nocopy boolean
398: ,p_event_warning out nocopy boolean
399: ,p_interview_warning out nocopy boolean
501: ,p_effective_date in date
502: ,p_period_of_service_id in number
503: ,p_object_version_number in out nocopy number
504: ,p_actual_termination_date in date
505: ,p_last_standard_process_date in date default hr_api.g_date
506: ,p_person_type_id in number default hr_api.g_number
507: ,p_assignment_status_type_id in number default hr_api.g_number
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
502: ,p_period_of_service_id in number
503: ,p_object_version_number in out nocopy number
504: ,p_actual_termination_date in date
505: ,p_last_standard_process_date in date default hr_api.g_date
506: ,p_person_type_id in number default hr_api.g_number
507: ,p_assignment_status_type_id in number default hr_api.g_number
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
510: -- 120.2 (START)
503: ,p_object_version_number in out nocopy number
504: ,p_actual_termination_date in date
505: ,p_last_standard_process_date in date default hr_api.g_date
506: ,p_person_type_id in number default hr_api.g_number
507: ,p_assignment_status_type_id in number default hr_api.g_number
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
510: -- 120.2 (START)
511: --
504: ,p_actual_termination_date in date
505: ,p_last_standard_process_date in date default hr_api.g_date
506: ,p_person_type_id in number default hr_api.g_number
507: ,p_assignment_status_type_id in number default hr_api.g_number
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
510: -- 120.2 (START)
511: --
512: ,p_atd_new in number default hr_api.g_true_num
508: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
509: --
510: -- 120.2 (START)
511: --
512: ,p_atd_new in number default hr_api.g_true_num
513: ,p_lspd_new in number default hr_api.g_true_num
514: --
515: -- 120.2 (END)
516: --
509: --
510: -- 120.2 (START)
511: --
512: ,p_atd_new in number default hr_api.g_true_num
513: ,p_lspd_new in number default hr_api.g_true_num
514: --
515: -- 120.2 (END)
516: --
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
513: ,p_lspd_new in number default hr_api.g_true_num
514: --
515: -- 120.2 (END)
516: --
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: --
515: -- 120.2 (END)
516: --
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: -- 120.2 (END)
516: --
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: --
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute_category in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute1 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute2 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute3 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute4 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute5 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute6 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute7 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute8 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute9 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute10 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute11 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute12 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute13 in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
531: ,p_attribute14 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
532: ,p_attribute15 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
533: ,p_attribute16 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
534: ,p_attribute17 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
535: ,p_attribute18 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
536: ,p_attribute19 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
537: ,p_attribute20 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
538: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
539: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
540: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
541: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
542: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
543: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
544: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
545: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
546: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
547: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
548: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
549: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
550: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
551: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
552: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
553: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
554: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
555: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
556: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
557: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
558: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
559: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
560: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
561: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
569: ,p_last_std_process_date_out out nocopy date
562: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
569: ,p_last_std_process_date_out out nocopy date
570: ,p_supervisor_warning out nocopy boolean
563: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
569: ,p_last_std_process_date_out out nocopy date
570: ,p_supervisor_warning out nocopy boolean
571: ,p_event_warning out nocopy boolean
564: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
565: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
566: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
567: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
568: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
569: ,p_last_std_process_date_out out nocopy date
570: ,p_supervisor_warning out nocopy boolean
571: ,p_event_warning out nocopy boolean
572: ,p_interview_warning out nocopy boolean
775: l_pds_object_version_number := p_object_version_number;
776: l_person_type_id := p_person_type_id;
777: l_actual_termination_date := trunc(p_actual_termination_date);
778: l_effective_date := trunc(p_effective_date);
779: l_applicant_number := hr_api.g_varchar2;
780: --
781: hr_utility.set_location(l_proc, 20);
782: --
783: -- Validation in addition to Table Handlers
783: -- Validation in addition to Table Handlers
784: --
785: -- Check period of service and get business group details for validation.
786: --
787: hr_api.mandatory_arg_error
788: (p_api_name => l_proc
789: ,p_argument => 'period_of_service_id'
790: ,p_argument_value => p_period_of_service_id
791: );
789: ,p_argument => 'period_of_service_id'
790: ,p_argument_value => p_period_of_service_id
791: );
792: --
793: hr_api.mandatory_arg_error
794: (p_api_name => l_proc
795: ,p_argument => 'actual_termination_date'
796: ,p_argument_value => l_actual_termination_date
797: );
847: if (l_src_bg_rec.PERMANENT = 'N'
848: and l_src_bg_rec.status = 'ACTIVE')
849: -- Commented for bug 5607315
850: /* and (p_actual_termination_date between l_src_bg_rec.START_DATE
851: and nvl(l_src_bg_rec.END_DATE,hr_api.g_eot))) */
852: then
853:
854: hr_utility.set_message(800, 'HR_449770_GLD_SRC_BG');
855: hr_utility.raise_error;
863: if (l_dest_bg_rec.PERMANENT = 'N'
864: and l_dest_bg_rec.status = 'ACTIVE')
865: -- Commented for bug 5607315
866: /* and (p_actual_termination_date between l_dest_bg_rec.START_DATE
867: and nvl(l_dest_bg_rec.END_DATE,hr_api.g_eot))) */
868: then
869:
870: hr_utility.set_message(800, 'HR_449771_GLD_DEST_BG');
871: hr_utility.raise_error;
954: ,p_pds_information29 => p_pds_information29
955: ,p_pds_information30 => p_pds_information30
956: );
957: exception
958: when hr_api.cannot_find_prog_unit then
959: hr_api.cannot_find_prog_unit_error
960: (p_module_name => 'ACTUAL_TERMINATION_EMP',
961: p_hook_type => 'BP'
962: );
955: ,p_pds_information30 => p_pds_information30
956: );
957: exception
958: when hr_api.cannot_find_prog_unit then
959: hr_api.cannot_find_prog_unit_error
960: (p_module_name => 'ACTUAL_TERMINATION_EMP',
961: p_hook_type => 'BP'
962: );
963: end;
977: l_last_standard_process_date is not null then
978: --
979: -- We are processing a save to LSPD as a separate call to this API.
980: --
981: if p_last_standard_process_date = hr_api.g_date
982: then
983: hr_utility.set_location(l_proc, 60);
984: --
985: -- Last standard process date is the default value i.e.
1234: -- for l_last_standard_process_date or it will be NULL. It can only be
1235: -- NULL if explicitly passed as such to the API.
1236: --
1237: if l_last_standard_process_date is not null and
1238: l_last_standard_process_date <> hr_api.g_date
1239: then
1240: --
1241: hr_utility.set_location(l_proc, 210);
1242: --
1250: --
1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1252: hr_utility.raise_error;
1253: end if;
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --
1256: hr_utility.set_location(l_proc, 230);
1257: --
1258: -- Last standard process date is the default value i.e.
1762: ,p_dod_warning => l_dod_warning
1763: ,p_business_group_id => l_business_group_id
1764: );
1765: exception
1766: when hr_api.cannot_find_prog_unit then
1767: hr_api.cannot_find_prog_unit_error
1768: (p_module_name => 'ACTUAL_TERMINATION_EMP',
1769: p_hook_type => 'AP'
1770: );
1763: ,p_business_group_id => l_business_group_id
1764: );
1765: exception
1766: when hr_api.cannot_find_prog_unit then
1767: hr_api.cannot_find_prog_unit_error
1768: (p_module_name => 'ACTUAL_TERMINATION_EMP',
1769: p_hook_type => 'AP'
1770: );
1771: --
1775: --
1776: -- When in validation only mode raise the Validate_Enabled exception
1777: --
1778: if p_validate then
1779: raise hr_api.validate_enabled;
1780: end if;
1781: --
1782: -- Set all output arguments
1783: --
1797: --
1798: --
1799: hr_utility.set_location(' Leaving:'||l_proc, 440);
1800: exception
1801: when hr_api.validate_enabled then
1802: --
1803: -- As the Validate_Enabled exception has been raised
1804: -- we must rollback to the savepoint
1805: --
1961: ,p_object_version_number => p_object_version_number
1962: ,p_final_process_date => l_final_process_date
1963: );
1964: exception
1965: when hr_api.cannot_find_prog_unit then
1966: hr_api.cannot_find_prog_unit_error
1967: (p_module_name => 'FINAL_PROCESS_EMP',
1968: p_hook_type => 'BP'
1969: );
1962: ,p_final_process_date => l_final_process_date
1963: );
1964: exception
1965: when hr_api.cannot_find_prog_unit then
1966: hr_api.cannot_find_prog_unit_error
1967: (p_module_name => 'FINAL_PROCESS_EMP',
1968: p_hook_type => 'BP'
1969: );
1970: end;
1974: -- Validation in addition to Table Handlers
1975: --
1976: -- Check period of service.
1977: --
1978: hr_api.mandatory_arg_error
1979: (p_api_name => l_proc
1980: ,p_argument => 'period_of_service_id'
1981: ,p_argument_value => p_period_of_service_id
1982: );
1982: );
1983: --
1984: -- Check Object version number.
1985: --
1986: hr_api.mandatory_arg_error
1987: (p_api_name => l_proc
1988: ,p_argument => 'object_version_number'
1989: ,p_argument_value => p_object_version_number
1990: );
2271: ,p_asg_future_changes_warning => l_asg_future_changes_warning
2272: ,p_entries_changed_warning => l_entries_changed_warning
2273: );
2274: exception
2275: when hr_api.cannot_find_prog_unit then
2276: hr_api.cannot_find_prog_unit_error
2277: (p_module_name => 'FINAL_PROCESS_EMP',
2278: p_hook_type => 'AP'
2279: );
2272: ,p_entries_changed_warning => l_entries_changed_warning
2273: );
2274: exception
2275: when hr_api.cannot_find_prog_unit then
2276: hr_api.cannot_find_prog_unit_error
2277: (p_module_name => 'FINAL_PROCESS_EMP',
2278: p_hook_type => 'AP'
2279: );
2280: end;
2284: --
2285: -- When in validation only mode raise the Validate_Enabled exception
2286: --
2287: if p_validate then
2288: raise hr_api.validate_enabled;
2289: end if;
2290: --
2291: -- Set all output arguments
2292: --
2297: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
2298: --
2299: hr_utility.set_location(' Leaving:'||l_proc, 400);
2300: exception
2301: when hr_api.validate_enabled then
2302: --
2303: -- As the Validate_Enabled exception has been raised
2304: -- we must rollback to the savepoint
2305: --
2344: (p_validate in boolean default false
2345: ,p_effective_date in date
2346: ,p_period_of_service_id in number
2347: ,p_object_version_number in out nocopy number
2348: ,p_termination_accepted_person in number default hr_api.g_number
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2345: ,p_effective_date in date
2346: ,p_period_of_service_id in number
2347: ,p_object_version_number in out nocopy number
2348: ,p_termination_accepted_person in number default hr_api.g_number
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2353: ,p_projected_termination_date in date default hr_api.g_date
2346: ,p_period_of_service_id in number
2347: ,p_object_version_number in out nocopy number
2348: ,p_termination_accepted_person in number default hr_api.g_number
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2353: ,p_projected_termination_date in date default hr_api.g_date
2354: ) is
2347: ,p_object_version_number in out nocopy number
2348: ,p_termination_accepted_person in number default hr_api.g_number
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2353: ,p_projected_termination_date in date default hr_api.g_date
2354: ) is
2355: --
2348: ,p_termination_accepted_person in number default hr_api.g_number
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2353: ,p_projected_termination_date in date default hr_api.g_date
2354: ) is
2355: --
2356: -- Declare cursors and local variables
2349: ,p_accepted_termination_date in date default hr_api.g_date
2350: ,p_comments in varchar2 default hr_api.g_varchar2
2351: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2352: ,p_notified_termination_date in date default hr_api.g_date
2353: ,p_projected_termination_date in date default hr_api.g_date
2354: ) is
2355: --
2356: -- Declare cursors and local variables
2357: --
2385: ,p_notified_termination_date => p_notified_termination_date
2386: ,p_projected_termination_date => p_projected_termination_date
2387: );
2388: exception
2389: when hr_api.cannot_find_prog_unit then
2390: hr_api.cannot_find_prog_unit_error
2391: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2392: p_hook_type => 'BP'
2393: );
2386: ,p_projected_termination_date => p_projected_termination_date
2387: );
2388: exception
2389: when hr_api.cannot_find_prog_unit then
2390: hr_api.cannot_find_prog_unit_error
2391: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2392: p_hook_type => 'BP'
2393: );
2394: end;
2426: ,p_notified_termination_date => p_notified_termination_date
2427: ,p_projected_termination_date => p_projected_termination_date
2428: );
2429: exception
2430: when hr_api.cannot_find_prog_unit then
2431: hr_api.cannot_find_prog_unit_error
2432: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2433: p_hook_type => 'AP'
2434: );
2427: ,p_projected_termination_date => p_projected_termination_date
2428: );
2429: exception
2430: when hr_api.cannot_find_prog_unit then
2431: hr_api.cannot_find_prog_unit_error
2432: (p_module_name => 'UPDATE_TERM_DETAILS_EMP',
2433: p_hook_type => 'AP'
2434: );
2435: end;
2434: );
2435: end;
2436: --
2437: if p_validate then
2438: raise hr_api.validate_enabled;
2439: end if;
2440: --
2441: hr_utility.set_location(' Leaving:'||l_proc, 8);
2442: --
2440: --
2441: hr_utility.set_location(' Leaving:'||l_proc, 8);
2442: --
2443: exception
2444: when hr_api.validate_enabled then
2445: --
2446: -- As the Validate_Enabled exception has been raised
2447: -- we must rollback to the savepoint
2448: --
2512: WHERE asg.person_id = p_person_id
2513: AND act.assignment_id = asg.assignment_id
2514: AND pac.payroll_action_id = act.payroll_action_id
2515: AND pac.action_type NOT IN ('X','BEE')
2516: AND pac.effective_date > nvl(p_fpr_date,hr_api.g_eot));
2517: EXCEPTION
2518: when NO_DATA_FOUND then null;
2519: END;
2520: --
2579: ,p_actual_termination_date => p_actual_termination_date
2580: ,p_clear_details => p_clear_details
2581: );
2582: exception
2583: when hr_api.cannot_find_prog_unit then
2584: hr_api.cannot_find_prog_unit_error
2585: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2586: p_hook_type => 'BP'
2587: );
2580: ,p_clear_details => p_clear_details
2581: );
2582: exception
2583: when hr_api.cannot_find_prog_unit then
2584: hr_api.cannot_find_prog_unit_error
2585: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2586: p_hook_type => 'BP'
2587: );
2588: end;
2607: ,p_actual_termination_date => p_actual_termination_date
2608: ,p_clear_details => p_clear_details
2609: );
2610: exception
2611: when hr_api.cannot_find_prog_unit then
2612: hr_api.cannot_find_prog_unit_error
2613: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2614: p_hook_type => 'AP'
2615: );
2608: ,p_clear_details => p_clear_details
2609: );
2610: exception
2611: when hr_api.cannot_find_prog_unit then
2612: hr_api.cannot_find_prog_unit_error
2613: (p_module_name => 'REVERSE_TERMINATE_EMPLOYEE',
2614: p_hook_type => 'AP'
2615: );
2616: end;
2615: );
2616: end;
2617:
2618: if p_validate then
2619: raise hr_api.validate_enabled;
2620: end if;
2621: --
2622: hr_utility.set_location(' Leaving:'||l_proc, 20);
2623: --
2621: --
2622: hr_utility.set_location(' Leaving:'||l_proc, 20);
2623: --
2624: exception
2625: when hr_api.validate_enabled then
2626: --
2627: -- As the Validate_Enabled exception has been raised
2628: -- we must rollback to the savepoint
2629: --