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_IE_TAX_VAL dependencies on PAY_IE_TAX_BODY_INTERFACE

Line 35: pay_ie_tax_body_interface tbi,

31: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
32: from per_all_assignments_f asg,
33: per_all_people_f per,
34: pay_all_payrolls_f pay,
35: pay_ie_tax_body_interface tbi,
36: per_periods_of_service pps
37: where per.national_identifier = tbi.pps_number
38: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)
39: --AND asg.payroll_id = pay.payroll_id

Line 56: ,pay_ie_tax_body_interface tbi

52: group by per.person_id,per.NATIONAL_IDENTIFIER;
53:
54: /* Cursor check_pps(p_pps_no varchar) is
55: Select 1 from per_all_people_f per
56: ,pay_ie_tax_body_interface tbi
57: Where per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
58: AND per.effective_end_date >= trunc(tbi.cert_start_date)
59: and per.national_identifier=p_pps_no
60: AND tbi.process_flag = 'Y'

Line 140: , pay_ie_tax_body_interface tbi

136: , per_all_assignments_f asg
137: , per_all_people_f per
138: , pay_all_payrolls_f pay
139: --, pay_ie_paye_details_f ppd
140: , pay_ie_tax_body_interface tbi
141: , pay_ie_tax_header_interface thi
142: WHERE per.person_id = asg.person_id
143: AND per.national_identifier = tbi.pps_number
144: AND asg.business_group_id = hou.business_group_id

Line 242: , pay_ie_tax_body_interface tbi

238: , per_all_assignments_f asg
239: , per_all_people_f per
240: , pay_all_payrolls_f pay
241: --, pay_ie_paye_details_f ppd
242: , pay_ie_tax_body_interface tbi
243: , pay_ie_tax_header_interface thi,
244: per_periods_of_service pps
245: WHERE per.person_id = asg.person_id
246: AND per.national_identifier = tbi.pps_number

Line 277: select pps_number, works_number from pay_ie_tax_body_interface

273: -- cursor get the skipped assignments. Assignments that didnt get processed
274: -- in the process
275: --bug 6376140 cursor modified for processing single assg
276: /* cursor csr_skipped_asg is
277: select pps_number, works_number from pay_ie_tax_body_interface
278: minus
279: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
280: FROM hr_organization_information hoi
281: , hr_organization_units hou

Line 286: , pay_ie_tax_body_interface tbi

282: , per_all_assignments_f asg
283: , per_all_people_f per
284: , pay_all_payrolls_f pay
285: --, pay_ie_paye_details_f ppd
286: , pay_ie_tax_body_interface tbi
287: , pay_ie_tax_header_interface thi
288: WHERE per.person_id = asg.person_id
289: AND asg.business_group_id = hou.business_group_id
290: AND hou.organization_id = hoi.organization_id

Line 310: from pay_ie_tax_body_interface;

306: AND pay.effective_end_date >= trunc(tbi.cert_start_date); */
307:
308: cursor csr_skipped_assignments is
309: select distinct pps_number pps_number,works_number,last_name,first_name
310: from pay_ie_tax_body_interface;
311:
312: /* check to see if any single paye details exists */
313: cursor get_paye_details (p_assignment_id number) is
314: select count(*) from pay_ie_paye_details_f where

Line 403: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;

399: l_datetrack_mode VARCHAR2(12);
400: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372
401: l_header_count NUMBER := 0;
402: l_record_count NUMBER := 0;
403: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
404: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
405:
406: l_usc_tax_basis pay_ie_paye_details_f.usc_tax_basis%TYPE;
407: --Declare output parameters from api row handlersb

Line 404: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;

400: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372
401: l_header_count NUMBER := 0;
402: l_record_count NUMBER := 0;
403: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
404: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
405:
406: l_usc_tax_basis pay_ie_paye_details_f.usc_tax_basis%TYPE;
407: --Declare output parameters from api row handlersb
408: l_ins_paye_details_id NUMBER;

Line 862: UPDATE pay_ie_tax_body_interface

858: /*Update interface table and set processed flag to 'Yes' to record that record has been updated or
859: inserted into payroll tables successfully using the row handler APIs.*/
860:
861: IF (p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
862: UPDATE pay_ie_tax_body_interface
863: SET processed_flag = 'Y'
864: WHERE pps_number = r_pay.pps_number_int;
865: END IF;
866: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);

Line 1418: UPDATE pay_ie_tax_body_interface

1414: /*Update interface table and set processed flag to 'No' to record that record has not been updated
1415: or inserted into payroll tables*/
1416:
1417: IF p_validate_mode = 'IE_VALIDATE_COMMIT' THEN
1418: UPDATE pay_ie_tax_body_interface
1419: SET processed_flag = 'N'
1420: WHERE pps_number = r_pay.pps_number_int;
1421: END IF;
1422: -- The following command will be used to output the exception details to an output file:

Line 1634: , PAY_IE_TAX_BODY_INTERFACE pbs

1630: ,SUM(NVL(PBS.AM_USC_YRLY_CUTOFF_3,0)) sum_USC_YRLY_CUTOFF_3
1631: ,SUM(NVL(PBS.AM_USC_YRLY_CUTOFF_4,0)) sum_USC_YRLY_CUTOFF_4
1632: --
1633: FROM PAY_IE_TAX_HEADER_INTERFACE phs
1634: , PAY_IE_TAX_BODY_INTERFACE pbs
1635: WHERE PHS.EMPLOYER_NUMBER = PBS.EMPLOYER_NUMBER
1636: AND PHS.TAX_YEAR = p_tax_year
1637: AND PBS.EMPLOYER_NUMBER = p_employer_number;
1638:

Line 1824: update pay_ie_tax_body_interface

1820: THEN
1821: retcode := 0;
1822: fnd_file.put_line( fnd_file.log, 'FND - CONC-COMPLETION TEXT:NORMAL');
1823:
1824: update pay_ie_tax_body_interface
1825: set process_flag = 'Y'
1826: where EMPLOYER_NUMBER = p_employer_number;
1827: Commit;
1828:

Line 1849: 'The total number of record in pay_ie_tax_body_interface is '

1845: retcode := 2;
1846: IF l_count_mth_taxcredit <> l_count_emp_recno THEN
1847: FND_FILE.NEW_LINE(fnd_file.log, 1);
1848: FND_FILE.PUT_LINE(fnd_file.log,
1849: 'The total number of record in pay_ie_tax_body_interface is '
1850: || TO_CHAR (l_count_mth_taxcredit));
1851: FND_FILE.PUT_LINE (fnd_file.log,
1852: 'The value in pay_ie_tax_trailer_interface.record_no is '
1853: || TO_CHAR(l_count_emp_recno));

Line 1855: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');

1851: FND_FILE.PUT_LINE (fnd_file.log,
1852: 'The value in pay_ie_tax_trailer_interface.record_no is '
1853: || TO_CHAR(l_count_emp_recno));
1854: FND_FILE.PUT_LINE(fnd_file.log,
1855: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
1856: FND_FILE.PUT_LINE(fnd_file.log,
1857: 'does not match the value in pay_ie_tax_trailer_interface.record_no');
1858: END IF;
1859:

Line 1863: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '

1859:
1860: IF l_sum_mth_rate_cutoff <> l_total_mth_cutoff THEN
1861: FND_FILE.NEW_LINE(fnd_file.log, 1);
1862: FND_FILE.PUT_LINE(fnd_file.log,
1863: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '
1864: || TO_CHAR (l_sum_mth_rate_cutoff));
1865: FND_FILE.PUT_LINE (fnd_file.log,
1866: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
1867: || TO_CHAR(l_total_mth_cutoff));

Line 1869: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');

1865: FND_FILE.PUT_LINE (fnd_file.log,
1866: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
1867: || TO_CHAR(l_total_mth_cutoff));
1868: FND_FILE.PUT_LINE(fnd_file.log,
1869: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
1870: FND_FILE.PUT_LINE(fnd_file.log,
1871: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');
1872: END IF;
1873: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN

Line 1876: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '

1872: END IF;
1873: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN
1874: FND_FILE.NEW_LINE(fnd_file.log, 1);
1875: FND_FILE.PUT_LINE(fnd_file.log,
1876: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '
1877: || TO_CHAR(l_sum_wk_rate_cutoff));
1878: FND_FILE.PUT_LINE(fnd_file.log,
1879: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
1880: || TO_CHAR(l_total_wk_cutoff));

Line 1882: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');

1878: FND_FILE.PUT_LINE(fnd_file.log,
1879: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
1880: || TO_CHAR(l_total_wk_cutoff));
1881: FND_FILE.PUT_LINE(fnd_file.log,
1882: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
1883: FND_FILE.PUT_LINE(fnd_file.log,
1884: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');
1885: END IF;
1886: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN

Line 1889: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '

1885: END IF;
1886: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN
1887: FND_FILE.NEW_LINE(fnd_file.log, 1);
1888: FND_FILE.PUT_LINE(fnd_file.log,
1889: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '
1890: || TO_CHAR(l_sum_mth_tax_credit));
1891: FND_FILE.PUT_LINE(fnd_file.log,
1892: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
1893: || TO_CHAR(l_total_mth_credit));

Line 1895: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');

1891: FND_FILE.PUT_LINE(fnd_file.log,
1892: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
1893: || TO_CHAR(l_total_mth_credit));
1894: FND_FILE.PUT_LINE(fnd_file.log,
1895: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
1896: FND_FILE.PUT_LINE(fnd_file.log,
1897: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');
1898: END IF;
1899: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN

Line 1902: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '

1898: END IF;
1899: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN
1900: FND_FILE.NEW_LINE(fnd_file.log, 1);
1901: FND_FILE.PUT_LINE(fnd_file.log,
1902: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '
1903: || TO_CHAR(l_sum_wk_tax_credit));
1904: FND_FILE.PUT_LINE(fnd_file.log,
1905: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
1906: || TO_CHAR(l_total_wk_credit));

Line 1908: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');

1904: FND_FILE.PUT_LINE(fnd_file.log,
1905: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
1906: || TO_CHAR(l_total_wk_credit));
1907: FND_FILE.PUT_LINE(fnd_file.log,
1908: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
1909: FND_FILE.PUT_LINE(fnd_file.log,
1910: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
1911: END IF;
1912:

Line 1917: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_cred '

1913: --
1914: IF l_total_YEARLY_TAX_CRED <> l_sum_YRLY_TAX_CRED THEN
1915: FND_FILE.NEW_LINE(fnd_file.log, 1);
1916: FND_FILE.PUT_LINE(fnd_file.log,
1917: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_cred '
1918: || TO_CHAR(l_sum_YRLY_TAX_CRED));
1919: FND_FILE.PUT_LINE(fnd_file.log,
1920: 'The total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred is '
1921: || TO_CHAR(l_total_YEARLY_TAX_CRED));

Line 1923: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_cred');

1919: FND_FILE.PUT_LINE(fnd_file.log,
1920: 'The total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred is '
1921: || TO_CHAR(l_total_YEARLY_TAX_CRED));
1922: FND_FILE.PUT_LINE(fnd_file.log,
1923: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_cred');
1924: FND_FILE.PUT_LINE(fnd_file.log,
1925: 'does not match the total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred');
1926: END IF;
1927:

Line 1931: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1 '

1927:
1928: IF l_total_YEARLY_TAX_RATE_1 <> l_sum_YRLY_TAX_RATE_1 THEN
1929: FND_FILE.NEW_LINE(fnd_file.log, 1);
1930: FND_FILE.PUT_LINE(fnd_file.log,
1931: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1 '
1932: || TO_CHAR(l_sum_YRLY_TAX_RATE_1));
1933: FND_FILE.PUT_LINE(fnd_file.log,
1934: 'The total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1 is '
1935: || TO_CHAR(l_total_YEARLY_TAX_RATE_1));

Line 1937: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1');

1933: FND_FILE.PUT_LINE(fnd_file.log,
1934: 'The total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1 is '
1935: || TO_CHAR(l_total_YEARLY_TAX_RATE_1));
1936: FND_FILE.PUT_LINE(fnd_file.log,
1937: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1');
1938: FND_FILE.PUT_LINE(fnd_file.log,
1939: 'does not match the total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1');
1940: END IF;
1941:

Line 1945: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2 '

1941:
1942: IF l_total_YEARLY_TAX_RATE_2 <> l_sum_YRLY_TAX_RATE_2 THEN
1943: FND_FILE.NEW_LINE(fnd_file.log, 1);
1944: FND_FILE.PUT_LINE(fnd_file.log,
1945: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2 '
1946: || TO_CHAR(l_sum_YRLY_TAX_RATE_2));
1947: FND_FILE.PUT_LINE(fnd_file.log,
1948: 'The total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2 is '
1949: || TO_CHAR(l_total_YEARLY_TAX_RATE_2));

Line 1951: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2');

1947: FND_FILE.PUT_LINE(fnd_file.log,
1948: 'The total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2 is '
1949: || TO_CHAR(l_total_YEARLY_TAX_RATE_2));
1950: FND_FILE.PUT_LINE(fnd_file.log,
1951: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2');
1952: FND_FILE.PUT_LINE(fnd_file.log,
1953: 'does not match the total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2');
1954: END IF;
1955:

Line 1959: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2 '

1955:
1956: IF l_total_MONTHLY_TAX_RATE_2 <> l_sum_MTHLY_TAX_RATE_2 THEN
1957: FND_FILE.NEW_LINE(fnd_file.log, 1);
1958: FND_FILE.PUT_LINE(fnd_file.log,
1959: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2 '
1960: || TO_CHAR(l_sum_MTHLY_TAX_RATE_2));
1961: FND_FILE.PUT_LINE(fnd_file.log,
1962: 'The total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2 is '
1963: || TO_CHAR(l_total_MONTHLY_TAX_RATE_2));

Line 1965: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2');

1961: FND_FILE.PUT_LINE(fnd_file.log,
1962: 'The total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2 is '
1963: || TO_CHAR(l_total_MONTHLY_TAX_RATE_2));
1964: FND_FILE.PUT_LINE(fnd_file.log,
1965: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2');
1966: FND_FILE.PUT_LINE(fnd_file.log,
1967: 'does not match the total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2');
1968: END IF;
1969:

Line 1973: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2 '

1969:
1970: IF l_total_WEEKLY_TAX_RATE_2 <> l_sum_WKLY_TAX_RATE_2 THEN
1971: FND_FILE.NEW_LINE(fnd_file.log, 1);
1972: FND_FILE.PUT_LINE(fnd_file.log,
1973: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2 '
1974: || TO_CHAR(l_sum_WKLY_TAX_RATE_2));
1975: FND_FILE.PUT_LINE(fnd_file.log,
1976: 'The total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2 is '
1977: || TO_CHAR(l_total_WEEKLY_TAX_RATE_2));

Line 1979: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2');

1975: FND_FILE.PUT_LINE(fnd_file.log,
1976: 'The total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2 is '
1977: || TO_CHAR(l_total_WEEKLY_TAX_RATE_2));
1978: FND_FILE.PUT_LINE(fnd_file.log,
1979: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2');
1980: FND_FILE.PUT_LINE(fnd_file.log,
1981: 'does not match the total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2');
1982: END IF;
1983:

Line 1987: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3 '

1983:
1984: IF l_total_YEARLY_TAX_RATE_3 <> l_sum_YRLY_TAX_RATE_3 THEN
1985: FND_FILE.NEW_LINE(fnd_file.log, 1);
1986: FND_FILE.PUT_LINE(fnd_file.log,
1987: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3 '
1988: || TO_CHAR(l_sum_YRLY_TAX_RATE_3));
1989: FND_FILE.PUT_LINE(fnd_file.log,
1990: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3 is '
1991: || TO_CHAR(l_total_YEARLY_TAX_RATE_3));

Line 1993: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3');

1989: FND_FILE.PUT_LINE(fnd_file.log,
1990: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3 is '
1991: || TO_CHAR(l_total_YEARLY_TAX_RATE_3));
1992: FND_FILE.PUT_LINE(fnd_file.log,
1993: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3');
1994: FND_FILE.PUT_LINE(fnd_file.log,
1995: 'does not match the total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3');
1996: END IF;
1997:

Line 2001: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3 '

1997:
1998: IF l_total_MONTHLY_TAX_RATE_3 <> l_sum_MTHLY_TAX_RATE_3 THEN
1999: FND_FILE.NEW_LINE(fnd_file.log, 1);
2000: FND_FILE.PUT_LINE(fnd_file.log,
2001: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3 '
2002: || TO_CHAR(l_sum_MTHLY_TAX_RATE_3));
2003: FND_FILE.PUT_LINE(fnd_file.log,
2004: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3 is '
2005: || TO_CHAR(l_total_MONTHLY_TAX_RATE_3));

Line 2007: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3');

2003: FND_FILE.PUT_LINE(fnd_file.log,
2004: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3 is '
2005: || TO_CHAR(l_total_MONTHLY_TAX_RATE_3));
2006: FND_FILE.PUT_LINE(fnd_file.log,
2007: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3');
2008: FND_FILE.PUT_LINE(fnd_file.log,
2009: 'does not match the total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3');
2010: END IF;
2011:

Line 2015: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3 '

2011:
2012: IF l_total_WEEKLY_TAX_RATE_3 <> l_sum_WKLY_TAX_RATE_3 THEN
2013: FND_FILE.NEW_LINE(fnd_file.log, 1);
2014: FND_FILE.PUT_LINE(fnd_file.log,
2015: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3 '
2016: || TO_CHAR(l_sum_WKLY_TAX_RATE_3));
2017: FND_FILE.PUT_LINE(fnd_file.log,
2018: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3 is '
2019: || TO_CHAR(l_total_WEEKLY_TAX_RATE_3));

Line 2021: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3');

2017: FND_FILE.PUT_LINE(fnd_file.log,
2018: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3 is '
2019: || TO_CHAR(l_total_WEEKLY_TAX_RATE_3));
2020: FND_FILE.PUT_LINE(fnd_file.log,
2021: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3');
2022: FND_FILE.PUT_LINE(fnd_file.log,
2023: 'does not match the total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3');
2024: END IF;
2025:

Line 2029: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4 '

2025:
2026: IF l_total_YEARLY_TAX_RATE_4 <> l_sum_YRLY_TAX_RATE_4 THEN
2027: FND_FILE.NEW_LINE(fnd_file.log, 1);
2028: FND_FILE.PUT_LINE(fnd_file.log,
2029: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4 '
2030: || TO_CHAR(l_sum_YRLY_TAX_RATE_4));
2031: FND_FILE.PUT_LINE(fnd_file.log,
2032: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4 is '
2033: || TO_CHAR(l_total_YEARLY_TAX_RATE_4));

Line 2035: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4');

2031: FND_FILE.PUT_LINE(fnd_file.log,
2032: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4 is '
2033: || TO_CHAR(l_total_YEARLY_TAX_RATE_4));
2034: FND_FILE.PUT_LINE(fnd_file.log,
2035: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4');
2036: FND_FILE.PUT_LINE(fnd_file.log,
2037: 'does not match the total yearly tax rate4 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4');
2038: END IF;
2039:

Line 2043: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4 '

2039:
2040: IF l_total_MONTHLY_TAX_RATE_4 <> l_sum_MTHLY_TAX_RATE_4 THEN
2041: FND_FILE.NEW_LINE(fnd_file.log, 1);
2042: FND_FILE.PUT_LINE(fnd_file.log,
2043: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4 '
2044: || TO_CHAR(l_sum_MTHLY_TAX_RATE_4));
2045: FND_FILE.PUT_LINE(fnd_file.log,
2046: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4 is '
2047: || TO_CHAR(l_total_MONTHLY_TAX_RATE_4));

Line 2049: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4');

2045: FND_FILE.PUT_LINE(fnd_file.log,
2046: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4 is '
2047: || TO_CHAR(l_total_MONTHLY_TAX_RATE_4));
2048: FND_FILE.PUT_LINE(fnd_file.log,
2049: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4');
2050: FND_FILE.PUT_LINE(fnd_file.log,
2051: 'does not match the total monthly tax rate4 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4');
2052: END IF;
2053:

Line 2057: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4 '

2053:
2054: IF l_total_WEEKLY_TAX_RATE_4 <> l_sum_WKLY_TAX_RATE_4 THEN
2055: FND_FILE.NEW_LINE(fnd_file.log, 1);
2056: FND_FILE.PUT_LINE(fnd_file.log,
2057: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4 '
2058: || TO_CHAR(l_sum_WKLY_TAX_RATE_4));
2059: FND_FILE.PUT_LINE(fnd_file.log,
2060: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4 is '
2061: || TO_CHAR(l_total_WEEKLY_TAX_RATE_4));

Line 2063: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4');

2059: FND_FILE.PUT_LINE(fnd_file.log,
2060: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4 is '
2061: || TO_CHAR(l_total_WEEKLY_TAX_RATE_4));
2062: FND_FILE.PUT_LINE(fnd_file.log,
2063: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4');
2064: FND_FILE.PUT_LINE(fnd_file.log,
2065: 'does not match the total weekly tax rate4 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4');
2066: END IF;
2067:

Line 2071: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1 '

2067:
2068: IF l_total_YEARLY_USC_RATE_1 <> l_sum_USC_YRLY_CUTOFF_1 THEN
2069: FND_FILE.NEW_LINE(fnd_file.log, 1);
2070: FND_FILE.PUT_LINE(fnd_file.log,
2071: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1 '
2072: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_1));
2073: FND_FILE.PUT_LINE(fnd_file.log,
2074: 'The total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1 is '
2075: || TO_CHAR(l_total_YEARLY_USC_RATE_1));

Line 2077: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1');

2073: FND_FILE.PUT_LINE(fnd_file.log,
2074: 'The total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1 is '
2075: || TO_CHAR(l_total_YEARLY_USC_RATE_1));
2076: FND_FILE.PUT_LINE(fnd_file.log,
2077: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1');
2078: FND_FILE.PUT_LINE(fnd_file.log,
2079: 'does not match the total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1');
2080: END IF;
2081:

Line 2085: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2 '

2081:
2082: IF l_total_YEARLY_USC_RATE_2 <> l_sum_USC_YRLY_CUTOFF_2 THEN
2083: FND_FILE.NEW_LINE(fnd_file.log, 1);
2084: FND_FILE.PUT_LINE(fnd_file.log,
2085: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2 '
2086: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_2));
2087: FND_FILE.PUT_LINE(fnd_file.log,
2088: 'The total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2 is '
2089: || TO_CHAR(l_total_YEARLY_USC_RATE_2));

Line 2091: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2');

2087: FND_FILE.PUT_LINE(fnd_file.log,
2088: 'The total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2 is '
2089: || TO_CHAR(l_total_YEARLY_USC_RATE_2));
2090: FND_FILE.PUT_LINE(fnd_file.log,
2091: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2');
2092: FND_FILE.PUT_LINE(fnd_file.log,
2093: 'does not match the total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2');
2094: END IF;
2095:

Line 2099: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3 '

2095:
2096: IF l_total_YEARLY_USC_RATE_3 <> l_sum_USC_YRLY_CUTOFF_3 THEN
2097: FND_FILE.NEW_LINE(fnd_file.log, 1);
2098: FND_FILE.PUT_LINE(fnd_file.log,
2099: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3 '
2100: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_3));
2101: FND_FILE.PUT_LINE(fnd_file.log,
2102: 'The total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3 is '
2103: || TO_CHAR(l_total_YEARLY_USC_RATE_3));

Line 2105: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3');

2101: FND_FILE.PUT_LINE(fnd_file.log,
2102: 'The total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3 is '
2103: || TO_CHAR(l_total_YEARLY_USC_RATE_3));
2104: FND_FILE.PUT_LINE(fnd_file.log,
2105: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3');
2106: FND_FILE.PUT_LINE(fnd_file.log,
2107: 'does not match the total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3');
2108: END IF;
2109:

Line 2113: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4 '

2109:
2110: IF l_total_YEARLY_USC_RATE_4 <> l_sum_USC_YRLY_CUTOFF_4 THEN
2111: FND_FILE.NEW_LINE(fnd_file.log, 1);
2112: FND_FILE.PUT_LINE(fnd_file.log,
2113: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4 '
2114: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_4));
2115: FND_FILE.PUT_LINE(fnd_file.log,
2116: 'The total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4 is '
2117: || TO_CHAR(l_total_YEARLY_USC_RATE_4));

Line 2119: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4');

2115: FND_FILE.PUT_LINE(fnd_file.log,
2116: 'The total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4 is '
2117: || TO_CHAR(l_total_YEARLY_USC_RATE_4));
2118: FND_FILE.PUT_LINE(fnd_file.log,
2119: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4');
2120: FND_FILE.PUT_LINE(fnd_file.log,
2121: 'does not match the total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4');
2122: END IF;
2123:

Line 2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

2146: l_error_stack := errbuf;
2147: l_error := SQLERRM;
2148: retcode := 2;
2149: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
2151:
2152: INSERT INTO pay_ie_tax_error ( pps_number
2153: , employee_number
2154: , full_name

Line 2201: --l_record_type pay_ie_tax_body_interface.record_type%type;

2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:
2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;

Line 2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;

2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:
2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;

Line 2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;

2199:
2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;

Line 2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;

2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;

Line 2205: l_works_number pay_ie_tax_body_interface.works_number%type;

2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;

Line 2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;

2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;
2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;

Line 2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;

2203: l_mth_rate_cutoff pay_ie_tax_body_interface.mth_rate_cutoff%type;
2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;

Line 2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;

2204: l_wk_rate_cutoff pay_ie_tax_body_interface.wk_rate_cutoff%type;
2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;

Line 2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;

2205: l_works_number pay_ie_tax_body_interface.works_number%type;
2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;

Line 2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;

2206: l_mth_tax_credit pay_ie_tax_body_interface.mth_tax_credit%type;
2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;

Line 2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;

2207: l_wk_tax_credit pay_ie_tax_body_interface.wk_tax_credit%type;
2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;

Line 2212: l_last_name pay_ie_tax_body_interface.last_name%type;

2208: l_cert_start_date pay_ie_tax_body_interface.cert_start_date%type;
2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;

Line 2213: l_first_name pay_ie_tax_body_interface.first_name%type;

2209: l_cert_end_date pay_ie_tax_body_interface.cert_end_date%type;
2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;

Line 2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;

2210: l_wk_mth_indicator pay_ie_tax_body_interface.wk_mth_indicator%type;
2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;

Line 2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;

2211: l_cert_date pay_ie_tax_body_interface.cert_date%type;
2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;

Line 2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;

2212: l_last_name pay_ie_tax_body_interface.last_name%type;
2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;

Line 2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;

2213: l_first_name pay_ie_tax_body_interface.first_name%type;
2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;
2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;

Line 2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;

2214: l_address_line1 pay_ie_tax_body_interface.address_line1%type;
2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;
2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;
2222: l_processed_flag VARCHAR2(1);

Line 2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;

2215: l_address_line2 pay_ie_tax_body_interface.address_line2%type;
2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;
2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;
2222: l_processed_flag VARCHAR2(1);
2223: l_processed_date DATE;

Line 2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;

2216: l_address_line3 pay_ie_tax_body_interface.address_line3%type;
2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;
2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;
2222: l_processed_flag VARCHAR2(1);
2223: l_processed_date DATE;
2224: --

Line 2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;

2217: l_tot_pay_to_date pay_ie_tax_body_interface.tot_pay_to_date%type;
2218: l_tot_tax_to_date pay_ie_tax_body_interface.tot_tax_to_date%type;
2219: l_exemption_indicator pay_ie_tax_body_interface.exemption_indicator%type;
2220: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%type;
2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;
2222: l_processed_flag VARCHAR2(1);
2223: l_processed_date DATE;
2224: --
2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;

Line 2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;

2221: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%type;
2222: l_processed_flag VARCHAR2(1);
2223: l_processed_date DATE;
2224: --
2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;
2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;

Line 2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;

2222: l_processed_flag VARCHAR2(1);
2223: l_processed_date DATE;
2224: --
2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;
2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;

Line 2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;

2223: l_processed_date DATE;
2224: --
2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;
2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;

Line 2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;

2224: --
2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;
2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;

Line 2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;

2225: l_cd_yrly_tax_cred pay_ie_tax_body_interface.cd_yrly_tax_cred%type;
2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;

Line 2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;

2226: l_cd_yrly_tax_rate_1 pay_ie_tax_body_interface.cd_yrly_tax_rate_1%type;
2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;

Line 2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;

2227: l_cd_yrly_tax_rate_2 pay_ie_tax_body_interface.cd_yrly_tax_rate_2%type;
2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;

Line 2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;

2228: l_cd_mthly_tax_rate_2 pay_ie_tax_body_interface.cd_mthly_tax_rate_2%type;
2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;

Line 2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;

2229: l_cd_wkly_tax_rate_2 pay_ie_tax_body_interface.cd_wkly_tax_rate_2%type;
2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;

Line 2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;

2230: l_cd_tax_rate_3 pay_ie_tax_body_interface.cd_tax_rate_3%type;
2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;

Line 2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;

2231: l_cd_yrly_tax_rate_3 pay_ie_tax_body_interface.cd_yrly_tax_rate_3%type;
2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;

Line 2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;

2232: l_cd_mthly_tax_rate_3 pay_ie_tax_body_interface.cd_mthly_tax_rate_3%type;
2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;

Line 2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;

2233: l_cd_wkly_tax_rate_3 pay_ie_tax_body_interface.cd_wkly_tax_rate_3%type;
2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;

Line 2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;

2234: l_cd_tax_rate_4 pay_ie_tax_body_interface.cd_tax_rate_4%type;
2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;

Line 2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;

2235: l_cd_yrly_tax_rate_4 pay_ie_tax_body_interface.cd_yrly_tax_rate_4%type;
2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;

Line 2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;

2236: l_cd_mthly_tax_rate_4 pay_ie_tax_body_interface.cd_mthly_tax_rate_4%type;
2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;

Line 2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;

2237: l_cd_wkly_tax_rate_4 pay_ie_tax_body_interface.cd_wkly_tax_rate_4%type;
2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;

Line 2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;

2238: l_cd_tax_rate_5 pay_ie_tax_body_interface.cd_tax_rate_5%type;
2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;

Line 2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;

2239: l_in_exempt_usc pay_ie_tax_body_interface.in_exempt_usc%type;
2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;

Line 2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;

2240: l_cd_total_usc_pay_todate pay_ie_tax_body_interface.cd_total_usc_pay_todate%type;
2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;

Line 2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;

2241: l_cd_total_usc_tax_todate pay_ie_tax_body_interface.cd_total_usc_tax_todate%type;
2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;

Line 2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;

2242: l_cd_usc_rate_1 pay_ie_tax_body_interface.cd_usc_rate_1%type;
2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;

Line 2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;

2243: l_am_usc_yrly_cutoff_1 pay_ie_tax_body_interface.am_usc_yrly_cutoff_1%type;
2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;

Line 2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;

2244: l_am_usc_mthly_cutoff_1 pay_ie_tax_body_interface.am_usc_mthly_cutoff_1%type;
2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;

Line 2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;

2245: l_am_usc_wkly_cutoff_1 pay_ie_tax_body_interface.am_usc_wkly_cutoff_1%type;
2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;

Line 2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;

2246: l_cd_usc_rate_2 pay_ie_tax_body_interface.cd_usc_rate_2%type;
2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;

Line 2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;

2247: l_am_usc_yrly_cutoff_2 pay_ie_tax_body_interface.am_usc_yrly_cutoff_2%type;
2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;

Line 2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;

2248: l_am_usc_mthly_cutoff_2 pay_ie_tax_body_interface.am_usc_mthly_cutoff_2%type;
2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;

Line 2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;

2249: l_am_usc_wkly_cutoff_2 pay_ie_tax_body_interface.am_usc_wkly_cutoff_2%type;
2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;

Line 2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;

2250: l_cd_usc_rate_3 pay_ie_tax_body_interface.cd_usc_rate_3%type;
2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;
2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;

Line 2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;

2251: l_am_usc_yrly_cutoff_3 pay_ie_tax_body_interface.am_usc_yrly_cutoff_3%type;
2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;
2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;
2259: --

Line 2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;

2252: l_am_usc_mthly_cutoff_3 pay_ie_tax_body_interface.am_usc_mthly_cutoff_3%type;
2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;
2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;
2259: --
2260:

Line 2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;

2253: l_am_usc_wkly_cutoff_3 pay_ie_tax_body_interface.am_usc_wkly_cutoff_3%type;
2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;
2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;
2259: --
2260:
2261:

Line 2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;

2254: l_cd_usc_rate_4 pay_ie_tax_body_interface.cd_usc_rate_4%type;
2255: l_am_usc_yrly_cutoff_4 pay_ie_tax_body_interface.am_usc_yrly_cutoff_4%type;
2256: l_am_usc_mthly_cutoff_4 pay_ie_tax_body_interface.am_usc_mthly_cutoff_4%type;
2257: l_am_usc_wkly_cutoff_4 pay_ie_tax_body_interface.am_usc_wkly_cutoff_4%type;
2258: l_cd_usc_rate_5 pay_ie_tax_body_interface.cd_usc_rate_5%type;
2259: --
2260:
2261:
2262: --Trailer

Line 2364: Delete from PAY_IE_TAX_BODY_INTERFACE;

2360:
2361:
2362: Begin
2363: Delete from PAY_IE_TAX_HEADER_INTERFACE;
2364: Delete from PAY_IE_TAX_BODY_INTERFACE;
2365: Delete from PAY_IE_TAX_TRAILER_INTERFACE;
2366: if sql%rowcount > 0 then
2367: commit;
2368: end if;

Line 2626: INSERT INTO PAY_IE_TAX_BODY_INTERFACE

2622: END IF;
2623: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_5-3 '||l_CD_USC_RATE_5);
2624: --
2625:
2626: INSERT INTO PAY_IE_TAX_BODY_INTERFACE
2627: (
2628: RECORD_TYPE
2629: ,PROCESS_FLAG
2630: ,PPS_NUMBER

Line 3014: , PAY_IE_TAX_BODY_INTERFACE pbs

3010: , SUM (NVL(PBS.WK_RATE_CUTOFF,0)) sum_wk_rate_cutoff
3011: , SUM(NVL(PBS.MTH_TAX_CREDIT,0)) sum_mth_tax_credit
3012: , SUM(NVL(PBS.WK_TAX_CREDIT,0)) sum_wk_tax_credit
3013: FROM PAY_IE_TAX_HEADER_INTERFACE phs
3014: , PAY_IE_TAX_BODY_INTERFACE pbs
3015: WHERE PHS.EMPLOYER_NUMBER = PBS.EMPLOYER_NUMBER
3016: AND PHS.TAX_YEAR = p_tax_year
3017: AND PBS.EMPLOYER_NUMBER = p_employer_number;
3018:

Line 3065: UPDATE PAY_IE_TAX_BODY_INTERFACE

3061: FND_FILE.PUT_LINE(fnd_file.log,'Error occured while deleting exisiting rows in
3062: PAY_IE_TAX_ERROR table');
3063: end;
3064:
3065: UPDATE PAY_IE_TAX_BODY_INTERFACE
3066: SET EMPLOYER_NUMBER =
3067: (SELECT EMPLOYER_NUMBER
3068: FROM PAY_IE_TAX_HEADER_INTERFACE);
3069:

Line 3104: update pay_ie_tax_body_interface

3100: THEN
3101: retcode := 0;
3102: fnd_file.put_line( fnd_file.log, 'FND - CONC-COMPLETION TEXT:NORMAL');
3103:
3104: update pay_ie_tax_body_interface
3105: set process_flag = 'Y'
3106: where EMPLOYER_NUMBER = p_employer_number;
3107: Commit;
3108:

Line 3129: 'The total number of record in pay_ie_tax_body_interface is '

3125: retcode := 2;
3126: IF l_count_mth_taxcredit <> l_count_emp_recno THEN
3127: FND_FILE.NEW_LINE(fnd_file.log, 1);
3128: FND_FILE.PUT_LINE(fnd_file.log,
3129: 'The total number of record in pay_ie_tax_body_interface is '
3130: || TO_CHAR (l_count_mth_taxcredit));
3131: FND_FILE.PUT_LINE (fnd_file.log,
3132: 'The value in pay_ie_tax_trailer_interface.record_no is '
3133: || TO_CHAR(l_count_emp_recno));

Line 3135: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');

3131: FND_FILE.PUT_LINE (fnd_file.log,
3132: 'The value in pay_ie_tax_trailer_interface.record_no is '
3133: || TO_CHAR(l_count_emp_recno));
3134: FND_FILE.PUT_LINE(fnd_file.log,
3135: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
3136: FND_FILE.PUT_LINE(fnd_file.log,
3137: 'does not match the value in pay_ie_tax_trailer_interface.record_no');
3138: END IF;
3139:

Line 3143: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '

3139:
3140: IF l_sum_mth_rate_cutoff <> l_total_mth_cutoff THEN
3141: FND_FILE.NEW_LINE(fnd_file.log, 1);
3142: FND_FILE.PUT_LINE(fnd_file.log,
3143: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '
3144: || TO_CHAR (l_sum_mth_rate_cutoff));
3145: FND_FILE.PUT_LINE (fnd_file.log,
3146: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
3147: || TO_CHAR(l_total_mth_cutoff));

Line 3149: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');

3145: FND_FILE.PUT_LINE (fnd_file.log,
3146: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
3147: || TO_CHAR(l_total_mth_cutoff));
3148: FND_FILE.PUT_LINE(fnd_file.log,
3149: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
3150: FND_FILE.PUT_LINE(fnd_file.log,
3151: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');
3152: END IF;
3153: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN

Line 3156: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '

3152: END IF;
3153: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN
3154: FND_FILE.NEW_LINE(fnd_file.log, 1);
3155: FND_FILE.PUT_LINE(fnd_file.log,
3156: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '
3157: || TO_CHAR(l_sum_wk_rate_cutoff));
3158: FND_FILE.PUT_LINE(fnd_file.log,
3159: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
3160: || TO_CHAR(l_total_wk_cutoff));

Line 3162: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');

3158: FND_FILE.PUT_LINE(fnd_file.log,
3159: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
3160: || TO_CHAR(l_total_wk_cutoff));
3161: FND_FILE.PUT_LINE(fnd_file.log,
3162: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
3163: FND_FILE.PUT_LINE(fnd_file.log,
3164: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');
3165: END IF;
3166: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN

Line 3169: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '

3165: END IF;
3166: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN
3167: FND_FILE.NEW_LINE(fnd_file.log, 1);
3168: FND_FILE.PUT_LINE(fnd_file.log,
3169: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '
3170: || TO_CHAR(l_sum_mth_tax_credit));
3171: FND_FILE.PUT_LINE(fnd_file.log,
3172: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
3173: || TO_CHAR(l_total_mth_credit));

Line 3175: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');

3171: FND_FILE.PUT_LINE(fnd_file.log,
3172: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
3173: || TO_CHAR(l_total_mth_credit));
3174: FND_FILE.PUT_LINE(fnd_file.log,
3175: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
3176: FND_FILE.PUT_LINE(fnd_file.log,
3177: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');
3178: END IF;
3179: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN

Line 3182: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '

3178: END IF;
3179: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN
3180: FND_FILE.NEW_LINE(fnd_file.log, 1);
3181: FND_FILE.PUT_LINE(fnd_file.log,
3182: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '
3183: || TO_CHAR(l_sum_wk_tax_credit));
3184: FND_FILE.PUT_LINE(fnd_file.log,
3185: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
3186: || TO_CHAR(l_total_wk_credit));

Line 3188: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');

3184: FND_FILE.PUT_LINE(fnd_file.log,
3185: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
3186: || TO_CHAR(l_total_wk_credit));
3187: FND_FILE.PUT_LINE(fnd_file.log,
3188: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
3189: FND_FILE.PUT_LINE(fnd_file.log,
3190: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
3191: END IF;
3192:

Line 3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

3213: l_error_stack := errbuf;
3214: l_error := SQLERRM;
3215: retcode := 2;
3216: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
3218:
3219: INSERT INTO pay_ie_tax_error ( pps_number
3220: , employee_number
3221: , full_name

Line 3260: pay_ie_tax_body_interface tbi,

3256: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
3257: from per_all_assignments_f asg,
3258: per_all_people_f per,
3259: pay_all_payrolls_f pay,
3260: pay_ie_tax_body_interface tbi,
3261: per_periods_of_service pps
3262: where per.national_identifier = tbi.pps_number
3263: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)
3264: --AND asg.payroll_id = pay.payroll_id

Line 3281: ,pay_ie_tax_body_interface tbi

3277: group by per.person_id,per.NATIONAL_IDENTIFIER;
3278:
3279: /* Cursor check_pps(p_pps_no varchar) is
3280: Select 1 from per_all_people_f per
3281: ,pay_ie_tax_body_interface tbi
3282: Where per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3283: AND per.effective_end_date >= trunc(tbi.cert_start_date)
3284: and per.national_identifier=p_pps_no
3285: AND tbi.process_flag = 'Y'

Line 3329: , pay_ie_tax_body_interface tbi

3325: , per_all_assignments_f asg
3326: , per_all_people_f per
3327: , pay_all_payrolls_f pay
3328: --, pay_ie_paye_details_f ppd
3329: , pay_ie_tax_body_interface tbi
3330: , pay_ie_tax_header_interface thi
3331: WHERE per.person_id = asg.person_id
3332: AND per.national_identifier = tbi.pps_number
3333: AND asg.business_group_id = hou.business_group_id

Line 3395: , pay_ie_tax_body_interface tbi

3391: , per_all_assignments_f asg
3392: , per_all_people_f per
3393: , pay_all_payrolls_f pay
3394: --, pay_ie_paye_details_f ppd
3395: , pay_ie_tax_body_interface tbi
3396: , pay_ie_tax_header_interface thi,
3397: per_periods_of_service pps
3398: WHERE per.person_id = asg.person_id
3399: AND per.national_identifier = tbi.pps_number

Line 3430: select pps_number, works_number from pay_ie_tax_body_interface

3426: -- cursor get the skipped assignments. Assignments that didnt get processed
3427: -- in the process
3428: --bug 6376140 cursor modified for processing single assg
3429: /* cursor csr_skipped_asg is
3430: select pps_number, works_number from pay_ie_tax_body_interface
3431: minus
3432: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
3433: FROM hr_organization_information hoi
3434: , hr_organization_units hou

Line 3439: , pay_ie_tax_body_interface tbi

3435: , per_all_assignments_f asg
3436: , per_all_people_f per
3437: , pay_all_payrolls_f pay
3438: --, pay_ie_paye_details_f ppd
3439: , pay_ie_tax_body_interface tbi
3440: , pay_ie_tax_header_interface thi
3441: WHERE per.person_id = asg.person_id
3442: AND asg.business_group_id = hou.business_group_id
3443: AND hou.organization_id = hoi.organization_id

Line 3463: from pay_ie_tax_body_interface;

3459: AND pay.effective_end_date >= trunc(tbi.cert_start_date); */
3460:
3461: cursor csr_skipped_assignments is
3462: select distinct pps_number pps_number,works_number,last_name,first_name
3463: from pay_ie_tax_body_interface;
3464:
3465: /* check to see if any single paye details exists */
3466: cursor get_paye_details (p_assignment_id number) is
3467: select count(*) from pay_ie_paye_details_f where

Line 3556: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;

3552: l_datetrack_mode VARCHAR2(12);
3553: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372
3554: l_header_count NUMBER := 0;
3555: l_record_count NUMBER := 0;
3556: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
3557: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
3558:
3559: --Declare output parameters from api row handlersb
3560: l_ins_paye_details_id NUMBER;

Line 3557: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;

3553: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372
3554: l_header_count NUMBER := 0;
3555: l_record_count NUMBER := 0;
3556: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
3557: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
3558:
3559: --Declare output parameters from api row handlersb
3560: l_ins_paye_details_id NUMBER;
3561: l_ins_object_version_no NUMBER;

Line 3901: UPDATE pay_ie_tax_body_interface

3897: /*Update interface table and set processed flag to 'Yes' to record that record has been updated or
3898: inserted into payroll tables successfully using the row handler APIs.*/
3899:
3900: IF (p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
3901: UPDATE pay_ie_tax_body_interface
3902: SET processed_flag = 'Y'
3903: WHERE pps_number = r_pay.pps_number_int;
3904: END IF;
3905: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);

Line 4409: UPDATE pay_ie_tax_body_interface

4405: /*Update interface table and set processed flag to 'No' to record that record has not been updated
4406: or inserted into payroll tables*/
4407:
4408: IF p_validate_mode = 'IE_VALIDATE_COMMIT' THEN
4409: UPDATE pay_ie_tax_body_interface
4410: SET processed_flag = 'N'
4411: WHERE pps_number = r_pay.pps_number_int;
4412: END IF;
4413: -- The following command will be used to output the exception details to an output file: