[Home] [Help]
PACKAGE: APPS.PAY_KR_PAYKRYLG_PKG
Source
1 package pay_kr_paykrylg_pkg as
2 /* $Header: paykrylg.pkh 120.1 2007/10/12 12:28:45 vaisriva noship $ */
3 ------------------------------------------------------------------------
4 procedure data(
5 p_assignment_action_id in number,
6 p_taxable out nocopy number,
7 p_basic_income_exem out nocopy number,
8 p_taxable_income out nocopy number,
9 p_ee_tax_exem out nocopy number,
10 p_dpnt_spouse_flag out nocopy varchar2,
11 p_dpnt_spouse_tax_exem out nocopy number,
12 p_num_of_underaged_dpnts out nocopy number,
13 p_num_of_aged_dpnts out nocopy number,
14 p_dpnt_tax_exem out nocopy number,
15 p_num_of_ageds out nocopy number,
16 p_aged_tax_exem out nocopy number,
17 p_num_of_disableds out nocopy number,
18 p_disabled_tax_exem out nocopy number,
19 p_female_ee_flag out nocopy varchar2,
20 p_female_ee_tax_exem out nocopy number,
21 p_num_of_children out nocopy number,
22 p_child_tax_exem out nocopy number,
23 p_supp_tax_exem out nocopy number,
24 p_hi_prem out nocopy number,
25 p_ei_prem out nocopy number,
26 p_pers_ins_name out nocopy varchar2,
27 p_pers_ins_prem out nocopy number,
28 p_disabled_ins_prem out nocopy number,
29 p_ins_prem_tax_exem out nocopy number,
30 p_med_exp out nocopy number,
31 p_med_exp_aged out nocopy number,
32 p_med_exp_disabled out nocopy number,
33 p_max_med_exp_tax_exem out nocopy number,
34 p_med_exp_tax_exem out nocopy number,
35 p_ee_educ_exp out nocopy number,
36 p_spouse_educ_exp out nocopy number,
37 p_disabled_educ_exp out nocopy number,
38 p_dpnt_educ_exp out nocopy number,
39 p_educ_exp_tax_exem out nocopy number,
40 p_housing_saving_type_meaning out nocopy varchar2,
41 p_housing_saving out nocopy number,
42 p_housing_purchase_date out nocopy date,
43 p_housing_loan_date out nocopy date,
44 p_housing_loan_repay out nocopy number,
45 p_lt_housing_loan_date out nocopy date,
46 p_lt_housing_loan_int_repay out nocopy number,
47 p_max_housing_exp_tax_exem out nocopy number,
48 p_housing_exp_tax_exem out nocopy number,
49 p_donation1_tax_exem out nocopy number,
50 p_donation2 out nocopy number,
51 p_max_donation2_tax_exem out nocopy number,
52 p_donation2_tax_exem out nocopy number,
53 p_donation_tax_exem out nocopy number,
54 p_sp_tax_exem out nocopy number,
55 p_std_sp_tax_exem out nocopy number,
56 p_np_prem out nocopy number,
57 p_np_prem_tax_exem out nocopy number,
58 p_pers_pension_prem_tax out nocopy number,
59 p_pers_pension_saving_tax out nocopy number,
60 p_invest_partner_fin_tax out nocopy number,
61 p_credit_card_exp_tax out nocopy number,
62 p_emp_st_own_plan_cont out nocopy number,
63 p_pers_pension_prem_tax_exem out nocopy number,
64 p_pers_pension_saving_tax_exem out nocopy number,
65 p_invest_partner_fin_tax_exem out nocopy number,
66 p_credit_card_exp_tax_exem out nocopy number,
67 p_emp_st_own_plan_cont_exem out nocopy number,
68 p_taxation_base out nocopy number,
69 p_calc_tax out nocopy number,
70 p_basic_tax_break out nocopy number,
71 p_housing_exp_tax_break out nocopy number,
72 p_stock_saving_tax_break out nocopy number,
73 p_ovstb_territory_short_name out nocopy varchar2,
74 p_ovstb_tax_paid_date out nocopy date,
75 p_ovstb_tax_foreign_currency out nocopy number,
76 p_ovstb_tax out nocopy number,
77 p_ovstb_application_date out nocopy date,
78 p_ovstb_submission_date out nocopy date,
79 p_ovs_tax_break out nocopy number,
80 p_lt_stock_saving_tax_break out nocopy number,
81 p_total_tax_break out nocopy number,
82 p_fwtb_immigration_purpose out nocopy varchar2,
83 p_fwtb_contract_date out nocopy date,
84 p_fwtb_expiry_date out nocopy date,
85 p_fwtb_application_date out nocopy date,
86 p_fwtb_submission_date out nocopy date,
87 p_foreign_worker_tax_break1 out nocopy number,
88 p_foreign_worker_tax_break2 out nocopy number,
89 p_annual_itax out nocopy number,
90 p_annual_rtax out nocopy number,
91 p_annual_stax out nocopy number,
92 p_prev_itax out nocopy number,
93 p_prev_rtax out nocopy number,
94 p_prev_stax out nocopy number,
95 p_cur_annual_itax out nocopy number,
96 p_cur_annual_rtax out nocopy number,
97 p_cur_annual_stax out nocopy number,
98 p_cur_itax out nocopy number,
99 p_cur_rtax out nocopy number,
100 p_cur_stax out nocopy number,
101 p_itax_adj out nocopy number,
102 p_itax_refund out nocopy number,
103 p_rtax_adj out nocopy number,
104 p_rtax_refund out nocopy number,
105 p_stax_adj out nocopy number,
106 p_stax_refund out nocopy number,
107 p_effective_date1 out nocopy date,
108 p_taxable_mth1 out nocopy number,
109 p_taxable_bon1 out nocopy number,
110 p_sp_irreg_bonus1 out nocopy number,
111 p_taxable1 out nocopy number,
112 p_itax1 out nocopy number,
113 p_rtax1 out nocopy number,
114 p_stax1 out nocopy number,
115 -- Bug 4322981
116 p_np_dedc1 out nocopy number,
117 p_hi_dedc1 out nocopy number,
118 p_ei_dedc1 out nocopy number,
119 p_donation_dedc1 out nocopy number,
120 -- End of 4322981
121 p_non_taxable_ovs1 out nocopy number,
122 p_non_taxable_ovt1 out nocopy number,
123 p_non_taxable_oth1 out nocopy number,
124 p_effective_date2 out nocopy date,
125 p_taxable_mth2 out nocopy number,
126 p_taxable_bon2 out nocopy number,
127 p_sp_irreg_bonus2 out nocopy number,
128 p_taxable2 out nocopy number,
129 p_itax2 out nocopy number,
130 p_rtax2 out nocopy number,
131 p_stax2 out nocopy number,
132 -- Bug 4322981
133 p_np_dedc2 out nocopy number,
134 p_hi_dedc2 out nocopy number,
135 p_ei_dedc2 out nocopy number,
136 p_donation_dedc2 out nocopy number,
137 -- End of 4322981
138 p_non_taxable_ovs2 out nocopy number,
139 p_non_taxable_ovt2 out nocopy number,
140 p_non_taxable_oth2 out nocopy number,
141 p_effective_date3 out nocopy date,
142 p_taxable_mth3 out nocopy number,
143 p_taxable_bon3 out nocopy number,
144 p_sp_irreg_bonus3 out nocopy number,
145 p_taxable3 out nocopy number,
146 p_itax3 out nocopy number,
147 p_rtax3 out nocopy number,
148 p_stax3 out nocopy number,
149 -- Bug 4322981
150 p_np_dedc3 out nocopy number,
151 p_hi_dedc3 out nocopy number,
152 p_ei_dedc3 out nocopy number,
153 p_donation_dedc3 out nocopy number,
154 -- End of 4322981
155 p_non_taxable_ovs3 out nocopy number,
156 p_non_taxable_ovt3 out nocopy number,
157 p_non_taxable_oth3 out nocopy number,
158 p_effective_date4 out nocopy date,
159 p_taxable_mth4 out nocopy number,
160 p_taxable_bon4 out nocopy number,
161 p_sp_irreg_bonus4 out nocopy number,
162 p_taxable4 out nocopy number,
163 p_itax4 out nocopy number,
164 p_rtax4 out nocopy number,
165 p_stax4 out nocopy number,
166 -- Bug 4322981
167 p_np_dedc4 out nocopy number,
168 p_hi_dedc4 out nocopy number,
169 p_ei_dedc4 out nocopy number,
170 p_donation_dedc4 out nocopy number,
171 -- End of 4322981
172 p_non_taxable_ovs4 out nocopy number,
173 p_non_taxable_ovt4 out nocopy number,
174 p_non_taxable_oth4 out nocopy number,
175 p_effective_date5 out nocopy date,
176 p_taxable_mth5 out nocopy number,
177 p_taxable_bon5 out nocopy number,
178 p_sp_irreg_bonus5 out nocopy number,
179 p_taxable5 out nocopy number,
180 p_itax5 out nocopy number,
181 p_rtax5 out nocopy number,
182 p_stax5 out nocopy number,
183 -- Bug 4322981
184 p_np_dedc5 out nocopy number,
185 p_hi_dedc5 out nocopy number,
186 p_ei_dedc5 out nocopy number,
187 p_donation_dedc5 out nocopy number,
188 -- End of 4322981
189 p_non_taxable_ovs5 out nocopy number,
190 p_non_taxable_ovt5 out nocopy number,
191 p_non_taxable_oth5 out nocopy number,
192 p_effective_date6 out nocopy date,
193 p_taxable_mth6 out nocopy number,
194 p_taxable_bon6 out nocopy number,
195 p_sp_irreg_bonus6 out nocopy number,
196 p_taxable6 out nocopy number,
197 p_itax6 out nocopy number,
198 p_rtax6 out nocopy number,
199 p_stax6 out nocopy number,
200 -- Bug 4322981
201 p_np_dedc6 out nocopy number,
202 p_hi_dedc6 out nocopy number,
203 p_ei_dedc6 out nocopy number,
204 p_donation_dedc6 out nocopy number,
205 -- End of 4322981
206 p_non_taxable_ovs6 out nocopy number,
207 p_non_taxable_ovt6 out nocopy number,
208 p_non_taxable_oth6 out nocopy number,
209 p_effective_date7 out nocopy date,
210 p_taxable_mth7 out nocopy number,
211 p_taxable_bon7 out nocopy number,
212 p_sp_irreg_bonus7 out nocopy number,
213 p_taxable7 out nocopy number,
214 p_itax7 out nocopy number,
215 p_rtax7 out nocopy number,
216 p_stax7 out nocopy number,
217 -- Bug 4322981
218 p_np_dedc7 out nocopy number,
219 p_hi_dedc7 out nocopy number,
220 p_ei_dedc7 out nocopy number,
221 p_donation_dedc7 out nocopy number,
222 -- End of 4322981
223 p_non_taxable_ovs7 out nocopy number,
224 p_non_taxable_ovt7 out nocopy number,
225 p_non_taxable_oth7 out nocopy number,
226 p_effective_date8 out nocopy date,
227 p_taxable_mth8 out nocopy number,
228 p_taxable_bon8 out nocopy number,
229 p_sp_irreg_bonus8 out nocopy number,
230 p_taxable8 out nocopy number,
231 p_itax8 out nocopy number,
232 p_rtax8 out nocopy number,
233 p_stax8 out nocopy number,
234 -- Bug 4322981
235 p_np_dedc8 out nocopy number,
236 p_hi_dedc8 out nocopy number,
237 p_ei_dedc8 out nocopy number,
238 p_donation_dedc8 out nocopy number,
239 -- End of 4322981
240 p_non_taxable_ovs8 out nocopy number,
241 p_non_taxable_ovt8 out nocopy number,
242 p_non_taxable_oth8 out nocopy number,
243 p_effective_date9 out nocopy date,
244 p_taxable_mth9 out nocopy number,
245 p_taxable_bon9 out nocopy number,
246 p_sp_irreg_bonus9 out nocopy number,
247 p_taxable9 out nocopy number,
248 p_itax9 out nocopy number,
249 p_rtax9 out nocopy number,
250 p_stax9 out nocopy number,
251 -- Bug 4322981
252 p_np_dedc9 out nocopy number,
253 p_hi_dedc9 out nocopy number,
254 p_ei_dedc9 out nocopy number,
255 p_donation_dedc9 out nocopy number,
256 -- End of 4322981
257 p_non_taxable_ovs9 out nocopy number,
258 p_non_taxable_ovt9 out nocopy number,
259 p_non_taxable_oth9 out nocopy number,
260 p_effective_date10 out nocopy date,
261 p_taxable_mth10 out nocopy number,
262 p_taxable_bon10 out nocopy number,
263 p_sp_irreg_bonus10 out nocopy number,
264 p_taxable10 out nocopy number,
265 p_itax10 out nocopy number,
266 p_rtax10 out nocopy number,
267 p_stax10 out nocopy number,
268 -- Bug 4322981
269 p_np_dedc10 out nocopy number,
270 p_hi_dedc10 out nocopy number,
271 p_ei_dedc10 out nocopy number,
272 p_donation_dedc10 out nocopy number,
273 -- End of 4322981
274 p_non_taxable_ovs10 out nocopy number,
275 p_non_taxable_ovt10 out nocopy number,
276 p_non_taxable_oth10 out nocopy number,
277 p_effective_date11 out nocopy date,
278 p_taxable_mth11 out nocopy number,
279 p_taxable_bon11 out nocopy number,
280 p_sp_irreg_bonus11 out nocopy number,
281 p_taxable11 out nocopy number,
282 p_itax11 out nocopy number,
283 p_rtax11 out nocopy number,
284 p_stax11 out nocopy number,
285 -- Bug 4322981
286 p_np_dedc11 out nocopy number,
287 p_hi_dedc11 out nocopy number,
288 p_ei_dedc11 out nocopy number,
289 p_donation_dedc11 out nocopy number,
290 -- End of 4322981
291 p_non_taxable_ovs11 out nocopy number,
292 p_non_taxable_ovt11 out nocopy number,
293 p_non_taxable_oth11 out nocopy number,
294 p_effective_date12 out nocopy date,
295 p_taxable_mth12 out nocopy number,
296 p_taxable_bon12 out nocopy number,
297 p_sp_irreg_bonus12 out nocopy number,
298 p_taxable12 out nocopy number,
299 p_itax12 out nocopy number,
300 p_rtax12 out nocopy number,
301 p_stax12 out nocopy number,
302 -- Bug 4322981
303 p_np_dedc12 out nocopy number,
304 p_hi_dedc12 out nocopy number,
305 p_ei_dedc12 out nocopy number,
306 p_donation_dedc12 out nocopy number,
307 -- End of 4322981
308 p_non_taxable_ovs12 out nocopy number,
309 p_non_taxable_ovt12 out nocopy number,
310 p_non_taxable_oth12 out nocopy number,
311 p_taxable_mth13 out nocopy number,
312 p_taxable_bon13 out nocopy number,
313 p_sp_irreg_bonus13 out nocopy number,
314 p_taxable13 out nocopy number,
315 p_itax13 out nocopy number,
316 p_rtax13 out nocopy number,
317 p_stax13 out nocopy number,
318 -- Bug 4322981
319 p_np_dedc13 out nocopy number,
320 p_hi_dedc13 out nocopy number,
321 p_ei_dedc13 out nocopy number,
322 p_donation_dedc13 out nocopy number,
323 -- End of 4322981
324 p_non_taxable_ovs13 out nocopy number,
325 p_non_taxable_ovt13 out nocopy number,
326 p_non_taxable_oth13 out nocopy number,
327 --3546994
328 p_dependent_count out nocopy number,
329 p_fw_tax_break1 out nocopy number,
330 p_fw_tax_break2 out nocopy number,
331 p_fw_tax_break3 out nocopy number,
332 p_fw_tax_break4 out nocopy number,
333 p_fw_tax_break5 out nocopy number,
334 p_fw_tax_break6 out nocopy number,
335 p_fw_tax_break7 out nocopy number,
336 p_fw_tax_break8 out nocopy number,
337 p_fw_tax_break9 out nocopy number,
338 p_fw_tax_break10 out nocopy number,
339 p_fw_tax_break11 out nocopy number,
340 p_fw_tax_break12 out nocopy number,
341 --
342 -- Bug 6470526: 2007 YEA Ledger Statutory Updates
343 --
344 p_stck_pur_opt_exec_earn1 out nocopy number,
345 p_stck_pur_opt_exec_earn2 out nocopy number,
346 p_stck_pur_opt_exec_earn3 out nocopy number,
347 p_stck_pur_opt_exec_earn4 out nocopy number,
348 p_stck_pur_opt_exec_earn5 out nocopy number,
349 p_stck_pur_opt_exec_earn6 out nocopy number,
350 p_stck_pur_opt_exec_earn7 out nocopy number,
351 p_stck_pur_opt_exec_earn8 out nocopy number,
352 p_stck_pur_opt_exec_earn9 out nocopy number,
353 p_stck_pur_opt_exec_earn10 out nocopy number,
354 p_stck_pur_opt_exec_earn11 out nocopy number,
355 p_stck_pur_opt_exec_earn12 out nocopy number,
356 p_stck_pur_opt_exec_earn13 out nocopy number,
357 p_research_payment1 out nocopy number,
358 p_research_payment2 out nocopy number,
359 p_research_payment3 out nocopy number,
360 p_research_payment4 out nocopy number,
361 p_research_payment5 out nocopy number,
362 p_research_payment6 out nocopy number,
363 p_research_payment7 out nocopy number,
364 p_research_payment8 out nocopy number,
365 p_research_payment9 out nocopy number,
366 p_research_payment10 out nocopy number,
367 p_research_payment11 out nocopy number,
368 p_research_payment12 out nocopy number,
369 p_research_payment13 out nocopy number
370 -- End of Bug 6470526
371 );
372 ------------------------------------------------------------------------
373 end pay_kr_paykrylg_pkg;