1837: -- Bug 2833630
1838: PROCEDURE update_salary_proposal(p_assignment_id number
1839: , p_effective_date date) IS
1840:
1841: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1842: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
1843: l_change_date per_pay_proposals.change_date%TYPE;
1844: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
1845: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
1838: PROCEDURE update_salary_proposal(p_assignment_id number
1839: , p_effective_date date) IS
1840:
1841: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1842: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
1843: l_change_date per_pay_proposals.change_date%TYPE;
1844: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
1845: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
1846: l_inv_next_sal_date_warning boolean;
1839: , p_effective_date date) IS
1840:
1841: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1842: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
1843: l_change_date per_pay_proposals.change_date%TYPE;
1844: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
1845: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
1846: l_inv_next_sal_date_warning boolean;
1847: l_proposed_salary_warning boolean;
1840:
1841: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1842: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
1843: l_change_date per_pay_proposals.change_date%TYPE;
1844: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
1845: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
1846: l_inv_next_sal_date_warning boolean;
1847: l_proposed_salary_warning boolean;
1848: l_approved_warning boolean;
1856:
1857: cursor csr_payproposal is
1858: select pay_proposal_id, object_version_number, change_date
1859: ,PROPOSED_SALARY_N
1860: from per_pay_proposals
1861: where assignment_id = p_assignment_id
1862: order by change_date DESC;
1863: BEGIN
1864: open csr_payproposal;