[Home] [Help]
PACKAGE: APPS.PAY_KR_YEA_PKG
Source
1 package pay_kr_yea_pkg as
2 /* $Header: pykryea.pkh 120.10.12010000.5 2008/08/12 10:27:33 vaisriva 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_taxable number default 0,
26 ------------------------------------------------------------------------
27 -- Previous Employers' Information
28 ------------------------------------------------------------------------
29 prev_termination_date_tbl t_date_tbl,
30 prev_corp_name_tbl t_varchar2_tbl,
31 prev_bp_number_tbl t_varchar2_tbl,
32 prev_taxable_mth_tbl t_number_tbl,
33 prev_taxable_bon_tbl t_number_tbl,
34 prev_sp_irreg_bonus_tbl t_number_tbl,
35 prev_stck_pur_opt_exe_earn_tbl t_number_tbl, -- Bug 6024342
36 prev_non_taxable_ovs_tbl t_number_tbl,
37 prev_non_taxable_ovt_tbl t_number_tbl,
38 prev_non_taxable_oth_tbl t_number_tbl,
39 prev_hi_prem_tbl t_number_tbl,
40 prev_ltci_prem_tbl t_number_tbl, -- Bug 7260606
41 prev_ei_prem_tbl t_number_tbl,
42 prev_np_prem_tbl t_number_tbl,
43 prev_pen_prem_tbl t_number_tbl, -- Bug 6024342
44 prev_itax_tbl t_number_tbl,
45 prev_rtax_tbl t_number_tbl,
46 prev_stax_tbl t_number_tbl,
47 --
48 prev_taxable_mth number default 0,
49 prev_taxable_bon number default 0,
50 prev_sp_irreg_bonus number default 0,
51 prev_stck_pur_opt_exec_earn number default 0, -- Bug 6024342
52 prev_taxable number default 0,
53 ------------------------------------------------------------------------
54 -- Annual Earnings
55 ------------------------------------------------------------------------
56 taxable_mth number default 0,
57 taxable_bon number default 0,
58 sp_irreg_bonus number default 0,
59 -- Bug 6024342
60 stck_pur_opt_exec_earn number default 0,
61 --
62 -- Bug 6012258
63 research_payment number default 0,
64 --
65 taxable number default 0,
66 non_taxable_ovs number default 0,
67 non_taxable_ovt number default 0,
68 non_taxable_oth number default 0,
69 non_taxable number default 0,
70 ------------------------------------------------------------------------
71 -- Monthly Regular Earnings -- Bus 3201332
72 ------------------------------------------------------------------------
73 monthly_reg_earning number default 0,
74 ------------------------------------------------------------------------
75 -- Bug 3172960 Foreign Worker Income Exemption
76 ------------------------------------------------------------------------
77 foreign_worker_income_exem number default 0,
78 ------------------------------------------------------------------------
79 -- Basic Income Exemption
80 ------------------------------------------------------------------------
81 basic_income_exem number default 0,
82 ------------------------------------------------------------------------
83 -- Taxable Income
84 ------------------------------------------------------------------------
85 taxable_income number default 0,
86 ------------------------------------------------------------------------
87 -- Employee Tax Exemption
88 ------------------------------------------------------------------------
89 ee_tax_exem number default 0,
90 ------------------------------------------------------------------------
91 -- Dependent Tax Exemption
92 ------------------------------------------------------------------------
93 dpnt_spouse_flag varchar2(1) default 'N',
94 dpnt_spouse_tax_exem number default 0,
95 num_of_aged_dpnts number default 0,
96 num_of_adult_dpnts number default 0,
97 num_of_underaged_dpnts number default 0,
98 num_of_dpnts number default 0,
99 dpnt_tax_exem number default 0,
100 num_of_ageds number default 0,
101 -- Bug 3172960
102 num_of_super_ageds number default 0,
103 --
104 num_of_new_born_adopted number default 0, -- Bug 6705170
105 new_born_adopted_tax_exem number default 0, -- Bug 6705170
106 --
107 num_of_addtl_child number default 0, -- Bug 6784288
108 --
109 aged_tax_exem number default 0,
110 num_of_disableds number default 0,
111 disabled_tax_exem number default 0,
112 female_ee_flag varchar2(1) default 'N',
113 female_ee_tax_exem number default 0,
114 num_of_children number default 0,
115 child_tax_exem number default 0,
116 -- Bug 5756690
117 addl_child_tax_exem number default 0,
118 supp_tax_exem number default 0,
119 ------------------------------------------------------------------------
120 -- Insurance Premium Tax Exemption
121 ------------------------------------------------------------------------
122 hi_prem number default 0,
123 hi_prem_tax_exem number default 0,
124 long_term_ins_prem number default 0, -- Bug 7164589
125 long_term_ins_prem_tax_exem number default 0, -- Bug 7164589
126 ei_prem number default 0,
127 ei_prem_tax_exem number default 0,
128 pers_ins_name varchar2(150),
129 pers_ins_prem number default 0,
130 pers_ins_prem_tax_exem number default 0,
131 disabled_ins_prem number default 0,
132 disabled_ins_prem_tax_exem number default 0,
133 ins_prem_tax_exem number default 0,
134 ------------------------------------------------------------------------
135 -- Medical Expense Tax Exemption
136 ------------------------------------------------------------------------
137 med_exp number default 0,
138 med_exp_card_emp number default 0,
139 med_exp_disabled number default 0,
140 med_exp_aged number default 0,
141 -- Bug 3172960
142 med_exp_emp number default 0,
143 max_med_exp_tax_exem number default 0,
144 med_exp_tax_exem number default 0,
145 --
146 -- Bug 3966549
147 reg_med_exp_tax_exem2004 number default 0,
148 add_med_exp_tax_exem2004 number default 0,
149 -- End of 3966549
150 --
151 ------------------------------------------------------------------------
152 -- Education Expense Tax Exemption
153 ------------------------------------------------------------------------
154 ee_educ_exp number default 0,
155 -- Bug 3971542
156 ee_occupation_educ_exp2005 number default 0,
157 -- End of 3971542
158 dpnt_educ_contact_type_tbl t_varchar2_tbl,
159 dpnt_educ_school_type_tbl t_varchar2_tbl,
160 dpnt_educ_exp_tbl t_number_tbl,
161 spouse_educ_exp number default 0,
162 disabled_educ_exp number default 0,
163 dpnt_educ_exp number default 0,
164 educ_exp_tax_exem number default 0,
165 ------------------------------------------------------------------------
166 -- Bug 3201332 Foreign Worker Special Pre-Tax Deduction
167 ------------------------------------------------------------------------
168 fw_educ_expense number default 0,
169 fw_house_rent number default 0,
170 ------------------------------------------------------------------------
171 -- Housing Expense Tax Exemption
172 ------------------------------------------------------------------------
173 /* Changes for Bug 2523481 */
174 --
175 housing_saving_type_tbl t_varchar2_tbl,
176 housing_saving_tbl t_number_tbl,
177 housing_saving_type varchar2(30),
178 housing_saving number default 0,
179 --
180 housing_purchase_date date,
181 housing_loan_date date,
182 housing_loan_repay number default 0,
183 --
184 lt_housing_loan_date date,
185 lt_housing_loan_interest_repay number default 0,
186 --
187 lt_housing_loan_date_1 date,
188 lt_housing_loan_intr_repay_1 number default 0,
189 --
190 max_housing_exp_tax_exem number default 0,
191 housing_exp_tax_exem number default 0,
192 ------------------------------------------------------------------------
193 -- Donation Tax Exemption (Political and ESOA)
194 ------------------------------------------------------------------------
195 donation1 number default 0,
196 political_donation1 number default 0,
197 political_donation2 number default 0,
198 political_donation3 number default 0,
199 donation1_tax_exem number default 0,
200 donation2 number default 0,
201 donation3 number default 0,
202 max_donation2_tax_exem number default 0,
203 max_donation3_tax_exem number default 0,
204 donation2_tax_exem number default 0,
205 donation3_tax_exem number default 0,
206 donation_tax_exem number default 0,
207 --
208 -- Bug 3966549
209 esoa_don2004 number default 0,
210 max_esoa_don_tax_exem2004 number default 0,
211 esoa_don_tax_exem2004 number default 0,
212 don_tax_break2004 number default 0,
213 -- End of 3966549
214 --
215 ------------------------------------------------------------------------
216 -- Marriage, Funeral and Relocation Tax Exemption
217 ------------------------------------------------------------------------
218 marriage_exemption varchar2(15),
219 funeral_exemption varchar2(15),
220 relocation_exemption varchar2(15),
221 marr_fun_relo_exemption number default 0,
222 ------------------------------------------------------------------------
223 -- Special Tax Exemption
224 ------------------------------------------------------------------------
225 sp_tax_exem number default 0,
226 std_sp_tax_exem number default 0,
227 ------------------------------------------------------------------------
228 -- National Pension Premium Tax Exemption
229 ------------------------------------------------------------------------
230 np_prem number default 0,
231 np_prem_tax_exem number default 0,
232 ------------------------------------------------------------------------
233 -- Pension Premium
234 ------------------------------------------------------------------------
235 pen_prem number default 0, -- Bug 6024342
236 ------------------------------------------------------------------------
237 -- Taxable Income2
238 ------------------------------------------------------------------------
239 taxable_income2 number default 0,
240 ------------------------------------------------------------------------
241 -- Tax Exemption
242 ------------------------------------------------------------------------
243 pers_pension_prem number default 0,
244 pers_pension_prem_tax_exem number default 0,
245 -- Bug 4750653
246 corp_pension_prem number default 0,
247 corp_pension_prem_tax_exem number default 0,
248 --
249 emp_st_own_plan_cont number default 0,
250 emp_st_own_plan_cont_exem number default 0,
251 pers_pension_saving number default 0,
252 pers_pension_saving_tax_exem number default 0,
253 invest_partner_fin1 number default 0,
254 invest_partner_fin2 number default 0,
255 invest_partner_fin_tax_exem number default 0,
256 small_bus_install number default 0, -- Bug 6895093
257 small_bus_install_exem number default 0, -- Bug 6895093
258 credit_card_exp number default 0,
259 direct_card_exp number default 0,
260 total_credit_card_exp number default 0,
261 credit_card_exp_tax_exem number default 0,
262 direct_card_exp_tax_exem number default 0,
263 total_credit_card_exp_tax_exem number default 0,
264 emp_stk_own_contri number default 0,
265 emp_stk_own_contri_tax_exem number default 0,
266 --
267 -- Bug 3966549
268 emp_cre_card_direct_exp2004 number default 0,
269 dpnt_cre_card_direct_exp2004 number default 0,
270 giro_tuition_paid_exp2004 number default 0,
271 -- End of 3966549
272
273 -- Bug 3506168
274 cash_receipt_exp2005 number default 0,
275 --
276 ------------------------------------------------------------------------
277 -- Taxation Base
278 ------------------------------------------------------------------------
279 taxation_base number default 0,
280 ------------------------------------------------------------------------
281 -- Calculated Tax
282 ------------------------------------------------------------------------
283 calc_tax number default 0,
284 ------------------------------------------------------------------------
285 -- Tax Break Information
286 ------------------------------------------------------------------------
287 basic_tax_break number default 0,
288 housing_loan_interest_repay number default 0,
289 housing_exp_tax_break number default 0,
290 stock_saving number default 0,
291 stock_saving_tax_break number default 0,
292 lt_stock_saving1 number default 0,
293 lt_stock_saving2 number default 0,
294 lt_stock_saving_tax_break number default 0,
295 --
296 ovstb_tax_paid_date date,
297 ovstb_territory_code fnd_territories.territory_code%TYPE,
298 ovstb_currency_code fnd_currencies.currency_code%TYPE,
299 ovstb_taxable number default 0,
300 ovstb_taxable_subj_tax_break number default 0,
301 ovstb_tax_break_rate number default 0,
302 ovstb_tax_foreign_currency number default 0,
303 ovstb_tax number default 0,
304 ovstb_application_date date,
305 ovstb_submission_date date,
306 ovs_tax_break number default 0,
307 --
308 total_tax_break number default 0,
309 --
310 fwtb_immigration_purpose varchar2(1),
311 fwtb_contract_date date,
312 fwtb_expiry_date date,
313 fwtb_application_date date,
314 fwtb_submission_date date,
315 foreign_worker_tax_break1 number default 0,
316 foreign_worker_tax_break2 number default 0,
317 foreign_worker_tax_break number default 0,
318 ------------------------------------------------------------------------
319 -- Tax
320 ------------------------------------------------------------------------
321 annual_itax number default 0,
322 annual_rtax number default 0,
323 annual_stax number default 0,
324 prev_itax number default 0,
325 prev_rtax number default 0,
326 prev_stax number default 0,
327 cur_itax number default 0,
328 cur_rtax number default 0,
329 cur_stax number default 0,
330 itax_adj number default 0,
331 rtax_adj number default 0,
332 stax_adj number default 0,
333 fw_contr_taxable_earn number default 0, -- Bug 5083240
334 fw_contr_non_taxable_earn number default 0, -- Bug 5083240
335 tot_med_exp_cards number default 0, -- Bug 6630135
336 dpnt_med_exp_cards number default 0, -- Bug 6630135
337 med_exp_paid_not_inc_med_exem number default 0, -- Bug 6630135
338 double_exem_amt number default 0 -- Bug 6716401
339 );
340 ------------------------------------------------------------------------
341 procedure yea_info(
342 p_assignment_id in number,
343 p_assignment_action_id in number,
344 p_effective_date in date,
345 p_business_group_id in number,
346 p_payroll_id in number,
347 p_yea_info out nocopy t_yea_info,
348 p_taxable_earnings_warning out nocopy boolean,
349 p_taxable_income_warning out nocopy boolean,
350 p_taxation_base_warning out nocopy boolean,
351 p_calc_tax_warning out nocopy boolean,
352 p_itax_warning out nocopy boolean,
353 p_rtax_warning out nocopy boolean,
354 -- Bug 2878937
355 p_tax_adj_warning out nocopy boolean);
356 ------------------------------------------------------------------------
357 function yea_info(
358 p_assignment_action_id in number) return t_yea_info;
359 ------------------------------------------------------------------------
360 procedure process_assignment(
361 p_validate in boolean default false,
362 p_business_group_id in number,
363 p_assignment_id in number,
364 p_assignment_action_id in number,
365 p_bal_asg_action_id in number,
366 p_report_type in out nocopy varchar2,
367 p_report_qualifier in out nocopy varchar2,
368 p_report_category in out nocopy varchar2,
369 p_effective_date in out nocopy date,
370 p_payroll_id in out nocopy number,
371 p_consolidation_set_id in out nocopy number,
372 p_archive_type_used in out nocopy varchar2); --5036734
373 --------------------------------------------------------------------------------
374 function calculate_adjustment(
375 p_assignment_id in pay_assignment_actions.assignment_id%type,
376 p_business_group_id in pay_payroll_actions.business_group_id%type,
377 p_effective_date in pay_payroll_actions.effective_date%type,
378 p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
379 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
380 p_itax_adj out nocopy number,
381 p_rtax_adj out nocopy number,
382 p_stax_adj out nocopy number,
383 p_error out nocopy varchar2) return number;
384 --------------------------------------------------------------------------------
385 end pay_kr_yea_pkg;