1 package pay_jp_isdf_dml_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpisfa.pkh 120.3.12020000.3 2012/09/20 19:26:34 dduvvuri ship $ */
3 --
4 function next_action_information_id return number;
5 --
6 procedure lock_pact(
7 p_action_information_id in number,
8 p_object_version_number in number,
9 p_rec out nocopy pay_jp_isdf_pact_v%rowtype);
10 --
11 procedure lock_assact(
12 p_action_information_id in number,
13 p_object_version_number in number,
14 p_rec out nocopy pay_jp_isdf_assact_v%rowtype);
15 --
16 procedure lock_emp(
17 p_action_information_id in number,
18 p_object_version_number in number,
19 p_rec out nocopy pay_jp_isdf_emp_v%rowtype);
20 --
21 procedure lock_entry(
22 p_action_information_id in number,
23 p_object_version_number in number,
24 p_rec out nocopy pay_jp_isdf_entry_v%rowtype);
25 --
26 procedure lock_calc_dct(
27 p_action_information_id in number,
28 p_object_version_number in number,
29 p_rec out nocopy pay_jp_isdf_calc_dct_v%rowtype);
30 --
31 procedure lock_calc_dct2(
32 p_action_information_id in number,
33 p_object_version_number in number,
34 p_rec out nocopy pay_jp_isdf_calc_dct_v2%rowtype);
35 --
36 procedure lock_life_gen(
37 p_action_information_id in number,
38 p_object_version_number in number,
39 p_rec out nocopy pay_jp_isdf_life_gen_v%rowtype);
40 --
41 procedure lock_care_med(
42 p_action_information_id in number,
43 p_object_version_number in number,
44 p_rec out nocopy pay_jp_isdf_care_med_v%rowtype);
45 --
46 procedure lock_life_pens(
47 p_action_information_id in number,
48 p_object_version_number in number,
49 p_rec out nocopy pay_jp_isdf_life_pens_v%rowtype);
50 --
51 procedure lock_nonlife(
52 p_action_information_id in number,
53 p_object_version_number in number,
54 p_rec out nocopy pay_jp_isdf_nonlife_v%rowtype);
55 --
56 procedure lock_social(
57 p_action_information_id in number,
58 p_object_version_number in number,
59 p_rec out nocopy pay_jp_isdf_social_v%rowtype);
60 --
61 procedure lock_mutual_aid(
62 p_action_information_id in number,
63 p_object_version_number in number,
64 p_rec out nocopy pay_jp_isdf_mutual_aid_v%rowtype);
65 --
66 procedure lock_spouse(
67 p_action_information_id in number,
68 p_object_version_number in number,
69 p_rec out nocopy pay_jp_isdf_spouse_v%rowtype);
70 --
71 procedure lock_spouse_inc(
72 p_action_information_id in number,
73 p_object_version_number in number,
74 p_rec out nocopy pay_jp_isdf_spouse_inc_v%rowtype);
75 --
76 procedure create_pact(
77 p_action_information_id in number,
78 p_payroll_action_id in number,
79 p_action_context_type in varchar2,
80 p_effective_date in date,
81 p_action_information_category in varchar2,
82 p_payroll_id in number,
83 p_organization_id in number,
84 p_assignment_set_id in number,
85 p_submission_period_status in varchar2,
86 p_submission_start_date in date,
87 p_submission_end_date in date,
88 p_tax_office_name in varchar2,
89 p_salary_payer_name in varchar2,
90 p_salary_payer_address in varchar2,
91 p_object_version_number out nocopy number);
92 --
93 procedure update_pact(
94 p_action_information_id in number,
95 p_object_version_number in out nocopy number,
96 p_submission_period_status in varchar2,
97 p_submission_start_date in date,
98 p_submission_end_date in date,
99 p_tax_office_name in varchar2,
100 p_salary_payer_name in varchar2,
101 p_salary_payer_address in varchar2);
102 --
103 procedure create_assact(
104 p_action_information_id in number,
105 p_assignment_action_id in number,
106 p_action_context_type in varchar2,
107 p_assignment_id in number,
108 p_effective_date in date,
109 p_action_information_category in varchar2,
110 p_tax_type in varchar2,
111 p_transaction_status in varchar2,
112 p_finalized_date in date,
113 p_finalized_by in number,
114 p_user_comments in varchar2,
115 p_admin_comments in varchar2,
116 p_transfer_status in varchar2,
117 p_transfer_date in date,
118 p_expiry_date in date,
119 p_object_version_number out nocopy number);
120 --
121 procedure update_assact(
125 p_finalized_date in date,
122 p_action_information_id in number,
123 p_object_version_number in out nocopy number,
124 p_transaction_status in varchar2,
126 p_finalized_by in number,
127 p_user_comments in varchar2,
128 p_admin_comments in varchar2,
129 p_transfer_status in varchar2,
130 p_transfer_date in date,
131 p_expiry_date in date);
132 --
133 procedure create_emp(
134 p_action_information_id in number,
135 p_assignment_action_id in number,
136 p_action_context_type in varchar2,
137 p_assignment_id in number,
138 p_effective_date in date,
139 p_action_information_category in varchar2,
140 p_employee_number in varchar2,
141 p_last_name_kana in varchar2,
142 p_first_name_kana in varchar2,
143 p_last_name in varchar2,
144 p_first_name in varchar2,
145 p_postal_code in varchar2,
146 p_address in varchar2,
147 p_object_version_number out nocopy number);
148 --
149 procedure update_emp(
150 p_action_information_id in number,
151 p_object_version_number in out nocopy number,
152 p_postal_code in varchar2,
153 p_address in varchar2);
154 --
155 procedure create_entry(
156 p_action_information_id in number,
157 p_assignment_action_id in number,
158 p_action_context_type in varchar2,
159 p_assignment_id in number,
160 p_effective_date in date,
161 p_action_information_category in varchar2,
162 p_status in varchar2,
163 p_ins_datetrack_update_mode in varchar2,
164 p_ins_element_entry_id in number,
165 p_ins_ee_object_version_number in number,
166 p_life_gen_ins_prem in number,
167 p_life_gen_ins_prem_o in number,
168 p_life_pens_ins_prem in number,
169 p_life_pens_ins_prem_o in number,
170 p_nonlife_long_ins_prem in number,
171 p_nonlife_long_ins_prem_o in number,
172 p_nonlife_short_ins_prem in number default null,
173 p_nonlife_short_ins_prem_o in number default null,
174 p_earthquake_ins_prem in number,
175 p_earthquake_ins_prem_o in number,
176 p_is_datetrack_update_mode in varchar2,
177 p_is_element_entry_id in number,
178 p_is_ee_object_version_number in number,
179 p_social_ins_prem in number,
180 p_social_ins_prem_o in number,
181 p_mutual_aid_prem in number,
182 p_mutual_aid_prem_o in number,
183 p_spouse_income in number,
184 p_spouse_income_o in number,
185 p_national_pens_ins_prem in number,
186 p_national_pens_ins_prem_o in number,
187 p_life_gen_ins_prem_new in number,
188 p_life_pens_ins_prem_new in number,
189 p_care_med_ins_prem_new in number,
190 p_object_version_number out nocopy number);
191 --
192 procedure update_entry(
193 p_action_information_id in number,
194 p_object_version_number in out nocopy number,
195 p_status in varchar2,
196 p_life_gen_ins_prem in number,
197 p_life_gen_ins_prem_o in number,
198 p_life_pens_ins_prem in number,
199 p_life_pens_ins_prem_o in number,
200 p_nonlife_long_ins_prem in number,
201 p_nonlife_long_ins_prem_o in number,
202 p_nonlife_short_ins_prem in number default null,
203 p_nonlife_short_ins_prem_o in number default null,
204 p_earthquake_ins_prem in number,
205 p_earthquake_ins_prem_o in number,
206 p_social_ins_prem in number,
207 p_social_ins_prem_o in number,
208 p_mutual_aid_prem in number,
209 p_mutual_aid_prem_o in number,
210 p_spouse_income in number,
211 p_spouse_income_o in number,
212 p_national_pens_ins_prem in number,
213 p_national_pens_ins_prem_o in number,
214 p_life_gen_ins_prem_new in number,
215 p_life_pens_ins_prem_new in number,
216 p_care_med_ins_prem_new in number);
217 --
218 procedure create_calc_dct(
219 p_action_information_id in number,
220 p_assignment_action_id in number,
221 p_action_context_type in varchar2,
222 p_assignment_id in number,
223 p_effective_date in date,
224 p_action_information_category in varchar2,
225 p_status in varchar2,
226 p_life_gen_ins_prem in number,
227 p_life_pens_ins_prem in number,
228 p_life_gen_ins_calc_prem in number,
229 p_life_pens_ins_calc_prem in number,
230 p_life_ins_deduction in number,
231 p_nonlife_long_ins_prem in number,
232 p_nonlife_short_ins_prem in number default null,
233 p_earthquake_ins_prem in number,
234 p_nonlife_long_ins_calc_prem in number,
235 p_nonlife_short_ins_calc_prem in number default null,
236 p_earthquake_ins_calc_prem in number,
237 p_nonlife_ins_deduction in number,
238 p_national_pens_ins_prem in number,
239 p_social_ins_deduction in number,
240 p_mutual_aid_deduction in number,
241 p_sp_earned_income_calc in number,
245 p_sp_real_estate_income_calc in number,
242 p_sp_business_income_calc in number,
243 p_sp_miscellaneous_income_calc in number,
244 p_sp_dividend_income_calc in number,
246 p_sp_retirement_income_calc in number,
247 p_sp_other_income_calc in number,
248 p_sp_income_calc in number,
249 p_spouse_income in number,
250 p_spouse_deduction in number,
251 p_object_version_number out nocopy number,
252 p_life_gen_new_ins_prem in number,
253 p_life_pens_new_ins_prem in number,
254 p_life_gen_new_ins_calc_prem in number,
255 p_life_pens_new_ins_calc_prem in number);
256 --
257 procedure update_calc_dct(
258 p_action_information_id in number,
259 p_object_version_number in out nocopy number,
260 p_status in varchar2,
261 p_life_gen_ins_prem in number,
262 p_life_pens_ins_prem in number,
263 p_life_gen_ins_calc_prem in number,
264 p_life_pens_ins_calc_prem in number,
265 p_life_ins_deduction in number,
266 p_nonlife_long_ins_prem in number,
267 p_nonlife_short_ins_prem in number default null,
268 p_earthquake_ins_prem in number,
269 p_nonlife_long_ins_calc_prem in number,
270 p_nonlife_short_ins_calc_prem in number default null,
271 p_earthquake_ins_calc_prem in number,
272 p_nonlife_ins_deduction in number,
273 p_national_pens_ins_prem in number,
274 p_social_ins_deduction in number,
275 p_mutual_aid_deduction in number,
276 p_sp_earned_income_calc in number,
277 p_sp_business_income_calc in number,
278 p_sp_miscellaneous_income_calc in number,
279 p_sp_dividend_income_calc in number,
280 p_sp_real_estate_income_calc in number,
281 p_sp_retirement_income_calc in number,
282 p_sp_other_income_calc in number,
283 p_sp_income_calc in number,
284 p_spouse_income in number,
285 p_spouse_deduction in number,
286 p_life_gen_new_ins_prem in number,
287 p_life_pens_new_ins_prem in number,
288 p_life_gen_new_ins_calc_prem in number,
289 p_life_pens_new_ins_calc_prem in number);
290 --
291 procedure create_calc_dct2(
292 p_action_information_id in number,
293 p_assignment_action_id in number,
294 p_action_context_type in varchar2,
295 p_assignment_id in number,
296 p_effective_date in date,
297 p_action_information_category in varchar2,
298 p_status in varchar2,
299 p_object_version_number out nocopy number,
300 p_care_med_new_ins_prem in number,
301 p_care_med_new_ins_calc_prem in number);
302 --
303 procedure update_calc_dct2(
304 p_action_information_id in number,
305 p_object_version_number in out nocopy number,
306 p_status in varchar2,
307 p_care_med_new_ins_prem in number,
308 p_care_med_new_ins_calc_prem in number);
309 --
310 procedure create_life_gen(
311 p_action_information_id in number,
312 p_assignment_action_id in number,
313 p_action_context_type in varchar2,
314 p_assignment_id in number,
315 p_effective_date in date,
316 p_action_information_category in varchar2,
317 p_status in varchar2,
318 p_assignment_extra_info_id in number,
319 p_aei_object_version_number in number,
320 p_gen_ins_class in varchar2,
324 p_ins_period in varchar2,
321 p_gen_ins_company_code in varchar2,
322 p_ins_company_name in varchar2,
323 p_ins_type in varchar2,
325 p_contractor_name in varchar2,
326 p_beneficiary_name in varchar2,
327 p_beneficiary_relship in varchar2,
328 p_annual_prem in number,
329 p_object_version_number out nocopy number,
330 p_gen_ins_old_new in varchar2);
331 --
332 procedure update_life_gen(
333 p_action_information_id in number,
334 p_object_version_number in out nocopy number,
335 p_status in varchar2,
336 p_ins_company_name in varchar2,
337 p_ins_type in varchar2,
338 p_ins_period in varchar2,
339 p_contractor_name in varchar2,
340 p_beneficiary_name in varchar2,
341 p_beneficiary_relship in varchar2,
342 p_annual_prem in number,
343 p_ins_old_new in varchar2);
344 --
345 procedure delete_life_gen(
346 p_action_information_id in number,
347 p_object_version_number in number);
348 --
349
350 procedure create_care_med(
351 p_action_information_id in number,
352 p_assignment_action_id in number,
353 p_action_context_type in varchar2,
354 p_assignment_id in number,
355 p_effective_date in date,
356 p_action_information_category in varchar2,
357 p_status in varchar2,
358 p_assignment_extra_info_id in number,
359 p_aei_object_version_number in number,
360 p_care_ins_class in varchar2,
361 p_care_ins_company_code in varchar2,
362 p_ins_company_name in varchar2,
363 p_ins_type in varchar2,
364 p_ins_period in varchar2,
365 p_contractor_name in varchar2,
366 p_beneficiary_name in varchar2,
367 p_beneficiary_relship in varchar2,
368 p_annual_prem in number,
369 p_object_version_number out nocopy number,
370 p_care_ins_old_new in varchar2);
371 --
372 procedure update_care_med(
373 p_action_information_id in number,
374 p_object_version_number in out nocopy number,
375 p_status in varchar2,
376 p_ins_company_name in varchar2,
377 p_ins_type in varchar2,
378 p_ins_period in varchar2,
379 p_contractor_name in varchar2,
380 p_beneficiary_name in varchar2,
381 p_beneficiary_relship in varchar2,
382 p_annual_prem in number,
383 p_ins_old_new in varchar2);
384 --
385 procedure delete_care_med(
386 p_action_information_id in number,
387 p_object_version_number in number);
388
389 procedure create_life_pens(
390 p_action_information_id in number,
391 p_assignment_action_id in number,
392 p_action_context_type in varchar2,
393 p_assignment_id in number,
394 p_effective_date in date,
395 p_action_information_category in varchar2,
396 p_status in varchar2,
397 p_assignment_extra_info_id in number,
398 p_aei_object_version_number in number,
399 p_pens_ins_class in varchar2,
400 p_pens_ins_company_code in varchar2,
401 p_ins_company_name in varchar2,
402 p_ins_type in varchar2,
403 p_ins_period_start_date in date,
404 p_ins_period in varchar2,
405 p_contractor_name in varchar2,
406 p_beneficiary_name in varchar2,
407 p_beneficiary_relship in varchar2,
408 p_annual_prem in number,
409 p_object_version_number out nocopy number,
410 p_pens_ins_old_new in varchar2);
411 --
412 procedure update_life_pens(
413 p_action_information_id in number,
414 p_object_version_number in out nocopy number,
415 p_status in varchar2,
416 p_ins_company_name in varchar2,
417 p_ins_type in varchar2,
418 p_ins_period_start_date in date,
419 p_ins_period in varchar2,
420 p_contractor_name in varchar2,
421 p_beneficiary_name in varchar2,
422 p_beneficiary_relship in varchar2,
423 p_annual_prem in number,
424 p_ins_old_new in varchar2);
425 --
426 procedure delete_life_pens(
427 p_action_information_id in number,
428 p_object_version_number in number);
429 --
430 procedure create_nonlife(
431 p_action_information_id in number,
432 p_assignment_action_id in number,
433 p_action_context_type in varchar2,
434 p_assignment_id in number,
435 p_effective_date in date,
436 p_action_information_category in varchar2,
437 p_status in varchar2,
438 p_assignment_extra_info_id in number,
439 p_aei_object_version_number in number,
440 p_nonlife_ins_class in varchar2,
441 p_nonlife_ins_term_type in varchar2,
442 p_nonlife_ins_company_code in varchar2,
443 p_ins_company_name in varchar2,
444 p_ins_type in varchar2,
445 p_ins_period in varchar2,
446 p_contractor_name in varchar2,
447 p_beneficiary_name in varchar2,
451 p_object_version_number out nocopy number);
448 p_beneficiary_relship in varchar2,
449 p_maturity_repayment in varchar2 default null,
450 p_annual_prem in number,
452 --
453 procedure update_nonlife(
454 p_action_information_id in number,
455 p_object_version_number in out nocopy number,
456 p_status in varchar2,
457 p_nonlife_ins_term_type in varchar2,
458 p_ins_company_name in varchar2,
459 p_ins_type in varchar2,
460 p_ins_period in varchar2,
461 p_contractor_name in varchar2,
462 p_beneficiary_name in varchar2,
463 p_beneficiary_relship in varchar2,
464 p_maturity_repayment in varchar2 default null,
465 p_annual_prem in number);
466 --
467 procedure delete_nonlife(
468 p_action_information_id in number,
469 p_object_version_number in number);
470 --
471 procedure create_social(
472 p_action_information_id in number,
473 p_assignment_action_id in number,
474 p_action_context_type in varchar2,
475 p_assignment_id in number,
476 p_effective_date in date,
477 p_action_information_category in varchar2,
478 p_status in varchar2,
479 p_ins_type in varchar2,
480 p_ins_payee_name in varchar2,
481 p_debtor_name in varchar2,
482 p_beneficiary_relship in varchar2,
483 p_annual_prem in number,
484 p_national_pens_flag in varchar2,
485 p_object_version_number out nocopy number);
486 --
487 procedure update_social(
488 p_action_information_id in number,
489 p_object_version_number in out nocopy number,
490 p_status in varchar2,
491 p_ins_type in varchar2,
492 p_ins_payee_name in varchar2,
493 p_debtor_name in varchar2,
494 p_beneficiary_relship in varchar2,
495 p_annual_prem in number,
496 p_national_pens_flag in varchar2);
497 --
498 procedure delete_social(
499 p_action_information_id in number,
500 p_object_version_number in number);
501 --
502 procedure create_mutual_aid(
503 p_action_information_id in number,
504 p_assignment_action_id in number,
505 p_action_context_type in varchar2,
506 p_assignment_id in number,
507 p_effective_date in date,
508 p_action_information_category in varchar2,
509 p_status in varchar2,
510 p_enterprise_contract_prem in number,
511 p_pension_prem in number,
512 p_disable_sup_contract_prem in number,
513 p_object_version_number out nocopy number);
514 --
515 procedure update_mutual_aid(
516 p_action_information_id in number,
517 p_object_version_number in out nocopy number,
518 p_status in varchar2,
519 p_enterprise_contract_prem in number,
520 p_pension_prem in number,
521 p_disable_sup_contract_prem in number);
522 --
523 procedure delete_mutual_aid(
524 p_action_information_id in number,
525 p_object_version_number in number);
526 --
527 procedure create_spouse(
528 p_action_information_id in number,
529 p_assignment_action_id in number,
530 p_action_context_type in varchar2,
531 p_assignment_id in number,
532 p_effective_date in date,
533 p_action_information_category in varchar2,
534 p_status in varchar2,
535 p_full_name_kana in varchar2,
536 --p_last_name_kana in varchar2,
537 --p_first_name_kana in varchar2,
538 p_full_name in varchar2,
539 --p_last_name in varchar2,
540 --p_first_name in varchar2,
541 p_postal_code in varchar2,
542 p_address in varchar2,
543 p_emp_income in number,
544 p_spouse_type in varchar2,
545 p_widow_type in varchar2,
546 p_spouse_dct_exclude in varchar2,
547 p_spouse_income_entry in number,
548 p_object_version_number out nocopy number);
549 --
550 procedure update_spouse(
551 p_action_information_id in number,
552 p_object_version_number in out nocopy number,
553 p_status in varchar2,
554 p_full_name_kana in varchar2,
555 --p_last_name_kana in varchar2,
556 --p_first_name_kana in varchar2,
557 p_full_name in varchar2,
558 --p_last_name in varchar2,
559 --p_first_name in varchar2,
560 p_postal_code in varchar2,
561 p_address in varchar2,
562 p_emp_income in number,
563 p_spouse_type in varchar2,
564 p_widow_type in varchar2,
565 p_spouse_dct_exclude in varchar2,
566 p_spouse_income_entry in number);
567 --
568 procedure delete_spouse(
569 p_action_information_id in number,
570 p_object_version_number in number);
571 --
572 procedure create_spouse_inc(
573 p_action_information_id in number,
574 p_assignment_action_id in number,
575 p_action_context_type in varchar2,
576 p_assignment_id in number,
577 p_effective_date in date,
578 p_action_information_category in varchar2,
582 p_sp_business_income in number,
579 p_status in varchar2,
580 p_sp_earned_income in number,
581 p_sp_earned_income_exp in number,
583 p_sp_business_income_exp in number,
584 p_sp_miscellaneous_income in number,
585 p_sp_miscellaneous_income_exp in number,
586 p_sp_dividend_income in number,
587 p_sp_dividend_income_exp in number,
588 p_sp_real_estate_income in number,
589 p_sp_real_estate_income_exp in number,
590 p_sp_retirement_income in number,
591 p_sp_retirement_income_exp in number,
592 p_sp_other_income in number,
593 p_sp_other_income_exp in number,
594 p_sp_other_income_exp_dct in number,
595 p_sp_other_income_exp_temp in number,
596 p_sp_other_income_exp_temp_exp in number,
597 p_object_version_number out nocopy number);
598 --
599 procedure update_spouse_inc(
600 p_action_information_id in number,
601 p_object_version_number in out nocopy number,
602 p_status in varchar2,
603 p_sp_earned_income in number,
604 p_sp_earned_income_exp in number,
605 p_sp_business_income in number,
606 p_sp_business_income_exp in number,
607 p_sp_miscellaneous_income in number,
608 p_sp_miscellaneous_income_exp in number,
609 p_sp_dividend_income in number,
610 p_sp_dividend_income_exp in number,
611 p_sp_real_estate_income in number,
612 p_sp_real_estate_income_exp in number,
613 p_sp_retirement_income in number,
614 p_sp_retirement_income_exp in number,
615 p_sp_other_income in number,
616 p_sp_other_income_exp in number,
617 p_sp_other_income_exp_dct in number,
618 p_sp_other_income_exp_temp in number,
619 p_sp_other_income_exp_temp_exp in number);
620 --
621 procedure delete_spouse_inc(
622 p_action_information_id in number,
623 p_object_version_number in number);
624 --
625 end pay_jp_isdf_dml_pkg;