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 404: -- Cover on the fnd_number function, but with exception handling

400: END canonical_to_date;
401: --
402: FUNCTION canonical_to_number(p_charnum IN VARCHAR2)
403: RETURN NUMBER
404: -- Cover on the fnd_number function, but with exception handling
405: IS
406: l_return_num NUMBER;
407: BEGIN
408: l_return_num := fnd_number.canonical_to_number(p_charnum);

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

404: -- Cover on the fnd_number function, but with exception handling
405: IS
406: l_return_num NUMBER;
407: BEGIN
408: l_return_num := fnd_number.canonical_to_number(p_charnum);
409: RETURN l_return_num;
410: EXCEPTION
411: WHEN OTHERS THEN
412: RETURN NULL;

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

3402: max(ev_scon.element_entry_id), cp_l_asg_id,
3403: 'S',max(pact.effective_date))),
3404: NULL)),1,9) scon,
3405: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
3406: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3407: able,
3408: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3409: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3410: total,

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

3405: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
3406: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3407: able,
3408: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3409: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3410: total,
3411: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
3412: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3413: employee,

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

3408: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
3409: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3410: total,
3411: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
3412: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3413: employee,
3414: --
3415: -- Bug Fix 678573 Start
3416: --

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

3414: --
3415: -- Bug Fix 678573 Start
3416: --
3417: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employer',
3418: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3419: employer,
3420: --
3421: -- Bug Fix 678573 End
3422: --

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

3420: --
3421: -- Bug Fix 678573 End
3422: --
3423: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able ET',
3424: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3425: able_et,
3426: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3427: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3428: able_lel,

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

3423: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able ET',
3424: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3425: able_et,
3426: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3427: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3428: able_lel,
3429: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UEL',
3430: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3431: able_uel,

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

3426: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able LEL',
3427: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3428: able_lel,
3429: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able UEL',
3430: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3431: able_uel,
3432: --EOY 07/08 Begin
3433: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able AUEL',
3434: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

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

3430: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3431: able_uel,
3432: --EOY 07/08 Begin
3433: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able AUEL',
3434: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3435: able_auel,
3436: -- EOY 07/08 End
3437: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ers Rebate',
3438: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)

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

3434: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3435: able_auel,
3436: -- EOY 07/08 End
3437: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ers Rebate',
3438: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3439: ers_rebate,
3440: -- Note Ees Rebate only for F category, but zero
3441: -- retrieved in all other cases.
3442: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',

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

3439: ers_rebate,
3440: -- Note Ees Rebate only for F category, but zero
3441: -- retrieved in all other cases.
3442: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',
3443: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3444: ees_rebate,
3445: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3446: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3447: rebate_emp

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

3442: 100*nvl(sum(decode(substr(bal.balance_name,6),'Ees Rebate',
3443: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3444: ees_rebate,
3445: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3446: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3447: rebate_emp
3448: FROM pay_balance_feeds_f feed
3449: ,pay_balance_types bal
3450: ,pay_run_result_values target

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

3670: p_update_recurring VARCHAR2) IS
3671: SELECT max(decode(iv.name,'Tax Code',screen_entry_value,NULL)) tax_code,
3672: max(decode(iv.name,'Tax Basis',screen_entry_value,NULL)) tax_basis,
3673: 100 * max(decode(iv.name,'Pay Previous',
3674: fnd_number.canonical_to_number(screen_entry_value),NULL))
3675: pay_previous,
3676: 100 * max(decode(iv.name,'Tax Previous',
3677: fnd_number.canonical_to_number(screen_entry_value),NULL))
3678: tax_previous

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

3673: 100 * max(decode(iv.name,'Pay Previous',
3674: fnd_number.canonical_to_number(screen_entry_value),NULL))
3675: pay_previous,
3676: 100 * max(decode(iv.name,'Tax Previous',
3677: fnd_number.canonical_to_number(screen_entry_value),NULL))
3678: tax_previous
3679: FROM pay_element_entries_f e,
3680: pay_element_entry_values_f v,
3681: pay_input_values_f iv,

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

3698: cursor csr_tax_details_result(p_tax_run_result_id NUMBER) IS
3699: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3700: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
3701: 100 * to_number(max(decode(name,'Pay Previous',
3702: fnd_number.canonical_to_number(result_value),NULL)))
3703: pay_previous,
3704: 100 * to_number(max(decode(name,'Tax Previous',
3705: fnd_number.canonical_to_number(result_value),NULL)))
3706: tax_previous

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

3701: 100 * to_number(max(decode(name,'Pay Previous',
3702: fnd_number.canonical_to_number(result_value),NULL)))
3703: pay_previous,
3704: 100 * to_number(max(decode(name,'Tax Previous',
3705: fnd_number.canonical_to_number(result_value),NULL)))
3706: tax_previous
3707: FROM pay_input_values_f v,
3708: pay_run_result_values rrv
3709: WHERE rrv.run_result_id = p_tax_run_result_id

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

3713: cursor csr_tax_paye_result(p_tax_run_result_id NUMBER) IS
3714: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3715: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
3716: 100 * to_number(max(decode(name,'Pay Previous',
3717: fnd_number.canonical_to_number(result_value),NULL)))
3718: pay_previous,
3719: 100 * to_number(max(decode(name,'Tax Previous',
3720: fnd_number.canonical_to_number(result_value),NULL)))
3721: tax_previous

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

3716: 100 * to_number(max(decode(name,'Pay Previous',
3717: fnd_number.canonical_to_number(result_value),NULL)))
3718: pay_previous,
3719: 100 * to_number(max(decode(name,'Tax Previous',
3720: fnd_number.canonical_to_number(result_value),NULL)))
3721: tax_previous
3722: FROM pay_input_values_f v,
3723: pay_run_result_values rrv
3724: WHERE rrv.run_result_id = p_tax_run_result_id