APPS.PAY_US_UPDATE_TAX_REC_PKG dependencies on PAY_US_UPDATE_TAX_REC_PKG

Line 1: PACKAGE BODY pay_us_update_tax_rec_pkg AS

1: PACKAGE BODY pay_us_update_tax_rec_pkg AS
2: /* $Header: pyusutxr.pkb 120.0 2005/05/29 10:07:53 appldev noship $ */
3:
4: PROCEDURE terminate_emp_tax_records ( p_assignment_id NUMBER
5: ,p_process_date DATE

Line 13: l_proc VARCHAR2(100) := 'pay_us_update_tax_rec_pkg.terminate_emp_tax_records';

9: l_new_end_date DATE;
10: l_ef_date DATE;
11: l_default_date DATE;
12: l_dt_mode VARCHAR2(30);
13: l_proc VARCHAR2(100) := 'pay_us_update_tax_rec_pkg.terminate_emp_tax_records';
14:
15: CURSOR csr_tax_defaulting(p_asg_id NUMBER) is
16: select min(ftr.effective_start_date)
17: from pay_us_emp_fed_tax_rules_f ftr

Line 167: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);

163: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||
164: p_assignment_id );
165: --
166: hr_utility.set_location
167: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);
168: UPDATE pay_us_emp_fed_tax_rules_f peft
169: SET peft.effective_end_date =
170: to_date('31/12/4712','DD/MM/YYYY')
171: WHERE peft.assignment_id = p_assignment_id

Line 175: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',6);

171: WHERE peft.assignment_id = p_assignment_id
172: AND peft.effective_end_date = p_process_date;
173: --
174: hr_utility.set_location
175: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',6);
176: UPDATE pay_us_emp_state_tax_rules_f pest
177: SET pest.effective_end_date =
178: to_date('31/12/4712','DD/MM/YYYY')
179: WHERE pest.assignment_id = p_assignment_id

Line 183: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',7);

179: WHERE pest.assignment_id = p_assignment_id
180: AND pest.effective_end_date = p_process_date;
181: --
182: hr_utility.set_location
183: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',7);
184: UPDATE pay_us_emp_county_tax_rules_f pect
185: SET pect.effective_end_date =
186: to_date('31/12/4712','DD/MM/YYYY')
187: WHERE pect.assignment_id = p_assignment_id

Line 191: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',8);

187: WHERE pect.assignment_id = p_assignment_id
188: AND pect.effective_end_date = p_process_date;
189: --
190: hr_utility.set_location
191: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',8);
192: UPDATE pay_us_emp_city_tax_rules_f pecit
193: SET pecit.effective_end_date =
194: to_date('31/12/4712','DD/MM/YYYY')
195: WHERE pecit.assignment_id = p_assignment_id

Line 204: end pay_us_update_tax_rec_pkg;

200: NULL;
201:
202: END reverse_term_emp_tax_records;
203:
204: end pay_us_update_tax_rec_pkg;