14: procedure update_sa_pds_details
15: (p_validate in boolean default false
16: ,p_effective_date in date
17: ,p_period_of_service_id in number
18: ,p_termination_accepted_person in number default hr_api.g_number
19: ,p_accepted_termination_date in date default hr_api.g_date
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
15: (p_validate in boolean default false
16: ,p_effective_date in date
17: ,p_period_of_service_id in number
18: ,p_termination_accepted_person in number default hr_api.g_number
19: ,p_accepted_termination_date in date default hr_api.g_date
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
17: ,p_period_of_service_id in number
18: ,p_termination_accepted_person in number default hr_api.g_number
19: ,p_accepted_termination_date in date default hr_api.g_date
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
18: ,p_termination_accepted_person in number default hr_api.g_number
19: ,p_accepted_termination_date in date default hr_api.g_date
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
19: ,p_accepted_termination_date in date default hr_api.g_date
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
20: ,p_object_version_number in out nocopy number
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
21: ,p_comments in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
22: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
23: ,p_notified_termination_date in date default hr_api.g_date
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
24: ,p_projected_termination_date in date default hr_api.g_date
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
25: ,p_attribute_category in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
26: ,p_attribute1 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
27: ,p_attribute2 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
28: ,p_attribute3 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
29: ,p_attribute4 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
30: ,p_attribute5 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
31: ,p_attribute6 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
32: ,p_attribute7 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
33: ,p_attribute8 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
34: ,p_attribute9 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
35: ,p_attribute10 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
36: ,p_attribute11 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
37: ,p_attribute12 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
38: ,p_attribute13 in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
46: ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
39: ,p_attribute14 in varchar2 default hr_api.g_varchar2
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
46: ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
47: ) is
40: ,p_attribute15 in varchar2 default hr_api.g_varchar2
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
46: ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
47: ) is
48: --
41: ,p_attribute16 in varchar2 default hr_api.g_varchar2
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
46: ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
47: ) is
48: --
49: -- Declare cursors and local variables
42: ,p_attribute17 in varchar2 default hr_api.g_varchar2
43: ,p_attribute18 in varchar2 default hr_api.g_varchar2
44: ,p_attribute19 in varchar2 default hr_api.g_varchar2
45: ,p_attribute20 in varchar2 default hr_api.g_varchar2
46: ,p_hijrah_termination_date in varchar2 default hr_api.g_varchar2
47: ) is
48: --
49: -- Declare cursors and local variables
50: --