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_CTY_BUS dependencies on PAY_CTY_SHD

Line 94: l_api_updating := pay_cty_shd.api_updating

90: ,p_argument => 'effective_date'
91: ,p_argument_value => p_effective_date
92: );
93: --
94: l_api_updating := pay_cty_shd.api_updating
95: (
96: p_emp_city_tax_rule_id => p_emp_city_tax_rule_id,
97: p_effective_date => p_effective_date,
98: p_object_version_number => p_object_version_number

Line 185: pay_cty_shd.constraint_error

181: open csr_valid_state_code;
182: fetch csr_valid_state_code into l_state_code;
183: if csr_valid_state_code%notfound then
184: close csr_valid_state_code;
185: pay_cty_shd.constraint_error
186: ('PAY_US_EMP_CITY_TAX_RULES_FK1');
187: end if;
188: close csr_valid_state_code;
189: else

Line 335: pay_cty_shd.constraint_error

331: open csr_valid_city_code;
332: fetch csr_valid_city_code into l_city_code;
333: if csr_valid_city_code%notfound then
334: close csr_valid_city_code;
335: pay_cty_shd.constraint_error
336: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');
337: end if;
338: close csr_valid_city_code;
339: else

Line 485: pay_cty_shd.g_old_rec.additional_wa_rate)

481: -- If value is being inserted or updated ...
482: --
483: if (p_emp_city_tax_rule_id is not null
484: and nvl(p_additional_wa_rate,hr_api.g_number) <>
485: pay_cty_shd.g_old_rec.additional_wa_rate)
486: or (p_emp_city_tax_rule_id is null) then
487: --
488: -- Check that additional_wa_rate is not null.
489: --

Line 585: pay_cty_shd.g_old_rec.filing_status_code)

581: -- If value is being inserted or updated ...
582: --
583: if (p_emp_city_tax_rule_id is not null
584: and nvl(p_filing_status_code,hr_api.g_varchar2) <>
585: pay_cty_shd.g_old_rec.filing_status_code)
586: or (p_emp_city_tax_rule_id is null) then
587: --
588: -- Check that filing_status_code is not null.
589: --

Line 658: pay_cty_shd.g_old_rec.lit_additional_tax)

654: -- If value is being inserted or updated ...
655: --
656: if (p_emp_city_tax_rule_id is not null
657: and nvl(p_lit_additional_tax,hr_api.g_number) <>
658: pay_cty_shd.g_old_rec.lit_additional_tax)
659: or (p_emp_city_tax_rule_id is null) then
660: --
661: -- Check that lit_additional_tax is not null.
662: --

Line 723: pay_cty_shd.g_old_rec.lit_override_amount)

719: -- If value is being inserted or updated ...
720: --
721: if (p_emp_city_tax_rule_id is not null
722: and nvl(p_lit_override_amount,hr_api.g_number) <>
723: pay_cty_shd.g_old_rec.lit_override_amount)
724: or (p_emp_city_tax_rule_id is null) then
725: --
726: -- Check that lit_override_amount is not null.
727: --

Line 788: pay_cty_shd.g_old_rec.lit_override_rate)

784: -- If value is being inserted or updated ...
785: --
786: if (p_emp_city_tax_rule_id is not null
787: and nvl(p_lit_override_rate,hr_api.g_number) <>
788: pay_cty_shd.g_old_rec.lit_override_rate)
789: or (p_emp_city_tax_rule_id is null) then
790: --
791: -- Check that lit_override_rate is not null.
792: --

Line 852: pay_cty_shd.g_old_rec.withholding_allowances)

848: -- If value is being inserted or updated ...
849: --
850: if (p_emp_city_tax_rule_id is not null
851: and nvl(p_withholding_allowances,hr_api.g_number) <>
852: pay_cty_shd.g_old_rec.withholding_allowances)
853: or (p_emp_city_tax_rule_id is null) then
854: --
855: -- Check that withholding_allowances is not null.
856: --

Line 1006: l_api_updating := pay_cty_shd.api_updating

1002: ,p_argument => 'city_code'
1003: ,p_argument_value => p_city_code
1004: );
1005: --
1006: l_api_updating := pay_cty_shd.api_updating
1007: (
1008: p_effective_date => p_effective_date,
1009: p_emp_city_tax_rule_id => p_emp_city_tax_rule_id,
1010: p_object_version_number => p_object_version_number

Line 1017: pay_cty_shd.g_old_rec.school_district_code)

1013: -- If the value is being inserted or updated...
1014: --
1015: if (l_api_updating
1016: and nvl(p_school_district_code,hr_api.g_number) <>
1017: pay_cty_shd.g_old_rec.school_district_code)
1018: or (not l_api_updating) then
1019: --
1020: -- Check school_district_code.
1021: --

Line 1275: (p_rec in pay_cty_shd.g_rec_type,

1271: -- Internal Row Handler Use Only.
1272: --
1273: --
1274: Procedure chk_non_updateable_args
1275: (p_rec in pay_cty_shd.g_rec_type,
1276: p_effective_date in date
1277: ) is
1278: --
1279: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 1287: if not pay_cty_shd.api_updating

1283: Begin
1284: hr_utility.set_location('Entering: '||l_proc, 10);
1285: --
1286: --
1287: if not pay_cty_shd.api_updating
1288: (p_emp_city_tax_rule_id => p_rec.emp_city_tax_rule_id,
1289: p_object_version_number => p_rec.object_version_number,
1290: p_effective_date => p_effective_date
1291: ) then

Line 1299: pay_cty_shd.g_old_rec.business_group_id) then

1295: end if;
1296: hr_utility.set_location(l_proc, 30);
1297: --
1298: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1299: pay_cty_shd.g_old_rec.business_group_id) then
1300: l_argument := 'business_group_id';
1301: raise l_error;
1302: end if;
1303: hr_utility.set_location(l_proc, 40);

Line 1306: pay_cty_shd.g_old_rec.assignment_id) then

1302: end if;
1303: hr_utility.set_location(l_proc, 40);
1304: --
1305: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1306: pay_cty_shd.g_old_rec.assignment_id) then
1307: l_argument := 'assignment_id';
1308: raise l_error;
1309: end if;
1310: hr_utility.set_location(l_proc, 50);

Line 1313: pay_cty_shd.g_old_rec.state_code) then

1309: end if;
1310: hr_utility.set_location(l_proc, 50);
1311: --
1312: if (nvl(p_rec.state_code, hr_api.g_varchar2) <>
1313: pay_cty_shd.g_old_rec.state_code) then
1314: l_argument := 'state_code';
1315: raise l_error;
1316: end if;
1317: hr_utility.set_location(l_proc, 60);

Line 1320: pay_cty_shd.g_old_rec.county_code) then

1316: end if;
1317: hr_utility.set_location(l_proc, 60);
1318: --
1319: if (nvl(p_rec.county_code, hr_api.g_varchar2) <>
1320: pay_cty_shd.g_old_rec.county_code) then
1321: l_argument := 'county_code';
1322: raise l_error;
1323: end if;
1324: hr_utility.set_location(l_proc, 70);

Line 1327: pay_cty_shd.g_old_rec.city_code) then

1323: end if;
1324: hr_utility.set_location(l_proc, 70);
1325: --
1326: if (nvl(p_rec.city_code, hr_api.g_varchar2) <>
1327: pay_cty_shd.g_old_rec.city_code) then
1328: l_argument := 'city_code';
1329: raise l_error;
1330: end if;
1331: hr_utility.set_location(l_proc, 80);

Line 1334: pay_cty_shd.g_old_rec.jurisdiction_code) then

1330: end if;
1331: hr_utility.set_location(l_proc, 80);
1332: --
1333: if (nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1334: pay_cty_shd.g_old_rec.jurisdiction_code) then
1335: l_argument := 'jurisdiction_code';
1336: raise l_error;
1337: end if;
1338: hr_utility.set_location('Leaving: '||l_proc, 90);

Line 1550: (p_rec in pay_cty_shd.g_rec_type,

1546: -- ----------------------------------------------------------------------------
1547: -- |---------------------------< insert_validate >----------------------------|
1548: -- ----------------------------------------------------------------------------
1549: Procedure insert_validate
1550: (p_rec in pay_cty_shd.g_rec_type,
1551: p_effective_date in date,
1552: p_datetrack_mode in varchar2,
1553: p_validation_start_date in date,
1554: p_validation_end_date in date) is

Line 1650: (p_rec in pay_cty_shd.g_rec_type,

1646: -- ----------------------------------------------------------------------------
1647: -- |---------------------------< update_validate >----------------------------|
1648: -- ----------------------------------------------------------------------------
1649: Procedure update_validate
1650: (p_rec in pay_cty_shd.g_rec_type,
1651: p_effective_date in date,
1652: p_datetrack_mode in varchar2,
1653: p_validation_start_date in date,
1654: p_validation_end_date in date) is

Line 1730: (p_rec in pay_cty_shd.g_rec_type,

1726: -- ----------------------------------------------------------------------------
1727: -- |---------------------------< delete_validate >----------------------------|
1728: -- ----------------------------------------------------------------------------
1729: Procedure delete_validate
1730: (p_rec in pay_cty_shd.g_rec_type,
1731: p_effective_date in date,
1732: p_datetrack_mode in varchar2,
1733: p_delete_routine in varchar2,
1734: p_validation_start_date in date,

Line 1746: p_assignment_id => pay_cty_shd.g_old_rec.assignment_id,

1742: -- Call all supporting business operations
1743: --
1744: chk_delete
1745: (p_effective_date => p_effective_date,
1746: p_assignment_id => pay_cty_shd.g_old_rec.assignment_id,
1747: p_city_code => pay_cty_shd.g_old_rec.city_code,
1748: p_county_code => pay_cty_shd.g_old_rec.county_code,
1749: p_state_code => pay_cty_shd.g_old_rec.state_code,
1750: p_delete_mode => p_datetrack_mode,

Line 1747: p_city_code => pay_cty_shd.g_old_rec.city_code,

1743: --
1744: chk_delete
1745: (p_effective_date => p_effective_date,
1746: p_assignment_id => pay_cty_shd.g_old_rec.assignment_id,
1747: p_city_code => pay_cty_shd.g_old_rec.city_code,
1748: p_county_code => pay_cty_shd.g_old_rec.county_code,
1749: p_state_code => pay_cty_shd.g_old_rec.state_code,
1750: p_delete_mode => p_datetrack_mode,
1751: p_delete_routine => p_delete_routine

Line 1748: p_county_code => pay_cty_shd.g_old_rec.county_code,

1744: chk_delete
1745: (p_effective_date => p_effective_date,
1746: p_assignment_id => pay_cty_shd.g_old_rec.assignment_id,
1747: p_city_code => pay_cty_shd.g_old_rec.city_code,
1748: p_county_code => pay_cty_shd.g_old_rec.county_code,
1749: p_state_code => pay_cty_shd.g_old_rec.state_code,
1750: p_delete_mode => p_datetrack_mode,
1751: p_delete_routine => p_delete_routine
1752: );

Line 1749: p_state_code => pay_cty_shd.g_old_rec.state_code,

1745: (p_effective_date => p_effective_date,
1746: p_assignment_id => pay_cty_shd.g_old_rec.assignment_id,
1747: p_city_code => pay_cty_shd.g_old_rec.city_code,
1748: p_county_code => pay_cty_shd.g_old_rec.county_code,
1749: p_state_code => pay_cty_shd.g_old_rec.state_code,
1750: p_delete_mode => p_datetrack_mode,
1751: p_delete_routine => p_delete_routine
1752: );
1753: --