1 package pay_jp_itwb_dml_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpiwba.pkh 120.0.12020000.2 2013/01/24 13:57:00 dduvvuri ship $ */
3 --
4 function next_action_information_id return number;
5 --
6 procedure copy_pai(
7 p_action_context_id in number,
8 p_effective_date in date,
9 p_action_context_id_o in number,
10 p_action_context_type in varchar2,
11 p_action_information_category in varchar2,
12 p_action_information_id out nocopy number,
13 p_object_version_number out nocopy number);
14 --
15 procedure copy_pai_type(
16 p_action_context_id in number,
17 p_effective_date in date,
18 p_action_context_id_o in number,
19 p_action_context_type in varchar2,
20 p_action_information_category in varchar2,
21 p_type in varchar2,
22 p_action_information_id out nocopy number,
23 p_object_version_number out nocopy number);
24 --
25 procedure copy_pai_item(
26 p_action_context_id in number,
27 p_effective_date in date,
28 p_action_context_id_o in number,
29 p_action_context_type in varchar2,
30 p_action_information_category in varchar2,
31 p_item_pay_id in number,
32 p_item_type in varchar2,
33 p_item_id in number,
34 p_action_information_id out nocopy number,
35 p_object_version_number out nocopy number);
36 --
37 procedure copy_pai_all_item(
38 p_action_context_id in number,
39 p_effective_date in date,
40 p_action_information_category in varchar2,
41 p_action_context_id_o in number);
42 --
43 procedure create_pact(
44 p_action_information_id in number,
45 p_payroll_action_id in number,
46 p_action_context_type in varchar2,
47 p_effective_date in date,
48 p_action_information_category in varchar2,
49 p_status in varchar2,
50 p_itax_org_id in number,
51 p_archive_sequence in number,
52 p_payroll_action_id_o in number,
53 p_object_version_number out nocopy number);
54 --
55 procedure create_itax_org(
56 p_action_information_id in number,
57 p_payroll_action_id in number,
58 p_action_context_type in varchar2,
59 p_effective_date in date,
60 p_action_information_category in varchar2,
61 p_itax_org_id in number,
62 p_name in varchar2,
63 p_name_kana in varchar2,
64 p_address1 in varchar2,
65 p_address2 in varchar2,
66 p_address_kana1 in varchar2,
67 p_address_kana2 in varchar2,
68 p_phone in varchar2,
69 p_serial1 in varchar2,
70 p_serial2 in varchar2,
71 p_object_version_number out nocopy number);
72 --
73 procedure create_assact(
74 p_action_information_id in number,
75 p_assignment_action_id in number,
76 p_action_context_type in varchar2,
77 p_assignment_id in number,
78 p_effective_date in date,
79 p_action_information_category in varchar2,
80 p_status in varchar2,
81 p_proc_assignment_action_id in number,
82 p_organization_id in number,
83 p_job_id in number,
84 p_payroll_id in number,
85 p_location_id in number,
86 p_termination_date in date,
87 p_leaving_reason in varchar2,
88 p_arch_assignment_action_id_o in number,
89 p_object_version_number out nocopy number);
90 --
91 procedure update_assact(
92 p_assignment_action_id in number,
93 p_effective_date in date,
94 p_arch_assignment_action_id_o in number,
95 p_proc_assignment_action_id in number,
96 p_proc_assact_date_o in date,
97 p_status in varchar2,
98 p_organization_id in number,
99 p_job_id in number,
100 p_payroll_id in number,
101 p_location_id in number,
102 p_termination_date in date,
103 p_leaving_reason in varchar2,
104 p_action_information_id out nocopy number,
105 p_object_version_number out nocopy number);
106 --
107 procedure add_assact(
108 p_assignment_action_id in number,
109 p_effective_date in date,
110 p_arch_assignment_action_id_o in number,
111 p_proc_assignment_action_id in number,
112 p_status in varchar2,
113 p_action_information_id out nocopy number,
114 p_object_version_number out nocopy number);
115 --
116 procedure create_emp(
117 p_action_information_id in number,
118 p_assignment_action_id in number,
119 p_action_context_type in varchar2,
120 p_assignment_id in number,
121 p_effective_date in date,
122 p_action_information_category in varchar2,
123 p_person_id in number,
124 p_employee_number in varchar2,
125 p_last_name in varchar2,
126 p_first_name in varchar2,
127 p_last_name_kana in varchar2,
128 p_first_name_kana in varchar2,
129 p_sex in varchar2,
130 p_birth_date in date,
131 p_object_version_number out nocopy number);
132 --
133 procedure update_emp(
134 p_assignment_action_id in number,
135 p_effective_date in date,
136 p_arch_assignment_action_id_o in number,
137 p_proc_assignment_action_id in number,
138 p_proc_assact_date_o in date,
139 p_person_id in number,
140 p_employee_number in varchar2,
141 p_last_name in varchar2,
142 p_first_name in varchar2,
143 p_last_name_kana in varchar2,
144 p_first_name_kana in varchar2,
145 p_sex in varchar2,
146 p_birth_date in date,
147 p_action_information_id out nocopy number,
148 p_object_version_number out nocopy number);
149 --
150 procedure create_emp_add(
151 p_action_information_id in number,
152 p_assignment_action_id in number,
153 p_action_context_type in varchar2,
154 p_assignment_id in number,
155 p_effective_date in date,
156 p_action_information_category in varchar2,
157 p_address_id in number,
158 p_address_jp in varchar2,
159 p_postal_code in varchar2,
160 p_district_code in varchar2,
161 p_address1 in varchar2,
162 p_address2 in varchar2,
163 p_address_kana1 in varchar2,
164 p_address_kana2 in varchar2,
165 p_phone1 in varchar2,
166 p_phone2 in varchar2,
167 p_object_version_number out nocopy number);
168 --
169 procedure update_emp_add(
170 p_assignment_action_id in number,
171 p_effective_date in date,
172 p_arch_assignment_action_id_o in number,
173 p_proc_assignment_action_id in number,
174 p_proc_assact_date_o in date,
175 p_address_id in number,
176 p_address_jp in varchar2,
177 p_postal_code in varchar2,
178 p_district_code in varchar2,
179 p_address1 in varchar2,
180 p_address2 in varchar2,
181 p_address_kana1 in varchar2,
182 p_address_kana2 in varchar2,
183 p_phone1 in varchar2,
184 p_phone2 in varchar2,
185 p_action_information_id out nocopy number,
186 p_object_version_number out nocopy number);
187 --
188 procedure create_emp_ass(
189 p_action_information_id in number,
190 p_assignment_action_id in number,
191 p_action_context_type in varchar2,
192 p_assignment_id in number,
193 p_effective_date in date,
194 p_action_information_category in varchar2,
195 p_hire_date in date,
196 p_organization_name in varchar2,
197 p_job_name in varchar2,
198 p_payroll_name in varchar2,
199 p_location_name in varchar2,
200 p_object_version_number out nocopy number);
201 --
202 procedure update_emp_ass(
203 p_assignment_action_id in number,
204 p_effective_date in date,
205 p_arch_assignment_action_id_o in number,
206 p_proc_assignment_action_id in number,
207 p_proc_assact_date_o in date,
208 p_hire_date in date,
209 p_organization_name in varchar2,
210 p_job_name in varchar2,
211 p_payroll_name in varchar2,
212 p_location_name in varchar2,
213 p_action_information_id out nocopy number,
214 p_object_version_number out nocopy number);
215 --
216 procedure create_emp_si(
217 p_action_information_id in number,
218 p_assignment_action_id in number,
219 p_action_context_type in varchar2,
220 p_assignment_id in number,
221 p_effective_date in date,
222 p_action_information_category in varchar2,
223 p_itax_org_id in number,
224 p_itax_type in varchar2,
225 p_hi_org_id in number,
226 p_hi_number in varchar2,
227 p_wp_org_id in number,
228 p_wp_number in varchar2,
229 p_wpf_org_id in number,
230 p_wpf_number in varchar2,
231 p_ei_org_id in number,
232 p_ei_number in varchar2,
233 p_nres_flag in varchar2,
234 p_nres_start_date in date,
235 p_projected_res_date in date,
236 p_object_version_number out nocopy number);
237 --
238 procedure update_emp_si(
239 p_assignment_action_id in number,
240 p_effective_date in date,
241 p_arch_assignment_action_id_o in number,
242 p_proc_assignment_action_id in number,
243 p_proc_assact_date_o in date,
244 p_itax_org_id in number,
245 p_itax_type in varchar2,
246 p_hi_org_id in number,
247 p_hi_number in varchar2,
248 p_wp_org_id in number,
249 p_wp_number in varchar2,
250 p_wpf_org_id in number,
251 p_wpf_number in varchar2,
252 p_ei_org_id in number,
253 p_ei_number in varchar2,
254 p_nres_flag in varchar2,
255 p_nres_start_date in date,
256 p_projected_res_date in date,
257 p_action_information_id out nocopy number,
258 p_object_version_number out nocopy number);
259 --
260 procedure create_sal_act(
261 p_action_information_id in number,
262 p_assignment_action_id in number,
263 p_action_context_type in varchar2,
264 p_assignment_id in number,
265 p_effective_date in date,
266 p_action_information_category in varchar2,
267 p_category in varchar2,
268 p_col_mth1 in varchar2,
269 p_col_mth2 in varchar2,
270 p_col_mth3 in varchar2,
271 p_col_mth4 in varchar2,
272 p_col_mth5 in varchar2,
273 p_col_mth6 in varchar2,
274 p_col_mth7 in varchar2,
275 p_col_mth8 in varchar2,
276 p_col_mth9 in varchar2,
277 p_col_mth10 in varchar2,
278 p_col_mth11 in varchar2,
279 p_col_mth12 in varchar2,
280 p_object_version_number out nocopy number);
281 --
282 procedure update_sal_act(
283 p_assignment_action_id in number,
284 p_effective_date in date,
285 p_arch_assignment_action_id_o in number,
286 p_category in varchar2,
287 p_col_mth1 in varchar2,
288 p_col_mth2 in varchar2,
289 p_col_mth3 in varchar2,
290 p_col_mth4 in varchar2,
291 p_col_mth5 in varchar2,
292 p_col_mth6 in varchar2,
293 p_col_mth7 in varchar2,
294 p_col_mth8 in varchar2,
295 p_col_mth9 in varchar2,
296 p_col_mth10 in varchar2,
297 p_col_mth11 in varchar2,
298 p_col_mth12 in varchar2,
299 p_action_information_id out nocopy number,
300 p_object_version_number out nocopy number);
301 --
302 procedure add_sal_act(
303 p_assignment_action_id in number,
304 p_effective_date in date,
305 p_arch_assignment_action_id_o in number,
306 p_category in varchar2,
307 p_col_mth1 in varchar2,
308 p_col_mth2 in varchar2,
309 p_col_mth3 in varchar2,
310 p_col_mth4 in varchar2,
311 p_col_mth5 in varchar2,
312 p_col_mth6 in varchar2,
313 p_col_mth7 in varchar2,
314 p_col_mth8 in varchar2,
315 p_col_mth9 in varchar2,
316 p_col_mth10 in varchar2,
317 p_col_mth11 in varchar2,
318 p_col_mth12 in varchar2,
319 p_action_information_id out nocopy number,
320 p_object_version_number out nocopy number);
321 --
322 procedure create_sal_pay(
323 p_action_information_id in number,
324 p_assignment_action_id in number,
325 p_action_context_type in varchar2,
326 p_assignment_id in number,
327 p_effective_date in date,
328 p_action_information_category in varchar2,
329 p_category in varchar2,
330 p_col_mth1 in number,
331 p_col_mth2 in number,
332 p_col_mth3 in number,
333 p_col_mth4 in number,
334 p_col_mth5 in number,
335 p_col_mth6 in number,
336 p_col_mth7 in number,
337 p_col_mth8 in number,
338 p_col_mth9 in number,
339 p_col_mth10 in number,
340 p_col_mth11 in number,
341 p_col_mth12 in number,
342 p_col_tot in number,
343 p_object_version_number out nocopy number);
344 --
345 procedure update_sal_pay(
346 p_assignment_action_id in number,
347 p_effective_date in date,
348 p_arch_assignment_action_id_o in number,
349 p_category in varchar2,
350 p_col_mth1 in number,
351 p_col_mth2 in number,
352 p_col_mth3 in number,
353 p_col_mth4 in number,
354 p_col_mth5 in number,
355 p_col_mth6 in number,
356 p_col_mth7 in number,
357 p_col_mth8 in number,
358 p_col_mth9 in number,
359 p_col_mth10 in number,
363 p_action_information_id out nocopy number,
360 p_col_mth11 in number,
361 p_col_mth12 in number,
362 p_col_tot in number,
364 p_object_version_number out nocopy number);
365 --
366 procedure add_sal_pay(
367 p_assignment_action_id in number,
368 p_effective_date in date,
369 p_arch_assignment_action_id_o in number,
370 p_category in varchar2,
371 p_col_mth1 in number,
372 p_col_mth2 in number,
373 p_col_mth3 in number,
374 p_col_mth4 in number,
375 p_col_mth5 in number,
376 p_col_mth6 in number,
377 p_col_mth7 in number,
378 p_col_mth8 in number,
379 p_col_mth9 in number,
380 p_col_mth10 in number,
381 p_col_mth11 in number,
382 p_col_mth12 in number,
383 p_col_tot in number,
384 p_action_information_id out nocopy number,
385 p_object_version_number out nocopy number);
386 --
387 procedure create_bon_act(
388 p_action_information_id in number,
389 p_assignment_action_id in number,
390 p_action_context_type in varchar2,
391 p_assignment_id in number,
392 p_effective_date in date,
393 p_action_information_category in varchar2,
394 p_category in varchar2,
395 p_col_cnt1 in varchar2,
396 p_col_cnt2 in varchar2,
397 p_col_cnt3 in varchar2,
398 p_col_cnt4 in varchar2,
399 p_col_cnt5 in varchar2,
400 p_col_cnt6 in varchar2,
401 p_col_cnt7 in varchar2,
402 p_col_cnt8 in varchar2,
403 p_col_cnt9 in varchar2,
404 p_col_cnt10 in varchar2,
405 p_col_cnt11 in varchar2,
406 p_col_cnt12 in varchar2,
407 p_col_cnt13 in varchar2,
408 p_col_cnt14 in varchar2,
409 p_col_cnt15 in varchar2,
410 p_object_version_number out nocopy number);
411 --
412 procedure update_bon_act(
413 p_assignment_action_id in number,
414 p_effective_date in date,
415 p_arch_assignment_action_id_o in number,
416 p_category in varchar2,
417 p_col_cnt1 in varchar2,
418 p_col_cnt2 in varchar2,
419 p_col_cnt3 in varchar2,
420 p_col_cnt4 in varchar2,
421 p_col_cnt5 in varchar2,
422 p_col_cnt6 in varchar2,
423 p_col_cnt7 in varchar2,
424 p_col_cnt8 in varchar2,
425 p_col_cnt9 in varchar2,
426 p_col_cnt10 in varchar2,
427 p_col_cnt11 in varchar2,
428 p_col_cnt12 in varchar2,
429 p_col_cnt13 in varchar2,
430 p_col_cnt14 in varchar2,
431 p_col_cnt15 in varchar2,
432 p_action_information_id out nocopy number,
433 p_object_version_number out nocopy number);
434 --
435 procedure add_bon_act(
436 p_assignment_action_id in number,
437 p_effective_date in date,
438 p_arch_assignment_action_id_o in number,
439 p_category in varchar2,
440 p_col_cnt1 in varchar2,
441 p_col_cnt2 in varchar2,
442 p_col_cnt3 in varchar2,
443 p_col_cnt4 in varchar2,
444 p_col_cnt5 in varchar2,
445 p_col_cnt6 in varchar2,
446 p_col_cnt7 in varchar2,
447 p_col_cnt8 in varchar2,
448 p_col_cnt9 in varchar2,
449 p_col_cnt10 in varchar2,
450 p_col_cnt11 in varchar2,
451 p_col_cnt12 in varchar2,
452 p_col_cnt13 in varchar2,
453 p_col_cnt14 in varchar2,
454 p_col_cnt15 in varchar2,
455 p_action_information_id out nocopy number,
456 p_object_version_number out nocopy number);
457 --
458 procedure create_bon_pay(
459 p_action_information_id in number,
460 p_assignment_action_id in number,
461 p_action_context_type in varchar2,
462 p_assignment_id in number,
463 p_effective_date in date,
464 p_action_information_category in varchar2,
465 p_category in varchar2,
466 p_col_cnt1 in varchar2,
467 p_col_cnt2 in varchar2,
468 p_col_cnt3 in varchar2,
469 p_col_cnt4 in varchar2,
470 p_col_cnt5 in varchar2,
471 p_col_cnt6 in varchar2,
472 p_col_cnt7 in varchar2,
473 p_col_cnt8 in varchar2,
474 p_col_cnt9 in varchar2,
475 p_col_cnt10 in varchar2,
476 p_col_cnt11 in varchar2,
477 p_col_cnt12 in varchar2,
478 p_col_cnt13 in varchar2,
479 p_col_cnt14 in varchar2,
480 p_col_cnt15 in varchar2,
481 p_col_tot in varchar2,
482 p_object_version_number out nocopy number);
483 --
484 procedure create_bon_pay(
485 p_action_information_id in number,
486 p_assignment_action_id in number,
490 p_action_information_category in varchar2,
487 p_action_context_type in varchar2,
488 p_assignment_id in number,
489 p_effective_date in date,
491 p_category in varchar2,
492 p_col_cnt1 in number,
493 p_col_cnt2 in number,
494 p_col_cnt3 in number,
495 p_col_cnt4 in number,
496 p_col_cnt5 in number,
497 p_col_cnt6 in number,
498 p_col_cnt7 in number,
499 p_col_cnt8 in number,
500 p_col_cnt9 in number,
501 p_col_cnt10 in number,
502 p_col_cnt11 in number,
503 p_col_cnt12 in number,
504 p_col_cnt13 in number,
505 p_col_cnt14 in number,
506 p_col_cnt15 in number,
507 p_col_tot in number,
508 p_object_version_number out nocopy number);
509 --
510 procedure update_bon_pay(
511 p_assignment_action_id in number,
512 p_effective_date in date,
513 p_arch_assignment_action_id_o in number,
514 p_category in varchar2,
515 p_col_cnt1 in varchar2,
516 p_col_cnt2 in varchar2,
517 p_col_cnt3 in varchar2,
518 p_col_cnt4 in varchar2,
519 p_col_cnt5 in varchar2,
520 p_col_cnt6 in varchar2,
521 p_col_cnt7 in varchar2,
522 p_col_cnt8 in varchar2,
523 p_col_cnt9 in varchar2,
524 p_col_cnt10 in varchar2,
525 p_col_cnt11 in varchar2,
526 p_col_cnt12 in varchar2,
527 p_col_cnt13 in varchar2,
528 p_col_cnt14 in varchar2,
529 p_col_cnt15 in varchar2,
530 p_col_tot in varchar2,
531 p_action_information_id out nocopy number,
532 p_object_version_number out nocopy number);
533 --
534 procedure update_bon_pay(
535 p_assignment_action_id in number,
536 p_effective_date in date,
537 p_arch_assignment_action_id_o in number,
538 p_category in varchar2,
539 p_col_cnt1 in number,
540 p_col_cnt2 in number,
541 p_col_cnt3 in number,
542 p_col_cnt4 in number,
543 p_col_cnt5 in number,
544 p_col_cnt6 in number,
545 p_col_cnt7 in number,
546 p_col_cnt8 in number,
547 p_col_cnt9 in number,
548 p_col_cnt10 in number,
549 p_col_cnt11 in number,
550 p_col_cnt12 in number,
551 p_col_cnt13 in number,
552 p_col_cnt14 in number,
553 p_col_cnt15 in number,
554 p_col_tot in number,
555 p_action_information_id out nocopy number,
556 p_object_version_number out nocopy number);
557 --
558 procedure add_bon_pay(
559 p_assignment_action_id in number,
560 p_effective_date in date,
561 p_arch_assignment_action_id_o in number,
562 p_category in varchar2,
563 p_col_cnt1 in varchar2,
564 p_col_cnt2 in varchar2,
565 p_col_cnt3 in varchar2,
566 p_col_cnt4 in varchar2,
567 p_col_cnt5 in varchar2,
568 p_col_cnt6 in varchar2,
569 p_col_cnt7 in varchar2,
570 p_col_cnt8 in varchar2,
571 p_col_cnt9 in varchar2,
572 p_col_cnt10 in varchar2,
573 p_col_cnt11 in varchar2,
574 p_col_cnt12 in varchar2,
575 p_col_cnt13 in varchar2,
576 p_col_cnt14 in varchar2,
577 p_col_cnt15 in varchar2,
578 p_col_tot in varchar2,
579 p_action_information_id out nocopy number,
580 p_object_version_number out nocopy number);
581 ---
582 procedure add_bon_pay(
583 p_assignment_action_id in number,
584 p_effective_date in date,
585 p_arch_assignment_action_id_o in number,
586 p_category in varchar2,
587 p_col_cnt1 in number,
588 p_col_cnt2 in number,
589 p_col_cnt3 in number,
590 p_col_cnt4 in number,
591 p_col_cnt5 in number,
592 p_col_cnt6 in number,
593 p_col_cnt7 in number,
594 p_col_cnt8 in number,
595 p_col_cnt9 in number,
596 p_col_cnt10 in number,
597 p_col_cnt11 in number,
598 p_col_cnt12 in number,
599 p_col_cnt13 in number,
600 p_col_cnt14 in number,
601 p_col_cnt15 in number,
602 p_col_tot in number,
603 p_action_information_id out nocopy number,
604 p_object_version_number out nocopy number);
605 --
606 procedure create_sal_earn(
607 p_action_information_id in number,
608 p_assignment_action_id in number,
609 p_action_context_type in varchar2,
610 p_assignment_id in number,
611 p_effective_date in date,
612 p_action_information_category in varchar2,
613 p_item_pay_id in number,
614 p_item_pay_ord in number,
618 p_item_rep_name in varchar2,
615 p_item_type in varchar2,
616 p_item_id in number,
617 p_item_rep_seq in number,
619 p_col_mth1 in number,
620 p_col_mth2 in number,
621 p_col_mth3 in number,
622 p_col_mth4 in number,
623 p_col_mth5 in number,
624 p_col_mth6 in number,
625 p_col_mth7 in number,
626 p_col_mth8 in number,
627 p_col_mth9 in number,
628 p_col_mth10 in number,
629 p_col_mth11 in number,
630 p_col_mth12 in number,
631 p_col_tot in number,
632 p_object_version_number out nocopy number);
633 --
634 procedure update_sal_earn(
635 p_assignment_action_id in number,
636 p_assignment_id in number,
637 p_effective_date in date,
638 p_arch_assignment_action_id_o in number,
639 p_item_pay_id in number,
640 p_item_pay_ord in number,
641 p_item_type in varchar2,
642 p_item_id in number,
643 p_item_rep_seq in number,
644 p_item_rep_name in varchar2,
645 p_col_mth1 in number,
646 p_col_mth2 in number,
647 p_col_mth3 in number,
648 p_col_mth4 in number,
649 p_col_mth5 in number,
650 p_col_mth6 in number,
651 p_col_mth7 in number,
652 p_col_mth8 in number,
653 p_col_mth9 in number,
654 p_col_mth10 in number,
655 p_col_mth11 in number,
656 p_col_mth12 in number,
657 p_col_tot in number,
658 p_action_information_id out nocopy number,
659 p_object_version_number out nocopy number);
660 --
661 procedure add_sal_earn(
662 p_assignment_action_id in number,
663 p_assignment_id in number,
664 p_effective_date in date,
665 p_item_pay_id in number,
666 p_item_pay_ord in number,
667 p_item_type in varchar2,
668 p_item_id in number,
669 p_item_rep_seq in number,
670 p_item_rep_name in varchar2,
671 p_col_mth1 in number,
672 p_col_mth2 in number,
673 p_col_mth3 in number,
674 p_col_mth4 in number,
675 p_col_mth5 in number,
676 p_col_mth6 in number,
677 p_col_mth7 in number,
678 p_col_mth8 in number,
679 p_col_mth9 in number,
680 p_col_mth10 in number,
681 p_col_mth11 in number,
682 p_col_mth12 in number,
683 p_col_tot in number,
684 p_action_information_id out nocopy number,
685 p_object_version_number out nocopy number);
686 --
687 procedure create_sal_dct(
688 p_action_information_id in number,
689 p_assignment_action_id in number,
690 p_action_context_type in varchar2,
691 p_assignment_id in number,
692 p_effective_date in date,
693 p_action_information_category in varchar2,
694 p_item_pay_id in number,
695 p_item_pay_ord in number,
696 p_item_type in varchar2,
697 p_item_id in number,
698 p_item_rep_seq in number,
699 p_item_rep_name in varchar2,
700 p_col_mth1 in number,
701 p_col_mth2 in number,
702 p_col_mth3 in number,
703 p_col_mth4 in number,
704 p_col_mth5 in number,
705 p_col_mth6 in number,
706 p_col_mth7 in number,
707 p_col_mth8 in number,
708 p_col_mth9 in number,
709 p_col_mth10 in number,
710 p_col_mth11 in number,
711 p_col_mth12 in number,
712 p_col_tot in number,
713 p_object_version_number out nocopy number);
714 --
715 procedure update_sal_dct(
716 p_assignment_action_id in number,
717 p_assignment_id in number,
718 p_effective_date in date,
719 p_arch_assignment_action_id_o in number,
720 p_item_pay_id in number,
721 p_item_pay_ord in number,
722 p_item_type in varchar2,
723 p_item_id in number,
724 p_item_rep_seq in number,
725 p_item_rep_name in varchar2,
726 p_col_mth1 in number,
727 p_col_mth2 in number,
728 p_col_mth3 in number,
729 p_col_mth4 in number,
730 p_col_mth5 in number,
731 p_col_mth6 in number,
732 p_col_mth7 in number,
733 p_col_mth8 in number,
734 p_col_mth9 in number,
735 p_col_mth10 in number,
736 p_col_mth11 in number,
737 p_col_mth12 in number,
738 p_col_tot in number,
739 p_action_information_id out nocopy number,
740 p_object_version_number out nocopy number);
741 --
742 procedure add_sal_dct(
743 p_assignment_action_id in number,
747 p_item_pay_ord in number,
744 p_assignment_id in number,
745 p_effective_date in date,
746 p_item_pay_id in number,
748 p_item_type in varchar2,
749 p_item_id in number,
750 p_item_rep_seq in number,
751 p_item_rep_name in varchar2,
752 p_col_mth1 in number,
753 p_col_mth2 in number,
754 p_col_mth3 in number,
755 p_col_mth4 in number,
756 p_col_mth5 in number,
757 p_col_mth6 in number,
758 p_col_mth7 in number,
759 p_col_mth8 in number,
760 p_col_mth9 in number,
761 p_col_mth10 in number,
762 p_col_mth11 in number,
763 p_col_mth12 in number,
764 p_col_tot in number,
765 p_action_information_id out nocopy number,
766 p_object_version_number out nocopy number);
767 --
768 procedure create_bon_earn(
769 p_action_information_id in number,
770 p_assignment_action_id in number,
771 p_action_context_type in varchar2,
772 p_assignment_id in number,
773 p_effective_date in date,
774 p_action_information_category in varchar2,
775 p_item_pay_id in number,
776 p_item_pay_ord in number,
777 p_item_type in varchar2,
778 p_item_id in number,
779 p_item_rep_seq in number,
780 p_item_rep_name in varchar2,
781 p_col_cnt1 in number,
782 p_col_cnt2 in number,
783 p_col_cnt3 in number,
784 p_col_cnt4 in number,
785 p_col_cnt5 in number,
786 p_col_cnt6 in number,
787 p_col_cnt7 in number,
788 p_col_cnt8 in number,
789 p_col_cnt9 in number,
790 p_col_cnt10 in number,
791 p_col_cnt11 in number,
792 p_col_cnt12 in number,
793 p_col_cnt13 in number,
794 p_col_cnt14 in number,
795 p_col_cnt15 in number,
796 p_col_tot in number,
797 p_object_version_number out nocopy number);
798 --
799 procedure update_bon_earn(
800 p_assignment_action_id in number,
801 p_assignment_id in number,
802 p_effective_date in date,
803 p_arch_assignment_action_id_o in number,
804 p_item_pay_id in number,
805 p_item_pay_ord in number,
806 p_item_type in varchar2,
807 p_item_id in number,
808 p_item_rep_seq in number,
809 p_item_rep_name in varchar2,
810 p_col_cnt1 in number,
811 p_col_cnt2 in number,
812 p_col_cnt3 in number,
813 p_col_cnt4 in number,
814 p_col_cnt5 in number,
815 p_col_cnt6 in number,
816 p_col_cnt7 in number,
817 p_col_cnt8 in number,
818 p_col_cnt9 in number,
819 p_col_cnt10 in number,
820 p_col_cnt11 in number,
821 p_col_cnt12 in number,
822 p_col_cnt13 in number,
823 p_col_cnt14 in number,
824 p_col_cnt15 in number,
825 p_col_tot in number,
826 p_action_information_id out nocopy number,
827 p_object_version_number out nocopy number);
828 --
829 procedure add_bon_earn(
830 p_assignment_action_id in number,
831 p_assignment_id in number,
832 p_effective_date in date,
833 p_item_pay_id in number,
834 p_item_pay_ord in number,
835 p_item_type in varchar2,
836 p_item_id in number,
837 p_item_rep_seq in number,
838 p_item_rep_name in varchar2,
839 p_col_cnt1 in number,
840 p_col_cnt2 in number,
841 p_col_cnt3 in number,
842 p_col_cnt4 in number,
843 p_col_cnt5 in number,
844 p_col_cnt6 in number,
845 p_col_cnt7 in number,
846 p_col_cnt8 in number,
847 p_col_cnt9 in number,
848 p_col_cnt10 in number,
849 p_col_cnt11 in number,
850 p_col_cnt12 in number,
851 p_col_cnt13 in number,
852 p_col_cnt14 in number,
853 p_col_cnt15 in number,
854 p_col_tot in number,
855 p_action_information_id out nocopy number,
856 p_object_version_number out nocopy number);
857 --
858 procedure create_bon_dct(
859 p_action_information_id in number,
860 p_assignment_action_id in number,
861 p_action_context_type in varchar2,
862 p_assignment_id in number,
863 p_effective_date in date,
864 p_action_information_category in varchar2,
865 p_item_pay_id in number,
866 p_item_pay_ord in number,
867 p_item_type in varchar2,
868 p_item_id in number,
869 p_item_rep_seq in number,
870 p_item_rep_name in varchar2,
871 p_col_cnt1 in number,
875 p_col_cnt5 in number,
872 p_col_cnt2 in number,
873 p_col_cnt3 in number,
874 p_col_cnt4 in number,
876 p_col_cnt6 in number,
877 p_col_cnt7 in number,
878 p_col_cnt8 in number,
879 p_col_cnt9 in number,
880 p_col_cnt10 in number,
881 p_col_cnt11 in number,
882 p_col_cnt12 in number,
883 p_col_cnt13 in number,
884 p_col_cnt14 in number,
885 p_col_cnt15 in number,
886 p_col_tot in number,
887 p_object_version_number out nocopy number);
888 --
889 procedure update_bon_dct(
890 p_assignment_action_id in number,
891 p_assignment_id in number,
892 p_effective_date in date,
893 p_arch_assignment_action_id_o in number,
894 p_item_pay_id in number,
895 p_item_pay_ord in number,
896 p_item_type in varchar2,
897 p_item_id in number,
898 p_item_rep_seq in number,
899 p_item_rep_name in varchar2,
900 p_col_cnt1 in number,
901 p_col_cnt2 in number,
902 p_col_cnt3 in number,
903 p_col_cnt4 in number,
904 p_col_cnt5 in number,
905 p_col_cnt6 in number,
906 p_col_cnt7 in number,
907 p_col_cnt8 in number,
908 p_col_cnt9 in number,
909 p_col_cnt10 in number,
910 p_col_cnt11 in number,
911 p_col_cnt12 in number,
912 p_col_cnt13 in number,
913 p_col_cnt14 in number,
914 p_col_cnt15 in number,
915 p_col_tot in number,
916 p_action_information_id out nocopy number,
917 p_object_version_number out nocopy number);
918 --
919 procedure add_bon_dct(
920 p_assignment_action_id in number,
921 p_assignment_id in number,
922 p_effective_date in date,
923 p_item_pay_id in number,
924 p_item_pay_ord in number,
925 p_item_type in varchar2,
926 p_item_id in number,
927 p_item_rep_seq in number,
928 p_item_rep_name in varchar2,
929 p_col_cnt1 in number,
930 p_col_cnt2 in number,
931 p_col_cnt3 in number,
932 p_col_cnt4 in number,
933 p_col_cnt5 in number,
934 p_col_cnt6 in number,
935 p_col_cnt7 in number,
936 p_col_cnt8 in number,
937 p_col_cnt9 in number,
938 p_col_cnt10 in number,
939 p_col_cnt11 in number,
940 p_col_cnt12 in number,
941 p_col_cnt13 in number,
942 p_col_cnt14 in number,
943 p_col_cnt15 in number,
944 p_col_tot in number,
945 p_action_information_id out nocopy number,
946 p_object_version_number out nocopy number);
947 --
948 procedure create_wrk(
949 p_action_information_id in number,
950 p_assignment_action_id in number,
951 p_action_context_type in varchar2,
952 p_assignment_id in number,
953 p_effective_date in date,
954 p_action_information_category in varchar2,
955 p_item_pay_id in number,
956 p_item_pay_ord in number,
957 p_item_type in varchar2,
958 p_item_id in number,
959 p_item_rep_seq in number,
960 p_item_rep_name in varchar2,
961 p_col_mth1 in number,
962 p_col_mth2 in number,
963 p_col_mth3 in number,
964 p_col_mth4 in number,
965 p_col_mth5 in number,
966 p_col_mth6 in number,
967 p_col_mth7 in number,
968 p_col_mth8 in number,
969 p_col_mth9 in number,
970 p_col_mth10 in number,
971 p_col_mth11 in number,
972 p_col_mth12 in number,
973 p_col_tot in number,
974 p_object_version_number out nocopy number);
975 --
976 procedure update_wrk(
977 p_assignment_action_id in number,
978 p_assignment_id in number,
979 p_effective_date in date,
980 p_arch_assignment_action_id_o in number,
981 p_item_pay_id in number,
982 p_item_pay_ord in number,
983 p_item_type in varchar2,
984 p_item_id in number,
985 p_item_rep_seq in number,
986 p_item_rep_name in varchar2,
987 p_col_mth1 in number,
988 p_col_mth2 in number,
989 p_col_mth3 in number,
990 p_col_mth4 in number,
991 p_col_mth5 in number,
992 p_col_mth6 in number,
993 p_col_mth7 in number,
994 p_col_mth8 in number,
995 p_col_mth9 in number,
996 p_col_mth10 in number,
997 p_col_mth11 in number,
998 p_col_mth12 in number,
999 p_col_tot in number,
1003 procedure add_wrk(
1000 p_action_information_id out nocopy number,
1001 p_object_version_number out nocopy number);
1002 --
1004 p_assignment_action_id in number,
1005 p_assignment_id in number,
1006 p_effective_date in date,
1007 p_item_pay_id in number,
1008 p_item_pay_ord in number,
1009 p_item_type in varchar2,
1010 p_item_id in number,
1011 p_item_rep_seq in number,
1012 p_item_rep_name in varchar2,
1013 p_col_mth1 in number,
1014 p_col_mth2 in number,
1015 p_col_mth3 in number,
1016 p_col_mth4 in number,
1017 p_col_mth5 in number,
1018 p_col_mth6 in number,
1019 p_col_mth7 in number,
1020 p_col_mth8 in number,
1021 p_col_mth9 in number,
1022 p_col_mth10 in number,
1023 p_col_mth11 in number,
1024 p_col_mth12 in number,
1025 p_col_tot in number,
1026 p_action_information_id out nocopy number,
1027 p_object_version_number out nocopy number);
1028 --
1029 procedure create_pjob(
1030 p_action_information_id in number,
1031 p_assignment_action_id in number,
1032 p_action_context_type in varchar2,
1033 p_assignment_id in number,
1034 p_effective_date in date,
1035 p_action_information_category in varchar2,
1036 p_term_date in date,
1037 p_employer_name in varchar2,
1038 p_employer_name_kana in varchar2,
1039 p_employer_address in varchar2,
1040 p_employer_address_kana in varchar2,
1041 p_txbl_inc in number,
1042 p_si_prem in number,
1043 p_mutual_aid_prem in number,
1044 p_itax in number,
1045 p_object_version_number out nocopy number);
1046 --
1047 procedure update_pjob(
1048 p_assignment_action_id in number,
1049 p_assignment_id in number,
1050 p_effective_date in date,
1051 p_arch_assignment_action_id_o in number,
1052 p_proc_assignment_action_id in number,
1053 p_proc_assact_date_o in date,
1054 p_term_date in date,
1055 p_employer_name in varchar2,
1056 p_employer_name_kana in varchar2,
1057 p_employer_address in varchar2,
1058 p_employer_address_kana in varchar2,
1059 p_txbl_inc in number,
1060 p_si_prem in number,
1061 p_mutual_aid_prem in number,
1062 p_itax in number,
1063 p_action_information_id out nocopy number,
1064 p_object_version_number out nocopy number);
1065 --
1066 procedure copy_pjob(
1067 p_assignment_action_id in number,
1068 p_effective_date in date,
1069 p_arch_assignment_action_id_o in number);
1070 --
1071 procedure create_dep(
1072 p_action_information_id in number,
1073 p_assignment_action_id in number,
1074 p_action_context_type in varchar2,
1075 p_assignment_id in number,
1076 p_effective_date in date,
1077 p_action_information_category in varchar2,
1078 p_dep_itax_type in varchar2,
1079 p_declare_flag in varchar2,
1080 p_spouse_type in varchar2,
1081 p_spouse_flag in varchar2,
1082 p_dep_spouse in varchar2,
1083 p_aged_dep_spouse in varchar2,
1084 p_ord_dep_num in number,
1085 p_sp_dep_num in number,
1086 p_aged_parent_dep_lt_num in number,
1087 p_aged_dep_num in number,
1088 p_ord_disable_num in number,
1089 p_sp_disable_num in number,
1090 p_sp_disable_lt_num in number,
1091 p_disable_type in varchar2,
1092 p_widow_type in varchar2,
1093 p_working_student_type in varchar2,
1094 p_otsu_spouse_dep_num in number,
1095 p_non_res_flag in varchar2,
1096 p_object_version_number out nocopy number);
1097 --
1098 procedure update_dep(
1099 p_assignment_action_id in number,
1100 p_effective_date in date,
1101 p_arch_assignment_action_id_o in number,
1102 p_proc_assignment_action_id in number,
1103 p_dep_itax_type in varchar2,
1104 p_declare_flag in varchar2,
1105 p_spouse_type in varchar2,
1106 p_spouse_flag in varchar2,
1107 p_dep_spouse in varchar2,
1108 p_aged_dep_spouse in varchar2,
1109 p_ord_dep_num in number,
1110 p_sp_dep_num in number,
1111 p_aged_parent_dep_lt_num in number,
1112 p_aged_dep_num in number,
1113 p_ord_disable_num in number,
1114 p_sp_disable_num in number,
1115 p_sp_disable_lt_num in number,
1116 p_disable_type in varchar2,
1117 p_widow_type in varchar2,
1118 p_working_student_type in varchar2,
1119 p_otsu_spouse_dep_num in number,
1120 p_non_res_flag in varchar2,
1121 p_action_information_id out nocopy number,
1122 p_object_version_number out nocopy number);
1123 --
1124 procedure create_yea_act(
1125 p_action_information_id in number,
1126 p_assignment_action_id in number,
1127 p_action_context_type in varchar2,
1128 p_assignment_id in number,
1129 p_effective_date in date,
1133 p_erd in date,
1130 p_action_information_category in varchar2,
1131 p_act in number,
1132 p_efd in date,
1134 p_pay in number,
1135 p_yea_type in varchar2,
1136 p_yea_flag in varchar2,
1137 p_object_version_number out nocopy number);
1138 --
1139 procedure update_yea_act(
1140 p_assignment_action_id in number,
1141 p_effective_date in date,
1142 p_arch_assignment_action_id_o in number,
1143 p_proc_assignment_action_id in number,
1144 p_proc_assact_date_o in date,
1145 p_act in number,
1146 p_efd in date,
1147 p_erd in date,
1148 p_pay in number,
1149 p_yea_type in varchar2,
1150 p_yea_flag in varchar2,
1151 p_action_information_id out nocopy number,
1152 p_object_version_number out nocopy number);
1153 --
1154 procedure add_yea_act(
1155 p_assignment_action_id in number,
1156 p_effective_date in date,
1157 p_arch_assignment_action_id_o in number,
1158 p_act in number,
1159 p_efd in date,
1160 p_erd in date,
1161 p_pay in number,
1162 p_yea_type in varchar2,
1163 p_yea_flag in varchar2,
1164 p_action_information_id out nocopy number,
1165 p_object_version_number out nocopy number);
1166 --
1167 procedure create_yea_pay(
1168 p_action_information_id in number,
1169 p_assignment_action_id in number,
1170 p_action_context_type in varchar2,
1171 p_assignment_id in number,
1172 p_effective_date in date,
1173 p_action_information_category in varchar2,
1174 p_sal_txbl_mon in number,
1175 p_sal_txbl_kind in number,
1176 p_sal_txbl in number,
1177 p_bon_txbl_mon in number,
1178 p_bon_txbl_kind in number,
1179 p_bon_txbl in number,
1180 p_spb_txbl_mon in number,
1181 p_spb_txbl_kind in number,
1182 p_spb_txbl in number,
1183 p_bon_txbl_tot in number,
1184 p_txbl in number,
1185 p_sal_itx in number,
1186 p_bon_itx in number,
1187 p_spb_itx in number,
1188 p_bon_itx_tot in number,
1189 p_withhold_itx in number,
1190 p_object_version_number out nocopy number);
1191 --
1192 procedure update_yea_pay(
1193 p_assignment_action_id in number,
1194 p_effective_date in date,
1195 p_arch_assignment_action_id_o in number,
1196 p_proc_assignment_action_id in number,
1197 p_proc_assact_date_o in date,
1198 p_sal_txbl_mon in number,
1199 p_sal_txbl_kind in number,
1200 p_sal_txbl in number,
1201 p_bon_txbl_mon in number,
1202 p_bon_txbl_kind in number,
1203 p_bon_txbl in number,
1204 p_spb_txbl_mon in number,
1205 p_spb_txbl_kind in number,
1206 p_spb_txbl in number,
1207 p_bon_txbl_tot in number,
1208 p_txbl in number,
1209 p_sal_itx in number,
1210 p_bon_itx in number,
1211 p_spb_itx in number,
1212 p_bon_itx_tot in number,
1213 p_withhold_itx in number,
1214 p_action_information_id out nocopy number,
1215 p_object_version_number out nocopy number);
1216 --
1217 procedure add_yea_pay(
1218 p_assignment_action_id in number,
1219 p_effective_date in date,
1220 p_arch_assignment_action_id_o in number,
1221 p_sal_txbl_mon in number,
1222 p_sal_txbl_kind in number,
1223 p_sal_txbl in number,
1224 p_bon_txbl_mon in number,
1225 p_bon_txbl_kind in number,
1226 p_bon_txbl in number,
1227 p_spb_txbl_mon in number,
1228 p_spb_txbl_kind in number,
1229 p_spb_txbl in number,
1230 p_bon_txbl_tot in number,
1231 p_txbl in number,
1232 p_sal_itx in number,
1233 p_bon_itx in number,
1234 p_spb_itx in number,
1235 p_bon_itx_tot in number,
1236 p_withhold_itx in number,
1237 p_action_information_id out nocopy number,
1238 p_object_version_number out nocopy number);
1239 --
1240 procedure create_yea_dct(
1241 p_action_information_id in number,
1242 p_assignment_action_id in number,
1243 p_action_context_type in varchar2,
1244 p_assignment_id in number,
1245 p_effective_date in date,
1246 p_action_information_category in varchar2,
1247 p_sal_dct_si_prem in number,
1248 p_dec_si_prem in number,
1249 p_dec_small_comp_mut_aid_prem in number,
1250 p_life_ins_prem_exm in number,
1251 p_earthquake_ins_prem_exm in number,
1252 p_spouse_sp_exm in number,
1253 p_basic_exm in number,
1254 p_gen_spouse_exm in number,
1255 p_elder_spouse_exm in number,
1256 p_gen_dep_exm in number,
1257 p_specific_dep_exm in number,
1258 p_junior_dep_exm in number,
1259 p_elder_dep_exm in number,
1263 p_sev_disabled_lt_exm in number,
1260 p_elder_parent_lt_exm in number,
1261 p_gen_disabled_exm in number,
1262 p_sev_disabled_exm in number,
1264 p_elder_exm in number,
1265 p_widow_exm in number,
1266 p_sp_widow_exm in number,
1267 p_working_student_exm in number,
1268 p_dep_exm in number,
1269 p_spouse_income in number,
1270 p_individual_pension_prem in number,
1271 p_long_term_nonlife_ins_prem in number,
1272 p_small_comp_mut_aid_prem in number,
1273 p_national_pension_prem in number,
1274 p_income_exm in number,
1275 p_object_version_number out nocopy number);
1276 --
1277 procedure update_yea_dct(
1278 p_assignment_action_id in number,
1279 p_effective_date in date,
1280 p_arch_assignment_action_id_o in number,
1281 p_proc_assignment_action_id in number,
1282 p_proc_assact_date_o in date,
1283 p_sal_dct_si_prem in number,
1284 p_dec_si_prem in number,
1285 p_dec_small_comp_mut_aid_prem in number,
1286 p_life_ins_prem_exm in number,
1287 p_earthquake_ins_prem_exm in number,
1288 p_spouse_sp_exm in number,
1289 p_basic_exm in number,
1290 p_gen_spouse_exm in number,
1291 p_elder_spouse_exm in number,
1292 p_gen_dep_exm in number,
1293 p_specific_dep_exm in number,
1294 p_junior_dep_exm in number,
1295 p_elder_dep_exm in number,
1296 p_elder_parent_lt_exm in number,
1297 p_gen_disabled_exm in number,
1298 p_sev_disabled_exm in number,
1299 p_sev_disabled_lt_exm in number,
1300 p_elder_exm in number,
1301 p_widow_exm in number,
1302 p_sp_widow_exm in number,
1303 p_working_student_exm in number,
1304 p_dep_exm in number,
1305 p_spouse_income in number,
1306 p_individual_pension_prem in number,
1307 p_long_term_nonlife_ins_prem in number,
1308 p_small_comp_mut_aid_prem in number,
1309 p_national_pension_prem in number,
1310 p_income_exm in number,
1311 p_action_information_id out nocopy number,
1312 p_object_version_number out nocopy number);
1313 --
1314 procedure add_yea_dct(
1315 p_assignment_action_id in number,
1316 p_effective_date in date,
1317 p_arch_assignment_action_id_o in number,
1318 p_sal_dct_si_prem in number,
1319 p_dec_si_prem in number,
1320 p_dec_small_comp_mut_aid_prem in number,
1321 p_life_ins_prem_exm in number,
1322 p_earthquake_ins_prem_exm in number,
1323 p_spouse_sp_exm in number,
1324 p_basic_exm in number,
1325 p_gen_spouse_exm in number,
1326 p_elder_spouse_exm in number,
1327 p_gen_dep_exm in number,
1328 p_specific_dep_exm in number,
1329 p_junior_dep_exm in number,
1330 p_elder_dep_exm in number,
1331 p_elder_parent_lt_exm in number,
1332 p_gen_disabled_exm in number,
1333 p_sev_disabled_exm in number,
1334 p_sev_disabled_lt_exm in number,
1335 p_elder_exm in number,
1336 p_widow_exm in number,
1337 p_sp_widow_exm in number,
1338 p_working_student_exm in number,
1339 p_dep_exm in number,
1340 p_spouse_income in number,
1341 p_individual_pension_prem in number,
1342 p_long_term_nonlife_ins_prem in number,
1343 p_small_comp_mut_aid_prem in number,
1344 p_national_pension_prem in number,
1345 p_income_exm in number,
1346 p_action_information_id out nocopy number,
1347 p_object_version_number out nocopy number);
1348 --
1349 procedure create_yea_tax(
1350 p_action_information_id in number,
1351 p_assignment_action_id in number,
1352 p_action_context_type in varchar2,
1353 p_assignment_id in number,
1354 p_effective_date in date,
1355 p_action_information_category in varchar2,
1356 p_amt_aft_emp_inc_dct in number,
1357 p_net_txbl_income in number,
1358 p_annual_tax in number,
1359 p_act_housing_loan_tax_credit in number,
1360 p_yea_annual_tax in number,
1361 p_yea_income_tax in number,
1362 p_yea_tax_pay in number,
1363 p_object_version_number out nocopy number);
1364 --
1365 procedure update_yea_tax(
1366 p_assignment_action_id in number,
1367 p_effective_date in date,
1368 p_arch_assignment_action_id_o in number,
1369 p_proc_assignment_action_id in number,
1370 p_proc_assact_date_o in date,
1371 p_amt_aft_emp_inc_dct in number,
1372 p_net_txbl_income in number,
1373 p_annual_tax in number,
1374 p_act_housing_loan_tax_credit in number,
1375 p_yea_annual_tax in number,
1376 p_yea_income_tax in number,
1377 p_yea_tax_pay in number,
1378 p_action_information_id out nocopy number,
1379 p_object_version_number out nocopy number);
1380 --
1381 procedure add_yea_tax(
1382 p_assignment_action_id in number,
1383 p_effective_date in date,
1384 p_arch_assignment_action_id_o in number,
1385 p_amt_aft_emp_inc_dct in number,
1386 p_net_txbl_income in number,
1387 p_annual_tax in number,
1388 p_act_housing_loan_tax_credit in number,
1392 p_action_information_id out nocopy number,
1389 p_yea_annual_tax in number,
1390 p_yea_income_tax in number,
1391 p_yea_tax_pay in number,
1393 p_object_version_number out nocopy number);
1394 --
1395 procedure create_emp_cust(
1396 p_action_information_id in number,
1397 p_assignment_action_id in number,
1398 p_action_context_type in varchar2,
1399 p_assignment_id in number,
1400 p_effective_date in date,
1401 p_action_information_category in varchar2,
1402 p_data_type in varchar2,
1403 p_information1 in varchar2,
1404 p_information2 in varchar2,
1405 p_information3 in varchar2,
1406 p_information4 in varchar2,
1407 p_information5 in varchar2,
1408 p_information6 in varchar2,
1409 p_information7 in varchar2,
1410 p_information8 in varchar2,
1411 p_information9 in varchar2,
1412 p_information10 in varchar2,
1413 p_information11 in varchar2,
1414 p_information12 in varchar2,
1415 p_information13 in varchar2,
1416 p_information14 in varchar2,
1417 p_information15 in varchar2,
1418 p_information16 in varchar2,
1419 p_information17 in varchar2,
1420 p_information18 in varchar2,
1421 p_information19 in varchar2,
1422 p_information20 in varchar2,
1423 p_information21 in varchar2,
1424 p_information22 in varchar2,
1425 p_information23 in varchar2,
1426 p_information24 in varchar2,
1427 p_information25 in varchar2,
1428 p_object_version_number out nocopy number);
1429 --
1430 procedure update_emp_cust(
1431 p_assignment_action_id in number,
1432 p_assignment_id in number,
1433 p_effective_date in date,
1434 p_arch_assignment_action_id_o in number,
1435 p_data_type in varchar2,
1436 p_information1 in varchar2,
1437 p_information2 in varchar2,
1438 p_information3 in varchar2,
1439 p_information4 in varchar2,
1440 p_information5 in varchar2,
1441 p_information6 in varchar2,
1442 p_information7 in varchar2,
1443 p_information8 in varchar2,
1444 p_information9 in varchar2,
1445 p_information10 in varchar2,
1446 p_information11 in varchar2,
1447 p_information12 in varchar2,
1448 p_information13 in varchar2,
1449 p_information14 in varchar2,
1450 p_information15 in varchar2,
1451 p_information16 in varchar2,
1452 p_information17 in varchar2,
1453 p_information18 in varchar2,
1454 p_information19 in varchar2,
1455 p_information20 in varchar2,
1456 p_information21 in varchar2,
1457 p_information22 in varchar2,
1458 p_information23 in varchar2,
1459 p_information24 in varchar2,
1460 p_information25 in varchar2,
1461 p_action_information_id out nocopy number,
1462 p_object_version_number out nocopy number);
1463 --
1464 procedure create_emp_cust(
1465 p_action_information_id in number,
1466 p_assignment_action_id in number,
1467 p_action_context_type in varchar2,
1468 p_assignment_id in number,
1469 p_effective_date in date,
1470 p_action_information_category in varchar2,
1471 p_data_type in varchar2,
1472 p_information1 in date,
1473 p_information2 in date,
1474 p_information3 in date,
1475 p_information4 in date,
1476 p_information5 in date,
1477 p_information6 in date,
1478 p_information7 in date,
1479 p_information8 in date,
1480 p_information9 in date,
1481 p_information10 in date,
1482 p_information11 in date,
1483 p_information12 in date,
1484 p_information13 in date,
1485 p_information14 in date,
1486 p_information15 in date,
1487 p_information16 in date,
1488 p_information17 in date,
1489 p_information18 in date,
1490 p_information19 in date,
1491 p_information20 in date,
1492 p_information21 in date,
1493 p_information22 in date,
1494 p_information23 in date,
1495 p_information24 in date,
1496 p_information25 in date,
1497 p_object_version_number out nocopy number);
1498 --
1499 procedure create_emp_cust(
1500 p_action_information_id in number,
1501 p_assignment_action_id in number,
1502 p_action_context_type in varchar2,
1503 p_assignment_id in number,
1504 p_effective_date in date,
1505 p_action_information_category in varchar2,
1506 p_data_type in varchar2,
1507 p_information1 in number,
1508 p_information2 in number,
1509 p_information3 in number,
1510 p_information4 in number,
1511 p_information5 in number,
1512 p_information6 in number,
1513 p_information7 in number,
1514 p_information8 in number,
1515 p_information9 in number,
1519 p_information13 in number,
1516 p_information10 in number,
1517 p_information11 in number,
1518 p_information12 in number,
1520 p_information14 in number,
1521 p_information15 in number,
1522 p_information16 in number,
1523 p_information17 in number,
1524 p_information18 in number,
1525 p_information19 in number,
1526 p_information20 in number,
1527 p_information21 in number,
1528 p_information22 in number,
1529 p_information23 in number,
1530 p_information24 in number,
1531 p_information25 in number,
1532 p_object_version_number out nocopy number);
1533 --
1534 procedure update_emp_cust(
1535 p_assignment_action_id in number,
1536 p_assignment_id in number,
1537 p_effective_date in date,
1538 p_arch_assignment_action_id_o in number,
1539 p_data_type in varchar2,
1540 p_information1 in date,
1541 p_information2 in date,
1542 p_information3 in date,
1543 p_information4 in date,
1544 p_information5 in date,
1545 p_information6 in date,
1546 p_information7 in date,
1547 p_information8 in date,
1548 p_information9 in date,
1549 p_information10 in date,
1550 p_information11 in date,
1551 p_information12 in date,
1552 p_information13 in date,
1553 p_information14 in date,
1554 p_information15 in date,
1555 p_information16 in date,
1556 p_information17 in date,
1557 p_information18 in date,
1558 p_information19 in date,
1559 p_information20 in date,
1560 p_information21 in date,
1561 p_information22 in date,
1562 p_information23 in date,
1563 p_information24 in date,
1564 p_information25 in date,
1565 p_action_information_id out nocopy number,
1566 p_object_version_number out nocopy number);
1567 --
1568 procedure update_emp_cust(
1569 p_assignment_action_id in number,
1570 p_assignment_id in number,
1571 p_effective_date in date,
1572 p_arch_assignment_action_id_o in number,
1573 p_data_type in varchar2,
1574 p_information1 in number,
1575 p_information2 in number,
1576 p_information3 in number,
1577 p_information4 in number,
1578 p_information5 in number,
1579 p_information6 in number,
1580 p_information7 in number,
1581 p_information8 in number,
1582 p_information9 in number,
1583 p_information10 in number,
1584 p_information11 in number,
1585 p_information12 in number,
1586 p_information13 in number,
1587 p_information14 in number,
1588 p_information15 in number,
1589 p_information16 in number,
1590 p_information17 in number,
1591 p_information18 in number,
1592 p_information19 in number,
1593 p_information20 in number,
1594 p_information21 in number,
1595 p_information22 in number,
1596 p_information23 in number,
1597 p_information24 in number,
1598 p_information25 in number,
1599 p_action_information_id out nocopy number,
1600 p_object_version_number out nocopy number);
1601 --
1602 procedure select_item_info(
1603 p_itax_organization_id in number,
1604 p_effective_date in date);
1605 --
1606 procedure insert_item_info(
1607 p_business_group_id in number,
1608 p_itax_organization_id in number,
1609 p_effective_date in date,
1610 p_payroll_id in number,
1611 p_category in varchar2,
1612 p_type in varchar2,
1613 p_element_type_id in number,
1614 p_input_value_id in number,
1615 p_balance_type_id in number,
1616 p_defined_balance_id in number,
1617 p_report_name in varchar2,
1618 p_report_sequence in number,
1619 p_null_valid in varchar2,
1620 p_validate in boolean default true);
1621 --
1622 procedure insert_item_info(
1623 p_business_group_id in number,
1624 p_itax_organization_id in number,
1625 p_effective_date in date,
1626 p_payroll_id in number,
1627 p_category in varchar2,
1628 p_type in varchar2,
1629 p_item_business_group_id in number,
1630 p_item_legislation_code in varchar2,
1631 p_element_name in varchar2,
1632 p_input_value_name in varchar2,
1633 p_balance_name in varchar2,
1634 p_dimension_name in varchar2,
1635 p_report_name in varchar2,
1636 p_report_sequence in number,
1637 p_null_valid in varchar2,
1638 p_validate in boolean default true);
1639 --
1640 procedure delete_item_info(
1641 p_itax_organization_id in number,
1642 p_effective_date in date,
1643 p_payroll_id in number,
1644 p_category in varchar2,
1645 p_type in varchar2,
1646 p_item_id in number);
1647 --
1648 end pay_jp_itwb_dml_pkg;
[Home] [Help]