DBA Data[Home] [Help]

APPS.HR_PERIODS_OF_SERVICE_API dependencies on HR_API

Line 16: ,p_termination_accepted_person in number default hr_api.g_number

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

Line 17: ,p_accepted_termination_date in date default hr_api.g_date

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

Line 19: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

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

Line 21: ,p_notified_termination_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

Line 22: ,p_projected_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
26: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 23: ,p_actual_termination_date in date default hr_api.g_date

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

Line 24: ,p_last_standard_process_date in date default hr_api.g_date

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

Line 25: ,p_final_process_date in date default hr_api.g_date

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

Line 26: ,p_attribute_category 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

Line 27: ,p_attribute1 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

Line 28: ,p_attribute2 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

Line 29: ,p_attribute3 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

Line 30: ,p_attribute4 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

Line 31: ,p_attribute5 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

Line 32: ,p_attribute6 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

Line 33: ,p_attribute7 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

Line 34: ,p_attribute8 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

Line 35: ,p_attribute9 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

Line 36: ,p_attribute10 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

Line 37: ,p_attribute11 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

Line 38: ,p_attribute12 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

Line 39: ,p_attribute13 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

Line 40: ,p_attribute14 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

Line 41: ,p_attribute15 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

Line 42: ,p_attribute16 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

Line 43: ,p_attribute17 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

Line 44: ,p_attribute18 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

Line 45: ,p_attribute19 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

Line 46: ,p_attribute20 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

Line 47: ,p_pds_information_category 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

Line 48: ,p_pds_information1 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

Line 49: ,p_pds_information2 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

Line 50: ,p_pds_information3 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

Line 51: ,p_pds_information4 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

Line 52: ,p_pds_information5 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

Line 53: ,p_pds_information6 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

Line 54: ,p_pds_information7 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

Line 55: ,p_pds_information8 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

Line 56: ,p_pds_information9 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

Line 57: ,p_pds_information10 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

Line 58: ,p_pds_information11 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

Line 59: ,p_pds_information12 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

Line 60: ,p_pds_information13 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

Line 61: ,p_pds_information14 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

Line 62: ,p_pds_information15 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

Line 63: ,p_pds_information16 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

Line 64: ,p_pds_information17 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

Line 65: ,p_pds_information18 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

Line 66: ,p_pds_information19 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

Line 67: ,p_pds_information20 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

Line 68: ,p_pds_information21 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

Line 69: ,p_pds_information22 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

Line 70: ,p_pds_information23 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

Line 71: ,p_pds_information24 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

Line 72: ,p_pds_information25 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

Line 73: ,p_pds_information26 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

Line 74: ,p_pds_information27 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

Line 75: ,p_pds_information28 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
79: --

Line 76: ,p_pds_information29 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: --
80: l_org_now_no_manager_warning BOOLEAN := FALSE;

Line 77: ,p_pds_information30 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;
81: l_asg_future_changes_warning BOOLEAN := FALSE;

Line 167: ,p_termination_accepted_person in number default hr_api.g_number

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

Line 168: ,p_accepted_termination_date in date default hr_api.g_date

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

Line 170: ,p_comments in varchar2 default hr_api.g_varchar2

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: --

Line 171: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

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)

Line 172: ,p_notified_termination_date in date default hr_api.g_date

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: --

Line 173: ,p_projected_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: --
177: ,p_actual_termination_date in date default hr_api.g_date

Line 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)

Line 178: ,p_last_standard_process_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)
182: --

Line 179: ,p_final_process_date in date default hr_api.g_date

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

Line 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

Line 184: ,p_attribute1 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

Line 185: ,p_attribute2 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

Line 186: ,p_attribute3 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

Line 187: ,p_attribute4 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

Line 188: ,p_attribute5 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

Line 189: ,p_attribute6 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

Line 190: ,p_attribute7 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

Line 191: ,p_attribute8 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

Line 192: ,p_attribute9 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

Line 193: ,p_attribute10 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

Line 194: ,p_attribute11 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

Line 195: ,p_attribute12 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

Line 196: ,p_attribute13 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

Line 197: ,p_attribute14 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

Line 198: ,p_attribute15 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

Line 199: ,p_attribute16 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

Line 200: ,p_attribute17 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

Line 201: ,p_attribute18 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

Line 202: ,p_attribute19 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

Line 203: ,p_attribute20 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

Line 204: ,p_pds_information_category 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

Line 205: ,p_pds_information1 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

Line 206: ,p_pds_information2 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

Line 207: ,p_pds_information3 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

Line 208: ,p_pds_information4 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

Line 209: ,p_pds_information5 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

Line 210: ,p_pds_information6 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

Line 211: ,p_pds_information7 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

Line 212: ,p_pds_information8 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

Line 213: ,p_pds_information9 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

Line 214: ,p_pds_information10 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

Line 215: ,p_pds_information11 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

Line 216: ,p_pds_information12 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

Line 217: ,p_pds_information13 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

Line 218: ,p_pds_information14 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

Line 219: ,p_pds_information15 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

Line 220: ,p_pds_information16 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

Line 221: ,p_pds_information17 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

Line 222: ,p_pds_information18 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

Line 223: ,p_pds_information19 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

Line 224: ,p_pds_information20 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

Line 225: ,p_pds_information21 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

Line 226: ,p_pds_information22 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

Line 227: ,p_pds_information23 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

Line 228: ,p_pds_information24 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

Line 229: ,p_pds_information25 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

Line 230: ,p_pds_information26 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

Line 231: ,p_pds_information27 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: --

Line 232: ,p_pds_information28 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: --
236: -- 115.9 (START)

Line 233: ,p_pds_information29 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)
237: --

Line 234: ,p_pds_information30 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: --
238: ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN

Line 364: when hr_api.cannot_find_prog_unit then

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: );

Line 365: hr_api.cannot_find_prog_unit_error

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;

Line 475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)

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

Line 476: <> nvl(p_leaving_reason,hr_api.g_varchar2)

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.

Line 488: IF nvl(p_leaving_reason,hr_api.g_varchar2)='D' AND

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');

Line 501: IF not (p_leaving_reason = hr_api.g_varchar2 and p_leaving_reason is not null) THEN

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

Line 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);

Line 506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )

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:

Line 523: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) <> 'R' and

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);

Line 524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )

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:

Line 540: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) = 'D') then

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:

Line 669: when hr_api.cannot_find_prog_unit then

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: );

Line 670: hr_api.cannot_find_prog_unit_error

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;

Line 677: raise hr_api.validate_enabled;

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: --

Line 683: when hr_api.validate_enabled then

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: --

Line 1038: l_new_final_process_date := hr_api.g_eot;

1034: AND p_new_final_process_date > p_old_final_process_date
1035: THEN
1036: l_new_final_process_date := p_new_final_process_date;
1037: ELSE
1038: l_new_final_process_date := hr_api.g_eot;
1039: END IF;
1040: --
1041: -- Lock assignment records
1042: --