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_STA_BUS dependencies on PAY_STA_SHD

Line 77: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');

73: --
74: -- raise error as FK does not relate to PK in pay_us_states
75: -- table.
76: --
77: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');
78: --
79: end if;
80: --
81: close c1;

Line 171: l_api_updating := pay_sta_shd.api_updating

167: ,p_argument => 'effective_date'
168: ,p_argument_value => p_effective_date
169: );
170: --
171: l_api_updating := pay_sta_shd.api_updating
172: (p_emp_state_tax_rule_id => p_emp_state_tax_rule_id,
173: p_effective_date => p_effective_date,
174: p_object_version_number => p_object_version_number);
175: --

Line 280: l_api_updating := pay_sta_shd.api_updating

276: ,p_argument => 'effective_date'
277: ,p_argument_value => p_effective_date
278: );
279: --
280: l_api_updating := pay_sta_shd.api_updating
281: (p_emp_state_tax_rule_id => p_emp_state_tax_rule_id,
282: p_effective_date => p_effective_date,
283: p_object_version_number => p_object_version_number);
284: --

Line 289: <> pay_sta_shd.g_old_rec.sit_optional_calc_ind

285: -- If the value is being inserted or updated...
286: --
287: if (l_api_updating
288: and nvl(p_sit_optional_calc_ind,hr_api.g_varchar2)
289: <> pay_sta_shd.g_old_rec.sit_optional_calc_ind
290: or not l_api_updating) then
291: --
292: -- Validate only if attribute is not null
293: --

Line 308: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');

304: -- table. Existence of state tax record was checked in a
305: -- previous step.
306: --
307:
308: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');
309:
310: end If;
311: close csr_get_state_abbrev;
312: if hr_api.not_exists_in_hr_lookups

Line 460: pay_sta_shd.g_old_rec.additional_wa_amount)

456: -- If the value is being inserted or updated...
457: --
458: if (p_emp_state_tax_rule_id is not null
459: and nvl(p_additional_wa_amount,hr_api.g_number) <>
460: pay_sta_shd.g_old_rec.additional_wa_amount)
461: or (p_emp_state_tax_rule_id is null) then
462: --
463: -- Check that the mandatory parameters have been set
464: --

Line 572: <> pay_sta_shd.g_old_rec.filing_status_code)

568: -- If the value is being inserted or updated...
569: --
570: if (p_emp_state_tax_rule_id is not null
571: and nvl(p_filing_status_code,hr_api.g_varchar2)
572: <> pay_sta_shd.g_old_rec.filing_status_code)
573: or (p_emp_state_tax_rule_id is null) then
574: --
575: -- Check that the mandatory parameters have been set
576: --

Line 645: <> nvl(pay_sta_shd.g_old_rec.sit_additional_tax,hr_api.g_number))

641: -- If the value is being inserted or updated...
642: --
643: if (p_emp_state_tax_rule_id is not null
644: and nvl(p_sit_additional_tax,hr_api.g_number)
645: <> nvl(pay_sta_shd.g_old_rec.sit_additional_tax,hr_api.g_number))
646: or (p_emp_state_tax_rule_id is null) then
647: --
648: -- Check that the mandatory parameters have been set
649: --

Line 711: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))

707: -- If the value is being inserted or updated...
708: --
709: if (p_emp_state_tax_rule_id is not null
710: and nvl(p_sit_override_amount,hr_api.g_number)
711: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))
712: or (p_emp_state_tax_rule_id is null) then
713: --
714: -- Check that the mandatory parameters have been set
715: --

Line 777: <> nvl(pay_sta_shd.g_old_rec.sit_override_rate,hr_api.g_number))

773: -- If the value is being inserted or updated...
774: --
775: if (p_emp_state_tax_rule_id is not null
776: and nvl(p_sit_override_rate,hr_api.g_number)
777: <> nvl(pay_sta_shd.g_old_rec.sit_override_rate,hr_api.g_number))
778: or (p_emp_state_tax_rule_id is null) then
779: --
780: -- Check that the mandatory parameters have been set
781: --

Line 843: <> nvl(pay_sta_shd.g_old_rec.remainder_percent,hr_api.g_number))

839: -- If the value is being inserted or updated...
840: --
841: if (p_emp_state_tax_rule_id is not null
842: and nvl(p_remainder_percent,hr_api.g_number)
843: <> nvl(pay_sta_shd.g_old_rec.remainder_percent,hr_api.g_number))
844: or (p_emp_state_tax_rule_id is null) then
845: --
846: -- Check that the mandatory parameters have been set
847: --

Line 908: <> nvl(pay_sta_shd.g_old_rec.secondary_wa,hr_api.g_number))

904: -- If the value is being inserted or updated...
905: --
906: if (p_emp_state_tax_rule_id is not null
907: and nvl(p_secondary_wa,hr_api.g_number)
908: <> nvl(pay_sta_shd.g_old_rec.secondary_wa,hr_api.g_number))
909: or (p_emp_state_tax_rule_id is null) then
910: --
911: -- Check that the mandatory parameters have been set
912: --

Line 974: <> nvl(pay_sta_shd.g_old_rec.withholding_allowances,hr_api.g_number))

970: -- If the value is being inserted or updated...
971: --
972: if (p_emp_state_tax_rule_id is not null
973: and nvl(p_withholding_allowances,hr_api.g_number)
974: <> nvl(pay_sta_shd.g_old_rec.withholding_allowances,hr_api.g_number))
975: or (p_emp_state_tax_rule_id is null) then
976: --
977: -- Check that the mandatory parameters have been set
978: --

Line 1040: nvl(pay_sta_shd.g_old_rec.sui_wage_base_override_amount,hr_api.g_number))

1036: -- If the value is being inserted or updated...
1037: --
1038: if ((p_emp_state_tax_rule_id is not null
1039: and nvl(p_sui_wage_base_override_amo,hr_api.g_number) <>
1040: nvl(pay_sta_shd.g_old_rec.sui_wage_base_override_amount,hr_api.g_number))
1041: or
1042: (p_emp_state_tax_rule_id is null)) then
1043: --
1044: -- Validate only if attribute is not null

Line 1106: <> nvl(pay_sta_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))

1102: -- If the value is being inserted or updated...
1103: --
1104: if ((p_emp_state_tax_rule_id is not null
1105: and nvl(p_supp_tax_override_rate,hr_api.g_number)
1106: <> nvl(pay_sta_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
1107: or
1108: (p_emp_state_tax_rule_id is null)) then
1109: --
1110: -- Validate only if attribute is not null

Line 1164: (p_rec in pay_sta_shd.g_rec_type

1160: --
1161: -- {End Of Comments}
1162: -- ----------------------------------------------------------------------------
1163: Procedure chk_non_updateable_args
1164: (p_rec in pay_sta_shd.g_rec_type
1165: ,p_effective_date in date
1166: ) is
1167: --
1168: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 1178: if not pay_sta_shd.api_updating

1174: --
1175: -- Only proceed with validation if a row exists for
1176: -- the current record in the HR schema
1177: --
1178: if not pay_sta_shd.api_updating
1179: (p_emp_state_tax_rule_id => p_rec.emp_state_tax_rule_id
1180: ,p_object_version_number => p_rec.object_version_number
1181: ,p_effective_date => p_effective_date
1182: ) then

Line 1190: pay_sta_shd.g_old_rec.assignment_id) then

1186: end if;
1187: hr_utility.set_location(l_proc, 30);
1188: --
1189: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1190: pay_sta_shd.g_old_rec.assignment_id) then
1191: l_argument := 'assignment_id';
1192: raise l_error;
1193: end if;
1194: hr_utility.set_location(l_proc, 40);

Line 1197: pay_sta_shd.g_old_rec.business_group_id) then

1193: end if;
1194: hr_utility.set_location(l_proc, 40);
1195: --
1196: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1197: pay_sta_shd.g_old_rec.business_group_id) then
1198: l_argument := 'business_group_id';
1199: raise l_error;
1200: end if;
1201: hr_utility.set_location(l_proc, 50);

Line 1204: pay_sta_shd.g_old_rec.state_code then

1200: end if;
1201: hr_utility.set_location(l_proc, 50);
1202: --
1203: if nvl(p_rec.state_code, hr_api.g_varchar2) <>
1204: pay_sta_shd.g_old_rec.state_code then
1205: l_argument := 'state_code';
1206: raise l_error;
1207: end if;
1208: hr_utility.set_location(l_proc, 60);

Line 1211: pay_sta_shd.g_old_rec.jurisdiction_code then

1207: end if;
1208: hr_utility.set_location(l_proc, 60);
1209: --
1210: if nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1211: pay_sta_shd.g_old_rec.jurisdiction_code then
1212: l_argument := 'jurisdiction_code';
1213: raise l_error;
1214: end if;
1215: hr_utility.set_location(l_proc, 70);

Line 1279: where substr(prr.jurisdiction_code,1,2)=pay_sta_shd.g_old_rec.state_code

1275: cursor csr_check_payroll(p_csr_tmp_date in date) is
1276: select null
1277: from pay_run_results prr,
1278: pay_assignment_actions paa
1279: where substr(prr.jurisdiction_code,1,2)=pay_sta_shd.g_old_rec.state_code
1280: and paa.assignment_action_id = prr.assignment_action_id
1281: and paa.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1282: and exists (select null
1283: from pay_payroll_actions ppa

Line 1281: and paa.assignment_id = pay_sta_shd.g_old_rec.assignment_id

1277: from pay_run_results prr,
1278: pay_assignment_actions paa
1279: where substr(prr.jurisdiction_code,1,2)=pay_sta_shd.g_old_rec.state_code
1280: and paa.assignment_action_id = prr.assignment_action_id
1281: and paa.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1282: and exists (select null
1283: from pay_payroll_actions ppa
1284: where ppa.payroll_action_id = paa.payroll_action_id
1285: and ppa.action_type in ('Q','R')

Line 1293: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id

1289: cursor csr_check_work_loc(p_csr_tmp_date in date) is
1290: select null
1291: from per_assignments_f asg,
1292: hr_locations hrl
1293: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1294: and hrl.location_id = asg.location_id
1295: and asg.effective_end_date > p_csr_tmp_date
1296: and exists (select null
1297: from pay_us_states pus

Line 1299: and pus.state_code = pay_sta_shd.g_old_rec.state_code);

1295: and asg.effective_end_date > p_csr_tmp_date
1296: and exists (select null
1297: from pay_us_states pus
1298: where pus.state_abbrev = hrl.region_2
1299: and pus.state_code = pay_sta_shd.g_old_rec.state_code);
1300: --
1301: cursor csr_check_residence_loc(p_csr_tmp_date in date) is
1302: select null
1303: from per_assignments_f asg,

Line 1305: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id

1301: cursor csr_check_residence_loc(p_csr_tmp_date in date) is
1302: select null
1303: from per_assignments_f asg,
1304: per_addresses pad
1305: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1306: and pad.person_id = asg.person_id
1307: and pad.primary_flag = 'Y'
1308: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date
1309: and exists (select null

Line 1312: and pus.state_code = pay_sta_shd.g_old_rec.state_code);

1308: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date
1309: and exists (select null
1310: from pay_us_states pus
1311: where pus.state_abbrev = pad.region_2
1312: and pus.state_code = pay_sta_shd.g_old_rec.state_code);
1313: --
1314: -- Cursor to check for existing county tax rules
1315: --
1316: cursor chk_county_tax_rules

Line 1321: and cnt.state_code = pay_sta_shd.g_old_rec.state_code

1317: is
1318: select null
1319: from pay_us_emp_county_tax_rules_f cnt
1320: where cnt.assignment_id = p_assignment_id
1321: and cnt.state_code = pay_sta_shd.g_old_rec.state_code
1322: and cnt.effective_end_date > p_effective_date;
1323: --
1324: begin
1325: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1644: (p_rec in pay_sta_shd.g_rec_type,

1640: -- ----------------------------------------------------------------------------
1641: -- |---------------------------< insert_validate >----------------------------|
1642: -- ----------------------------------------------------------------------------
1643: Procedure insert_validate
1644: (p_rec in pay_sta_shd.g_rec_type,
1645: p_effective_date in date,
1646: p_datetrack_mode in varchar2,
1647: p_validation_start_date in date,
1648: p_validation_end_date in date) is

Line 1742: (p_rec in pay_sta_shd.g_rec_type,

1738: -- ----------------------------------------------------------------------------
1739: -- |---------------------------< update_validate >----------------------------|
1740: -- ----------------------------------------------------------------------------
1741: Procedure update_validate
1742: (p_rec in pay_sta_shd.g_rec_type,
1743: p_effective_date in date,
1744: p_datetrack_mode in varchar2,
1745: p_validation_start_date in date,
1746: p_validation_end_date in date) is

Line 1835: (p_rec in pay_sta_shd.g_rec_type,

1831: -- ----------------------------------------------------------------------------
1832: -- |---------------------------< delete_validate >----------------------------|
1833: -- ----------------------------------------------------------------------------
1834: Procedure delete_validate
1835: (p_rec in pay_sta_shd.g_rec_type,
1836: p_effective_date in date,
1837: p_datetrack_mode in varchar2,
1838: p_validation_start_date in date,
1839: p_validation_end_date in date,

Line 1852: ,p_assignment_id => pay_sta_shd.g_old_rec.assignment_id

1848: -- Call all supporting business operations
1849: --
1850: chk_delete
1851: (p_emp_state_tax_rule_id => p_rec.emp_state_tax_rule_id
1852: ,p_assignment_id => pay_sta_shd.g_old_rec.assignment_id
1853: ,p_effective_date => p_effective_date
1854: ,p_datetrack_mode => p_datetrack_mode
1855: ,p_validation_start_date => p_validation_start_date
1856: ,p_validation_end_date => p_validation_end_date