APPS.HR_PERSON_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE update_person
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_datetrack_update_mode in varchar2
30: ,p_person_id in number
31: ,p_object_version_number in out nocopy number

Line 32: ,p_person_type_id in number default hr_api.g_number

28: ,p_effective_date in date
29: ,p_datetrack_update_mode in varchar2
30: ,p_person_id in number
31: ,p_object_version_number in out nocopy number
32: ,p_person_type_id in number default hr_api.g_number
33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date

Line 33: ,p_last_name in varchar2 default hr_api.g_varchar2

29: ,p_datetrack_update_mode in varchar2
30: ,p_person_id in number
31: ,p_object_version_number in out nocopy number
32: ,p_person_type_id in number default hr_api.g_number
33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date

Line 34: ,p_applicant_number in varchar2 default hr_api.g_varchar2

30: ,p_person_id in number
31: ,p_object_version_number in out nocopy number
32: ,p_person_type_id in number default hr_api.g_number
33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 35: ,p_comments in varchar2 default hr_api.g_varchar2

31: ,p_object_version_number in out nocopy number
32: ,p_person_type_id in number default hr_api.g_number
33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2

Line 36: ,p_date_employee_data_verified in date default hr_api.g_date

32: ,p_person_type_id in number default hr_api.g_number
33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 37: ,p_date_of_birth in date default hr_api.g_date

33: ,p_last_name in varchar2 default hr_api.g_varchar2
34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 38: ,p_email_address in varchar2 default hr_api.g_varchar2

34: ,p_applicant_number in varchar2 default hr_api.g_varchar2
35: ,p_comments in varchar2 default hr_api.g_varchar2
36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2

Line 40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

36: ,p_date_employee_data_verified in date default hr_api.g_date
37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2

Line 41: ,p_first_name in varchar2 default hr_api.g_varchar2

37: ,p_date_of_birth in date default hr_api.g_date
38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2

Line 42: ,p_known_as in varchar2 default hr_api.g_varchar2

38: ,p_email_address in varchar2 default hr_api.g_varchar2
39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2

Line 43: ,p_marital_status in varchar2 default hr_api.g_varchar2

39: ,p_employee_number in out nocopy varchar2
40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

Line 44: ,p_middle_names in varchar2 default hr_api.g_varchar2

40: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 45: ,p_nationality in varchar2 default hr_api.g_varchar2

41: ,p_first_name in varchar2 default hr_api.g_varchar2
42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2

Line 46: ,p_national_identifier in varchar2 default hr_api.g_varchar2

42: ,p_known_as in varchar2 default hr_api.g_varchar2
43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2

Line 47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

43: ,p_marital_status in varchar2 default hr_api.g_varchar2
44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number

Line 48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

44: ,p_middle_names in varchar2 default hr_api.g_varchar2
45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 49: ,p_sex in varchar2 default hr_api.g_varchar2

45: ,p_nationality in varchar2 default hr_api.g_varchar2
46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 50: ,p_title in varchar2 default hr_api.g_varchar2

46: ,p_national_identifier in varchar2 default hr_api.g_varchar2
47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 51: ,p_vendor_id in number default hr_api.g_number

47: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 52: ,p_work_telephone in varchar2 default hr_api.g_varchar2

48: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 53: ,p_attribute_category in varchar2 default hr_api.g_varchar2

49: ,p_sex in varchar2 default hr_api.g_varchar2
50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 54: ,p_attribute1 in varchar2 default hr_api.g_varchar2

50: ,p_title in varchar2 default hr_api.g_varchar2
51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 55: ,p_attribute2 in varchar2 default hr_api.g_varchar2

51: ,p_vendor_id in number default hr_api.g_number
52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 56: ,p_attribute3 in varchar2 default hr_api.g_varchar2

52: ,p_work_telephone in varchar2 default hr_api.g_varchar2
53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 57: ,p_attribute4 in varchar2 default hr_api.g_varchar2

53: ,p_attribute_category in varchar2 default hr_api.g_varchar2
54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 58: ,p_attribute5 in varchar2 default hr_api.g_varchar2

54: ,p_attribute1 in varchar2 default hr_api.g_varchar2
55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 59: ,p_attribute6 in varchar2 default hr_api.g_varchar2

55: ,p_attribute2 in varchar2 default hr_api.g_varchar2
56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 60: ,p_attribute7 in varchar2 default hr_api.g_varchar2

56: ,p_attribute3 in varchar2 default hr_api.g_varchar2
57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 61: ,p_attribute8 in varchar2 default hr_api.g_varchar2

57: ,p_attribute4 in varchar2 default hr_api.g_varchar2
58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 62: ,p_attribute9 in varchar2 default hr_api.g_varchar2

58: ,p_attribute5 in varchar2 default hr_api.g_varchar2
59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 63: ,p_attribute10 in varchar2 default hr_api.g_varchar2

59: ,p_attribute6 in varchar2 default hr_api.g_varchar2
60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 64: ,p_attribute11 in varchar2 default hr_api.g_varchar2

60: ,p_attribute7 in varchar2 default hr_api.g_varchar2
61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 65: ,p_attribute12 in varchar2 default hr_api.g_varchar2

61: ,p_attribute8 in varchar2 default hr_api.g_varchar2
62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 66: ,p_attribute13 in varchar2 default hr_api.g_varchar2

62: ,p_attribute9 in varchar2 default hr_api.g_varchar2
63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 67: ,p_attribute14 in varchar2 default hr_api.g_varchar2

63: ,p_attribute10 in varchar2 default hr_api.g_varchar2
64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 68: ,p_attribute15 in varchar2 default hr_api.g_varchar2

64: ,p_attribute11 in varchar2 default hr_api.g_varchar2
65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 69: ,p_attribute16 in varchar2 default hr_api.g_varchar2

65: ,p_attribute12 in varchar2 default hr_api.g_varchar2
66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 70: ,p_attribute17 in varchar2 default hr_api.g_varchar2

66: ,p_attribute13 in varchar2 default hr_api.g_varchar2
67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 71: ,p_attribute18 in varchar2 default hr_api.g_varchar2

67: ,p_attribute14 in varchar2 default hr_api.g_varchar2
68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 72: ,p_attribute19 in varchar2 default hr_api.g_varchar2

68: ,p_attribute15 in varchar2 default hr_api.g_varchar2
69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 73: ,p_attribute20 in varchar2 default hr_api.g_varchar2

69: ,p_attribute16 in varchar2 default hr_api.g_varchar2
70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 74: ,p_attribute21 in varchar2 default hr_api.g_varchar2

70: ,p_attribute17 in varchar2 default hr_api.g_varchar2
71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 75: ,p_attribute22 in varchar2 default hr_api.g_varchar2

71: ,p_attribute18 in varchar2 default hr_api.g_varchar2
72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 76: ,p_attribute23 in varchar2 default hr_api.g_varchar2

72: ,p_attribute19 in varchar2 default hr_api.g_varchar2
73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 77: ,p_attribute24 in varchar2 default hr_api.g_varchar2

73: ,p_attribute20 in varchar2 default hr_api.g_varchar2
74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 78: ,p_attribute25 in varchar2 default hr_api.g_varchar2

74: ,p_attribute21 in varchar2 default hr_api.g_varchar2
75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 79: ,p_attribute26 in varchar2 default hr_api.g_varchar2

75: ,p_attribute22 in varchar2 default hr_api.g_varchar2
76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 80: ,p_attribute27 in varchar2 default hr_api.g_varchar2

76: ,p_attribute23 in varchar2 default hr_api.g_varchar2
77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 81: ,p_attribute28 in varchar2 default hr_api.g_varchar2

77: ,p_attribute24 in varchar2 default hr_api.g_varchar2
78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 82: ,p_attribute29 in varchar2 default hr_api.g_varchar2

78: ,p_attribute25 in varchar2 default hr_api.g_varchar2
79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 83: ,p_attribute30 in varchar2 default hr_api.g_varchar2

79: ,p_attribute26 in varchar2 default hr_api.g_varchar2
80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 84: ,p_per_information_category in varchar2 default hr_api.g_varchar2

80: ,p_attribute27 in varchar2 default hr_api.g_varchar2
81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 85: ,p_per_information1 in varchar2 default hr_api.g_varchar2

81: ,p_attribute28 in varchar2 default hr_api.g_varchar2
82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 86: ,p_per_information2 in varchar2 default hr_api.g_varchar2

82: ,p_attribute29 in varchar2 default hr_api.g_varchar2
83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 87: ,p_per_information3 in varchar2 default hr_api.g_varchar2

83: ,p_attribute30 in varchar2 default hr_api.g_varchar2
84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 88: ,p_per_information4 in varchar2 default hr_api.g_varchar2

84: ,p_per_information_category in varchar2 default hr_api.g_varchar2
85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 89: ,p_per_information5 in varchar2 default hr_api.g_varchar2

85: ,p_per_information1 in varchar2 default hr_api.g_varchar2
86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 90: ,p_per_information6 in varchar2 default hr_api.g_varchar2

86: ,p_per_information2 in varchar2 default hr_api.g_varchar2
87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 91: ,p_per_information7 in varchar2 default hr_api.g_varchar2

87: ,p_per_information3 in varchar2 default hr_api.g_varchar2
88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 92: ,p_per_information8 in varchar2 default hr_api.g_varchar2

88: ,p_per_information4 in varchar2 default hr_api.g_varchar2
89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 93: ,p_per_information9 in varchar2 default hr_api.g_varchar2

89: ,p_per_information5 in varchar2 default hr_api.g_varchar2
90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 94: ,p_per_information10 in varchar2 default hr_api.g_varchar2

90: ,p_per_information6 in varchar2 default hr_api.g_varchar2
91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 95: ,p_per_information11 in varchar2 default hr_api.g_varchar2

91: ,p_per_information7 in varchar2 default hr_api.g_varchar2
92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 96: ,p_per_information12 in varchar2 default hr_api.g_varchar2

92: ,p_per_information8 in varchar2 default hr_api.g_varchar2
93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 97: ,p_per_information13 in varchar2 default hr_api.g_varchar2

93: ,p_per_information9 in varchar2 default hr_api.g_varchar2
94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 98: ,p_per_information14 in varchar2 default hr_api.g_varchar2

94: ,p_per_information10 in varchar2 default hr_api.g_varchar2
95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 99: ,p_per_information15 in varchar2 default hr_api.g_varchar2

95: ,p_per_information11 in varchar2 default hr_api.g_varchar2
96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 100: ,p_per_information16 in varchar2 default hr_api.g_varchar2

96: ,p_per_information12 in varchar2 default hr_api.g_varchar2
97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 101: ,p_per_information17 in varchar2 default hr_api.g_varchar2

97: ,p_per_information13 in varchar2 default hr_api.g_varchar2
98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 102: ,p_per_information18 in varchar2 default hr_api.g_varchar2

98: ,p_per_information14 in varchar2 default hr_api.g_varchar2
99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 103: ,p_per_information19 in varchar2 default hr_api.g_varchar2

99: ,p_per_information15 in varchar2 default hr_api.g_varchar2
100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 104: ,p_per_information20 in varchar2 default hr_api.g_varchar2

100: ,p_per_information16 in varchar2 default hr_api.g_varchar2
101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 105: ,p_per_information21 in varchar2 default hr_api.g_varchar2

101: ,p_per_information17 in varchar2 default hr_api.g_varchar2
102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 106: ,p_per_information22 in varchar2 default hr_api.g_varchar2

102: ,p_per_information18 in varchar2 default hr_api.g_varchar2
103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 107: ,p_per_information23 in varchar2 default hr_api.g_varchar2

103: ,p_per_information19 in varchar2 default hr_api.g_varchar2
104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 108: ,p_per_information24 in varchar2 default hr_api.g_varchar2

104: ,p_per_information20 in varchar2 default hr_api.g_varchar2
105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 109: ,p_per_information25 in varchar2 default hr_api.g_varchar2

105: ,p_per_information21 in varchar2 default hr_api.g_varchar2
106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 110: ,p_per_information26 in varchar2 default hr_api.g_varchar2

106: ,p_per_information22 in varchar2 default hr_api.g_varchar2
107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 111: ,p_per_information27 in varchar2 default hr_api.g_varchar2

107: ,p_per_information23 in varchar2 default hr_api.g_varchar2
108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date

Line 112: ,p_per_information28 in varchar2 default hr_api.g_varchar2

108: ,p_per_information24 in varchar2 default hr_api.g_varchar2
109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 113: ,p_per_information29 in varchar2 default hr_api.g_varchar2

109: ,p_per_information25 in varchar2 default hr_api.g_varchar2
110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date

Line 114: ,p_per_information30 in varchar2 default hr_api.g_varchar2

110: ,p_per_information26 in varchar2 default hr_api.g_varchar2
111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 115: ,p_date_of_death in date default hr_api.g_date

111: ,p_per_information27 in varchar2 default hr_api.g_varchar2
112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 116: ,p_background_check_status in varchar2 default hr_api.g_varchar2

112: ,p_per_information28 in varchar2 default hr_api.g_varchar2
113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 117: ,p_background_date_check in date default hr_api.g_date

113: ,p_per_information29 in varchar2 default hr_api.g_varchar2
114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number

Line 118: ,p_blood_type in varchar2 default hr_api.g_varchar2

114: ,p_per_information30 in varchar2 default hr_api.g_varchar2
115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

115: ,p_date_of_death in date default hr_api.g_date
116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2

Line 120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

116: ,p_background_check_status in varchar2 default hr_api.g_varchar2
117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 121: ,p_fte_capacity in number default hr_api.g_number

117: ,p_background_date_check in date default hr_api.g_date
118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 122: ,p_hold_applicant_date_until in date default hr_api.g_date

118: ,p_blood_type in varchar2 default hr_api.g_varchar2
119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date

Line 123: ,p_honors in varchar2 default hr_api.g_varchar2

119: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 124: ,p_internal_location in varchar2 default hr_api.g_varchar2

120: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

121: ,p_fte_capacity in number default hr_api.g_number
122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 126: ,p_last_medical_test_date in date default hr_api.g_date

122: ,p_hold_applicant_date_until in date default hr_api.g_date
123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

Line 127: ,p_mailstop in varchar2 default hr_api.g_varchar2

123: ,p_honors in varchar2 default hr_api.g_varchar2
124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date

Line 128: ,p_office_number in varchar2 default hr_api.g_varchar2

124: ,p_internal_location in varchar2 default hr_api.g_varchar2
125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 129: ,p_on_military_service in varchar2 default hr_api.g_varchar2

125: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

126: ,p_last_medical_test_date in date default hr_api.g_date
127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 131: ,p_projected_start_date in date default hr_api.g_date

127: ,p_mailstop in varchar2 default hr_api.g_varchar2
128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date

Line 132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

128: ,p_office_number in varchar2 default hr_api.g_varchar2
129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

129: ,p_on_military_service in varchar2 default hr_api.g_varchar2
130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 134: ,p_resume_exists in varchar2 default hr_api.g_varchar2

130: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 135: ,p_resume_last_updated in date default hr_api.g_date

131: ,p_projected_start_date in date default hr_api.g_date
132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

132: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2

Line 137: ,p_student_status in varchar2 default hr_api.g_varchar2

133: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number

Line 138: ,p_work_schedule in varchar2 default hr_api.g_varchar2

134: ,p_resume_exists in varchar2 default hr_api.g_varchar2
135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

135: ,p_resume_last_updated in date default hr_api.g_date
136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 140: ,p_suffix in varchar2 default hr_api.g_varchar2

136: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 141: ,p_benefit_group_id in number default hr_api.g_number

137: ,p_student_status in varchar2 default hr_api.g_varchar2
138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

Line 142: ,p_receipt_of_death_cert_date in date default hr_api.g_date

138: ,p_work_schedule in varchar2 default hr_api.g_varchar2
139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

Line 143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

139: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

Line 144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

140: ,p_suffix in varchar2 default hr_api.g_varchar2
141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

Line 145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

141: ,p_benefit_group_id in number default hr_api.g_number
142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

Line 146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

142: ,p_receipt_of_death_cert_date in date default hr_api.g_date
143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

Line 147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

143: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

144: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

145: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

146: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date

Line 151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

147: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date

Line 152: ,p_dpdnt_adoption_date in date default hr_api.g_date

148: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

149: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 154: ,p_original_date_of_hire in date default hr_api.g_date

150: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 155: ,p_adjusted_svc_date in date default hr_api.g_date

151: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

152: ,p_dpdnt_adoption_date in date default hr_api.g_date
153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number

Line 157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

153: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number
161: ,p_npw_number in varchar2 default hr_api.g_varchar2

Line 158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

154: ,p_original_date_of_hire in date default hr_api.g_date
155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number
161: ,p_npw_number in varchar2 default hr_api.g_varchar2
162: ,p_effective_start_date out nocopy date

Line 159: ,p_global_person_id in varchar2 default hr_api.g_varchar2

155: ,p_adjusted_svc_date in date default hr_api.g_date
156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number
161: ,p_npw_number in varchar2 default hr_api.g_varchar2
162: ,p_effective_start_date out nocopy date
163: ,p_effective_end_date out nocopy date

Line 160: ,p_party_id in number default hr_api.g_number

156: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number
161: ,p_npw_number in varchar2 default hr_api.g_varchar2
162: ,p_effective_start_date out nocopy date
163: ,p_effective_end_date out nocopy date
164: ,p_party_last_update_date out nocopy date

Line 161: ,p_npw_number in varchar2 default hr_api.g_varchar2

157: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
158: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
159: ,p_global_person_id in varchar2 default hr_api.g_varchar2
160: ,p_party_id in number default hr_api.g_number
161: ,p_npw_number in varchar2 default hr_api.g_varchar2
162: ,p_effective_start_date out nocopy date
163: ,p_effective_end_date out nocopy date
164: ,p_party_last_update_date out nocopy date
165: ,p_full_name out nocopy varchar2