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 1587: sv_total_earnings := nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

1583:
1584: end if;
1585:
1586: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_YTD' then
1587: sv_total_earnings := nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1588: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);
1589: end if;
1590:
1591: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_YTD' then

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

1588: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);
1589: end if;
1590:
1591: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_YTD' then
1592: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1593: end if;
1594:
1595: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD' then
1596: sv_ded_reported_16 := nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

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

1592: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1593: end if;
1594:
1595: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD' then
1596: sv_ded_reported_16 := nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1597: end if;
1598:
1599: if sv_dbi(i).dbi_name = 'CAEOY_QPP_BASIC_EXEMPTION_PER_JD_YTD' then
1600: sv_cpp_basic_exemption :=

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

1597: end if;
1598:
1599: if sv_dbi(i).dbi_name = 'CAEOY_QPP_BASIC_EXEMPTION_PER_JD_YTD' then
1600: sv_cpp_basic_exemption :=
1601: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1602: end if;
1603:
1604: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EXEMPT_PER_JD_YTD' then
1605: sv_cpp_exempt_bal :=

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

1602: end if;
1603:
1604: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EXEMPT_PER_JD_YTD' then
1605: sv_cpp_exempt_bal :=
1606: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1607: end if;
1608:
1609: /* Added by ssmukher for PPIP tax */
1610: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then

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

1607: end if;
1608:
1609: /* Added by ssmukher for PPIP tax */
1610: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then
1611: sv_ppip_insurable_earnings := nvl(sv_ppip_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1612: end if;
1613: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD' then
1614: sv_ded_reported_ppip :=nvl(sv_ded_reported_ppip,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1615: end if;

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

1610: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD' then
1611: sv_ppip_insurable_earnings := nvl(sv_ppip_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1612: end if;
1613: if sv_dbi(i).dbi_name = 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD' then
1614: sv_ded_reported_ppip :=nvl(sv_ded_reported_ppip,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1615: end if;
1616:
1617: sv_ppip_ded_required := ((sv_ppip_insurable_earnings * sv_ppip_rate )/ 100 );
1618:

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

1634: if sv_p_y = 'E' then
1635:
1636: if instr(sv_dbi(i).dbi_name, 'YTD') > 0 and
1637: instr(sv_dbi(i).dbi_name, 'CODE') = 0 and
1638: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0 then
1639:
1640: sv_nb := sv_nb + 1;
1641: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1642: sv_neg_bal(sv_nb).dbi_value :=

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

1639:
1640: sv_nb := sv_nb + 1;
1641: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1642: sv_neg_bal(sv_nb).dbi_value :=
1643: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1644: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1645: sv_print := 1;
1646:
1647: end if;

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

1646:
1647: end if;
1648:
1649: if (sv_dbi(i).dbi_name = 'CAEOY_RL1_NONBOX_FOOTNOTE') and
1650: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then
1651:
1652: sv_nb := sv_nb + 1;
1653: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1654: sv_neg_bal(sv_nb).dbi_value :=

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

1651:
1652: sv_nb := sv_nb + 1;
1653: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1654: sv_neg_bal(sv_nb).dbi_value :=
1655: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1656: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1657: sv_print := 1;
1658:
1659: end if;

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

1689: sv_qpp_ded_required := 0.00;
1690: end if;
1691: /* For Bug no. 13421306 - end*/
1692:
1693: /*sv_cpp_qpp_deficiency := to_char((fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
1694: - sv_cpp_ded_required ),'999,990.00'); */
1695:
1696: /*For Bug no. 13421306- Changed sv_cpp_ded_required to sv_qpp_ded_required*/
1697: --sv_cpp_qpp_deficiency := sv_cpp_ded_required - sv_ded_reported_16;

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

1727: sv_col.delete;
1728: sv_neg_bal.delete;
1729: end if;
1730:
1731: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1732: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1733: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1734: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1735:

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

1728: sv_neg_bal.delete;
1729: end if;
1730:
1731: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1732: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1733: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1734: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1735:
1736: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then

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

1729: end if;
1730:
1731: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1732: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1733: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1734: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1735:
1736: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then
1737:

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

1730:
1731: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') > 0 and
1732: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
1733: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') > 0 and
1734: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then */
1735:
1736: if (sv_cpp_qpp_deficiency > 1) or (sv_ppip_deficiency > 1) then
1737:
1738: sv_print := 1;

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

1913: if sv_p_y = 'E' then
1914: /* Checking for Negative Balance values for RL2 */
1915: if lr_rl2_emprec.NEGATIVE_BALANCE_FLAG = 'Y' then
1916:
1917: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_A,'0')) < 0 then
1918:
1919: sv_nb := sv_nb + 1;
1920: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1921: sv_neg_bal(sv_nb).dbi_value :=

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

1919: sv_nb := sv_nb + 1;
1920: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1921: sv_neg_bal(sv_nb).dbi_value :=
1922: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1923: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_A));
1924:
1925: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1926: sv_print := 1;
1927: end if;

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

1925: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1926: sv_print := 1;
1927: end if;
1928:
1929: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_B,'0')) < 0 then
1930:
1931: sv_nb := sv_nb + 1;
1932: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1933: sv_neg_bal(sv_nb).dbi_value :=

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

1931: sv_nb := sv_nb + 1;
1932: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1933: sv_neg_bal(sv_nb).dbi_value :=
1934: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1935: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_B));
1936:
1937: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1938: sv_print := 1;
1939: end if;

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

1937: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1938: sv_print := 1;
1939: end if;
1940:
1941: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_C,'0')) < 0 then
1942:
1943: sv_nb := sv_nb + 1;
1944: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1945: sv_neg_bal(sv_nb).dbi_value :=

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

1943: sv_nb := sv_nb + 1;
1944: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1945: sv_neg_bal(sv_nb).dbi_value :=
1946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1947: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_C));
1948:
1949: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1950: sv_print := 1;
1951: end if;

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

1949: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1950: sv_print := 1;
1951: end if;
1952:
1953: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_D,'0')) < 0 then
1954:
1955: sv_nb := sv_nb + 1;
1956: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1957: sv_neg_bal(sv_nb).dbi_value :=

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

1955: sv_nb := sv_nb + 1;
1956: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1957: sv_neg_bal(sv_nb).dbi_value :=
1958: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1959: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_D));
1960:
1961: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1962: sv_print := 1;
1963: end if;

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

1961: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1962: sv_print := 1;
1963: end if;
1964:
1965: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_E,'0')) < 0 then
1966:
1967: sv_nb := sv_nb + 1;
1968: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1969: sv_neg_bal(sv_nb).dbi_value :=

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

1967: sv_nb := sv_nb + 1;
1968: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1969: sv_neg_bal(sv_nb).dbi_value :=
1970: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1971: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_E));
1972:
1973: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1974: sv_print := 1;
1975: end if;

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

1973: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1974: sv_print := 1;
1975: end if;
1976:
1977: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_F,'0')) < 0 then
1978:
1979: sv_nb := sv_nb + 1;
1980: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1981: sv_neg_bal(sv_nb).dbi_value :=

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

1979: sv_nb := sv_nb + 1;
1980: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1981: sv_neg_bal(sv_nb).dbi_value :=
1982: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1983: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_F));
1984:
1985: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1986: sv_print := 1;
1987: end if;

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

1985: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1986: sv_print := 1;
1987: end if;
1988:
1989: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_G,'0')) < 0 then
1990:
1991: sv_nb := sv_nb + 1;
1992: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1993: sv_neg_bal(sv_nb).dbi_value :=

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

1991: sv_nb := sv_nb + 1;
1992: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1993: sv_neg_bal(sv_nb).dbi_value :=
1994: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1995: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_G));
1996:
1997: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1998: sv_print := 1;
1999: end if;

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

1997: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1998: sv_print := 1;
1999: end if;
2000:
2001: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_H,'0')) < 0 then
2002:
2003: sv_nb := sv_nb + 1;
2004: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
2005: sv_neg_bal(sv_nb).dbi_value :=

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

2003: sv_nb := sv_nb + 1;
2004: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
2005: sv_neg_bal(sv_nb).dbi_value :=
2006: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2007: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_H));
2008:
2009: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
2010: sv_print := 1;
2011: end if;

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

2009: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
2010: sv_print := 1;
2011: end if;
2012:
2013: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_I,'0')) < 0 then
2014:
2015: sv_nb := sv_nb + 1;
2016: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
2017: sv_neg_bal(sv_nb).dbi_value :=

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

2015: sv_nb := sv_nb + 1;
2016: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
2017: sv_neg_bal(sv_nb).dbi_value :=
2018: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2019: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_I));
2020:
2021: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
2022: sv_print := 1;
2023: end if;

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

2021: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
2022: sv_print := 1;
2023: end if;
2024:
2025: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_J,'0')) < 0 then
2026:
2027: sv_nb := sv_nb + 1;
2028: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
2029: sv_neg_bal(sv_nb).dbi_value :=

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

2027: sv_nb := sv_nb + 1;
2028: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
2029: sv_neg_bal(sv_nb).dbi_value :=
2030: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2031: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_J));
2032:
2033: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
2034: sv_print := 1;
2035: end if;

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

2033: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
2034: sv_print := 1;
2035: end if;
2036:
2037: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_K,'0')) < 0 then
2038:
2039: sv_nb := sv_nb + 1;
2040: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
2041: sv_neg_bal(sv_nb).dbi_value :=

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

2039: sv_nb := sv_nb + 1;
2040: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
2041: sv_neg_bal(sv_nb).dbi_value :=
2042: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2043: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_K));
2044:
2045: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
2046: sv_print := 1;
2047: end if;

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

2045: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
2046: sv_print := 1;
2047: end if;
2048:
2049: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_L,'0')) < 0 then
2050:
2051: sv_nb := sv_nb + 1;
2052: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
2053: sv_neg_bal(sv_nb).dbi_value :=

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

2051: sv_nb := sv_nb + 1;
2052: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
2053: sv_neg_bal(sv_nb).dbi_value :=
2054: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2055: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_L));
2056:
2057: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
2058: sv_print := 1;
2059: end if;

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

2057: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
2058: sv_print := 1;
2059: end if;
2060:
2061: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_M,'0')) < 0 then
2062:
2063: sv_nb := sv_nb + 1;
2064: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
2065: sv_neg_bal(sv_nb).dbi_value :=

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

2063: sv_nb := sv_nb + 1;
2064: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
2065: sv_neg_bal(sv_nb).dbi_value :=
2066: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2067: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_M));
2068:
2069: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
2070: sv_print := 1;
2071: end if;

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

2069: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
2070: sv_print := 1;
2071: end if;
2072:
2073: if fnd_number.canonical_to_number(nvl(lr_rl2_emprec.RL2_BOX_O,'0')) < 0 then
2074:
2075: sv_nb := sv_nb + 1;
2076: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
2077: sv_neg_bal(sv_nb).dbi_value :=

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

2075: sv_nb := sv_nb + 1;
2076: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
2077: sv_neg_bal(sv_nb).dbi_value :=
2078: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2079: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_O));
2080:
2081: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box O';
2082: sv_print := 1;
2083: end if;

Line 2089: if (fnd_number.canonical_to_number(nvl(l_further_amount(l_i),'0')) < 0) then

2085: /* Bug 15908332 */
2086: for l_i in 1..further_info_count loop
2087: if l_further_amount(l_i) is not null then
2088: if(l_further_code(l_i) <> 'RL2_FURTHER_INFO_AMOUNT_201') then
2089: if (fnd_number.canonical_to_number(nvl(l_further_amount(l_i),'0')) < 0) then
2090: sv_nb := sv_nb + 1;
2091: sv_neg_bal(sv_nb).dbi_name := l_further_code(l_i);
2092: sv_neg_bal(sv_nb).dbi_value :=
2093: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

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

2645: sv_print := 1;
2646: end if;
2647: end if;
2648: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD' then
2649: sv_total_earnings :=nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2650: --lv_multi_jurisdiction := lv_multi_jurisdiction + 1;
2651: hr_utility.set_location('Multi Jurisdiction : '||
2652: to_char(lv_multi_jurisdiction), 999 );
2653: end if;

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

2651: hr_utility.set_location('Multi Jurisdiction : '||
2652: to_char(lv_multi_jurisdiction), 999 );
2653: end if;
2654: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2655: sv_pensionable_earnings :=nvl(sv_pensionable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2656: end if;
2657: /* Commented because bug# 1701287
2658: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2659: --sv_pensionable_earnings :=

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

2656: end if;
2657: /* Commented because bug# 1701287
2658: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2659: --sv_pensionable_earnings :=
2660: -- to_char(fnd_number.canonical_to_number(nvl(sv_pensionable_earnings,'0'),'999,999,990.00') +
2661: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2662: --end if;
2663: */
2664: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then

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

2657: /* Commented because bug# 1701287
2658: --if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2659: --sv_pensionable_earnings :=
2660: -- to_char(fnd_number.canonical_to_number(nvl(sv_pensionable_earnings,'0'),'999,999,990.00') +
2661: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2662: --end if;
2663: */
2664: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2665: sv_ded_reported_16 :=nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

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

2661: --fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2662: --end if;
2663: */
2664: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2665: sv_ded_reported_16 :=nvl(sv_ded_reported_16,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2666: end if;
2667: /*
2668: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2669: sv_ded_reported_16 :=

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

2666: end if;
2667: /*
2668: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2669: sv_ded_reported_16 :=
2670: to_char(fnd_number.canonical_to_number(nvl(sv_ded_reported_16,'0'),'999,999,990.00') +
2671: fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2672: end if;
2673: */
2674:

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

2667: /*
2668: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD' then
2669: sv_ded_reported_16 :=
2670: to_char(fnd_number.canonical_to_number(nvl(sv_ded_reported_16,'0'),'999,999,990.00') +
2671: fnd_number.canonical_to_number(sv_dbi(i).dbi_value),'999,999,990.00');
2672: end if;
2673: */
2674:
2675: /* bug 5552744 */

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

2686:
2687: if sv_emp_jurisdiction = 'QC' then
2688:
2689: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2690: sv_qc_insurable_earnings := nvl(sv_qc_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2691: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);
2692: end if;
2693:
2694: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then

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

2691: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);
2692: end if;
2693:
2694: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2695: sv_qc_ded_reported_18 := nvl(sv_qc_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2696: hr_utility.trace('QC Withheld : '|| sv_qc_ded_reported_18);
2697: end if;
2698:
2699: else

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

2698:
2699: else
2700:
2701: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2702: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2703: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);
2704: end if;
2705:
2706: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then

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

2703: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);
2704: end if;
2705:
2706: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2707: sv_ded_reported_18 := nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2708: hr_utility.trace('FED Withheld : '|| sv_ded_reported_18);
2709: end if;
2710:
2711: end if; /* 'QC' */

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

2715:
2716: /* bug 5552744 */
2717: /*
2718: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2719: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2720: end if;
2721: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2722: sv_ded_reported_18 :=nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2723: end if;

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

2718: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2719: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2720: end if;
2721: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2722: sv_ded_reported_18 :=nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2723: end if;
2724: */
2725:
2726: if sv_dbi(i).dbi_name = 'CAEOY_CPP_BASIC_EXEMPTION_PER_JD_GRE_YTD' then

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

2724: */
2725:
2726: if sv_dbi(i).dbi_name = 'CAEOY_CPP_BASIC_EXEMPTION_PER_JD_GRE_YTD' then
2727: sv_cpp_basic_exemption :=
2728: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2729: end if;
2730: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EXEMPT_PER_JD_GRE_YTD' then
2731: sv_cpp_exempt_bal :=
2732: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

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

2728: nvl(sv_cpp_basic_exemption,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2729: end if;
2730: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EXEMPT_PER_JD_GRE_YTD' then
2731: sv_cpp_exempt_bal :=
2732: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2733: end if;
2734: if sv_p_y = 'E' then
2735: if instr(sv_dbi(i).dbi_name, 'GRE_YTD') > 0 and
2736: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0

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

2732: nvl(sv_cpp_exempt_bal,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2733: end if;
2734: if sv_p_y = 'E' then
2735: if instr(sv_dbi(i).dbi_name, 'GRE_YTD') > 0 and
2736: fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0
2737: then
2738: if ((sv_report_type = 'T4') or
2739: (sv_report_type = 'CAEOY_T4_AMEND_PP')) then
2740: begin

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

2757: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2758: end if;
2759: sv_neg_bal(sv_nb).dbi_value :=
2760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2761: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2762: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2763: sv_print := 1;
2764: end if;
2765:

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

2763: sv_print := 1;
2764: end if;
2765:
2766: if (sv_dbi(i).dbi_name = 'CAEOY_T4A_NONBOX_FOOTNOTE') and
2767: (fnd_number.canonical_to_number(nvl(sv_dbi(i).dbi_value,'0')) < 0) then
2768:
2769: sv_nb := sv_nb + 1;
2770: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2771: sv_neg_bal(sv_nb).dbi_value :=

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

2769: sv_nb := sv_nb + 1;
2770: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2771: sv_neg_bal(sv_nb).dbi_value :=
2772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2773: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2774: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2775: sv_print := 1;
2776:
2777: end if;

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

2882: end if;
2883: */
2884:
2885: /* sv_cpp_qpp_deficiency :=
2886: to_char( (fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
2887: - sv_cpp_ded_required ),'999,990.00');
2888:
2889: sv_ei_deficiency :=
2890: to_char( (fnd_number.canonical_to_number(sv_ded_reported_18,'999,999,990.00')

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

2886: to_char( (fnd_number.canonical_to_number(sv_ded_reported_16,'999,999,990.00')
2887: - sv_cpp_ded_required ),'999,990.00');
2888:
2889: sv_ei_deficiency :=
2890: to_char( (fnd_number.canonical_to_number(sv_ded_reported_18,'999,999,990.00')
2891: - sv_ei_ded_required ),'999,990.00');
2892: */
2893:
2894: sv_cpp_qpp_deficiency := (sv_cpp_ded_required - sv_ded_reported_16);

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

2926: sv_col.delete;
2927: sv_neg_bal.delete;
2928: end if;
2929:
2930: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2931: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2932: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2933: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2934: */

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

2927: sv_neg_bal.delete;
2928: end if;
2929:
2930: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2931: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2932: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2933: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2934: */
2935:

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

2928: end if;
2929:
2930: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2931: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2932: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2933: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2934: */
2935:
2936: if ( (sv_cpp_qpp_deficiency > 1) or (sv_ei_deficiency > 1) or (sv_qc_ei_deficiency > 1)) then

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

2929:
2930: /* if ( ( fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00') < 0 and
2931: abs(fnd_number.canonical_to_number( sv_cpp_qpp_deficiency, '999,990.00')) > 1 ) or
2932: ( fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00') < 0 and
2933: abs(fnd_number.canonical_to_number( sv_ei_deficiency, '999,990.00')) > 1 ) ) then
2934: */
2935:
2936: if ( (sv_cpp_qpp_deficiency > 1) or (sv_ei_deficiency > 1) or (sv_qc_ei_deficiency > 1)) then
2937: