[Home] [Help]
1: Package Body pay_pel_bus as
2: /* $Header: pypelrhi.pkb 120.7.12010000.3 2008/10/03 08:41:56 ankagarw ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_pel_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --
112: ,p_argument => 'element_link_id'
113: ,p_argument_value => p_element_link_id
114: );
115: --
116: if ( nvl(pay_pel_bus.g_element_link_id, hr_api.g_number)
117: = p_element_link_id) then
118: --
119: -- The legislation code has already been found with a previous
120: -- call to this function. Just return the value in the global
119: -- The legislation code has already been found with a previous
120: -- call to this function. Just return the value in the global
121: -- variable.
122: --
123: l_legislation_code := pay_pel_bus.g_legislation_code;
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --
145: close csr_leg_code;
146: pay_pel_bus.g_element_link_id := p_element_link_id;
147: pay_pel_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
143: -- available for the next call to this function.
144: --
145: close csr_leg_code;
146: pay_pel_bus.g_element_link_id := p_element_link_id;
147: pay_pel_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
1705: --
1706:
1707: if p_rec.standard_link_flag = 'Y'
1708: then
1709: pay_pel_bus.chk_standard_link_flag
1710: (p_element_type_id => p_rec.element_type_id
1711: ,p_business_group_id => p_rec.business_group_id
1712: ,p_element_link_id => p_rec.element_link_id
1713: ,p_standard_link_flag => p_rec.standard_link_flag
1715: ,p_datetrack_mode => p_datetrack_mode
1716: );
1717: end if;
1718:
1719: pay_pel_bus.chk_ben_contri
1720: (p_element_type_id => p_rec.element_type_id
1721: ,p_effective_start_date => p_effective_date
1722: );
1723:
1720: (p_element_type_id => p_rec.element_type_id
1721: ,p_effective_start_date => p_effective_date
1722: );
1723:
1724: pay_pel_bus.chk_emp_cat
1725: (p_employment_category => p_rec.employment_category,
1726: p_effective_date => p_effective_date
1727: );
1728:
1727: );
1728:
1729:
1730: if p_rec.job_id is not null then
1731: pay_pel_bus.chk_job_id
1732: (p_business_group_id => p_rec.business_group_id,
1733: p_job_id => p_rec.job_id,
1734: p_effective_date => p_effective_date
1735: );
1743: );
1744: end if;
1745:
1746: if p_rec.grade_id is not null then
1747: pay_pel_bus.chk_grade_id
1748: (p_business_group_id => p_rec.business_group_id,
1749: p_grade_id => p_rec.grade_id,
1750: p_effective_date => p_effective_date
1751: );
1751: );
1752: end if;
1753:
1754: if p_rec.people_group_id is not null then
1755: pay_pel_bus.chk_people_group_id
1756: (p_people_group_id => p_rec.people_group_id,
1757: p_effective_date => p_effective_date
1758: );
1759: end if;
1759: end if;
1760:
1761:
1762: if p_rec.position_id is not null then
1763: pay_pel_bus.chk_position
1764: (p_business_group_id => p_rec.business_group_id
1765: ,p_position_id => p_rec.position_id
1766: ,p_organization_id => p_rec.organization_id
1767: ,p_job_id => p_rec.job_id
1768: ,p_effective_date => p_effective_date
1769: );
1770: end if;
1771:
1772: pay_pel_bus.chk_linktoallpr
1773: (p_link_to_all_payrolls_flag => p_rec.link_to_all_payrolls_flag
1774: ,p_payroll_id => p_rec.payroll_id
1775: );
1776:
1773: (p_link_to_all_payrolls_flag => p_rec.link_to_all_payrolls_flag
1774: ,p_payroll_id => p_rec.payroll_id
1775: );
1776:
1777: pay_pel_bus.chk_costable_type
1778: (p_effective_date => p_effective_date
1779: ,p_element_link_id => p_rec.element_link_id
1780: ,p_business_group_id => p_rec.business_group_id
1781: ,p_element_type_id => p_rec.element_type_id
1852: ,p_object_id => p_rec.element_link_id
1853: );
1854:
1855: -- Check for Standard link flag update
1856: pay_pel_bus.chk_standard_link_flag
1857: (p_element_type_id => p_rec.element_type_id
1858: ,p_business_group_id => p_rec.business_group_id
1859: ,p_element_link_id => p_rec.element_link_id
1860: ,p_standard_link_flag => p_rec.standard_link_flag
1862: ,p_datetrack_mode => p_datetrack_mode
1863: );
1864:
1865: -- Check for Costable type updation
1866: pay_pel_bus.chk_costable_type_for_upd
1867: (p_costable_type => p_rec.costable_type ,
1868: p_datetrack_mode => p_datetrack_mode);
1869:
1870: -- Check qualifying conditions
1875: l_multiply_value_flag := p_rec.multiply_value_flag;
1876: l_standard_link_flag := p_rec.standard_link_flag;
1877:
1878:
1879: pay_pel_bus.chk_defaults
1880: (p_element_type_id => null
1881: ,p_qualifying_age => l_qualifying_age
1882: ,p_qualifying_length_of_service => l_qualifying_length_of_service
1883: ,p_qualifying_units => l_qualifying_units
1888:
1889:
1890:
1891: -- Check for general checks for costable type
1892: pay_pel_bus.chk_costable_type
1893: (p_effective_date => p_effective_date,
1894: p_element_link_id => p_rec.element_link_id,
1895: p_business_group_id => p_rec.business_group_id,
1896: p_element_type_id => p_rec.element_type_id,
1931: --
1932: hr_utility.set_location(' Leaving:'||l_proc, 10);
1933: End delete_validate;
1934: --
1935: end pay_pel_bus;