DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PER_PYP_SHD

Line 1340: per_pyp_shd.lck

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

Line 1345: l_change_date:=per_pyp_shd.g_old_rec.change_date;

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: --

Line 1504: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;

1500: close get_element;
1501: hr_utility.set_location(l_proc,20);
1502: --
1503: if p_proposed_salary_n = hr_api.g_number then
1504: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1505: else
1506: l_proposed_salary_n:=p_proposed_salary_n;
1507: end if;
1508: maintain_elements_bsp(p_pay_proposal_id

Line 1522: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;

1518: into l_assignment_id
1519: from per_pay_proposals pyp
1520: where pyp.pay_proposal_id=p_pay_proposal_id;
1521: if p_proposed_salary_n = hr_api.g_number then
1522: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1523: else
1524: l_proposed_salary_n:=p_proposed_salary_n;
1525: end if;
1526: maintain_elements_bsp(p_pay_proposal_id

Line 1817: per_pyp_shd.lck

1813: l_object_version_number := p_object_version_number;
1814: --
1815: -- get the old record details
1816: --
1817: per_pyp_shd.lck
1818: (p_pay_proposal_id => p_pay_proposal_id
1819: ,p_object_version_number => p_object_version_number);
1820: --
1821: if p_change_date = hr_api.g_date then

Line 1822: l_change_date:=per_pyp_shd.g_old_rec.change_date;

1818: (p_pay_proposal_id => p_pay_proposal_id
1819: ,p_object_version_number => p_object_version_number);
1820: --
1821: if p_change_date = hr_api.g_date then
1822: l_change_date:=per_pyp_shd.g_old_rec.change_date;
1823: else
1824: l_change_date := trunc(p_change_date);
1825: end if;
1826: --

Line 1852: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;

1848: --
1849: /* last approved proposal is end-dated if proposals are
1850: approved through SalMgmt screen. Bug#7386307 by schowdhu
1851: */
1852: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1853: --
1854: if (nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') then
1855: end_date_approved_proposal(l_assignment_id, l_change_date-1, p_pay_proposal_id);
1856: end if;

Line 1854: if (nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') then

1850: approved through SalMgmt screen. Bug#7386307 by schowdhu
1851: */
1852: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1853: --
1854: if (nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') then
1855: end_date_approved_proposal(l_assignment_id, l_change_date-1, p_pay_proposal_id);
1856: end if;
1857: update_last_change_date(l_assignment_id, l_change_date);
1858: --

Line 1860: if(nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') THEN

1856: end if;
1857: update_last_change_date(l_assignment_id, l_change_date);
1858: --
1859:
1860: if(nvl(per_pyp_shd.g_old_rec.approved,'N')<>'Y') THEN
1861: --
1862: -- only do this if the salary is not approved.
1863: --
1864: per_pyp_upd.upd

Line 1884: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;

1880: --
1881: hr_utility.set_location(l_proc,10);
1882: --
1883: -- Bug 1732348 Fix
1884: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1885: open get_element;
1886: fetch get_element into l_element_entry_id; -- ,l_assignment_id;
1887: close get_element;
1888: --

Line 1891: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;

1887: close get_element;
1888: --
1889: --
1890: if p_proposed_salary_n = hr_api.g_number then
1891: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1892: else
1893: l_proposed_salary_n:=p_proposed_salary_n;
1894: end if;
1895: --

Line 2824: l_pyp_rec per_pyp_shd.g_rec_type;

2820: p_payroll_warning out nocopy boolean
2821: ) as
2822: l_proc varchar2(72) := g_package||'cre_or_upd_salary_proposal';
2823: l_api_updating boolean;
2824: l_pyp_rec per_pyp_shd.g_rec_type;
2825: l_null_pyp_rec per_pyp_shd.g_rec_type;
2826: l_inv_next_sal_date_warning boolean;
2827: l_proposed_salary_warning boolean;
2828: l_approved_warning boolean;

Line 2825: l_null_pyp_rec per_pyp_shd.g_rec_type;

2821: ) as
2822: l_proc varchar2(72) := g_package||'cre_or_upd_salary_proposal';
2823: l_api_updating boolean;
2824: l_pyp_rec per_pyp_shd.g_rec_type;
2825: l_null_pyp_rec per_pyp_shd.g_rec_type;
2826: l_inv_next_sal_date_warning boolean;
2827: l_proposed_salary_warning boolean;
2828: l_approved_warning boolean;
2829: l_payroll_warning boolean;

Line 2864: l_api_updating := per_pyp_shd.api_updating

2860:
2861: l_pay_proposal_id := p_pay_proposal_id;
2862: l_object_version_number := p_object_version_number;
2863:
2864: l_api_updating := per_pyp_shd.api_updating
2865: (p_pay_proposal_id => p_pay_proposal_id
2866: ,p_object_version_number => p_object_version_number);
2867: hr_utility.set_location(l_proc, 20);
2868:

Line 2877: per_pyp_shd.convert_args

2873: --
2874: -- set the record
2875: --
2876: l_pyp_rec :=
2877: per_pyp_shd.convert_args
2878: (p_pay_proposal_id
2879: ,p_assignment_id
2880: ,p_business_group_id
2881: ,p_change_date

Line 2919: per_pyp_shd.g_old_rec:=l_null_pyp_rec;

2915: if not l_api_updating then
2916: --
2917: -- set g_old_rec to null
2918: --
2919: per_pyp_shd.g_old_rec:=l_null_pyp_rec;
2920: hr_utility.set_location(l_proc, 30);
2921: --
2922: -- convert the null values
2923: --

Line 3005: per_pyp_shd.lck

3001: --
3002: -- updating not inserting
3003: --
3004: hr_utility.set_location(l_proc, 70);
3005: per_pyp_shd.lck
3006: (p_pay_proposal_id => p_pay_proposal_id
3007: ,p_object_version_number => p_object_version_number);
3008: --
3009: -- convert the null values