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_IVL_BUS dependencies on PAY_IVL_SHD

Line 18: where input_value_id = pay_ivl_shd.g_old_rec.input_value_id;

14: g_input_value_id number default null;
15:
16: cursor csr_row_count is
17: select count(*) from pay_input_values_f
18: where input_value_id = pay_ivl_shd.g_old_rec.input_value_id;
19: --
20: -- ---------------------------------------------------------------------------
21: -- |----------------------< set_security_group_id >--------------------------|
22: -- ---------------------------------------------------------------------------

Line 193: ,p_rec in pay_ivl_shd.g_rec_type

189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure chk_non_updateable_args
192: (p_effective_date in date
193: ,p_rec in pay_ivl_shd.g_rec_type
194: ) IS
195: --
196:
197: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';

Line 204: IF NOT pay_ivl_shd.api_updating

200: --
201: -- Only proceed with the validation if a row exists for the current
202: -- record in the HR Schema.
203: --
204: IF NOT pay_ivl_shd.api_updating
205: (p_input_value_id => p_rec.input_value_id
206: ,p_effective_date => p_effective_date
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN

Line 295: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');

291: ,p_to_date => p_validation_end_date))) Then
292: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
293: fnd_message.set_token('TABLE_NAME','element types');
294: hr_multi_message.add
295: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
296: End If;
297: --
298: Exception
299: When Others Then

Line 802: if (p_name <> pay_ivl_shd.g_old_rec.name or p_display_sequence

798: BEGIN
799:
800: hr_utility.set_location(' Entering:'|| l_proc, 10);
801:
802: if (p_name <> pay_ivl_shd.g_old_rec.name or p_display_sequence
803: <> pay_ivl_shd.g_old_rec.display_sequence) then
804: pay_element_types_pkg.check_for_paylink_batches
805: (p_element_type_id => p_element_type_id
806: ,p_element_name => p_name);

Line 803: <> pay_ivl_shd.g_old_rec.display_sequence) then

799:
800: hr_utility.set_location(' Entering:'|| l_proc, 10);
801:
802: if (p_name <> pay_ivl_shd.g_old_rec.name or p_display_sequence
803: <> pay_ivl_shd.g_old_rec.display_sequence) then
804: pay_element_types_pkg.check_for_paylink_batches
805: (p_element_type_id => p_element_type_id
806: ,p_element_name => p_name);
807: end if;

Line 837: if (p_generate_db_items_flag <> pay_ivl_shd.g_old_rec.generate_db_items_flag)

833: BEGIN
834:
835: hr_utility.set_location(' Entering:'|| l_proc, 10);
836:
837: if (p_generate_db_items_flag <> pay_ivl_shd.g_old_rec.generate_db_items_flag)
838: and p_datetrack_mode <> 'CORRECTION' then
839: open csr_row_count;
840: fetch csr_row_count into l_count;
841: close csr_row_count;

Line 899: if (p_name <> pay_ivl_shd.g_old_rec.name) then

895:
896: hr_utility.set_location(' Entering:'|| l_proc, 10);
897:
898:
899: if (p_name <> pay_ivl_shd.g_old_rec.name) then
900:
901: -- Force Correction mode
902: if p_datetrack_mode <> 'CORRECTION' then
903: open csr_row_count;

Line 940: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then

936: fnd_message.raise_error;
937: end if;
938:
939: -- Check for the new name
940: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
941: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
942: fnd_message.raise_error;
943: end if;
944:

Line 950: if l_dummy = 'Y' and upper(pay_ivl_shd.g_old_rec.name)

946: -- and the name is one of these 'Coverage','EE Contr' and 'ER Contr'
947: open csr_ben_contri;
948: fetch csr_ben_contri into l_dummy;
949:
950: if l_dummy = 'Y' and upper(pay_ivl_shd.g_old_rec.name)
951: in ('COVERAGE','EE CONTR','ER CONTR')
952: then
953: close csr_ben_contri;
954: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');

Line 986: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))

982: cursor csr_uom is
983: select lookup_code from
984: hr_lookups
985: where upper(substr(lookup_code,1,2))
986: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
987: and lookup_type = 'UNITS'
988: and enabled_flag = 'Y'
989: and p_effective_date between
990: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

Line 1004: if (p_uom <> pay_ivl_shd.g_old_rec.uom and p_uom is not null) then

1000: hr_utility.set_location(' Entering:'|| l_proc, 10);
1001:
1002: -- Check that the UOM if updated to a not null value is
1003: -- within the class as the previous UOM value
1004: if (p_uom <> pay_ivl_shd.g_old_rec.uom and p_uom is not null) then
1005: if p_datetrack_mode <> 'CORRECTION' then
1006: open csr_row_count;
1007: fetch csr_row_count into l_count;
1008: close csr_row_count;

Line 1016: if pay_ivl_shd.g_old_rec.uom is not null then

1012: else
1013: p_datetrack_mode := 'CORRECTION';
1014: end if;
1015: end if;
1016: if pay_ivl_shd.g_old_rec.uom is not null then
1017: for rec in csr_uom
1018: loop
1019: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1020: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');

Line 1088: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then

1084: -- Check for element entries and Hot default flag
1085:
1086: open csr_entries;
1087: fetch csr_entries into l_dummy;
1088: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1089: close csr_entries;
1090: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1091: fnd_message.raise_error;
1092: end if;

Line 1121: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then

1117:
1118: hr_utility.set_location(' Entering:'|| l_proc, 10);
1119:
1120:
1121: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1122: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1123: fnd_message.raise_error;
1124: end if;
1125:

Line 1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,

1424: select 'X'
1425: from hr_lookups
1426: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1427: and lookup_type = decode(p_lookup_type,
1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1429: p_lookup_type)
1430: and enabled_flag = 'Y'
1431: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1432: and nvl(end_date_active,hr_api.g_eot);

Line 1443: pay_ivl_shd.g_old_rec.lookup_type is not null and

1439: --
1440: hr_utility.set_location(' Entering:'|| l_proc, 10);
1441: --
1442: if p_lookup_type is not null or (
1443: pay_ivl_shd.g_old_rec.lookup_type is not null and
1444: p_lookup_type = hr_api.g_varchar2
1445: ) then
1446: --
1447: open csr_lookup;

Line 1464: pay_ivl_shd.g_old_rec.value_set_id is not null and

1460: --
1461: elsif p_value_set_id is not null and p_default_value is not null and
1462: p_default_value <> hr_api.g_varchar2 and (
1463: p_value_set_id <> hr_api.g_number or (
1464: pay_ivl_shd.g_old_rec.value_set_id is not null and
1465: p_value_set_id = hr_api.g_number
1466: )
1467: ) then
1468: --

Line 1473: l_value_set_id := pay_ivl_shd.g_old_rec.value_set_id;

1469: if p_value_set_id = hr_api.g_number then
1470: --
1471: -- Value set id is not changing, use the old one
1472: --
1473: l_value_set_id := pay_ivl_shd.g_old_rec.value_set_id;
1474: --
1475: else
1476: --
1477: -- Value set id is changing, use the new one

Line 1498: elsif pay_ivl_shd.g_old_rec.min_value is not null

1494: fnd_message.raise_error;
1495: --
1496: end if;
1497: --
1498: elsif pay_ivl_shd.g_old_rec.min_value is not null
1499: or pay_ivl_shd.g_old_rec.max_value is not null then
1500: --
1501: if p_min_value <> pay_ivl_shd.g_old_rec.min_value OR p_max_value <> pay_ivl_shd.g_old_rec.max_value then
1502: --

Line 1499: or pay_ivl_shd.g_old_rec.max_value is not null then

1495: --
1496: end if;
1497: --
1498: elsif pay_ivl_shd.g_old_rec.min_value is not null
1499: or pay_ivl_shd.g_old_rec.max_value is not null then
1500: --
1501: if p_min_value <> pay_ivl_shd.g_old_rec.min_value OR p_max_value <> pay_ivl_shd.g_old_rec.max_value then
1502: --
1503: if (p_default_value <= p_min_value or

Line 1501: if p_min_value <> pay_ivl_shd.g_old_rec.min_value OR p_max_value <> pay_ivl_shd.g_old_rec.max_value then

1497: --
1498: elsif pay_ivl_shd.g_old_rec.min_value is not null
1499: or pay_ivl_shd.g_old_rec.max_value is not null then
1500: --
1501: if p_min_value <> pay_ivl_shd.g_old_rec.min_value OR p_max_value <> pay_ivl_shd.g_old_rec.max_value then
1502: --
1503: if (p_default_value <= p_min_value or
1504: p_default_value >= p_max_value) then
1505: --

Line 1521: if (p_default_value <= pay_ivl_shd.g_old_rec.min_value or

1517: end if;
1518: --
1519: else
1520: --
1521: if (p_default_value <= pay_ivl_shd.g_old_rec.min_value or
1522: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1523: --
1524: if p_warning_or_error = 'E' then
1525: --

Line 1522: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then

1518: --
1519: else
1520: --
1521: if (p_default_value <= pay_ivl_shd.g_old_rec.min_value or
1522: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1523: --
1524: if p_warning_or_error = 'E' then
1525: --
1526: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');

Line 1775: if pay_ivl_shd.g_old_rec.formula_id is not null and

1771: IS
1772:
1773: BEGIN
1774:
1775: if pay_ivl_shd.g_old_rec.formula_id is not null and
1776: p_formula_id is not null and (
1777: p_lookup_type is not null or
1778: p_value_set_id is not null or
1779: p_min_value is not null or

Line 1786: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and

1782:
1783: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1784: fnd_message.raise_error;
1785:
1786: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1787: p_lookup_type is not null and (
1788: p_formula_id is not null or
1789: p_value_set_id is not null or
1790: p_min_value is not null or

Line 1797: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and

1793:
1794: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1795: fnd_message.raise_error;
1796:
1797: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1798: p_value_set_id is not null and (
1799: p_formula_id is not null or
1800: p_lookup_type is not null or
1801: p_min_value is not null or

Line 1808: elsif (pay_ivl_shd.g_old_rec.min_value is not null and

1804:
1805: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1806: fnd_message.raise_error;
1807:
1808: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1809: p_min_value is not null or
1810: pay_ivl_shd.g_old_rec.max_value is not null and
1811: p_max_value is not null) and (
1812: p_formula_id is not null or

Line 1810: pay_ivl_shd.g_old_rec.max_value is not null and

1806: fnd_message.raise_error;
1807:
1808: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1809: p_min_value is not null or
1810: pay_ivl_shd.g_old_rec.max_value is not null and
1811: p_max_value is not null) and (
1812: p_formula_id is not null or
1813: p_lookup_type is not null or
1814: p_value_set_id is not null

Line 1852: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type

1848:
1849: hr_utility.set_location(' Entering:'|| l_proc, 10);
1850:
1851:
1852: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1853: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1854: OR p_max <> pay_ivl_shd.g_old_rec.max_value OR p_warning_or_error <> pay_ivl_shd.g_old_rec.warning_or_error
1855: then
1856: p_link_inp_val_warning := TRUE;

Line 1853: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value

1849: hr_utility.set_location(' Entering:'|| l_proc, 10);
1850:
1851:
1852: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1853: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1854: OR p_max <> pay_ivl_shd.g_old_rec.max_value OR p_warning_or_error <> pay_ivl_shd.g_old_rec.warning_or_error
1855: then
1856: p_link_inp_val_warning := TRUE;
1857: end if;

Line 1854: OR p_max <> pay_ivl_shd.g_old_rec.max_value OR p_warning_or_error <> pay_ivl_shd.g_old_rec.warning_or_error

1850:
1851:
1852: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1853: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1854: OR p_max <> pay_ivl_shd.g_old_rec.max_value OR p_warning_or_error <> pay_ivl_shd.g_old_rec.warning_or_error
1855: then
1856: p_link_inp_val_warning := TRUE;
1857: end if;
1858:

Line 1960: (p_rec in pay_ivl_shd.g_rec_type

1956: -- ----------------------------------------------------------------------------
1957: -- |---------------------------< insert_validate >----------------------------|
1958: -- ----------------------------------------------------------------------------
1959: Procedure insert_validate
1960: (p_rec in pay_ivl_shd.g_rec_type
1961: ,p_effective_date in date
1962: ,p_datetrack_mode in varchar2
1963: ,p_validation_start_date in date
1964: ,p_validation_end_date in date

Line 1992: ,p_associated_column1 => pay_ivl_shd.g_tab_nam

1988: -- Validate Important Attributes
1989: --
1990: hr_api.validate_bus_grp_id
1991: (p_business_group_id => p_rec.business_group_id
1992: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
1993: || '.BUSINESS_GROUP_ID');
1994: --
1995: -- after validating the set of important attributes,
1996: -- if Multiple Message Detection is enabled and at least

Line 2098: (p_rec in pay_ivl_shd.g_rec_type

2094: -- ----------------------------------------------------------------------------
2095: -- |---------------------------< update_validate >----------------------------|
2096: -- ----------------------------------------------------------------------------
2097: Procedure update_validate
2098: (p_rec in pay_ivl_shd.g_rec_type
2099: ,p_effective_date in date
2100: ,p_datetrack_mode in out nocopy varchar2
2101: ,p_validation_start_date in date
2102: ,p_validation_end_date in date

Line 2133: ,p_associated_column1 => pay_ivl_shd.g_tab_nam

2129: --
2130:
2131: hr_api.validate_bus_grp_id
2132: (p_business_group_id => p_rec.business_group_id
2133: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2134: || '.BUSINESS_GROUP_ID');
2135: --
2136: -- After validating the set of important attributes,
2137: -- if Multiple Message Detection is enabled and at least

Line 2278: (p_rec in pay_ivl_shd.g_rec_type

2274: -- ----------------------------------------------------------------------------
2275: -- |---------------------------< delete_validate >----------------------------|
2276: -- ----------------------------------------------------------------------------
2277: Procedure delete_validate
2278: (p_rec in pay_ivl_shd.g_rec_type
2279: ,p_effective_date in date
2280: ,p_datetrack_mode in varchar2
2281: ,p_validation_start_date in date
2282: ,p_validation_end_date in date

Line 2293: ,pay_ivl_shd.g_old_rec.business_group_id

2289: hr_utility.set_location('Entering:'||l_proc, 5);
2290: --
2291: --
2292: chk_startup_action(false
2293: ,pay_ivl_shd.g_old_rec.business_group_id
2294: ,pay_ivl_shd.g_old_rec.legislation_code
2295: );
2296: IF hr_startup_data_api_support.g_startup_mode
2297: NOT IN ('GENERIC','STARTUP') THEN

Line 2294: ,pay_ivl_shd.g_old_rec.legislation_code

2290: --
2291: --
2292: chk_startup_action(false
2293: ,pay_ivl_shd.g_old_rec.business_group_id
2294: ,pay_ivl_shd.g_old_rec.legislation_code
2295: );
2296: IF hr_startup_data_api_support.g_startup_mode
2297: NOT IN ('GENERIC','STARTUP') THEN
2298: --