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