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_US_TAX_INTERNAL dependencies on HR_API

Line 70: and nvl(adr.date_to, hr_api.g_eot)

66: ,pay_us_city_names cty2
67: where adr.person_id = p_person_id
68: and adr.primary_flag = 'Y'
69: and p_effective_date between adr.date_from
70: and nvl(adr.date_to, hr_api.g_eot)
71: AND CNT.STATE_CODE = STA.STATE_CODE
72: AND ADR.TOWN_OR_CITY = CTY.CITY_NAME
73: AND ADR.REGION_1 = CNT.COUNTY_NAME
74: AND ADR.REGION_2 = STA.STATE_ABBREV

Line 117: l_csr_date date default hr_api.g_sot) is

113:
114:
115: cursor csr_future_state_rule( p_state_code number,
116: p_assignment_id number,
117: l_csr_date date default hr_api.g_sot) is
118: select null
119: from pay_us_emp_state_tax_rules_f sta
120: where sta.assignment_id = p_assignment_id
121: and sta.state_code = p_state_code

Line 126: l_csr_date date default hr_api.g_sot) is

122: and sta.effective_start_date > l_csr_date;
123: --
124: cursor csr_future_county_rule( p_state_code number, p_county_code number,
125: p_assignment_id number,
126: l_csr_date date default hr_api.g_sot) is
127: select null
128: from pay_us_emp_county_tax_rules_f cnt
129: where cnt.assignment_id = p_assignment_id
130: and cnt.state_code = p_state_code

Line 136: l_csr_date date default hr_api.g_sot) is

132: and cnt.effective_start_date > l_csr_date;
133: --
134: cursor csr_future_city_rule( p_state_code number, p_county_code number,
135: p_city_code varchar2, p_assignment_id number,
136: l_csr_date date default hr_api.g_sot) is
137: select null
138: from pay_us_emp_city_tax_rules_f cty
139: where cty.assignment_id = p_assignment_id
140: and cty.state_code = p_state_code

Line 160: and nvl(adr.date_to, hr_api.g_eot)

156: and asg.soft_coding_keyflex_id is not null
157: and asg.assignment_type = 'E'
158: and asg.person_id = adr.person_id
159: and p_ef_date between adr.date_from
160: and nvl(adr.date_to, hr_api.g_eot)
161: and adr.primary_flag = 'Y'
162: and rownum = 1
163: and exists (select null
164: from hr_soft_coding_keyflex sck

Line 1284: If l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

1280: --
1281: -- Make sure that the start and end dates match the 'VERTEX'
1282: -- Element Entry row(s).
1283: --
1284: If l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot
1285: or not l_element_rec_tbl.exists(l_pct_inc + 1) then
1286: --
1287: hr_utility.set_location(l_proc, 75);
1288: --

Line 1339: (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

1335: l_input_value_id_tbl
1336: );
1337: if l_element_rec_tbl(l_pct_inc).effective_start_date <= p_effective_date and
1338: l_element_rec_tbl(l_pct_inc).effective_end_date >= p_effective_date and
1339: (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot
1340: or not l_element_rec_tbl.exists(l_pct_inc + 1)) then
1341: --
1342: hr_utility.set_location(l_proc, 90);
1343: --

Line 1595: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

1591: hr_utility.raise_error;
1592: end if;
1593: If l_location_chg_tbl(l_asg_inc).end_date <
1594: l_element_rec_tbl(l_pct_inc).effective_end_date
1595: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot
1596: or not l_element_rec_tbl.exists(l_pct_inc + 1)) then
1597: --
1598: hr_utility.set_location(l_proc ,145);
1599: --

Line 1718: record's effective end date = hr_api.g_eot or the next percentage

1714: --
1715: /*
1716: a. if the current assignment location record's effective end date <
1717: current percentage record's effective end date and current percentage
1718: record's effective end date = hr_api.g_eot or the next percentage
1719: record doesn't exist then call hr_entry_api.update_element_entry with
1720: a mode of 'UPDATE' at the the assignment record's effective end
1721: date + 1.
1722: b. else if the current assignment location record's effective end date

Line 1772: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

1768: hr_utility.raise_error;
1769: end if;
1770: If l_location_chg_tbl(l_asg_inc).end_date <
1771: l_element_rec_tbl(l_pct_inc).effective_end_date
1772: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot
1773: or not l_element_rec_tbl.exists(l_pct_inc + 1)) then
1774: --
1775: hr_utility.set_location(l_proc ,185);
1776: --

Line 1928: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

1924: l_input_value_id_tbl
1925: );
1926: If l_location_chg_tbl(l_asg_inc).end_date <
1927: l_element_rec_tbl(l_pct_inc).effective_end_date
1928: and (l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot
1929: or not l_element_rec_tbl.exists(l_pct_inc + 1)) then
1930: --
1931: hr_utility.set_location(l_proc ,225);
1932: --

Line 2175: if p_datetrack_mode = hr_api.g_zap then

2171: -- If the entries have already been purged or deleted, there is nothing to do here,
2172: -- otherwise, perform the delete.
2173: --
2174: if p_datetrack_mode in('ZAP','DELETE') then
2175: if p_datetrack_mode = hr_api.g_zap then
2176: l_tmp_date := hr_api.g_date;
2177: else
2178: l_tmp_date := l_effective_date;
2179: end if;

Line 2176: l_tmp_date := hr_api.g_date;

2172: -- otherwise, perform the delete.
2173: --
2174: if p_datetrack_mode in('ZAP','DELETE') then
2175: if p_datetrack_mode = hr_api.g_zap then
2176: l_tmp_date := hr_api.g_date;
2177: else
2178: l_tmp_date := l_effective_date;
2179: end if;
2180: open csr_get_ele_entry_id(l_assignment_id

Line 2597: hr_api.mandatory_arg_error(p_api_name => l_proc,

2593: hr_utility.set_location('Entering:'|| l_proc, 10);
2594: --
2595: -- Ensure that all the mandatory arguments are not null
2596: --
2597: hr_api.mandatory_arg_error(p_api_name => l_proc,
2598: p_argument => 'effective_date',
2599: p_argument_value => p_effective_date);
2600: --
2601: l_effective_date := trunc(p_effective_date);

Line 3563: -- ie:hr_api.g_number. Reason for this is we should take the value of

3559: end if;
3560:
3561: -- I'm overriding the value of p_location_id if the datetrace mode
3562: -- is UPDATE_OVERRIDE and the location_id was passed as default value
3563: -- ie:hr_api.g_number. Reason for this is we should take the value of
3564: -- the location_id as of the effective date of the change and we must
3565: -- maintain the tax records. The value of
3566: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3567: -- hook (before) procedure to used for stored data.

Line 3610: -- reimp - changed hr_api.g_number to be null, since this code assumes null

3606: );
3607: end if; -- csr_get_tax_loc
3608: close csr_get_tax_loc;
3609:
3610: -- reimp - changed hr_api.g_number to be null, since this code assumes null
3611: -- to mean the location hasn't changed.
3612:
3613: if l_location_id = hr_api.g_number then
3614: l_location_id := null;

Line 3613: if l_location_id = hr_api.g_number then

3609:
3610: -- reimp - changed hr_api.g_number to be null, since this code assumes null
3611: -- to mean the location hasn't changed.
3612:
3613: if l_location_id = hr_api.g_number then
3614: l_location_id := null;
3615: end if;
3616:
3617: -- reimp - changed the conditions before move_tax_default_date is called

Line 3618: -- before it required l_location_id to not be null/hr_api.g_number

3614: l_location_id := null;
3615: end if;
3616:
3617: -- reimp - changed the conditions before move_tax_default_date is called
3618: -- before it required l_location_id to not be null/hr_api.g_number
3619:
3620: if l_location_id is not null and
3621: l_effective_date >= l_defaulting_date then
3622: --

Line 4273: hr_api.mandatory_arg_error(p_api_name => l_proc,

4269: hr_utility.set_location('Entering:'|| l_proc, 10);
4270: --
4271: -- Ensure that all the mandatory arguments are not null
4272: --
4273: hr_api.mandatory_arg_error(p_api_name => l_proc,
4274: p_argument => 'effective_date',
4275: p_argument_value => p_effective_date);
4276: --
4277: if p_assignment_id is null then

Line 5387: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is

5383: from per_assignments_f asg
5384: where asg.assignment_id = p_assignment_id
5385: and p_date between asg.effective_start_date and asg.effective_end_date;
5386: --
5387: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is
5388: select null
5389: from pay_us_emp_fed_tax_rules_f fed
5390: where fed.assignment_id = p_assignment_id
5391: and fed.effective_start_date > l_csr_date;

Line 6348: hr_api.mandatory_arg_error(p_api_name => l_proc,

6344: end if;
6345: --
6346: -- Check that L_EFFECTIVE_DATE is not null
6347: --
6348: hr_api.mandatory_arg_error(p_api_name => l_proc,
6349: p_argument => 'effective_date',
6350: p_argument_value => l_effective_date);
6351: --
6352: -- Validate p_assignment_id against per_assignments_f

Line 6428: if p_datetrack_mode in (hr_api.g_correction,hr_api.g_update_change_insert) then

6424: -- If it is DELETE_*_CHANGE or ZAP it doesn't matter what the location id is.
6425: --
6426: -- If it is UPDATE_OVERRIDE, the location_id is passed in by the maintain taxes proc.
6427: --
6428: if p_datetrack_mode in (hr_api.g_correction,hr_api.g_update_change_insert) then
6429: open csr_asg_loc_id(l_new_default_date);
6430: fetch csr_asg_loc_id into l_new_location_id;
6431: if csr_asg_loc_id%NOTFOUND then
6432: close csr_asg_loc_id;

Line 6538: if l_asg_eed = hr_api.g_eot then

6534: );
6535: --
6536: else -- DELETE_NEXT_CHANGE, defaulting not met
6537: --
6538: if l_asg_eed = hr_api.g_eot then
6539: --
6540: -- This delete extends to the end of time, so it removes the taxes.
6541: --
6542: delete_fed_tax_rule(