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

Line 106: fnd_number.number_to_canonical function instead of to_number

102: for year end magnetic media
103: 22-DEC-2005 ssouresr 115.38 The exception report will now also detect negative
104: T4A and RL1 non box footnotes.
105: 31-JUL-2006 ydevi 115.39 all monetary values are converted into number by using
106: fnd_number.number_to_canonical function instead of to_number
107: function
108: The masking of the monetory values has been done using
109: pay_us_employee_payslip_web.get_format_value instead of
110: to_char.

Line 1377: sv_total_earnings := nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1373:
1374: end if;
1375:
1376: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_YTD' then
1377: sv_total_earnings := nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1378: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);
1379: end if;
1380:
1381: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_YTD' then

Line 1382: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1378: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);
1379: end if;
1380:
1381: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_YTD' then
1382: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1383: end if;
1384:
1385: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD' then
1386: sv_ded_reported_16 := nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 1386: sv_ded_reported_16 := nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1382: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1383: end if;
1384:
1385: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD' then
1386: sv_ded_reported_16 := nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1387: end if;
1388:
1389: if sv_dbi(i).dbi_name = 'CAEOY_QPP_BASIC_EXEMPTION_PER_JD_YTD' then
1390: sv_cpp_basic_exemption :=

Line 1391: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1387: end if;
1388:
1389: if sv_dbi(i).dbi_name = 'CAEOY_QPP_BASIC_EXEMPTION_PER_JD_YTD' then
1390: sv_cpp_basic_exemption :=
1391: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1392: end if;
1393:
1394: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EXEMPT_PER_JD_YTD' then
1395: sv_cpp_exempt_bal :=

Line 1396: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1392: end if;
1393:
1394: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EXEMPT_PER_JD_YTD' then
1395: sv_cpp_exempt_bal :=
1396: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1397: end if;
1398:
1399: /* Added by ssmukher for PPIP tax */
1400: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then

Line 1401: sv_ppip_insurable_earnings := nvl(sv_ppip_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1397: end if;
1398:
1399: /* Added by ssmukher for PPIP tax */
1400: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then
1401: sv_ppip_insurable_earnings := nvl(sv_ppip_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1402: end if;
1403: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD' then
1404: sv_ded_reported_ppip :=nvl(sv_ded_reported_ppip,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1405: end if;

Line 1404: sv_ded_reported_ppip :=nvl(sv_ded_reported_ppip,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1400: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then
1401: sv_ppip_insurable_earnings := nvl(sv_ppip_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1402: end if;
1403: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD' then
1404: sv_ded_reported_ppip :=nvl(sv_ded_reported_ppip,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1405: end if;
1406:
1407: sv_ppip_ded_required := ((sv_ppip_insurable_earnings * sv_ppip_rate )/ 100 );
1408:

Line 1428: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0 then

1424: if sv_p_y = 'E' then
1425:
1426: if instr(sv_dbi(i).dbi_name, 'YTD') > 0 and
1427: instr(sv_dbi(i).dbi_name, 'CODE') = 0 and
1428: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0 then
1429:
1430: sv_nb := sv_nb + 1;
1431: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1432: sv_neg_bal(sv_nb).dbi_value :=

Line 1433: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

1429:
1430: sv_nb := sv_nb + 1;
1431: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1432: sv_neg_bal(sv_nb).dbi_value :=
1433: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1434: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1435: sv_print := 1;
1436:
1437: end if;

Line 1440: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then

1436:
1437: end if;
1438:
1439: if (sv_dbi(i).dbi_name = 'CAEOY_RL1_NONBOX_FOOTNOTE') and
1440: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then
1441:
1442: sv_nb := sv_nb + 1;
1443: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1444: sv_neg_bal(sv_nb).dbi_value :=

Line 1445: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

1441:
1442: sv_nb := sv_nb + 1;
1443: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1444: sv_neg_bal(sv_nb).dbi_value :=
1445: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1446: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1447: sv_print := 1;
1448:
1449: end if;

Line 1468: /*sv_cpp_qpp_deficiency := to_char((fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')

1464: if sv_cpp_ded_required < 0 then
1465: sv_cpp_ded_required := 0.00;
1466: end if;
1467:
1468: /*sv_cpp_qpp_deficiency := to_char((fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
1469: - sv_cpp_ded_required ),'999,990.00'); */
1470:
1471: sv_cpp_qpp_deficiency := sv_cpp_ded_required - sv_ded_reported_16;
1472:

Line 1502: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and

1498: sv_col.delete;
1499: sv_neg_bal.delete;
1500: end if;
1501:
1502: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1503: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1504: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1505: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1506:

Line 1503: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or

1499: sv_neg_bal.delete;
1500: end if;
1501:
1502: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1503: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1504: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1505: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1506:
1507: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then

Line 1504: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and

1500: end if;
1501:
1502: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1503: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1504: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1505: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1506:
1507: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then
1508:

Line 1505: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */

1501:
1502: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1503: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1504: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1505: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1506:
1507: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then
1508:
1509: sv_print := 1;

Line 1659: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_A,'0')) < 0 then

1655: if sv_p_y = 'E' then
1656: /* Checking for Negative Balance values for RL2 */
1657: if lr_rl2_emprec.NEGATIVE_BALANCE_FLAG = 'Y' then
1658:
1659: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_A,'0')) < 0 then
1660:
1661: sv_nb := sv_nb + 1;
1662: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1663: sv_neg_bal(sv_nb).dbi_value :=

Line 1665: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_A));

1661: sv_nb := sv_nb + 1;
1662: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1663: sv_neg_bal(sv_nb).dbi_value :=
1664: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1665: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_A));
1666:
1667: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1668: sv_print := 1;
1669: end if;

Line 1671: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_B,'0')) < 0 then

1667: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1668: sv_print := 1;
1669: end if;
1670:
1671: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_B,'0')) < 0 then
1672:
1673: sv_nb := sv_nb + 1;
1674: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1675: sv_neg_bal(sv_nb).dbi_value :=

Line 1677: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_B));

1673: sv_nb := sv_nb + 1;
1674: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1675: sv_neg_bal(sv_nb).dbi_value :=
1676: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1677: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_B));
1678:
1679: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1680: sv_print := 1;
1681: end if;

Line 1683: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_C,'0')) < 0 then

1679: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1680: sv_print := 1;
1681: end if;
1682:
1683: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_C,'0')) < 0 then
1684:
1685: sv_nb := sv_nb + 1;
1686: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1687: sv_neg_bal(sv_nb).dbi_value :=

Line 1689: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_C));

1685: sv_nb := sv_nb + 1;
1686: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1687: sv_neg_bal(sv_nb).dbi_value :=
1688: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1689: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_C));
1690:
1691: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1692: sv_print := 1;
1693: end if;

Line 1695: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_D,'0')) < 0 then

1691: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1692: sv_print := 1;
1693: end if;
1694:
1695: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_D,'0')) < 0 then
1696:
1697: sv_nb := sv_nb + 1;
1698: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1699: sv_neg_bal(sv_nb).dbi_value :=

Line 1701: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_D));

1697: sv_nb := sv_nb + 1;
1698: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1699: sv_neg_bal(sv_nb).dbi_value :=
1700: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1701: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_D));
1702:
1703: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1704: sv_print := 1;
1705: end if;

Line 1707: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_E,'0')) < 0 then

1703: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1704: sv_print := 1;
1705: end if;
1706:
1707: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_E,'0')) < 0 then
1708:
1709: sv_nb := sv_nb + 1;
1710: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1711: sv_neg_bal(sv_nb).dbi_value :=

Line 1713: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_E));

1709: sv_nb := sv_nb + 1;
1710: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1711: sv_neg_bal(sv_nb).dbi_value :=
1712: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1713: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_E));
1714:
1715: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1716: sv_print := 1;
1717: end if;

Line 1719: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_F,'0')) < 0 then

1715: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1716: sv_print := 1;
1717: end if;
1718:
1719: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_F,'0')) < 0 then
1720:
1721: sv_nb := sv_nb + 1;
1722: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1723: sv_neg_bal(sv_nb).dbi_value :=

Line 1725: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_F));

1721: sv_nb := sv_nb + 1;
1722: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1723: sv_neg_bal(sv_nb).dbi_value :=
1724: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1725: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_F));
1726:
1727: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1728: sv_print := 1;
1729: end if;

Line 1731: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_G,'0')) < 0 then

1727: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1728: sv_print := 1;
1729: end if;
1730:
1731: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_G,'0')) < 0 then
1732:
1733: sv_nb := sv_nb + 1;
1734: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1735: sv_neg_bal(sv_nb).dbi_value :=

Line 1737: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_G));

1733: sv_nb := sv_nb + 1;
1734: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1735: sv_neg_bal(sv_nb).dbi_value :=
1736: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1737: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_G));
1738:
1739: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1740: sv_print := 1;
1741: end if;

Line 1743: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_H,'0')) < 0 then

1739: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1740: sv_print := 1;
1741: end if;
1742:
1743: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_H,'0')) < 0 then
1744:
1745: sv_nb := sv_nb + 1;
1746: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
1747: sv_neg_bal(sv_nb).dbi_value :=

Line 1749: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_H));

1745: sv_nb := sv_nb + 1;
1746: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
1747: sv_neg_bal(sv_nb).dbi_value :=
1748: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1749: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_H));
1750:
1751: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
1752: sv_print := 1;
1753: end if;

Line 1755: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_I,'0')) < 0 then

1751: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
1752: sv_print := 1;
1753: end if;
1754:
1755: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_I,'0')) < 0 then
1756:
1757: sv_nb := sv_nb + 1;
1758: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
1759: sv_neg_bal(sv_nb).dbi_value :=

Line 1761: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_I));

1757: sv_nb := sv_nb + 1;
1758: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
1759: sv_neg_bal(sv_nb).dbi_value :=
1760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1761: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_I));
1762:
1763: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
1764: sv_print := 1;
1765: end if;

Line 1767: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_J,'0')) < 0 then

1763: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
1764: sv_print := 1;
1765: end if;
1766:
1767: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_J,'0')) < 0 then
1768:
1769: sv_nb := sv_nb + 1;
1770: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
1771: sv_neg_bal(sv_nb).dbi_value :=

Line 1773: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_J));

1769: sv_nb := sv_nb + 1;
1770: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
1771: sv_neg_bal(sv_nb).dbi_value :=
1772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1773: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_J));
1774:
1775: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
1776: sv_print := 1;
1777: end if;

Line 1779: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_K,'0')) < 0 then

1775: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
1776: sv_print := 1;
1777: end if;
1778:
1779: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_K,'0')) < 0 then
1780:
1781: sv_nb := sv_nb + 1;
1782: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
1783: sv_neg_bal(sv_nb).dbi_value :=

Line 1785: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_K));

1781: sv_nb := sv_nb + 1;
1782: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
1783: sv_neg_bal(sv_nb).dbi_value :=
1784: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1785: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_K));
1786:
1787: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
1788: sv_print := 1;
1789: end if;

Line 1791: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_L,'0')) < 0 then

1787: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
1788: sv_print := 1;
1789: end if;
1790:
1791: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_L,'0')) < 0 then
1792:
1793: sv_nb := sv_nb + 1;
1794: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
1795: sv_neg_bal(sv_nb).dbi_value :=

Line 1797: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_L));

1793: sv_nb := sv_nb + 1;
1794: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
1795: sv_neg_bal(sv_nb).dbi_value :=
1796: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1797: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_L));
1798:
1799: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
1800: sv_print := 1;
1801: end if;

Line 1803: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_M,'0')) < 0 then

1799: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
1800: sv_print := 1;
1801: end if;
1802:
1803: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_M,'0')) < 0 then
1804:
1805: sv_nb := sv_nb + 1;
1806: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
1807: sv_neg_bal(sv_nb).dbi_value :=

Line 1809: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_M));

1805: sv_nb := sv_nb + 1;
1806: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
1807: sv_neg_bal(sv_nb).dbi_value :=
1808: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1809: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_M));
1810:
1811: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
1812: sv_print := 1;
1813: end if;

Line 1815: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_O,'0')) < 0 then

1811: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
1812: sv_print := 1;
1813: end if;
1814:
1815: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_O,'0')) < 0 then
1816:
1817: sv_nb := sv_nb + 1;
1818: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
1819: sv_neg_bal(sv_nb).dbi_value :=

Line 1821: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_O));

1817: sv_nb := sv_nb + 1;
1818: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
1819: sv_neg_bal(sv_nb).dbi_value :=
1820: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1821: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_O));
1822:
1823: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box O';
1824: sv_print := 1;
1825: end if;

Line 2324: sv_total_earnings :=nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2320: sv_print := 1;
2321: end if;
2322: end if;
2323: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD' then
2324: sv_total_earnings :=nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2325: --lv_multi_jurisdiction := lv_multi_jurisdiction + 1;
2326: hr_utility.set_location('Multi Jurisdiction : '||
2327: to_char(lv_multi_jurisdiction), 999 );
2328: end if;

Line 2330: sv_pensionable_earnings :=nvl(sv_pensionable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2326: hr_utility.set_location('Multi Jurisdiction : '||
2327: to_char(lv_multi_jurisdiction), 999 );
2328: end if;
2329: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2330: sv_pensionable_earnings :=nvl(sv_pensionable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2331: end if;
2332: /* Commented because bug# 1701287
2333: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2334: --sv_pensionable_earnings :=

Line 2335: -- to_char(fnd_number.canonical_to_number(nvl(sv_pensionable_earnings,'0'),'999,999,990.00') +

2331: end if;
2332: /* Commented because bug# 1701287
2333: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2334: --sv_pensionable_earnings :=
2335: -- to_char(fnd_number.canonical_to_number(nvl(sv_pensionable_earnings,'0'),'999,999,990.00') +
2336: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2337: --end if;
2338: */
2339: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then

Line 2336: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');

2332: /* Commented because bug# 1701287
2333: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2334: --sv_pensionable_earnings :=
2335: -- to_char(fnd_number.canonical_to_number(nvl(sv_pensionable_earnings,'0'),'999,999,990.00') +
2336: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2337: --end if;
2338: */
2339: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2340: sv_ded_reported_16 :=nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2340: sv_ded_reported_16 :=nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2336: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2337: --end if;
2338: */
2339: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2340: sv_ded_reported_16 :=nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2341: end if;
2342: /*
2343: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2344: sv_ded_reported_16 :=

Line 2345: to_char(fnd_number.canonical_to_number(nvl(sv_ded_reported_16,'0'),'999,999,990.00') +

2341: end if;
2342: /*
2343: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2344: sv_ded_reported_16 :=
2345: to_char(fnd_number.canonical_to_number(nvl(sv_ded_reported_16,'0'),'999,999,990.00') +
2346: fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2347: end if;
2348: */
2349:

Line 2346: fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');

2342: /*
2343: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2344: sv_ded_reported_16 :=
2345: to_char(fnd_number.canonical_to_number(nvl(sv_ded_reported_16,'0'),'999,999,990.00') +
2346: fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2347: end if;
2348: */
2349:
2350: /* bug 5552744 */

Line 2365: sv_qc_insurable_earnings := nvl(sv_qc_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2361:
2362: if sv_emp_jurisdiction = 'QC' then
2363:
2364: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2365: sv_qc_insurable_earnings := nvl(sv_qc_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2366: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);
2367: end if;
2368:
2369: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then

Line 2370: sv_qc_ded_reported_18 := nvl(sv_qc_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2366: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);
2367: end if;
2368:
2369: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2370: sv_qc_ded_reported_18 := nvl(sv_qc_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2371: hr_utility.trace('QC Withheld : '|| sv_qc_ded_reported_18);
2372: end if;
2373:
2374: else

Line 2377: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2373:
2374: else
2375:
2376: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2377: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2378: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);
2379: end if;
2380:
2381: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then

Line 2382: sv_ded_reported_18 := nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2378: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);
2379: end if;
2380:
2381: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2382: sv_ded_reported_18 := nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2383: hr_utility.trace('FED Withheld : '|| sv_ded_reported_18);
2384: end if;
2385:
2386: end if; /* 'QC' */

Line 2394: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2390:
2391: /* bug 5552744 */
2392: /*
2393: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2394: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2395: end if;
2396: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2397: sv_ded_reported_18 :=nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2398: end if;

Line 2397: sv_ded_reported_18 :=nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2393: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2394: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2395: end if;
2396: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2397: sv_ded_reported_18 :=nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2398: end if;
2399: */
2400:
2401: if sv_dbi(i).dbi_name = 'CAEOY_CPP_BASIC_EXEMPTION_PER_JD_GRE_YTD' then

Line 2403: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2399: */
2400:
2401: if sv_dbi(i).dbi_name = 'CAEOY_CPP_BASIC_EXEMPTION_PER_JD_GRE_YTD' then
2402: sv_cpp_basic_exemption :=
2403: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2404: end if;
2405: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EXEMPT_PER_JD_GRE_YTD' then
2406: sv_cpp_exempt_bal :=
2407: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2407: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

2403: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2404: end if;
2405: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EXEMPT_PER_JD_GRE_YTD' then
2406: sv_cpp_exempt_bal :=
2407: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2408: end if;
2409: if sv_p_y = 'E' then
2410: if instr(sv_dbi(i).dbi_name, 'GRE_YTD') > 0 and
2411: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0

Line 2411: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0

2407: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2408: end if;
2409: if sv_p_y = 'E' then
2410: if instr(sv_dbi(i).dbi_name, 'GRE_YTD') > 0 and
2411: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0
2412: then
2413: if ((sv_report_type = 'T4') or
2414: (sv_report_type = 'CAEOY_T4_AMEND_PP')) then
2415: begin

Line 2436: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

2432: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2433: end if;
2434: sv_neg_bal(sv_nb).dbi_value :=
2435: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2436: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2437: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2438: sv_print := 1;
2439: end if;
2440:

Line 2442: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then

2438: sv_print := 1;
2439: end if;
2440:
2441: if (sv_dbi(i).dbi_name = 'CAEOY_T4A_NONBOX_FOOTNOTE') and
2442: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then
2443:
2444: sv_nb := sv_nb + 1;
2445: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2446: sv_neg_bal(sv_nb).dbi_value :=

Line 2448: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

2444: sv_nb := sv_nb + 1;
2445: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2446: sv_neg_bal(sv_nb).dbi_value :=
2447: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2448: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2449: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2450: sv_print := 1;
2451:
2452: end if;

Line 2559: to_char( (fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')

2555: end if;
2556: */
2557:
2558: /* sv_cpp_qpp_deficiency :=
2559: to_char( (fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
2560: - sv_cpp_ded_required ),'999,990.00');
2561:
2562: sv_ei_deficiency :=
2563: to_char( (fnd_number.canonical_to_number(sv_ded_reported_18,'999,999,990.00')

Line 2563: to_char( (fnd_number.canonical_to_number(sv_ded_reported_18,'999,999,990.00')

2559: to_char( (fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
2560: - sv_cpp_ded_required ),'999,990.00');
2561:
2562: sv_ei_deficiency :=
2563: to_char( (fnd_number.canonical_to_number(sv_ded_reported_18,'999,999,990.00')
2564: - sv_ei_ded_required ),'999,990.00');
2565: */
2566:
2567: sv_cpp_qpp_deficiency := (sv_cpp_ded_required - sv_ded_reported_16);

Line 2603: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and

2599: sv_col.delete;
2600: sv_neg_bal.delete;
2601: end if;
2602:
2603: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2604: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2605: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2606: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2607: */

Line 2604: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or

2600: sv_neg_bal.delete;
2601: end if;
2602:
2603: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2604: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2605: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2606: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2607: */
2608:

Line 2605: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and

2601: end if;
2602:
2603: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2604: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2605: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2606: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2607: */
2608:
2609: if ( (sv_cpp_qpp_deficiency > 1) or (sv_ei_deficiency > 1) or (sv_qc_ei_deficiency > 1)) then

Line 2606: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then

2602:
2603: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2604: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2605: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2606: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2607: */
2608:
2609: if ( (sv_cpp_qpp_deficiency > 1) or (sv_ei_deficiency > 1) or (sv_qc_ei_deficiency > 1)) then
2610: