1 Package pay_ca_emp_fedtax_inf_api as
2 /* $Header: pycatapi.pkh 120.1.12010000.1 2008/07/27 22:17:49 appldev ship $ */
3 /*#
4 * This package contains Federal Tax Information APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Employee Federal Tax Information for Canada
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------< create_ca_emp_fedtax_inf >---------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a Canadian federal tax record for an existing assignment
17 * with a Canadian location.
18 *
19 * the API will only complete successfully if a tax record does not already
20 * exist
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * An assignment with a Canadian location must exist
27 *
28 * <p><b>Post Success</b><br>
29 * Canadian Federal tax information related to an employees assignment will be
30 * sucessfully inserted into the database
31 *
32 * <p><b>Post Failure</b><br>
33 * Tax record will not be created and appropriate error will be raised.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_emp_fed_tax_inf_id If p_validate is false, then this uniquely
38 * identifies the federal tax record created. If p_validate is true, then set
39 * to null.
40 * @param p_effective_start_date Start Date when the tax record is created
41 * @param p_effective_end_date End Date of the tax record created.
42 * @param p_legislation_code must be 'CA'
43 * @param p_assignment_id Assignment Id for which the Tax record is being
44 * created
45 * @param p_business_group_id Business Group of the Record corresponding to the
46 * assignme id
47 * @param p_employment_province to override the work province must be a valid
48 * province code
49 * @param p_tax_credit_amount tax credit amount and basic exempt amount cannot
50 * be both NULL or both NOT NULL.The valid combinations are Basic Exempt = 'Y'
51 * Tax Credit = NULL, Basic Exempt = 'N' Tax credit = some value
52 * @param p_claim_code currently not used
53 * @param p_basic_exemption_flag Mutually exclusive with tax credit amount
54 * @param p_additional_tax The default value is 0
55 * @param p_annual_dedn The default value is 0
56 * @param p_total_expense_by_commission The default value is 0
57 * @param p_total_remnrtn_by_commission The default value is 0
58 * @param p_prescribed_zone_dedn_amt The default value is 0
59 * @param p_other_fedtax_credits The default value is 0
60 * @param p_cpp_qpp_exempt_flag If it is selected as 'Y' then the employee will
61 * be exempt from CPP/QPP tax.If it is selected as 'N' then the employee will
62 * not be exempt from CPP/QPP tax.
63 * @param p_fed_exempt_flag If it is selected as 'Y' then the employee will be
64 * exempt from Federal tax.If it is selected as 'N' then the employee will not
65 * be exempt from Federal tax.
66 * @param p_ei_exempt_flag If it is selected as 'Y' then the employee will be
67 * exempt from Employment insurance tax.If it is selected as 'N' then the
68 * employee will not be exempt from Employment insurance tax.
69 * @param p_tax_calc_method Must be a valid tax calculation method , which is
70 * the lookup codes for lookup type 'CA_TAX_CALC_METHOD'
71 * @param p_fed_override_amount Default value = 0
72 * @param p_fed_override_rate Default value = 0
73 * @param p_ca_tax_information_category {@rep:casecolumn
74 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION_CATEGORY}
75 * @param p_ca_tax_information1 {@rep:casecolumn
76 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION1}
77 * @param p_ca_tax_information2 {@rep:casecolumn
78 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION2}
79 * @param p_ca_tax_information3 {@rep:casecolumn
80 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION3}
81 * @param p_ca_tax_information4 {@rep:casecolumn
82 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION4}
83 * @param p_ca_tax_information5 {@rep:casecolumn
84 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION5}
85 * @param p_ca_tax_information6 {@rep:casecolumn
86 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION6}
87 * @param p_ca_tax_information7 {@rep:casecolumn
88 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION7}
89 * @param p_ca_tax_information8 {@rep:casecolumn
90 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION8}
91 * @param p_ca_tax_information9 {@rep:casecolumn
92 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION9}
93 * @param p_ca_tax_information10 {@rep:casecolumn
94 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION10}
95 * @param p_ca_tax_information11 {@rep:casecolumn
96 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION11}
97 * @param p_ca_tax_information12 {@rep:casecolumn
98 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION12}
99 * @param p_ca_tax_information13 {@rep:casecolumn
100 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION13}
101 * @param p_ca_tax_information14 {@rep:casecolumn
102 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION14}
103 * @param p_ca_tax_information15 {@rep:casecolumn
104 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION15}
105 * @param p_ca_tax_information16 {@rep:casecolumn
106 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION16}
107 * @param p_ca_tax_information17 {@rep:casecolumn
108 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION17}
109 * @param p_ca_tax_information18 {@rep:casecolumn
110 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION18}
111 * @param p_ca_tax_information19 {@rep:casecolumn
112 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION19}
113 * @param p_ca_tax_information20 {@rep:casecolumn
114 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION20}
115 * @param p_ca_tax_information21 {@rep:casecolumn
116 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION21}
117 * @param p_ca_tax_information22 {@rep:casecolumn
118 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION22}
119 * @param p_ca_tax_information23 {@rep:casecolumn
120 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION23}
121 * @param p_ca_tax_information24 {@rep:casecolumn
122 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION24}
123 * @param p_ca_tax_information25 {@rep:casecolumn
124 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION25}
125 * @param p_ca_tax_information26 {@rep:casecolumn
126 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION26}
127 * @param p_ca_tax_information27 {@rep:casecolumn
128 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION27}
129 * @param p_ca_tax_information28 {@rep:casecolumn
130 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION28}
131 * @param p_ca_tax_information29 {@rep:casecolumn
132 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION29}
133 * @param p_ca_tax_information30 {@rep:casecolumn
134 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION30}
135 * @param p_object_version_number Object Version Number for the Tax record
136 * created
137 * @param p_fed_lsf_amount Default value = 0
138 * @param p_effective_date Date when the tax record is created
139 * @rep:displayname Create Employee Federal Tax Information for Canada
140 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
141 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
142 * @rep:scope public
143 * @rep:lifecycle active
144 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
145 */
146 --
147 -- {End Of Comments}
148 --
149 procedure create_ca_emp_fedtax_inf
150 (
151 p_validate in boolean default false
152 ,p_emp_fed_tax_inf_id out nocopy number
153 ,p_effective_start_date out nocopy date
154 ,p_effective_end_date out nocopy date
155 ,p_legislation_code in varchar2 default null
156 ,p_assignment_id in number default null
157 ,p_business_group_id in number default null
158 ,p_employment_province in varchar2 default null
159 ,p_tax_credit_amount in number default null
160 ,p_claim_code in varchar2 default null
161 ,p_basic_exemption_flag in varchar2 default null
162 ,p_additional_tax in number default null
163 ,p_annual_dedn in number default null
164 ,p_total_expense_by_commission in number default null
165 ,p_total_remnrtn_by_commission in number default null
166 ,p_prescribed_zone_dedn_amt in number default null
167 ,p_other_fedtax_credits in varchar2 default null
168 ,p_cpp_qpp_exempt_flag in varchar2 default null
169 ,p_fed_exempt_flag in varchar2 default null
170 ,p_ei_exempt_flag in varchar2 default null
171 ,p_tax_calc_method in varchar2 default null
172 ,p_fed_override_amount in number default null
173 ,p_fed_override_rate in number default null
174 ,p_ca_tax_information_category in varchar2 default null
175 ,p_ca_tax_information1 in varchar2 default null
176 ,p_ca_tax_information2 in varchar2 default null
177 ,p_ca_tax_information3 in varchar2 default null
178 ,p_ca_tax_information4 in varchar2 default null
179 ,p_ca_tax_information5 in varchar2 default null
180 ,p_ca_tax_information6 in varchar2 default null
181 ,p_ca_tax_information7 in varchar2 default null
182 ,p_ca_tax_information8 in varchar2 default null
183 ,p_ca_tax_information9 in varchar2 default null
184 ,p_ca_tax_information10 in varchar2 default null
185 ,p_ca_tax_information11 in varchar2 default null
186 ,p_ca_tax_information12 in varchar2 default null
187 ,p_ca_tax_information13 in varchar2 default null
188 ,p_ca_tax_information14 in varchar2 default null
189 ,p_ca_tax_information15 in varchar2 default null
190 ,p_ca_tax_information16 in varchar2 default null
191 ,p_ca_tax_information17 in varchar2 default null
192 ,p_ca_tax_information18 in varchar2 default null
193 ,p_ca_tax_information19 in varchar2 default null
194 ,p_ca_tax_information20 in varchar2 default null
195 ,p_ca_tax_information21 in varchar2 default null
196 ,p_ca_tax_information22 in varchar2 default null
197 ,p_ca_tax_information23 in varchar2 default null
198 ,p_ca_tax_information24 in varchar2 default null
199 ,p_ca_tax_information25 in varchar2 default null
200 ,p_ca_tax_information26 in varchar2 default null
201 ,p_ca_tax_information27 in varchar2 default null
202 ,p_ca_tax_information28 in varchar2 default null
203 ,p_ca_tax_information29 in varchar2 default null
204 ,p_ca_tax_information30 in varchar2 default null
205 ,p_object_version_number out nocopy number
206 ,p_fed_lsf_amount in number default null
207 ,p_effective_date in date
208 );
209 --
210 -- ----------------------------------------------------------------------------
211 -- |-------------------------< update_ca_emp_fedtax_inf >---------------------|
212 -- ----------------------------------------------------------------------------
213 --
214 -- {Start Of Comments}
215 /*#
216 * This API updates an existing Canadian federal tax record.
217 *
218 *
219 * <p><b>Licensing</b><br>
220 * This API is licensed for use with Human Resources.
221 *
222 * <p><b>Prerequisites</b><br>
223 * The assignment,business group id should exist in canadian legislation.
224 *
225 * <p><b>Post Success</b><br>
226 * The Federal tax record will be created
227 *
228 * <p><b>Post Failure</b><br>
229 * The Federal tax record will not be created and an error will be raised.
230 * @param p_validate If true, then validation alone will be performed and the
231 * database will remain unchanged. If false and all validation checks pass,
232 * then the database will be modified.
233 * @param p_emp_fed_tax_inf_id PK of record
234 * @param p_effective_start_date Start Date when the tax record is updated
235 * @param p_effective_end_date End Date when the tax record is updated
236 * @param p_legislation_code must be 'CA'
237 * @param p_assignment_id Assignment Id for which the Tax record is being
238 * updated
239 * @param p_business_group_id {@rep:casecolumn
240 * PAY_CA_EMP_FED_TAX_INFO_F.BUSINESS_GROUP_ID}
241 * @param p_employment_province {@rep:casecolumn
242 * PAY_CA_EMP_FED_TAX_INFO_F.EMPLOYMENT_PROVINCE}
243 * @param p_tax_credit_amount {@rep:casecolumn
244 * PAY_CA_EMP_FED_TAX_INFO_F.TAX_CREDIT_AMOUNT}
245 * @param p_claim_code {@rep:casecolumn PAY_CA_EMP_FED_TAX_INFO_F.CLAIM_CODE}
246 * @param p_basic_exemption_flag {@rep:casecolumn
247 * PAY_CA_EMP_FED_TAX_INFO_F.BASIC_EXEMPTION_FLAG}
248 * @param p_additional_tax {@rep:casecolumn
249 * PAY_CA_EMP_FED_TAX_INFO_F.ADDITIONAL_TAX}
250 * @param p_annual_dedn {@rep:casecolumn PAY_CA_EMP_FED_TAX_INFO_F.ANNUAL_DEDN}
251 * @param p_total_expense_by_commission {@rep:casecolumn
252 * PAY_CA_EMP_FED_TAX_INFO_F.TOTAL_EXPENSE_BY_COMMISSION}
253 * @param p_total_remnrtn_by_commission {@rep:casecolumn
254 * PAY_CA_EMP_FED_TAX_INFO_F.TOTAL_REMNRTN_BY_COMMISSION}
255 * @param p_prescribed_zone_dedn_amt {@rep:casecolumn
256 * PAY_CA_EMP_FED_TAX_INFO_F.PRESCRIBED_ZONE_DEDN_AMT}
257 * @param p_other_fedtax_credits {@rep:casecolumn
258 * PAY_CA_EMP_FED_TAX_INFO_F.OTHER_FEDTAX_CREDITS}
259 * @param p_cpp_qpp_exempt_flag {@rep:casecolumn
260 * PAY_CA_EMP_FED_TAX_INFO_F.CPP_QPP_EXEMPT_FLAG}
261 * @param p_fed_exempt_flag {@rep:casecolumn
262 * PAY_CA_EMP_FED_TAX_INFO_F.FED_EXEMPT_FLAG}
263 * @param p_ei_exempt_flag {@rep:casecolumn
264 * PAY_CA_EMP_FED_TAX_INFO_F.EI_EXEMPT_FLAG}
265 * @param p_tax_calc_method {@rep:casecolumn
266 * PAY_CA_EMP_FED_TAX_INFO_F.TAX_CALC_METHOD}
267 * @param p_fed_override_amount {@rep:casecolumn
268 * PAY_CA_EMP_FED_TAX_INFO_F.FED_OVERRIDE_AMOUNT}
269 * @param p_fed_override_rate {@rep:casecolumn
270 * PAY_CA_EMP_FED_TAX_INFO_F.FED_OVERRIDE_RATE}
271 * @param p_ca_tax_information_category {@rep:casecolumn
272 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION_CATEGORY}
273 * @param p_ca_tax_information1 {@rep:casecolumn
274 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION1}
275 * @param p_ca_tax_information2 {@rep:casecolumn
276 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION2}
277 * @param p_ca_tax_information3 {@rep:casecolumn
278 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION3}
279 * @param p_ca_tax_information4 {@rep:casecolumn
280 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION4}
281 * @param p_ca_tax_information5 {@rep:casecolumn
282 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION5}
283 * @param p_ca_tax_information6 {@rep:casecolumn
284 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION6}
285 * @param p_ca_tax_information7 {@rep:casecolumn
286 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION7}
287 * @param p_ca_tax_information8 {@rep:casecolumn
288 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION8}
289 * @param p_ca_tax_information9 {@rep:casecolumn
290 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION9}
291 * @param p_ca_tax_information10 {@rep:casecolumn
292 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION10}
293 * @param p_ca_tax_information11 {@rep:casecolumn
294 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION11}
295 * @param p_ca_tax_information12 {@rep:casecolumn
296 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION12}
297 * @param p_ca_tax_information13 {@rep:casecolumn
298 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION13}
299 * @param p_ca_tax_information14 {@rep:casecolumn
300 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION14}
301 * @param p_ca_tax_information15 {@rep:casecolumn
302 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION15}
303 * @param p_ca_tax_information16 {@rep:casecolumn
304 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION16}
305 * @param p_ca_tax_information17 {@rep:casecolumn
306 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION17}
307 * @param p_ca_tax_information18 {@rep:casecolumn
308 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION18}
309 * @param p_ca_tax_information19 {@rep:casecolumn
310 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION19}
311 * @param p_ca_tax_information20 {@rep:casecolumn
312 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION20}
313 * @param p_ca_tax_information21 {@rep:casecolumn
314 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION21}
315 * @param p_ca_tax_information22 {@rep:casecolumn
316 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION22}
317 * @param p_ca_tax_information23 {@rep:casecolumn
321 * @param p_ca_tax_information25 {@rep:casecolumn
318 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION23}
319 * @param p_ca_tax_information24 {@rep:casecolumn
320 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION24}
322 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION25}
323 * @param p_ca_tax_information26 {@rep:casecolumn
324 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION26}
325 * @param p_ca_tax_information27 {@rep:casecolumn
326 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION27}
327 * @param p_ca_tax_information28 {@rep:casecolumn
328 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION28}
329 * @param p_ca_tax_information29 {@rep:casecolumn
330 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION29}
331 * @param p_ca_tax_information30 {@rep:casecolumn
332 * PAY_CA_EMP_FED_TAX_INFO_F.CA_TAX_INFORMATION30}
333 * @param p_object_version_number Object Version Number for the Tax record
334 * updated
335 * @param p_fed_lsf_amount Indicates the Federal labour sponsored funds amount.
336 * @param p_effective_date Effective date of the Tax Record updated
337 * @param p_datetrack_mode Datetrack mode of the record being updated
338 * @rep:displayname Update Employee Federal Tax Information for Canada
339 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
340 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
341 * @rep:scope public
342 * @rep:lifecycle active
343 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
344 */
345 --
346 -- {End Of Comments}
347 --
348 procedure update_ca_emp_fedtax_inf
349 (
350 p_validate in boolean default false
351 ,p_emp_fed_tax_inf_id in number
352 ,p_effective_start_date out nocopy date
353 ,p_effective_end_date out nocopy date
354 ,p_legislation_code in varchar2 default hr_api.g_varchar2
355 ,p_assignment_id in number default hr_api.g_number
356 ,p_business_group_id in number default hr_api.g_number
357 ,p_employment_province in varchar2 default hr_api.g_varchar2
358 ,p_tax_credit_amount in number default hr_api.g_number
359 ,p_claim_code in varchar2 default hr_api.g_varchar2
360 ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
361 ,p_additional_tax in number default hr_api.g_number
362 ,p_annual_dedn in number default hr_api.g_number
363 ,p_total_expense_by_commission in number default hr_api.g_number
364 ,p_total_remnrtn_by_commission in number default hr_api.g_number
365 ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
366 ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
367 ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
368 ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
369 ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
370 ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
371 ,p_fed_override_amount in number default hr_api.g_number
372 ,p_fed_override_rate in number default hr_api.g_number
373 ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
374 ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
375 ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
376 ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
377 ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
378 ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
379 ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
380 ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
381 ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
382 ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
383 ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
384 ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
385 ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
386 ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
387 ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
388 ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
389 ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
390 ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
391 ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
392 ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
393 ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
394 ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
395 ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
396 ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
397 ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
398 ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
399 ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
400 ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
401 ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
402 ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
403 ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
404 ,p_object_version_number in out nocopy number
408 );
405 ,p_fed_lsf_amount in number default hr_api.g_number
406 ,p_effective_date in date
407 ,p_datetrack_mode in varchar2
409 --
410 -- ----------------------------------------------------------------------------
411 -- |-------------------------< delete_ca_emp_fedtax_inf >---------------------|
412 -- ----------------------------------------------------------------------------
413 --
414 -- {Start Of Comments}
415 /*#
416 * This API deletes an existing Canadian federal tax record.
417 *
418 * associated with a Canadian employee assignment
419 *
420 * <p><b>Licensing</b><br>
421 * This API is licensed for use with Human Resources.
422 *
423 * <p><b>Prerequisites</b><br>
424 * A Canadian Federal tax record must exist
425 *
426 * <p><b>Post Success</b><br>
427 * Canadian Federal tax information related to an employees assignment is
428 * sucessfully deleted
429 *
430 * <p><b>Post Failure</b><br>
431 * No Federal tax records are deleted
432 * @param p_validate If true, then validation alone will be performed and the
433 * database will remain unchanged. If false and all validation checks pass,
434 * then the database will be modified.
435 * @param p_emp_fed_tax_inf_id PK of record
436 * @param p_effective_start_date If p_validate is false, then set to the
437 * effective start date for the deleted employee federal tax information row
438 * which now exists as of the effective date. If p_validate is true or all row
439 * instances have been deleted then set to null
440 * @param p_effective_end_date If p_validate is false, then set to the
441 * effective end date for the deleted employee federal tax information row
442 * which now exists as of the effective date. If p_validate is true or all row
443 * instances have been deleted then set to null
444 * @param p_object_version_number Current version number of the employee
445 * federal tax information to be deleted
446 * @param p_effective_date Effective date of the Tax Record deleted
447 * @param p_datetrack_mode Datetrack mode of the record being deleted
448 * @rep:displayname Delete Employee Federal Tax Information for Canada
449 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
450 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
451 * @rep:scope public
452 * @rep:lifecycle active
453 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
454 */
455 --
456 -- {End Of Comments}
457 --
458 procedure delete_ca_emp_fedtax_inf
459 (
460 p_validate in boolean default false
461 ,p_emp_fed_tax_inf_id in number
462 ,p_effective_start_date out nocopy date
463 ,p_effective_end_date out nocopy date
464 ,p_object_version_number in out nocopy number
465 ,p_effective_date in date
466 ,p_datetrack_mode in varchar2
467 );
468 --
469 -- ----------------------------------------------------------------------------
470 -- |----------------------------------< lck >---------------------------------|
471 -- ----------------------------------------------------------------------------
472 -- {Start Of Comments}
473 --
474 -- Description:
475 --
476 -- Prerequisites:
477 --
478 --
479 -- In Parameters:
480 -- Name Reqd Type Description
481 -- p_emp_fed_tax_inf_id Yes number PK of record
482 -- p_object_version_number Yes number OVN of record
483 -- p_effective_date Yes date Session Date.
484 -- p_datetrack_mode Yes varchar2 Datetrack mode.
485 --
486 -- Post Success:
487 --
488 -- Name Type Description
489 -- p_validation_start_date Yes Derived Effective Start Date.
490 -- p_validation_end_date Yes Derived Effective End Date.
491 --
492 -- Post Failure:
493 --
494 -- Access Status:
495 -- Public.
496 --
497 -- {End Of Comments}
498 --
499 procedure lck
500 (
501 p_emp_fed_tax_inf_id in number
502 ,p_object_version_number in number
503 ,p_effective_date in date
504 ,p_datetrack_mode in varchar2
505 ,p_validation_start_date out nocopy date
506 ,p_validation_end_date out nocopy date
507 );
508 --
509 procedure pull_tax_records( p_assignment_id in number,
510 p_new_start_date in date,
511 p_default_date in date);
512
513 procedure check_hiring_date( p_assignment_id in number,
514 p_default_date in date,
515 p_s_start_date in date);
516
517 procedure tax_record_already_present(p_assignment_id in number,
518 p_effective_date in date,
519 p_rec_present out nocopy varchar2) ;
520
521 procedure perform_assignment_validation(p_assignment_id in varchar2,
522 p_effective_date in date);
523
524 procedure check_basic_exemption(p_basic_exemption_flag in varchar2,
525 p_tax_credit_amount in number) ;
526
527 procedure check_employment_province(p_employment_province in varchar2) ;
528
529 function convert_null_to_zero(p_value in number) return number;
530 end pay_ca_emp_fedtax_inf_api;
531
[Home] [Help]