eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_NUMBER

Line 209: order by 3, fnd_number.canonical_to_number(pur.row_low_range_or_name);

205: and nvl(put.legislation_code,'X') = nvl(l_legislation_code,nvl(put.legislation_code,'X'))
206: and pur.user_table_id = put.user_table_id
207: and p_effective_date
208: between pur.effective_start_date and pur.effective_end_date
209: order by 3, fnd_number.canonical_to_number(pur.row_low_range_or_name);
210: --
211: cursor csr_udt_val(
212: p_user_table_id in number,
213: p_row_id in number,

Line 290: if fnd_number.canonical_to_number(l_rate) = 0.5 then

286: --
287: end loop;
288: close csr_udt_val;
289: --
290: if fnd_number.canonical_to_number(l_rate) = 0.5 then
291: l_rate := '1/2';
292: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
293: l_rate := '1/4';
294: end if;

Line 292: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then

288: close csr_udt_val;
289: --
290: if fnd_number.canonical_to_number(l_rate) = 0.5 then
291: l_rate := '1/2';
292: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
293: l_rate := '1/4';
294: end if;
295: --
296: g_life_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

Line 320: if fnd_number.canonical_to_number(l_rate) = 0.5 then

316: --
317: end loop;
318: close csr_udt_val;
319: --
320: if fnd_number.canonical_to_number(l_rate) = 0.5 then
321: l_rate := '1/2';
322: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
323: l_rate := '1/4';
324: end if;

Line 322: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then

318: close csr_udt_val;
319: --
320: if fnd_number.canonical_to_number(l_rate) = 0.5 then
321: l_rate := '1/2';
322: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
323: l_rate := '1/4';
324: end if;
325: --
326: g_life_calc3 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

Line 397: if fnd_number.canonical_to_number(l_rate) = 0.5 then

393: --
394: end loop;
395: close csr_udt_val;
396: --
397: if fnd_number.canonical_to_number(l_rate) = 0.5 then
398: l_rate := '1/2';
399: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
400: l_rate := '1/4';
401: end if;

Line 399: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then

395: close csr_udt_val;
396: --
397: if fnd_number.canonical_to_number(l_rate) = 0.5 then
398: l_rate := '1/2';
399: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
400: l_rate := '1/4';
401: end if;
402: --
403: g_lnonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

Line 468: if fnd_number.canonical_to_number(l_rate) = 0.5 then

464: --
465: end loop;
466: close csr_udt_val;
467: --
468: if fnd_number.canonical_to_number(l_rate) = 0.5 then
469: l_rate := '1/2';
470: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
471: l_rate := '1/4';
472: end if;

Line 470: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then

466: close csr_udt_val;
467: --
468: if fnd_number.canonical_to_number(l_rate) = 0.5 then
469: l_rate := '1/2';
470: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
471: l_rate := '1/4';
472: end if;
473: --
474: g_snonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

Line 640: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then

636: g_sp_calc_exp1b_fmt := to_char(g_sp_calc_exp1b);
637: g_sp_calc_exp1b_fmt := to_char(to_number(g_sp_calc_exp1b_fmt),fnd_currency.get_format_mask('JPY',40));
638: g_sp_calc_cal1 := to_char(c_sp_calc_earned_inc_calc1);
639: --
640: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then
641: l_sp_calc_other_inc_calc_rate := '1/2';
642: elsif fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.25 then
643: l_sp_calc_other_inc_calc_rate := '1/4';
644: end if;

Line 642: elsif fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.25 then

638: g_sp_calc_cal1 := to_char(c_sp_calc_earned_inc_calc1);
639: --
640: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then
641: l_sp_calc_other_inc_calc_rate := '1/2';
642: elsif fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.25 then
643: l_sp_calc_other_inc_calc_rate := '1/4';
644: end if;
645: --
646: g_sp_calc_cal6 := 'x '||l_sp_calc_other_inc_calc_rate;

Line 656: if fnd_number.canonical_to_number(l_csr_udt_row.row_low_range_or_name) > c_inc_spouse_dct_max then

652: --
653: fetch csr_udt_row into l_csr_udt_row;
654: exit when csr_udt_row%notfound;
655: --
656: if fnd_number.canonical_to_number(l_csr_udt_row.row_low_range_or_name) > c_inc_spouse_dct_max then
657: --
658: l_dct_cnt := l_dct_cnt + 1;
659: l_sp_calc_tbl(l_dct_cnt).range_a := l_csr_udt_row.row_low_range_or_name;
660: l_sp_calc_tbl(l_dct_cnt).range_b := l_csr_udt_row.row_high_range;

Line 669: --l_sp_calc_tbl(l_dct_cnt).val := to_char(fnd_number.canonical_to_number(l_csr_udt_val.value)/c_sp_calc_unit);

665: fetch csr_udt_val into l_csr_udt_val;
666: exit when csr_udt_val%notfound;
667: --
668: if l_csr_udt_val.user_column_name = c_dct_udtcol then
669: --l_sp_calc_tbl(l_dct_cnt).val := to_char(fnd_number.canonical_to_number(l_csr_udt_val.value)/c_sp_calc_unit);
670: l_sp_calc_tbl(l_dct_cnt).val := l_csr_udt_val.value;
671: end if;
672: --
673: end loop;

Line 1385: 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);

1381: for i in 1..l_action_info_tbl.count loop
1382: --
1383: if l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_GEN' then
1384: --
1385: 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);
1386: --
1387: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_PENS' then
1388: --
1389: 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);

Line 1389: 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);

1385: 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);
1386: --
1387: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_LIFE_PENS' then
1388: --
1389: 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);
1390: --
1391: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_NONLIFE' then
1392: --
1393: -- non support calc for negative amount since deduction from multiple type is acceptable, it is not feasible in system.

Line 1394: if nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0) > 0 then

1390: --
1391: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_NONLIFE' then
1392: --
1393: -- non support calc for negative amount since deduction from multiple type is acceptable, it is not feasible in system.
1394: if nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0) > 0 then
1395: --
1396: if l_action_info_tbl(i).action_information2 = 'EQ' then
1397: 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);
1398: elsif l_action_info_tbl(i).action_information2 = 'L' then

Line 1397: 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);

1393: -- non support calc for negative amount since deduction from multiple type is acceptable, it is not feasible in system.
1394: if nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0) > 0 then
1395: --
1396: if l_action_info_tbl(i).action_information2 = 'EQ' then
1397: 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);
1398: elsif l_action_info_tbl(i).action_information2 = 'L' then
1399: 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);
1400: elsif l_action_info_tbl(i).action_information2 = 'S' then
1401: 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);

Line 1399: 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);

1395: --
1396: if l_action_info_tbl(i).action_information2 = 'EQ' then
1397: 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);
1398: elsif l_action_info_tbl(i).action_information2 = 'L' then
1399: 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);
1400: elsif l_action_info_tbl(i).action_information2 = 'S' then
1401: 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);
1402: end if;
1403: --

Line 1401: 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);

1397: 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);
1398: elsif l_action_info_tbl(i).action_information2 = 'L' then
1399: 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);
1400: elsif l_action_info_tbl(i).action_information2 = 'S' then
1401: 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);
1402: end if;
1403: --
1404: end if;
1405: --

Line 1409: 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);

1405: --
1406: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SOCIAL' then
1407: --
1408: if l_action_info_tbl(i).action_information7 = 'Y' then
1409: 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);
1410: end if;
1411: --
1412: 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);
1413: --

Line 1412: 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);

1408: if l_action_info_tbl(i).action_information7 = 'Y' then
1409: 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);
1410: end if;
1411: --
1412: 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);
1413: --
1414: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1415: --
1416: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);

Line 1416: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);

1412: 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);
1413: --
1414: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1415: --
1416: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1417: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1418: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1419: --
1420: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then

Line 1417: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);

1413: --
1414: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1415: --
1416: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1417: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1418: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1419: --
1420: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1421: --

Line 1418: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);

1414: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_MUTUAL_AID' then
1415: --
1416: p_calc_total_rec.mutual_aid_ec := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1417: p_calc_total_rec.mutual_aid_p := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information3),0);
1418: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1419: --
1420: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1421: --
1422: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);

Line 1422: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);

1418: p_calc_total_rec.mutual_aid_dsc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1419: --
1420: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1421: --
1422: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1423: p_calc_total_rec.sp_spouse_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1424: p_calc_total_rec.sp_sp_type := l_action_info_tbl(i).action_information7;
1425: p_calc_total_rec.sp_wid_type := l_action_info_tbl(i).action_information8;
1426: p_calc_total_rec.sp_dct_exc := l_action_info_tbl(i).action_information9;

Line 1423: p_calc_total_rec.sp_spouse_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);

1419: --
1420: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE' then
1421: --
1422: p_calc_total_rec.sp_emp_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1423: p_calc_total_rec.sp_spouse_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1424: p_calc_total_rec.sp_sp_type := l_action_info_tbl(i).action_information7;
1425: p_calc_total_rec.sp_wid_type := l_action_info_tbl(i).action_information8;
1426: p_calc_total_rec.sp_dct_exc := l_action_info_tbl(i).action_information9;
1427: --

Line 1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);

1427: --
1428: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE_INC' then
1429: --
1430: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);

Line 1432: 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);

1428: elsif l_action_info_tbl(i).action_information_category = 'JP_ISDF_SPOUSE_INC' then
1429: --
1430: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);

Line 1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);

1429: --
1430: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);

Line 1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);

1430: p_calc_total_rec.sp_inc_cnt := p_calc_total_rec.sp_inc_cnt + 1;
1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);

Line 1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);

1431: p_calc_total_rec.sp_earned_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information2),0);
1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);

Line 1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);

1432: 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);
1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);

Line 1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);

1433: p_calc_total_rec.sp_business_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information4),0);
1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);

Line 1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);

1434: p_calc_total_rec.sp_business_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information5),0);
1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);

Line 1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);

1435: p_calc_total_rec.sp_miscellaneous_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information6),0);
1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);

Line 1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);

1436: p_calc_total_rec.sp_miscellaneous_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information7),0);
1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);

Line 1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);

1437: p_calc_total_rec.sp_dividend_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information8),0);
1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);

Line 1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);

1438: p_calc_total_rec.sp_dividend_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information9),0);
1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);

Line 1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);

1439: p_calc_total_rec.sp_real_estate_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information10),0);
1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);

Line 1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);

1440: p_calc_total_rec.sp_real_estate_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information11),0);
1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1448: --

Line 1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);

1441: p_calc_total_rec.sp_retirement_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information12),0);
1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1448: --
1449: end if;

Line 1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);

1442: p_calc_total_rec.sp_retirement_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information13),0);
1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1448: --
1449: end if;
1450: --

Line 1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);

1443: p_calc_total_rec.sp_other_inc := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information14),0);
1444: p_calc_total_rec.sp_other_inc_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information15),0);
1445: p_calc_total_rec.sp_other_inc_exp_dct := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information16),0);
1446: p_calc_total_rec.sp_other_inc_exp_tmp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information17),0);
1447: p_calc_total_rec.sp_other_inc_exp_tmp_exp := nvl(fnd_number.canonical_to_number(l_action_info_tbl(i).action_information18),0);
1448: --
1449: end if;
1450: --
1451: end loop;

Line 2969: -- p_finalized_by => fnd_number.number_to_canonical(fnd_global.user_id),

2965: -- p_action_information_id => l_assact_rec.assignment_action_id,
2966: -- p_object_version_number => p_object_version_number,
2967: -- p_transaction_status => 'F',
2968: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),
2969: -- p_finalized_by => fnd_number.number_to_canonical(fnd_global.user_id),
2970: -- p_user_comments => p_user_comments,
2971: -- p_admin_comments => l_assact_rec.admin_comments,
2972: -- p_transfer_status => l_assact_rec.transfer_status,
2973: -- p_transfer_date => l_assact_rec.transfer_date,

Line 2979: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),

2975: update pay_jp_isdf_assact_dml_v
2976: set object_version_number = p_object_version_number,
2977: transaction_status = 'F',
2978: finalized_date = fnd_date.date_to_canonical(l_submission_date),
2979: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),
2980: user_comments = p_user_comments
2981: where row_id = l_assact_rec.row_id;
2982: --
2983: if g_debug then

Line 3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),

3415: p_input_value_id2 => c_life_pens_iv_id,
3416: p_input_value_id3 => c_nonlife_long_iv_id,
3417: p_input_value_id4 => c_nonlife_short_iv_id,
3418: p_input_value_id5 => c_earthquake_iv_id,
3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

Line 3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),

3416: p_input_value_id3 => c_nonlife_long_iv_id,
3417: p_input_value_id4 => c_nonlife_short_iv_id,
3418: p_input_value_id5 => c_earthquake_iv_id,
3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3424: p_effective_start_date => l_esd,

Line 3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),

3417: p_input_value_id4 => c_nonlife_short_iv_id,
3418: p_input_value_id5 => c_earthquake_iv_id,
3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3424: p_effective_start_date => l_esd,
3425: p_effective_end_date => l_eed,

Line 3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),

3418: p_input_value_id5 => c_earthquake_iv_id,
3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3424: p_effective_start_date => l_esd,
3425: p_effective_end_date => l_eed,
3426: p_update_warning => l_warning);

Line 3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

3419: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3420: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3421: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3422: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3423: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3424: p_effective_start_date => l_esd,
3425: p_effective_end_date => l_eed,
3426: p_update_warning => l_warning);
3427: --

Line 3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),

3454: p_input_value_id2 => c_life_pens_iv_id,
3455: p_input_value_id3 => c_nonlife_long_iv_id,
3456: p_input_value_id4 => c_nonlife_short_iv_id,
3457: p_input_value_id5 => c_earthquake_iv_id,
3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

Line 3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),

3455: p_input_value_id3 => c_nonlife_long_iv_id,
3456: p_input_value_id4 => c_nonlife_short_iv_id,
3457: p_input_value_id5 => c_earthquake_iv_id,
3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3463: p_element_entry_id => p_rec.ins_element_entry_id,

Line 3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),

3456: p_input_value_id4 => c_nonlife_short_iv_id,
3457: p_input_value_id5 => c_earthquake_iv_id,
3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3463: p_element_entry_id => p_rec.ins_element_entry_id,
3464: p_object_version_number => p_rec.ins_ee_object_version_number,

Line 3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),

3457: p_input_value_id5 => c_earthquake_iv_id,
3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3463: p_element_entry_id => p_rec.ins_element_entry_id,
3464: p_object_version_number => p_rec.ins_ee_object_version_number,
3465: p_effective_start_date => l_esd,

Line 3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

3458: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3459: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3460: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3461: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3462: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3463: p_element_entry_id => p_rec.ins_element_entry_id,
3464: p_object_version_number => p_rec.ins_ee_object_version_number,
3465: p_effective_start_date => l_esd,
3466: p_effective_end_date => l_eed,

Line 3490: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),

3486: p_input_value_id5 => c_social_iv_id,
3487: p_input_value_id6 => c_mutual_aid_iv_id,
3488: p_input_value_id7 => c_spouse_iv_id,
3489: p_input_value_id9 => c_national_pens_iv_id,
3490: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3491: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3492: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3493: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3494: p_effective_start_date => l_esd,

Line 3491: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),

3487: p_input_value_id6 => c_mutual_aid_iv_id,
3488: p_input_value_id7 => c_spouse_iv_id,
3489: p_input_value_id9 => c_national_pens_iv_id,
3490: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3491: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3492: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3493: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3494: p_effective_start_date => l_esd,
3495: p_effective_end_date => l_eed,

Line 3492: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),

3488: p_input_value_id7 => c_spouse_iv_id,
3489: p_input_value_id9 => c_national_pens_iv_id,
3490: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3491: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3492: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3493: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3494: p_effective_start_date => l_esd,
3495: p_effective_end_date => l_eed,
3496: p_update_warning => l_warning);

Line 3493: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),

3489: p_input_value_id9 => c_national_pens_iv_id,
3490: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3491: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3492: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3493: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3494: p_effective_start_date => l_esd,
3495: p_effective_end_date => l_eed,
3496: p_update_warning => l_warning);
3497: --

Line 3527: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),

3523: p_input_value_id5 => c_social_iv_id,
3524: p_input_value_id6 => c_mutual_aid_iv_id,
3525: p_input_value_id7 => c_spouse_iv_id,
3526: p_input_value_id9 => c_national_pens_iv_id,
3527: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3528: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3529: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3530: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3531: p_element_entry_id => p_rec.is_element_entry_id,

Line 3528: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),

3524: p_input_value_id6 => c_mutual_aid_iv_id,
3525: p_input_value_id7 => c_spouse_iv_id,
3526: p_input_value_id9 => c_national_pens_iv_id,
3527: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3528: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3529: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3530: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3531: p_element_entry_id => p_rec.is_element_entry_id,
3532: p_object_version_number => p_rec.is_ee_object_version_number,

Line 3529: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),

3525: p_input_value_id7 => c_spouse_iv_id,
3526: p_input_value_id9 => c_national_pens_iv_id,
3527: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3528: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3529: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3530: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3531: p_element_entry_id => p_rec.is_element_entry_id,
3532: p_object_version_number => p_rec.is_ee_object_version_number,
3533: p_effective_start_date => l_esd,

Line 3530: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),

3526: p_input_value_id9 => c_national_pens_iv_id,
3527: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3528: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3529: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3530: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3531: p_element_entry_id => p_rec.is_element_entry_id,
3532: p_object_version_number => p_rec.is_ee_object_version_number,
3533: p_effective_start_date => l_esd,
3534: p_effective_end_date => l_eed,

Line 3559: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),

3555: update pay_jp_isdf_entry_dml_v
3556: set object_version_number = p_rec.object_version_number,
3557: status = l_status,
3558: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3559: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3560: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3561: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
3562: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
3563: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,

Line 3560: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),

3556: set object_version_number = p_rec.object_version_number,
3557: status = l_status,
3558: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3559: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3560: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3561: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
3562: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
3563: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
3564: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,

Line 3567: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),

3563: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
3564: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
3565: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
3566: is_datetrack_update_mode = l_is_datetrack_update_mode,
3567: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3568: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3569: social_ins_prem_o = l_entry_rec.social_ins_prem,
3570: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
3571: spouse_income_o = l_entry_rec.spouse_income,

Line 3568: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),

3564: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
3565: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
3566: is_datetrack_update_mode = l_is_datetrack_update_mode,
3567: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3568: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3569: social_ins_prem_o = l_entry_rec.social_ins_prem,
3570: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
3571: spouse_income_o = l_entry_rec.spouse_income,
3572: national_pens_ins_prem_o = l_entry_rec.national_pens_ins_prem

Line 3582: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),

3578: set object_version_number = p_rec.object_version_number,
3579: status = l_status,
3580: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3581: is_datetrack_update_mode = l_is_datetrack_update_mode,
3582: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3583: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3584: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3585: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
3586: where row_id = p_rec.row_id;

Line 3583: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),

3579: status = l_status,
3580: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3581: is_datetrack_update_mode = l_is_datetrack_update_mode,
3582: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3583: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3584: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3585: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
3586: where row_id = p_rec.row_id;
3587: --

Line 3584: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),

3580: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3581: is_datetrack_update_mode = l_is_datetrack_update_mode,
3582: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3583: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3584: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3585: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
3586: where row_id = p_rec.row_id;
3587: --
3588: end if;

Line 3585: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)

3581: is_datetrack_update_mode = l_is_datetrack_update_mode,
3582: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3583: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3584: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3585: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number)
3586: where row_id = p_rec.row_id;
3587: --
3588: end if;
3589: --

Line 3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),

3611: p_input_value_id2 => c_life_pens_iv_id,
3612: p_input_value_id3 => c_nonlife_long_iv_id,
3613: p_input_value_id4 => c_nonlife_short_iv_id,
3614: p_input_value_id5 => c_earthquake_iv_id,
3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

Line 3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),

3612: p_input_value_id3 => c_nonlife_long_iv_id,
3613: p_input_value_id4 => c_nonlife_short_iv_id,
3614: p_input_value_id5 => c_earthquake_iv_id,
3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3620: p_effective_start_date => l_esd,

Line 3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),

3613: p_input_value_id4 => c_nonlife_short_iv_id,
3614: p_input_value_id5 => c_earthquake_iv_id,
3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3620: p_effective_start_date => l_esd,
3621: p_effective_end_date => l_eed,

Line 3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),

3614: p_input_value_id5 => c_earthquake_iv_id,
3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3620: p_effective_start_date => l_esd,
3621: p_effective_end_date => l_eed,
3622: p_update_warning => l_warning);

Line 3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

3615: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3616: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3617: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3618: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3619: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3620: p_effective_start_date => l_esd,
3621: p_effective_end_date => l_eed,
3622: p_update_warning => l_warning);
3623: --

Line 3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),

3654: p_input_value_id2 => c_life_pens_iv_id,
3655: p_input_value_id3 => c_nonlife_long_iv_id,
3656: p_input_value_id4 => c_nonlife_short_iv_id,
3657: p_input_value_id5 => c_earthquake_iv_id,
3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

Line 3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),

3655: p_input_value_id3 => c_nonlife_long_iv_id,
3656: p_input_value_id4 => c_nonlife_short_iv_id,
3657: p_input_value_id5 => c_earthquake_iv_id,
3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3663: p_element_entry_id => p_rec.ins_element_entry_id,

Line 3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),

3656: p_input_value_id4 => c_nonlife_short_iv_id,
3657: p_input_value_id5 => c_earthquake_iv_id,
3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3663: p_element_entry_id => p_rec.ins_element_entry_id,
3664: p_object_version_number => p_rec.ins_ee_object_version_number,

Line 3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),

3657: p_input_value_id5 => c_earthquake_iv_id,
3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3663: p_element_entry_id => p_rec.ins_element_entry_id,
3664: p_object_version_number => p_rec.ins_ee_object_version_number,
3665: p_effective_start_date => l_esd,

Line 3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),

3658: p_entry_value1 => fnd_number.number_to_canonical(p_rec.life_gen_ins_prem),
3659: p_entry_value2 => fnd_number.number_to_canonical(p_rec.life_pens_ins_prem),
3660: p_entry_value3 => fnd_number.number_to_canonical(p_rec.nonlife_long_ins_prem),
3661: p_entry_value4 => fnd_number.number_to_canonical(p_rec.nonlife_short_ins_prem),
3662: p_entry_value5 => fnd_number.number_to_canonical(p_rec.earthquake_ins_prem),
3663: p_element_entry_id => p_rec.ins_element_entry_id,
3664: p_object_version_number => p_rec.ins_ee_object_version_number,
3665: p_effective_start_date => l_esd,
3666: p_effective_end_date => l_eed,

Line 3696: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),

3692: p_input_value_id5 => c_social_iv_id,
3693: p_input_value_id6 => c_mutual_aid_iv_id,
3694: p_input_value_id7 => c_spouse_iv_id,
3695: p_input_value_id9 => c_national_pens_iv_id,
3696: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3697: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3698: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3699: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3700: p_effective_start_date => l_esd,

Line 3697: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),

3693: p_input_value_id6 => c_mutual_aid_iv_id,
3694: p_input_value_id7 => c_spouse_iv_id,
3695: p_input_value_id9 => c_national_pens_iv_id,
3696: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3697: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3698: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3699: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3700: p_effective_start_date => l_esd,
3701: p_effective_end_date => l_eed,

Line 3698: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),

3694: p_input_value_id7 => c_spouse_iv_id,
3695: p_input_value_id9 => c_national_pens_iv_id,
3696: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3697: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3698: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3699: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3700: p_effective_start_date => l_esd,
3701: p_effective_end_date => l_eed,
3702: p_update_warning => l_warning);

Line 3699: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),

3695: p_input_value_id9 => c_national_pens_iv_id,
3696: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3697: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3698: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3699: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3700: p_effective_start_date => l_esd,
3701: p_effective_end_date => l_eed,
3702: p_update_warning => l_warning);
3703: --

Line 3737: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),

3733: p_input_value_id5 => c_social_iv_id,
3734: p_input_value_id6 => c_mutual_aid_iv_id,
3735: p_input_value_id7 => c_spouse_iv_id,
3736: p_input_value_id9 => c_national_pens_iv_id,
3737: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3738: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3739: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3740: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3741: p_element_entry_id => p_rec.is_element_entry_id,

Line 3738: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),

3734: p_input_value_id6 => c_mutual_aid_iv_id,
3735: p_input_value_id7 => c_spouse_iv_id,
3736: p_input_value_id9 => c_national_pens_iv_id,
3737: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3738: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3739: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3740: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3741: p_element_entry_id => p_rec.is_element_entry_id,
3742: p_object_version_number => p_rec.is_ee_object_version_number,

Line 3739: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),

3735: p_input_value_id7 => c_spouse_iv_id,
3736: p_input_value_id9 => c_national_pens_iv_id,
3737: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3738: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3739: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3740: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3741: p_element_entry_id => p_rec.is_element_entry_id,
3742: p_object_version_number => p_rec.is_ee_object_version_number,
3743: p_effective_start_date => l_esd,

Line 3740: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),

3736: p_input_value_id9 => c_national_pens_iv_id,
3737: p_entry_value5 => fnd_number.number_to_canonical(p_rec.social_ins_prem),
3738: p_entry_value6 => fnd_number.number_to_canonical(p_rec.mutual_aid_prem),
3739: p_entry_value7 => fnd_number.number_to_canonical(p_rec.spouse_income),
3740: p_entry_value9 => fnd_number.number_to_canonical(p_rec.national_pens_ins_prem),
3741: p_element_entry_id => p_rec.is_element_entry_id,
3742: p_object_version_number => p_rec.is_ee_object_version_number,
3743: p_effective_start_date => l_esd,
3744: p_effective_end_date => l_eed,

Line 3769: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),

3765: update pay_jp_isdf_entry_dml_v
3766: set object_version_number = p_rec.object_version_number,
3767: status = l_status,
3768: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3769: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3770: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3771: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
3772: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
3773: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,

Line 3770: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),

3766: set object_version_number = p_rec.object_version_number,
3767: status = l_status,
3768: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3769: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3770: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3771: life_gen_ins_prem_o = l_entry_rec.life_gen_ins_prem,
3772: life_pens_ins_prem_o = l_entry_rec.life_pens_ins_prem,
3773: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
3774: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,

Line 3777: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),

3773: nonlife_long_ins_prem_o = l_entry_rec.nonlife_long_ins_prem,
3774: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
3775: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
3776: is_datetrack_update_mode = l_is_datetrack_update_mode,
3777: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3778: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3779: social_ins_prem_o = l_entry_rec.social_ins_prem,
3780: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
3781: spouse_income_o = l_entry_rec.spouse_income,

Line 3778: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),

3774: nonlife_short_ins_prem_o = l_entry_rec.nonlife_short_ins_prem,
3775: earthquake_ins_prem_o = l_entry_rec.earthquake_ins_prem,
3776: is_datetrack_update_mode = l_is_datetrack_update_mode,
3777: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3778: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3779: social_ins_prem_o = l_entry_rec.social_ins_prem,
3780: mutual_aid_prem_o = l_entry_rec.mutual_aid_prem,
3781: spouse_income_o = l_entry_rec.spouse_income,
3782: national_pens_ins_prem_o = l_entry_rec.national_pens_ins_prem

Line 3791: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),

3787: update pay_jp_isdf_entry_dml_v
3788: set object_version_number = p_rec.object_version_number,
3789: status = l_status,
3790: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3791: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3792: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3793: life_gen_ins_prem_o = null,
3794: life_pens_ins_prem_o = null,
3795: nonlife_long_ins_prem_o = null,

Line 3792: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),

3788: set object_version_number = p_rec.object_version_number,
3789: status = l_status,
3790: ins_datetrack_update_mode = l_ins_datetrack_update_mode,
3791: ins_element_entry_id = fnd_number.number_to_canonical(l_ins_element_entry_id),
3792: ins_ee_object_version_number = fnd_number.number_to_canonical(l_ins_ee_object_version_number),
3793: life_gen_ins_prem_o = null,
3794: life_pens_ins_prem_o = null,
3795: nonlife_long_ins_prem_o = null,
3796: nonlife_short_ins_prem_o = null,

Line 3799: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),

3795: nonlife_long_ins_prem_o = null,
3796: nonlife_short_ins_prem_o = null,
3797: earthquake_ins_prem_o = null,
3798: is_datetrack_update_mode = l_is_datetrack_update_mode,
3799: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3800: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3801: social_ins_prem_o = null,
3802: mutual_aid_prem_o = null,
3803: spouse_income_o = null,

Line 3800: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),

3796: nonlife_short_ins_prem_o = null,
3797: earthquake_ins_prem_o = null,
3798: is_datetrack_update_mode = l_is_datetrack_update_mode,
3799: is_element_entry_id = fnd_number.number_to_canonical(l_is_element_entry_id),
3800: is_ee_object_version_number = fnd_number.number_to_canonical(l_is_ee_object_version_number),
3801: social_ins_prem_o = null,
3802: mutual_aid_prem_o = null,
3803: spouse_income_o = null,
3804: national_pens_ins_prem_o = null

Line 3886: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),

3882: --
3883: update pay_jp_isdf_life_gen_dml_v
3884: set object_version_number = p_rec.object_version_number,
3885: status = p_rec.status,
3886: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
3887: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
3888: where row_id = p_rec.row_id;
3889: --
3890: -- currently only support case of update entry data (except for amendment of ins_class and code)

Line 3887: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)

3883: update pay_jp_isdf_life_gen_dml_v
3884: set object_version_number = p_rec.object_version_number,
3885: status = p_rec.status,
3886: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
3887: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
3888: where row_id = p_rec.row_id;
3889: --
3890: -- currently only support case of update entry data (except for amendment of ins_class and code)
3891: -- additionally not support if eit has been removed at the transferred time

Line 3941: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)

3937: -- since no storage for old eit data in view, unnecessary to change like entry.
3938: update pay_jp_isdf_life_gen_dml_v
3939: set object_version_number = p_rec.object_version_number,
3940: status = p_rec.status,
3941: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
3942: where row_id = p_rec.row_id;
3943: --
3944: end if;
3945: --

Line 3984: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)

3980: --
3981: -- since no storage for old eit data in view, unnecessary to change like entry.
3982: update pay_jp_isdf_life_gen_dml_v
3983: set object_version_number = p_rec.object_version_number,
3984: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
3985: where row_id = p_rec.row_id;
3986: --
3987: end if;
3988: --

Line 4067: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),

4063: --
4064: update pay_jp_isdf_life_pens_dml_v
4065: set object_version_number = p_rec.object_version_number,
4066: status = p_rec.status,
4067: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4068: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4069: where row_id = p_rec.row_id;
4070: --
4071: -- currently only support case of update entry data (except for amendment of ins_class and code)

Line 4068: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)

4064: update pay_jp_isdf_life_pens_dml_v
4065: set object_version_number = p_rec.object_version_number,
4066: status = p_rec.status,
4067: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4068: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4069: where row_id = p_rec.row_id;
4070: --
4071: -- currently only support case of update entry data (except for amendment of ins_class and code)
4072: -- additionally not support if eit has been removed at the transferred time

Line 4123: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)

4119: -- since no storage for old eit data in view, unnecessary to change like entry.
4120: update pay_jp_isdf_life_pens_dml_v
4121: set object_version_number = p_rec.object_version_number,
4122: status = p_rec.status,
4123: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4124: where row_id = p_rec.row_id;
4125: --
4126: end if;
4127: --

Line 4167: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)

4163: --
4164: -- since no storage for old eit data in view, unnecessary to change like entry.
4165: update pay_jp_isdf_life_pens_dml_v
4166: set object_version_number = p_rec.object_version_number,
4167: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4168: where row_id = p_rec.row_id;
4169: --
4170: end if;
4171: --

Line 4251: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),

4247: --
4248: update pay_jp_isdf_nonlife_dml_v
4249: set object_version_number = p_rec.object_version_number,
4250: status = p_rec.status,
4251: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4252: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4253: where row_id = p_rec.row_id;
4254: --
4255: -- currently only support case of update entry data (except for amendment of ins_class and code)

Line 4252: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)

4248: update pay_jp_isdf_nonlife_dml_v
4249: set object_version_number = p_rec.object_version_number,
4250: status = p_rec.status,
4251: assignment_extra_info_id = fnd_number.number_to_canonical(p_rec.assignment_extra_info_id),
4252: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4253: where row_id = p_rec.row_id;
4254: --
4255: -- currently only support case of update entry data (except for amendment of ins_class and code)
4256: -- additionally not support if eit has been removed at the transferred time

Line 4308: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)

4304: -- since no storage for old eit data in view, unnecessary to change like entry.
4305: update pay_jp_isdf_nonlife_dml_v
4306: set object_version_number = p_rec.object_version_number,
4307: status = p_rec.status,
4308: aei_object_version_number = fnd_number.number_to_canonical(p_rec.aei_object_version_number)
4309: where row_id = p_rec.row_id;
4310: --
4311: end if;
4312: --

Line 4353: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)

4349: --
4350: -- since no storage for old eit data in view, unnecessary to change like entry.
4351: update pay_jp_isdf_nonlife_dml_v
4352: set object_version_number = p_rec.object_version_number,
4353: aei_object_version_number = fnd_number.number_to_canonical(l_csr_aei.object_version_number)
4354: where row_id = p_rec.row_id;
4355: --
4356: end if;
4357: --

Line 4761: ins_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.ins_ee_object_version_number),

4757: p_delete_warning => l_warning);
4758: --
4759: update pay_jp_isdf_entry_dml_v
4760: set object_version_number = l_csr_entry.object_version_number + 1,
4761: ins_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.ins_ee_object_version_number),
4762: is_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.is_ee_object_version_number)
4763: where row_id = l_csr_entry.row_id;
4764: --
4765: end loop;

Line 4762: is_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.is_ee_object_version_number)

4758: --
4759: update pay_jp_isdf_entry_dml_v
4760: set object_version_number = l_csr_entry.object_version_number + 1,
4761: ins_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.ins_ee_object_version_number),
4762: is_ee_object_version_number = fnd_number.number_to_canonical(l_csr_entry.is_ee_object_version_number)
4763: where row_id = l_csr_entry.row_id;
4764: --
4765: end loop;
4766: close csr_entry;