APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_APPLICATIONS

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

319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here
321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322: --Bug 3063591 End Here
323: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
324: -- Bug 3900299 Starts Here
325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

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

321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322: --Bug 3063591 End Here
323: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
324: -- Bug 3900299 Starts Here
325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

Line 327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

323: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
324: -- Bug 3900299 Starts Here
325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

324: -- Bug 3900299 Starts Here
325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

326: -- Bug 3900299 Ends Here
327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

327: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

328: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

329: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

330: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

331: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

332: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

333: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

334: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

335: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

336: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

337: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

338: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

339: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

340: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

341: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE

Line 346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

342: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

343: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE

Line 348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

344: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 349: ,p_current_employer IN per_applications.current_employer%TYPE

345: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE

Line 350: ,p_termination_reason IN per_applications.termination_reason%TYPE

346: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE

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

347: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 1044: ,p_application_id IN per_applications.application_id%TYPE

1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

Line 1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

1047: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

1048: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

1049: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

1050: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

1051: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

1052: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

1053: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

1054: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

1055: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

1056: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

1057: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

1058: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

1059: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE

Line 1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

1060: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

1061: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE

Line 1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

1062: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 1067: ,p_current_employer IN per_applications.current_employer%TYPE

1063: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

Line 1068: ,p_termination_reason IN per_applications.termination_reason%TYPE

1064: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

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

1065: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

Line 1478: ,p_application_id per_applications.application_id%TYPE

1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE

Line 1479: ,p_app_object_version_number per_applications.object_version_number%TYPE

1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE
1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE