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 714: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1167: (p_rec in pay_sta_shd.g_rec_type

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

Line 1181: if not pay_sta_shd.api_updating

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

Line 1193: pay_sta_shd.g_old_rec.assignment_id) then

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

Line 1200: pay_sta_shd.g_old_rec.business_group_id) then

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

Line 1207: pay_sta_shd.g_old_rec.state_code then

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

Line 1214: pay_sta_shd.g_old_rec.jurisdiction_code then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1647: (p_rec in pay_sta_shd.g_rec_type,

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

Line 1745: (p_rec in pay_sta_shd.g_rec_type,

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

Line 1838: (p_rec in pay_sta_shd.g_rec_type,

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

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

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