8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_referral_info >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_referral_info
12: (p_validate in number default hr_api.g_false_num
13: ,p_object_id in number
14: ,p_object_type in varchar2
15: ,p_source_type in varchar2 default null
16: ,p_source_name in varchar2 default null
87: --
88: -- Convert constant values to their corresponding boolean value
89: --
90: l_validate :=
91: hr_api.constant_to_boolean
92: (p_constant_value => p_validate);
93: --
94: -- Register Surrogate ID or user key values
95: --
216: -- ----------------------------------------------------------------------------
217: -- |-------------------------< update_referral_info >--------------------|
218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_referral_info
220: (p_validate in number default hr_api.g_false_num
221: ,p_referral_info_id in number
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_referral_info
220: (p_validate in number default hr_api.g_false_num
221: ,p_referral_info_id in number
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
219: PROCEDURE update_referral_info
220: (p_validate in number default hr_api.g_false_num
221: ,p_referral_info_id in number
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
220: (p_validate in number default hr_api.g_false_num
221: ,p_referral_info_id in number
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
221: ,p_referral_info_id in number
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
222: ,p_source_type in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
223: ,p_source_name in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
224: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
225: ,p_source_value1 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
226: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
227: ,p_source_value2 in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
228: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
229: ,p_source_value3 in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_source_value4 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_source_value5 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_source_person_id in number default hr_api.g_number
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_employee_comment in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
241: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
242: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
243: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
244: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
245: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
246: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
247: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
248: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
249: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
250: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
258: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
251: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
258: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
252: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
258: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_start_date out nocopy date
253: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
258: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_start_date out nocopy date
261: ,p_end_date out nocopy date
254: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
255: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
256: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
257: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
258: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_start_date out nocopy date
261: ,p_end_date out nocopy date
262: ,p_return_status out nocopy varchar2
287: --
288: -- Convert constant values to their corresponding boolean value
289: --
290: l_validate :=
291: hr_api.constant_to_boolean
292: (p_constant_value => p_validate);
293: --
294: -- Register Surrogate ID or user key values
295: --