APPS.HR_PL_PERSON_API dependencies on HR_API

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

61: * @param p_date_of_birth Date of birth of the person.
62: * @param p_email_address Email address of the person.
63: * @param p_employee_number The business group's employee number generation
64: * method determines when you can update the employee value. To keep the
65: * existing employee number pass in hr_api.g_varchar2. When the API call
66: * completes if p_validate is false then will be set to the employee number. If
67: * p_validate is true then will be set to the passed value.
68: * @param p_expense_check_send_to_addres Mailing address of the person.
69: * @param p_first_name First Name of the person.

Line 249: ,p_person_type_id in number default hr_api.g_number

245: ,p_effective_date in date
246: ,p_datetrack_update_mode in varchar2
247: ,p_person_id in number
248: ,p_object_version_number in out nocopy number
249: ,p_person_type_id in number default hr_api.g_number
250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date

Line 250: ,p_last_name in varchar2 default hr_api.g_varchar2

246: ,p_datetrack_update_mode in varchar2
247: ,p_person_id in number
248: ,p_object_version_number in out nocopy number
249: ,p_person_type_id in number default hr_api.g_number
250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date

Line 251: ,p_applicant_number in varchar2 default hr_api.g_varchar2

247: ,p_person_id in number
248: ,p_object_version_number in out nocopy number
249: ,p_person_type_id in number default hr_api.g_number
250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 252: ,p_comments in varchar2 default hr_api.g_varchar2

248: ,p_object_version_number in out nocopy number
249: ,p_person_type_id in number default hr_api.g_number
250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2

Line 253: ,p_date_employee_data_verified in date default hr_api.g_date

249: ,p_person_type_id in number default hr_api.g_number
250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 254: ,p_date_of_birth in date default hr_api.g_date

250: ,p_last_name in varchar2 default hr_api.g_varchar2
251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 255: ,p_email_address in varchar2 default hr_api.g_varchar2

251: ,p_applicant_number in varchar2 default hr_api.g_varchar2
252: ,p_comments in varchar2 default hr_api.g_varchar2
253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2

Line 257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

253: ,p_date_employee_data_verified in date default hr_api.g_date
254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2

Line 258: ,p_first_name in varchar2 default hr_api.g_varchar2

254: ,p_date_of_birth in date default hr_api.g_date
255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2

Line 259: ,p_preferred_name in varchar2 default hr_api.g_varchar2

255: ,p_email_address in varchar2 default hr_api.g_varchar2
256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2

Line 260: ,p_marital_status in varchar2 default hr_api.g_varchar2

256: ,p_employee_number in out nocopy varchar2
257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2

Line 261: ,p_middle_names in varchar2 default hr_api.g_varchar2

257: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 262: ,p_nationality in varchar2 default hr_api.g_varchar2

258: ,p_first_name in varchar2 default hr_api.g_varchar2
259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2

Line 263: ,p_pesel_value in varchar2 default hr_api.g_varchar2

259: ,p_preferred_name in varchar2 default hr_api.g_varchar2
260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2

Line 264: ,p_maiden_name in varchar2 default hr_api.g_varchar2

260: ,p_marital_status in varchar2 default hr_api.g_varchar2
261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number

Line 265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

261: ,p_middle_names in varchar2 default hr_api.g_varchar2
262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 266: ,p_sex in varchar2 default hr_api.g_varchar2

262: ,p_nationality in varchar2 default hr_api.g_varchar2
263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 267: ,p_title in varchar2 default hr_api.g_varchar2

263: ,p_pesel_value in varchar2 default hr_api.g_varchar2
264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 268: ,p_vendor_id in number default hr_api.g_number

264: ,p_maiden_name in varchar2 default hr_api.g_varchar2
265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 269: ,p_work_telephone in varchar2 default hr_api.g_varchar2

265: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 270: ,p_attribute_category in varchar2 default hr_api.g_varchar2

266: ,p_sex in varchar2 default hr_api.g_varchar2
267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 271: ,p_attribute1 in varchar2 default hr_api.g_varchar2

267: ,p_title in varchar2 default hr_api.g_varchar2
268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 272: ,p_attribute2 in varchar2 default hr_api.g_varchar2

268: ,p_vendor_id in number default hr_api.g_number
269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 273: ,p_attribute3 in varchar2 default hr_api.g_varchar2

269: ,p_work_telephone in varchar2 default hr_api.g_varchar2
270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 274: ,p_attribute4 in varchar2 default hr_api.g_varchar2

270: ,p_attribute_category in varchar2 default hr_api.g_varchar2
271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 275: ,p_attribute5 in varchar2 default hr_api.g_varchar2

271: ,p_attribute1 in varchar2 default hr_api.g_varchar2
272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 276: ,p_attribute6 in varchar2 default hr_api.g_varchar2

272: ,p_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 277: ,p_attribute7 in varchar2 default hr_api.g_varchar2

273: ,p_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 278: ,p_attribute8 in varchar2 default hr_api.g_varchar2

274: ,p_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 279: ,p_attribute9 in varchar2 default hr_api.g_varchar2

275: ,p_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 280: ,p_attribute10 in varchar2 default hr_api.g_varchar2

276: ,p_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 281: ,p_attribute11 in varchar2 default hr_api.g_varchar2

277: ,p_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 282: ,p_attribute12 in varchar2 default hr_api.g_varchar2

278: ,p_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 283: ,p_attribute13 in varchar2 default hr_api.g_varchar2

279: ,p_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 284: ,p_attribute14 in varchar2 default hr_api.g_varchar2

280: ,p_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute15 in varchar2 default hr_api.g_varchar2

281: ,p_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute16 in varchar2 default hr_api.g_varchar2

282: ,p_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute17 in varchar2 default hr_api.g_varchar2

283: ,p_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute18 in varchar2 default hr_api.g_varchar2

284: ,p_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute19 in varchar2 default hr_api.g_varchar2

285: ,p_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute20 in varchar2 default hr_api.g_varchar2

286: ,p_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute21 in varchar2 default hr_api.g_varchar2

287: ,p_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute22 in varchar2 default hr_api.g_varchar2

288: ,p_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute23 in varchar2 default hr_api.g_varchar2

289: ,p_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute24 in varchar2 default hr_api.g_varchar2

290: ,p_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute25 in varchar2 default hr_api.g_varchar2

291: ,p_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute26 in varchar2 default hr_api.g_varchar2

292: ,p_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute27 in varchar2 default hr_api.g_varchar2

293: ,p_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute28 in varchar2 default hr_api.g_varchar2

294: ,p_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute29 in varchar2 default hr_api.g_varchar2

295: ,p_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute30 in varchar2 default hr_api.g_varchar2

296: ,p_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 301: ,p_per_information_category in varchar2 default hr_api.g_varchar2

297: ,p_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 302: ,p_nip_value in varchar2 default hr_api.g_varchar2

298: ,p_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 303: ,p_per_information2 in varchar2 default hr_api.g_varchar2

299: ,p_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 304: ,p_per_information3 in varchar2 default hr_api.g_varchar2

300: ,p_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 305: ,p_per_information4 in varchar2 default hr_api.g_varchar2

301: ,p_per_information_category in varchar2 default hr_api.g_varchar2
302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 306: ,p_per_information5 in varchar2 default hr_api.g_varchar2

302: ,p_nip_value in varchar2 default hr_api.g_varchar2
303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 307: ,p_per_information6 in varchar2 default hr_api.g_varchar2

303: ,p_per_information2 in varchar2 default hr_api.g_varchar2
304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 308: ,p_per_information7 in varchar2 default hr_api.g_varchar2

304: ,p_per_information3 in varchar2 default hr_api.g_varchar2
305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 309: ,p_per_information8 in varchar2 default hr_api.g_varchar2

305: ,p_per_information4 in varchar2 default hr_api.g_varchar2
306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 310: ,p_per_information9 in varchar2 default hr_api.g_varchar2

306: ,p_per_information5 in varchar2 default hr_api.g_varchar2
307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 311: ,p_per_information10 in varchar2 default hr_api.g_varchar2

307: ,p_per_information6 in varchar2 default hr_api.g_varchar2
308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 312: ,p_per_information11 in varchar2 default hr_api.g_varchar2

308: ,p_per_information7 in varchar2 default hr_api.g_varchar2
309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 313: ,p_per_information12 in varchar2 default hr_api.g_varchar2

309: ,p_per_information8 in varchar2 default hr_api.g_varchar2
310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 314: ,p_per_information13 in varchar2 default hr_api.g_varchar2

310: ,p_per_information9 in varchar2 default hr_api.g_varchar2
311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 315: ,p_per_information14 in varchar2 default hr_api.g_varchar2

311: ,p_per_information10 in varchar2 default hr_api.g_varchar2
312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 316: ,p_per_information15 in varchar2 default hr_api.g_varchar2

312: ,p_per_information11 in varchar2 default hr_api.g_varchar2
313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 317: ,p_per_information16 in varchar2 default hr_api.g_varchar2

313: ,p_per_information12 in varchar2 default hr_api.g_varchar2
314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 318: ,p_per_information17 in varchar2 default hr_api.g_varchar2

314: ,p_per_information13 in varchar2 default hr_api.g_varchar2
315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 319: ,p_per_information18 in varchar2 default hr_api.g_varchar2

315: ,p_per_information14 in varchar2 default hr_api.g_varchar2
316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 320: ,p_per_information19 in varchar2 default hr_api.g_varchar2

316: ,p_per_information15 in varchar2 default hr_api.g_varchar2
317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 321: ,p_per_information20 in varchar2 default hr_api.g_varchar2

317: ,p_per_information16 in varchar2 default hr_api.g_varchar2
318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 322: ,p_per_information21 in varchar2 default hr_api.g_varchar2

318: ,p_per_information17 in varchar2 default hr_api.g_varchar2
319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 323: ,p_per_information22 in varchar2 default hr_api.g_varchar2

319: ,p_per_information18 in varchar2 default hr_api.g_varchar2
320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 324: ,p_per_information23 in varchar2 default hr_api.g_varchar2

320: ,p_per_information19 in varchar2 default hr_api.g_varchar2
321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 325: ,p_per_information24 in varchar2 default hr_api.g_varchar2

321: ,p_per_information20 in varchar2 default hr_api.g_varchar2
322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 326: ,p_per_information25 in varchar2 default hr_api.g_varchar2

322: ,p_per_information21 in varchar2 default hr_api.g_varchar2
323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 327: ,p_per_information26 in varchar2 default hr_api.g_varchar2

323: ,p_per_information22 in varchar2 default hr_api.g_varchar2
324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 328: ,p_per_information27 in varchar2 default hr_api.g_varchar2

324: ,p_per_information23 in varchar2 default hr_api.g_varchar2
325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date

Line 329: ,p_per_information28 in varchar2 default hr_api.g_varchar2

325: ,p_per_information24 in varchar2 default hr_api.g_varchar2
326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 330: ,p_per_information29 in varchar2 default hr_api.g_varchar2

326: ,p_per_information25 in varchar2 default hr_api.g_varchar2
327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date

Line 331: ,p_per_information30 in varchar2 default hr_api.g_varchar2

327: ,p_per_information26 in varchar2 default hr_api.g_varchar2
328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 332: ,p_date_of_death in date default hr_api.g_date

328: ,p_per_information27 in varchar2 default hr_api.g_varchar2
329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 333: ,p_background_check_status in varchar2 default hr_api.g_varchar2

329: ,p_per_information28 in varchar2 default hr_api.g_varchar2
330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 334: ,p_background_date_check in date default hr_api.g_date

330: ,p_per_information29 in varchar2 default hr_api.g_varchar2
331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number

Line 335: ,p_blood_type in varchar2 default hr_api.g_varchar2

331: ,p_per_information30 in varchar2 default hr_api.g_varchar2
332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

332: ,p_date_of_death in date default hr_api.g_date
333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2

Line 337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

333: ,p_background_check_status in varchar2 default hr_api.g_varchar2
334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 338: ,p_fte_capacity in number default hr_api.g_number

334: ,p_background_date_check in date default hr_api.g_date
335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 339: ,p_hold_applicant_date_until in date default hr_api.g_date

335: ,p_blood_type in varchar2 default hr_api.g_varchar2
336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date

Line 340: ,p_honors in varchar2 default hr_api.g_varchar2

336: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 341: ,p_internal_location in varchar2 default hr_api.g_varchar2

337: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

338: ,p_fte_capacity in number default hr_api.g_number
339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 343: ,p_last_medical_test_date in date default hr_api.g_date

339: ,p_hold_applicant_date_until in date default hr_api.g_date
340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2

Line 344: ,p_mailstop in varchar2 default hr_api.g_varchar2

340: ,p_honors in varchar2 default hr_api.g_varchar2
341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date

Line 345: ,p_office_number in varchar2 default hr_api.g_varchar2

341: ,p_internal_location in varchar2 default hr_api.g_varchar2
342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 346: ,p_on_military_service in varchar2 default hr_api.g_varchar2

342: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 347: ,p_prefix in varchar2 default hr_api.g_varchar2

343: ,p_last_medical_test_date in date default hr_api.g_date
344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 348: ,p_projected_start_date in date default hr_api.g_date

344: ,p_mailstop in varchar2 default hr_api.g_varchar2
345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date

Line 349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

345: ,p_office_number in varchar2 default hr_api.g_varchar2
346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

346: ,p_on_military_service in varchar2 default hr_api.g_varchar2
347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 351: ,p_resume_exists in varchar2 default hr_api.g_varchar2

347: ,p_prefix in varchar2 default hr_api.g_varchar2
348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 352: ,p_resume_last_updated in date default hr_api.g_date

348: ,p_projected_start_date in date default hr_api.g_date
349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

349: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2

Line 354: ,p_student_status in varchar2 default hr_api.g_varchar2

350: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number

Line 355: ,p_work_schedule in varchar2 default hr_api.g_varchar2

351: ,p_resume_exists in varchar2 default hr_api.g_varchar2
352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

352: ,p_resume_last_updated in date default hr_api.g_date
353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 357: ,p_suffix in varchar2 default hr_api.g_varchar2

353: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 358: ,p_benefit_group_id in number default hr_api.g_number

354: ,p_student_status in varchar2 default hr_api.g_varchar2
355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

Line 359: ,p_receipt_of_death_cert_date in date default hr_api.g_date

355: ,p_work_schedule in varchar2 default hr_api.g_varchar2
356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

Line 360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

356: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

Line 361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

357: ,p_suffix in varchar2 default hr_api.g_varchar2
358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

Line 362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

358: ,p_benefit_group_id in number default hr_api.g_number
359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

Line 363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

359: ,p_receipt_of_death_cert_date in date default hr_api.g_date
360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

Line 364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

360: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

361: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

362: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

363: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date

Line 368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

364: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date

Line 369: ,p_dpdnt_adoption_date in date default hr_api.g_date

365: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

366: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 371: ,p_original_date_of_hire in date default hr_api.g_date

367: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 372: ,p_adjusted_svc_date in date default hr_api.g_date

368: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

369: ,p_dpdnt_adoption_date in date default hr_api.g_date
370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number

Line 374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

370: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number
378: ,p_npw_number in varchar2 default hr_api.g_varchar2

Line 375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

371: ,p_original_date_of_hire in date default hr_api.g_date
372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number
378: ,p_npw_number in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date

Line 376: ,p_global_person_id in varchar2 default hr_api.g_varchar2

372: ,p_adjusted_svc_date in date default hr_api.g_date
373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number
378: ,p_npw_number in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date
380: ,p_effective_end_date out nocopy date

Line 377: ,p_party_id in number default hr_api.g_number

373: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number
378: ,p_npw_number in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date
380: ,p_effective_end_date out nocopy date
381: ,p_full_name out nocopy varchar2

Line 378: ,p_npw_number in varchar2 default hr_api.g_varchar2

374: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376: ,p_global_person_id in varchar2 default hr_api.g_varchar2
377: ,p_party_id in number default hr_api.g_number
378: ,p_npw_number in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date
380: ,p_effective_end_date out nocopy date
381: ,p_full_name out nocopy varchar2
382: ,p_comment_id out nocopy number

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

433: * @param p_date_of_birth Date of birth of the person.
434: * @param p_email_address Email address of the person.
435: * @param p_employee_number The business group's employee number generation
436: * method determines when you can update the employee value. To keep the
437: * existing employee number pass in hr_api.g_varchar2. When the API call
438: * completes if p_validate is false then will be set to the employee number. If
439: * p_validate is true then will be set to the passed value.
440: * @param p_expense_check_send_to_addres Mailing address of the person.
441: * @param p_first_name First Name of the person.

Line 605: ,p_person_type_id in number default hr_api.g_number

601: ,p_effective_date in date
602: ,p_datetrack_update_mode in varchar2
603: ,p_person_id in number
604: ,p_object_version_number in out nocopy number
605: ,p_person_type_id in number default hr_api.g_number
606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date

Line 606: ,p_last_name in varchar2 default hr_api.g_varchar2

602: ,p_datetrack_update_mode in varchar2
603: ,p_person_id in number
604: ,p_object_version_number in out nocopy number
605: ,p_person_type_id in number default hr_api.g_number
606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date

Line 607: ,p_applicant_number in varchar2 default hr_api.g_varchar2

603: ,p_person_id in number
604: ,p_object_version_number in out nocopy number
605: ,p_person_type_id in number default hr_api.g_number
606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 608: ,p_comments in varchar2 default hr_api.g_varchar2

604: ,p_object_version_number in out nocopy number
605: ,p_person_type_id in number default hr_api.g_number
606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2

Line 609: ,p_date_employee_data_verified in date default hr_api.g_date

605: ,p_person_type_id in number default hr_api.g_number
606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 610: ,p_date_of_birth in date default hr_api.g_date

606: ,p_last_name in varchar2 default hr_api.g_varchar2
607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 611: ,p_email_address in varchar2 default hr_api.g_varchar2

607: ,p_applicant_number in varchar2 default hr_api.g_varchar2
608: ,p_comments in varchar2 default hr_api.g_varchar2
609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2

Line 613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

609: ,p_date_employee_data_verified in date default hr_api.g_date
610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2

Line 614: ,p_first_name in varchar2 default hr_api.g_varchar2

610: ,p_date_of_birth in date default hr_api.g_date
611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2

Line 615: ,p_preferred_name in varchar2 default hr_api.g_varchar2

611: ,p_email_address in varchar2 default hr_api.g_varchar2
612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2

Line 616: ,p_marital_status in varchar2 default hr_api.g_varchar2

612: ,p_employee_number in out nocopy varchar2
613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2

Line 617: ,p_middle_names in varchar2 default hr_api.g_varchar2

613: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 618: ,p_nationality in varchar2 default hr_api.g_varchar2

614: ,p_first_name in varchar2 default hr_api.g_varchar2
615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2

Line 619: ,p_pesel in varchar2 default hr_api.g_varchar2

615: ,p_preferred_name in varchar2 default hr_api.g_varchar2
616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2

Line 620: ,p_maiden_name in varchar2 default hr_api.g_varchar2

616: ,p_marital_status in varchar2 default hr_api.g_varchar2
617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number

Line 621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

617: ,p_middle_names in varchar2 default hr_api.g_varchar2
618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 622: ,p_sex in varchar2 default hr_api.g_varchar2

618: ,p_nationality in varchar2 default hr_api.g_varchar2
619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 623: ,p_title in varchar2 default hr_api.g_varchar2

619: ,p_pesel in varchar2 default hr_api.g_varchar2
620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 624: ,p_vendor_id in number default hr_api.g_number

620: ,p_maiden_name in varchar2 default hr_api.g_varchar2
621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 625: ,p_work_telephone in varchar2 default hr_api.g_varchar2

621: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 626: ,p_attribute_category in varchar2 default hr_api.g_varchar2

622: ,p_sex in varchar2 default hr_api.g_varchar2
623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 627: ,p_attribute1 in varchar2 default hr_api.g_varchar2

623: ,p_title in varchar2 default hr_api.g_varchar2
624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 628: ,p_attribute2 in varchar2 default hr_api.g_varchar2

624: ,p_vendor_id in number default hr_api.g_number
625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 629: ,p_attribute3 in varchar2 default hr_api.g_varchar2

625: ,p_work_telephone in varchar2 default hr_api.g_varchar2
626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 630: ,p_attribute4 in varchar2 default hr_api.g_varchar2

626: ,p_attribute_category in varchar2 default hr_api.g_varchar2
627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 631: ,p_attribute5 in varchar2 default hr_api.g_varchar2

627: ,p_attribute1 in varchar2 default hr_api.g_varchar2
628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 632: ,p_attribute6 in varchar2 default hr_api.g_varchar2

628: ,p_attribute2 in varchar2 default hr_api.g_varchar2
629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 633: ,p_attribute7 in varchar2 default hr_api.g_varchar2

629: ,p_attribute3 in varchar2 default hr_api.g_varchar2
630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 634: ,p_attribute8 in varchar2 default hr_api.g_varchar2

630: ,p_attribute4 in varchar2 default hr_api.g_varchar2
631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 635: ,p_attribute9 in varchar2 default hr_api.g_varchar2

631: ,p_attribute5 in varchar2 default hr_api.g_varchar2
632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 636: ,p_attribute10 in varchar2 default hr_api.g_varchar2

632: ,p_attribute6 in varchar2 default hr_api.g_varchar2
633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 637: ,p_attribute11 in varchar2 default hr_api.g_varchar2

633: ,p_attribute7 in varchar2 default hr_api.g_varchar2
634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 638: ,p_attribute12 in varchar2 default hr_api.g_varchar2

634: ,p_attribute8 in varchar2 default hr_api.g_varchar2
635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 639: ,p_attribute13 in varchar2 default hr_api.g_varchar2

635: ,p_attribute9 in varchar2 default hr_api.g_varchar2
636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 640: ,p_attribute14 in varchar2 default hr_api.g_varchar2

636: ,p_attribute10 in varchar2 default hr_api.g_varchar2
637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 641: ,p_attribute15 in varchar2 default hr_api.g_varchar2

637: ,p_attribute11 in varchar2 default hr_api.g_varchar2
638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 642: ,p_attribute16 in varchar2 default hr_api.g_varchar2

638: ,p_attribute12 in varchar2 default hr_api.g_varchar2
639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 643: ,p_attribute17 in varchar2 default hr_api.g_varchar2

639: ,p_attribute13 in varchar2 default hr_api.g_varchar2
640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 644: ,p_attribute18 in varchar2 default hr_api.g_varchar2

640: ,p_attribute14 in varchar2 default hr_api.g_varchar2
641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 645: ,p_attribute19 in varchar2 default hr_api.g_varchar2

641: ,p_attribute15 in varchar2 default hr_api.g_varchar2
642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 646: ,p_attribute20 in varchar2 default hr_api.g_varchar2

642: ,p_attribute16 in varchar2 default hr_api.g_varchar2
643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 647: ,p_attribute21 in varchar2 default hr_api.g_varchar2

643: ,p_attribute17 in varchar2 default hr_api.g_varchar2
644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 648: ,p_attribute22 in varchar2 default hr_api.g_varchar2

644: ,p_attribute18 in varchar2 default hr_api.g_varchar2
645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 649: ,p_attribute23 in varchar2 default hr_api.g_varchar2

645: ,p_attribute19 in varchar2 default hr_api.g_varchar2
646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 650: ,p_attribute24 in varchar2 default hr_api.g_varchar2

646: ,p_attribute20 in varchar2 default hr_api.g_varchar2
647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 651: ,p_attribute25 in varchar2 default hr_api.g_varchar2

647: ,p_attribute21 in varchar2 default hr_api.g_varchar2
648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 652: ,p_attribute26 in varchar2 default hr_api.g_varchar2

648: ,p_attribute22 in varchar2 default hr_api.g_varchar2
649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 653: ,p_attribute27 in varchar2 default hr_api.g_varchar2

649: ,p_attribute23 in varchar2 default hr_api.g_varchar2
650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 654: ,p_attribute28 in varchar2 default hr_api.g_varchar2

650: ,p_attribute24 in varchar2 default hr_api.g_varchar2
651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2

Line 655: ,p_attribute29 in varchar2 default hr_api.g_varchar2

651: ,p_attribute25 in varchar2 default hr_api.g_varchar2
652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2

Line 656: ,p_attribute30 in varchar2 default hr_api.g_varchar2

652: ,p_attribute26 in varchar2 default hr_api.g_varchar2
653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2

Line 657: ,p_per_information_category in varchar2 default hr_api.g_varchar2

653: ,p_attribute27 in varchar2 default hr_api.g_varchar2
654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2

Line 658: ,p_nip in varchar2 default hr_api.g_varchar2

654: ,p_attribute28 in varchar2 default hr_api.g_varchar2
655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2

Line 659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2

655: ,p_attribute29 in varchar2 default hr_api.g_varchar2
656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2

Line 660: ,p_inheritor in varchar2 default hr_api.g_varchar2

656: ,p_attribute30 in varchar2 default hr_api.g_varchar2
657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2

Line 661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2

657: ,p_per_information_category in varchar2 default hr_api.g_varchar2
658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2

Line 662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2

658: ,p_nip in varchar2 default hr_api.g_varchar2
659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date

Line 663: ,p_tax_office in varchar2 default hr_api.g_varchar2

659: ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 664: ,p_legal_employer in varchar2 default hr_api.g_varchar2

660: ,p_inheritor in varchar2 default hr_api.g_varchar2
661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date

Line 665: ,p_citizenship in varchar2 default hr_api.g_varchar2

661: ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 666: ,p_date_of_death in date default hr_api.g_date

662: ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 667: ,p_background_check_status in varchar2 default hr_api.g_varchar2

663: ,p_tax_office in varchar2 default hr_api.g_varchar2
664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 668: ,p_background_date_check in date default hr_api.g_date

664: ,p_legal_employer in varchar2 default hr_api.g_varchar2
665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number

Line 669: ,p_blood_type in varchar2 default hr_api.g_varchar2

665: ,p_citizenship in varchar2 default hr_api.g_varchar2
666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

666: ,p_date_of_death in date default hr_api.g_date
667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2

Line 671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

667: ,p_background_check_status in varchar2 default hr_api.g_varchar2
668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 672: ,p_fte_capacity in number default hr_api.g_number

668: ,p_background_date_check in date default hr_api.g_date
669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 673: ,p_hold_applicant_date_until in date default hr_api.g_date

669: ,p_blood_type in varchar2 default hr_api.g_varchar2
670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date

Line 674: ,p_honors in varchar2 default hr_api.g_varchar2

670: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 675: ,p_internal_location in varchar2 default hr_api.g_varchar2

671: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

672: ,p_fte_capacity in number default hr_api.g_number
673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 677: ,p_last_medical_test_date in date default hr_api.g_date

673: ,p_hold_applicant_date_until in date default hr_api.g_date
674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2

Line 678: ,p_mailstop in varchar2 default hr_api.g_varchar2

674: ,p_honors in varchar2 default hr_api.g_varchar2
675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date

Line 679: ,p_office_number in varchar2 default hr_api.g_varchar2

675: ,p_internal_location in varchar2 default hr_api.g_varchar2
676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 680: ,p_on_military_service in varchar2 default hr_api.g_varchar2

676: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 681: ,p_prefix in varchar2 default hr_api.g_varchar2

677: ,p_last_medical_test_date in date default hr_api.g_date
678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 682: ,p_projected_start_date in date default hr_api.g_date

678: ,p_mailstop in varchar2 default hr_api.g_varchar2
679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date

Line 683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

679: ,p_office_number in varchar2 default hr_api.g_varchar2
680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

680: ,p_on_military_service in varchar2 default hr_api.g_varchar2
681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 685: ,p_resume_exists in varchar2 default hr_api.g_varchar2

681: ,p_prefix in varchar2 default hr_api.g_varchar2
682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 686: ,p_resume_last_updated in date default hr_api.g_date

682: ,p_projected_start_date in date default hr_api.g_date
683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

683: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2

Line 688: ,p_student_status in varchar2 default hr_api.g_varchar2

684: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number

Line 689: ,p_work_schedule in varchar2 default hr_api.g_varchar2

685: ,p_resume_exists in varchar2 default hr_api.g_varchar2
686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

686: ,p_resume_last_updated in date default hr_api.g_date
687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 691: ,p_suffix in varchar2 default hr_api.g_varchar2

687: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 692: ,p_benefit_group_id in number default hr_api.g_number

688: ,p_student_status in varchar2 default hr_api.g_varchar2
689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

Line 693: ,p_receipt_of_death_cert_date in date default hr_api.g_date

689: ,p_work_schedule in varchar2 default hr_api.g_varchar2
690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

Line 694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

690: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

Line 695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

691: ,p_suffix in varchar2 default hr_api.g_varchar2
692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

Line 696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

692: ,p_benefit_group_id in number default hr_api.g_number
693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

Line 697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

693: ,p_receipt_of_death_cert_date in date default hr_api.g_date
694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

Line 698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

694: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

695: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

696: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

697: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date

Line 702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

698: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date

Line 703: ,p_dpdnt_adoption_date in date default hr_api.g_date

699: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

700: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 705: ,p_original_date_of_hire in date default hr_api.g_date

701: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 706: ,p_adjusted_svc_date in date default hr_api.g_date

702: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

703: ,p_dpdnt_adoption_date in date default hr_api.g_date
704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number

Line 708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

704: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number
712: ,p_npw_number in varchar2 default hr_api.g_varchar2

Line 709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

705: ,p_original_date_of_hire in date default hr_api.g_date
706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number
712: ,p_npw_number in varchar2 default hr_api.g_varchar2
713: ,p_effective_start_date out nocopy date

Line 710: ,p_global_person_id in varchar2 default hr_api.g_varchar2

706: ,p_adjusted_svc_date in date default hr_api.g_date
707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number
712: ,p_npw_number in varchar2 default hr_api.g_varchar2
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date

Line 711: ,p_party_id in number default hr_api.g_number

707: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number
712: ,p_npw_number in varchar2 default hr_api.g_varchar2
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date
715: ,p_full_name out nocopy varchar2

Line 712: ,p_npw_number in varchar2 default hr_api.g_varchar2

708: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710: ,p_global_person_id in varchar2 default hr_api.g_varchar2
711: ,p_party_id in number default hr_api.g_number
712: ,p_npw_number in varchar2 default hr_api.g_varchar2
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date
715: ,p_full_name out nocopy varchar2
716: ,p_comment_id out nocopy number