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.
PACKAGE: APPS.PAY_CA_CONT_CALC

Source


1 package pay_ca_cont_calc AUTHID CURRENT_USER as
2 /* $Header: pycacoc.pkh 120.0 2005/05/29 01:57:30 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 --
18 procedure PAY_CA_EMP_FED_TAX_INFO_F_aru(
19 p_business_group_id in number,
20 p_legislation_code in varchar2,
21 p_effective_date in date ,
22 p_old_ADDITIONAL_TAX in NUMBER,
23 p_new_ADDITIONAL_TAX in NUMBER ,
24 p_old_ANNUAL_DEDN in NUMBER,
25 p_new_ANNUAL_DEDN in NUMBER ,
26 p_old_ASSIGNMENT_ID in NUMBER,
27 p_new_ASSIGNMENT_ID in NUMBER ,
28 p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
29 p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
30 p_old_BUSINESS_GROUP_ID in NUMBER,
31 p_new_BUSINESS_GROUP_ID in NUMBER ,
32 p_old_CA_TAX_INFORMATION1 in VARCHAR2,
33 p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
34 p_old_CA_TAX_INFORMATION10 in VARCHAR2,
35 p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
36 p_old_CA_TAX_INFORMATION11 in VARCHAR2,
37 p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
38 p_old_CA_TAX_INFORMATION12 in VARCHAR2,
39 p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
40 p_old_CA_TAX_INFORMATION13 in VARCHAR2,
41 p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
42 p_old_CA_TAX_INFORMATION14 in VARCHAR2,
43 p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
44 p_old_CA_TAX_INFORMATION15 in VARCHAR2,
45 p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
46 p_old_CA_TAX_INFORMATION16 in VARCHAR2,
47 p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
48 p_old_CA_TAX_INFORMATION17 in VARCHAR2,
49 p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
50 p_old_CA_TAX_INFORMATION18 in VARCHAR2,
51 p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
52 p_old_CA_TAX_INFORMATION19 in VARCHAR2,
53 p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
54 p_old_CA_TAX_INFORMATION2 in VARCHAR2,
55 p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
56 p_old_CA_TAX_INFORMATION20 in VARCHAR2,
57 p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
58 p_old_CA_TAX_INFORMATION21 in VARCHAR2,
59 p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
60 p_old_CA_TAX_INFORMATION22 in VARCHAR2,
61 p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
62 p_old_CA_TAX_INFORMATION23 in VARCHAR2,
63 p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
64 p_old_CA_TAX_INFORMATION24 in VARCHAR2,
65 p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
66 p_old_CA_TAX_INFORMATION25 in VARCHAR2,
67 p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
68 p_old_CA_TAX_INFORMATION26 in VARCHAR2,
69 p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
70 p_old_CA_TAX_INFORMATION27 in VARCHAR2,
71 p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
72 p_old_CA_TAX_INFORMATION28 in VARCHAR2,
73 p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
74 p_old_CA_TAX_INFORMATION29 in VARCHAR2,
75 p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
76 p_old_CA_TAX_INFORMATION3 in VARCHAR2,
77 p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
78 p_old_CA_TAX_INFORMATION30 in VARCHAR2,
79 p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
80 p_old_CA_TAX_INFORMATION4 in VARCHAR2,
81 p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
82 p_old_CA_TAX_INFORMATION5 in VARCHAR2,
83 p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
84 p_old_CA_TAX_INFORMATION6 in VARCHAR2,
85 p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
86 p_old_CA_TAX_INFORMATION7 in VARCHAR2,
87 p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
88 p_old_CA_TAX_INFORMATION8 in VARCHAR2,
89 p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
90 p_old_CA_TAX_INFORMATION9 in VARCHAR2,
91 p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
92 p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
93 p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
94 p_old_CLAIM_CODE in VARCHAR2,
95 p_new_CLAIM_CODE in VARCHAR2 ,
96 p_old_CPP_QPP_EXEMPT_FLAG in VARCHAR2,
97 p_new_CPP_QPP_EXEMPT_FLAG in VARCHAR2 ,
98 p_old_EI_EXEMPT_FLAG in VARCHAR2,
99 p_new_EI_EXEMPT_FLAG in VARCHAR2 ,
100 p_old_EMPLOYMENT_PROVINCE in VARCHAR2,
101 p_new_EMPLOYMENT_PROVINCE in VARCHAR2 ,
102 p_old_EMP_FED_TAX_INF_ID in NUMBER,
103 p_new_EMP_FED_TAX_INF_ID in NUMBER ,
104 p_old_FED_EXEMPT_FLAG in VARCHAR2,
105 p_new_FED_EXEMPT_FLAG in VARCHAR2 ,
106 p_old_FED_OVERRIDE_AMOUNT in NUMBER,
107 p_new_FED_OVERRIDE_AMOUNT in NUMBER ,
108 p_old_FED_OVERRIDE_RATE in NUMBER,
109 p_new_FED_OVERRIDE_RATE in NUMBER ,
110 p_old_LEGISLATION_CODE in VARCHAR2,
111 p_new_LEGISLATION_CODE in VARCHAR2 ,
112 p_old_OTHER_FEDTAX_CREDITS in NUMBER,
113 p_new_OTHER_FEDTAX_CREDITS in NUMBER ,
114 p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
115 p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
116 p_old_TAX_CALC_METHOD in VARCHAR2,
117 p_new_TAX_CALC_METHOD in VARCHAR2 ,
118 p_old_TAX_CREDIT_AMOUNT in NUMBER,
119 p_new_TAX_CREDIT_AMOUNT in NUMBER ,
120 p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
121 p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
122 p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
123 p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
124 p_old_EFFECTIVE_END_DATE in DATE,
125 p_new_EFFECTIVE_END_DATE in DATE ,
126 p_old_EFFECTIVE_START_DATE in DATE,
127 p_new_EFFECTIVE_START_DATE in DATE
128 );
129 --
130 procedure PAY_CA_EMP_PROV_TAX_INFO_F_aru(
131 p_business_group_id in number,
132 p_legislation_code in varchar2,
133 p_effective_date in date ,
134 p_old_ADDITIONAL_TAX in NUMBER,
135 p_new_ADDITIONAL_TAX in NUMBER ,
136 p_old_ANNUAL_DEDN in NUMBER,
137 p_new_ANNUAL_DEDN in NUMBER ,
138 p_old_ASSIGNMENT_ID in NUMBER,
139 p_new_ASSIGNMENT_ID in NUMBER ,
140 p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
141 p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
142 p_old_BUSINESS_GROUP_ID in NUMBER,
143 p_new_BUSINESS_GROUP_ID in NUMBER ,
144 p_old_CA_TAX_INFORMATION1 in VARCHAR2,
145 p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
146 p_old_CA_TAX_INFORMATION10 in VARCHAR2,
147 p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
148 p_old_CA_TAX_INFORMATION11 in VARCHAR2,
149 p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
150 p_old_CA_TAX_INFORMATION12 in VARCHAR2,
151 p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
152 p_old_CA_TAX_INFORMATION13 in VARCHAR2,
153 p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
154 p_old_CA_TAX_INFORMATION14 in VARCHAR2,
155 p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
156 p_old_CA_TAX_INFORMATION15 in VARCHAR2,
157 p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
158 p_old_CA_TAX_INFORMATION16 in VARCHAR2,
159 p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
160 p_old_CA_TAX_INFORMATION17 in VARCHAR2,
161 p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
162 p_old_CA_TAX_INFORMATION18 in VARCHAR2,
163 p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
164 p_old_CA_TAX_INFORMATION19 in VARCHAR2,
165 p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
166 p_old_CA_TAX_INFORMATION2 in VARCHAR2,
167 p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
168 p_old_CA_TAX_INFORMATION20 in VARCHAR2,
169 p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
170 p_old_CA_TAX_INFORMATION21 in VARCHAR2,
171 p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
172 p_old_CA_TAX_INFORMATION22 in VARCHAR2,
173 p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
174 p_old_CA_TAX_INFORMATION23 in VARCHAR2,
175 p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
176 p_old_CA_TAX_INFORMATION24 in VARCHAR2,
177 p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
178 p_old_CA_TAX_INFORMATION25 in VARCHAR2,
179 p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
180 p_old_CA_TAX_INFORMATION26 in VARCHAR2,
181 p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
182 p_old_CA_TAX_INFORMATION27 in VARCHAR2,
183 p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
184 p_old_CA_TAX_INFORMATION28 in VARCHAR2,
185 p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
186 p_old_CA_TAX_INFORMATION29 in VARCHAR2,
187 p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
188 p_old_CA_TAX_INFORMATION3 in VARCHAR2,
189 p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
190 p_old_CA_TAX_INFORMATION30 in VARCHAR2,
191 p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
192 p_old_CA_TAX_INFORMATION4 in VARCHAR2,
193 p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
194 p_old_CA_TAX_INFORMATION5 in VARCHAR2,
195 p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
196 p_old_CA_TAX_INFORMATION6 in VARCHAR2,
197 p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
198 p_old_CA_TAX_INFORMATION7 in VARCHAR2,
199 p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
200 p_old_CA_TAX_INFORMATION8 in VARCHAR2,
201 p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
202 p_old_CA_TAX_INFORMATION9 in VARCHAR2,
203 p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
204 p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
205 p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
206 p_old_DEDUCTION_CODE in VARCHAR2,
207 p_new_DEDUCTION_CODE in VARCHAR2 ,
208 p_old_DISABILITY_STATUS in VARCHAR2,
209 p_new_DISABILITY_STATUS in VARCHAR2 ,
210 p_old_EMP_PROVINCE_TAX_INF_ID in NUMBER,
211 p_new_EMP_PROVINCE_TAX_INF_ID in NUMBER ,
212 p_old_EXTRA_INFO_NOT_PROVIDED in VARCHAR2,
213 p_new_EXTRA_INFO_NOT_PROVIDED in VARCHAR2 ,
214 p_old_JURISDICTION_CODE in VARCHAR2,
215 p_new_JURISDICTION_CODE in VARCHAR2 ,
216 p_old_LEGISLATION_CODE in VARCHAR2,
217 p_new_LEGISLATION_CODE in VARCHAR2 ,
218 p_old_MARRIAGE_STATUS in VARCHAR2,
219 p_new_MARRIAGE_STATUS in VARCHAR2 ,
220 p_old_NON_RESIDENT_STATUS in VARCHAR2,
221 p_new_NON_RESIDENT_STATUS in VARCHAR2 ,
222 p_old_NO_OF_DEPENDANTS in NUMBER,
223 p_new_NO_OF_DEPENDANTS in NUMBER ,
224 p_old_NO_OF_INFIRM_DEPENDANTS in NUMBER,
225 p_new_NO_OF_INFIRM_DEPENDANTS in NUMBER ,
226 p_old_OTHER_TAX_CREDIT in NUMBER,
227 p_new_OTHER_TAX_CREDIT in NUMBER ,
228 p_old_PMED_EXEMPT_FLAG in VARCHAR2,
229 p_new_PMED_EXEMPT_FLAG in VARCHAR2 ,
230 p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
231 p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
232 p_old_PROVINCE_CODE in VARCHAR2,
233 p_new_PROVINCE_CODE in VARCHAR2 ,
234 p_old_PROV_EXEMPT_FLAG in VARCHAR2,
235 p_new_PROV_EXEMPT_FLAG in VARCHAR2 ,
236 p_old_PROV_OVERRIDE_AMOUNT in NUMBER,
237 p_new_PROV_OVERRIDE_AMOUNT in NUMBER ,
238 p_old_PROV_OVERRIDE_RATE in NUMBER,
239 p_new_PROV_OVERRIDE_RATE in NUMBER ,
240 p_old_QPP_EXEMPT_FLAG in VARCHAR2,
241 p_new_QPP_EXEMPT_FLAG in VARCHAR2 ,
242 p_old_TAX_CALC_METHOD in VARCHAR2,
243 p_new_TAX_CALC_METHOD in VARCHAR2 ,
244 p_old_TAX_CREDIT_AMOUNT in NUMBER,
245 p_new_TAX_CREDIT_AMOUNT in NUMBER ,
246 p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
247 p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
248 p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
249 p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
250 p_old_WC_EXEMPT_FLAG in VARCHAR2,
251 p_new_WC_EXEMPT_FLAG in VARCHAR2 ,
252 p_old_EFFECTIVE_END_DATE in DATE,
253 p_new_EFFECTIVE_END_DATE in DATE ,
254 p_old_EFFECTIVE_START_DATE in DATE,
255 p_new_EFFECTIVE_START_DATE in DATE
256 );
257 --
258 end pay_ca_cont_calc;