1336: --
1337: --
1338: -- get the old record details
1339: --
1340: per_pyp_shd.lck
1341: (p_pay_proposal_id => p_pay_proposal_id
1342: ,p_object_version_number => p_object_version_number);
1343: --
1344: if p_change_date = hr_api.g_date then
1341: (p_pay_proposal_id => p_pay_proposal_id
1342: ,p_object_version_number => p_object_version_number);
1343: --
1344: if p_change_date = hr_api.g_date then
1345: l_change_date:=per_pyp_shd.g_old_rec.change_date;
1346: else
1347: l_change_date := trunc(p_change_date);
1348: end if;
1349: --
1499: close get_element;
1500: hr_utility.set_location(l_proc,20);
1501: --
1502: if p_proposed_salary_n = hr_api.g_number then
1503: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1504: else
1505: l_proposed_salary_n:=p_proposed_salary_n;
1506: end if;
1507: maintain_elements_bsp(p_pay_proposal_id
1517: into l_assignment_id
1518: from per_pay_proposals pyp
1519: where pyp.pay_proposal_id=p_pay_proposal_id;
1520: if p_proposed_salary_n = hr_api.g_number then
1521: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1522: else
1523: l_proposed_salary_n:=p_proposed_salary_n;
1524: end if;
1525: maintain_elements_bsp(p_pay_proposal_id
1812: l_object_version_number := p_object_version_number;
1813: --
1814: -- get the old record details
1815: --
1816: per_pyp_shd.lck
1817: (p_pay_proposal_id => p_pay_proposal_id
1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if p_change_date = hr_api.g_date then
1817: (p_pay_proposal_id => p_pay_proposal_id
1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if p_change_date = hr_api.g_date then
1821: l_change_date:=per_pyp_shd.g_old_rec.change_date;
1822: else
1823: l_change_date := trunc(p_change_date);
1824: end if;
1825: --
1847: --
1848: /* last approved proposal is end-dated if proposals are
1849: approved through SalMgmt screen. Bug#7386307 by schowdhu
1850: */
1851: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1852: --
1853: if (nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') then
1854: end_date_approved_proposal(l_assignment_id, l_change_date-1, p_pay_proposal_id);
1855: end if;
1849: approved through SalMgmt screen. Bug#7386307 by schowdhu
1850: */
1851: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1852: --
1853: if (nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') then
1854: end_date_approved_proposal(l_assignment_id, l_change_date-1, p_pay_proposal_id);
1855: end if;
1856: update_last_change_date(l_assignment_id, l_change_date);
1857: --
1855: end if;
1856: update_last_change_date(l_assignment_id, l_change_date);
1857: --
1858:
1859: if(nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') THEN
1860: --
1861: -- only do this if the salary is not approved.
1862: --
1863: per_pyp_upd.upd
1879: --
1880: hr_utility.set_location(l_proc,10);
1881: --
1882: -- Bug 1732348 Fix
1883: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1884: open get_element;
1885: fetch get_element into l_element_entry_id; -- ,l_assignment_id;
1886: close get_element;
1887: --
1886: close get_element;
1887: --
1888: --
1889: if p_proposed_salary_n = hr_api.g_number then
1890: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1891: else
1892: l_proposed_salary_n:=p_proposed_salary_n;
1893: end if;
1894: --
2818: p_payroll_warning out nocopy boolean
2819: ) as
2820: l_proc varchar2(72) := g_package||'cre_or_upd_salary_proposal';
2821: l_api_updating boolean;
2822: l_pyp_rec per_pyp_shd.g_rec_type;
2823: l_null_pyp_rec per_pyp_shd.g_rec_type;
2824: l_inv_next_sal_date_warning boolean;
2825: l_proposed_salary_warning boolean;
2826: l_approved_warning boolean;
2819: ) as
2820: l_proc varchar2(72) := g_package||'cre_or_upd_salary_proposal';
2821: l_api_updating boolean;
2822: l_pyp_rec per_pyp_shd.g_rec_type;
2823: l_null_pyp_rec per_pyp_shd.g_rec_type;
2824: l_inv_next_sal_date_warning boolean;
2825: l_proposed_salary_warning boolean;
2826: l_approved_warning boolean;
2827: l_payroll_warning boolean;
2858:
2859: l_pay_proposal_id := p_pay_proposal_id;
2860: l_object_version_number := p_object_version_number;
2861:
2862: l_api_updating := per_pyp_shd.api_updating
2863: (p_pay_proposal_id => p_pay_proposal_id
2864: ,p_object_version_number => p_object_version_number);
2865: hr_utility.set_location(l_proc, 20);
2866:
2871: --
2872: -- set the record
2873: --
2874: l_pyp_rec :=
2875: per_pyp_shd.convert_args
2876: (p_pay_proposal_id
2877: ,p_assignment_id
2878: ,p_business_group_id
2879: ,p_change_date
2913: if not l_api_updating then
2914: --
2915: -- set g_old_rec to null
2916: --
2917: per_pyp_shd.g_old_rec:=l_null_pyp_rec;
2918: hr_utility.set_location(l_proc, 30);
2919: --
2920: -- convert the null values
2921: --
2999: --
3000: -- updating not inserting
3001: --
3002: hr_utility.set_location(l_proc, 70);
3003: per_pyp_shd.lck
3004: (p_pay_proposal_id => p_pay_proposal_id
3005: ,p_object_version_number => p_object_version_number);
3006: --
3007: -- convert the null values