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 3020: ,p_application_id IN per_applications.application_id%TYPE

3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

Line 3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE

3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

Line 3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

Line 3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE

3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

Line 3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE

3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

Line 3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE

3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

Line 3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE

3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

Line 3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE

3023: ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

Line 3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE

3024: ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

Line 3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE

3025: ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

Line 3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE

3026: ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

Line 3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE

3027: ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

Line 3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE

3028: ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

Line 3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE

3029: ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

Line 3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE

3030: ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

Line 3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE

3031: ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

Line 3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE

3032: ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

Line 3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE

3033: ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

Line 3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE

3034: ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

Line 3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE

3035: ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE

Line 3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE

3036: ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE

Line 3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE

3037: ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE

Line 3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE

3038: ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

Line 3043: ,p_current_employer IN per_applications.current_employer%TYPE

3039: ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

Line 3044: ,p_termination_reason IN per_applications.termination_reason%TYPE

3040: ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

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

3041: ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
3042: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
3043: ,p_current_employer IN per_applications.current_employer%TYPE
3044: ,p_termination_reason IN per_applications.termination_reason%TYPE
3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

Line 3476: l_app_object_version_number per_applications.object_version_number%TYPE;

3472: --
3473: l_pgp_rec pay_people_groups%ROWTYPE;
3474: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3475: --
3476: l_app_object_version_number per_applications.object_version_number%TYPE;
3477: --
3478: l_address_id per_addresses.address_id%TYPE;
3479: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3480: --

Line 7062: ,p_application_id per_applications.application_id%TYPE

7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE

Line 7063: ,p_app_object_version_number per_applications.object_version_number%TYPE

7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE
7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE