[Home] [Help]
210: and nvl(put.legislation_code,'X') = nvl(l_legislation_code,nvl(put.legislation_code,'X'))
211: and pur.user_table_id = put.user_table_id
212: and p_effective_date
213: between pur.effective_start_date and pur.effective_end_date
214: order by 3, fnd_number.canonical_to_number(pur.row_low_range_or_name);
215: --
216: cursor csr_udt_val(
217: p_user_table_id in number,
218: p_row_id in number,
291: --
292: end loop;
293: close csr_udt_val;
294: --
295: if fnd_number.canonical_to_number(l_rate) = 0.5 then
296: l_rate := '1/2';
297: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
298: l_rate := '1/4';
299: end if;
293: close csr_udt_val;
294: --
295: if fnd_number.canonical_to_number(l_rate) = 0.5 then
296: l_rate := '1/2';
297: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
298: l_rate := '1/4';
299: end if;
300: --
301: g_life_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
321: --
322: end loop;
323: close csr_udt_val;
324: --
325: if fnd_number.canonical_to_number(l_rate) = 0.5 then
326: l_rate := '1/2';
327: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
328: l_rate := '1/4';
329: end if;
323: close csr_udt_val;
324: --
325: if fnd_number.canonical_to_number(l_rate) = 0.5 then
326: l_rate := '1/2';
327: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
328: l_rate := '1/4';
329: end if;
330: --
331: g_life_calc3 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
398: --
399: end loop;
400: close csr_udt_val;
401: --
402: if fnd_number.canonical_to_number(l_rate) = 0.5 then
403: l_rate := '1/2';
404: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
405: l_rate := '1/4';
406: end if;
400: close csr_udt_val;
401: --
402: if fnd_number.canonical_to_number(l_rate) = 0.5 then
403: l_rate := '1/2';
404: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
405: l_rate := '1/4';
406: end if;
407: --
408: g_lnonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
469: --
470: end loop;
471: close csr_udt_val;
472: --
473: if fnd_number.canonical_to_number(l_rate) = 0.5 then
474: l_rate := '1/2';
475: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
476: l_rate := '1/4';
477: end if;
471: close csr_udt_val;
472: --
473: if fnd_number.canonical_to_number(l_rate) = 0.5 then
474: l_rate := '1/2';
475: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
476: l_rate := '1/4';
477: end if;
478: --
479: g_snonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
641: g_sp_calc_exp1b_fmt := to_char(g_sp_calc_exp1b);
642: g_sp_calc_exp1b_fmt := to_char(to_number(g_sp_calc_exp1b_fmt),fnd_currency.get_format_mask('JPY',40));
643: g_sp_calc_cal1 := to_char(c_sp_calc_earned_inc_calc1);
644: --
645: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then
646: l_sp_calc_other_inc_calc_rate := '1/2';
647: elsif fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.25 then
648: l_sp_calc_other_inc_calc_rate := '1/4';
649: end if;
643: g_sp_calc_cal1 := to_char(c_sp_calc_earned_inc_calc1);
644: --
645: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then
646: l_sp_calc_other_inc_calc_rate := '1/2';
647: elsif fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.25 then
648: l_sp_calc_other_inc_calc_rate := '1/4';
649: end if;
650: --
651: g_sp_calc_cal6 := 'x '||l_sp_calc_other_inc_calc_rate;
657: --
658: fetch csr_udt_row into l_csr_udt_row;
659: exit when csr_udt_row%notfound;
660: --
661: if fnd_number.canonical_to_number(l_csr_udt_row.row_low_range_or_name) > c_inc_spouse_dct_max then
662: --
663: l_dct_cnt := l_dct_cnt + 1;
664: l_sp_calc_tbl(l_dct_cnt).range_a := l_csr_udt_row.row_low_range_or_name;
665: l_sp_calc_tbl(l_dct_cnt).range_b := l_csr_udt_row.row_high_range;
670: fetch csr_udt_val into l_csr_udt_val;
671: exit when csr_udt_val%notfound;
672: --
673: if l_csr_udt_val.user_column_name = c_dct_udtcol then
674: --l_sp_calc_tbl(l_dct_cnt).val := to_char(fnd_number.canonical_to_number(l_csr_udt_val.value)/c_sp_calc_unit);
675: l_sp_calc_tbl(l_dct_cnt).val := l_csr_udt_val.value;
676: end if;
677: --
678: end loop;
1094: and nvl(put.legislation_code,'X') = nvl(l_legislation_code,nvl(put.legislation_code,'X'))
1095: and pur.user_table_id = put.user_table_id
1096: and p_effective_date
1097: between pur.effective_start_date and pur.effective_end_date
1098: order by 3, fnd_number.canonical_to_number(pur.row_low_range_or_name);
1099: --
1100: cursor csr_udt_val(
1101: p_user_table_id in number,
1102: p_row_id in number,
1231: --
1232: end loop;
1233: close csr_udt_val;
1234: --
1235: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1236: l_rate := '1/2';
1237: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1238: l_rate := '1/4';
1239: end if;
1233: close csr_udt_val;
1234: --
1235: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1236: l_rate := '1/2';
1237: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1238: l_rate := '1/4';
1239: end if;
1240: --
1241: g_new_life_calc2a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1261: --
1262: end loop;
1263: close csr_udt_val;
1264: --
1265: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1266: l_rate := '1/2';
1267: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1268: l_rate := '1/4';
1269: end if;
1263: close csr_udt_val;
1264: --
1265: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1266: l_rate := '1/2';
1267: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1268: l_rate := '1/4';
1269: end if;
1270: --
1271: g_new_life_calc3a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1362: --
1363: end loop;
1364: close csr_udt_val;
1365: --
1366: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1367: l_rate := '1/2';
1368: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1369: l_rate := '1/4';
1370: end if;
1364: close csr_udt_val;
1365: --
1366: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1367: l_rate := '1/2';
1368: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1369: l_rate := '1/4';
1370: end if;
1371: --
1372: g_old_life_calc2a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1392: --
1393: end loop;
1394: close csr_udt_val;
1395: --
1396: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1397: l_rate := '1/2';
1398: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1399: l_rate := '1/4';
1400: end if;
1394: close csr_udt_val;
1395: --
1396: if fnd_number.canonical_to_number(l_rate) = 0.5 then
1397: l_rate := '1/2';
1398: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1399: l_rate := '1/4';
1400: end if;
1401: --
1402: g_old_life_calc3a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1787: --
1788: if l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_GEN' then
1789: --
1790: if nvl(l_action_info_tbl(i).action_information13,'O') = 'O' then
1791: p_calc_total_rec.life_gen := nvl(p_calc_total_rec.life_gen,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1792: else
1793: p_calc_total_rec.life_gen_new := nvl(p_calc_total_rec.life_gen_new,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1794: end if;
1795: --
1789: --
1790: if nvl(l_action_info_tbl(i).action_information13,'O') = 'O' then
1791: p_calc_total_rec.life_gen := nvl(p_calc_total_rec.life_gen,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1792: else
1793: p_calc_total_rec.life_gen_new := nvl(p_calc_total_rec.life_gen_new,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1794: end if;
1795: --
1796: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_CARE_MED' then
1797: --
1795: --
1796: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_CARE_MED' then
1797: --
1798: if l_action_info_tbl(i).action_information13 = 'N' then
1799: p_calc_total_rec.care_med_new := nvl(p_calc_total_rec.care_med_new,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1800: end if;
1801: --
1802: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_PENS' then
1803: --
1801: --
1802: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_PENS' then
1803: --
1804: if nvl(l_action_info_tbl(i).action_information14,'O') = 'O' then
1805: p_calc_total_rec.life_pens := nvl(p_calc_total_rec.life_pens,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1806: else
1807: p_calc_total_rec.life_pens_new := nvl(p_calc_total_rec.life_pens_new,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1808: end if;
1809: --
1803: --
1804: if nvl(l_action_info_tbl(i).action_information14,'O') = 'O' then
1805: p_calc_total_rec.life_pens := nvl(p_calc_total_rec.life_pens,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1806: else
1807: p_calc_total_rec.life_pens_new := nvl(p_calc_total_rec.life_pens_new,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1808: end if;
1809: --
1810: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_NONLIFE' then
1811: --
1809: --
1810: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_NONLIFE' then
1811: --
1812: -- non support calc for negative amount since deduction from multiple type is acceptable, it is not feasible in system.
1813: if nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0) > 0 then
1814: --
1815: if l_action_info_tbl(i).action_information2 = 'EQ' then
1816: p_calc_total_rec.earthquake := nvl(p_calc_total_rec.earthquake,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1817: elsif l_action_info_tbl(i).action_information2 = 'L' then
1812: -- non support calc for negative amount since deduction from multiple type is acceptable, it is not feasible in system.
1813: if nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0) > 0 then
1814: --
1815: if l_action_info_tbl(i).action_information2 = 'EQ' then
1816: p_calc_total_rec.earthquake := nvl(p_calc_total_rec.earthquake,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1817: elsif l_action_info_tbl(i).action_information2 = 'L' then
1818: p_calc_total_rec.nonlife_long := nvl(p_calc_total_rec.nonlife_long,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1819: elsif l_action_info_tbl(i).action_information2 = 'S' then
1820: p_calc_total_rec.nonlife_short := nvl(p_calc_total_rec.nonlife_short,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1814: --
1815: if l_action_info_tbl(i).action_information2 = 'EQ' then
1816: p_calc_total_rec.earthquake := nvl(p_calc_total_rec.earthquake,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1817: elsif l_action_info_tbl(i).action_information2 = 'L' then
1818: p_calc_total_rec.nonlife_long := nvl(p_calc_total_rec.nonlife_long,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1819: elsif l_action_info_tbl(i).action_information2 = 'S' then
1820: p_calc_total_rec.nonlife_short := nvl(p_calc_total_rec.nonlife_short,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1821: end if;
1822: --
1816: p_calc_total_rec.earthquake := nvl(p_calc_total_rec.earthquake,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1817: elsif l_action_info_tbl(i).action_information2 = 'L' then
1818: p_calc_total_rec.nonlife_long := nvl(p_calc_total_rec.nonlife_long,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1819: elsif l_action_info_tbl(i).action_information2 = 'S' then
1820: p_calc_total_rec.nonlife_short := nvl(p_calc_total_rec.nonlife_short,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1821: end if;
1822: --
1823: end if;
1824: --
1824: --
1825: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SOCIAL' then
1826: --
1827: if l_action_info_tbl(i).action_information7 = 'Y' then
1828: p_calc_total_rec.national_pens := nvl(p_calc_total_rec.national_pens,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1829: end if;
1830: --
1831: p_calc_total_rec.social := nvl(p_calc_total_rec.social,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1832: --
1827: if l_action_info_tbl(i).action_information7 = 'Y' then
1828: p_calc_total_rec.national_pens := nvl(p_calc_total_rec.national_pens,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1829: end if;
1830: --
1831: p_calc_total_rec.social := nvl(p_calc_total_rec.social,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1832: --
1833: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1834: --
1835: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1831: p_calc_total_rec.social := nvl(p_calc_total_rec.social,0) + nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1832: --
1833: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1834: --
1835: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1836: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1837: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1838: --
1839: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1832: --
1833: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1834: --
1835: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1836: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1837: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1838: --
1839: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1840: --
1833: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1834: --
1835: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1836: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1837: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1838: --
1839: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1840: --
1841: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1837: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1838: --
1839: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1840: --
1841: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1842: p_calc_total_rec.sp_spouse_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1843: p_calc_total_rec.sp_sp_type := l_action_info_tbl(i).action_information7;
1844: p_calc_total_rec.sp_wid_type := l_action_info_tbl(i).action_information8;
1845: p_calc_total_rec.sp_dct_exc := l_action_info_tbl(i).action_information9;
1838: --
1839: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1840: --
1841: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1842: p_calc_total_rec.sp_spouse_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1843: p_calc_total_rec.sp_sp_type := l_action_info_tbl(i).action_information7;
1844: p_calc_total_rec.sp_wid_type := l_action_info_tbl(i).action_information8;
1845: p_calc_total_rec.sp_dct_exc := l_action_info_tbl(i).action_information9;
1846: --
1846: --
1847: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE_INC' then
1848: --
1849: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1850: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1847: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE_INC' then
1848: --
1849: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1850: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1848: --
1849: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1850: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1849: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1850: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1850: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1851: p_calc_total_rec.sp_earned_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),c_sp_earned_inc_exp);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1852: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1853: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1854: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1855: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1856: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1857: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1858: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1866: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1859: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1866: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1867: --
1860: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1866: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1867: --
1868: end if;
1861: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1866: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1867: --
1868: end if;
1869: --
1862: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1863: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1864: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1865: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1866: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1867: --
1868: end if;
1869: --
1870: end loop;
3632: -- p_action_information_id => l_assact_rec.assignment_action_id,
3633: -- p_object_version_number => p_object_version_number,
3634: -- p_transaction_status => 'F',
3635: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),
3636: -- p_finalized_by => fnd_number.number_to_canonical(fnd_global.user_id),
3637: -- p_user_comments => p_user_comments,
3638: -- p_admin_comments => l_assact_rec.admin_comments,
3639: -- p_transfer_status => l_assact_rec.transfer_status,
3640: -- p_transfer_date => l_assact_rec.transfer_date,
3642: update pay_jp_isdf_assact_dml_v
3643: set object_version_number = p_object_version_number,
3644: transaction_status = 'F',
3645: finalized_date = fnd_date.date_to_canonical(l_submission_date),
3646: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),
3647: user_comments = p_user_comments
3648: where row_id = l_assact_rec.row_id;
3649: --
3650: if g_debug then
4085: p_input_value_id5 => c_earthquake_iv_id,
4086: p_input_value_id6 => c_life_gen_new_iv_id,
4087: p_input_value_id7 => c_life_pens_new_iv_id,
4088: p_input_value_id8 => c_care_med_new_iv_id,
4089: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4086: p_input_value_id6 => c_life_gen_new_iv_id,
4087: p_input_value_id7 => c_life_pens_new_iv_id,
4088: p_input_value_id8 => c_care_med_new_iv_id,
4089: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4087: p_input_value_id7 => c_life_pens_new_iv_id,
4088: p_input_value_id8 => c_care_med_new_iv_id,
4089: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4088: p_input_value_id8 => c_care_med_new_iv_id,
4089: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4096: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4089: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4096: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4097: p_effective_start_date => l_esd,
4090: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4096: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4097: p_effective_start_date => l_esd,
4098: p_effective_end_date => l_eed,
4091: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4096: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4097: p_effective_start_date => l_esd,
4098: p_effective_end_date => l_eed,
4099: p_update_warning => l_warning);
4092: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4093: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4094: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4095: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4096: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4097: p_effective_start_date => l_esd,
4098: p_effective_end_date => l_eed,
4099: p_update_warning => l_warning);
4100: --
4130: p_input_value_id5 => c_earthquake_iv_id,
4131: p_input_value_id6 => c_life_gen_new_iv_id,
4132: p_input_value_id7 => c_life_pens_new_iv_id,
4133: p_input_value_id8 => c_care_med_new_iv_id,
4134: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4131: p_input_value_id6 => c_life_gen_new_iv_id,
4132: p_input_value_id7 => c_life_pens_new_iv_id,
4133: p_input_value_id8 => c_care_med_new_iv_id,
4134: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4132: p_input_value_id7 => c_life_pens_new_iv_id,
4133: p_input_value_id8 => c_care_med_new_iv_id,
4134: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4133: p_input_value_id8 => c_care_med_new_iv_id,
4134: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4141: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4134: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4141: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4142: p_element_entry_id => p_rec.ins_element_entry_id,
4135: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4141: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4142: p_element_entry_id => p_rec.ins_element_entry_id,
4143: p_object_version_number => p_rec.ins_ee_object_version_number,
4136: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4141: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4142: p_element_entry_id => p_rec.ins_element_entry_id,
4143: p_object_version_number => p_rec.ins_ee_object_version_number,
4144: p_effective_start_date => l_esd,
4137: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4138: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4139: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4140: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4141: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4142: p_element_entry_id => p_rec.ins_element_entry_id,
4143: p_object_version_number => p_rec.ins_ee_object_version_number,
4144: p_effective_start_date => l_esd,
4145: p_effective_end_date => l_eed,
4165: p_input_value_id5 => c_social_iv_id,
4166: p_input_value_id6 => c_mutual_aid_iv_id,
4167: p_input_value_id7 => c_spouse_iv_id,
4168: p_input_value_id9 => c_national_pens_iv_id,
4169: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4170: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4171: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4172: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4173: p_effective_start_date => l_esd,
4166: p_input_value_id6 => c_mutual_aid_iv_id,
4167: p_input_value_id7 => c_spouse_iv_id,
4168: p_input_value_id9 => c_national_pens_iv_id,
4169: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4170: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4171: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4172: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4173: p_effective_start_date => l_esd,
4174: p_effective_end_date => l_eed,
4167: p_input_value_id7 => c_spouse_iv_id,
4168: p_input_value_id9 => c_national_pens_iv_id,
4169: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4170: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4171: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4172: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4173: p_effective_start_date => l_esd,
4174: p_effective_end_date => l_eed,
4175: p_update_warning => l_warning);
4168: p_input_value_id9 => c_national_pens_iv_id,
4169: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4170: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4171: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4172: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4173: p_effective_start_date => l_esd,
4174: p_effective_end_date => l_eed,
4175: p_update_warning => l_warning);
4176: --
4202: p_input_value_id5 => c_social_iv_id,
4203: p_input_value_id6 => c_mutual_aid_iv_id,
4204: p_input_value_id7 => c_spouse_iv_id,
4205: p_input_value_id9 => c_national_pens_iv_id,
4206: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4207: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4208: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4209: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4210: p_element_entry_id => p_rec.is_element_entry_id,
4203: p_input_value_id6 => c_mutual_aid_iv_id,
4204: p_input_value_id7 => c_spouse_iv_id,
4205: p_input_value_id9 => c_national_pens_iv_id,
4206: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4207: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4208: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4209: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4210: p_element_entry_id => p_rec.is_element_entry_id,
4211: p_object_version_number => p_rec.is_ee_object_version_number,
4204: p_input_value_id7 => c_spouse_iv_id,
4205: p_input_value_id9 => c_national_pens_iv_id,
4206: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4207: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4208: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4209: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4210: p_element_entry_id => p_rec.is_element_entry_id,
4211: p_object_version_number => p_rec.is_ee_object_version_number,
4212: p_effective_start_date => l_esd,
4205: p_input_value_id9 => c_national_pens_iv_id,
4206: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4207: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4208: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4209: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4210: p_element_entry_id => p_rec.is_element_entry_id,
4211: p_object_version_number => p_rec.is_ee_object_version_number,
4212: p_effective_start_date => l_esd,
4213: p_effective_end_date => l_eed,
4234: update pay_jp_isdf_entry_dml_v
4235: set object_version_number = p_rec.object_version_number,
4236: status = l_status,
4237: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4238: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4239: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4240: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
4241: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
4242: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4235: set object_version_number = p_rec.object_version_number,
4236: status = l_status,
4237: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4238: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4239: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4240: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
4241: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
4242: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4243: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4242: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4243: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4244: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
4245: is_datetrack_update_mode = l_is_datetrack_update_mode,
4246: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4247: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4248: social_ins_prem_o = l_entry_rec.social_ins_prem,
4249: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
4250: spouse_income_o = l_entry_rec.spouse_income,
4243: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4244: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
4245: is_datetrack_update_mode = l_is_datetrack_update_mode,
4246: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4247: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4248: social_ins_prem_o = l_entry_rec.social_ins_prem,
4249: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
4250: spouse_income_o = l_entry_rec.spouse_income,
4251: national_pens_ins_prem_o = l_entry_rec.national_pens_ins_prem,
4260: set object_version_number = p_rec.object_version_number,
4261: status = l_status,
4262: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4263: is_datetrack_update_mode = l_is_datetrack_update_mode,
4264: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4265: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4266: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4267: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
4268: where row_id = p_rec.row_id;
4261: status = l_status,
4262: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4263: is_datetrack_update_mode = l_is_datetrack_update_mode,
4264: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4265: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4266: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4267: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
4268: where row_id = p_rec.row_id;
4269: --
4262: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4263: is_datetrack_update_mode = l_is_datetrack_update_mode,
4264: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4265: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4266: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4267: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
4268: where row_id = p_rec.row_id;
4269: --
4270: end if;
4263: is_datetrack_update_mode = l_is_datetrack_update_mode,
4264: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4265: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4266: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4267: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
4268: where row_id = p_rec.row_id;
4269: --
4270: end if;
4271: --
4299: p_input_value_id5 => c_earthquake_iv_id,
4300: p_input_value_id6 => c_life_gen_new_iv_id,
4301: p_input_value_id7 => c_life_pens_new_iv_id,
4302: p_input_value_id8 => c_care_med_new_iv_id,
4303: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4300: p_input_value_id6 => c_life_gen_new_iv_id,
4301: p_input_value_id7 => c_life_pens_new_iv_id,
4302: p_input_value_id8 => c_care_med_new_iv_id,
4303: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4301: p_input_value_id7 => c_life_pens_new_iv_id,
4302: p_input_value_id8 => c_care_med_new_iv_id,
4303: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4302: p_input_value_id8 => c_care_med_new_iv_id,
4303: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4310: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4303: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4310: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4311: p_effective_start_date => l_esd,
4304: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4310: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4311: p_effective_start_date => l_esd,
4312: p_effective_end_date => l_eed,
4305: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4310: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4311: p_effective_start_date => l_esd,
4312: p_effective_end_date => l_eed,
4313: p_update_warning => l_warning);
4306: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4307: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4308: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4309: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4310: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4311: p_effective_start_date => l_esd,
4312: p_effective_end_date => l_eed,
4313: p_update_warning => l_warning);
4314: --
4348: p_input_value_id5 => c_earthquake_iv_id,
4349: p_input_value_id6 => c_life_gen_new_iv_id,
4350: p_input_value_id7 => c_life_pens_new_iv_id,
4351: p_input_value_id8 => c_care_med_new_iv_id,
4352: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4349: p_input_value_id6 => c_life_gen_new_iv_id,
4350: p_input_value_id7 => c_life_pens_new_iv_id,
4351: p_input_value_id8 => c_care_med_new_iv_id,
4352: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4350: p_input_value_id7 => c_life_pens_new_iv_id,
4351: p_input_value_id8 => c_care_med_new_iv_id,
4352: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4351: p_input_value_id8 => c_care_med_new_iv_id,
4352: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4359: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4352: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4359: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4360: p_element_entry_id => p_rec.ins_element_entry_id,
4353: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4359: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4360: p_element_entry_id => p_rec.ins_element_entry_id,
4361: p_object_version_number => p_rec.ins_ee_object_version_number,
4354: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4359: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4360: p_element_entry_id => p_rec.ins_element_entry_id,
4361: p_object_version_number => p_rec.ins_ee_object_version_number,
4362: p_effective_start_date => l_esd,
4355: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
4356: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
4357: p_entry_value6 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem_new),
4358: p_entry_value7 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem_new),
4359: p_entry_value8 => fnd_number.number_to_canonical(p_rec.care_med_ins_prem_new),
4360: p_element_entry_id => p_rec.ins_element_entry_id,
4361: p_object_version_number => p_rec.ins_ee_object_version_number,
4362: p_effective_start_date => l_esd,
4363: p_effective_end_date => l_eed,
4389: p_input_value_id5 => c_social_iv_id,
4390: p_input_value_id6 => c_mutual_aid_iv_id,
4391: p_input_value_id7 => c_spouse_iv_id,
4392: p_input_value_id9 => c_national_pens_iv_id,
4393: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4394: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4395: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4396: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4397: p_effective_start_date => l_esd,
4390: p_input_value_id6 => c_mutual_aid_iv_id,
4391: p_input_value_id7 => c_spouse_iv_id,
4392: p_input_value_id9 => c_national_pens_iv_id,
4393: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4394: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4395: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4396: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4397: p_effective_start_date => l_esd,
4398: p_effective_end_date => l_eed,
4391: p_input_value_id7 => c_spouse_iv_id,
4392: p_input_value_id9 => c_national_pens_iv_id,
4393: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4394: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4395: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4396: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4397: p_effective_start_date => l_esd,
4398: p_effective_end_date => l_eed,
4399: p_update_warning => l_warning);
4392: p_input_value_id9 => c_national_pens_iv_id,
4393: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4394: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4395: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4396: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4397: p_effective_start_date => l_esd,
4398: p_effective_end_date => l_eed,
4399: p_update_warning => l_warning);
4400: --
4430: p_input_value_id5 => c_social_iv_id,
4431: p_input_value_id6 => c_mutual_aid_iv_id,
4432: p_input_value_id7 => c_spouse_iv_id,
4433: p_input_value_id9 => c_national_pens_iv_id,
4434: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4435: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4436: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4437: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4438: p_element_entry_id => p_rec.is_element_entry_id,
4431: p_input_value_id6 => c_mutual_aid_iv_id,
4432: p_input_value_id7 => c_spouse_iv_id,
4433: p_input_value_id9 => c_national_pens_iv_id,
4434: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4435: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4436: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4437: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4438: p_element_entry_id => p_rec.is_element_entry_id,
4439: p_object_version_number => p_rec.is_ee_object_version_number,
4432: p_input_value_id7 => c_spouse_iv_id,
4433: p_input_value_id9 => c_national_pens_iv_id,
4434: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4435: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4436: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4437: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4438: p_element_entry_id => p_rec.is_element_entry_id,
4439: p_object_version_number => p_rec.is_ee_object_version_number,
4440: p_effective_start_date => l_esd,
4433: p_input_value_id9 => c_national_pens_iv_id,
4434: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
4435: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
4436: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
4437: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
4438: p_element_entry_id => p_rec.is_element_entry_id,
4439: p_object_version_number => p_rec.is_ee_object_version_number,
4440: p_effective_start_date => l_esd,
4441: p_effective_end_date => l_eed,
4462: update pay_jp_isdf_entry_dml_v
4463: set object_version_number = p_rec.object_version_number,
4464: status = l_status,
4465: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4466: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4467: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4468: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
4469: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
4470: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4463: set object_version_number = p_rec.object_version_number,
4464: status = l_status,
4465: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4466: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4467: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4468: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
4469: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
4470: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4471: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4470: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
4471: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4472: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
4473: is_datetrack_update_mode = l_is_datetrack_update_mode,
4474: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4475: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4476: social_ins_prem_o = l_entry_rec.social_ins_prem,
4477: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
4478: spouse_income_o = l_entry_rec.spouse_income,
4471: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
4472: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
4473: is_datetrack_update_mode = l_is_datetrack_update_mode,
4474: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4475: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4476: social_ins_prem_o = l_entry_rec.social_ins_prem,
4477: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
4478: spouse_income_o = l_entry_rec.spouse_income,
4479: national_pens_ins_prem_o = l_entry_rec.national_pens_ins_prem,
4487: update pay_jp_isdf_entry_dml_v
4488: set object_version_number = p_rec.object_version_number,
4489: status = l_status,
4490: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4491: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4492: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4493: life_gen_ins_prem_o = null,
4494: life_pens_ins_prem_o = null,
4495: nonlife_long_ins_prem_o = null,
4488: set object_version_number = p_rec.object_version_number,
4489: status = l_status,
4490: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
4491: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
4492: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
4493: life_gen_ins_prem_o = null,
4494: life_pens_ins_prem_o = null,
4495: nonlife_long_ins_prem_o = null,
4496: nonlife_short_ins_prem_o = null,
4495: nonlife_long_ins_prem_o = null,
4496: nonlife_short_ins_prem_o = null,
4497: earthquake_ins_prem_o = null,
4498: is_datetrack_update_mode = l_is_datetrack_update_mode,
4499: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4500: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4501: social_ins_prem_o = null,
4502: mutual_aid_prem_o = null,
4503: spouse_income_o = null,
4496: nonlife_short_ins_prem_o = null,
4497: earthquake_ins_prem_o = null,
4498: is_datetrack_update_mode = l_is_datetrack_update_mode,
4499: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
4500: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
4501: social_ins_prem_o = null,
4502: mutual_aid_prem_o = null,
4503: spouse_income_o = null,
4504: national_pens_ins_prem_o = null
4583: --
4584: update pay_jp_isdf_life_gen_dml_v
4585: set object_version_number = p_rec.object_version_number,
4586: status = p_rec.status,
4587: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4588: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4589: where row_id = p_rec.row_id;
4590: --
4591: -- currently only support case of update entry data (except for amendment of ins_class and code)
4584: update pay_jp_isdf_life_gen_dml_v
4585: set object_version_number = p_rec.object_version_number,
4586: status = p_rec.status,
4587: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4588: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4589: where row_id = p_rec.row_id;
4590: --
4591: -- currently only support case of update entry data (except for amendment of ins_class and code)
4592: -- additionally not support if eit has been removed at the transferred time
4640: -- since no storage for old eit data in view, unnecessary to change like entry.
4641: update pay_jp_isdf_life_gen_dml_v
4642: set object_version_number = p_rec.object_version_number,
4643: status = p_rec.status,
4644: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4645: where row_id = p_rec.row_id;
4646: --
4647: end if;
4648: --
4684: --
4685: -- since no storage for old eit data in view, unnecessary to change like entry.
4686: update pay_jp_isdf_life_gen_dml_v
4687: set object_version_number = p_rec.object_version_number,
4688: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4689: where row_id = p_rec.row_id;
4690: --
4691: end if;
4692: --
4767: --
4768: update pay_jp_isdf_care_med_dml_v
4769: set object_version_number = p_rec.object_version_number,
4770: status = p_rec.status,
4771: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4772: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4773: where row_id = p_rec.row_id;
4774: --
4775: -- currently only support case of update entry data (except for amendment of ins_class and code)
4768: update pay_jp_isdf_care_med_dml_v
4769: set object_version_number = p_rec.object_version_number,
4770: status = p_rec.status,
4771: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4772: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4773: where row_id = p_rec.row_id;
4774: --
4775: -- currently only support case of update entry data (except for amendment of ins_class and code)
4776: -- additionally not support if eit has been removed at the transferred time
4822: -- since no storage for old eit data in view, unnecessary to change like entry.
4823: update pay_jp_isdf_care_med_dml_v
4824: set object_version_number = p_rec.object_version_number,
4825: status = p_rec.status,
4826: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4827: where row_id = p_rec.row_id;
4828: --
4829: end if;
4830: --
4865: --
4866: -- since no storage for old eit data in view, unnecessary to change like entry.
4867: update pay_jp_isdf_care_med_dml_v
4868: set object_version_number = p_rec.object_version_number,
4869: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4870: where row_id = p_rec.row_id;
4871: --
4872: end if;
4873: --
4950: --
4951: update pay_jp_isdf_life_pens_dml_v
4952: set object_version_number = p_rec.object_version_number,
4953: status = p_rec.status,
4954: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4955: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4956: where row_id = p_rec.row_id;
4957: --
4958: -- currently only support case of update entry data (except for amendment of ins_class and code)
4951: update pay_jp_isdf_life_pens_dml_v
4952: set object_version_number = p_rec.object_version_number,
4953: status = p_rec.status,
4954: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4955: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4956: where row_id = p_rec.row_id;
4957: --
4958: -- currently only support case of update entry data (except for amendment of ins_class and code)
4959: -- additionally not support if eit has been removed at the transferred time
5008: -- since no storage for old eit data in view, unnecessary to change like entry.
5009: update pay_jp_isdf_life_pens_dml_v
5010: set object_version_number = p_rec.object_version_number,
5011: status = p_rec.status,
5012: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
5013: where row_id = p_rec.row_id;
5014: --
5015: end if;
5016: --
5053: --
5054: -- since no storage for old eit data in view, unnecessary to change like entry.
5055: update pay_jp_isdf_life_pens_dml_v
5056: set object_version_number = p_rec.object_version_number,
5057: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
5058: where row_id = p_rec.row_id;
5059: --
5060: end if;
5061: --
5137: --
5138: update pay_jp_isdf_nonlife_dml_v
5139: set object_version_number = p_rec.object_version_number,
5140: status = p_rec.status,
5141: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
5142: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
5143: where row_id = p_rec.row_id;
5144: --
5145: -- currently only support case of update entry data (except for amendment of ins_class and code)
5138: update pay_jp_isdf_nonlife_dml_v
5139: set object_version_number = p_rec.object_version_number,
5140: status = p_rec.status,
5141: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
5142: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
5143: where row_id = p_rec.row_id;
5144: --
5145: -- currently only support case of update entry data (except for amendment of ins_class and code)
5146: -- additionally not support if eit has been removed at the transferred time
5194: -- since no storage for old eit data in view, unnecessary to change like entry.
5195: update pay_jp_isdf_nonlife_dml_v
5196: set object_version_number = p_rec.object_version_number,
5197: status = p_rec.status,
5198: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
5199: where row_id = p_rec.row_id;
5200: --
5201: end if;
5202: --
5239: --
5240: -- since no storage for old eit data in view, unnecessary to change like entry.
5241: update pay_jp_isdf_nonlife_dml_v
5242: set object_version_number = p_rec.object_version_number,
5243: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
5244: where row_id = p_rec.row_id;
5245: --
5246: end if;
5247: --
5683: p_delete_warning => l_warning);
5684: --
5685: update pay_jp_isdf_entry_dml_v
5686: set object_version_number = l_csr_entry.object_version_number + 1,
5687: ins_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.ins_ee_object_version_number),
5688: is_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.is_ee_object_version_number)
5689: where row_id = l_csr_entry.row_id;
5690: --
5691: end loop;
5684: --
5685: update pay_jp_isdf_entry_dml_v
5686: set object_version_number = l_csr_entry.object_version_number + 1,
5687: ins_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.ins_ee_object_version_number),
5688: is_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.is_ee_object_version_number)
5689: where row_id = l_csr_entry.row_id;
5690: --
5691: end loop;
5692: close csr_entry;