12: procedure update_pds_details
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_period_of_service_id in number
16: ,p_termination_accepted_person in number default hr_api.g_number
17: ,p_accepted_termination_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_period_of_service_id in number
16: ,p_termination_accepted_person in number default hr_api.g_number
17: ,p_accepted_termination_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
15: ,p_period_of_service_id in number
16: ,p_termination_accepted_person in number default hr_api.g_number
17: ,p_accepted_termination_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
16: ,p_termination_accepted_person in number default hr_api.g_number
17: ,p_accepted_termination_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
17: ,p_accepted_termination_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
18: ,p_object_version_number in out nocopy number
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
23: ,p_actual_termination_date in date default hr_api.g_date
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
24: ,p_last_standard_process_date in date default hr_api.g_date
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
25: ,p_final_process_date in date default hr_api.g_date
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
27: ,p_attribute1 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
28: ,p_attribute2 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
29: ,p_attribute3 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
30: ,p_attribute4 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
31: ,p_attribute5 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
32: ,p_attribute6 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
33: ,p_attribute7 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
34: ,p_attribute8 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
35: ,p_attribute9 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
36: ,p_attribute10 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
37: ,p_attribute11 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
38: ,p_attribute12 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
39: ,p_attribute13 in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
40: ,p_attribute14 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
41: ,p_attribute15 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
42: ,p_attribute16 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
43: ,p_attribute17 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
44: ,p_attribute18 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
45: ,p_attribute19 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
46: ,p_attribute20 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
47: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
48: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
49: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
50: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
51: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
52: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
53: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
54: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
55: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
56: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
57: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
58: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
59: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
60: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
61: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
62: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
63: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
64: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
65: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
66: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
67: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
68: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
69: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
77: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
70: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
77: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
78: ) is
71: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
77: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
78: ) is
79: --
72: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
77: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
78: ) is
79: --
80: l_org_now_no_manager_warning BOOLEAN := FALSE;
73: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
74: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
75: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
76: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
77: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
78: ) is
79: --
80: l_org_now_no_manager_warning BOOLEAN := FALSE;
81: l_asg_future_changes_warning BOOLEAN := FALSE;
163: procedure update_pds_details
164: (p_validate in boolean default false
165: ,p_effective_date in date
166: ,p_period_of_service_id in number
167: ,p_termination_accepted_person in number default hr_api.g_number
168: ,p_accepted_termination_date in date default hr_api.g_date
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
164: (p_validate in boolean default false
165: ,p_effective_date in date
166: ,p_period_of_service_id in number
167: ,p_termination_accepted_person in number default hr_api.g_number
168: ,p_accepted_termination_date in date default hr_api.g_date
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
172: ,p_notified_termination_date in date default hr_api.g_date
166: ,p_period_of_service_id in number
167: ,p_termination_accepted_person in number default hr_api.g_number
168: ,p_accepted_termination_date in date default hr_api.g_date
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
172: ,p_notified_termination_date in date default hr_api.g_date
173: ,p_projected_termination_date in date default hr_api.g_date
174: --
167: ,p_termination_accepted_person in number default hr_api.g_number
168: ,p_accepted_termination_date in date default hr_api.g_date
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
172: ,p_notified_termination_date in date default hr_api.g_date
173: ,p_projected_termination_date in date default hr_api.g_date
174: --
175: -- 115.9 (START)
168: ,p_accepted_termination_date in date default hr_api.g_date
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
172: ,p_notified_termination_date in date default hr_api.g_date
173: ,p_projected_termination_date in date default hr_api.g_date
174: --
175: -- 115.9 (START)
176: --
169: ,p_object_version_number in out nocopy number
170: ,p_comments in varchar2 default hr_api.g_varchar2
171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
172: ,p_notified_termination_date in date default hr_api.g_date
173: ,p_projected_termination_date in date default hr_api.g_date
174: --
175: -- 115.9 (START)
176: --
177: ,p_actual_termination_date in date default hr_api.g_date
173: ,p_projected_termination_date in date default hr_api.g_date
174: --
175: -- 115.9 (START)
176: --
177: ,p_actual_termination_date in date default hr_api.g_date
178: ,p_last_standard_process_date in date default hr_api.g_date
179: ,p_final_process_date in date default hr_api.g_date
180: --
181: -- 115.9 (END)
174: --
175: -- 115.9 (START)
176: --
177: ,p_actual_termination_date in date default hr_api.g_date
178: ,p_last_standard_process_date in date default hr_api.g_date
179: ,p_final_process_date in date default hr_api.g_date
180: --
181: -- 115.9 (END)
182: --
175: -- 115.9 (START)
176: --
177: ,p_actual_termination_date in date default hr_api.g_date
178: ,p_last_standard_process_date in date default hr_api.g_date
179: ,p_final_process_date in date default hr_api.g_date
180: --
181: -- 115.9 (END)
182: --
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
179: ,p_final_process_date in date default hr_api.g_date
180: --
181: -- 115.9 (END)
182: --
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
180: --
181: -- 115.9 (END)
182: --
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
181: -- 115.9 (END)
182: --
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
182: --
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
183: ,p_attribute_category in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
184: ,p_attribute1 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
185: ,p_attribute2 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
186: ,p_attribute3 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
187: ,p_attribute4 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
188: ,p_attribute5 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
189: ,p_attribute6 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
190: ,p_attribute7 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
191: ,p_attribute8 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
192: ,p_attribute9 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
193: ,p_attribute10 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
194: ,p_attribute11 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
195: ,p_attribute12 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
196: ,p_attribute13 in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
197: ,p_attribute14 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
198: ,p_attribute15 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
199: ,p_attribute16 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
200: ,p_attribute17 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
201: ,p_attribute18 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
202: ,p_attribute19 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
203: ,p_attribute20 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
204: ,p_pds_information_category in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
205: ,p_pds_information1 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
206: ,p_pds_information2 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
207: ,p_pds_information3 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
208: ,p_pds_information4 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
209: ,p_pds_information5 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
210: ,p_pds_information6 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
211: ,p_pds_information7 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
212: ,p_pds_information8 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
213: ,p_pds_information9 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
214: ,p_pds_information10 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
215: ,p_pds_information11 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
216: ,p_pds_information12 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
217: ,p_pds_information13 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
218: ,p_pds_information14 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
219: ,p_pds_information15 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
220: ,p_pds_information16 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
221: ,p_pds_information17 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
222: ,p_pds_information18 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
223: ,p_pds_information19 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
224: ,p_pds_information20 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
225: ,p_pds_information21 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
226: ,p_pds_information22 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
234: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
227: ,p_pds_information23 in varchar2 default hr_api.g_varchar2
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
234: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
235: --
228: ,p_pds_information24 in varchar2 default hr_api.g_varchar2
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
234: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
235: --
236: -- 115.9 (START)
229: ,p_pds_information25 in varchar2 default hr_api.g_varchar2
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
234: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
235: --
236: -- 115.9 (START)
237: --
230: ,p_pds_information26 in varchar2 default hr_api.g_varchar2
231: ,p_pds_information27 in varchar2 default hr_api.g_varchar2
232: ,p_pds_information28 in varchar2 default hr_api.g_varchar2
233: ,p_pds_information29 in varchar2 default hr_api.g_varchar2
234: ,p_pds_information30 in varchar2 default hr_api.g_varchar2
235: --
236: -- 115.9 (START)
237: --
238: ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
360: ,p_pds_information30 => p_pds_information30
361: ,p_object_version_number => p_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_PDS_DETAILS',
367: p_hook_type => 'BP'
368: );
361: ,p_object_version_number => p_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_PDS_DETAILS',
367: p_hook_type => 'BP'
368: );
369: end;
471: -- Fix for bug 3882918. check with nvl for the leaving_reason.
472: --
473: hr_utility.set_location('Update_pds_details ',800);
474: --
475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)
476: <> nvl(p_leaving_reason,hr_api.g_varchar2)
477: then
478: --
479: -- Fix for bug 3882918. If this proc is called without leaving_reason parameter
472: --
473: hr_utility.set_location('Update_pds_details ',800);
474: --
475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)
476: <> nvl(p_leaving_reason,hr_api.g_varchar2)
477: then
478: --
479: -- Fix for bug 3882918. If this proc is called without leaving_reason parameter
480: -- then no need to check further as it means, user doesn't want to change this value.
484: --
485: -- Bug number 4900409 - validating actual termination date cannot be future date
486: -- if leaving reason is 'D' Deceased
487:
488: IF nvl(p_leaving_reason,hr_api.g_varchar2)='D' AND
489: (per_pds_shd.g_old_rec.actual_termination_date > SYSDATE) THEN
490:
491: hr_utility.set_location('Update_pds_details ',812);
492: fnd_message.set_name('PER','PER_449766_NO_FUT_ACTUAL_TERM');
497: hr_utility.set_location('Update_pds_details ',818);
498:
499: -- End of changes for 4900409
500:
501: IF not (p_leaving_reason = hr_api.g_varchar2 and p_leaving_reason is not null) THEN
502: --
503: hr_utility.set_location('Update_pds_details ',820);
504: --
505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
501: IF not (p_leaving_reason = hr_api.g_varchar2 and p_leaving_reason is not null) THEN
502: --
503: hr_utility.set_location('Update_pds_details ',820);
504: --
505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )
507: then
508:
509: hr_utility.set_location('Update_pds_details ',900);
502: --
503: hr_utility.set_location('Update_pds_details ',820);
504: --
505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )
507: then
508:
509: hr_utility.set_location('Update_pds_details ',900);
510:
519: ,p_object_version_number=> l_ptu_object_version_number
520: ,p_effective_start_date => l_effective_start_date
521: ,p_effective_end_date => l_effective_end_date);
522:
523: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) <> 'R' and
524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )
525: then
526:
527: hr_utility.set_location('Update_pds_details ',910);
520: ,p_effective_start_date => l_effective_start_date
521: ,p_effective_end_date => l_effective_end_date);
522:
523: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) <> 'R' and
524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )
525: then
526:
527: hr_utility.set_location('Update_pds_details ',910);
528:
536: ,p_datetrack_delete_mode => 'ZAP');
537:
538: -- Fix for Bug 5152193 Starts here
539:
540: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) = 'D') then
541: open csr_get_pds_details;
542: fetch csr_get_pds_details into l_pds_rec;
543: close csr_get_pds_details;
544:
665: ,p_pds_information29 => p_pds_information29
666: ,p_pds_information30 => p_pds_information30
667: );
668: exception
669: when hr_api.cannot_find_prog_unit then
670: hr_api.cannot_find_prog_unit_error
671: (p_module_name => 'UPDATE_PDS_DETAILS',
672: p_hook_type => 'AP'
673: );
666: ,p_pds_information30 => p_pds_information30
667: );
668: exception
669: when hr_api.cannot_find_prog_unit then
670: hr_api.cannot_find_prog_unit_error
671: (p_module_name => 'UPDATE_PDS_DETAILS',
672: p_hook_type => 'AP'
673: );
674: end;
673: );
674: end;
675: --
676: if p_validate then
677: raise hr_api.validate_enabled;
678: end if;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 8);
681: --
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 8);
681: --
682: exception
683: when hr_api.validate_enabled then
684: --
685: -- As the Validate_Enabled exception has been raised
686: -- we must rollback to the savepoint
687: --
1009: AND p_new_final_process_date > p_old_final_process_date
1010: THEN
1011: l_new_final_process_date := p_new_final_process_date;
1012: ELSE
1013: l_new_final_process_date := hr_api.g_eot;
1014: END IF;
1015: --
1016: -- Lock assignment records
1017: --