67: --
68: procedure update_referral_info
69: (p_validate in boolean default false
70: ,p_referral_info_id in number
71: ,p_source_type in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
68: procedure update_referral_info
69: (p_validate in boolean default false
70: ,p_referral_info_id in number
71: ,p_source_type in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
69: (p_validate in boolean default false
70: ,p_referral_info_id in number
71: ,p_source_type in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
70: ,p_referral_info_id in number
71: ,p_source_type in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
71: ,p_source_type in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
72: ,p_source_name in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
73: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
74: ,p_source_value1 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
75: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
76: ,p_source_value2 in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
77: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
78: ,p_source_value3 in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
79: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
80: ,p_source_value4 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
81: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
82: ,p_source_value5 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
83: ,p_source_person_id in number default hr_api.g_number
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
84: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
85: ,p_employee_comment in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
86: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
87: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
88: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
89: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
90: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
91: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
92: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
93: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
94: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
95: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
96: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
97: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
98: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
99: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
107: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
100: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
107: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
108: ,p_object_version_number in out nocopy number
101: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
107: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
108: ,p_object_version_number in out nocopy number
109: ,p_start_date out nocopy date
102: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
107: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
108: ,p_object_version_number in out nocopy number
109: ,p_start_date out nocopy date
110: ,p_end_date out nocopy date
103: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
104: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
105: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
106: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
107: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
108: ,p_object_version_number in out nocopy number
109: ,p_start_date out nocopy date
110: ,p_end_date out nocopy date
111: );