APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PAY_PROPOSALS

Line 423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE

Line 424: ,p_change_date IN per_pay_proposals.change_date%TYPE

420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE

Line 425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE

Line 426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE

Line 427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE

423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE

Line 428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE

424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE

Line 429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE

425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE

Line 430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE

426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE

Line 431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE

427: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE

Line 432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE

428: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE

Line 433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE

429: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE

Line 434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE

430: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE

Line 435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE

431: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE

Line 436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE

432: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE

Line 437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE

433: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE

Line 438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE

434: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE

Line 439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE

435: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE

Line 440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE

436: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE

Line 441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE

437: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE

Line 442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE

438: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE

Line 443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE

439: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE

Line 444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE

440: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE

Line 445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE

441: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
449: ,p_approved IN per_pay_proposals.approved%TYPE

Line 446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE

442: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
449: ,p_approved IN per_pay_proposals.approved%TYPE
450: ,p_deployment_factor_id OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE

Line 447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE

443: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
449: ,p_approved IN per_pay_proposals.approved%TYPE
450: ,p_deployment_factor_id OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
451: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE

Line 448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE

444: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
449: ,p_approved IN per_pay_proposals.approved%TYPE
450: ,p_deployment_factor_id OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
451: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
452: ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE

Line 449: ,p_approved IN per_pay_proposals.approved%TYPE

445: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
446: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
447: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
448: ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
449: ,p_approved IN per_pay_proposals.approved%TYPE
450: ,p_deployment_factor_id OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
451: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
452: ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE
453: ,p_relocate_domestically IN per_deployment_factors.relocate_domestically%TYPE

Line 784: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

780: l_phn_object_version_number per_phones.object_version_number%TYPE;
781: --
782: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
783: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
784: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
785: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
786: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
787: l_inv_next_sal_date_warning BOOLEAN;
788: l_proposed_salary_warning BOOLEAN;

Line 785: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;

781: --
782: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
783: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
784: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
785: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
786: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
787: l_inv_next_sal_date_warning BOOLEAN;
788: l_proposed_salary_warning BOOLEAN;
789: l_approved_warning BOOLEAN;

Line 3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

3117: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3118: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3119: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3120: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE

Line 3122: ,p_change_date IN per_pay_proposals.change_date%TYPE

3118: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3119: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3120: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE

Line 3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

3119: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3120: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE

Line 3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

3120: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE

Line 3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE

3121: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE

Line 3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE

3122: ,p_change_date IN per_pay_proposals.change_date%TYPE
3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE

Line 3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE

3123: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE

Line 3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE

3124: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE

Line 3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE

3125: ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE

Line 3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE

3126: ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE

Line 3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE

3127: ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE

Line 3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE

3128: ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE

Line 3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE

3129: ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE

Line 3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE

3130: ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE

Line 3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE

3131: ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE

Line 3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE

3132: ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE

Line 3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE

3133: ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE

Line 3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE

3134: ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE

Line 3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE

3135: ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE

Line 3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE

3136: ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE

Line 3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE

3137: ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE

Line 3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE

3138: ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE

Line 3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE

3139: ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
3147: ,p_approved IN per_pay_proposals.approved%TYPE

Line 3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE

3140: ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
3147: ,p_approved IN per_pay_proposals.approved%TYPE
3148: ,p_deployment_factor_id IN OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE

Line 3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE

3141: ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
3147: ,p_approved IN per_pay_proposals.approved%TYPE
3148: ,p_deployment_factor_id IN OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
3149: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE

Line 3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE

3142: ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
3147: ,p_approved IN per_pay_proposals.approved%TYPE
3148: ,p_deployment_factor_id IN OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
3149: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
3150: ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE

Line 3147: ,p_approved IN per_pay_proposals.approved%TYPE

3143: ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
3144: ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
3145: ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
3146: ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
3147: ,p_approved IN per_pay_proposals.approved%TYPE
3148: ,p_deployment_factor_id IN OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
3149: ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
3150: ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE
3151: ,p_relocate_domestically IN per_deployment_factors.relocate_domestically%TYPE

Line 3486: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

3482: l_phn_object_version_number per_phones.object_version_number%TYPE;
3483: --
3484: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
3485: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
3486: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
3487: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
3488: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3489: l_inv_next_sal_date_warning BOOLEAN;
3490: l_proposed_salary_warning BOOLEAN;

Line 3487: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;

3483: --
3484: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
3485: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
3486: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
3487: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
3488: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3489: l_inv_next_sal_date_warning BOOLEAN;
3490: l_proposed_salary_warning BOOLEAN;
3491: l_approved_warning BOOLEAN;

Line 7078: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE

7074: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7075: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7076: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7077: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7078: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
7079: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
7080: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE
7081: ,p_dpf_object_version_number per_deployment_factors.object_version_number%TYPE
7082: ,p_chk1_checklist_item_id per_checklist_items.checklist_item_id%TYPE

Line 7079: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE

7075: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7076: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7077: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7078: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
7079: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
7080: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE
7081: ,p_dpf_object_version_number per_deployment_factors.object_version_number%TYPE
7082: ,p_chk1_checklist_item_id per_checklist_items.checklist_item_id%TYPE
7083: ,p_chk1_object_version_number per_checklist_items.object_version_number%TYPE