eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DK_PERSON_API dependencies on HR_API

Line 58: * existing employee number pass in hr_api.g_varchar2. When the API call

54: * @param p_date_of_birth Date of birth.
55: * @param p_email_address Email address.
56: * @param p_employee_number The business group's employee number generation
57: * method determines when you can update the employee value. To keep the
58: * existing employee number pass in hr_api.g_varchar2. When the API call
59: * completes if p_validate is false then will be set to the employee number. If
60: * p_validate is true then will be set to the passed value.
61: * @param p_expense_check_send_to_addres Address to use as mailing address.
62: * @param p_first_name Person's first name.

Line 204: ,p_person_type_id in number default hr_api.g_number

200: ,p_effective_date in date
201: ,p_datetrack_update_mode in varchar2
202: ,p_person_id in number
203: ,p_object_version_number in out nocopy number
204: ,p_person_type_id in number default hr_api.g_number
205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date

Line 205: ,p_last_name in varchar2 default hr_api.g_varchar2

201: ,p_datetrack_update_mode in varchar2
202: ,p_person_id in number
203: ,p_object_version_number in out nocopy number
204: ,p_person_type_id in number default hr_api.g_number
205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date

Line 206: ,p_applicant_number in varchar2 default hr_api.g_varchar2

202: ,p_person_id in number
203: ,p_object_version_number in out nocopy number
204: ,p_person_type_id in number default hr_api.g_number
205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 207: ,p_comments in varchar2 default hr_api.g_varchar2

203: ,p_object_version_number in out nocopy number
204: ,p_person_type_id in number default hr_api.g_number
205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2

Line 208: ,p_date_employee_data_verified in date default hr_api.g_date

204: ,p_person_type_id in number default hr_api.g_number
205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 209: ,p_date_of_birth in date default hr_api.g_date

205: ,p_last_name in varchar2 default hr_api.g_varchar2
206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 210: ,p_email_address in varchar2 default hr_api.g_varchar2

206: ,p_applicant_number in varchar2 default hr_api.g_varchar2
207: ,p_comments in varchar2 default hr_api.g_varchar2
208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216

Line 212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

208: ,p_date_employee_data_verified in date default hr_api.g_date
209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2

Line 213: ,p_first_name in varchar2 default hr_api.g_varchar2

209: ,p_date_of_birth in date default hr_api.g_date
210: ,p_email_address in varchar2 default hr_api.g_varchar2
211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2

Line 215: ,p_middle_names in varchar2 default hr_api.g_varchar2

211: ,p_employee_number in out nocopy varchar2
212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2

Line 216: ,p_known_as in varchar2 default hr_api.g_varchar2

212: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

Line 217: ,p_marital_status in varchar2 default hr_api.g_varchar2

213: ,p_first_name in varchar2 default hr_api.g_varchar2
214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 218: ,p_nationality in varchar2 default hr_api.g_varchar2

214: -- Added for bug fix 4666216
215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2

Line 219: ,p_national_identifier in varchar2 default hr_api.g_varchar2

215: ,p_middle_names in varchar2 default hr_api.g_varchar2
216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2

Line 220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

216: ,p_known_as in varchar2 default hr_api.g_varchar2
217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number

Line 221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

217: ,p_marital_status in varchar2 default hr_api.g_varchar2
218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 222: ,p_sex in varchar2 default hr_api.g_varchar2

218: ,p_nationality in varchar2 default hr_api.g_varchar2
219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 223: ,p_title in varchar2 default hr_api.g_varchar2

219: ,p_national_identifier in varchar2 default hr_api.g_varchar2
220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 224: ,p_vendor_id in number default hr_api.g_number

220: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 225: ,p_work_telephone in varchar2 default hr_api.g_varchar2

221: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 226: ,p_attribute_category in varchar2 default hr_api.g_varchar2

222: ,p_sex in varchar2 default hr_api.g_varchar2
223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 227: ,p_attribute1 in varchar2 default hr_api.g_varchar2

223: ,p_title in varchar2 default hr_api.g_varchar2
224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute2 in varchar2 default hr_api.g_varchar2

224: ,p_vendor_id in number default hr_api.g_number
225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute3 in varchar2 default hr_api.g_varchar2

225: ,p_work_telephone in varchar2 default hr_api.g_varchar2
226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute4 in varchar2 default hr_api.g_varchar2

226: ,p_attribute_category in varchar2 default hr_api.g_varchar2
227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute5 in varchar2 default hr_api.g_varchar2

227: ,p_attribute1 in varchar2 default hr_api.g_varchar2
228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute6 in varchar2 default hr_api.g_varchar2

228: ,p_attribute2 in varchar2 default hr_api.g_varchar2
229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute7 in varchar2 default hr_api.g_varchar2

229: ,p_attribute3 in varchar2 default hr_api.g_varchar2
230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute8 in varchar2 default hr_api.g_varchar2

230: ,p_attribute4 in varchar2 default hr_api.g_varchar2
231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute9 in varchar2 default hr_api.g_varchar2

231: ,p_attribute5 in varchar2 default hr_api.g_varchar2
232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute10 in varchar2 default hr_api.g_varchar2

232: ,p_attribute6 in varchar2 default hr_api.g_varchar2
233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute11 in varchar2 default hr_api.g_varchar2

233: ,p_attribute7 in varchar2 default hr_api.g_varchar2
234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute12 in varchar2 default hr_api.g_varchar2

234: ,p_attribute8 in varchar2 default hr_api.g_varchar2
235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute13 in varchar2 default hr_api.g_varchar2

235: ,p_attribute9 in varchar2 default hr_api.g_varchar2
236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute14 in varchar2 default hr_api.g_varchar2

236: ,p_attribute10 in varchar2 default hr_api.g_varchar2
237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute15 in varchar2 default hr_api.g_varchar2

237: ,p_attribute11 in varchar2 default hr_api.g_varchar2
238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute16 in varchar2 default hr_api.g_varchar2

238: ,p_attribute12 in varchar2 default hr_api.g_varchar2
239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute17 in varchar2 default hr_api.g_varchar2

239: ,p_attribute13 in varchar2 default hr_api.g_varchar2
240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute18 in varchar2 default hr_api.g_varchar2

240: ,p_attribute14 in varchar2 default hr_api.g_varchar2
241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute19 in varchar2 default hr_api.g_varchar2

241: ,p_attribute15 in varchar2 default hr_api.g_varchar2
242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute20 in varchar2 default hr_api.g_varchar2

242: ,p_attribute16 in varchar2 default hr_api.g_varchar2
243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute21 in varchar2 default hr_api.g_varchar2

243: ,p_attribute17 in varchar2 default hr_api.g_varchar2
244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute22 in varchar2 default hr_api.g_varchar2

244: ,p_attribute18 in varchar2 default hr_api.g_varchar2
245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute23 in varchar2 default hr_api.g_varchar2

245: ,p_attribute19 in varchar2 default hr_api.g_varchar2
246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute24 in varchar2 default hr_api.g_varchar2

246: ,p_attribute20 in varchar2 default hr_api.g_varchar2
247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute25 in varchar2 default hr_api.g_varchar2

247: ,p_attribute21 in varchar2 default hr_api.g_varchar2
248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute26 in varchar2 default hr_api.g_varchar2

248: ,p_attribute22 in varchar2 default hr_api.g_varchar2
249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute27 in varchar2 default hr_api.g_varchar2

249: ,p_attribute23 in varchar2 default hr_api.g_varchar2
250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute28 in varchar2 default hr_api.g_varchar2

250: ,p_attribute24 in varchar2 default hr_api.g_varchar2
251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date

Line 255: ,p_attribute29 in varchar2 default hr_api.g_varchar2

251: ,p_attribute25 in varchar2 default hr_api.g_varchar2
252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 256: ,p_attribute30 in varchar2 default hr_api.g_varchar2

252: ,p_attribute26 in varchar2 default hr_api.g_varchar2
253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date

Line 257: ,p_initials in varchar2 default hr_api.g_varchar2

253: ,p_attribute27 in varchar2 default hr_api.g_varchar2
254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 258: ,p_jubilee_date in date default hr_api.g_date

254: ,p_attribute28 in varchar2 default hr_api.g_varchar2
255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date

Line 259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2

255: ,p_attribute29 in varchar2 default hr_api.g_varchar2
256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 260: ,p_date_of_death in date default hr_api.g_date

256: ,p_attribute30 in varchar2 default hr_api.g_varchar2
257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 261: ,p_background_check_status in varchar2 default hr_api.g_varchar2

257: ,p_initials in varchar2 default hr_api.g_varchar2
258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 262: ,p_background_date_check in date default hr_api.g_date

258: ,p_jubilee_date in date default hr_api.g_date
259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number

Line 263: ,p_blood_type in varchar2 default hr_api.g_varchar2

259: ,p_trainee IN VARCHAR2 DEFAULT hr_api.g_varchar2
260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

260: ,p_date_of_death in date default hr_api.g_date
261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2

Line 265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

261: ,p_background_check_status in varchar2 default hr_api.g_varchar2
262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 266: ,p_fte_capacity in number default hr_api.g_number

262: ,p_background_date_check in date default hr_api.g_date
263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 267: ,p_hold_applicant_date_until in date default hr_api.g_date

263: ,p_blood_type in varchar2 default hr_api.g_varchar2
264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date

Line 268: ,p_honors in varchar2 default hr_api.g_varchar2

264: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 269: ,p_internal_location in varchar2 default hr_api.g_varchar2

265: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

266: ,p_fte_capacity in number default hr_api.g_number
267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 271: ,p_last_medical_test_date in date default hr_api.g_date

267: ,p_hold_applicant_date_until in date default hr_api.g_date
268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date

Line 272: ,p_mailstop in varchar2 default hr_api.g_varchar2

268: ,p_honors in varchar2 default hr_api.g_varchar2
269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 273: ,p_office_number in varchar2 default hr_api.g_varchar2

269: ,p_internal_location in varchar2 default hr_api.g_varchar2
270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 274: ,p_on_military_service in varchar2 default hr_api.g_varchar2

270: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 275: ,p_projected_start_date in date default hr_api.g_date

271: ,p_last_medical_test_date in date default hr_api.g_date
272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date

Line 276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

272: ,p_mailstop in varchar2 default hr_api.g_varchar2
273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

273: ,p_office_number in varchar2 default hr_api.g_varchar2
274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 278: ,p_resume_exists in varchar2 default hr_api.g_varchar2

274: ,p_on_military_service in varchar2 default hr_api.g_varchar2
275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 279: ,p_resume_last_updated in date default hr_api.g_date

275: ,p_projected_start_date in date default hr_api.g_date
276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

276: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number

Line 281: ,p_student_status in varchar2 default hr_api.g_varchar2

277: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 282: ,p_work_schedule in varchar2 default hr_api.g_varchar2

278: ,p_resume_exists in varchar2 default hr_api.g_varchar2
279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

279: ,p_resume_last_updated in date default hr_api.g_date
280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 284: ,p_benefit_group_id in number default hr_api.g_number

280: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

Line 285: ,p_receipt_of_death_cert_date in date default hr_api.g_date

281: ,p_student_status in varchar2 default hr_api.g_varchar2
282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

Line 286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

282: ,p_work_schedule in varchar2 default hr_api.g_varchar2
283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

Line 287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

283: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

Line 288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

284: ,p_benefit_group_id in number default hr_api.g_number
285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

Line 289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

285: ,p_receipt_of_death_cert_date in date default hr_api.g_date
286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

Line 290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

286: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

287: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

288: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

289: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date

Line 294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

290: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date

Line 295: ,p_dpdnt_adoption_date in date default hr_api.g_date

291: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

292: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 297: ,p_original_date_of_hire in date default hr_api.g_date

293: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 298: ,p_adjusted_svc_date in date default hr_api.g_date

294: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

295: ,p_dpdnt_adoption_date in date default hr_api.g_date
296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number

Line 300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

296: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number
304: ,p_npw_number in varchar2 default hr_api.g_varchar2

Line 301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

297: ,p_original_date_of_hire in date default hr_api.g_date
298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number
304: ,p_npw_number in varchar2 default hr_api.g_varchar2
305: ,p_effective_start_date out nocopy date

Line 302: ,p_global_person_id in varchar2 default hr_api.g_varchar2

298: ,p_adjusted_svc_date in date default hr_api.g_date
299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number
304: ,p_npw_number in varchar2 default hr_api.g_varchar2
305: ,p_effective_start_date out nocopy date
306: ,p_effective_end_date out nocopy date

Line 303: ,p_party_id in number default hr_api.g_number

299: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number
304: ,p_npw_number in varchar2 default hr_api.g_varchar2
305: ,p_effective_start_date out nocopy date
306: ,p_effective_end_date out nocopy date
307: ,p_full_name out nocopy varchar2

Line 304: ,p_npw_number in varchar2 default hr_api.g_varchar2

300: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
301: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
302: ,p_global_person_id in varchar2 default hr_api.g_varchar2
303: ,p_party_id in number default hr_api.g_number
304: ,p_npw_number in varchar2 default hr_api.g_varchar2
305: ,p_effective_start_date out nocopy date
306: ,p_effective_end_date out nocopy date
307: ,p_full_name out nocopy varchar2
308: ,p_comment_id out nocopy number