[Home] [Help]
PACKAGE: APPS.PAY_KR_YEA_PKG
Source
1 package pay_kr_yea_pkg AUTHID CURRENT_USER as
2 /* $Header: pykryea.pkh 120.33.12020000.6 2012/12/20 17:32:43 mdubasi ship $ */
3 ------------------------------------------------------------------------
4 type t_number_tbl is table of number index by binary_integer;
5 type t_varchar2_tbl is table of varchar2(255) index by binary_integer;
6 type t_date_tbl is table of date index by binary_integer;
7 ------------------------------------------------------------------------
8 type t_yea_info is record(
9 non_resident_flag varchar2(1) default 'N',
10 -- Bug 6615356
11 foreign_residency_flag varchar2(1) default 'N',
12 ------------------------------------------------------------------------
13 -- Bug 3201332 Nationality
14 ------------------------------------------------------------------------
15 nationality varchar2(1) default 'K',
16 -- Bug 3172960
17 fixed_tax_rate varchar2(1) default 'N',
18 ------------------------------------------------------------------------
19 -- Current Employer's Information
20 ------------------------------------------------------------------------
21 cur_taxable_mth number default 0,
22 cur_taxable_bon number default 0,
23 cur_sp_irreg_bonus number default 0,
24 cur_stck_pur_opt_exec_earn number default 0, -- Bug 6012258
25 cur_esop_withd_earn number default 0, -- Bug 8644512
26 cur_taxable number default 0,
27 cur_non_taxable_ovs number default 0, -- Bug 8644512
28 cur_non_taxable_ovt number default 0, -- Bug 8644512
29 cur_birth_raising_allowance number default 0, -- Bug 8644512
30 cur_fw_income_exem number default 0, -- Bug 8644512
31 ------------------------------------------------------------------------
32 -- Previous Employers' Information
33 ------------------------------------------------------------------------
34 prev_hire_date_tbl t_date_tbl, -- Bug 8644512
35 prev_termination_date_tbl t_date_tbl,
36 prev_corp_name_tbl t_varchar2_tbl,
37 prev_bp_number_tbl t_varchar2_tbl,
38 prev_tax_brk_pd_from_tbl t_date_tbl, -- Bug 8644512
39 prev_tax_brk_pd_to_tbl t_date_tbl, -- Bug 8644512
40 prev_taxable_mth_tbl t_number_tbl,
41 prev_taxable_bon_tbl t_number_tbl,
42 prev_sp_irreg_bonus_tbl t_number_tbl,
43 prev_stck_pur_opt_exe_earn_tbl t_number_tbl, -- Bug 6024342
44 prev_esop_withd_earn_tbl t_number_tbl, -- Bug 8644512
45 prev_non_taxable_ovs_tbl t_number_tbl,
46 prev_non_taxable_ovt_tbl t_number_tbl,
47 prev_non_taxable_oth_tbl t_number_tbl,
48 prev_hi_prem_tbl t_number_tbl,
49 prev_ltci_prem_tbl t_number_tbl, -- Bug 7260606
50 prev_ei_prem_tbl t_number_tbl,
51 prev_np_prem_tbl t_number_tbl,
52 prev_pen_prem_tbl t_number_tbl, -- Bug 6024342
53 prev_military_pen_prem_tbl t_number_tbl, -- Bug 9737699
54 prev_pri_school_pen_prem_tbl t_number_tbl, -- Bug 9737699
55 prev_post_office_pen_prem_tbl t_number_tbl, -- Bug 9737699
56 prev_separation_pension_tbl t_number_tbl, -- Bug 7508706
57 prev_itax_tbl t_number_tbl,
58 prev_rtax_tbl t_number_tbl,
59 prev_stax_tbl t_number_tbl,
60 prev_research_payment_tbl t_number_tbl, -- Bug 8341054
61 prev_bir_raising_allowance_tbl t_number_tbl, -- Bug 8341054
62 prev_foreign_wrkr_inc_exem_tbl t_number_tbl, -- Bug 8341054
63 --
64 pledt_asg_info_id_tbl t_number_tbl, -- Bug 9393732
65 pledt_amt_sub_to_exem_tbl t_number_tbl, -- Bug 9393732
66 tlaw_asg_info_id_tbl t_number_tbl, -- Bug 9393732
67 tlaw_amt_sub_to_exem_tbl t_number_tbl, -- Bug 9393732
68 spec_asg_info_id_tbl t_number_tbl, -- Bug 9393732
69 spec_donated_year_tbl t_number_tbl, -- Bug 9393732
70 spec_amt_sub_to_exem_tbl t_number_tbl, -- Bug 9393732
71 stat_asg_info_id_tbl t_number_tbl, -- Bug 9393732
72 stat_amt_sub_to_exem_tbl t_number_tbl, -- Bug 9393732
73 rel_asg_info_id_tbl t_number_tbl, -- Bug 9393732
74 spec_rel_grpby_don_year_tbl t_number_tbl, -- Bug 9393732
75 rel_amt_sub_to_exem_tbl t_number_tbl, -- Bug 9393732
76 rel_donated_year_tbl t_number_tbl,
77 spec_rel_amt_grpby_year_tbl t_number_tbl,
78 rel_amt_exem_grpby_year_tbl t_number_tbl,
79 new_donation_calc_flag varchar2(1) default 'Y',
80 don_priority_flag varchar2(1) default 'Y',
81 rel_grpby_don_year_tbl t_number_tbl,
82 spec_don_year_tbl t_number_tbl,
83 spec_rel_asg_info_id_tbl t_number_tbl,
84 spec_rel_donated_year_tbl t_number_tbl,
85 spec_rel_don_code_tbl t_varchar2_tbl,
86 spec_rel_max_exem_amt t_number_tbl,
87 spec_rel_amt_sub_to_exem_tbl t_number_tbl,
88 pledt_donated_year_tbl t_number_tbl, -- Bug 9393732
89 tlaw_donated_year_tbl t_number_tbl, -- Bug 9393732
90 stat_donated_year_tbl t_number_tbl, -- Bug 9393732
91 create_don_rec_flag varchar2(1) default 'Y', -- Bug 9393732
92 --
93 -- Bug 9737699
94 sep_pen_priority_tbl t_number_tbl,
95 sep_pen_fin_institute_tbl t_varchar2_tbl,
96 sep_pen_acc_number_tbl t_varchar2_tbl,
97 sep_pen_cont_amount_tbl t_number_tbl,
98 sep_pen_type_tbl t_number_tbl,
99 sep_pen_exem_amount_tbl t_number_tbl,
100 pen_saving_priority_tbl t_number_tbl,
101 pen_saving_fin_institute_tbl t_varchar2_tbl,
102 pen_saving_acc_number_tbl t_varchar2_tbl,
103 pen_saving_cont_amount_tbl t_number_tbl,
104 pen_saving_type_tbl t_number_tbl,
105 pen_saving_exem_amount_tbl t_number_tbl,
106 hou_saving_priority_tbl t_number_tbl,
107 hou_saving_fin_institute_tbl t_varchar2_tbl,
108 hou_saving_acc_number_tbl t_varchar2_tbl,
109 hou_saving_cont_amount_tbl t_number_tbl,
110 hou_saving_type_tbl t_varchar2_tbl,
111 hou_saving_exem_amount_tbl t_number_tbl,
112 lt_stck_saving_priority_tbl t_number_tbl,
113 lt_stck_saving_fin_inst_tbl t_varchar2_tbl,
114 lt_stck_saving_acc_number_tbl t_varchar2_tbl,
115 lt_stck_saving_cont_amt_tbl t_number_tbl,
116 lt_stck_saving_type_tbl t_number_tbl,
117 lt_stck_saving_exem_amt_tbl t_number_tbl,
118 --
119 prev_taxable_mth number default 0,
120 prev_taxable_bon number default 0,
121 prev_sp_irreg_bonus number default 0,
122 prev_stck_pur_opt_exec_earn number default 0, -- Bug 6024342
123 prev_esop_withd_earn number default 0, -- Bug 8644512
124 prev_birth_raising_allowance number default 0, -- Bug 8644512
125 prev_non_taxable_ovt number default 0, -- Bug 8644512
126 prev_taxable number default 0,
127 prev_foreign_wrkr_inc_exem number default 0, -- Bug 8341054
128 ------------------------------------------------------------------------
129 -- Annual Earnings
130 ------------------------------------------------------------------------
131 taxable_mth number default 0,
132 taxable_bon number default 0,
133 sp_irreg_bonus number default 0,
134 -- Bug 6024342
135 stck_pur_opt_exec_earn number default 0,
136 --
137 esop_withd_earn number default 0, -- Bug 8644512
138 -- Bug 6012258
139 research_payment number default 0,
140 --
141 -- Bug 7142620
142 birth_raising_allowance number default 0,
143 --
144 taxable number default 0,
145 taxable1 number default 0, -- Bug 7615517
146 non_taxable_ovs number default 0,
147 non_taxable_ovt number default 0,
148 non_taxable_ovs_frgn number default 0, -- Bug 7439803
149 non_taxable_oth number default 0,
150 non_rep_non_taxable number default 0, -- Bug 9079450
151 non_taxable number default 0,
152 ------------------------------------------------------------------------
153 -- Monthly Regular Earnings -- Bus 3201332
154 ------------------------------------------------------------------------
155 monthly_reg_earning number default 0,
156 ------------------------------------------------------------------------
157 -- Bug 3172960 Foreign Worker Income Exemption
158 ------------------------------------------------------------------------
159 foreign_worker_income_exem number default 0,
160 ------------------------------------------------------------------------
161 -- Basic Income Exemption
162 ------------------------------------------------------------------------
163 basic_income_exem number default 0,
164 ------------------------------------------------------------------------
165 -- Taxable Income
166 ------------------------------------------------------------------------
167 taxable_income number default 0,
168 ------------------------------------------------------------------------
169 -- Employee Tax Exemption
170 ------------------------------------------------------------------------
171 ee_tax_exem number default 0,
172 ------------------------------------------------------------------------
173 -- Dependent Tax Exemption
174 ------------------------------------------------------------------------
175 dpnt_spouse_flag varchar2(1) default 'N',
176 dpnt_spouse_tax_exem number default 0,
177 num_of_aged_dpnts number default 0,
178 num_of_adult_dpnts number default 0,
179 num_of_underaged_dpnts number default 0,
180 num_of_dpnts number default 0,
181 dpnt_tax_exem number default 0,
182 num_of_ageds number default 0,
183 -- Bug 3172960
184 num_of_super_ageds number default 0,
185 --
186 num_of_new_born_adopted number default 0, -- Bug 6705170
187 new_born_adopted_tax_exem number default 0, -- Bug 6705170
188 --
189 single_parent_flag varchar2(1) default 'N', -- Bug 16010775
190 single_parent_tax_exem number default 0, -- Bug 16010775
191 num_of_addtl_child number default 0, -- Bug 6784288
192 --
193 aged_tax_exem number default 0,
194 num_of_disableds number default 0,
195 disabled_tax_exem number default 0,
196 female_ee_flag varchar2(1) default 'N',
197 house_holder_flag varchar2(1) default 'N', -- Bug 9737699
198 house_holder_exception_flag varchar2(1) default 'N', -- Bug 13247926
199 tot_num_dpnts number default 0, -- Bug 9737699
200 female_ee_tax_exem number default 0,
201 num_of_children number default 0,
202 child_tax_exem number default 0,
203 -- Bug 5756690
204 addl_child_tax_exem number default 0,
205 supp_tax_exem number default 0,
206 ------------------------------------------------------------------------
207 -- Insurance Premium Tax Exemption
208 ------------------------------------------------------------------------
209 hi_prem number default 0,
210 hi_prem_tax_exem number default 0,
211 long_term_ins_prem number default 0, -- Bug 7164589
212 long_term_ins_prem_tax_exem number default 0, -- Bug 7164589
213 ei_prem number default 0,
214 ei_prem_tax_exem number default 0,
215 pers_ins_name varchar2(150),
216 pers_ins_prem number default 0,
217 pers_ins_prem_tax_exem number default 0,
218 disabled_ins_prem number default 0,
219 disabled_ins_prem_tax_exem number default 0,
220 ins_prem_tax_exem number default 0,
221 ------------------------------------------------------------------------
222 -- Medical Expense Tax Exemption
223 ------------------------------------------------------------------------
224 med_exp number default 0,
225 med_exp_card_emp number default 0,
226 med_exp_disabled number default 0,
227 med_exp_aged number default 0,
228 -- Bug 3172960
229 med_exp_emp number default 0,
230 max_med_exp_tax_exem number default 0,
231 med_exp_tax_exem number default 0,
232 --
233 -- Bug 3966549
234 reg_med_exp_tax_exem2004 number default 0,
235 add_med_exp_tax_exem2004 number default 0,
236 -- End of 3966549
237 --
238 ------------------------------------------------------------------------
239 -- Education Expense Tax Exemption
240 ------------------------------------------------------------------------
241 ee_educ_exp number default 0,
242 -- Bug 3971542
243 ee_occupation_educ_exp2005 number default 0,
244 -- End of 3971542
245 dpnt_educ_contact_type_tbl t_varchar2_tbl,
246 dpnt_educ_school_type_tbl t_varchar2_tbl,
247 dpnt_educ_exp_tbl t_number_tbl,
248 dpnt_educ_contact_name_tbl t_varchar2_tbl, -- Bug 9079450
249 dpnt_educ_contact_ni_tbl t_varchar2_tbl, -- Bug 9079450
250 spouse_educ_exp number default 0,
251 disabled_educ_exp number default 0,
252 dpnt_educ_exp number default 0,
253 educ_exp_tax_exem number default 0,
254 ------------------------------------------------------------------------
255 -- Bug 3201332 Foreign Worker Special Pre-Tax Deduction
256 ------------------------------------------------------------------------
257 fw_educ_expense number default 0,
258 fw_house_rent number default 0,
259 ------------------------------------------------------------------------
260 -- Housing Expense Tax Exemption
261 ------------------------------------------------------------------------
262 /* Changes for Bug 2523481 */
263 --
264 housing_saving_type_tbl t_varchar2_tbl,
265 housing_saving_tbl t_number_tbl,
269 housing_purchase_date date,
266 housing_saving_type varchar2(30),
267 housing_saving number default 0,
268 --
270 housing_loan_date date,
271 housing_loan_repay number default 0,
272 -- Bug 9393732
273 housing_prv_date_moved date,
274 housing_prv_loan_date date,
275 housing_prv_loan_repay number default 0,
276 --
277 lt_housing_loan_date date,
278 lt_housing_loan_interest_repay number default 0,
279 --
280 lt_housing_loan_date_1 date,
281 lt_housing_loan_intr_repay_1 number default 0,
282 --
283 -- Bug 8237227
284 lt_housing_loan_date_2 date,
285 lt_housing_loan_intr_repay_2 number default 0,
286 lt_2012_fixed_intr_wo_grace number default 0, --14754836
287 lt_2012_housing_other_intr number default 0, --14754836
288 lt_2012_house_fixed_intr_exem number default 0, --14754836
289 lt_2012_house_othr_intr_exem number default 0, --14754836
290 --
291 housing_rent_exp number default 0, -- Bug 9737699
292 housing_rent_exp_tax_exem number default 0, -- Bug 9737699
293 sep_pen_exem_amt1 number default 0, -- Bug 9737699
294 sep_pen_exem_amt_archive varchar2(200), -- Bug 9737699
295 pen_sav_amt_archive varchar2(200), -- Bug 9737699
296 hou_sav_amt_archive varchar2(200), -- Bug 9737699
297 lt_stck_sav_amt_archive varchar2(200), -- Bug 9737699
298 sep_pen_exem_amt2 number default 0, -- Bug 9737699
299 pen_sav_exem_amt1 number default 0, -- Bug 9737699
300 pen_sav_exem_amt2 number default 0, -- Bug 9737699
301 hou_sav_exem_amt1 number default 0, -- Bug 9737699
302 hou_sav_exem_amt2 number default 0, -- Bug 9737699
303 hou_sav_exem_amt3 number default 0, -- Bug 9737699
304 lt_stck_sav_exem_amt1 number default 0, -- Bug 9737699
305 lt_stck_sav_exem_amt2 number default 0, -- Bug 9737699
306 lt_stck_sav_exem_amt3 number default 0, -- Bug 9737699
307 max_housing_exp_tax_exem number default 0,
308 housing_exp_tax_exem number default 0,
309 -- Bug 7142620
310 housing_saving_exem number default 0,
311 housing_loan_repay_exem number default 0,
312 housing_prv_loan_repay_exem number default 0, -- Bug 12807687
313 housing_inst_loan_repay_exem number default 0, --Bug 12807687
314 lt_housing_loan_int_rep_exem1 number default 0, --Bug 12807687
315 lt_housing_loan_int_rep_exem2 number default 0, --Bug 12807687
316 lt_housing_loan_int_rep_exem3 number default 0, --Bug 12807687
317 lt_housing_loan_intr_exem number default 0,
318 -- End of Bug 7142620
319
320 -- Bug 9737699
321 housing_sub_saving_exem number default 0,
322 total_housing_saving_exem number default 0,
323 lt_hou_pro_saving_exem number default 0,
324 emp_hou_pro_saving_exem number default 0,
325 -- End of bug 9737699
326 ------------------------------------------------------------------------
327 -- Donation Tax Exemption (Political and ESOA)
328 ------------------------------------------------------------------------
329 donation1 number default 0,
330 political_donation1 number default 0,
331 political_donation2 number default 0,
332 political_donation3 number default 0,
333 donation1_tax_exem number default 0,
334 donation2 number default 0,
335 donation3 number default 0,
336 donation4 number default 0, -- Bug 7142612
337 religious_donation number default 0, -- Bug 7142612
338 max_donation2_tax_exem number default 0,
339 max_donation3_tax_exem number default 0,
340 donation2_tax_exem number default 0,
341 donation3_tax_exem number default 0,
342 donation_tax_exem number default 0,
343 --
344 -- Bug 3966549
345 esoa_don2004 number default 0,
346 max_esoa_don_tax_exem2004 number default 0,
347 esoa_don_tax_exem2004 number default 0,
348 don_tax_break2004 number default 0,
349 -- End of 3966549
350 --
351 ------------------------------------------------------------------------
352 -- Marriage, Funeral and Relocation Tax Exemption
353 ------------------------------------------------------------------------
354 marriage_exemption varchar2(15),
355 funeral_exemption varchar2(15),
356 relocation_exemption varchar2(15),
357 marr_fun_relo_exemption number default 0,
358 ------------------------------------------------------------------------
359 -- Special Tax Exemption
360 ------------------------------------------------------------------------
361 sp_tax_exem number default 0,
362 std_sp_tax_exem number default 0,
363 ------------------------------------------------------------------------
364 -- National Pension Premium Tax Exemption
365 ------------------------------------------------------------------------
366 np_prem number default 0,
367 np_prem_tax_exem number default 0,
368 ------------------------------------------------------------------------
369 -- Pension Premium
370 ------------------------------------------------------------------------
371 pen_prem number default 0, -- Bug 6024342
372 military_pen_prem number default 0, -- Bug 9737699
373 private_school_pen_prem number default 0, -- Bug 9737699
374 post_office_pen_prem number default 0, -- Bug 9737699
375 ------------------------------------------------------------------------
376 -- Taxable Income2
377 ------------------------------------------------------------------------
378 taxable_income2 number default 0,
379 ------------------------------------------------------------------------
380 -- Tax Exemption
381 ------------------------------------------------------------------------
382 pers_pension_prem number default 0,
383 pers_pension_prem_tax_exem number default 0,
384 -- Bug 4750653
388 -- Bug 9737699
385 corp_pension_prem number default 0,
386 corp_pension_prem_tax_exem number default 0,
387 --
389 scientific_technician_tax_exem number default 0, -- Bug 9737699
390 emp_st_own_plan_cont number default 0,
391 emp_st_own_plan_cont_exem number default 0,
392 pers_pension_saving number default 0,
393 pers_pension_saving_tax_exem number default 0,
394 invest_partner_fin1 number default 0,
395 invest_partner_fin2 number default 0,
396 invest_partner_fin3 number default 0, -- Bug 8237227
397 invest_partner_fin4 number default 0, -- BUG 14219478
398 invest_partner_fin5 number default 0, -- BUG 14219478
399 invest_partner_fin6 number default 0, -- BUG 14219478
400
401 invest_partner_fin_tax_exem number default 0,
402 small_bus_install number default 0, -- Bug 6895093
403 small_bus_install_exem number default 0, -- Bug 6895093
404 credit_card_exp number default 0,
405 direct_card_exp number default 0,
406 total_credit_card_exp number default 0,
407 credit_card_exp_tax_exem number default 0,
408 direct_card_exp_tax_exem number default 0,
409 total_credit_card_exp_tax_exem number default 0,
410 emp_stk_own_contri number default 0,
411 emp_stk_own_contri_tax_exem number default 0,
412 --
413 -- Bug 3966549
414 emp_cre_card_direct_exp2004 number default 0,
415 dpnt_cre_card_direct_exp2004 number default 0,
416 giro_tuition_paid_exp2004 number default 0,
417 -- End of 3966549
418
419 -- Bug 3506168
420 cash_receipt_exp2005 number default 0,
421 -- bug 14219478 start
422 traditional_market_exp number default 0,
423 total_cards_amount number default 0,
424 credit_card_expense number default 0,
425 -- End of bug 14219478
426 --
427 ------------------------------------------------------------------------
428 -- Taxation Base
429 ------------------------------------------------------------------------
430 taxation_base number default 0,
431 ------------------------------------------------------------------------
432 -- Calculated Tax
433 ------------------------------------------------------------------------
434 calc_tax number default 0,
435 ------------------------------------------------------------------------
436 -- Tax Break Information
437 ------------------------------------------------------------------------
438 basic_tax_break number default 0,
439 housing_loan_interest_repay number default 0,
440 housing_exp_tax_break number default 0,
441 stock_saving number default 0,
442 stock_saving_tax_break number default 0,
443 lt_stock_saving1 number default 0,
444 lt_stock_saving2 number default 0,
445 lt_stock_saving_tax_break number default 0,
446 --
447 ovstb_tax_paid_date date,
448 ovstb_territory_code fnd_territories.territory_code%TYPE,
449 ovstb_currency_code fnd_currencies.currency_code%TYPE,
450 ovstb_taxable number default 0,
451 ovstb_taxable_subj_tax_break number default 0,
452 ovstb_tax_break_rate number default 0,
453 ovstb_tax_foreign_currency number default 0,
454 ovstb_tax number default 0,
455 ovstb_application_date date,
456 ovstb_submission_date date,
457 ovs_tax_break number default 0,
458 --
459 total_tax_break number default 0,
460 --
461 fwtb_immigration_purpose varchar2(1),
462 fwtb_contract_date date,
463 fwtb_expiry_date date,
464 fwtb_application_date date,
465 fwtb_submission_date date,
466 foreign_worker_tax_break1 number default 0,
467 foreign_worker_tax_break2 number default 0,
468 foreign_worker_tax_break number default 0,
469 -- Bug 14754822
470 tax_reduction_smb number default 0,
471 tax_reduction_teachers number default 0,
472 tax_reduction_marine number default 0,
473 taxable_earnings_smb number default 0,
474 taxable_earnings_teachers number default 0,
475 taxable_earnings_marine number default 0,
476 ------------------------------------------------------------------------
477 -- Tax
478 ------------------------------------------------------------------------
479 annual_itax number default 0,
480 annual_rtax number default 0,
481 annual_stax number default 0,
482 prev_itax number default 0,
483 prev_rtax number default 0,
484 prev_stax number default 0,
485 cur_itax number default 0,
486 cur_rtax number default 0,
487 cur_stax number default 0,
488 itax_adj number default 0,
489 rtax_adj number default 0,
490 stax_adj number default 0,
491 fw_contr_taxable_earn number default 0, -- Bug 5083240
492 fw_contr_non_taxable_earn number default 0, -- Bug 5083240
493 tot_med_exp_cards number default 0, -- Bug 6630135
494 dpnt_med_exp_cards number default 0, -- Bug 6630135
495 med_exp_paid_not_inc_med_exem number default 0, -- Bug 6630135
496 double_exem_amt number default 0, -- Bug 6716401
497 ------------------------------------------------------------------------
498 -- Tax Group Info
499 ------------------------------------------------------------------------
500 tax_grp_bus_reg_num varchar2(12), -- Bug 7361372
501 tax_grp_name varchar2(150), -- Bug 7361372
502 tax_grp_wkpd_from date, -- Bug 8644512
503 tax_grp_wkpd_to date, -- Bug 8644512
504 tax_grp_tax_brk_pd_from date, -- Bug 8644512
505 tax_grp_tax_brk_pd_to date, -- Bug 8644512
506 tax_grp_taxable_mth number default 0, -- Bug 7361372
507 tax_grp_taxable_bon number default 0, -- Bug 7361372
508 tax_grp_sp_irreg_bonus number default 0, -- Bug 7361372
509 tax_grp_stck_pur_opt_exec_earn number default 0, -- Bug 7361372
513 tax_grp_stax number default 0, -- Bug 7361372
510 tax_grp_esop_withd_earn number default 0, -- Bug 8644512
511 tax_grp_itax number default 0, -- Bug 7361372
512 tax_grp_rtax number default 0, -- Bug 7361372
514 tax_grp_taxable number default 0, -- Bug 7361372
515 tax_grp_post_tax_deduc number default 0, -- Bug 7361372
516 tax_grp_taxable_mth_ne number default 0, -- Bug 7508706
517 tax_grp_taxable_bon_ne number default 0, -- Bug 7508706
518 tax_grp_sp_irreg_bonus_ne number default 0, -- Bug 7508706
519 tax_grp_esop_withd_earn_ne number default 0, -- Bug 8644512
520 tax_grp_stck_pur_ne number default 0, -- Bug 7508706
521 tax_grp_taxable_ne number default 0, -- Bug 7508706
522 tax_grp_non_taxable_ovt number default 0, -- Bug 8644512
523 tax_grp_bir_raising_allw number default 0, -- Bug 8644512
524 tax_grp_fw_income_exem number default 0, -- Bug 8644512
525 company_related_exp number default 0, -- Bug 7615517
526 long_term_stck_fund_1year number default 0, -- Bug 7615517
527 long_term_stck_fund_2year number default 0, -- Bug 7615517
528 long_term_stck_fund_3year number default 0, -- Bug 7615517
529 long_term_stck_fund_tax_exem number default 0, -- Bug 7615517
530 --
531 cur_ntax_R10 number default 0, --Bug 12807687
532 cur_ntax_G01 number default 0, -- Bug 8644512
533 cur_ntax_H01 number default 0, -- Bug 8644512
534 cur_ntax_H05 number default 0, -- Bug 8644512
535 cur_ntax_H06 number default 0, -- Bug 8644512
536 cur_ntax_H07 number default 0, -- Bug 8644512
537 cur_ntax_H08 number default 0, -- Bug 8644512
538 cur_ntax_H09 number default 0, -- Bug 8644512
539 cur_ntax_H10 number default 0, -- Bug 8644512
540 cur_ntax_H11 number default 0, -- Bug 8644512
541 cur_ntax_H12 number default 0, -- Bug 8644512
542 cur_ntax_H13 number default 0, -- Bug 8644512
543 cur_ntax_I01 number default 0, -- Bug 8644512
544 cur_ntax_K01 number default 0, -- Bug 8644512
545 cur_ntax_M01 number default 0, -- Bug 8644512
546 cur_ntax_M02 number default 0, -- Bug 8644512
547 cur_ntax_M03 number default 0, -- Bug 8644512
548 cur_ntax_S01 number default 0, -- Bug 8644512
549 cur_ntax_T01 number default 0, -- Bug 8644512
550 cur_ntax_Y01 number default 0, -- Bug 8644512
551 cur_ntax_Y02 number default 0, -- Bug 8644512
552 cur_ntax_Y03 number default 0, -- Bug 8644512
553 cur_ntax_Y20 number default 0, -- Bug 8644512
554 cur_ntax_Y21 number default 0, -- Bug 9737699
555 cur_ntax_ZZ number default 0, -- Bug 9737699
556 cur_ntax_Z01 number default 0, -- Bug 8644512
557 cur_ntax_tax_brk number default 0, -- Bug 9737699
558 cur_ntax_H14 number default 0, --Bug 14754822
559 cur_ntax_H15 number default 0,
560 cur_ntax_T10 number default 0,
561 cur_ntax_T20 number default 0,
562 -- Bug 8880364
563 cur_ntax_frgn_M01 number default 0,
564 cur_ntax_frgn_M02 number default 0,
565 cur_ntax_frgn_M03 number default 0,
566 --
567 prev_ntax_R10 number default 0, --Bug 12807687
568 prev_ntax_G01 number default 0, -- Bug 8644512
569 prev_ntax_H01 number default 0, -- Bug 8644512
570 prev_ntax_H05 number default 0, -- Bug 8644512
571 prev_ntax_H06 number default 0, -- Bug 8644512
572 prev_ntax_H07 number default 0, -- Bug 8644512
573 prev_ntax_H08 number default 0, -- Bug 8644512
574 prev_ntax_H09 number default 0, -- Bug 8644512
575 prev_ntax_H10 number default 0, -- Bug 8644512
576 prev_ntax_H11 number default 0, -- Bug 8644512
577 prev_ntax_H12 number default 0, -- Bug 8644512
578 prev_ntax_H13 number default 0, -- Bug 8644512
579 prev_ntax_I01 number default 0, -- Bug 8644512
580 prev_ntax_K01 number default 0, -- Bug 8644512
581 prev_ntax_M01 number default 0, -- Bug 8644512
582 prev_ntax_M02 number default 0, -- Bug 8644512
583 prev_ntax_M03 number default 0, -- Bug 8644512
584 prev_ntax_S01 number default 0, -- Bug 8644512
585 prev_ntax_T01 number default 0, -- Bug 8644512
586 prev_ntax_Y01 number default 0, -- Bug 8644512
587 prev_ntax_Y02 number default 0, -- Bug 8644512
588 prev_ntax_Y03 number default 0, -- Bug 8644512
589 prev_ntax_Y20 number default 0, -- Bug 8644512
590 prev_ntax_Y21 number default 0, -- Bug 9737699
591 prev_ntax_ZZ number default 0, -- Bug 9737699
592 prev_ntax_Z01 number default 0, -- Bug 8644512
593 prev_ntax_tax_brk number default 0, -- Bug 9737699
594 prev_ntax_H14 number default 0, --Bug 14754822
595 prev_ntax_H15 number default 0,
596 prev_ntax_T10 number default 0,
597 prev_ntax_T20 number default 0,
598 --
599 tax_grp_ntax_R10 number default 0, --Bug 12807687
600 tax_grp_ntax_G01 number default 0, -- Bug 8644512
601 tax_grp_ntax_H01 number default 0, -- Bug 8644512
602 tax_grp_ntax_H05 number default 0, -- Bug 8644512
603 tax_grp_ntax_H06 number default 0, -- Bug 8644512
604 tax_grp_ntax_H07 number default 0, -- Bug 8644512
605 tax_grp_ntax_H08 number default 0, -- Bug 8644512
606 tax_grp_ntax_H09 number default 0, -- Bug 8644512
607 tax_grp_ntax_H10 number default 0, -- Bug 8644512
608 tax_grp_ntax_H11 number default 0, -- Bug 8644512
609 tax_grp_ntax_H12 number default 0, -- Bug 8644512
610 tax_grp_ntax_H13 number default 0, -- Bug 8644512
611 tax_grp_ntax_I01 number default 0, -- Bug 8644512
612 tax_grp_ntax_K01 number default 0, -- Bug 8644512
613 tax_grp_ntax_M01 number default 0, -- Bug 8644512
614 tax_grp_ntax_M02 number default 0, -- Bug 8644512
618 tax_grp_ntax_Y01 number default 0, -- Bug 8644512
615 tax_grp_ntax_M03 number default 0, -- Bug 8644512
616 tax_grp_ntax_S01 number default 0, -- Bug 8644512
617 tax_grp_ntax_T01 number default 0, -- Bug 8644512
619 tax_grp_ntax_Y02 number default 0, -- Bug 8644512
620 tax_grp_ntax_Y03 number default 0, -- Bug 8644512
621 tax_grp_ntax_Y20 number default 0, -- Bug 8644512
622 tax_grp_ntax_Y21 number default 0, -- Bug 9737699
623 tax_grp_ntax_ZZ number default 0, -- Bug 9737699
624 tax_grp_ntax_Z01 number default 0, -- Bug 8644512
625 tax_grp_ntax_tax_brk number default 0, -- Bug 9737699
626 tax_grp_ntax_H14 number default 0, --Bug 14754822
627 tax_grp_ntax_H15 number default 0,
628 tax_grp_ntax_T10 number default 0,
629 tax_grp_ntax_T20 number default 0,
630 --
631 prev_ntax_R10_tbl t_number_tbl, --Bug 12807687
632 prev_ntax_G01_tbl t_number_tbl, -- Bug 8644512
633 prev_ntax_H01_tbl t_number_tbl, -- Bug 8644512
634 prev_ntax_H05_tbl t_number_tbl, -- Bug 8644512
635 prev_ntax_H06_tbl t_number_tbl, -- Bug 8644512
636 prev_ntax_H07_tbl t_number_tbl, -- Bug 8644512
637 prev_ntax_H08_tbl t_number_tbl, -- Bug 8644512
638 prev_ntax_H09_tbl t_number_tbl, -- Bug 8644512
639 prev_ntax_H10_tbl t_number_tbl, -- Bug 8644512
640 prev_ntax_H11_tbl t_number_tbl, -- Bug 8644512
641 prev_ntax_H12_tbl t_number_tbl, -- Bug 8644512
642 prev_ntax_H13_tbl t_number_tbl, -- Bug 8644512
643 prev_ntax_I01_tbl t_number_tbl, -- Bug 8644512
644 prev_ntax_K01_tbl t_number_tbl, -- Bug 8644512
645 prev_ntax_M01_tbl t_number_tbl, -- Bug 8644512
646 prev_ntax_M02_tbl t_number_tbl, -- Bug 8644512
647 prev_ntax_M03_tbl t_number_tbl, -- Bug 8644512
648 prev_ntax_S01_tbl t_number_tbl, -- Bug 8644512
649 prev_ntax_T01_tbl t_number_tbl, -- Bug 8644512
650 prev_ntax_Y01_tbl t_number_tbl, -- Bug 8644512
651 prev_ntax_Y02_tbl t_number_tbl, -- Bug 8644512
652 prev_ntax_Y03_tbl t_number_tbl, -- Bug 8644512
653 prev_ntax_Y20_tbl t_number_tbl, -- Bug 8644512
654 prev_ntax_Y21_tbl t_number_tbl, -- Bug 9737699
655 prev_ntax_ZZ_tbl t_number_tbl, -- Bug 9737699
656 prev_ntax_Z01_tbl t_number_tbl, -- Bug 8644512
657 prev_ntax_tax_brk_tbl t_number_tbl, -- Bug 9737699
658 prev_ntax_H14_tbl t_number_tbl, -- Bug 14754822
659 prev_ntax_H15_tbl t_number_tbl,
660 prev_ntax_T10_tbl t_number_tbl,
661 prev_ntax_T20_tbl t_number_tbl,
662
663 --
664 total_ntax_R10 number default 0, --Bug 12807687
665 total_ntax_G01 number default 0, -- Bug 8644512
666 total_ntax_H01 number default 0, -- Bug 8644512
667 total_ntax_H05 number default 0, -- Bug 8644512
668 total_ntax_H06 number default 0, -- Bug 8644512
669 total_ntax_H07 number default 0, -- Bug 8644512
670 total_ntax_H08 number default 0, -- Bug 8644512
671 total_ntax_H09 number default 0, -- Bug 8644512
672 total_ntax_H10 number default 0, -- Bug 8644512
673 total_ntax_H11 number default 0, -- Bug 8644512
674 total_ntax_H12 number default 0, -- Bug 8644512
675 total_ntax_H13 number default 0, -- Bug 8644512
676 total_ntax_I01 number default 0, -- Bug 8644512
677 total_ntax_K01 number default 0, -- Bug 8644512
678 total_ntax_M01 number default 0, -- Bug 8644512
679 total_ntax_M02 number default 0, -- Bug 8644512
680 total_ntax_M03 number default 0, -- Bug 8644512
681 total_ntax_S01 number default 0, -- Bug 8644512
682 total_ntax_T01 number default 0, -- Bug 8644512
683 total_ntax_Y01 number default 0, -- Bug 8644512
684 total_ntax_Y02 number default 0, -- Bug 8644512
685 total_ntax_Y03 number default 0, -- Bug 8644512
686 total_ntax_Y20 number default 0, -- Bug 8644512
687 total_ntax_Y21 number default 0, -- Bug 9737699
688 total_ntax_ZZ number default 0, -- Bug 9737699
689 total_ntax_Z01 number default 0, -- Bug 8644512
690 total_ntax_tax_brk number default 0, -- Bug 9737699
691 total_ntax_H14 number default 0, --Bug 14754822
692 total_ntax_H15 number default 0,
693 total_ntax_T10 number default 0,
694 total_ntax_T20 number default 0,
695
696 --
697 cur_total_ntax_earn number default 0, -- Bug 8644512
698 tax_grp_total_ntax_earn number default 0, -- Bug 8644512
699 smb_income_exem number default 0, -- Bug 9079450
700 cur_smb_days_worked number default 0, -- Bug 9079450
701 prev_smb_days_worked number default 0, -- Bug 9079450
702 cur_smb_eligible_income number default 0, -- Bug 9079450
703 prev_smb_eligible_income number default 0, -- Bug 9079450
704 emp_join_prev_year varchar2(1), -- Bug 9079450
705 emp_leave_cur_year varchar2(1), -- Bug 9079450
706 smb_eligibility_flag varchar2(1) -- Bug 9079450
707 );
708 ------------------------------------------------------------------------
709 procedure yea_info(
710 p_assignment_id in number,
711 p_assignment_action_id in number,
712 p_effective_date in date,
713 p_business_group_id in number,
714 p_payroll_id in number,
715 p_yea_info out nocopy t_yea_info,
716 p_taxable_earnings_warning out nocopy boolean,
717 p_taxable_income_warning out nocopy boolean,
718 p_taxation_base_warning out nocopy boolean,
719 p_calc_tax_warning out nocopy boolean,
720 p_itax_warning out nocopy boolean,
721 p_rtax_warning out nocopy boolean,
722 -- Bug 2878937
723 p_tax_adj_warning out nocopy boolean);
724 ------------------------------------------------------------------------
725 function yea_info(
726 p_assignment_action_id in number) return t_yea_info;
727 ------------------------------------------------------------------------
728 procedure process_assignment(
729 p_validate in boolean default false,
730 p_business_group_id in number,
731 p_assignment_id in number,
732 p_assignment_action_id in number,
733 p_bal_asg_action_id in number,
734 p_report_type in out nocopy varchar2,
735 p_report_qualifier in out nocopy varchar2,
739 p_consolidation_set_id in out nocopy number,
736 p_report_category in out nocopy varchar2,
737 p_effective_date in out nocopy date,
738 p_payroll_id in out nocopy number,
740 p_archive_type_used in out nocopy varchar2); --5036734
741 --------------------------------------------------------------------------------
742 function calculate_adjustment(
743 p_assignment_id in pay_assignment_actions.assignment_id%type,
744 p_business_group_id in pay_payroll_actions.business_group_id%type,
745 p_effective_date in pay_payroll_actions.effective_date%type,
746 p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
747 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
748 p_itax_adj out nocopy number,
749 p_rtax_adj out nocopy number,
750 p_stax_adj out nocopy number,
751 p_error out nocopy varchar2) return number;
752 --------------------------------------------------------------------------------
753
754 function chk_valid_donation(p_donation_year in varchar2,
755 p_donation_code in varchar2,
756 p_effective_date in date) return varchar2;
757 end pay_kr_yea_pkg;