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_CURRENCY

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

267: --
268: if csr_udt_row%rowcount = 1 then
269: --
270: g_life_range1b := l_csr_udt_row.row_high_range;
271: g_life_range1b := to_char(to_number(g_life_range1b),fnd_currency.get_format_mask('JPY',40));
272: --
273: elsif csr_udt_row%rowcount = 2 then
274: --
275: g_life_range2a := l_csr_udt_row.row_low_range_or_name;

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

273: elsif csr_udt_row%rowcount = 2 then
274: --
275: g_life_range2a := l_csr_udt_row.row_low_range_or_name;
276: g_life_range2b := l_csr_udt_row.row_high_range;
277: g_life_range2a := to_char(to_number(g_life_range2a),fnd_currency.get_format_mask('JPY',40));
278: g_life_range2b := to_char(to_number(g_life_range2b),fnd_currency.get_format_mask('JPY',40));
279: --
280: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
281: loop

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

274: --
275: g_life_range2a := l_csr_udt_row.row_low_range_or_name;
276: g_life_range2b := l_csr_udt_row.row_high_range;
277: g_life_range2a := to_char(to_number(g_life_range2a),fnd_currency.get_format_mask('JPY',40));
278: g_life_range2b := to_char(to_number(g_life_range2b),fnd_currency.get_format_mask('JPY',40));
279: --
280: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
281: loop
282: --

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

297: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
298: l_rate := '1/4';
299: end if;
300: --
301: g_life_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
302: --
303: elsif csr_udt_row%rowcount = 3 then
304: --
305: g_life_range3a := l_csr_udt_row.row_low_range_or_name;

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

303: elsif csr_udt_row%rowcount = 3 then
304: --
305: g_life_range3a := l_csr_udt_row.row_low_range_or_name;
306: g_life_range3b := l_csr_udt_row.row_high_range;
307: g_life_range3a := to_char(to_number(g_life_range3a),fnd_currency.get_format_mask('JPY',40));
308: g_life_range3b := to_char(to_number(g_life_range3b),fnd_currency.get_format_mask('JPY',40));
309: --
310: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
311: loop

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

304: --
305: g_life_range3a := l_csr_udt_row.row_low_range_or_name;
306: g_life_range3b := l_csr_udt_row.row_high_range;
307: g_life_range3a := to_char(to_number(g_life_range3a),fnd_currency.get_format_mask('JPY',40));
308: g_life_range3b := to_char(to_number(g_life_range3b),fnd_currency.get_format_mask('JPY',40));
309: --
310: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
311: loop
312: --

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

327: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
328: l_rate := '1/4';
329: end if;
330: --
331: g_life_calc3 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
332: --
333: elsif csr_udt_row%rowcount = 4 then
334: --
335: g_life_range4a := l_csr_udt_row.row_low_range_or_name;

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

332: --
333: elsif csr_udt_row%rowcount = 4 then
334: --
335: g_life_range4a := l_csr_udt_row.row_low_range_or_name;
336: g_life_range4a := to_char(to_number(g_life_range4a),fnd_currency.get_format_mask('JPY',40));
337: --
338: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);
339: loop
340: --

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

358: g_life_gen_max := g_life_calc4;
359: g_life_pens_max := g_life_calc4;
360: g_life_ins_max := to_char(to_number(g_life_gen_max) + to_number(g_life_pens_max));
361: --
362: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
363: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
364: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
365: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
366: --

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

359: g_life_pens_max := g_life_calc4;
360: g_life_ins_max := to_char(to_number(g_life_gen_max) + to_number(g_life_pens_max));
361: --
362: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
363: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
364: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
365: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
366: --
367: --

Line 364: 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_gen_max) + to_number(g_life_pens_max));
361: --
362: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
363: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
364: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
365: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
366: --
367: --
368: -- nonlife_ins prompt fetch

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

361: --
362: g_life_calc4 := to_char(to_number(g_life_calc4),fnd_currency.get_format_mask('JPY',40));
363: g_life_gen_max := to_char(to_number(g_life_gen_max),fnd_currency.get_format_mask('JPY',40));
364: g_life_pens_max := to_char(to_number(g_life_pens_max),fnd_currency.get_format_mask('JPY',40));
365: g_life_ins_max := to_char(to_number(g_life_ins_max),fnd_currency.get_format_mask('JPY',40));
366: --
367: --
368: -- nonlife_ins prompt fetch
369: --

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

379: --
380: if csr_udt_row%rowcount = 1 then
381: --
382: g_lnonlife_range1b := l_csr_udt_row.row_high_range;
383: g_lnonlife_range1b := to_char(to_number(g_lnonlife_range1b),fnd_currency.get_format_mask('JPY',40));
384: --
385: elsif csr_udt_row%rowcount = 2 then
386: --
387: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

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

404: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
405: l_rate := '1/4';
406: end if;
407: --
408: g_lnonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
409: --
410: elsif csr_udt_row%rowcount = 3 then
411: --
412: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

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

450: --
451: if csr_udt_row%rowcount = 1 then
452: --
453: g_snonlife_range1b := l_csr_udt_row.row_high_range;
454: g_snonlife_range1b := to_char(to_number(g_snonlife_range1b),fnd_currency.get_format_mask('JPY',40));
455: --
456: elsif csr_udt_row%rowcount = 2 then
457: --
458: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

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

475: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
476: l_rate := '1/4';
477: end if;
478: --
479: g_snonlife_calc2 := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
480: --
481: elsif csr_udt_row%rowcount = 3 then
482: --
483: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,l_effective_date);

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

522: l_effective_date));
523: end if;
524: --
525: g_earthquake_max := c_earthquake_max;
526: g_earthquake_max := to_char(to_number(g_earthquake_max),fnd_currency.get_format_mask('JPY',40));
527: --
528: g_lnonlife_year := to_char(c_nonlife_long_year);
529: g_lnonlife_max := l_lnonlife_calc3;
530: g_snonlife_max := l_snonlife_calc3;

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

527: --
528: g_lnonlife_year := to_char(c_nonlife_long_year);
529: g_lnonlife_max := l_lnonlife_calc3;
530: g_snonlife_max := l_snonlife_calc3;
531: g_lnonlife_max := to_char(to_number(g_lnonlife_max),fnd_currency.get_format_mask('JPY',40));
532: g_snonlife_max := to_char(to_number(g_snonlife_max),fnd_currency.get_format_mask('JPY',40));
533: --
534: -- + nonlife dct
535: --

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

528: g_lnonlife_year := to_char(c_nonlife_long_year);
529: g_lnonlife_max := l_lnonlife_calc3;
530: g_snonlife_max := l_snonlife_calc3;
531: g_lnonlife_max := to_char(to_number(g_lnonlife_max),fnd_currency.get_format_mask('JPY',40));
532: g_snonlife_max := to_char(to_number(g_snonlife_max),fnd_currency.get_format_mask('JPY',40));
533: --
534: -- + nonlife dct
535: --
536: -- value always should be fetched.

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

581: end if;
582: --
583: g_nonlife_max := l_nonlife_max;
584: g_nonlife_max_2007 := l_nonlife_max_2007;
585: g_nonlife_max := to_char(to_number(g_nonlife_max),fnd_currency.get_format_mask('JPY',40));
586: g_nonlife_max_2007 := to_char(to_number(g_nonlife_max_2007),fnd_currency.get_format_mask('JPY',40));
587: --
588: --
589: -- spouse prompt fetch

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

582: --
583: g_nonlife_max := l_nonlife_max;
584: g_nonlife_max_2007 := l_nonlife_max_2007;
585: g_nonlife_max := to_char(to_number(g_nonlife_max),fnd_currency.get_format_mask('JPY',40));
586: g_nonlife_max_2007 := to_char(to_number(g_nonlife_max_2007),fnd_currency.get_format_mask('JPY',40));
587: --
588: --
589: -- spouse prompt fetch
590: --

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

602: l_effective_date));
603: end if;
604: --
605: g_sp_emp_inc_max := c_emp_income_max/c_sp_calc_unit;
606: g_sp_emp_inc_max := to_char(to_number(g_sp_emp_inc_max),fnd_currency.get_format_mask('JPY',40));
607: --
608: l_effective_date := g_effective_date;
609: --
610: if c_inc_spouse_dct_max is null then

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

617: l_effective_date));
618: end if;
619: --
620: g_sp_spdct_max := c_inc_spouse_dct_max/c_sp_calc_unit;
621: g_sp_spdct_max := to_char(to_number(g_sp_spdct_max),fnd_currency.get_format_mask('JPY',40));
622: --
623: l_effective_date := g_effective_date;
624: --
625: if c_spouse_income_max is null then

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

631: l_effective_date));
632: end if;
633: --
634: g_sp_spinc_max := c_spouse_income_max/c_sp_calc_unit;
635: g_sp_spinc_max := to_char(to_number(g_sp_spinc_max),fnd_currency.get_format_mask('JPY',40));
636: --
637: --
638: -- spouse_calc prompt fetch
639: --

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

638: -- spouse_calc prompt fetch
639: --
640: g_sp_calc_exp1b := c_sp_earned_inc_exp;
641: g_sp_calc_exp1b_fmt := to_char(g_sp_calc_exp1b);
642: g_sp_calc_exp1b_fmt := to_char(to_number(g_sp_calc_exp1b_fmt),fnd_currency.get_format_mask('JPY',40));
643: g_sp_calc_cal1 := to_char(c_sp_calc_earned_inc_calc1);
644: --
645: if fnd_number.canonical_to_number(c_sp_calc_other_inc_calc_rate) = 0.5 then
646: l_sp_calc_other_inc_calc_rate := '1/2';

Line 716: 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_range9a := l_sp_calc_tbl(9).range_a;
713: g_sp_calc_dct_range9b := l_sp_calc_tbl(9).range_b;
714: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
715: --
716: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));

Line 717: 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_dct_range9b := l_sp_calc_tbl(9).range_b;
714: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
715: --
716: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));

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

714: g_sp_calc_dct9 := l_sp_calc_tbl(9).val;
715: --
716: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));

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

715: --
716: g_sp_calc_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));

Line 720: 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_dct_range1a := to_char(to_number(g_sp_calc_dct_range1a),fnd_currency.get_format_mask('JPY',40));
717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));

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

717: g_sp_calc_dct_range1b := to_char(to_number(g_sp_calc_dct_range1b),fnd_currency.get_format_mask('JPY',40));
718: g_sp_calc_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));

Line 722: 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_dct1 := to_char(to_number(g_sp_calc_dct1),fnd_currency.get_format_mask('JPY',40));
719: g_sp_calc_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));

Line 723: 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_dct_range2a := to_char(to_number(g_sp_calc_dct_range2a),fnd_currency.get_format_mask('JPY',40));
720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));

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

720: g_sp_calc_dct_range2b := to_char(to_number(g_sp_calc_dct_range2b),fnd_currency.get_format_mask('JPY',40));
721: g_sp_calc_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));

Line 725: 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_dct2 := to_char(to_number(g_sp_calc_dct2),fnd_currency.get_format_mask('JPY',40));
722: g_sp_calc_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));

Line 726: 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_dct_range3a := to_char(to_number(g_sp_calc_dct_range3a),fnd_currency.get_format_mask('JPY',40));
723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));

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

723: g_sp_calc_dct_range3b := to_char(to_number(g_sp_calc_dct_range3b),fnd_currency.get_format_mask('JPY',40));
724: g_sp_calc_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));

Line 728: 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_dct3 := to_char(to_number(g_sp_calc_dct3),fnd_currency.get_format_mask('JPY',40));
725: g_sp_calc_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));

Line 729: 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_dct_range4a := to_char(to_number(g_sp_calc_dct_range4a),fnd_currency.get_format_mask('JPY',40));
726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));

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

726: g_sp_calc_dct_range4b := to_char(to_number(g_sp_calc_dct_range4b),fnd_currency.get_format_mask('JPY',40));
727: g_sp_calc_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));

Line 731: 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_dct4 := to_char(to_number(g_sp_calc_dct4),fnd_currency.get_format_mask('JPY',40));
728: g_sp_calc_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));

Line 732: 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_dct_range5a := to_char(to_number(g_sp_calc_dct_range5a),fnd_currency.get_format_mask('JPY',40));
729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));

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

729: g_sp_calc_dct_range5b := to_char(to_number(g_sp_calc_dct_range5b),fnd_currency.get_format_mask('JPY',40));
730: g_sp_calc_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));

Line 734: 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_dct5 := to_char(to_number(g_sp_calc_dct5),fnd_currency.get_format_mask('JPY',40));
731: g_sp_calc_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));

Line 735: 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_dct_range6a := to_char(to_number(g_sp_calc_dct_range6a),fnd_currency.get_format_mask('JPY',40));
732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));

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

732: g_sp_calc_dct_range6b := to_char(to_number(g_sp_calc_dct_range6b),fnd_currency.get_format_mask('JPY',40));
733: g_sp_calc_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));

Line 737: 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_dct6 := to_char(to_number(g_sp_calc_dct6),fnd_currency.get_format_mask('JPY',40));
734: g_sp_calc_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));

Line 738: 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_dct_range7a := to_char(to_number(g_sp_calc_dct_range7a),fnd_currency.get_format_mask('JPY',40));
735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));

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

735: g_sp_calc_dct_range7b := to_char(to_number(g_sp_calc_dct_range7b),fnd_currency.get_format_mask('JPY',40));
736: g_sp_calc_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
743: --

Line 740: 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_dct7 := to_char(to_number(g_sp_calc_dct7),fnd_currency.get_format_mask('JPY',40));
737: g_sp_calc_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
743: --
744: end if;

Line 741: 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_dct_range8a := to_char(to_number(g_sp_calc_dct_range8a),fnd_currency.get_format_mask('JPY',40));
738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
743: --
744: end if;
745: --

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

738: g_sp_calc_dct_range8b := to_char(to_number(g_sp_calc_dct_range8b),fnd_currency.get_format_mask('JPY',40));
739: g_sp_calc_dct8 := to_char(to_number(g_sp_calc_dct8),fnd_currency.get_format_mask('JPY',40));
740: g_sp_calc_dct_range9a := to_char(to_number(g_sp_calc_dct_range9a),fnd_currency.get_format_mask('JPY',40));
741: g_sp_calc_dct_range9b := to_char(to_number(g_sp_calc_dct_range9b),fnd_currency.get_format_mask('JPY',40));
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
743: --
744: end if;
745: --
746: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');

Line 1211: g_new_life_range1b := to_char(to_number(g_new_life_range1b),fnd_currency.get_format_mask('JPY',40));

1207: --
1208: if csr_udt_row%rowcount = 1 then
1209: --
1210: g_new_life_range1b := l_csr_udt_row.row_high_range;
1211: g_new_life_range1b := to_char(to_number(g_new_life_range1b),fnd_currency.get_format_mask('JPY',40));
1212: --
1213: elsif csr_udt_row%rowcount = 2 then
1214: --
1215: g_new_life_range2a := l_csr_udt_row.row_low_range_or_name;

Line 1217: g_new_life_range2a := to_char(to_number(g_new_life_range2a),fnd_currency.get_format_mask('JPY',40));

1213: elsif csr_udt_row%rowcount = 2 then
1214: --
1215: g_new_life_range2a := l_csr_udt_row.row_low_range_or_name;
1216: g_new_life_range2b := l_csr_udt_row.row_high_range;
1217: g_new_life_range2a := to_char(to_number(g_new_life_range2a),fnd_currency.get_format_mask('JPY',40));
1218: g_new_life_range2b := to_char(to_number(g_new_life_range2b),fnd_currency.get_format_mask('JPY',40));
1219: --
1220: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1221: loop

Line 1218: g_new_life_range2b := to_char(to_number(g_new_life_range2b),fnd_currency.get_format_mask('JPY',40));

1214: --
1215: g_new_life_range2a := l_csr_udt_row.row_low_range_or_name;
1216: g_new_life_range2b := l_csr_udt_row.row_high_range;
1217: g_new_life_range2a := to_char(to_number(g_new_life_range2a),fnd_currency.get_format_mask('JPY',40));
1218: g_new_life_range2b := to_char(to_number(g_new_life_range2b),fnd_currency.get_format_mask('JPY',40));
1219: --
1220: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1221: loop
1222: --

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

1237: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1238: l_rate := '1/4';
1239: end if;
1240: --
1241: g_new_life_calc2a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1242: --
1243: elsif csr_udt_row%rowcount = 3 then
1244: --
1245: g_new_life_range3a := l_csr_udt_row.row_low_range_or_name;

Line 1247: g_new_life_range3a := to_char(to_number(g_new_life_range3a),fnd_currency.get_format_mask('JPY',40));

1243: elsif csr_udt_row%rowcount = 3 then
1244: --
1245: g_new_life_range3a := l_csr_udt_row.row_low_range_or_name;
1246: g_new_life_range3b := l_csr_udt_row.row_high_range;
1247: g_new_life_range3a := to_char(to_number(g_new_life_range3a),fnd_currency.get_format_mask('JPY',40));
1248: g_new_life_range3b := to_char(to_number(g_new_life_range3b),fnd_currency.get_format_mask('JPY',40));
1249: --
1250: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1251: loop

Line 1248: g_new_life_range3b := to_char(to_number(g_new_life_range3b),fnd_currency.get_format_mask('JPY',40));

1244: --
1245: g_new_life_range3a := l_csr_udt_row.row_low_range_or_name;
1246: g_new_life_range3b := l_csr_udt_row.row_high_range;
1247: g_new_life_range3a := to_char(to_number(g_new_life_range3a),fnd_currency.get_format_mask('JPY',40));
1248: g_new_life_range3b := to_char(to_number(g_new_life_range3b),fnd_currency.get_format_mask('JPY',40));
1249: --
1250: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1251: loop
1252: --

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

1267: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1268: l_rate := '1/4';
1269: end if;
1270: --
1271: g_new_life_calc3a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1272: --
1273: elsif csr_udt_row%rowcount = 4 then
1274: --
1275: g_new_life_range4a := l_csr_udt_row.row_low_range_or_name;

Line 1276: g_new_life_range4a := to_char(to_number(g_new_life_range4a),fnd_currency.get_format_mask('JPY',40));

1272: --
1273: elsif csr_udt_row%rowcount = 4 then
1274: --
1275: g_new_life_range4a := l_csr_udt_row.row_low_range_or_name;
1276: g_new_life_range4a := to_char(to_number(g_new_life_range4a),fnd_currency.get_format_mask('JPY',40));
1277: --
1278: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1279: loop
1280: --

Line 1291: g_new_life_calc4a := to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

1287: --
1288: end loop;
1289: close csr_udt_val;
1290: --
1291: g_new_life_calc4a := to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1292: --
1293: end if;
1294: --
1295: end loop;

Line 1342: g_old_life_range1b := to_char(to_number(g_old_life_range1b),fnd_currency.get_format_mask('JPY',40));

1338: --
1339: if csr_udt_row%rowcount = 1 then
1340: --
1341: g_old_life_range1b := l_csr_udt_row.row_high_range;
1342: g_old_life_range1b := to_char(to_number(g_old_life_range1b),fnd_currency.get_format_mask('JPY',40));
1343: --
1344: elsif csr_udt_row%rowcount = 2 then
1345: --
1346: g_old_life_range2a := l_csr_udt_row.row_low_range_or_name;

Line 1348: g_old_life_range2a := to_char(to_number(g_old_life_range2a),fnd_currency.get_format_mask('JPY',40));

1344: elsif csr_udt_row%rowcount = 2 then
1345: --
1346: g_old_life_range2a := l_csr_udt_row.row_low_range_or_name;
1347: g_old_life_range2b := l_csr_udt_row.row_high_range;
1348: g_old_life_range2a := to_char(to_number(g_old_life_range2a),fnd_currency.get_format_mask('JPY',40));
1349: g_old_life_range2b := to_char(to_number(g_old_life_range2b),fnd_currency.get_format_mask('JPY',40));
1350:
1351: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1352: loop

Line 1349: g_old_life_range2b := to_char(to_number(g_old_life_range2b),fnd_currency.get_format_mask('JPY',40));

1345: --
1346: g_old_life_range2a := l_csr_udt_row.row_low_range_or_name;
1347: g_old_life_range2b := l_csr_udt_row.row_high_range;
1348: g_old_life_range2a := to_char(to_number(g_old_life_range2a),fnd_currency.get_format_mask('JPY',40));
1349: g_old_life_range2b := to_char(to_number(g_old_life_range2b),fnd_currency.get_format_mask('JPY',40));
1350:
1351: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1352: loop
1353: --

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

1368: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1369: l_rate := '1/4';
1370: end if;
1371: --
1372: g_old_life_calc2a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1373: --
1374: elsif csr_udt_row%rowcount = 3 then
1375: --
1376: g_old_life_range3a := l_csr_udt_row.row_low_range_or_name;

Line 1378: g_old_life_range3a := to_char(to_number(g_old_life_range3a),fnd_currency.get_format_mask('JPY',40));

1374: elsif csr_udt_row%rowcount = 3 then
1375: --
1376: g_old_life_range3a := l_csr_udt_row.row_low_range_or_name;
1377: g_old_life_range3b := l_csr_udt_row.row_high_range;
1378: g_old_life_range3a := to_char(to_number(g_old_life_range3a),fnd_currency.get_format_mask('JPY',40));
1379: g_old_life_range3b := to_char(to_number(g_old_life_range3b),fnd_currency.get_format_mask('JPY',40));
1380:
1381: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1382: loop

Line 1379: g_old_life_range3b := to_char(to_number(g_old_life_range3b),fnd_currency.get_format_mask('JPY',40));

1375: --
1376: g_old_life_range3a := l_csr_udt_row.row_low_range_or_name;
1377: g_old_life_range3b := l_csr_udt_row.row_high_range;
1378: g_old_life_range3a := to_char(to_number(g_old_life_range3a),fnd_currency.get_format_mask('JPY',40));
1379: g_old_life_range3b := to_char(to_number(g_old_life_range3b),fnd_currency.get_format_mask('JPY',40));
1380:
1381: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1382: loop
1383: --

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

1398: elsif fnd_number.canonical_to_number(l_rate) = 0.25 then
1399: l_rate := '1/4';
1400: end if;
1401: --
1402: g_old_life_calc3a := 'x '||l_rate||' + '||to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1403: --
1404: elsif csr_udt_row%rowcount = 4 then
1405: --
1406: g_old_life_range4a := l_csr_udt_row.row_low_range_or_name;

Line 1407: g_old_life_range4a := to_char(to_number(g_old_life_range4a),fnd_currency.get_format_mask('JPY',40));

1403: --
1404: elsif csr_udt_row%rowcount = 4 then
1405: --
1406: g_old_life_range4a := l_csr_udt_row.row_low_range_or_name;
1407: g_old_life_range4a := to_char(to_number(g_old_life_range4a),fnd_currency.get_format_mask('JPY',40));
1408:
1409: open csr_udt_val(l_csr_udt_row.user_table_id,l_csr_udt_row.user_row_id,c_st_upd_date_2012);
1410: loop
1411: --

Line 1422: g_old_life_calc4a := to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));

1418: --
1419: end loop;
1420: close csr_udt_val;
1421: --
1422: g_old_life_calc4a := to_char(to_number(l_add_adj),fnd_currency.get_format_mask('JPY',40));
1423: --
1424: end if;
1425: --
1426: end loop;