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_FED_BUS dependencies on PAY_FED_SHD

Line 56: <> pay_fed_shd.g_old_rec.sui_state_code)

52: -- If the value is being inserted or updated...
53: --
54: if (p_emp_fed_tax_rule_id is not null
55: and nvl(p_sui_state_code,hr_api.g_varchar2)
56: <> pay_fed_shd.g_old_rec.sui_state_code)
57: or (p_emp_fed_tax_rule_id is null) then
58: --
59: -- Check that the mandatory parameters have been set
60: --

Line 77: pay_fed_shd.constraint_error('PAY_US_EMP_FED_TAX_RULES_FK1');

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

Line 162: l_api_updating := pay_fed_shd.api_updating

158: ,p_argument => 'effective_date'
159: ,p_argument_value => p_effective_date
160: );
161: --
162: l_api_updating := pay_fed_shd.api_updating
163: (p_emp_fed_tax_rule_id => p_emp_fed_tax_rule_id,
164: p_effective_date => p_effective_date,
165: p_object_version_number => p_object_version_number);
166: --

Line 264: <> nvl(pay_fed_shd.g_old_rec.sui_jurisdiction_code,hr_api.g_varchar2)

260: -- If the value is being inserted or updated...
261: --
262: if (p_emp_fed_tax_rule_id is not null
263: and nvl(p_sui_jurisdiction_code,hr_api.g_varchar2)
264: <> nvl(pay_fed_shd.g_old_rec.sui_jurisdiction_code,hr_api.g_varchar2)
265: or (p_emp_fed_tax_rule_id is null)) then
266: --
267: -- Check that the mandatory parameters have been set
268: --

Line 337: pay_fed_shd.g_old_rec.additional_wa_amount)

333: -- If the value is being inserted or updated...
334: --
335: if (p_emp_fed_tax_rule_id is not null
336: and nvl(p_additional_wa_amount,hr_api.g_number) <>
337: pay_fed_shd.g_old_rec.additional_wa_amount)
338: or (p_emp_fed_tax_rule_id is null) then
339: --
340: -- Check that the mandatory parameters have been set
341: --

Line 417: <> pay_fed_shd.g_old_rec.filing_status_code)

413: -- If the value is being inserted or updated...
414: --
415: if (p_emp_fed_tax_rule_id is not null
416: and nvl(p_filing_status_code,hr_api.g_varchar2)
417: <> pay_fed_shd.g_old_rec.filing_status_code)
418: or (p_emp_fed_tax_rule_id is null) then
419: --
420: -- Check that the mandatory parameters have been set
421: --

Line 492: <> nvl(pay_fed_shd.g_old_rec.fit_override_amount,hr_api.g_number))

488: -- If the value is being inserted or updated...
489: --
490: if (p_emp_fed_tax_rule_id is not null
491: and nvl(p_fit_override_amount,hr_api.g_number)
492: <> nvl(pay_fed_shd.g_old_rec.fit_override_amount,hr_api.g_number))
493: or (p_emp_fed_tax_rule_id is null) then
494: --
495: -- Check that the mandatory parameters have been set
496: --

Line 558: <> nvl(pay_fed_shd.g_old_rec.fit_override_rate,hr_api.g_number))

554: -- If the value is being inserted or updated...
555: --
556: if (p_emp_fed_tax_rule_id is not null
557: and nvl(p_fit_override_rate,hr_api.g_number)
558: <> nvl(pay_fed_shd.g_old_rec.fit_override_rate,hr_api.g_number))
559: or (p_emp_fed_tax_rule_id is null) then
560: --
561: -- Check that the mandatory parameters have been set
562: --

Line 624: <> nvl(pay_fed_shd.g_old_rec.withholding_allowances,hr_api.g_number))

620: -- If the value is being inserted or updated...
621: --
622: if (p_emp_fed_tax_rule_id is not null
623: and nvl(p_withholding_allowances,hr_api.g_number)
624: <> nvl(pay_fed_shd.g_old_rec.withholding_allowances,hr_api.g_number))
625: or (p_emp_fed_tax_rule_id is null) then
626: --
627: -- Check that the mandatory parameters have been set
628: --

Line 704: <> nvl(pay_fed_shd.g_old_rec.eic_filing_status_code,hr_api.g_varchar2))

700: -- If the value is being updated or inserted...
701: --
702: if ((p_emp_fed_tax_rule_id is not null
703: and nvl(p_eic_filing_status_code,hr_api.g_varchar2)
704: <> nvl(pay_fed_shd.g_old_rec.eic_filing_status_code,hr_api.g_varchar2))
705: or
706: (p_emp_fed_tax_rule_id is null)) then
707: --
708: -- Validate only if attribute is not null

Line 725: pay_fed_shd.constraint_error('PAY_USFTR_EIC_FILING_STATU_CHK');

721: --
722: -- raise error as eic_filing_status_code does not exist in hr_lookups
723: -- table.
724: --
725: pay_fed_shd.constraint_error('PAY_USFTR_EIC_FILING_STATU_CHK');
726: --
727: end if;
728: --
729: end if;

Line 776: <> nvl(pay_fed_shd.g_old_rec.fit_additional_tax,hr_api.g_number))

772: -- If the value is being updated or inserted...
773: --
774: if ((p_emp_fed_tax_rule_id is not null
775: and nvl(p_fit_additional_tax,hr_api.g_number)
776: <> nvl(pay_fed_shd.g_old_rec.fit_additional_tax,hr_api.g_number))
777: or
778: (p_emp_fed_tax_rule_id is null)) then
779: --
780: -- Validate only if attribute is not null

Line 842: <> nvl(pay_fed_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))

838: -- If the value is being updated or inserted...
839: --
840: if ((p_emp_fed_tax_rule_id is not null
841: and nvl(p_supp_tax_override_rate,hr_api.g_number)
842: <> nvl(pay_fed_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
843: or
844: (p_emp_fed_tax_rule_id is null)) then
845: --
846: -- Validate only if attribute is not null

Line 922: and paa.assignment_id = pay_fed_shd.g_old_rec.assignment_id

918: pay_assignment_actions paa
919: where ppa.payroll_action_id = paa.payroll_action_id
920: and ppa.action_type in ('Q','R','B','I','V')
921: and ppa.date_earned > p_csr_tmp_date
922: and paa.assignment_id = pay_fed_shd.g_old_rec.assignment_id
923: and paa.action_status = 'C'
924: );
925: --
926: -- Cursor to check for existing state tax rules

Line 1039: (p_rec in pay_fed_shd.g_rec_type

1035: --
1036: -- {End Of Comments}
1037: -- ----------------------------------------------------------------------------
1038: Procedure chk_non_updateable_args
1039: (p_rec in pay_fed_shd.g_rec_type
1040: ,p_effective_date in date
1041: ) is
1042: --
1043: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 1053: if not pay_fed_shd.api_updating

1049: --
1050: -- Only proceed with validation if a row exists for
1051: -- the current record in the HR schema
1052: --
1053: if not pay_fed_shd.api_updating
1054: (p_emp_fed_tax_rule_id => p_rec.emp_fed_tax_rule_id
1055: ,p_object_version_number => p_rec.object_version_number
1056: ,p_effective_date => p_effective_date
1057: ) then

Line 1065: pay_fed_shd.g_old_rec.assignment_id)then

1061: end if;
1062: hr_utility.set_location(l_proc, 30);
1063: --
1064: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1065: pay_fed_shd.g_old_rec.assignment_id)then
1066: l_argument := 'assignment_id';
1067: raise l_error;
1068: end if;
1069: hr_utility.set_location(l_proc, 40);

Line 1072: pay_fed_shd.g_old_rec.business_group_id)then

1068: end if;
1069: hr_utility.set_location(l_proc, 40);
1070: --
1071: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1072: pay_fed_shd.g_old_rec.business_group_id)then
1073: l_argument := 'business_group_id';
1074: raise l_error;
1075: end if;
1076: hr_utility.set_location(l_proc, 50);

Line 1287: (p_rec in pay_fed_shd.g_rec_type,

1283: -- ----------------------------------------------------------------------------
1284: -- |---------------------------< insert_validate >----------------------------|
1285: -- ----------------------------------------------------------------------------
1286: Procedure insert_validate
1287: (p_rec in pay_fed_shd.g_rec_type,
1288: p_effective_date in date,
1289: p_datetrack_mode in varchar2,
1290: p_validation_start_date in date,
1291: p_validation_end_date in date) is

Line 1372: (p_rec in pay_fed_shd.g_rec_type,

1368: -- ----------------------------------------------------------------------------
1369: -- |---------------------------< update_validate >----------------------------|
1370: -- ----------------------------------------------------------------------------
1371: Procedure update_validate
1372: (p_rec in pay_fed_shd.g_rec_type,
1373: p_effective_date in date,
1374: p_datetrack_mode in varchar2,
1375: p_validation_start_date in date,
1376: p_validation_end_date in date) is

Line 1462: (p_rec in pay_fed_shd.g_rec_type

1458: -- ----------------------------------------------------------------------------
1459: -- |---------------------------< delete_validate >----------------------------|
1460: -- ----------------------------------------------------------------------------
1461: Procedure delete_validate
1462: (p_rec in pay_fed_shd.g_rec_type
1463: ,p_effective_date in date
1464: ,p_datetrack_mode in varchar2
1465: ,p_validation_start_date in date
1466: ,p_validation_end_date in date

Line 1479: ,p_assignment_id => pay_fed_shd.g_old_rec.assignment_id

1475: -- Call all supporting business operations
1476: --
1477: chk_delete
1478: (p_emp_fed_tax_rule_id => p_rec.emp_fed_tax_rule_id
1479: ,p_assignment_id => pay_fed_shd.g_old_rec.assignment_id
1480: ,p_effective_date => p_effective_date
1481: ,p_datetrack_mode => p_datetrack_mode
1482: ,p_validation_start_date => p_validation_start_date
1483: ,p_validation_end_date => p_validation_end_date