APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_APPLICATIONS

Line 316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE

312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here
314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
315: --Bug 3063591 End Here
316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
317: -- Bug 3900299 Starts Here
318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

Line 318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE

314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
315: --Bug 3063591 End Here
316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
317: -- Bug 3900299 Starts Here
318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

Line 320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
317: -- Bug 3900299 Starts Here
318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

317: -- Bug 3900299 Starts Here
318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

319: -- Bug 3900299 Ends Here
320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

320: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

321: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

322: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

323: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

324: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

325: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

326: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

327: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

328: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

329: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

330: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

331: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

332: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

333: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

334: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE

Line 339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

335: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

336: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE

Line 341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

337: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 342: ,p_current_employer IN per_applications.current_employer%TYPE

338: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE

Line 343: ,p_termination_reason IN per_applications.termination_reason%TYPE

339: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
347: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE

Line 344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE

340: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
347: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
348: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 1037: ,p_application_id IN per_applications.application_id%TYPE

1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

Line 1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

1040: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

1041: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

1042: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

1043: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

1044: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

1045: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

1046: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

1047: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

1048: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

1049: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

1050: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

1051: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

1052: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE

Line 1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

1053: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

1054: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE

Line 1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

1055: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 1060: ,p_current_employer IN per_applications.current_employer%TYPE

1056: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

Line 1061: ,p_termination_reason IN per_applications.termination_reason%TYPE

1057: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

Line 1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE

1058: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1066: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

Line 1471: ,p_application_id per_applications.application_id%TYPE

1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE
1472: ,p_app_object_version_number per_applications.object_version_number%TYPE
1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE

Line 1472: ,p_app_object_version_number per_applications.object_version_number%TYPE

1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE
1472: ,p_app_object_version_number per_applications.object_version_number%TYPE
1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE