APPS.HR_PERSON_ATT dependencies on HR_API

Line 16: ,p_person_type_id in number default hr_api.g_number

12: ,p_effective_date in date
13: ,p_attribute_update_mode in varchar2
14: ,p_person_id in number
15: ,p_object_version_number in out nocopy number
16: ,p_person_type_id in number default hr_api.g_number
17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date

Line 17: ,p_last_name in varchar2 default hr_api.g_varchar2

13: ,p_attribute_update_mode in varchar2
14: ,p_person_id in number
15: ,p_object_version_number in out nocopy number
16: ,p_person_type_id in number default hr_api.g_number
17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date

Line 18: ,p_applicant_number in varchar2 default hr_api.g_varchar2

14: ,p_person_id in number
15: ,p_object_version_number in out nocopy number
16: ,p_person_type_id in number default hr_api.g_number
17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 19: ,p_comments in varchar2 default hr_api.g_varchar2

15: ,p_object_version_number in out nocopy number
16: ,p_person_type_id in number default hr_api.g_number
17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2

Line 20: ,p_date_employee_data_verified in date default hr_api.g_date

16: ,p_person_type_id in number default hr_api.g_number
17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 21: ,p_date_of_birth in date default hr_api.g_date

17: ,p_last_name in varchar2 default hr_api.g_varchar2
18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 22: ,p_email_address in varchar2 default hr_api.g_varchar2

18: ,p_applicant_number in varchar2 default hr_api.g_varchar2
19: ,p_comments in varchar2 default hr_api.g_varchar2
20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2

Line 24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

20: ,p_date_employee_data_verified in date default hr_api.g_date
21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2

Line 25: ,p_first_name in varchar2 default hr_api.g_varchar2

21: ,p_date_of_birth in date default hr_api.g_date
22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2

Line 26: ,p_known_as in varchar2 default hr_api.g_varchar2

22: ,p_email_address in varchar2 default hr_api.g_varchar2
23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2

Line 27: ,p_marital_status in varchar2 default hr_api.g_varchar2

23: ,p_employee_number in out nocopy varchar2
24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

Line 28: ,p_middle_names in varchar2 default hr_api.g_varchar2

24: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 29: ,p_nationality in varchar2 default hr_api.g_varchar2

25: ,p_first_name in varchar2 default hr_api.g_varchar2
26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2

Line 30: ,p_national_identifier in varchar2 default hr_api.g_varchar2

26: ,p_known_as in varchar2 default hr_api.g_varchar2
27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2

Line 31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

27: ,p_marital_status in varchar2 default hr_api.g_varchar2
28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number

Line 32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

28: ,p_middle_names in varchar2 default hr_api.g_varchar2
29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 33: ,p_sex in varchar2 default hr_api.g_varchar2

29: ,p_nationality in varchar2 default hr_api.g_varchar2
30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2

Line 34: ,p_title in varchar2 default hr_api.g_varchar2

30: ,p_national_identifier in varchar2 default hr_api.g_varchar2
31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 35: ,p_vendor_id in number default hr_api.g_number

31: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 36: ,p_work_telephone in varchar2 default hr_api.g_varchar2

32: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 37: ,p_suffix in varchar2 default hr_api.g_varchar2

33: ,p_sex in varchar2 default hr_api.g_varchar2
34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 38: ,p_attribute_category in varchar2 default hr_api.g_varchar2

34: ,p_title in varchar2 default hr_api.g_varchar2
35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 39: ,p_attribute1 in varchar2 default hr_api.g_varchar2

35: ,p_vendor_id in number default hr_api.g_number
36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 40: ,p_attribute2 in varchar2 default hr_api.g_varchar2

36: ,p_work_telephone in varchar2 default hr_api.g_varchar2
37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 41: ,p_attribute3 in varchar2 default hr_api.g_varchar2

37: ,p_suffix in varchar2 default hr_api.g_varchar2
38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 42: ,p_attribute4 in varchar2 default hr_api.g_varchar2

38: ,p_attribute_category in varchar2 default hr_api.g_varchar2
39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 43: ,p_attribute5 in varchar2 default hr_api.g_varchar2

39: ,p_attribute1 in varchar2 default hr_api.g_varchar2
40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 44: ,p_attribute6 in varchar2 default hr_api.g_varchar2

40: ,p_attribute2 in varchar2 default hr_api.g_varchar2
41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 45: ,p_attribute7 in varchar2 default hr_api.g_varchar2

41: ,p_attribute3 in varchar2 default hr_api.g_varchar2
42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 46: ,p_attribute8 in varchar2 default hr_api.g_varchar2

42: ,p_attribute4 in varchar2 default hr_api.g_varchar2
43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 47: ,p_attribute9 in varchar2 default hr_api.g_varchar2

43: ,p_attribute5 in varchar2 default hr_api.g_varchar2
44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 48: ,p_attribute10 in varchar2 default hr_api.g_varchar2

44: ,p_attribute6 in varchar2 default hr_api.g_varchar2
45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 49: ,p_attribute11 in varchar2 default hr_api.g_varchar2

45: ,p_attribute7 in varchar2 default hr_api.g_varchar2
46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 50: ,p_attribute12 in varchar2 default hr_api.g_varchar2

46: ,p_attribute8 in varchar2 default hr_api.g_varchar2
47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 51: ,p_attribute13 in varchar2 default hr_api.g_varchar2

47: ,p_attribute9 in varchar2 default hr_api.g_varchar2
48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 52: ,p_attribute14 in varchar2 default hr_api.g_varchar2

48: ,p_attribute10 in varchar2 default hr_api.g_varchar2
49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 53: ,p_attribute15 in varchar2 default hr_api.g_varchar2

49: ,p_attribute11 in varchar2 default hr_api.g_varchar2
50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 54: ,p_attribute16 in varchar2 default hr_api.g_varchar2

50: ,p_attribute12 in varchar2 default hr_api.g_varchar2
51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 55: ,p_attribute17 in varchar2 default hr_api.g_varchar2

51: ,p_attribute13 in varchar2 default hr_api.g_varchar2
52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 56: ,p_attribute18 in varchar2 default hr_api.g_varchar2

52: ,p_attribute14 in varchar2 default hr_api.g_varchar2
53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 57: ,p_attribute19 in varchar2 default hr_api.g_varchar2

53: ,p_attribute15 in varchar2 default hr_api.g_varchar2
54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 58: ,p_attribute20 in varchar2 default hr_api.g_varchar2

54: ,p_attribute16 in varchar2 default hr_api.g_varchar2
55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 59: ,p_attribute21 in varchar2 default hr_api.g_varchar2

55: ,p_attribute17 in varchar2 default hr_api.g_varchar2
56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 60: ,p_attribute22 in varchar2 default hr_api.g_varchar2

56: ,p_attribute18 in varchar2 default hr_api.g_varchar2
57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 61: ,p_attribute23 in varchar2 default hr_api.g_varchar2

57: ,p_attribute19 in varchar2 default hr_api.g_varchar2
58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 62: ,p_attribute24 in varchar2 default hr_api.g_varchar2

58: ,p_attribute20 in varchar2 default hr_api.g_varchar2
59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 63: ,p_attribute25 in varchar2 default hr_api.g_varchar2

59: ,p_attribute21 in varchar2 default hr_api.g_varchar2
60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 64: ,p_attribute26 in varchar2 default hr_api.g_varchar2

60: ,p_attribute22 in varchar2 default hr_api.g_varchar2
61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 65: ,p_attribute27 in varchar2 default hr_api.g_varchar2

61: ,p_attribute23 in varchar2 default hr_api.g_varchar2
62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 66: ,p_attribute28 in varchar2 default hr_api.g_varchar2

62: ,p_attribute24 in varchar2 default hr_api.g_varchar2
63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 67: ,p_attribute29 in varchar2 default hr_api.g_varchar2

63: ,p_attribute25 in varchar2 default hr_api.g_varchar2
64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 68: ,p_attribute30 in varchar2 default hr_api.g_varchar2

64: ,p_attribute26 in varchar2 default hr_api.g_varchar2
65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 69: ,p_per_information_category in varchar2 default hr_api.g_varchar2

65: ,p_attribute27 in varchar2 default hr_api.g_varchar2
66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 70: ,p_per_information1 in varchar2 default hr_api.g_varchar2

66: ,p_attribute28 in varchar2 default hr_api.g_varchar2
67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 71: ,p_per_information2 in varchar2 default hr_api.g_varchar2

67: ,p_attribute29 in varchar2 default hr_api.g_varchar2
68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 72: ,p_per_information3 in varchar2 default hr_api.g_varchar2

68: ,p_attribute30 in varchar2 default hr_api.g_varchar2
69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 73: ,p_per_information4 in varchar2 default hr_api.g_varchar2

69: ,p_per_information_category in varchar2 default hr_api.g_varchar2
70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 74: ,p_per_information5 in varchar2 default hr_api.g_varchar2

70: ,p_per_information1 in varchar2 default hr_api.g_varchar2
71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 75: ,p_per_information6 in varchar2 default hr_api.g_varchar2

71: ,p_per_information2 in varchar2 default hr_api.g_varchar2
72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 76: ,p_per_information7 in varchar2 default hr_api.g_varchar2

72: ,p_per_information3 in varchar2 default hr_api.g_varchar2
73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 77: ,p_per_information8 in varchar2 default hr_api.g_varchar2

73: ,p_per_information4 in varchar2 default hr_api.g_varchar2
74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 78: ,p_per_information9 in varchar2 default hr_api.g_varchar2

74: ,p_per_information5 in varchar2 default hr_api.g_varchar2
75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 79: ,p_per_information10 in varchar2 default hr_api.g_varchar2

75: ,p_per_information6 in varchar2 default hr_api.g_varchar2
76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 80: ,p_per_information11 in varchar2 default hr_api.g_varchar2

76: ,p_per_information7 in varchar2 default hr_api.g_varchar2
77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 81: ,p_per_information12 in varchar2 default hr_api.g_varchar2

77: ,p_per_information8 in varchar2 default hr_api.g_varchar2
78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 82: ,p_per_information13 in varchar2 default hr_api.g_varchar2

78: ,p_per_information9 in varchar2 default hr_api.g_varchar2
79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 83: ,p_per_information14 in varchar2 default hr_api.g_varchar2

79: ,p_per_information10 in varchar2 default hr_api.g_varchar2
80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 84: ,p_per_information15 in varchar2 default hr_api.g_varchar2

80: ,p_per_information11 in varchar2 default hr_api.g_varchar2
81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 85: ,p_per_information16 in varchar2 default hr_api.g_varchar2

81: ,p_per_information12 in varchar2 default hr_api.g_varchar2
82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 86: ,p_per_information17 in varchar2 default hr_api.g_varchar2

82: ,p_per_information13 in varchar2 default hr_api.g_varchar2
83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 87: ,p_per_information18 in varchar2 default hr_api.g_varchar2

83: ,p_per_information14 in varchar2 default hr_api.g_varchar2
84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 88: ,p_per_information19 in varchar2 default hr_api.g_varchar2

84: ,p_per_information15 in varchar2 default hr_api.g_varchar2
85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 89: ,p_per_information20 in varchar2 default hr_api.g_varchar2

85: ,p_per_information16 in varchar2 default hr_api.g_varchar2
86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 90: ,p_per_information21 in varchar2 default hr_api.g_varchar2

86: ,p_per_information17 in varchar2 default hr_api.g_varchar2
87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 91: ,p_per_information22 in varchar2 default hr_api.g_varchar2

87: ,p_per_information18 in varchar2 default hr_api.g_varchar2
88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 92: ,p_per_information23 in varchar2 default hr_api.g_varchar2

88: ,p_per_information19 in varchar2 default hr_api.g_varchar2
89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 93: ,p_per_information24 in varchar2 default hr_api.g_varchar2

89: ,p_per_information20 in varchar2 default hr_api.g_varchar2
90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 94: ,p_per_information25 in varchar2 default hr_api.g_varchar2

90: ,p_per_information21 in varchar2 default hr_api.g_varchar2
91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 95: ,p_per_information26 in varchar2 default hr_api.g_varchar2

91: ,p_per_information22 in varchar2 default hr_api.g_varchar2
92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 96: ,p_per_information27 in varchar2 default hr_api.g_varchar2

92: ,p_per_information23 in varchar2 default hr_api.g_varchar2
93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date

Line 97: ,p_per_information28 in varchar2 default hr_api.g_varchar2

93: ,p_per_information24 in varchar2 default hr_api.g_varchar2
94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 98: ,p_per_information29 in varchar2 default hr_api.g_varchar2

94: ,p_per_information25 in varchar2 default hr_api.g_varchar2
95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date

Line 99: ,p_per_information30 in varchar2 default hr_api.g_varchar2

95: ,p_per_information26 in varchar2 default hr_api.g_varchar2
96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 100: ,p_date_of_death in date default hr_api.g_date

96: ,p_per_information27 in varchar2 default hr_api.g_varchar2
97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 101: ,p_background_check_status in varchar2 default hr_api.g_varchar2

97: ,p_per_information28 in varchar2 default hr_api.g_varchar2
98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 102: ,p_background_date_check in date default hr_api.g_date

98: ,p_per_information29 in varchar2 default hr_api.g_varchar2
99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number

Line 103: ,p_blood_type in varchar2 default hr_api.g_varchar2

99: ,p_per_information30 in varchar2 default hr_api.g_varchar2
100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

100: ,p_date_of_death in date default hr_api.g_date
101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2

Line 105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

101: ,p_background_check_status in varchar2 default hr_api.g_varchar2
102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 106: ,p_fte_capacity in number default hr_api.g_number

102: ,p_background_date_check in date default hr_api.g_date
103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 107: ,p_hold_applicant_date_until in date default hr_api.g_date

103: ,p_blood_type in varchar2 default hr_api.g_varchar2
104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date

Line 108: ,p_honors in varchar2 default hr_api.g_varchar2

104: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 109: ,p_internal_location in varchar2 default hr_api.g_varchar2

105: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

106: ,p_fte_capacity in number default hr_api.g_number
107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 111: ,p_last_medical_test_date in date default hr_api.g_date

107: ,p_hold_applicant_date_until in date default hr_api.g_date
108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

Line 112: ,p_mailstop in varchar2 default hr_api.g_varchar2

108: ,p_honors in varchar2 default hr_api.g_varchar2
109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date

Line 113: ,p_office_number in varchar2 default hr_api.g_varchar2

109: ,p_internal_location in varchar2 default hr_api.g_varchar2
110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 114: ,p_on_military_service in varchar2 default hr_api.g_varchar2

110: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

111: ,p_last_medical_test_date in date default hr_api.g_date
112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 116: ,p_projected_start_date in date default hr_api.g_date

112: ,p_mailstop in varchar2 default hr_api.g_varchar2
113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date

Line 117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

113: ,p_office_number in varchar2 default hr_api.g_varchar2
114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

114: ,p_on_military_service in varchar2 default hr_api.g_varchar2
115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 119: ,p_resume_exists in varchar2 default hr_api.g_varchar2

115: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 120: ,p_resume_last_updated in date default hr_api.g_date

116: ,p_projected_start_date in date default hr_api.g_date
117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

117: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number

Line 122: ,p_student_status in varchar2 default hr_api.g_varchar2

118: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 123: ,p_work_schedule in varchar2 default hr_api.g_varchar2

119: ,p_resume_exists in varchar2 default hr_api.g_varchar2
120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

120: ,p_resume_last_updated in date default hr_api.g_date
121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 125: ,p_benefit_group_id in number default hr_api.g_number

121: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 126: ,p_receipt_of_death_cert_date in date default hr_api.g_date

122: ,p_student_status in varchar2 default hr_api.g_varchar2
123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

123: ,p_work_schedule in varchar2 default hr_api.g_varchar2
124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

124: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date

Line 129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

125: ,p_benefit_group_id in number default hr_api.g_number
126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 130: ,p_dpdnt_adoption_date in date default hr_api.g_date

126: ,p_receipt_of_death_cert_date in date default hr_api.g_date
127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

127: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 132: ,p_original_date_of_hire in date default hr_api.g_date

128: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
136: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

129: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
136: ,p_global_person_id in varchar2 default hr_api.g_varchar2
137: ,p_effective_start_date out nocopy date

Line 134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

130: ,p_dpdnt_adoption_date in date default hr_api.g_date
131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
136: ,p_global_person_id in varchar2 default hr_api.g_varchar2
137: ,p_effective_start_date out nocopy date
138: ,p_effective_end_date out nocopy date

Line 135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

131: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
136: ,p_global_person_id in varchar2 default hr_api.g_varchar2
137: ,p_effective_start_date out nocopy date
138: ,p_effective_end_date out nocopy date
139: ,p_full_name out nocopy varchar2

Line 136: ,p_global_person_id in varchar2 default hr_api.g_varchar2

132: ,p_original_date_of_hire in date default hr_api.g_date
133: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
134: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
135: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
136: ,p_global_person_id in varchar2 default hr_api.g_varchar2
137: ,p_effective_start_date out nocopy date
138: ,p_effective_end_date out nocopy date
139: ,p_full_name out nocopy varchar2
140: ,p_comment_id out nocopy number

Line 627: ,c_person_type_id in number default hr_api.g_number

623: -- --------------------------------------------------------------------------
624: function process_row
625: (c_effective_start_date in date
626: ,c_object_version_number in number
627: ,c_person_type_id in number default hr_api.g_number
628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date

Line 628: ,c_last_name in varchar2 default hr_api.g_varchar2

624: function process_row
625: (c_effective_start_date in date
626: ,c_object_version_number in number
627: ,c_person_type_id in number default hr_api.g_number
628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date

Line 629: ,c_applicant_number in varchar2 default hr_api.g_varchar2

625: (c_effective_start_date in date
626: ,c_object_version_number in number
627: ,c_person_type_id in number default hr_api.g_number
628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2

Line 630: ,c_comments in varchar2 default hr_api.g_varchar2

626: ,c_object_version_number in number
627: ,c_person_type_id in number default hr_api.g_number
628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2

Line 631: ,c_date_employee_data_verified in date default hr_api.g_date

627: ,c_person_type_id in number default hr_api.g_number
628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 632: ,c_date_of_birth in date default hr_api.g_date

628: ,c_last_name in varchar2 default hr_api.g_varchar2
629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2

Line 633: ,c_email_address in varchar2 default hr_api.g_varchar2

629: ,c_applicant_number in varchar2 default hr_api.g_varchar2
630: ,c_comments in varchar2 default hr_api.g_varchar2
631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2

Line 635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

631: ,c_date_employee_data_verified in date default hr_api.g_date
632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2

Line 636: ,c_first_name in varchar2 default hr_api.g_varchar2

632: ,c_date_of_birth in date default hr_api.g_date
633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2

Line 637: ,c_known_as in varchar2 default hr_api.g_varchar2

633: ,c_email_address in varchar2 default hr_api.g_varchar2
634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2

Line 638: ,c_marital_status in varchar2 default hr_api.g_varchar2

634: ,c_employee_number in varchar2
635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2

Line 639: ,c_middle_names in varchar2 default hr_api.g_varchar2

635: ,c_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 640: ,c_nationality in varchar2 default hr_api.g_varchar2

636: ,c_first_name in varchar2 default hr_api.g_varchar2
637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2

Line 641: ,c_national_identifier in varchar2 default hr_api.g_varchar2

637: ,c_known_as in varchar2 default hr_api.g_varchar2
638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2

Line 642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2

638: ,c_marital_status in varchar2 default hr_api.g_varchar2
639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number

Line 643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2

639: ,c_middle_names in varchar2 default hr_api.g_varchar2
640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2

Line 644: ,c_sex in varchar2 default hr_api.g_varchar2

640: ,c_nationality in varchar2 default hr_api.g_varchar2
641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2

Line 645: ,c_title in varchar2 default hr_api.g_varchar2

641: ,c_national_identifier in varchar2 default hr_api.g_varchar2
642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2

Line 646: ,c_vendor_id in number default hr_api.g_number

642: ,c_previous_last_name in varchar2 default hr_api.g_varchar2
643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2

Line 647: ,c_work_telephone in varchar2 default hr_api.g_varchar2

643: ,c_registered_disabled_flag in varchar2 default hr_api.g_varchar2
644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2

Line 648: ,c_suffix in varchar2 default hr_api.g_varchar2

644: ,c_sex in varchar2 default hr_api.g_varchar2
645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2

Line 649: ,c_attribute_category in varchar2 default hr_api.g_varchar2

645: ,c_title in varchar2 default hr_api.g_varchar2
646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2

Line 650: ,c_attribute1 in varchar2 default hr_api.g_varchar2

646: ,c_vendor_id in number default hr_api.g_number
647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2

Line 651: ,c_attribute2 in varchar2 default hr_api.g_varchar2

647: ,c_work_telephone in varchar2 default hr_api.g_varchar2
648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2

Line 652: ,c_attribute3 in varchar2 default hr_api.g_varchar2

648: ,c_suffix in varchar2 default hr_api.g_varchar2
649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2

Line 653: ,c_attribute4 in varchar2 default hr_api.g_varchar2

649: ,c_attribute_category in varchar2 default hr_api.g_varchar2
650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2

Line 654: ,c_attribute5 in varchar2 default hr_api.g_varchar2

650: ,c_attribute1 in varchar2 default hr_api.g_varchar2
651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2

Line 655: ,c_attribute6 in varchar2 default hr_api.g_varchar2

651: ,c_attribute2 in varchar2 default hr_api.g_varchar2
652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2

Line 656: ,c_attribute7 in varchar2 default hr_api.g_varchar2

652: ,c_attribute3 in varchar2 default hr_api.g_varchar2
653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2

Line 657: ,c_attribute8 in varchar2 default hr_api.g_varchar2

653: ,c_attribute4 in varchar2 default hr_api.g_varchar2
654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2

Line 658: ,c_attribute9 in varchar2 default hr_api.g_varchar2

654: ,c_attribute5 in varchar2 default hr_api.g_varchar2
655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2

Line 659: ,c_attribute10 in varchar2 default hr_api.g_varchar2

655: ,c_attribute6 in varchar2 default hr_api.g_varchar2
656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2

Line 660: ,c_attribute11 in varchar2 default hr_api.g_varchar2

656: ,c_attribute7 in varchar2 default hr_api.g_varchar2
657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2

Line 661: ,c_attribute12 in varchar2 default hr_api.g_varchar2

657: ,c_attribute8 in varchar2 default hr_api.g_varchar2
658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2

Line 662: ,c_attribute13 in varchar2 default hr_api.g_varchar2

658: ,c_attribute9 in varchar2 default hr_api.g_varchar2
659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2

Line 663: ,c_attribute14 in varchar2 default hr_api.g_varchar2

659: ,c_attribute10 in varchar2 default hr_api.g_varchar2
660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2

Line 664: ,c_attribute15 in varchar2 default hr_api.g_varchar2

660: ,c_attribute11 in varchar2 default hr_api.g_varchar2
661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2

Line 665: ,c_attribute16 in varchar2 default hr_api.g_varchar2

661: ,c_attribute12 in varchar2 default hr_api.g_varchar2
662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2

Line 666: ,c_attribute17 in varchar2 default hr_api.g_varchar2

662: ,c_attribute13 in varchar2 default hr_api.g_varchar2
663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2

Line 667: ,c_attribute18 in varchar2 default hr_api.g_varchar2

663: ,c_attribute14 in varchar2 default hr_api.g_varchar2
664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2

Line 668: ,c_attribute19 in varchar2 default hr_api.g_varchar2

664: ,c_attribute15 in varchar2 default hr_api.g_varchar2
665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2

Line 669: ,c_attribute20 in varchar2 default hr_api.g_varchar2

665: ,c_attribute16 in varchar2 default hr_api.g_varchar2
666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2

Line 670: ,c_attribute21 in varchar2 default hr_api.g_varchar2

666: ,c_attribute17 in varchar2 default hr_api.g_varchar2
667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2

Line 671: ,c_attribute22 in varchar2 default hr_api.g_varchar2

667: ,c_attribute18 in varchar2 default hr_api.g_varchar2
668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2

Line 672: ,c_attribute23 in varchar2 default hr_api.g_varchar2

668: ,c_attribute19 in varchar2 default hr_api.g_varchar2
669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2

Line 673: ,c_attribute24 in varchar2 default hr_api.g_varchar2

669: ,c_attribute20 in varchar2 default hr_api.g_varchar2
670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2

Line 674: ,c_attribute25 in varchar2 default hr_api.g_varchar2

670: ,c_attribute21 in varchar2 default hr_api.g_varchar2
671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2

Line 675: ,c_attribute26 in varchar2 default hr_api.g_varchar2

671: ,c_attribute22 in varchar2 default hr_api.g_varchar2
672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2

Line 676: ,c_attribute27 in varchar2 default hr_api.g_varchar2

672: ,c_attribute23 in varchar2 default hr_api.g_varchar2
673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2

Line 677: ,c_attribute28 in varchar2 default hr_api.g_varchar2

673: ,c_attribute24 in varchar2 default hr_api.g_varchar2
674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2

Line 678: ,c_attribute29 in varchar2 default hr_api.g_varchar2

674: ,c_attribute25 in varchar2 default hr_api.g_varchar2
675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2

Line 679: ,c_attribute30 in varchar2 default hr_api.g_varchar2

675: ,c_attribute26 in varchar2 default hr_api.g_varchar2
676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2

Line 680: ,c_per_information_category in varchar2 default hr_api.g_varchar2

676: ,c_attribute27 in varchar2 default hr_api.g_varchar2
677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2

Line 681: ,c_per_information1 in varchar2 default hr_api.g_varchar2

677: ,c_attribute28 in varchar2 default hr_api.g_varchar2
678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2

Line 682: ,c_per_information2 in varchar2 default hr_api.g_varchar2

678: ,c_attribute29 in varchar2 default hr_api.g_varchar2
679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2

Line 683: ,c_per_information3 in varchar2 default hr_api.g_varchar2

679: ,c_attribute30 in varchar2 default hr_api.g_varchar2
680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2

Line 684: ,c_per_information4 in varchar2 default hr_api.g_varchar2

680: ,c_per_information_category in varchar2 default hr_api.g_varchar2
681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2

Line 685: ,c_per_information5 in varchar2 default hr_api.g_varchar2

681: ,c_per_information1 in varchar2 default hr_api.g_varchar2
682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2

Line 686: ,c_per_information6 in varchar2 default hr_api.g_varchar2

682: ,c_per_information2 in varchar2 default hr_api.g_varchar2
683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2

Line 687: ,c_per_information7 in varchar2 default hr_api.g_varchar2

683: ,c_per_information3 in varchar2 default hr_api.g_varchar2
684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2

Line 688: ,c_per_information8 in varchar2 default hr_api.g_varchar2

684: ,c_per_information4 in varchar2 default hr_api.g_varchar2
685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2

Line 689: ,c_per_information9 in varchar2 default hr_api.g_varchar2

685: ,c_per_information5 in varchar2 default hr_api.g_varchar2
686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2

Line 690: ,c_per_information10 in varchar2 default hr_api.g_varchar2

686: ,c_per_information6 in varchar2 default hr_api.g_varchar2
687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2

Line 691: ,c_per_information11 in varchar2 default hr_api.g_varchar2

687: ,c_per_information7 in varchar2 default hr_api.g_varchar2
688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2

Line 692: ,c_per_information12 in varchar2 default hr_api.g_varchar2

688: ,c_per_information8 in varchar2 default hr_api.g_varchar2
689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2

Line 693: ,c_per_information13 in varchar2 default hr_api.g_varchar2

689: ,c_per_information9 in varchar2 default hr_api.g_varchar2
690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2

Line 694: ,c_per_information14 in varchar2 default hr_api.g_varchar2

690: ,c_per_information10 in varchar2 default hr_api.g_varchar2
691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2

Line 695: ,c_per_information15 in varchar2 default hr_api.g_varchar2

691: ,c_per_information11 in varchar2 default hr_api.g_varchar2
692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2

Line 696: ,c_per_information16 in varchar2 default hr_api.g_varchar2

692: ,c_per_information12 in varchar2 default hr_api.g_varchar2
693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2

Line 697: ,c_per_information17 in varchar2 default hr_api.g_varchar2

693: ,c_per_information13 in varchar2 default hr_api.g_varchar2
694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2

Line 698: ,c_per_information18 in varchar2 default hr_api.g_varchar2

694: ,c_per_information14 in varchar2 default hr_api.g_varchar2
695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2

Line 699: ,c_per_information19 in varchar2 default hr_api.g_varchar2

695: ,c_per_information15 in varchar2 default hr_api.g_varchar2
696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2

Line 700: ,c_per_information20 in varchar2 default hr_api.g_varchar2

696: ,c_per_information16 in varchar2 default hr_api.g_varchar2
697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2

Line 701: ,c_per_information21 in varchar2 default hr_api.g_varchar2

697: ,c_per_information17 in varchar2 default hr_api.g_varchar2
698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2

Line 702: ,c_per_information22 in varchar2 default hr_api.g_varchar2

698: ,c_per_information18 in varchar2 default hr_api.g_varchar2
699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2

Line 703: ,c_per_information23 in varchar2 default hr_api.g_varchar2

699: ,c_per_information19 in varchar2 default hr_api.g_varchar2
700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2

Line 704: ,c_per_information24 in varchar2 default hr_api.g_varchar2

700: ,c_per_information20 in varchar2 default hr_api.g_varchar2
701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2

Line 705: ,c_per_information25 in varchar2 default hr_api.g_varchar2

701: ,c_per_information21 in varchar2 default hr_api.g_varchar2
702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2

Line 706: ,c_per_information26 in varchar2 default hr_api.g_varchar2

702: ,c_per_information22 in varchar2 default hr_api.g_varchar2
703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2

Line 707: ,c_per_information27 in varchar2 default hr_api.g_varchar2

703: ,c_per_information23 in varchar2 default hr_api.g_varchar2
704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date

Line 708: ,c_per_information28 in varchar2 default hr_api.g_varchar2

704: ,c_per_information24 in varchar2 default hr_api.g_varchar2
705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2

Line 709: ,c_per_information29 in varchar2 default hr_api.g_varchar2

705: ,c_per_information25 in varchar2 default hr_api.g_varchar2
706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date

Line 710: ,c_per_information30 in varchar2 default hr_api.g_varchar2

706: ,c_per_information26 in varchar2 default hr_api.g_varchar2
707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2

Line 711: ,c_date_of_death in date default hr_api.g_date

707: ,c_per_information27 in varchar2 default hr_api.g_varchar2
708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2

Line 712: ,c_background_check_status in varchar2 default hr_api.g_varchar2

708: ,c_per_information28 in varchar2 default hr_api.g_varchar2
709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 713: ,c_background_date_check in date default hr_api.g_date

709: ,c_per_information29 in varchar2 default hr_api.g_varchar2
710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number

Line 714: ,c_blood_type in varchar2 default hr_api.g_varchar2

710: ,c_per_information30 in varchar2 default hr_api.g_varchar2
711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date

Line 715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2

711: ,c_date_of_death in date default hr_api.g_date
712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2

Line 716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2

712: ,c_background_check_status in varchar2 default hr_api.g_varchar2
713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2

Line 717: ,c_fte_capacity in number default hr_api.g_number

713: ,c_background_date_check in date default hr_api.g_date
714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 718: ,c_hold_applicant_date_until in date default hr_api.g_date

714: ,c_blood_type in varchar2 default hr_api.g_varchar2
715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date

Line 719: ,c_honors in varchar2 default hr_api.g_varchar2

715: ,c_correspondence_language in varchar2 default hr_api.g_varchar2
716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2

Line 720: ,c_internal_location in varchar2 default hr_api.g_varchar2

716: ,c_fast_path_employee in varchar2 default hr_api.g_varchar2
717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2

Line 721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2

717: ,c_fte_capacity in number default hr_api.g_number
718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2

Line 722: ,c_last_medical_test_date in date default hr_api.g_date

718: ,c_hold_applicant_date_until in date default hr_api.g_date
719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2

Line 723: ,c_mailstop in varchar2 default hr_api.g_varchar2

719: ,c_honors in varchar2 default hr_api.g_varchar2
720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date

Line 724: ,c_office_number in varchar2 default hr_api.g_varchar2

720: ,c_internal_location in varchar2 default hr_api.g_varchar2
721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 725: ,c_on_military_service in varchar2 default hr_api.g_varchar2

721: ,c_last_medical_test_by in varchar2 default hr_api.g_varchar2
722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2

722: ,c_last_medical_test_date in date default hr_api.g_date
723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2

Line 727: ,c_projected_start_date in date default hr_api.g_date

723: ,c_mailstop in varchar2 default hr_api.g_varchar2
724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date

Line 728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2

724: ,c_office_number in varchar2 default hr_api.g_varchar2
725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2

725: ,c_on_military_service in varchar2 default hr_api.g_varchar2
726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2

Line 730: ,c_resume_exists in varchar2 default hr_api.g_varchar2

726: ,c_pre_name_adjunct in varchar2 default hr_api.g_varchar2
727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2

Line 731: ,c_resume_last_updated in date default hr_api.g_date

727: ,c_projected_start_date in date default hr_api.g_date
728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2

Line 732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2

728: ,c_rehire_authorizor in varchar2 default hr_api.g_varchar2
729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number

Line 733: ,c_student_status in varchar2 default hr_api.g_varchar2

729: ,c_rehire_recommendation in varchar2 default hr_api.g_varchar2
730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date

Line 734: ,c_work_schedule in varchar2 default hr_api.g_varchar2

730: ,c_resume_exists in varchar2 default hr_api.g_varchar2
731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2

731: ,c_resume_last_updated in date default hr_api.g_date
732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 736: ,c_benefit_group_id in number default hr_api.g_number

732: ,c_second_passport_exists in varchar2 default hr_api.g_varchar2
733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 737: ,c_receipt_of_death_cert_date in date default hr_api.g_date

733: ,c_student_status in varchar2 default hr_api.g_varchar2
734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date

Line 738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

734: ,c_work_schedule in varchar2 default hr_api.g_varchar2
735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

735: ,c_rehire_reason in varchar2 default hr_api.g_varchar2
736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date

Line 740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

736: ,c_benefit_group_id in number default hr_api.g_number
737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2

Line 741: ,c_dpdnt_adoption_date in date default hr_api.g_date

737: ,c_receipt_of_death_cert_date in date default hr_api.g_date
738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2

Line 742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

738: ,c_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2

Line 743: ,c_original_date_of_hire in date default hr_api.g_date

739: ,c_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2
747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )

Line 744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2

740: ,c_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2
747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )
748: return boolean is

Line 745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2

741: ,c_dpdnt_adoption_date in date default hr_api.g_date
742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2
747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )
748: return boolean is
749: l_proc varchar2(72) := g_package||'process_row';

Line 746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2

742: ,c_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2
747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )
748: return boolean is
749: l_proc varchar2(72) := g_package||'process_row';
750: begin

Line 747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )

743: ,c_original_date_of_hire in date default hr_api.g_date
744: ,c_town_of_birth in varchar2 default hr_api.g_varchar2
745: ,c_region_of_birth in varchar2 default hr_api.g_varchar2
746: ,c_country_of_birth in varchar2 default hr_api.g_varchar2
747: ,c_global_person_id in varchar2 default hr_api.g_varchar2 )
748: return boolean is
749: l_proc varchar2(72) := g_package||'process_row';
750: begin
751: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1514: l_datetrack_update_mode := hr_api.g_correction;

1510: if l_effective_date_row then
1511: -- reset the first row flag
1512: l_effective_date_row := false;
1513: -- set all future row operations to a CORRECTION
1514: l_datetrack_update_mode := hr_api.g_correction;
1515: -- set the API out parameters for the first transaction
1516: p_object_version_number := l_object_version_number;
1517: p_full_name := l_full_name;
1518: p_effective_start_date := l_effective_start_date;

Line 1558: ,p_datetrack_mode => hr_api.g_correction

1554: -- b) to populate the l_validation_start_date which is used
1555: -- in determining the correct datetrack mode on an update operation
1556: per_per_shd.lck
1557: (p_effective_date => l_constant_effective_date
1558: ,p_datetrack_mode => hr_api.g_correction
1559: ,p_person_id => p_person_id
1560: ,p_object_version_number => p_object_version_number
1561: ,p_validation_start_date => l_validation_start_date
1562: ,p_validation_end_date => l_validation_end_date);

Line 1590: l_datetrack_update_mode := hr_api.g_update;

1586: ,p_update_change_insert => l_update_change_insert);
1587: -- step 1.2
1588: if l_update then
1589: -- we can do an update
1590: l_datetrack_update_mode := hr_api.g_update;
1591: elsif l_update_change_insert then
1592: -- we can do an update change insert
1593: l_datetrack_update_mode := hr_api.g_update_change_insert;
1594: elsif (l_validation_start_date = l_constant_effective_date) and

Line 1593: l_datetrack_update_mode := hr_api.g_update_change_insert;

1589: -- we can do an update
1590: l_datetrack_update_mode := hr_api.g_update;
1591: elsif l_update_change_insert then
1592: -- we can do an update change insert
1593: l_datetrack_update_mode := hr_api.g_update_change_insert;
1594: elsif (l_validation_start_date = l_constant_effective_date) and
1595: l_correction then
1596: -- we can only perform a correction
1597: l_datetrack_update_mode := hr_api.g_correction;

Line 1597: l_datetrack_update_mode := hr_api.g_correction;

1593: l_datetrack_update_mode := hr_api.g_update_change_insert;
1594: elsif (l_validation_start_date = l_constant_effective_date) and
1595: l_correction then
1596: -- we can only perform a correction
1597: l_datetrack_update_mode := hr_api.g_correction;
1598: else
1599: -- we cannot perform an update due to a restriction within the APIs
1600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1601: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 1610: l_lck_start_date := hr_api.g_sot;

1606: l_lck_start_date := l_constant_effective_date;
1607: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1608: -- set lock start date to start of time and the datetrack mode
1609: -- to CORRECTION
1610: l_lck_start_date := hr_api.g_sot;
1611: l_datetrack_update_mode := hr_api.g_correction;
1612: else
1613: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1614: -- so raise DT invalid mode error

Line 1611: l_datetrack_update_mode := hr_api.g_correction;

1607: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1608: -- set lock start date to start of time and the datetrack mode
1609: -- to CORRECTION
1610: l_lck_start_date := hr_api.g_sot;
1611: l_datetrack_update_mode := hr_api.g_correction;
1612: else
1613: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1614: -- so raise DT invalid mode error
1615: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');

Line 1896: raise hr_api.validate_enabled;

1892: --
1893: -- When in validation only mode raise the Validate_Enabled exception
1894: --
1895: if p_validate then
1896: raise hr_api.validate_enabled;
1897: end if;
1898: -- set the warning OUT parameters
1899: p_name_combination_warning := l_api_name_combination_warning;
1900: p_assign_payroll_warning := l_api_assign_payroll_warning;

Line 1905: when hr_api.validate_enabled then

1901: p_orig_hire_warning := l_api_orig_hire_warning;
1902: --
1903: hr_utility.set_location(' Leaving:'||l_proc, 10);
1904: exception
1905: when hr_api.validate_enabled then
1906: --
1907: -- As the Validate_Enabled exception has been raised
1908: -- we must rollback to the savepoint
1909: --