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 261: ,p_rec in pay_ivl_shd.g_rec_type

257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure chk_non_updateable_args
260: (p_effective_date in date
261: ,p_rec in pay_ivl_shd.g_rec_type
262: ) IS
263: --
264:
265: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';

Line 272: IF NOT pay_ivl_shd.api_updating

268: --
269: -- Only proceed with the validation if a row exists for the current
270: -- record in the HR Schema.
271: --
272: IF NOT pay_ivl_shd.api_updating
273: (p_input_value_id => p_rec.input_value_id
274: ,p_effective_date => p_effective_date
275: ,p_object_version_number => p_rec.object_version_number
276: ) THEN

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

359: ,p_to_date => p_validation_end_date))) Then
360: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
361: fnd_message.set_token('TABLE_NAME','element types');
362: hr_multi_message.add
363: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
364: End If;
365: --
366: Exception
367: When Others Then

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

866: BEGIN
867:
868: hr_utility.set_location(' Entering:'|| l_proc, 10);
869:
870: if (p_name <> pay_ivl_shd.g_old_rec.name or p_display_sequence
871: <> pay_ivl_shd.g_old_rec.display_sequence) then
872: pay_element_types_pkg.check_for_paylink_batches
873: (p_element_type_id => p_element_type_id
874: ,p_element_name => p_name);

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

867:
868: hr_utility.set_location(' Entering:'|| l_proc, 10);
869:
870: if (p_name <> pay_ivl_shd.g_old_rec.name or p_display_sequence
871: <> pay_ivl_shd.g_old_rec.display_sequence) then
872: pay_element_types_pkg.check_for_paylink_batches
873: (p_element_type_id => p_element_type_id
874: ,p_element_name => p_name);
875: end if;

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

901: BEGIN
902:
903: hr_utility.set_location(' Entering:'|| l_proc, 10);
904:
905: if (p_generate_db_items_flag <> pay_ivl_shd.g_old_rec.generate_db_items_flag)
906: and p_datetrack_mode <> 'CORRECTION' then
907: open csr_row_count;
908: fetch csr_row_count into l_count;
909: close csr_row_count;

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

963:
964: hr_utility.set_location(' Entering:'|| l_proc, 10);
965:
966:
967: if (p_name <> pay_ivl_shd.g_old_rec.name) then
968:
969: -- Force Correction mode
970: if p_datetrack_mode <> 'CORRECTION' then
971: open csr_row_count;

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

1004: fnd_message.raise_error;
1005: end if;
1006:
1007: -- Check for the new name
1008: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
1009: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
1010: fnd_message.raise_error;
1011: end if;
1012:

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

1014: -- and the name is one of these 'Coverage','EE Contr' and 'ER Contr'
1015: open csr_ben_contri;
1016: fetch csr_ben_contri into l_dummy;
1017:
1018: if l_dummy = 'Y' and upper(pay_ivl_shd.g_old_rec.name)
1019: in ('COVERAGE','EE CONTR','ER CONTR')
1020: then
1021: close csr_ben_contri;
1022: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');

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

1050: cursor csr_uom is
1051: select lookup_code from
1052: hr_lookups
1053: where upper(substr(lookup_code,1,2))
1054: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
1055: and lookup_type = 'UNITS'
1056: and enabled_flag = 'Y'
1057: and p_effective_date between
1058: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

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

1068: hr_utility.set_location(' Entering:'|| l_proc, 10);
1069:
1070: -- Check that the UOM if updated to a not null value is
1071: -- within the class as the previous UOM value
1072: if (p_uom <> pay_ivl_shd.g_old_rec.uom and p_uom is not null) then
1073: if p_datetrack_mode <> 'CORRECTION' then
1074: open csr_row_count;
1075: fetch csr_row_count into l_count;
1076: close csr_row_count;

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

1080: else
1081: p_datetrack_mode := 'CORRECTION';
1082: end if;
1083: end if;
1084: if pay_ivl_shd.g_old_rec.uom is not null then
1085: for rec in csr_uom
1086: loop
1087: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1088: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');

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

1152: -- Check for element entries and Hot default flag
1153:
1154: open csr_entries;
1155: fetch csr_entries into l_dummy;
1156: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1157: close csr_entries;
1158: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1159: fnd_message.raise_error;
1160: end if;

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

1185:
1186: hr_utility.set_location(' Entering:'|| l_proc, 10);
1187:
1188:
1189: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1190: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1191: fnd_message.raise_error;
1192: end if;
1193:

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

1507: select 'X'
1508: from hr_lookups
1509: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1510: and lookup_type = decode(p_lookup_type,
1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1512: p_lookup_type)
1513: and enabled_flag = 'Y'
1514: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1515: and nvl(end_date_active,hr_api.g_eot);

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

1522: --
1523: hr_utility.set_location(' Entering:'|| l_proc, 10);
1524: --
1525: if p_lookup_type is not null or (
1526: pay_ivl_shd.g_old_rec.lookup_type is not null and
1527: p_lookup_type = hr_api.g_varchar2
1528: ) then
1529: --
1530: open csr_lookup;

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

1543: --
1544: elsif p_value_set_id is not null and p_default_value is not null and
1545: p_default_value <> hr_api.g_varchar2 and (
1546: p_value_set_id <> hr_api.g_number or (
1547: pay_ivl_shd.g_old_rec.value_set_id is not null and
1548: p_value_set_id = hr_api.g_number
1549: )
1550: ) then
1551: --

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

1552: if p_value_set_id = hr_api.g_number then
1553: --
1554: -- Value set id is not changing, use the old one
1555: --
1556: l_value_set_id := pay_ivl_shd.g_old_rec.value_set_id;
1557: --
1558: else
1559: --
1560: -- Value set id is changing, use the new one

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

1577: fnd_message.raise_error;
1578: --
1579: end if;
1580: --
1581: elsif pay_ivl_shd.g_old_rec.min_value is not null
1582: or pay_ivl_shd.g_old_rec.max_value is not null then
1583: --
1584: 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
1585: --

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

1578: --
1579: end if;
1580: --
1581: elsif pay_ivl_shd.g_old_rec.min_value is not null
1582: or pay_ivl_shd.g_old_rec.max_value is not null then
1583: --
1584: 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
1585: --
1586: if (p_default_value <= p_min_value or

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

1580: --
1581: elsif pay_ivl_shd.g_old_rec.min_value is not null
1582: or pay_ivl_shd.g_old_rec.max_value is not null then
1583: --
1584: 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
1585: --
1586: if (p_default_value <= p_min_value or
1587: p_default_value >= p_max_value) then
1588: --

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

1600: end if;
1601: --
1602: else
1603: --
1604: if (p_default_value <= pay_ivl_shd.g_old_rec.min_value or
1605: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1606: --
1607: if p_warning_or_error = 'E' then
1608: --

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

1601: --
1602: else
1603: --
1604: if (p_default_value <= pay_ivl_shd.g_old_rec.min_value or
1605: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1606: --
1607: if p_warning_or_error = 'E' then
1608: --
1609: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');

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

1902: IS
1903:
1904: BEGIN
1905:
1906: if pay_ivl_shd.g_old_rec.formula_id is not null and
1907: p_formula_id is not null and (
1908: p_lookup_type is not null or
1909: p_value_set_id is not null or
1910: p_min_value is not null or

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

1913:
1914: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1915: fnd_message.raise_error;
1916:
1917: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1918: p_lookup_type is not null and (
1919: p_formula_id is not null or
1920: p_value_set_id is not null or
1921: p_min_value is not null or

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

1924:
1925: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1926: fnd_message.raise_error;
1927:
1928: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1929: p_value_set_id is not null and (
1930: p_formula_id is not null or
1931: p_lookup_type is not null or
1932: p_min_value is not null or

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

1935:
1936: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1937: fnd_message.raise_error;
1938:
1939: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1940: p_min_value is not null or
1941: pay_ivl_shd.g_old_rec.max_value is not null and
1942: p_max_value is not null) and (
1943: p_formula_id is not null or

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

1937: fnd_message.raise_error;
1938:
1939: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1940: p_min_value is not null or
1941: pay_ivl_shd.g_old_rec.max_value is not null and
1942: p_max_value is not null) and (
1943: p_formula_id is not null or
1944: p_lookup_type is not null or
1945: p_value_set_id is not null

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

1979:
1980: hr_utility.set_location(' Entering:'|| l_proc, 10);
1981:
1982:
1983: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1984: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1985: 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
1986: then
1987: p_link_inp_val_warning := TRUE;

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

1980: hr_utility.set_location(' Entering:'|| l_proc, 10);
1981:
1982:
1983: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1984: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1985: 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
1986: then
1987: p_link_inp_val_warning := TRUE;
1988: end if;

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

1981:
1982:
1983: if p_lookup_type <> pay_ivl_shd.g_old_rec.lookup_type
1984: OR p_default_value <> pay_ivl_shd.g_old_rec.default_value OR p_min <> pay_ivl_shd.g_old_rec.min_value
1985: 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
1986: then
1987: p_link_inp_val_warning := TRUE;
1988: end if;
1989:

Line 2091: (p_rec in pay_ivl_shd.g_rec_type

2087: -- ----------------------------------------------------------------------------
2088: -- |---------------------------< insert_validate >----------------------------|
2089: -- ----------------------------------------------------------------------------
2090: Procedure insert_validate
2091: (p_rec in pay_ivl_shd.g_rec_type
2092: ,p_effective_date in date
2093: ,p_datetrack_mode in varchar2
2094: ,p_validation_start_date in date
2095: ,p_validation_end_date in date

Line 2123: ,p_associated_column1 => pay_ivl_shd.g_tab_nam

2119: -- Validate Important Attributes
2120: --
2121: hr_api.validate_bus_grp_id
2122: (p_business_group_id => p_rec.business_group_id
2123: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2124: || '.BUSINESS_GROUP_ID');
2125: --
2126: -- after validating the set of important attributes,
2127: -- if Multiple Message Detection is enabled and at least

Line 2237: (p_rec in pay_ivl_shd.g_rec_type

2233: -- ----------------------------------------------------------------------------
2234: -- |---------------------------< update_validate >----------------------------|
2235: -- ----------------------------------------------------------------------------
2236: Procedure update_validate
2237: (p_rec in pay_ivl_shd.g_rec_type
2238: ,p_effective_date in date
2239: ,p_datetrack_mode in out nocopy varchar2
2240: ,p_validation_start_date in date
2241: ,p_validation_end_date in date

Line 2272: ,p_associated_column1 => pay_ivl_shd.g_tab_nam

2268: --
2269:
2270: hr_api.validate_bus_grp_id
2271: (p_business_group_id => p_rec.business_group_id
2272: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2273: || '.BUSINESS_GROUP_ID');
2274: --
2275: -- After validating the set of important attributes,
2276: -- if Multiple Message Detection is enabled and at least

Line 2437: (p_rec in pay_ivl_shd.g_rec_type

2433: -- ----------------------------------------------------------------------------
2434: -- |---------------------------< delete_validate >----------------------------|
2435: -- ----------------------------------------------------------------------------
2436: Procedure delete_validate
2437: (p_rec in pay_ivl_shd.g_rec_type
2438: ,p_effective_date in date
2439: ,p_datetrack_mode in varchar2
2440: ,p_validation_start_date in date
2441: ,p_validation_end_date in date

Line 2452: ,pay_ivl_shd.g_old_rec.business_group_id

2448: hr_utility.set_location('Entering:'||l_proc, 5);
2449: --
2450: --
2451: chk_startup_action(false
2452: ,pay_ivl_shd.g_old_rec.business_group_id
2453: ,pay_ivl_shd.g_old_rec.legislation_code
2454: );
2455: IF hr_startup_data_api_support.g_startup_mode
2456: NOT IN ('GENERIC','STARTUP') THEN

Line 2453: ,pay_ivl_shd.g_old_rec.legislation_code

2449: --
2450: --
2451: chk_startup_action(false
2452: ,pay_ivl_shd.g_old_rec.business_group_id
2453: ,pay_ivl_shd.g_old_rec.legislation_code
2454: );
2455: IF hr_startup_data_api_support.g_startup_mode
2456: NOT IN ('GENERIC','STARTUP') THEN
2457: --