1 PACKAGE pay_us_action_arch AUTHID CURRENT_USER AS
2 /* $Header: pyusxfrp.pkh 120.4.12020000.3 2013/02/04 16:10:38 emunisek ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 25-JAN-2001 Asasthan 115.0 Created.
30 04-APR-2001 Asasthan 115.4 Changed action29 to number.
31 13-JUN-2001 Asasthan 115.5 Added Effective date.
32 15-AUG-2001 Asasthan 115.6 Payslip changes.
33 22-JAN-2002 ahanda 115.5 Changed package to take care
34 of Multi Assignment Processing.
35 17-JUN-2002 ahanda 115.10 2365908 Changed package to populate tax
36 deductions if location has changed.
37 15-OCT-2002 tmehra 115.11 Added Function to check for Alien.
38 02-DEC-2002 ahanda 115.13 Changed package to fix GSCC warnings.
39 04-DEC-2003 vpandya 115.14 Added variable gv_act_param_val
40 which is being used in pyusxfrp.pkb
41 version 115.80 or above.
42 03-NOV-2004 ahanda 115.15 Changed parameter for action_creation
43 procedure.
44 31-MAR-2009 sudedas 115.17 3816988 Introduced procedure -
45 action_archdeinit
46 03-AUG-2010 emunisek 115.18 9872952 Added parameter g_wage_exempt to hold
47 the value, if the Employee is subject
48 to FIT Exempt from Wage Accumulation.
49 20-Feb-2012 abellur 115.20 13029995 Added global variables g_assignment_id
50 and g_assignment_id, to support/archive
51 third party XML Check Writer.
52 04-FEB-2013 emunisek 115.21 16082307 Made Procedure get_employee_withholding_info
53 Public so that it can be called from Payroll
54 Simulator related Package.
55 */
56 --
57
58 PROCEDURE get_payroll_action_info(p_payroll_action_id in number
59 ,p_end_date out nocopy date
60 ,p_start_date out nocopy date
61 ,p_business_group_id out nocopy number
62 ,p_cons_set_id out nocopy number
63 ,p_payroll_id out nocopy number
64 );
65
66 PROCEDURE action_range_cursor(p_payroll_action_id in number
67 ,p_sqlstr out nocopy varchar2);
68
69 PROCEDURE action_action_creation(p_payroll_action_id in number
70 ,p_start_person_id in number
71 ,p_end_person_id in number
72 ,p_chunk in number);
73
74 PROCEDURE action_archive_data(p_xfr_action_id in number,
75 p_effective_date in date);
76
77
78 PROCEDURE action_archinit(p_payroll_action_id in number);
79
80 PROCEDURE action_archdeinit(p_payroll_action_id IN NUMBER);
81
82 FUNCTION check_alien(
83 p_assignment_action_id in number)
84 RETURN VARCHAR2;
85
86 PROCEDURE get_employee_withholding_info(
87 p_assignment_id in number
88 ,p_run_effective_date in date
89 ,p_resident_jurisdiction in varchar2
90 );
91
92 TYPE state_tax_info_rec IS RECORD
93 ( sit_exists varchar2(1)
94 ,sui_ee_exists varchar2(1)
95 ,sui_er_exists varchar2(1)
96 ,sdi_ee_exists varchar2(1)
97 ,sdi_er_exists varchar2(1)
98 );
99
100 TYPE state_tax_info_table IS TABLE OF
101 state_tax_info_rec
102 INDEX BY BINARY_INTEGER;
103
104 TYPE county_tax_info_rec IS RECORD
105 ( jurisdiction_code varchar2(11)
106 ,cnty_tax_exists varchar2(1)
107 ,cnty_head_tax_exists varchar2(1)
108 ,cnty_sd_tax_exists varchar2(1)
109 );
110
111 TYPE county_tax_info_table IS TABLE OF
112 county_tax_info_rec
113 INDEX BY BINARY_INTEGER;
114
115 TYPE jurisdiction_rec IS RECORD
116 ( action_info_category varchar2(25)
117 ,balance_name varchar2(80)
118 ,balance_type_id number
119 ,payment_def_bal_id number
120 ,asg_run_def_bal_id number
121 ,ytd_def_bal_id number
122 );
123
124 TYPE jurisdiction_tab IS TABLE OF
125 jurisdiction_rec
126 INDEX BY BINARY_INTEGER;
127
128 TYPE school_jd_rec IS RECORD
129 (school_jd varchar2(11));
130
131 TYPE school_jd_tab IS TABLE OF
132 school_jd_rec
133 INDEX BY BINARY_INTEGER;
134
135 ltr_state_tax_info state_tax_info_table;
136 ltr_county_tax_info county_tax_info_table;
137
138 ltr_fed_tax_bal jurisdiction_tab;
139 ltr_state_tax_bal jurisdiction_tab;
140 ltr_state2_tax_bal jurisdiction_tab;
141 ltr_county_tax_bal jurisdiction_tab;
142 ltr_city_tax_bal jurisdiction_tab;
143 ---- PA32 Change begin
144 ltr_psd_tax_bal jurisdiction_tab;
145 -- PA32 Change end
146 ltr_schdist_tax_bal jurisdiction_tab;
147
148 g_min_chunk number:= -1;
149 g_archive_flag varchar2(1) := 'N';
150 g_bal_act_id number:= -1;
151 g_wage_exempt varchar2(1) := 'N'; /*Added for Bug#9872952*/
152 gv_act_param_val varchar2(240);
153
154 ---- PA32 Change begin
155 g_cty_wk_psd_wh_def_bal_id number := 0;
156 -- PA32 Change end
157
158 -- 13029995 introduced for 3rd party checks, change start
159 g_assignment_id number :=0;
160 g_printed varchar2(500);
161 -- 3rd party checks change end
162
163 END pay_us_action_arch;