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 1503: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;

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

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

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

Line 1816: per_pyp_shd.lck

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

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

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

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

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;

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

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

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

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

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

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

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

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

Line 2822: l_pyp_rec per_pyp_shd.g_rec_type;

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;

Line 2823: l_null_pyp_rec per_pyp_shd.g_rec_type;

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;

Line 2862: l_api_updating := per_pyp_shd.api_updating

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:

Line 2875: per_pyp_shd.convert_args

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

Line 2917: per_pyp_shd.g_old_rec:=l_null_pyp_rec;

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

Line 3003: per_pyp_shd.lck

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