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_CNT_BUS dependencies on PAY_CNT_SHD

Line 101: l_api_updating := pay_cnt_shd.api_updating

97: ,p_argument => 'effective_date'
98: ,p_argument_value => p_effective_date
99: );
100: --
101: l_api_updating := pay_cnt_shd.api_updating
102: (
103: p_emp_county_tax_rule_id => p_emp_county_tax_rule_id,
104: p_effective_date => p_effective_date,
105: p_object_version_number => p_object_version_number

Line 192: pay_cnt_shd.constraint_error

188: open csr_valid_state_code;
189: fetch csr_valid_state_code into l_state_code;
190: if csr_valid_state_code%notfound then
191: close csr_valid_state_code;
192: pay_cnt_shd.constraint_error
193: (p_constraint_name => 'PAY_US_EMP_COUNTY_TAX_RULES_FK1');
194: end if;
195: else
196: hr_utility.set_message(801,'PAY_72774_CNT_STA_NOT_NULL');

Line 269: pay_cnt_shd.constraint_error

265: open csr_valid_county_code;
266: fetch csr_valid_county_code into l_county_code;
267: if csr_valid_county_code%notfound then
268: close csr_valid_county_code;
269: pay_cnt_shd.constraint_error
270: (p_constraint_name => 'PAY_US_EMP_COUNTY_TAX_RULE_FK3');
271: end if;
272: hr_utility.set_location(l_proc, 15);
273: else

Line 401: nvl(pay_cnt_shd.g_old_rec.additional_wa_rate, hr_api.g_number))

397: -- If value is being inserted or updated ...
398: --
399: if (p_emp_county_tax_rule_id is not null
400: and nvl(p_additional_wa_rate,hr_api.g_number) <>
401: nvl(pay_cnt_shd.g_old_rec.additional_wa_rate, hr_api.g_number))
402: or (p_emp_county_tax_rule_id is null) then
403: --
404: -- Check that additional_wa_rate is not null.
405: --

Line 494: l_api_updating := pay_cnt_shd.api_updating

490: );
491: --
492: hr_utility.set_location(l_proc, 15);
493: --
494: l_api_updating := pay_cnt_shd.api_updating
495: (p_emp_county_tax_rule_id => p_emp_county_tax_rule_id,
496: p_effective_date => p_effective_date,
497: p_object_version_number => p_object_version_number);
498: --

Line 578: nvl(pay_cnt_shd.g_old_rec.lit_additional_tax, hr_api.g_number))

574: -- If value is being inserted or updated ...
575: --
576: if (p_emp_county_tax_rule_id is not null
577: and nvl(p_lit_additional_tax,hr_api.g_number) <>
578: nvl(pay_cnt_shd.g_old_rec.lit_additional_tax, hr_api.g_number))
579: or (p_emp_county_tax_rule_id is null) then
580: --
581: -- Check that lit_additional_tax is not null.
582: --

Line 644: nvl(pay_cnt_shd.g_old_rec.lit_override_amount,hr_api.g_number))

640: -- If value is being inserted or updated ...
641: --
642: if (p_emp_county_tax_rule_id is not null
643: and nvl(p_lit_override_amount,hr_api.g_number) <>
644: nvl(pay_cnt_shd.g_old_rec.lit_override_amount,hr_api.g_number))
645: or (p_emp_county_tax_rule_id is null) then
646: --
647: -- Check that lit_override_amount is not null.
648: --

Line 712: nvl(pay_cnt_shd.g_old_rec.lit_override_rate,hr_api.g_number))

708: -- If value is being inserted or updated ...
709: --
710: if (p_emp_county_tax_rule_id is not null
711: and nvl(p_lit_override_rate,hr_api.g_number) <>
712: nvl(pay_cnt_shd.g_old_rec.lit_override_rate,hr_api.g_number))
713: or (p_emp_county_tax_rule_id is null) then
714: --
715: -- Check that lit_override_rate is not null.
716: --

Line 780: nvl(pay_cnt_shd.g_old_rec.withholding_allowances,hr_api.g_number))

776: -- If value is being inserted or updated ...
777: --
778: if (p_emp_county_tax_rule_id is not null
779: and nvl(p_withholding_allowances,hr_api.g_number) <>
780: nvl(pay_cnt_shd.g_old_rec.withholding_allowances,hr_api.g_number))
781: or (p_emp_county_tax_rule_id is null) then
782: --
783: -- Check that withholding_allowances is not null.
784: --

Line 928: l_api_updating := pay_cnt_shd.api_updating

924: ,p_argument => 'county_code'
925: ,p_argument_value => p_county_code
926: );
927: --
928: l_api_updating := pay_cnt_shd.api_updating
929: (
930: p_effective_date => p_effective_date,
931: p_emp_county_tax_rule_id => p_emp_county_tax_rule_id,
932: p_object_version_number => p_object_version_number

Line 939: nvl(pay_cnt_shd.g_old_rec.school_district_code,hr_api.g_varchar2))

935: -- Only perform validation if the school district code value has changed
936: --
937: if (l_api_updating
938: and nvl(p_school_district_code,hr_api.g_varchar2) <>
939: nvl(pay_cnt_shd.g_old_rec.school_district_code,hr_api.g_varchar2))
940: or (not l_api_updating) then
941: --
942: -- Check school_district_code.
943: --

Line 1015: (p_rec in pay_cnt_shd.g_rec_type,

1011: -- Access Status
1012: -- Internal Row Handler Use Only.
1013: --
1014: Procedure chk_non_updateable_args
1015: (p_rec in pay_cnt_shd.g_rec_type,
1016: p_effective_date in date
1017: ) is
1018: --
1019: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 1027: if not pay_cnt_shd.api_updating

1023: Begin
1024: hr_utility.set_location('Entering: '||l_proc, 10);
1025: --
1026: --
1027: if not pay_cnt_shd.api_updating
1028: (p_emp_county_tax_rule_id => p_rec.emp_county_tax_rule_id,
1029: p_object_version_number => p_rec.object_version_number,
1030: p_effective_date => p_effective_date
1031: ) then

Line 1039: nvl(pay_cnt_shd.g_old_rec.business_group_id, hr_api.g_number)) then

1035: end if;
1036: hr_utility.set_location(l_proc, 30);
1037: --
1038: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1039: nvl(pay_cnt_shd.g_old_rec.business_group_id, hr_api.g_number)) then
1040: l_argument := 'business_group_id';
1041: raise l_error;
1042: end if;
1043: hr_utility.set_location(l_proc, 40);

Line 1046: pay_cnt_shd.g_old_rec.assignment_id) then

1042: end if;
1043: hr_utility.set_location(l_proc, 40);
1044: --
1045: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1046: pay_cnt_shd.g_old_rec.assignment_id) then
1047: l_argument := 'assignment_id';
1048: raise l_error;
1049: end if;
1050: hr_utility.set_location(l_proc, 50);

Line 1053: pay_cnt_shd.g_old_rec.state_code) then

1049: end if;
1050: hr_utility.set_location(l_proc, 50);
1051: --
1052: if (nvl(p_rec.state_code, hr_api.g_varchar2) <>
1053: pay_cnt_shd.g_old_rec.state_code) then
1054: l_argument := 'state_code';
1055: raise l_error;
1056: end if;
1057: hr_utility.set_location(l_proc, 60);

Line 1060: pay_cnt_shd.g_old_rec.county_code) then

1056: end if;
1057: hr_utility.set_location(l_proc, 60);
1058: --
1059: if (nvl(p_rec.county_code, hr_api.g_varchar2) <>
1060: pay_cnt_shd.g_old_rec.county_code) then
1061: l_argument := 'county_code';
1062: raise l_error;
1063: end if;
1064: hr_utility.set_location(l_proc, 70);

Line 1067: pay_cnt_shd.g_old_rec.jurisdiction_code) then

1063: end if;
1064: hr_utility.set_location(l_proc, 70);
1065: --
1066: if (nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1067: pay_cnt_shd.g_old_rec.jurisdiction_code) then
1068: l_argument := 'jurisdiction_code';
1069: raise l_error;
1070: end if;
1071: hr_utility.set_location('Leaving: '||l_proc, 80);

Line 1488: (p_rec in pay_cnt_shd.g_rec_type,

1484: -- ----------------------------------------------------------------------------
1485: -- |---------------------------< insert_validate >----------------------------|
1486: -- ----------------------------------------------------------------------------
1487: Procedure insert_validate
1488: (p_rec in pay_cnt_shd.g_rec_type,
1489: p_effective_date in date,
1490: p_datetrack_mode in varchar2,
1491: p_validation_start_date in date,
1492: p_validation_end_date in date) is

Line 1577: (p_rec in pay_cnt_shd.g_rec_type,

1573: -- ----------------------------------------------------------------------------
1574: -- |---------------------------< update_validate >----------------------------|
1575: -- ----------------------------------------------------------------------------
1576: Procedure update_validate
1577: (p_rec in pay_cnt_shd.g_rec_type,
1578: p_effective_date in date,
1579: p_datetrack_mode in varchar2,
1580: p_validation_start_date in date,
1581: p_validation_end_date in date) is

Line 1653: (p_rec in pay_cnt_shd.g_rec_type,

1649: -- ----------------------------------------------------------------------------
1650: -- |---------------------------< delete_validate >----------------------------|
1651: -- ----------------------------------------------------------------------------
1652: Procedure delete_validate
1653: (p_rec in pay_cnt_shd.g_rec_type,
1654: p_effective_date in date,
1655: p_datetrack_mode in varchar2,
1656: p_delete_routine in varchar2,
1657: p_validation_start_date in date,

Line 1669: p_assignment_id => pay_cnt_shd.g_old_rec.assignment_id,

1665: -- Call all supporting business operations
1666: --
1667: chk_delete
1668: (p_effective_date => p_effective_date,
1669: p_assignment_id => pay_cnt_shd.g_old_rec.assignment_id,
1670: p_state_code => pay_cnt_shd.g_old_rec.state_code,
1671: p_county_code => pay_cnt_shd.g_old_rec.county_code,
1672: p_delete_mode => p_datetrack_mode,
1673: p_delete_routine => p_delete_routine);

Line 1670: p_state_code => pay_cnt_shd.g_old_rec.state_code,

1666: --
1667: chk_delete
1668: (p_effective_date => p_effective_date,
1669: p_assignment_id => pay_cnt_shd.g_old_rec.assignment_id,
1670: p_state_code => pay_cnt_shd.g_old_rec.state_code,
1671: p_county_code => pay_cnt_shd.g_old_rec.county_code,
1672: p_delete_mode => p_datetrack_mode,
1673: p_delete_routine => p_delete_routine);
1674: --

Line 1671: p_county_code => pay_cnt_shd.g_old_rec.county_code,

1667: chk_delete
1668: (p_effective_date => p_effective_date,
1669: p_assignment_id => pay_cnt_shd.g_old_rec.assignment_id,
1670: p_state_code => pay_cnt_shd.g_old_rec.state_code,
1671: p_county_code => pay_cnt_shd.g_old_rec.county_code,
1672: p_delete_mode => p_datetrack_mode,
1673: p_delete_routine => p_delete_routine);
1674: --
1675: dt_delete_validate