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_GB_EOY_ARCHIVE dependencies on FND_NUMBER

Line 428: -- Cover on the fnd_number function, but with exception handling

424: END canonical_to_date;
425: --
426: FUNCTION canonical_to_number(p_charnum IN VARCHAR2)
427: RETURN NUMBER
428: -- Cover on the fnd_number function, but with exception handling
429: IS
430: l_return_num NUMBER;
431: BEGIN
432: l_return_num := fnd_number.canonical_to_number(p_charnum);

Line 432: l_return_num := fnd_number.canonical_to_number(p_charnum);

428: -- Cover on the fnd_number function, but with exception handling
429: IS
430: l_return_num NUMBER;
431: BEGIN
432: l_return_num := fnd_number.canonical_to_number(p_charnum);
433: RETURN l_return_num;
434: EXCEPTION
435: WHEN OTHERS THEN
436: RETURN NULL;

Line 3536: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3532: max(ev_scon.element_entry_id), cp_l_asg_id,
3533: 'S',max(pact.effective_date))),
3534: NULL)),1,9) scon,
3535: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
3536: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3537: able,
3538: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3539: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3540: total,

Line 3539: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3535: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
3536: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3537: able,
3538: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3539: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3540: total,
3541: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
3542: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3543: employee,

Line 3542: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3538: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3539: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3540: total,
3541: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
3542: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3543: employee,
3544: --
3545: -- Bug Fix 678573 Start
3546: --

Line 3548: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3544: --
3545: -- Bug Fix 678573 Start
3546: --
3547: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employer',
3548: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3549: employer,
3550: --
3551: -- Bug Fix 678573 End
3552: --

Line 3554: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3550: --
3551: -- Bug Fix 678573 End
3552: --
3553: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able ET',
3554: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3555: able_et,
3556: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3557: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3558: able_lel,

Line 3557: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3553: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able ET',
3554: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3555: able_et,
3556: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3557: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3558: able_lel,
3559: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UEL',
3560: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3561: able_uel,

Line 3560: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3556: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3557: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3558: able_lel,
3559: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UEL',
3560: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3561: able_uel,
3562: -- 8357870 begin
3563: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UAP',
3564: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

Line 3564: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3560: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3561: able_uel,
3562: -- 8357870 begin
3563: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UAP',
3564: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3565: able_uap,
3566: -- 8357870 end
3567: --EOY 07/08 Begin
3568: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able AUEL',

Line 3569: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3565: able_uap,
3566: -- 8357870 end
3567: --EOY 07/08 Begin
3568: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able AUEL',
3569: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3570: able_auel,
3571: -- EOY 07/08 End
3572: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ers Rebate',
3573: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

Line 3573: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3569: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3570: able_auel,
3571: -- EOY 07/08 End
3572: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ers Rebate',
3573: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3574: ers_rebate,
3575: -- Note Ees Rebate only for F category, but zero
3576: -- retrieved in all other cases.
3577: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',

Line 3578: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3574: ers_rebate,
3575: -- Note Ees Rebate only for F category, but zero
3576: -- retrieved in all other cases.
3577: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',
3578: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3579: ees_rebate,
3580: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3581: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3582: rebate_emp

Line 3581: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

3577: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',
3578: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3579: ees_rebate,
3580: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3581: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3582: rebate_emp
3583: FROM pay_balance_feeds_f feed
3584: ,pay_balance_types bal
3585: ,pay_run_result_values target

Line 3815: fnd_number.canonical_to_number(screen_entry_value),NULL))

3811: p_update_recurring VARCHAR2) IS
3812: SELECT max(decode(iv.name,'Tax Code',screen_entry_value,NULL)) tax_code,
3813: max(decode(iv.name,'Tax Basis',screen_entry_value,NULL)) tax_basis,
3814: 100 * max(decode(iv.name,'Pay Previous',
3815: fnd_number.canonical_to_number(screen_entry_value),NULL))
3816: pay_previous,
3817: 100 * max(decode(iv.name,'Tax Previous',
3818: fnd_number.canonical_to_number(screen_entry_value),NULL))
3819: tax_previous

Line 3818: fnd_number.canonical_to_number(screen_entry_value),NULL))

3814: 100 * max(decode(iv.name,'Pay Previous',
3815: fnd_number.canonical_to_number(screen_entry_value),NULL))
3816: pay_previous,
3817: 100 * max(decode(iv.name,'Tax Previous',
3818: fnd_number.canonical_to_number(screen_entry_value),NULL))
3819: tax_previous
3820: FROM pay_element_entries_f e,
3821: pay_element_entry_values_f v,
3822: pay_input_values_f iv,

Line 3843: fnd_number.canonical_to_number(result_value),NULL)))

3839: cursor csr_tax_details_result(p_tax_run_result_id NUMBER) IS
3840: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3841: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
3842: 100 * to_number(max(decode(name,'Pay Previous',
3843: fnd_number.canonical_to_number(result_value),NULL)))
3844: pay_previous,
3845: 100 * to_number(max(decode(name,'Tax Previous',
3846: fnd_number.canonical_to_number(result_value),NULL)))
3847: tax_previous

Line 3846: fnd_number.canonical_to_number(result_value),NULL)))

3842: 100 * to_number(max(decode(name,'Pay Previous',
3843: fnd_number.canonical_to_number(result_value),NULL)))
3844: pay_previous,
3845: 100 * to_number(max(decode(name,'Tax Previous',
3846: fnd_number.canonical_to_number(result_value),NULL)))
3847: tax_previous
3848: FROM pay_input_values_f v,
3849: pay_run_result_values rrv
3850: WHERE rrv.run_result_id = p_tax_run_result_id

Line 3858: fnd_number.canonical_to_number(result_value),NULL)))

3854: cursor csr_tax_paye_result(p_tax_run_result_id NUMBER) IS
3855: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3856: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
3857: 100 * to_number(max(decode(name,'Pay Previous',
3858: fnd_number.canonical_to_number(result_value),NULL)))
3859: pay_previous,
3860: 100 * to_number(max(decode(name,'Tax Previous',
3861: fnd_number.canonical_to_number(result_value),NULL)))
3862: tax_previous

Line 3861: fnd_number.canonical_to_number(result_value),NULL)))

3857: 100 * to_number(max(decode(name,'Pay Previous',
3858: fnd_number.canonical_to_number(result_value),NULL)))
3859: pay_previous,
3860: 100 * to_number(max(decode(name,'Tax Previous',
3861: fnd_number.canonical_to_number(result_value),NULL)))
3862: tax_previous
3863: FROM pay_input_values_f v,
3864: pay_run_result_values rrv
3865: WHERE rrv.run_result_id = p_tax_run_result_id