DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_CURRENCY

Line 266: g_life_range1b := to_char(to_number(g_life_range1b),fnd_currency.get_format_mask('JPY',40));

262: --
263: if csr_udt_row%rowcount = 1 then
264: --
265: g_life_range1b := l_csr_udt_row.row_high_range;
266: g_life_range1b := to_char(to_number(g_life_range1b),fnd_currency.get_format_mask('JPY',40));
267: --
268: elsif csr_udt_row%rowcount = 2 then
269: --
270: g_life_range2a := l_csr_udt_row.row_low_range_or_name;

Line 272: g_life_range2a := to_char(to_number(g_life_range2a),fnd_currency.get_format_mask('JPY',40));

268: elsif csr_udt_row%rowcount = 2 then
269: --
270: g_life_range2a := l_csr_udt_row.row_low_range_or_name;
271: g_life_range2b := l_csr_udt_row.row_high_range;
272: g_life_range2a := to_char(to_number(g_life_range2a),fnd_currency.get_format_mask('JPY',40));
273: g_life_range2b := to_char(to_number(g_life_range2b),fnd_currency.get_format_mask('JPY',40));
274: --
275: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
276: loop

Line 273: g_life_range2b := to_char(to_number(g_life_range2b),fnd_currency.get_format_mask('JPY',40));

269: --
270: g_life_range2a := l_csr_udt_row.row_low_range_or_name;
271: g_life_range2b := l_csr_udt_row.row_high_range;
272: g_life_range2a := to_char(to_number(g_life_range2a),fnd_currency.get_format_mask('JPY',40));
273: g_life_range2b := to_char(to_number(g_life_range2b),fnd_currency.get_format_mask('JPY',40));
274: --
275: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
276: loop
277: --

Line 296: g_life_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

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));
297: --
298: elsif csr_udt_row%rowcount = 3 then
299: --
300: g_life_range3a := l_csr_udt_row.row_low_range_or_name;

Line 302: g_life_range3a := to_char(to_number(g_life_range3a),fnd_currency.get_format_mask('JPY',40));

298: elsif csr_udt_row%rowcount = 3 then
299: --
300: g_life_range3a := l_csr_udt_row.row_low_range_or_name;
301: g_life_range3b := l_csr_udt_row.row_high_range;
302: g_life_range3a := to_char(to_number(g_life_range3a),fnd_currency.get_format_mask('JPY',40));
303: g_life_range3b := to_char(to_number(g_life_range3b),fnd_currency.get_format_mask('JPY',40));
304: --
305: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
306: loop

Line 303: g_life_range3b := to_char(to_number(g_life_range3b),fnd_currency.get_format_mask('JPY',40));

299: --
300: g_life_range3a := l_csr_udt_row.row_low_range_or_name;
301: g_life_range3b := l_csr_udt_row.row_high_range;
302: g_life_range3a := to_char(to_number(g_life_range3a),fnd_currency.get_format_mask('JPY',40));
303: g_life_range3b := to_char(to_number(g_life_range3b),fnd_currency.get_format_mask('JPY',40));
304: --
305: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
306: loop
307: --

Line 326: g_life_calc3 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

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));
327: --
328: elsif csr_udt_row%rowcount = 4 then
329: --
330: g_life_range4a := l_csr_udt_row.row_low_range_or_name;

Line 331: g_life_range4a := to_char(to_number(g_life_range4a),fnd_currency.get_format_mask('JPY',40));

327: --
328: elsif csr_udt_row%rowcount = 4 then
329: --
330: g_life_range4a := l_csr_udt_row.row_low_range_or_name;
331: g_life_range4a := to_char(to_number(g_life_range4a),fnd_currency.get_format_mask('JPY',40));
332: --
333: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
334: loop
335: --

Line 357: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));

353: g_life_gen_max := g_life_calc4;
354: g_life_pens_max := g_life_calc4;
355: g_life_ins_max := to_char(to_number(g_life_gen_max) + to_number(g_life_pens_max));
356: --
357: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
358: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
359: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
360: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
361: --

Line 358: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));

354: g_life_pens_max := g_life_calc4;
355: g_life_ins_max := to_char(to_number(g_life_gen_max) + to_number(g_life_pens_max));
356: --
357: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
358: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
359: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
360: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
361: --
362: --

Line 359: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));

355: g_life_ins_max := to_char(to_number(g_life_gen_max) + to_number(g_life_pens_max));
356: --
357: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
358: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
359: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
360: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
361: --
362: --
363: -- nonlife_ins prompt fetch

Line 360: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));

356: --
357: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
358: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
359: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
360: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
361: --
362: --
363: -- nonlife_ins prompt fetch
364: --

Line 378: g_lnonlife_range1b := to_char(to_number(g_lnonlife_range1b),fnd_currency.get_format_mask('JPY',40));

374: --
375: if csr_udt_row%rowcount = 1 then
376: --
377: g_lnonlife_range1b := l_csr_udt_row.row_high_range;
378: g_lnonlife_range1b := to_char(to_number(g_lnonlife_range1b),fnd_currency.get_format_mask('JPY',40));
379: --
380: elsif csr_udt_row%rowcount = 2 then
381: --
382: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

Line 403: g_lnonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

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));
404: --
405: elsif csr_udt_row%rowcount = 3 then
406: --
407: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

Line 449: g_snonlife_range1b := to_char(to_number(g_snonlife_range1b),fnd_currency.get_format_mask('JPY',40));

445: --
446: if csr_udt_row%rowcount = 1 then
447: --
448: g_snonlife_range1b := l_csr_udt_row.row_high_range;
449: g_snonlife_range1b := to_char(to_number(g_snonlife_range1b),fnd_currency.get_format_mask('JPY',40));
450: --
451: elsif csr_udt_row%rowcount = 2 then
452: --
453: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

Line 474: g_snonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

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));
475: --
476: elsif csr_udt_row%rowcount = 3 then
477: --
478: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

Line 521: g_earthquake_max := to_char(to_number(g_earthquake_max),fnd_currency.get_format_mask('JPY',40));

517: l_effective_date));
518: end if;
519: --
520: g_earthquake_max := c_earthquake_max;
521: g_earthquake_max := to_char(to_number(g_earthquake_max),fnd_currency.get_format_mask('JPY',40));
522: --
523: g_lnonlife_year := to_char(c_nonlife_long_year);
524: g_lnonlife_max := l_lnonlife_calc3;
525: g_snonlife_max := l_snonlife_calc3;

Line 526: g_lnonlife_max := to_char(to_number(g_lnonlife_max),fnd_currency.get_format_mask('JPY',40));

522: --
523: g_lnonlife_year := to_char(c_nonlife_long_year);
524: g_lnonlife_max := l_lnonlife_calc3;
525: g_snonlife_max := l_snonlife_calc3;
526: g_lnonlife_max := to_char(to_number(g_lnonlife_max),fnd_currency.get_format_mask('JPY',40));
527: g_snonlife_max := to_char(to_number(g_snonlife_max),fnd_currency.get_format_mask('JPY',40));
528: --
529: -- + nonlife dct
530: --

Line 527: g_snonlife_max := to_char(to_number(g_snonlife_max),fnd_currency.get_format_mask('JPY',40));

523: g_lnonlife_year := to_char(c_nonlife_long_year);
524: g_lnonlife_max := l_lnonlife_calc3;
525: g_snonlife_max := l_snonlife_calc3;
526: g_lnonlife_max := to_char(to_number(g_lnonlife_max),fnd_currency.get_format_mask('JPY',40));
527: g_snonlife_max := to_char(to_number(g_snonlife_max),fnd_currency.get_format_mask('JPY',40));
528: --
529: -- + nonlife dct
530: --
531: -- value always should be fetched.

Line 580: g_nonlife_max := to_char(to_number(g_nonlife_max),fnd_currency.get_format_mask('JPY',40));

576: end if;
577: --
578: g_nonlife_max := l_nonlife_max;
579: g_nonlife_max_2007 := l_nonlife_max_2007;
580: g_nonlife_max := to_char(to_number(g_nonlife_max),fnd_currency.get_format_mask('JPY',40));
581: g_nonlife_max_2007 := to_char(to_number(g_nonlife_max_2007),fnd_currency.get_format_mask('JPY',40));
582: --
583: --
584: -- spouse prompt fetch

Line 581: g_nonlife_max_2007 := to_char(to_number(g_nonlife_max_2007),fnd_currency.get_format_mask('JPY',40));

577: --
578: g_nonlife_max := l_nonlife_max;
579: g_nonlife_max_2007 := l_nonlife_max_2007;
580: g_nonlife_max := to_char(to_number(g_nonlife_max),fnd_currency.get_format_mask('JPY',40));
581: g_nonlife_max_2007 := to_char(to_number(g_nonlife_max_2007),fnd_currency.get_format_mask('JPY',40));
582: --
583: --
584: -- spouse prompt fetch
585: --

Line 601: g_sp_emp_inc_max := to_char(to_number(g_sp_emp_inc_max),fnd_currency.get_format_mask('JPY',40));

597: l_effective_date));
598: end if;
599: --
600: g_sp_emp_inc_max := c_emp_income_max/c_sp_calc_unit;
601: g_sp_emp_inc_max := to_char(to_number(g_sp_emp_inc_max),fnd_currency.get_format_mask('JPY',40));
602: --
603: l_effective_date := g_effective_date;
604: --
605: if c_inc_spouse_dct_max is null then

Line 616: g_sp_spdct_max := to_char(to_number(g_sp_spdct_max),fnd_currency.get_format_mask('JPY',40));

612: l_effective_date));
613: end if;
614: --
615: g_sp_spdct_max := c_inc_spouse_dct_max/c_sp_calc_unit;
616: g_sp_spdct_max := to_char(to_number(g_sp_spdct_max),fnd_currency.get_format_mask('JPY',40));
617: --
618: l_effective_date := g_effective_date;
619: --
620: if c_spouse_income_max is null then

Line 630: g_sp_spinc_max := to_char(to_number(g_sp_spinc_max),fnd_currency.get_format_mask('JPY',40));

626: l_effective_date));
627: end if;
628: --
629: g_sp_spinc_max := c_spouse_income_max/c_sp_calc_unit;
630: g_sp_spinc_max := to_char(to_number(g_sp_spinc_max),fnd_currency.get_format_mask('JPY',40));
631: --
632: --
633: -- spouse_calc prompt fetch
634: --

Line 637: g_sp_calc_exp1b_fmt := to_char(to_number(g_sp_calc_exp1b_fmt),fnd_currency.get_format_mask('JPY',40));

633: -- spouse_calc prompt fetch
634: --
635: g_sp_calc_exp1b := c_sp_earned_inc_exp;
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';

Line 711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));

707: g_sp_calc_dct_range9a := l_sp_calc_tbl(9).range_a;
708: g_sp_calc_dct_range9b := l_sp_calc_tbl(9).range_b;
709: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
710: --
711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));

Line 712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));

708: g_sp_calc_dct_range9b := l_sp_calc_tbl(9).range_b;
709: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
710: --
711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));

Line 713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));

709: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
710: --
711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));

Line 714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));

710: --
711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));

Line 715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));

711: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));

Line 716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));

712: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));

Line 717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));

713: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));

Line 718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));

714: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));

Line 719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));

715: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));

Line 720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));

716: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));

Line 721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));

717: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));

Line 722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));

718: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));

Line 723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));

719: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));

Line 724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));

720: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));

Line 725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));

721: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));

Line 726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));

722: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));

Line 727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));

723: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));

Line 728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));

724: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));

Line 729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));

725: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));

Line 730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));

726: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));

Line 731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));

727: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));

Line 732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));

728: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));

Line 733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));

729: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));

Line 734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));

730: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
738: --

Line 735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));

731: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
738: --
739: end if;

Line 736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));

732: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
738: --
739: end if;
740: --

Line 737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));

733: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
738: --
739: end if;
740: --
741: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');