APPS.HR_FR_PERIODS_OF_SERVICE_API dependencies on HR_API

Line 16: ,p_termination_accepted_person in number default hr_api.g_number

12: procedure update_fr_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_attribute_category in varchar2 default hr_api.g_varchar2

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_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 23: ,p_attribute_category in varchar2 default hr_api.g_varchar2

19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 24: ,p_attribute1 in varchar2 default hr_api.g_varchar2

20: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 25: ,p_attribute2 in varchar2 default hr_api.g_varchar2

21: ,p_notified_termination_date in date default hr_api.g_date
22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 26: ,p_attribute3 in varchar2 default hr_api.g_varchar2

22: ,p_projected_termination_date in date default hr_api.g_date
23: ,p_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 27: ,p_attribute4 in varchar2 default hr_api.g_varchar2

23: ,p_attribute_category in varchar2 default hr_api.g_varchar2
24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 28: ,p_attribute5 in varchar2 default hr_api.g_varchar2

24: ,p_attribute1 in varchar2 default hr_api.g_varchar2
25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 29: ,p_attribute6 in varchar2 default hr_api.g_varchar2

25: ,p_attribute2 in varchar2 default hr_api.g_varchar2
26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 30: ,p_attribute7 in varchar2 default hr_api.g_varchar2

26: ,p_attribute3 in varchar2 default hr_api.g_varchar2
27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 31: ,p_attribute8 in varchar2 default hr_api.g_varchar2

27: ,p_attribute4 in varchar2 default hr_api.g_varchar2
28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 32: ,p_attribute9 in varchar2 default hr_api.g_varchar2

28: ,p_attribute5 in varchar2 default hr_api.g_varchar2
29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 33: ,p_attribute10 in varchar2 default hr_api.g_varchar2

29: ,p_attribute6 in varchar2 default hr_api.g_varchar2
30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 34: ,p_attribute11 in varchar2 default hr_api.g_varchar2

30: ,p_attribute7 in varchar2 default hr_api.g_varchar2
31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 35: ,p_attribute12 in varchar2 default hr_api.g_varchar2

31: ,p_attribute8 in varchar2 default hr_api.g_varchar2
32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 36: ,p_attribute13 in varchar2 default hr_api.g_varchar2

32: ,p_attribute9 in varchar2 default hr_api.g_varchar2
33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 37: ,p_attribute14 in varchar2 default hr_api.g_varchar2

33: ,p_attribute10 in varchar2 default hr_api.g_varchar2
34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 38: ,p_attribute15 in varchar2 default hr_api.g_varchar2

34: ,p_attribute11 in varchar2 default hr_api.g_varchar2
35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 39: ,p_attribute16 in varchar2 default hr_api.g_varchar2

35: ,p_attribute12 in varchar2 default hr_api.g_varchar2
36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 40: ,p_attribute17 in varchar2 default hr_api.g_varchar2

36: ,p_attribute13 in varchar2 default hr_api.g_varchar2
37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2

Line 41: ,p_attribute18 in varchar2 default hr_api.g_varchar2

37: ,p_attribute14 in varchar2 default hr_api.g_varchar2
38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2

Line 42: ,p_attribute19 in varchar2 default hr_api.g_varchar2

38: ,p_attribute15 in varchar2 default hr_api.g_varchar2
39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2

Line 43: ,p_attribute20 in varchar2 default hr_api.g_varchar2

39: ,p_attribute16 in varchar2 default hr_api.g_varchar2
40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2

Line 44: ,p_starting_reason in varchar2 default hr_api.g_varchar2

40: ,p_attribute17 in varchar2 default hr_api.g_varchar2
41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2

Line 45: ,p_ending_reason in varchar2 default hr_api.g_varchar2

41: ,p_attribute18 in varchar2 default hr_api.g_varchar2
42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2

Line 46: ,p_qualification_level in varchar2 default hr_api.g_varchar2

42: ,p_attribute19 in varchar2 default hr_api.g_varchar2
43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2

Line 47: ,p_type_work in varchar2 default hr_api.g_varchar2

43: ,p_attribute20 in varchar2 default hr_api.g_varchar2
44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2

Line 48: ,p_employee_status in varchar2 default hr_api.g_varchar2

44: ,p_starting_reason in varchar2 default hr_api.g_varchar2
45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
52: ,p_social_plan in varchar2 default hr_api.g_varchar2

Line 49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2

45: ,p_ending_reason in varchar2 default hr_api.g_varchar2
46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
52: ,p_social_plan in varchar2 default hr_api.g_varchar2
53: ) is

Line 50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2

46: ,p_qualification_level in varchar2 default hr_api.g_varchar2
47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
52: ,p_social_plan in varchar2 default hr_api.g_varchar2
53: ) is
54: --

Line 51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2

47: ,p_type_work in varchar2 default hr_api.g_varchar2
48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
52: ,p_social_plan in varchar2 default hr_api.g_varchar2
53: ) is
54: --
55: -- Declare cursors and local variables

Line 52: ,p_social_plan in varchar2 default hr_api.g_varchar2

48: ,p_employee_status in varchar2 default hr_api.g_varchar2
49: ,p_affiliated_alsace_moselle in varchar2 default hr_api.g_varchar2
50: ,p_relationship_MD in varchar2 default hr_api.g_varchar2
51: ,p_final_payment_schedule in varchar2 default hr_api.g_varchar2
52: ,p_social_plan in varchar2 default hr_api.g_varchar2
53: ) is
54: --
55: -- Declare cursors and local variables
56: --