eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PEL_BUS dependencies on STANDARD

Line 601: ,p_standard_link_flag in out nocopy varchar2

597: ,p_qualifying_age in out nocopy varchar2
598: ,p_qualifying_length_of_service in out nocopy varchar2
599: ,p_qualifying_units in out nocopy varchar2
600: ,p_multiply_value_flag in out nocopy varchar2
601: ,p_standard_link_flag in out nocopy varchar2
602: ,p_effective_date in date
603: ) is
604: --
605: l_proc varchar2(72) := g_package || 'chk_defaults';

Line 609: standard_link_flag,multiply_value_flag

605: l_proc varchar2(72) := g_package || 'chk_defaults';
606:
607: cursor csr_Defaults is
608: select qualifying_age,qualifying_length_of_service,qualifying_units,
609: standard_link_flag,multiply_value_flag
610: from pay_element_types_f
611: where element_type_id = p_element_type_id;
612: --
613: begin

Line 657: p_standard_link_flag := nvl(p_standard_link_flag,rec.standard_link_flag);

653: nvl(p_qualifying_length_of_service,rec.qualifying_length_of_service);
654: p_qualifying_units := nvl(p_qualifying_units,rec.qualifying_units);
655: p_multiply_value_flag :=
656: nvl(p_multiply_value_flag,rec.multiply_value_flag);
657: p_standard_link_flag := nvl(p_standard_link_flag,rec.standard_link_flag);
658: end loop;
659:
660: --
661: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 766: -- |----------------------------------------------|

762: end chk_end_date;
763:
764: --
765: -- ---------------------------------------------------------------------------
766: -- |----------------------------------------------|
767: -- ---------------------------------------------------------------------------
768: --
769: procedure chk_standard_entries
770: ( p_business_group_id in number

Line 769: procedure chk_standard_entries

765: -- ---------------------------------------------------------------------------
766: -- |----------------------------------------------|
767: -- ---------------------------------------------------------------------------
768: --
769: procedure chk_standard_entries
770: ( p_business_group_id in number
771: ,p_element_link_id in number
772: ,p_element_type_id in number
773: ,p_effective_start_date in date

Line 787: l_proc varchar2(72) := g_package || 'chk_standard_entries';

783: ,p_employment_category in varchar2
784: ,p_people_group_id in number
785: ) is
786: --
787: l_proc varchar2(72) := g_package || 'chk_standard_entries';
788: --
789: begin
790: hr_utility.set_location('Entering:'||l_proc,10);
791: --

Line 810: end chk_standard_entries;

806: p_employment_category,
807: p_people_group_id);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc,20);
810: end chk_standard_entries;
811:
812: --
813: -- ---------------------------------------------------------------------------
814: -- |---------------------------------------------------------|

Line 1519: -- |-------------------------------------------------|

1515: end;
1516:
1517: --
1518: -- ---------------------------------------------------------------------------
1519: -- |-------------------------------------------------|
1520: -- ---------------------------------------------------------------------------
1521: -- {Start Of Comments}
1522: --
1523: -- Description:

Line 1525: -- satisfied when the standard link flag is updated from No to Yes:

1521: -- {Start Of Comments}
1522: --
1523: -- Description:
1524: -- This procedure is used to ensure the following business rules are
1525: -- satisfied when the standard link flag is updated from No to Yes:
1526: -- 1. the change will not take place over the lifetime of the link.
1527: -- (ie. there exist date-effective updates to the link).
1528: -- 2. no entries exist for the link.
1529: -- 3. no salary basis is associated with the standard link element.

Line 1529: -- 3. no salary basis is associated with the standard link element.

1525: -- satisfied when the standard link flag is updated from No to Yes:
1526: -- 1. the change will not take place over the lifetime of the link.
1527: -- (ie. there exist date-effective updates to the link).
1528: -- 2. no entries exist for the link.
1529: -- 3. no salary basis is associated with the standard link element.
1530: -- We also check in this procedure that the standard link flag is never set
1531: -- to 'Y' for elements whose processing type is non-recurring.
1532: --
1533: -- In Arguments:

Line 1530: -- We also check in this procedure that the standard link flag is never set

1526: -- 1. the change will not take place over the lifetime of the link.
1527: -- (ie. there exist date-effective updates to the link).
1528: -- 2. no entries exist for the link.
1529: -- 3. no salary basis is associated with the standard link element.
1530: -- We also check in this procedure that the standard link flag is never set
1531: -- to 'Y' for elements whose processing type is non-recurring.
1532: --
1533: -- In Arguments:
1534: -- p_element_type_id

Line 1537: -- p_standard_link_flag

1533: -- In Arguments:
1534: -- p_element_type_id
1535: -- p_business_group_id
1536: -- p_element_link_id
1537: -- p_standard_link_flag
1538: -- p_effective_date
1539: -- p_datetrack_mode
1540: --
1541: -- Post Success:

Line 1550: procedure chk_standard_link_flag

1546: --
1547: -- {End Of Comments}
1548: -- ----------------------------------------------------------------------------
1549:
1550: procedure chk_standard_link_flag
1551: (p_element_type_id in number,
1552: p_business_group_id in number,
1553: p_element_link_id in number,
1554: p_standard_link_flag in varchar2,

Line 1554: p_standard_link_flag in varchar2,

1550: procedure chk_standard_link_flag
1551: (p_element_type_id in number,
1552: p_business_group_id in number,
1553: p_element_link_id in number,
1554: p_standard_link_flag in varchar2,
1555: p_effective_date in date,
1556: p_datetrack_mode in varchar2
1557: ) is
1558: --

Line 1559: l_proc varchar2(72) := g_package || 'chk_standard_link_flag';

1555: p_effective_date in date,
1556: p_datetrack_mode in varchar2
1557: ) is
1558: --
1559: l_proc varchar2(72) := g_package || 'chk_standard_link_flag';
1560: l_dummy varchar2(1);
1561: l_processing_type varchar2(30);
1562: l_pay_basis_exists number;
1563:

Line 1594: -- Only check for change of standard link flag if not inserting

1590: --
1591: begin
1592: hr_utility.set_location('Entering:'||l_proc,10);
1593: --
1594: -- Only check for change of standard link flag if not inserting
1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then
1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'
1598: and p_standard_link_flag = 'Y' then

Line 1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'

1593: --
1594: -- Only check for change of standard link flag if not inserting
1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then
1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'
1598: and p_standard_link_flag = 'Y' then
1599: hr_utility.set_location(l_proc,20);
1600: open csr_DateEffRecs;
1601: fetch csr_DateEffRecs into l_dummy;

Line 1598: and p_standard_link_flag = 'Y' then

1594: -- Only check for change of standard link flag if not inserting
1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then
1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'
1598: and p_standard_link_flag = 'Y' then
1599: hr_utility.set_location(l_proc,20);
1600: open csr_DateEffRecs;
1601: fetch csr_DateEffRecs into l_dummy;
1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then

Line 1612: -- Match standard link flag against processing type

1608: end if;
1609: end if;
1610: --
1611: -- Bugfix 5012412
1612: -- Match standard link flag against processing type
1613: if (p_standard_link_flag = 'Y') then
1614: hr_utility.set_location(l_proc,30);
1615: --
1616: open csr_ProcessingType;

Line 1613: if (p_standard_link_flag = 'Y') then

1609: end if;
1610: --
1611: -- Bugfix 5012412
1612: -- Match standard link flag against processing type
1613: if (p_standard_link_flag = 'Y') then
1614: hr_utility.set_location(l_proc,30);
1615: --
1616: open csr_ProcessingType;
1617: fetch csr_ProcessingType into l_processing_type;

Line 1623: -- Standard link flag can only be 'Y' if processing type is 'R', i.e. recurring

1619: --
1620: if (l_processing_type = 'N')
1621: then
1622: hr_utility.set_location(l_proc,40);
1623: -- Standard link flag can only be 'Y' if processing type is 'R', i.e. recurring
1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');
1625: fnd_message.raise_error;
1626: end if;
1627: --

Line 1649: end chk_standard_link_flag;

1645: end if;
1646: --
1647: hr_utility.set_location(' Leaving:'||l_proc,50);
1648:
1649: end chk_standard_link_flag;
1650:
1651: --
1652: -- ---------------------------------------------------------------------------
1653: -- |----------------------------------------------------|

Line 1707: if p_rec.standard_link_flag = 'Y'

1703: -- Validate Dependent Attributes
1704: --
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

Line 1709: pay_pel_bus.chk_standard_link_flag

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

Line 1713: ,p_standard_link_flag => p_rec.standard_link_flag

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
1714: ,p_effective_date => p_effective_date
1715: ,p_datetrack_mode => p_datetrack_mode
1716: );
1717: end if;

Line 1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;

1806: l_qualifying_length_of_service
1807: pay_element_links_f.qualifying_length_of_service%TYPE;
1808: l_qualifying_units pay_element_links_f.qualifying_units%TYPE;
1809: l_multiply_value_flag pay_element_links_f.multiply_value_flag%TYPE;
1810: l_standard_link_flag pay_element_links_f.standard_link_flag%TYPE;
1811:
1812:
1813: --
1814: Begin

Line 1855: -- Check for Standard link flag update

1851: (p_object_type => 'EL'
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

Line 1856: pay_pel_bus.chk_standard_link_flag

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

Line 1860: ,p_standard_link_flag => p_rec.standard_link_flag

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
1861: ,p_effective_date => p_effective_date
1862: ,p_datetrack_mode => p_datetrack_mode
1863: );
1864:

Line 1876: l_standard_link_flag := p_rec.standard_link_flag;

1872: l_qualifying_age := p_rec.qualifying_age;
1873: l_qualifying_length_of_service := p_rec.qualifying_length_of_service;
1874: l_qualifying_units := p_rec.qualifying_units;
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

Line 1885: ,p_standard_link_flag => l_standard_link_flag

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
1884: ,p_multiply_value_flag => l_multiply_value_flag
1885: ,p_standard_link_flag => l_standard_link_flag
1886: ,p_effective_date => p_effective_date
1887: );
1888:
1889: