1 package pay_us_cont_calc AUTHID CURRENT_USER as
2 /* $Header: pyuscoc.pkh 120.0 2005/05/29 02:18:50 appldev noship $ */
3
4 /*
5 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
6
7 Description : Package and procedure to build sql for payroll processes.
8
9 Change List
10 -----------
11 Date Name Vers Bug No Description
12 ----------- ---------- ----- ------- -----------------------------------
13 26-MAR-2001 nbristow 115.0 Created.
14
15 */
16 --
17 procedure PAY_US_FED_TAX_RULES_F_aru(
18 p_business_group_id in number,
19 p_legislation_code in varchar2,
20 p_effective_date in date ,
21 p_old_ADDITIONAL_WA_AMOUNT in NUMBER,
22 p_new_ADDITIONAL_WA_AMOUNT in NUMBER ,
23 p_old_ASSIGNMENT_ID in NUMBER,
24 p_new_ASSIGNMENT_ID in NUMBER ,
25 p_old_BUSINESS_GROUP_ID in NUMBER,
26 p_new_BUSINESS_GROUP_ID in NUMBER ,
27 p_old_CUMULATIVE_TAXATION in VARCHAR2,
28 p_new_CUMULATIVE_TAXATION in VARCHAR2 ,
29 p_old_EIC_FILING_STATUS_CODE in VARCHAR2,
30 p_new_EIC_FILING_STATUS_CODE in VARCHAR2 ,
31 p_old_EMP_FED_TAX_RULE_ID in NUMBER,
32 p_new_EMP_FED_TAX_RULE_ID in NUMBER ,
33 p_old_EXCESSIVE_WA_REJECT_DATE in DATE,
34 p_new_EXCESSIVE_WA_REJECT_DATE in DATE ,
35 p_old_FILING_STATUS_CODE in VARCHAR2,
36 p_new_FILING_STATUS_CODE in VARCHAR2 ,
37 p_old_FIT_ADDITIONAL_TAX in NUMBER,
38 p_new_FIT_ADDITIONAL_TAX in NUMBER ,
39 p_old_FIT_EXEMPT in VARCHAR2,
40 p_new_FIT_EXEMPT in VARCHAR2 ,
41 p_old_FIT_OVERRIDE_AMOUNT in NUMBER,
42 p_new_FIT_OVERRIDE_AMOUNT in NUMBER ,
43 p_old_FIT_OVERRIDE_RATE in NUMBER,
44 p_new_FIT_OVERRIDE_RATE in NUMBER ,
45 p_old_FUTA_TAX_EXEMPT in VARCHAR2,
46 p_new_FUTA_TAX_EXEMPT in VARCHAR2 ,
47 p_old_MEDICARE_TAX_EXEMPT in VARCHAR2,
48 p_new_MEDICARE_TAX_EXEMPT in VARCHAR2 ,
49 p_old_SS_TAX_EXEMPT in VARCHAR2,
50 p_new_SS_TAX_EXEMPT in VARCHAR2 ,
51 p_old_STATUTORY_EMPLOYEE in VARCHAR2,
52 p_new_STATUTORY_EMPLOYEE in VARCHAR2 ,
53 p_old_SUI_JURISDICTION_CODE in VARCHAR2,
54 p_new_SUI_JURISDICTION_CODE in VARCHAR2 ,
55 p_old_SUI_STATE_CODE in VARCHAR2,
56 p_new_SUI_STATE_CODE in VARCHAR2 ,
57 p_old_SUPP_TAX_OVERRIDE_RATE in NUMBER,
58 p_new_SUPP_TAX_OVERRIDE_RATE in NUMBER ,
59 p_old_W2_FILED_YEAR in NUMBER,
60 p_new_W2_FILED_YEAR in NUMBER ,
61 p_old_WITHHOLDING_ALLOWANCES in NUMBER,
62 p_new_WITHHOLDING_ALLOWANCES in NUMBER ,
63 p_old_EFFECTIVE_END_DATE in DATE,
64 p_new_EFFECTIVE_END_DATE in DATE ,
65 p_old_EFFECTIVE_START_DATE in DATE,
66 p_new_EFFECTIVE_START_DATE in DATE
67 );
68 --
69 procedure PAY_US_STATE_TAX_RULES_F_aru(
70 p_business_group_id in number,
71 p_legislation_code in varchar2,
72 p_effective_date in date ,
73 p_old_ADDITIONAL_WA_AMOUNT in NUMBER,
74 p_new_ADDITIONAL_WA_AMOUNT in NUMBER ,
75 p_old_ASSIGNMENT_ID in NUMBER,
76 p_new_ASSIGNMENT_ID in NUMBER ,
77 p_old_BUSINESS_GROUP_ID in NUMBER,
78 p_new_BUSINESS_GROUP_ID in NUMBER ,
79 p_old_EMP_STATE_TAX_RULE_ID in NUMBER,
80 p_new_EMP_STATE_TAX_RULE_ID in NUMBER ,
81 p_old_EXCESSIVE_WA_REJECT_DATE in DATE,
82 p_new_EXCESSIVE_WA_REJECT_DATE in DATE ,
83 p_old_FILING_STATUS_CODE in VARCHAR2,
84 p_new_FILING_STATUS_CODE in VARCHAR2 ,
85 p_old_JURISDICTION_CODE in VARCHAR2,
86 p_new_JURISDICTION_CODE in VARCHAR2 ,
87 p_old_REMAINDER_PERCENT in NUMBER,
88 p_new_REMAINDER_PERCENT in NUMBER ,
89 p_old_SDI_EXEMPT in VARCHAR2,
90 p_new_SDI_EXEMPT in VARCHAR2 ,
91 p_old_SECONDARY_WA in NUMBER,
92 p_new_SECONDARY_WA in NUMBER ,
93 p_old_SIT_ADDITIONAL_TAX in NUMBER,
94 p_new_SIT_ADDITIONAL_TAX in NUMBER ,
95 p_old_SIT_EXEMPT in VARCHAR2,
96 p_new_SIT_EXEMPT in VARCHAR2 ,
97 p_old_SIT_OPTIONAL_CALC_IND in VARCHAR2,
98 p_new_SIT_OPTIONAL_CALC_IND in VARCHAR2 ,
99 p_old_SIT_OVERRIDE_AMOUNT in NUMBER,
100 p_new_SIT_OVERRIDE_AMOUNT in NUMBER ,
101 p_old_SIT_OVERRIDE_RATE in NUMBER,
102 p_new_SIT_OVERRIDE_RATE in NUMBER ,
103 p_old_STATE_CODE in VARCHAR2,
104 p_new_STATE_CODE in VARCHAR2 ,
105 p_old_STATE_NON_RESIDENT_CERT in VARCHAR2,
106 p_new_STATE_NON_RESIDENT_CERT in VARCHAR2 ,
107 p_old_SUI_EXEMPT in VARCHAR2,
108 p_new_SUI_EXEMPT in VARCHAR2 ,
109 p_old_SUI_WAGE_BASE_OVERRIDE_A in NUMBER,
110 p_new_SUI_WAGE_BASE_OVERRIDE_A in NUMBER ,
111 p_old_SUPP_TAX_OVERRIDE_RATE in NUMBER,
112 p_new_SUPP_TAX_OVERRIDE_RATE in NUMBER ,
113 p_old_WC_EXEMPT in VARCHAR2,
114 p_new_WC_EXEMPT in VARCHAR2 ,
115 p_old_WITHHOLDING_ALLOWANCES in NUMBER,
116 p_new_WITHHOLDING_ALLOWANCES in NUMBER ,
117 p_old_EFFECTIVE_END_DATE in DATE,
118 p_new_EFFECTIVE_END_DATE in DATE ,
119 p_old_EFFECTIVE_START_DATE in DATE,
120 p_new_EFFECTIVE_START_DATE in DATE
121 );
122 --
123 procedure PAY_US_COUNTY_TAX_RULES_F_aru(
124 p_business_group_id in number,
125 p_legislation_code in varchar2,
126 p_effective_date in date ,
127 p_old_ADDITIONAL_WA_RATE in NUMBER,
128 p_new_ADDITIONAL_WA_RATE in NUMBER ,
129 p_old_ASSIGNMENT_ID in NUMBER,
130 p_new_ASSIGNMENT_ID in NUMBER ,
131 p_old_BUSINESS_GROUP_ID in NUMBER,
132 p_new_BUSINESS_GROUP_ID in NUMBER ,
133 p_old_COUNTY_CODE in VARCHAR2,
134 p_new_COUNTY_CODE in VARCHAR2 ,
135 p_old_EMP_COUNTY_TAX_RULE_ID in NUMBER,
136 p_new_EMP_COUNTY_TAX_RULE_ID in NUMBER ,
137 p_old_FILING_STATUS_CODE in VARCHAR2,
138 p_new_FILING_STATUS_CODE in VARCHAR2 ,
139 p_old_HT_EXEMPT in VARCHAR2,
140 p_new_HT_EXEMPT in VARCHAR2 ,
141 p_old_JURISDICTION_CODE in VARCHAR2,
142 p_new_JURISDICTION_CODE in VARCHAR2 ,
143 p_old_LIT_ADDITIONAL_TAX in NUMBER,
144 p_new_LIT_ADDITIONAL_TAX in NUMBER ,
145 p_old_LIT_EXEMPT in VARCHAR2,
146 p_new_LIT_EXEMPT in VARCHAR2 ,
147 p_old_LIT_OVERRIDE_AMOUNT in NUMBER,
148 p_new_LIT_OVERRIDE_AMOUNT in NUMBER ,
149 p_old_LIT_OVERRIDE_RATE in NUMBER,
150 p_new_LIT_OVERRIDE_RATE in NUMBER ,
151 p_old_SCHOOL_DISTRICT_CODE in VARCHAR2,
152 p_new_SCHOOL_DISTRICT_CODE in VARCHAR2 ,
153 p_old_SD_EXEMPT in VARCHAR2,
154 p_new_SD_EXEMPT in VARCHAR2 ,
155 p_old_STATE_CODE in VARCHAR2,
156 p_new_STATE_CODE in VARCHAR2 ,
157 p_old_WITHHOLDING_ALLOWANCES in NUMBER,
158 p_new_WITHHOLDING_ALLOWANCES in NUMBER ,
159 p_old_EFFECTIVE_END_DATE in DATE,
160 p_new_EFFECTIVE_END_DATE in DATE ,
161 p_old_EFFECTIVE_START_DATE in DATE,
162 p_new_EFFECTIVE_START_DATE in DATE
163 );
164 --
165 procedure PAY_US_CITY_TAX_RULES_F_aru(
166 p_business_group_id in number,
167 p_legislation_code in varchar2,
168 p_effective_date in date ,
169 p_old_ADDITIONAL_WA_RATE in NUMBER,
170 p_new_ADDITIONAL_WA_RATE in NUMBER ,
171 p_old_ASSIGNMENT_ID in NUMBER,
172 p_new_ASSIGNMENT_ID in NUMBER ,
173 p_old_BUSINESS_GROUP_ID in NUMBER,
174 p_new_BUSINESS_GROUP_ID in NUMBER ,
175 p_old_CITY_CODE in VARCHAR2,
176 p_new_CITY_CODE in VARCHAR2 ,
177 p_old_COUNTY_CODE in VARCHAR2,
178 p_new_COUNTY_CODE in VARCHAR2 ,
179 p_old_EMP_CITY_TAX_RULE_ID in NUMBER,
180 p_new_EMP_CITY_TAX_RULE_ID in NUMBER ,
181 p_old_FILING_STATUS_CODE in VARCHAR2,
182 p_new_FILING_STATUS_CODE in VARCHAR2 ,
183 p_old_HT_EXEMPT in VARCHAR2,
184 p_new_HT_EXEMPT in VARCHAR2 ,
185 p_old_JURISDICTION_CODE in VARCHAR2,
186 p_new_JURISDICTION_CODE in VARCHAR2 ,
187 p_old_LIT_ADDITIONAL_TAX in NUMBER,
188 p_new_LIT_ADDITIONAL_TAX in NUMBER ,
189 p_old_LIT_EXEMPT in VARCHAR2,
190 p_new_LIT_EXEMPT in VARCHAR2 ,
191 p_old_LIT_OVERRIDE_AMOUNT in NUMBER,
192 p_new_LIT_OVERRIDE_AMOUNT in NUMBER ,
193 p_old_LIT_OVERRIDE_RATE in NUMBER,
194 p_new_LIT_OVERRIDE_RATE in NUMBER ,
195 p_old_SCHOOL_DISTRICT_CODE in VARCHAR2,
196 p_new_SCHOOL_DISTRICT_CODE in VARCHAR2 ,
197 p_old_SD_EXEMPT in VARCHAR2,
198 p_new_SD_EXEMPT in VARCHAR2 ,
199 p_old_STATE_CODE in VARCHAR2,
200 p_new_STATE_CODE in VARCHAR2 ,
201 p_old_WITHHOLDING_ALLOWANCES in NUMBER,
202 p_new_WITHHOLDING_ALLOWANCES in NUMBER ,
203 p_old_EFFECTIVE_END_DATE in DATE,
204 p_new_EFFECTIVE_END_DATE in DATE ,
205 p_old_EFFECTIVE_START_DATE in DATE,
206 p_new_EFFECTIVE_START_DATE in DATE
207 );
208 --
209 end pay_us_cont_calc;
[Home] [Help]