1 PACKAGE pay_ca_update_tax_rec_pkg AS
2 /* $Header: pycautxr.pkh 120.1.12010000.1 2008/11/12 09:29:26 sneelapa noship $ */
3 ------------------------------------------------------------------------------
4 /*
5
6 +======================================================================+
7 | Copyright (c) 1997 Oracle Corporation |
8 | Redwood Shores, California, USA |
9 | All rights reserved. |
10 +======================================================================+
11 Package Header Name : PAY_CA_UPDATE_TAX_REC_PKG
12 Package File Name : pycautxr.pkh
13 Description : This package was created to handle the update of the tax
14 records in specific case:
15
16 a) If the employee termination is reversed, the tax records
17 need to be modified to update the Effective End Date to
18 the end of time.
19
20 The following two tables are updated:
21 pay_ca_emp_fed_tax_info_f, pay_ca_emp_prov_tax_info_f.
22
23 Change List:
24 ------------
25
26 Name Date Version Bug Text
27 ----------- ---------- --------- ------- ------------------------------
28 sneelapa 23-APR-08 115.0 Initial Version
29
30 ======================================================================== */
31
32 PROCEDURE reverse_term_emp_tax_records ( p_assignment_id NUMBER
33 ,p_process_date DATE);
34
35 end pay_ca_update_tax_rec_pkg;