[Home] [Help]
PACKAGE: APPS.PAY_JP_WIC_PKG
Source
1 package pay_jp_wic_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpwic.pkh 120.10.12020000.2 2012/10/11 11:26:12 mdubasi ship $ */
3 --
4 g_valid_term_taxable_amt number;
5 --
6 type t_tax_info is record(
7 taxable_income number := 0,
8 mutual_aid_prem number,
9 si_prem number := 0,
10 itax number := 0,
11 itax_adjustment number := 0,
12 withholding_itax number := 0,
13 disaster_tax_reduction number);
14 type t_certificate_info is record(
15 tax_info t_tax_info,
16 net_taxable_income number,
17 spouse_sp_exempt number,
18 spouse_net_taxable_income number,
19 li_prem_exempt number,
20 pp_prem number,
21 ai_prem_exempt number,
22 long_ai_prem number,
23 total_income_exempt number,
24 housing_tax_reduction number,
25 housing_residence_date date,
26 unclaimed_housing_tax_reduct number,
27 fixed_rate_tax_reduction number,
28 national_pens_prem number,
29 dep_spouse_exists_kou varchar2(1) := 'N',
33 aged_spouse_exists varchar2(1) := 'N',
30 dep_spouse_not_exist_kou varchar2(1) := 'N',
31 dep_spouse_exists_otsu varchar2(1) := 'N',
32 dep_spouse_not_exist_otsu varchar2(1) := 'N',
34 num_specifieds_kou number,
35 num_specifieds_otsu number,
36 num_aged_parents_lt number,
37 num_ageds_kou number,
38 num_ageds_otsu number,
39 num_deps_kou number,
40 num_deps_otsu number,
41 num_junior_deps number,
42 num_svr_disableds_lt number,
43 num_svr_disableds number,
44 num_disableds number,
45 husband_exists varchar2(1) := 'N',
46 minor_flag varchar2(1) := 'N',
47 otsu_flag varchar2(1) := 'N',
48 svr_disabled_flag varchar2(1) := 'N',
49 disabled_flag varchar2(1) := 'N',
50 aged_flag varchar2(1) := 'N',
51 widow_flag varchar2(1) := 'N',
52 sp_widow_flag varchar2(1) := 'N',
53 widower_flag varchar2(1) := 'N',
54 working_student_flag varchar2(1) := 'N',
55 deceased_termination_flag varchar2(1) := 'N',
56 disastered_flag varchar2(1) := 'N',
57 foreigner_flag varchar2(1) := 'N',
58 description_kanji varchar2(32767),
59 description_kana varchar2(32767),
60 desc_line1_kanji varchar2(32767),
61 desc_line1_kana varchar2(32767),
62 old_life_ins_prem number,
63 new_life_ins_prem number,
64 care_med_ins_prem number,
65 new_pen_ins_prem number );
66 --
67 type t_prev_job_info is record(
68 itax_organization_id number,
69 taxable_income number := 0,
70 mutual_aid_prem number,
71 si_prem number := 0,
72 itax number := 0,
73 foreign_address_flag varchar2(1) := 'N',
74 salary_payer_address_kanji varchar2(2000),
75 salary_payer_address_kana varchar2(2000),
76 salary_payer_name_kanji varchar2(2000),
77 salary_payer_name_kana varchar2(2000),
78 termination_date date);
79 type t_prev_jobs is table of t_prev_job_info index by binary_integer;
80 --
81 type t_dpnt_info is record(
82 contact_type_kanji hr_lookups.meaning%type,
83 contact_type_kana hr_lookups.meaning%type,
84 last_name_kanji per_all_people_f.per_information18%type,
85 last_name_kana per_all_people_f.last_name%type,
86 first_name_kanji per_all_people_f.per_information19%type,
87 first_name_kana per_all_people_f.first_name%type,
88 junior varchar2(1));
89 type t_dpnts is table of t_dpnt_info index by binary_integer;
90 --
91 type t_description_info is record(
92 description_type varchar2(30),
93 description_kanji varchar2(32767),
94 description_kana varchar2(32767));
95 type t_descriptions is table of t_description_info index by binary_integer;
96 --
97 type t_housing_rec is record(
98 residence_date date,
99 loan_type varchar2(60),
100 loan_balance number);
101 type t_housing_tbl is table of t_housing_rec index by binary_integer;
102 --
103 type t_housing_info is record(
104 payable_loan number,
105 loan_count number,
106 residence_date_1 date,
107 loan_type_1 varchar2(60),
108 loan_balance_1 number,
109 residence_date_2 date,
110 loan_type_2 varchar2(60),
111 loan_balance_2 number);
112 --
113 -- |-------------------------------------------------------------------|
114 -- |----------------------< get_ee_description >-----------------------|
115 -- |-------------------------------------------------------------------|
116 procedure get_ee_description(
117 p_assignment_id in number,
118 p_business_group_id in number,
119 p_effective_date in date,
120 p_itw_override_flag out nocopy varchar2,
121 p_itw_description out nocopy varchar2,
122 p_wtm_override_flag out nocopy varchar2,
123 p_wtm_description out nocopy varchar2);
124 -- |-------------------------------------------------------------------|
125 -- |-----------------------< get_descriptions >------------------------|
126 -- |-------------------------------------------------------------------|
127 procedure get_descriptions(
128 p_assignment_id in number,
129 p_person_id in number,
130 p_effective_date in date,
131 p_itax_yea_category in varchar2,
132 p_certificate_info in t_certificate_info,
133 p_last_name_kanji in varchar2,
134 p_last_name_kana in varchar2,
135 p_dpnts in t_dpnts,
136 p_prev_jobs in t_prev_jobs,
137 p_housing_tbl in t_housing_tbl,
138 p_report_type in varchar2, --> ITW/WTM
139 p_descriptions out nocopy t_descriptions);
140 --
141 procedure get_descriptions(
142 p_assignment_id in number,
143 p_person_id in number,
144 p_effective_date in date,
145 p_itax_yea_category in varchar2,
146 p_certificate_info in t_certificate_info,
147 p_last_name_kanji in varchar2,
148 p_last_name_kana in varchar2,
149 p_dpnts in t_dpnts,
150 p_prev_jobs in t_prev_jobs,
151 p_report_type in varchar2, --> ITW/WTM
152 p_descriptions out nocopy t_descriptions);
153 --
154 -- |-------------------------------------------------------------------|
155 -- |---------------------< get_certificate_info >----------------------|
156 -- |-------------------------------------------------------------------|
157 -- Wrapper function for ITT
158 procedure get_certificate_info(
159 p_assignment_action_id in number,
163 p_itax_organization_id in number,
160 p_assignment_id in number,
161 p_action_sequence in number,
162 p_effective_date in date,
164 p_itax_category in varchar2,
165 p_itax_yea_category in varchar2,
166 p_employment_category in varchar2,
167 p_person_id in number,
168 p_business_group_id in number,
169 p_date_earned in date,
170 p_certificate_info out nocopy t_tax_info,
171 p_submission_required_flag out nocopy varchar2,
172 p_withholding_tax_info out nocopy t_tax_info);
173 --
174 -- Following is deprecated.
175 --
176 procedure get_certificate_info(
177 p_assignment_action_id in number,
178 p_assignment_id in number,
179 p_action_sequence in number,
180 p_effective_date in date,
181 p_itax_organization_id in number,
182 p_itax_category in varchar2,
183 p_itax_yea_category in varchar2,
184 p_employment_category in varchar2,
185 p_person_id in number,
186 p_business_group_id in number,
187 p_date_earned in date,
188 p_certificate_info out nocopy t_tax_info,
189 p_submission_required_flag out nocopy varchar2,
190 p_withholding_tax_info out nocopy t_tax_info,
191 p_prev_jobs out nocopy t_prev_jobs);
192 -- |-------------------------------------------------------------------|
193 -- |---------------------< get_certificate_info >----------------------|
194 -- |-------------------------------------------------------------------|
195 --
196 -- Wrapper function for the wrapper function for WTM, ITW (called from gci_wtm, gci_itw_b : gci_b)
197 --
198 procedure get_certificate_info(
199 p_assignment_action_id in number,
200 p_assignment_id in number,
201 p_action_sequence in number,
202 p_business_group_id in number,
203 p_effective_date in date,
204 p_date_earned in date,
205 p_itax_organization_id in number,
206 p_itax_category in varchar2,
207 p_itax_yea_category in varchar2,
208 p_dpnt_ref_type in varchar2,
209 p_dpnt_effective_date in date,
210 p_person_id in number,
211 p_sex in varchar2,
212 p_date_of_birth in date,
213 p_leaving_reason in varchar2,
214 p_last_name_kanji in varchar2,
215 p_last_name_kana in varchar2,
216 p_employment_category in varchar2,
217 p_magnetic_media_flag in varchar2 default 'N',
218 p_certificate_info out nocopy t_certificate_info,
219 p_submission_required_flag out nocopy varchar2,
220 p_prev_jobs out nocopy t_prev_jobs,
221 p_housing_tbl out nocopy t_housing_tbl);
222 --
223 -- Wrapper function for WTM (used this in efile PAYJPWTM, PAYJPSPE : gci_wtm)
224 --
225 procedure get_certificate_info(
226 p_assignment_action_id in number,
227 p_assignment_id in number,
228 p_action_sequence in number,
229 p_business_group_id in number,
230 p_effective_date in date,
231 p_date_earned in date,
232 p_itax_organization_id in number,
233 p_itax_category in varchar2,
234 p_itax_yea_category in varchar2,
235 p_dpnt_ref_type in varchar2,
236 p_dpnt_effective_date in date,
237 p_person_id in number,
238 p_sex in varchar2,
239 p_date_of_birth in date,
240 p_leaving_reason in varchar2,
241 p_last_name_kanji in varchar2,
242 p_last_name_kana in varchar2,
243 p_employment_category in varchar2,
244 p_magnetic_media_flag in varchar2 default 'N',
245 p_certificate_info out nocopy t_certificate_info,
246 p_submission_required_flag out nocopy varchar2,
247 p_prev_job_info out nocopy t_prev_job_info,
248 p_housing_info out nocopy t_housing_info);
249 --
250 -- Wrapper function for existing user program (call gci_wtm for previous behavior : gci_wtm_usr)
251 --
252 procedure get_certificate_info(
253 p_assignment_action_id in number,
254 p_assignment_id in number,
255 p_action_sequence in number,
256 p_business_group_id in number,
257 p_effective_date in date,
258 p_date_earned in date,
259 p_itax_organization_id in number,
260 p_itax_category in varchar2,
261 p_itax_yea_category in varchar2,
262 p_dpnt_ref_type in varchar2,
263 p_dpnt_effective_date in date,
264 p_person_id in number,
265 p_sex in varchar2,
266 p_date_of_birth in date,
267 p_leaving_reason in varchar2,
268 p_last_name_kanji in varchar2,
269 p_last_name_kana in varchar2,
270 p_employment_category in varchar2,
271 p_magnetic_media_flag in varchar2 default 'N',
272 p_certificate_info out nocopy t_certificate_info,
273 p_submission_required_flag out nocopy varchar2,
274 p_prev_job_info out nocopy t_prev_job_info);
275 --
279 --
276 -- |-------------------------------------------------------------------|
277 -- |---------------------< get_certificate_info >----------------------|
278 -- |-------------------------------------------------------------------|
280 -- Wrapper function for ITW (called from gci_itw : gci_itw_b)
281 --
282 procedure get_certificate_info(
283 p_assignment_action_id in number,
284 p_assignment_id in number,
285 p_action_sequence in number,
286 p_business_group_id in number,
287 p_effective_date in date,
288 p_date_earned in date,
289 p_itax_organization_id in number,
290 p_itax_category in varchar2,
291 p_itax_yea_category in varchar2,
292 p_dpnt_ref_type in varchar2,
293 p_dpnt_effective_date in date,
294 p_person_id in number,
295 p_sex in varchar2,
296 p_date_of_birth in date,
297 p_leaving_reason in varchar2,
298 p_last_name_kanji in varchar2,
299 p_last_name_kana in varchar2,
300 p_employment_category in varchar2,
301 p_magnetic_media_flag in varchar2 default 'N',
302 p_certificate_info out nocopy t_certificate_info,
303 p_submission_required_flag out nocopy varchar2,
304 p_prev_jobs out nocopy t_prev_jobs,
305 p_withholding_tax_info out nocopy t_tax_info);
306 --
307 -- |-------------------------------------------------------------------|
308 -- |---------------------< get_certificate_info >----------------------|
309 -- |-------------------------------------------------------------------|
310 --
311 -- Wrapper function for Archive (used this in PAYJPITW_ARCHIVE : gci_itw_arc)
312 --
313 procedure get_certificate_info(
314 p_assignment_action_id in number,
315 p_assignment_id in number,
316 p_action_sequence in number,
317 p_business_group_id in number,
318 p_effective_date in date,
319 p_date_earned in date,
320 p_itax_organization_id in number,
321 p_itax_category in varchar2,
322 p_itax_yea_category in varchar2,
323 p_dpnt_ref_type in varchar2,
324 p_dpnt_effective_date in date,
325 p_person_id in number,
326 p_sex in varchar2,
327 p_date_of_birth in date,
328 p_leaving_reason in varchar2,
329 p_last_name_kanji in varchar2,
330 p_last_name_kana in varchar2,
331 p_employment_category in varchar2,
332 p_certificate_info out nocopy t_certificate_info,
333 p_submission_required_flag out nocopy varchar2,
334 p_prev_job_info out nocopy t_prev_job_info,
335 p_housing_info out nocopy t_housing_info,
336 p_withholding_tax_info out nocopy t_tax_info,
337 p_itw_description out nocopy varchar2,
338 p_itw_descriptions out nocopy t_descriptions,
339 p_wtm_description out nocopy varchar2,
340 p_wtm_descriptions out nocopy t_descriptions);
341 --
342 -- Wrapper function for wage ledger (used this in PAYJPWL_ARCHIVE : gci_wl_arc)
343 --
344 procedure get_certificate_info(
345 p_assignment_action_id in number,
346 p_assignment_id in number,
347 p_action_sequence in number,
348 p_business_group_id in number,
349 p_effective_date in date,
350 p_date_earned in date,
351 p_itax_organization_id in number,
352 p_itax_category in varchar2,
353 p_itax_yea_category in varchar2,
354 p_dpnt_ref_type in varchar2,
355 p_dpnt_effective_date in date,
356 p_person_id in number,
357 p_sex in varchar2,
358 p_date_of_birth in date,
359 p_leaving_reason in varchar2,
360 p_last_name_kanji in varchar2,
361 p_last_name_kana in varchar2,
362 p_employment_category in varchar2,
363 p_certificate_info out nocopy t_certificate_info,
364 p_submission_required_flag out nocopy varchar2,
365 p_prev_job_info out nocopy t_prev_job_info,
366 p_withholding_tax_info out nocopy t_tax_info,
367 p_itw_description out nocopy varchar2,
368 p_itw_descriptions out nocopy t_descriptions,
369 p_wtm_description out nocopy varchar2,
370 p_wtm_descriptions out nocopy t_descriptions);
371 --
372 -- |-------------------------------------------------------------------|
373 -- |---------------------< set_valid_term_taxable_amt >----------------|
374 -- |-------------------------------------------------------------------|
375 procedure set_valid_term_taxable_amt(
376 p_valid_term_taxable_amt in number);
377 --
378 -- |-------------------------------------------------------------------|
379 -- |---------------------< spr_term_valid >----------------------------|
380 -- |-------------------------------------------------------------------|
381 -- Use in Summary Payment Report and ITW with Term Validation
382 function spr_term_valid(
383 p_assignment_action_id in number,
384 p_assignment_id in number,
385 p_action_sequence in number,
386 p_effective_date in date,
387 p_itax_organization_id in number,
388 p_itax_category in varchar2,
389 p_itax_yea_category in varchar2,
390 p_employment_category in varchar2,
391 p_termination_date in date,
392 p_certificate_info in t_certificate_info default null)
393 return number;
394 --
395 -- |-------------------------------------------------------------------|
396 -- |---------------------< get_certificate_info >----------------------|
397 -- |-------------------------------------------------------------------|
398 --
399 -- Wrapper for ITW with Term Validation (used this in PAYJPITW : gci_itw)
400 --
401 procedure get_certificate_info(
402 p_assignment_action_id in number,
403 p_assignment_id in number,
404 p_action_sequence in number,
405 p_business_group_id in number,
406 p_effective_date in date,
407 p_date_earned in date,
408 p_itax_organization_id in number,
409 p_itax_category in varchar2,
410 p_itax_yea_category in varchar2,
411 p_dpnt_ref_type in varchar2,
412 p_dpnt_effective_date in date,
413 p_person_id in number,
414 p_sex in varchar2,
415 p_date_of_birth in date,
416 p_leaving_reason in varchar2,
417 p_last_name_kanji in varchar2,
418 p_last_name_kana in varchar2,
419 p_employment_category in varchar2,
420 p_magnetic_media_flag in varchar2 default 'N',
421 p_termination_date in date,
422 p_certificate_info out nocopy t_certificate_info,
423 p_submission_required_flag out nocopy varchar2,
424 p_prev_jobs out nocopy t_prev_jobs,
425 p_withholding_tax_info out nocopy t_tax_info,
426 p_spr_term_valid out nocopy number);
427 --
428 procedure get_prev_jobs(
429 p_assignment_id in number,
430 p_action_sequence in number,
431 p_business_group_id in number,
432 p_effective_date in date,
433 p_date_earned in date,
434 p_itax_organization_id in number,
435 p_person_id in number,
436 p_prev_jobs out nocopy t_prev_jobs);
437 --
438 -- |-------------------------------------------------------------------|
439 -- |---------------------< get_certificate_info >----------------------|
440 -- |-------------------------------------------------------------------|
441 -- For debugging purpose. NEVER USE THIS in your product code.
442 procedure get_certificate_info(
443 p_assignment_action_id in number,
444 p_magnetic_media_flag in varchar2 default 'N',
445 p_certificate_info out nocopy t_certificate_info,
446 p_submission_required_flag out nocopy varchar2,
447 p_prev_jobs out nocopy t_prev_jobs,
448 p_withholding_tax_info out nocopy t_tax_info);
449 --
450 -- Deprecated
451 --
452 FUNCTION ass_set_validation(
453 p_assignment_set_id in NUMBER,
454 p_assignment_id in NUMBER,
455 p_effective_date in DATE) RETURN NUMBER;
456 --
457 end pay_jp_wic_pkg;