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_US_EMP_BALADJ_CLEANUP dependencies on PAY_US_EMP_BALADJ_CLEANUP

Line 1: PACKAGE BODY pay_us_emp_baladj_cleanup AS

1: PACKAGE BODY pay_us_emp_baladj_cleanup AS
2: /* $Header: payusbaladjclean.pkb 120.0 2005/05/29 11:52 appldev noship $ */
3: /*
4: ******************************************************************
5: * *

Line 1641: if pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.count > 0 then

1637: end if;
1638: hr_utility.trace('SIT_Exists = ' || lv_sit_exists);
1639:
1640: if lv_sit_exists = 'N' then
1641: if pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.count > 0 then
1642: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1643: lv_balance_name
1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;
1645: ln_ytd_def_bal_id

Line 1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;

1640: if lv_sit_exists = 'N' then
1641: if pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.count > 0 then
1642: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1643: lv_balance_name
1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;
1645: ln_ytd_def_bal_id
1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;
1647: lv_element_name
1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;

Line 1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;

1642: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1643: lv_balance_name
1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;
1645: ln_ytd_def_bal_id
1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;
1647: lv_element_name
1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;
1649: ln_element_type_id
1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;

Line 1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;

1644: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).balance_name;
1645: ln_ytd_def_bal_id
1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;
1647: lv_element_name
1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;
1649: ln_element_type_id
1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;
1651: lv_input_name
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;

Line 1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;

1646: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).ytd_def_bal_id;
1647: lv_element_name
1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;
1649: ln_element_type_id
1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;
1651: lv_input_name
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;

Line 1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;

1648: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_name;
1649: ln_element_type_id
1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;
1651: lv_input_name
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);

Line 1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;

1650: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).element_type_id;
1651: lv_input_name
1652: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_name;
1653: ln_input_value_id
1654: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(0).input_value_id;
1655: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1656: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1657: hr_utility.trace('lv_element_name=' || lv_element_name);
1658: hr_utility.trace('lv_input_name=' || lv_input_name);

Line 1667: for j in pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.first..

1663: p_defined_balance_id => ln_ytd_def_bal_id
1664: ,p_balcall_aaid => ln_bal_asg_action_id);
1665:
1666: IF ln_bal_value <> 0 THEN
1667: for j in pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.first..
1668: pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.last loop
1669:
1670: if j > 0 then
1671: lv_balance_name

Line 1668: pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.last loop

1664: ,p_balcall_aaid => ln_bal_asg_action_id);
1665:
1666: IF ln_bal_value <> 0 THEN
1667: for j in pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.first..
1668: pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.last loop
1669:
1670: if j > 0 then
1671: lv_balance_name
1672: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).balance_name;

Line 1672: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).balance_name;

1668: pay_us_emp_baladj_cleanup.ltr_sit_tax_bal.last loop
1669:
1670: if j > 0 then
1671: lv_balance_name
1672: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).balance_name;
1673: ln_ytd_def_bal_id
1674: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).ytd_def_bal_id;
1675: lv_element_name
1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;

Line 1674: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).ytd_def_bal_id;

1670: if j > 0 then
1671: lv_balance_name
1672: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).balance_name;
1673: ln_ytd_def_bal_id
1674: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).ytd_def_bal_id;
1675: lv_element_name
1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;
1677: ln_element_type_id
1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;

Line 1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;

1672: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).balance_name;
1673: ln_ytd_def_bal_id
1674: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).ytd_def_bal_id;
1675: lv_element_name
1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;
1677: ln_element_type_id
1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;
1679: lv_input_name
1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;

Line 1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;

1674: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).ytd_def_bal_id;
1675: lv_element_name
1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;
1677: ln_element_type_id
1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;
1679: lv_input_name
1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;
1681: ln_input_value_id
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;

Line 1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;

1676: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_name;
1677: ln_element_type_id
1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;
1679: lv_input_name
1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;
1681: ln_input_value_id
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;

1678: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).element_type_id;
1679: lv_input_name
1680: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_name;
1681: ln_input_value_id
1682: := pay_us_emp_baladj_cleanup.ltr_sit_tax_bal(j).input_value_id;
1683:
1684: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1685: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1686: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 1709: := pay_us_emp_baladj_cleanup.get_input_value_id(

1705: if lv_sub2_jd_flag = 'N' then
1706: ln_count2 := sub2_input_value_table.count+1;
1707: --Set Input Value of Jurisdiction
1708: sub2_input_value_table(ln_count2)
1709: := pay_us_emp_baladj_cleanup.get_input_value_id(
1710: p_element_type_id => ln_element_type_id
1711: ,p_input_value_name => 'Jurisdiction'
1712: ,p_effective_date => ld_run_effective_date);
1713: sub2_entry_value_table(ln_count2) := lv_jurisdiction;

Line 1742: := pay_us_emp_baladj_cleanup.get_input_value_id(

1738: if lv_sub_jd_flag = 'N' then
1739: ln_count1 := sub_input_value_table.count+1;
1740: --Set Input Value of Jurisdiction
1741: sub_input_value_table(ln_count1)
1742: := pay_us_emp_baladj_cleanup.get_input_value_id(
1743: p_element_type_id => ln_element_type_id
1744: ,p_input_value_name => 'Jurisdiction'
1745: ,p_effective_date => ld_run_effective_date);
1746: sub_entry_value_table(ln_count1) := lv_jurisdiction;

Line 1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then

1847: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
1848: is null then
1849: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1850: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then
1852: lv_balance_name
1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1854: ln_ytd_def_bal_id
1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;

Line 1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;

1849: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1850: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then
1852: lv_balance_name
1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1854: ln_ytd_def_bal_id
1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;
1856: lv_element_name
1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;

Line 1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;

1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then
1852: lv_balance_name
1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1854: ln_ytd_def_bal_id
1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;
1856: lv_element_name
1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;
1858: ln_element_type_id
1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;

Line 1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;

1853: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).balance_name;
1854: ln_ytd_def_bal_id
1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;
1856: lv_element_name
1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;
1858: ln_element_type_id
1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;
1860: lv_input_name
1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;

Line 1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;

1855: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).ytd_def_bal_id;
1856: lv_element_name
1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;
1858: ln_element_type_id
1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;
1860: lv_input_name
1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;
1862: ln_input_value_id
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;

Line 1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;

1857: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_name;
1858: ln_element_type_id
1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;
1860: lv_input_name
1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;
1862: ln_input_value_id
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;

1859: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).element_type_id;
1860: lv_input_name
1861: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_name;
1862: ln_input_value_id
1863: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(0).input_value_id;
1864:
1865: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1866: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1867: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 1877: for k in pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.first..

1873: p_defined_balance_id => ln_ytd_def_bal_id
1874: ,p_balcall_aaid => ln_bal_asg_action_id);
1875:
1876: IF ln_bal_value <> 0 THEN
1877: for k in pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.first..
1878: pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.last loop
1879: if k > 0 then
1880: lv_balance_name
1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;

Line 1878: pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.last loop

1874: ,p_balcall_aaid => ln_bal_asg_action_id);
1875:
1876: IF ln_bal_value <> 0 THEN
1877: for k in pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.first..
1878: pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.last loop
1879: if k > 0 then
1880: lv_balance_name
1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;
1882: ln_ytd_def_bal_id

Line 1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;

1877: for k in pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.first..
1878: pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.last loop
1879: if k > 0 then
1880: lv_balance_name
1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;
1882: ln_ytd_def_bal_id
1883: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).ytd_def_bal_id;
1884: lv_element_name
1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;

Line 1883: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).ytd_def_bal_id;

1879: if k > 0 then
1880: lv_balance_name
1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;
1882: ln_ytd_def_bal_id
1883: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).ytd_def_bal_id;
1884: lv_element_name
1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;
1886: ln_element_type_id
1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;

Line 1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;

1881: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).balance_name;
1882: ln_ytd_def_bal_id
1883: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).ytd_def_bal_id;
1884: lv_element_name
1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;
1886: ln_element_type_id
1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;
1888: lv_input_name
1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;

Line 1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;

1883: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).ytd_def_bal_id;
1884: lv_element_name
1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;
1886: ln_element_type_id
1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;
1888: lv_input_name
1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;
1890: ln_input_value_id
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;

Line 1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;

1885: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_name;
1886: ln_element_type_id
1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;
1888: lv_input_name
1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;
1890: ln_input_value_id
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;

1887: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).element_type_id;
1888: lv_input_name
1889: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_name;
1890: ln_input_value_id
1891: := pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal(k).input_value_id;
1892:
1893: hr_utility.trace('lv_balance_name =' || lv_balance_name);
1894: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
1895: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 1912: := pay_us_emp_baladj_cleanup.get_input_value_id(

1908: if lv_sub2_jd_flag = 'N' then
1909: ln_count2 := sub2_input_value_table.count+1;
1910: --Set Input Value of Jurisdiction
1911: sub2_input_value_table(ln_count2)
1912: := pay_us_emp_baladj_cleanup.get_input_value_id(
1913: p_element_type_id => ln_element_type_id
1914: ,p_input_value_name => 'Jurisdiction'
1915: ,p_effective_date => ld_run_effective_date);
1916: sub2_entry_value_table(ln_count2) := lv_jurisdiction;

Line 1945: := pay_us_emp_baladj_cleanup.get_input_value_id(

1941: if lv_sub_jd_flag = 'N' then
1942: ln_count1 := sub_input_value_table.count+1;
1943: --Set Input Value of Jurisdiction
1944: sub_input_value_table(ln_count1)
1945: := pay_us_emp_baladj_cleanup.get_input_value_id(
1946: p_element_type_id => ln_element_type_id
1947: ,p_input_value_name => 'Jurisdiction'
1948: ,p_effective_date => ld_run_effective_date);
1949: sub_entry_value_table(ln_count1) := lv_jurisdiction;

Line 2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then

2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
2060: is not null then
2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2062: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then
2064: lv_balance_name
2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2066: ln_ytd_def_bal_id
2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;

Line 2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;

2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2062: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then
2064: lv_balance_name
2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2066: ln_ytd_def_bal_id
2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;
2068: lv_element_name
2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;

Line 2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;

2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then
2064: lv_balance_name
2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2066: ln_ytd_def_bal_id
2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;
2068: lv_element_name
2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;
2070: ln_element_type_id
2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;

Line 2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;

2065: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).balance_name;
2066: ln_ytd_def_bal_id
2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;
2068: lv_element_name
2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;
2070: ln_element_type_id
2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;
2072: lv_input_name
2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;

Line 2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;

2067: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).ytd_def_bal_id;
2068: lv_element_name
2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;
2070: ln_element_type_id
2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;
2072: lv_input_name
2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;
2074: ln_input_value_id
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;

Line 2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;

2069: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_name;
2070: ln_element_type_id
2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;
2072: lv_input_name
2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;
2074: ln_input_value_id
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;

2071: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).element_type_id;
2072: lv_input_name
2073: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_name;
2074: ln_input_value_id
2075: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(0).input_value_id;
2076:
2077: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2078: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2079: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 2091: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).balance_name;

2087: hr_utility.trace('ln_subj_bal_value =' || ln_subj_bal_value);
2088:
2089: IF ln_subj_bal_value <> 0 THEN
2090: lv_balance_name
2091: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).balance_name;
2092: ln_ytd_def_bal_id
2093: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).ytd_def_bal_id;
2094: lv_element_name
2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;

Line 2093: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).ytd_def_bal_id;

2089: IF ln_subj_bal_value <> 0 THEN
2090: lv_balance_name
2091: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).balance_name;
2092: ln_ytd_def_bal_id
2093: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).ytd_def_bal_id;
2094: lv_element_name
2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;
2096: ln_element_type_id
2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;

Line 2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;

2091: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).balance_name;
2092: ln_ytd_def_bal_id
2093: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).ytd_def_bal_id;
2094: lv_element_name
2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;
2096: ln_element_type_id
2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;
2098: lv_input_name
2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;

Line 2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;

2093: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).ytd_def_bal_id;
2094: lv_element_name
2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;
2096: ln_element_type_id
2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;
2098: lv_input_name
2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;
2100: ln_input_value_id
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;

Line 2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;

2095: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_name;
2096: ln_element_type_id
2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;
2098: lv_input_name
2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;
2100: ln_input_value_id
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;

2097: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).element_type_id;
2098: lv_input_name
2099: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_name;
2100: ln_input_value_id
2101: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(1).input_value_id;
2102:
2103: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2104: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2105: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 2119: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).balance_name;

2115: -- Reduced Subject
2116: ln_redu_subj_bal_value := ln_subj_bal_value - ln_pre_tax_bal_value;
2117: hr_utility.trace('ln_redu_subj_bal_value ='||ln_redu_subj_bal_value);
2118: lv_balance_name
2119: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).balance_name;
2120: ln_ytd_def_bal_id
2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;
2122: lv_element_name
2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;

Line 2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;

2117: hr_utility.trace('ln_redu_subj_bal_value ='||ln_redu_subj_bal_value);
2118: lv_balance_name
2119: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).balance_name;
2120: ln_ytd_def_bal_id
2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;
2122: lv_element_name
2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;
2124: ln_element_type_id
2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;

Line 2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;

2119: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).balance_name;
2120: ln_ytd_def_bal_id
2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;
2122: lv_element_name
2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;
2124: ln_element_type_id
2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;
2126: lv_input_name
2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;

Line 2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;

2121: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).ytd_def_bal_id;
2122: lv_element_name
2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;
2124: ln_element_type_id
2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;
2126: lv_input_name
2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;
2128: ln_input_value_id
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;

Line 2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;

2123: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_name;
2124: ln_element_type_id
2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;
2126: lv_input_name
2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;
2128: ln_input_value_id
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;

2125: :=pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).element_type_id;
2126: lv_input_name
2127: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_name;
2128: ln_input_value_id
2129: := pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal(2).input_value_id;
2130:
2131: hr_utility.trace('lv_balance_name =' || lv_balance_name);
2132: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
2133: hr_utility.trace('lv_element_name=' || lv_element_name);

Line 2162: := pay_us_emp_baladj_cleanup.get_input_value_id(

2158: if lv_misc_jd_flag = 'N' then
2159: ln_count3 := misc_input_value_table.count+1;
2160: --Set Input Value of Jurisdiction
2161: misc_input_value_table(ln_count3)
2162: := pay_us_emp_baladj_cleanup.get_input_value_id(
2163: p_element_type_id => ln_element_type_id
2164: ,p_input_value_name => 'Jurisdiction'
2165: ,p_effective_date => ld_run_effective_date);
2166: misc_entry_value_table(ln_count3) := lv_jurisdiction;

Line 2248: gv_package := 'pay_us_emp_baladj_cleanup';

2244:
2245: begin
2246: --hr_utility.trace_on (null, 'BAL');
2247:
2248: gv_package := 'pay_us_emp_baladj_cleanup';
2249: g_proc_init := FALSE;
2250: g_min_chunk := -1;
2251: end pay_us_emp_baladj_cleanup;

Line 2251: end pay_us_emp_baladj_cleanup;

2247:
2248: gv_package := 'pay_us_emp_baladj_cleanup';
2249: g_proc_init := FALSE;
2250: g_min_chunk := -1;
2251: end pay_us_emp_baladj_cleanup;