117: ,p_irf_information10 => p_irf_information10
118: ,p_object_created_by => p_object_created_by
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'create_referral_info'
124: ,p_hook_type => 'BP'
125: );
118: ,p_object_created_by => p_object_created_by
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'create_referral_info'
124: ,p_hook_type => 'BP'
125: );
126: end;
225: ,p_start_date => l_start_date
226: ,p_end_date => l_end_date
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'create_referral_info'
232: ,p_hook_type => 'AP'
233: );
226: ,p_end_date => l_end_date
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'create_referral_info'
232: ,p_hook_type => 'AP'
233: );
234: end;
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all IN OUT and OUT parameters with out values
243: --
247: p_end_date := l_end_date;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 70);
250: exception
251: when hr_api.validate_enabled then
252: --
253: -- As the Validate_Enabled exception has been raised
254: -- we must rollback to the savepoint
255: --
288: --
289: procedure update_referral_info
290: (p_validate in boolean default false
291: ,p_referral_info_id in number
292: ,p_source_type in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
289: procedure update_referral_info
290: (p_validate in boolean default false
291: ,p_referral_info_id in number
292: ,p_source_type in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
290: (p_validate in boolean default false
291: ,p_referral_info_id in number
292: ,p_source_type in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
291: ,p_referral_info_id in number
292: ,p_source_type in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
292: ,p_source_type in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
293: ,p_source_name in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
294: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
295: ,p_source_value1 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
296: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
297: ,p_source_value2 in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
298: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
299: ,p_source_value3 in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
300: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
301: ,p_source_value4 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
303: ,p_source_value5 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
304: ,p_source_person_id in number default hr_api.g_number
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
305: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
306: ,p_employee_comment in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
307: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
308: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
309: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
310: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
311: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
312: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
313: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
314: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
315: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
316: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
317: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
318: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
319: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
320: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
328: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
321: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
328: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
322: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
328: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: ,p_start_date out nocopy date
323: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
328: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: ,p_start_date out nocopy date
331: ,p_end_date out nocopy date
324: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
325: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
326: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
327: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
328: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: ,p_start_date out nocopy date
331: ,p_end_date out nocopy date
332: ) is
389: ,p_irf_information10 => p_irf_information10
390: ,p_object_version_number => p_object_version_number
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'update_referral_info'
396: ,p_hook_type => 'BP'
397: );
390: ,p_object_version_number => p_object_version_number
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'update_referral_info'
396: ,p_hook_type => 'BP'
397: );
398: end;
496: ,p_irf_information10 => p_irf_information10
497: ,p_object_version_number => p_object_version_number
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'update_referral_info'
503: ,p_hook_type => 'AP'
504: );
497: ,p_object_version_number => p_object_version_number
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'update_referral_info'
503: ,p_hook_type => 'AP'
504: );
505: end;
506: --
507: -- When in validation only mode raise the Validate_Enabled exception
508: --
509: if p_validate then
510: raise hr_api.validate_enabled;
511: end if;
512: --
513: -- Set all IN OUT and OUT parameters with out values
514: --
517: p_end_date := l_end_date;
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 70);
520: exception
521: when hr_api.validate_enabled then
522: --
523: -- As the Validate_Enabled exception has been raised
524: -- we must rollback to the savepoint
525: --