DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on FND_NUMBER

Line 335: 23-May-2005 lakrish 115.146 4235088, do fnd_number.canonical_to_number() to the

331: to avoid value of cost1 being displayed for
332: cost2 when cost1 is 'SAREC'
333: 12-May-2005 ikasire 115.145 Moved the fnd_message binding into IF clause to avoid
334: misleading error message from SSBEN
335: 23-May-2005 lakrish 115.146 4235088, do fnd_number.canonical_to_number() to the
336: FF output before assigning to a number variable
337: 09-Jun-2005 nhunur 115.147 4383988, do fnd_number.canonical_to_number() to all
338: FF that return a number variable
339: 05-Sep-05 swjain 115.148 Bug No 4538786 Per Pay Period with frequency rules

Line 337: 09-Jun-2005 nhunur 115.147 4383988, do fnd_number.canonical_to_number() to all

333: 12-May-2005 ikasire 115.145 Moved the fnd_message binding into IF clause to avoid
334: misleading error message from SSBEN
335: 23-May-2005 lakrish 115.146 4235088, do fnd_number.canonical_to_number() to the
336: FF output before assigning to a number variable
337: 09-Jun-2005 nhunur 115.147 4383988, do fnd_number.canonical_to_number() to all
338: FF that return a number variable
339: 05-Sep-05 swjain 115.148 Bug No 4538786 Per Pay Period with frequency rules
340: changes in procedure main
341: 13-Sep-2005 rbingi 115.151 Bug-4604560 in procedure main, Added close for

Line 379: fnd_number.canonical_to_number function

375: 25-Sep-2009 velvanop 115.167 Bug 8943410(11i): System applies rounding to rate value prior to the application of VAPRO
376: factor. The fix is to apply rounding after the VAPRO has been applied
377: 20-Jan-2011 krupani 120.18.12010000.4 Bug 10428587: Cursor c_pgr was failing when NLS_NUMERIC_CHARACTERS
378: is set to ',.' from '.,'. Fixed the same using
379: fnd_number.canonical_to_number function
380: 31-Jan-2011 amnaraya 120.18.12010000.6 Bug 11065081: Calculate the communicated values for use in SS
381: 20-Apr-2011 sagnanas 120.18.12010000.7 Bug 12378553: Passed p_annual_target
382: 29-Oct-2012 stee 120.18.12010000.8 Bug 14751721: When calculating the rate value, check
383: if it is new mid-year election.

Line 1071: select fnd_number.canonical_to_number(value) /* Bug 10428587 */

1067: l_state c_state%rowtype;
1068: --
1069: Cursor c_pgr (c_pay_rate_grade_rule_id in number
1070: ,c_effective_date in date ) is
1071: select fnd_number.canonical_to_number(value) /* Bug 10428587 */
1072: from pay_grade_rules_f pgr
1073: where grade_rule_id = c_pay_rate_grade_rule_id
1074: and c_effective_date between
1075: pgr.effective_start_date and pgr.effective_end_date;

Line 2010: l_abr.mn_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

2006: if (l_outputs.count >= 4) then
2007: for l_count in l_outputs.first..l_outputs.last loop
2008: begin
2009: if l_outputs(l_count).name = 'L_MN_ELCN_VAL' then
2010: l_abr.mn_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2011: elsif l_outputs(l_count).name = 'L_MX_ELCN_VAL' then
2012: l_abr.mx_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2013: elsif l_outputs(l_count).name = 'L_INCRMT_VAL' then
2014: l_abr.incrmt_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

Line 2012: l_abr.mx_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

2008: begin
2009: if l_outputs(l_count).name = 'L_MN_ELCN_VAL' then
2010: l_abr.mn_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2011: elsif l_outputs(l_count).name = 'L_MX_ELCN_VAL' then
2012: l_abr.mx_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2013: elsif l_outputs(l_count).name = 'L_INCRMT_VAL' then
2014: l_abr.incrmt_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2015: elsif l_outputs(l_count).name = 'L_DFLT_VAL' then
2016: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

Line 2014: l_abr.incrmt_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

2010: l_abr.mn_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2011: elsif l_outputs(l_count).name = 'L_MX_ELCN_VAL' then
2012: l_abr.mx_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2013: elsif l_outputs(l_count).name = 'L_INCRMT_VAL' then
2014: l_abr.incrmt_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2015: elsif l_outputs(l_count).name = 'L_DFLT_VAL' then
2016: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2017: end if;
2018: exception

Line 2016: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);

2012: l_abr.mx_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2013: elsif l_outputs(l_count).name = 'L_INCRMT_VAL' then
2014: l_abr.incrmt_elcn_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2015: elsif l_outputs(l_count).name = 'L_DFLT_VAL' then
2016: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2017: end if;
2018: exception
2019: when others then
2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

Line 2819: l_val := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value); --bug4235088

2815: p_param1_value => fnd_date.date_to_canonical(l_fonm_rt_strt_dt),
2816: p_param2 => 'CVG_STRT_DT',
2817: p_param2_value => fnd_date.date_to_canonical(l_cvg_eff_dt)
2818: );
2819: l_val := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value); --bug4235088
2820: else
2821: l_val := 0;
2822: end if;
2823: