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 1282: If l_element_rec_tbl(l_pct_inc).effective_end_date = hr_api.g_eot

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

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

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

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

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

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

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

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

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

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

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

Line 2173: if p_datetrack_mode = hr_api.g_zap then

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

Line 2174: l_tmp_date := hr_api.g_date;

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

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

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

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

3475: end if;
3476:
3477: -- I'm overriding the value of p_location_id if the datetrace mode
3478: -- is UPDATE_OVERRIDE and the location_id was passed as default value
3479: -- ie:hr_api.g_number. Reason for this is we should take the value of
3480: -- the location_id as of the effective date of the change and we must
3481: -- maintain the tax records. The value of
3482: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3483: -- hook (before) procedure to used for stored data.

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

3522: );
3523: end if; -- csr_get_tax_loc
3524: close csr_get_tax_loc;
3525:
3526: -- reimp - changed hr_api.g_number to be null, since this code assumes null
3527: -- to mean the location hasn't changed.
3528:
3529: if l_location_id = hr_api.g_number then
3530: l_location_id := null;

Line 3529: if l_location_id = hr_api.g_number then

3525:
3526: -- reimp - changed hr_api.g_number to be null, since this code assumes null
3527: -- to mean the location hasn't changed.
3528:
3529: if l_location_id = hr_api.g_number then
3530: l_location_id := null;
3531: end if;
3532:
3533: -- reimp - changed the conditions before move_tax_default_date is called

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

3530: l_location_id := null;
3531: end if;
3532:
3533: -- reimp - changed the conditions before move_tax_default_date is called
3534: -- before it required l_location_id to not be null/hr_api.g_number
3535:
3536: if l_location_id is not null and
3537: l_effective_date >= l_defaulting_date then
3538: --

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

4185: hr_utility.set_location('Entering:'|| l_proc, 10);
4186: --
4187: -- Ensure that all the mandatory arguments are not null
4188: --
4189: hr_api.mandatory_arg_error(p_api_name => l_proc,
4190: p_argument => 'effective_date',
4191: p_argument_value => p_effective_date);
4192: --
4193: if p_assignment_id is null then

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

5299: from per_assignments_f asg
5300: where asg.assignment_id = p_assignment_id
5301: and p_date between asg.effective_start_date and asg.effective_end_date;
5302: --
5303: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is
5304: select null
5305: from pay_us_emp_fed_tax_rules_f fed
5306: where fed.assignment_id = p_assignment_id
5307: and fed.effective_start_date > l_csr_date;

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

6260: end if;
6261: --
6262: -- Check that L_EFFECTIVE_DATE is not null
6263: --
6264: hr_api.mandatory_arg_error(p_api_name => l_proc,
6265: p_argument => 'effective_date',
6266: p_argument_value => l_effective_date);
6267: --
6268: -- Validate p_assignment_id against per_assignments_f

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

6340: -- If it is DELETE_*_CHANGE or ZAP it doesn't matter what the location id is.
6341: --
6342: -- If it is UPDATE_OVERRIDE, the location_id is passed in by the maintain taxes proc.
6343: --
6344: if p_datetrack_mode in (hr_api.g_correction,hr_api.g_update_change_insert) then
6345: open csr_asg_loc_id(l_new_default_date);
6346: fetch csr_asg_loc_id into l_new_location_id;
6347: if csr_asg_loc_id%NOTFOUND then
6348: close csr_asg_loc_id;

Line 6454: if l_asg_eed = hr_api.g_eot then

6450: );
6451: --
6452: else -- DELETE_NEXT_CHANGE, defaulting not met
6453: --
6454: if l_asg_eed = hr_api.g_eot then
6455: --
6456: -- This delete extends to the end of time, so it removes the taxes.
6457: --
6458: delete_fed_tax_rule(