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

APPS.HR_CN_PERSON_API dependencies on HR_API

Line 57: * employee number pass in hr_api.g_varchar2. When the API call completes if

53: * @param p_person_type_id {@rep:casecolumn PER_ALL_PEOPLE_F.PERSON_TYPE_ID}
54: * @param p_family_or_last_name {@rep:casecolumn PER_ALL_PEOPLE_F.LAST_NAME}
55: * @param p_applicant_number The business group's employee number generation
56: * method determines when you can update the person value. To keep the existing
57: * employee number pass in hr_api.g_varchar2. When the API call completes if
58: * p_validate is true then this will be set to the employee numb
59: * @param p_comments Person Comment Text
60: * @param p_date_employee_data_verified {@rep:casecolumn
61: * PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED}

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

62: * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
63: * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
64: * @param p_employee_number The business group's employee number generation
65: * method determines when you can update the employee value. To keep the
66: * existing employee number pass in hr_api.g_varchar2. When the API call
67: * completes if p_validate is false then will be set to the employee nu
68: * @param p_expense_check_send_to_addres Address to which the expense should be
69: * sent. Valid values are determined by the 'HOME_OFFICE' lookup type.
70: * @param p_given_or_first_name {@rep:casecolumn PER_ALL_PEOPLE_F.FIRST_NAME}

Line 266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number

262: ,p_effective_date IN DATE
263: ,p_datetrack_update_mode IN VARCHAR2
264: ,p_person_id IN NUMBER
265: ,p_object_version_number IN OUT NOCOPY NUMBER
266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

Line 267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

263: ,p_datetrack_update_mode IN VARCHAR2
264: ,p_person_id IN NUMBER
265: ,p_object_version_number IN OUT NOCOPY NUMBER
266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

Line 268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

264: ,p_person_id IN NUMBER
265: ,p_object_version_number IN OUT NOCOPY NUMBER
266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2

265: ,p_object_version_number IN OUT NOCOPY NUMBER
266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2

Line 270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

266: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

267: ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

268: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

270: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

271: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

272: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

273: ,p_employee_number IN OUT NOCOPY VARCHAR2
274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

274: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

275: ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2

276: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

277: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

Line 282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

278: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

279: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

280: ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

281: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

282: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

283: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

284: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

285: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

286: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

308: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

309: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

310: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

311: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

312: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

313: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

314: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

315: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2

316: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2

317: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2

318: ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

319: ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2

320: ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2

321: ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

322: ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

323: ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

Line 328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

324: ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2

325: ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

Line 330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

326: ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

327: ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

328: ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

329: ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

Line 334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

330: ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

Line 335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

331: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

332: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

333: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

334: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

Line 339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

335: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

336: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

337: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

338: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

339: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

Line 344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

340: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

341: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

342: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

343: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

Line 348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

344: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

345: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

346: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

347: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

348: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

349: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number

Line 354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

350: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date

Line 355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

351: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

352: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number

353: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date

354: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2

355: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

356: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2

357: ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date

Line 362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

358: ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date

Line 363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

359: ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2

360: ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date

Line 365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date

361: ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date

362: ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date

Line 367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

363: ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date

Line 368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date

364: ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

365: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date

366: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date

367: ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

368: ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number

Line 373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

369: ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

370: ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
378: --

Line 375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

371: ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
378: --
379: ,p_effective_start_date OUT NOCOPY DATE

Line 376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number

372: ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
378: --
379: ,p_effective_start_date OUT NOCOPY DATE
380: ,p_effective_end_date OUT NOCOPY DATE

Line 377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

373: ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375: ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376: ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377: ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
378: --
379: ,p_effective_start_date OUT NOCOPY DATE
380: ,p_effective_end_date OUT NOCOPY DATE
381: ,p_full_name OUT NOCOPY VARCHAR2