APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_APPLICATIONS

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

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

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

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

Line 324: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

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

Line 325: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

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

Line 326: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

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

Line 327: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

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

Line 328: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

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

Line 329: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

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

Line 330: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

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

Line 331: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

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

Line 332: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

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

Line 333: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

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

Line 334: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

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

Line 335: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

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

Line 336: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

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

Line 337: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

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

Line 338: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

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

Line 339: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

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

Line 340: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

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

Line 341: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

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

Line 342: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

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

Line 343: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

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

Line 344: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

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

Line 345: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

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

Line 346: ,p_current_employer IN per_applications.current_employer%TYPE

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

Line 347: ,p_termination_reason IN per_applications.termination_reason%TYPE

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

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

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

Line 773: l_app_object_version_number per_applications.object_version_number%TYPE;

769: --
770: l_pgp_rec pay_people_groups%ROWTYPE;
771: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
772: --
773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;
775: --
776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;

Line 774: l_application_id per_applications.application_id%TYPE;

770: l_pgp_rec pay_people_groups%ROWTYPE;
771: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
772: --
773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;
775: --
776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;
778: --

Line 2986: ,p_application_id IN per_applications.application_id%TYPE

2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

Line 2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

2989: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

2990: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

2991: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

2992: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

2993: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

2994: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

2995: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

2996: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

2997: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

2998: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

2999: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

3000: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

3001: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE

Line 3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

3002: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

3003: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE

Line 3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

3004: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 3009: ,p_current_employer IN per_applications.current_employer%TYPE

3005: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

Line 3010: ,p_termination_reason IN per_applications.termination_reason%TYPE

3006: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

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

3007: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3008: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3009: ,p_current_employer IN per_applications.current_employer%TYPE
3010: ,p_termination_reason IN per_applications.termination_reason%TYPE
3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

Line 3442: l_app_object_version_number per_applications.object_version_number%TYPE;

3438: --
3439: l_pgp_rec pay_people_groups%ROWTYPE;
3440: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3441: --
3442: l_app_object_version_number per_applications.object_version_number%TYPE;
3443: --
3444: l_address_id per_addresses.address_id%TYPE;
3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3446: --

Line 7022: ,p_application_id per_applications.application_id%TYPE

7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE

Line 7023: ,p_app_object_version_number per_applications.object_version_number%TYPE

7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE