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.
111: 01-Aug-2006 ssmukher 115.40 Implementation of PPIP tax in the package.Also the
112: use of diff EI rates (For Quebec and Non Quebec Employees).
113: Modified the following procedures
707: lv_format := '
717: if sv_f_p = 'F' then
718: lv_format := lv_format ||
719: '
724: else
725: lv_format := lv_format ||
726: '
732: if ( sv_f_p = 'F' ) then
733: lv_format := lv_format || '
737: else
738: lv_format := lv_format || '
749: if sv_f_p = 'F' then
750: lv_format := lv_format || '
752: '
757: else
758: lv_format := lv_format || '
760: '
773: if sv_f_p = 'F' then
774: lv_format := lv_format || '
776: '
781: else
782: lv_format := lv_format || '
784: '
797: ' '||''||
798: '
801: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
802: '
811: sv_rl1_slip_no ||''||
812: '
815: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||'
825: if sv_f_p = 'F' then
826: lv_format := '
829: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
830: '
835: /* QC Insurable Earning */
836: '
848: ' '||''||
849: '
861: ' '||''||
862: '
874: ' '||''||
875: '
880: else
881: lv_format := '
884: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
885: '
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;
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
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 :=
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;
2431: else
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;
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 :=
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: