DBA Data[Home] [Help]

APPS.BEN_TCS_COMPENSATION dependencies on FND_NUMBER

Line 189: p_bnfts_table(i).value := fnd_number.number_to_canonical(bnfts_rec.val) ;

185: for bnfts_rec in bnfts_rows loop
186: i := i + 1;
187: p_bnfts_table(i).start_date := bnfts_rec.effective_start_date;
188: p_bnfts_table(i).end_date := bnfts_rec.effective_end_date;
189: p_bnfts_table(i).value := fnd_number.number_to_canonical(bnfts_rec.val) ;
190: p_bnfts_table(i).output_key := bnfts_rec.per_bnfts_bal_id;
191:
192: if p_comp_typ_cd = 'MNTRY' then
193: p_bnfts_table(i).currency_cd := nvl(p_currency_cd,bnfts_rec.uom);

Line 471: p_thrd_pty_table(i).value := fnd_number.number_to_canonical(thrd_pty_rec.amount);

467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
468: for thrd_pty_rec in thrd_pty_rows loop
469: p_thrd_pty_table(i).start_date := thrd_pty_rec.period_start_date;
470: p_thrd_pty_table(i).end_date := thrd_pty_rec.period_end_date;
471: p_thrd_pty_table(i).value := fnd_number.number_to_canonical(thrd_pty_rec.amount);
472:
473: if p_comp_typ_cd = 'MNTRY' then
474: --- vkodedal 6945274 - currency issue -3rd party payroll
475: ---p_thrd_pty_table(i).currency_cd := nvl(p_currency_cd,thrd_pty_rec.currency);

Line 560: p_cost_table(i).value := fnd_number.number_to_canonical(l_amt);

556: l_amt := -1 * cost_rec.costed_value;
557: else
558: l_amt := cost_rec.costed_value;
559: end if;
560: p_cost_table(i).value := fnd_number.number_to_canonical(l_amt);
561: if p_comp_typ_cd = 'MNTRY' then
562: p_cost_table(i).currency_cd := nvl(p_currency_cd,cost_rec.output_currency_code);
563: elsif p_comp_typ_cd = 'NNMNTRY' then
564: p_cost_table(i).uom := p_uom;

Line 625: p_result_table(i).value := fnd_number.number_to_canonical(run_rec.result_value);

621: for run_rec in run_results loop
622: i := i + 1;
623: p_result_table(i).start_date := run_rec.effective_date;
624: p_result_table(i).end_date := run_rec.effective_date;
625: p_result_table(i).value := fnd_number.number_to_canonical(run_rec.result_value);
626: if p_comp_typ_cd = 'MNTRY' then
627: p_result_table(i).currency_cd := nvl(p_currency_cd,run_rec.output_currency_code);
628: elsif p_comp_typ_cd = 'NNMNTRY' then
629: p_result_table(i).uom := p_uom;

Line 885: l_value := fnd_number.number_to_canonical(fnd_number.canonical_to_number(p_value)/l_asg_payroll.number_per_fiscal_year );

881: l_end_date := l_asg_payroll.effective_end_date;
882: end if;
883: if (p_salary_basis = 'Y' ) then
884:
885: l_value := fnd_number.number_to_canonical(fnd_number.canonical_to_number(p_value)/l_asg_payroll.number_per_fiscal_year );
886: else
887: l_value := p_value;
888: end if;
889: hr_utility.set_location('l_start_date '||l_start_date, 57);

Line 1001: l_value := l_pay_ann_factor * fnd_number.canonical_to_number(p_elm_table(ee_row).value);

997: IF l_rate_basis = 'HOURLY' THEN
998: --Bug 7537970 - pass element entry start date not period start date to get fte factor
999: l_pay_ann_factor := l_pay_ann_factor *PER_SALADMIN_UTILITY.get_fte_factor(p_assignment_id,l_esd);
1000: END If;
1001: l_value := l_pay_ann_factor * fnd_number.canonical_to_number(p_elm_table(ee_row).value);
1002: else
1003: l_value := p_elm_table(ee_row).value;
1004: l_salary_basis := 'N';
1005: end if ;

Line 1010: p_value => fnd_number.number_to_canonical(l_value),

1006: hr_utility.set_location('Annulization factor is null', 30);
1007: get_payroll_periods(p_assignment_id => p_assignment_id,
1008: p_perd_st_dt => l_esd,
1009: p_perd_en_dt => l_eed,
1010: p_value => fnd_number.number_to_canonical(l_value),
1011: p_output_key => p_elm_table(ee_row).output_key,
1012: p_currency_cd => p_currency_cd,
1013: p_uom => p_uom,
1014: p_creator_type => p_elm_table(ee_row).creator_type,