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_NL_WAGE_REPORT_PKG dependencies on HR_GENERAL

Line 1856: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));

1852: --##--Fnd_file.put_line(FND_FILE.LOG,'#######~~~~ l_flat_rate_taxation '||l_flat_rate_taxation||' ');
1853: --
1854: p_collXMLTable(y).TagName := 'TotLnLbPh'; -- 1..5
1855: p_collXMLTable(y).Mandatory:= 'Y';
1856: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));
1857: p_collXMLTable(y).Tagvalue := 0;
1858: FOR i in 1..5 LOOP
1859: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1860: + g_col_bal_def_table(i).balance_value2;

Line 1866: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));

1862: --
1863: y:= y+1;
1864: p_collXMLTable(y).TagName := 'TotLnSV'; -- 6..11
1865: p_collXMLTable(y).Mandatory:= 'Y';
1866: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));
1867: p_collXMLTable(y).Tagvalue := 0;
1868: FOR i in 6..11 LOOP
1869: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1870: + g_col_bal_def_table(i).balance_value2;

Line 1877: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));

1873: y:= y+1;
1874: p_collXMLTable(y).TagName := 'PrLnWAOAof'; --12..13
1875: p_collXMLTable(y).Mandatory:= 'Y';
1876: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1877: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
1878: ELSE
1879: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
1880: END IF;
1881: p_collXMLTable(y).Tagvalue := 0;

Line 1879: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));

1875: p_collXMLTable(y).Mandatory:= 'Y';
1876: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1877: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
1878: ELSE
1879: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
1880: END IF;
1881: p_collXMLTable(y).Tagvalue := 0;
1882: FOR i in 12..13 LOOP
1883: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 1892: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

1888: y:= y+1;
1889: p_collXMLTable(y).TagName := 'PrLnWAOAok'; -- 14..15
1890: p_collXMLTable(y).Mandatory:= 'Y';
1891: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1892: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
1893: ELSE
1894: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
1895: END IF;
1896: p_collXMLTable(y).Tagvalue:=0;

Line 1894: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

1890: p_collXMLTable(y).Mandatory:= 'Y';
1891: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1892: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
1893: ELSE
1894: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
1895: END IF;
1896: p_collXMLTable(y).Tagvalue:=0;
1897: --IF g_public_org_flag <> 'N' OR g_risk_cover_flag <> 'Y' THEN
1898: ELSE

Line 1903: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

1899: y:= y+1;
1900: p_collXMLTable(y).TagName := 'PrLnWAOAok'; -- 14..15
1901: p_collXMLTable(y).Mandatory:= 'Y';
1902: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1903: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
1904: ELSE
1905: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
1906: END IF;
1907: p_collXMLTable(y).Tagvalue:=0;

Line 1905: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

1901: p_collXMLTable(y).Mandatory:= 'Y';
1902: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
1903: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
1904: ELSE
1905: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
1906: END IF;
1907: p_collXMLTable(y).Tagvalue:=0;
1908: FOR i in 14..15 LOOP
1909: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 1918: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

1914: IF g_public_org_flag = 'N' THEN
1915: y:= y+1;
1916: p_collXMLTable(y).TagName := 'PrLnAWF'; -- 16..17
1917: p_collXMLTable(y).Mandatory:= 'Y';
1918: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
1919: p_collXMLTable(y).Tagvalue:=0;
1920: FOR i in 16..17 LOOP
1921: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1922: + g_col_bal_def_table(i).balance_value2;

Line 1928: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

1924: ELSE
1925: y:= y+1;
1926: p_collXMLTable(y).TagName := 'PrLnAWF'; -- 16..17
1927: p_collXMLTable(y).Mandatory:= 'Y';
1928: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
1929: p_collXMLTable(y).Tagvalue:=0;
1930: END IF;
1931: --
1932: --IF g_public_org_flag = 'Y' THEN

Line 1936: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));

1932: --IF g_public_org_flag = 'Y' THEN
1933: y:= y+1;
1934: p_collXMLTable(y).TagName := 'PrLnUFO'; --18..19
1935: p_collXMLTable(y).Mandatory:= 'Y';
1936: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));
1937: p_collXMLTable(y).Tagvalue:=0;
1938: FOR i in 18..19 LOOP
1939: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1940: + g_col_bal_def_table(i).balance_value2;

Line 1947: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));

1943: --
1944: y:= y+1;
1945: p_collXMLTable(y).TagName := 'TotVergZvw'; --20..27
1946: p_collXMLTable(y).Mandatory:= 'Y';
1947: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));
1948: p_collXMLTable(y).Tagvalue:=0;
1949: FOR i in 20..27 LOOP
1950: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1951: + g_col_bal_def_table(i).balance_value2;

Line 1958: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));

1954: --
1955: y:= y+1;
1956: p_collXMLTable(y).TagName := 'IngLbPh'; --28..32
1957: p_collXMLTable(y).Mandatory:= 'Y';
1958: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));
1959: p_collXMLTable(y).Tagvalue:=0;
1960: FOR i in 28..32 LOOP
1961: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1962: + g_col_bal_def_table(i).balance_value2;

Line 1977: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));

1973: --
1974: y:= y+1;
1975: p_collXMLTable(y).TagName := 'EHPubUitk'; -- 33..34
1976: p_collXMLTable(y).Mandatory:= 'N';
1977: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));
1978: p_collXMLTable(y).Tagvalue:= l_major_issue_flat_rate; -- Bug# 5754707
1979: /* FOR i in 33..34 LOOP
1980: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1981: + g_col_bal_def_table(i).balance_value2;

Line 1988: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));

1984: --
1985: y:= y+1;
1986: p_collXMLTable(y).TagName := 'EHLnBestKar'; --35..36
1987: p_collXMLTable(y).Mandatory:= 'N';
1988: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));
1989: p_collXMLTable(y).Tagvalue:=0;
1990: FOR i in 35..36 LOOP
1991: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
1992: + g_col_bal_def_table(i).balance_value2;

Line 1999: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));

1995: --
1996: y:= y+1;
1997: p_collXMLTable(y).TagName := 'EHSpLn'; -- 37..38
1998: p_collXMLTable(y).Mandatory:= 'N';
1999: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));
2000: p_collXMLTable(y).Tagvalue:=0;
2001: FOR i in 37..38 LOOP
2002: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2003: + g_col_bal_def_table(i).balance_value2;

Line 2010: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));

2006: --
2007: y:= y+1;
2008: p_collXMLTable(y).TagName := 'EHSpPr'; --39..40
2009: p_collXMLTable(y).Mandatory:= 'N';
2010: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));
2011: p_collXMLTable(y).Tagvalue:=0;
2012:
2013: IF p_effective_date < to_date('01012008','DDMMYYYY') THEN
2014: FOR i in 39..40 LOOP --Dutch Year End Changes 08 This Tag is obsolete as of 08 Wage Report

Line 2024: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));

2020: --
2021: y:= y+1;
2022: p_collXMLTable(y).TagName := 'EHLnNat'; --41-44
2023: p_collXMLTable(y).Mandatory:= 'N';
2024: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));
2025: p_collXMLTable(y).Tagvalue:= l_single_rate_exp_pay; -- Bug# 5754707
2026: /*FOR i in 41..44 LOOP
2027: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2028: + g_col_bal_def_table(i).balance_value2;

Line 2035: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));

2031: --
2032: y:= y+1;
2033: p_collXMLTable(y).TagName := 'EHFeest'; -- 45..46
2034: p_collXMLTable(y).Mandatory:= 'N';
2035: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));
2036: p_collXMLTable(y).Tagvalue:=0;
2037: p_collXMLTable(y).Tagvalue := l_flat_tax_holidays; /*** Bug 6610259 ***/
2038: /*FOR i in 45..46 LOOP
2039: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2047: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));

2043: --
2044: y:= y+1;
2045: p_collXMLTable(y).TagName := 'EHBmVerg'; --47..48
2046: p_collXMLTable(y).Mandatory:= 'N';
2047: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));
2048: p_collXMLTable(y).Tagvalue:=0;
2049: FOR i in 47..48 LOOP
2050: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2051: + g_col_bal_def_table(i).balance_value2;

Line 2059: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));

2055: IF p_effective_date >= TO_DATE('01012007','DDMMYYYY') THEN
2056: y:= y+1;
2057: p_collXMLTable(y).TagName := 'EHGebrAuto';
2058: p_collXMLTable(y).Mandatory:= 'N';
2059: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));
2060: p_collXMLTable(y).Tagvalue:= l_flat_rate_taxation;
2061: END IF;
2062: --
2063: y:= y+1;

Line 2066: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));

2062: --
2063: y:= y+1;
2064: p_collXMLTable(y).TagName := 'EHVUT'; -- 49..50
2065: p_collXMLTable(y).Mandatory:= 'N';
2066: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));
2067: p_collXMLTable(y).Tagvalue:=0;
2068: FOR i in 49..50 LOOP
2069: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2070: + g_col_bal_def_table(i).balance_value2;

Line 2078: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));

2074: IF p_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
2075: y:= y+1;
2076: p_collXMLTable(y).TagName := 'AVBetOV'; -- 51..52
2077: p_collXMLTable(y).Mandatory:= 'N';
2078: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));
2079: p_collXMLTable(y).Tagvalue:=0;
2080: FOR i in 51..52 LOOP
2081: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2082: + g_col_bal_def_table(i).balance_value2;

Line 2090: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));

2086: --
2087: y:= y+1;
2088: p_collXMLTable(y).TagName := 'AVLgdWerkl'; -- 53..54
2089: p_collXMLTable(y).Mandatory:= 'N';
2090: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));
2091: p_collXMLTable(y).Tagvalue:=0;
2092: FOR i in 53..54 LOOP
2093: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2094: + g_col_bal_def_table(i).balance_value2;

Line 2103: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));

2099: --
2100: y:= y+1;
2101: p_collXMLTable(y).TagName := 'AVArboNP'; -- 55
2102: p_collXMLTable(y).Mandatory:= 'N';
2103: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));
2104: p_collXMLTable(y).Tagvalue:=0;
2105: IF p_effective_date < to_date('01012008','DDMMYYYY') THEN
2106: p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(55).balance_value ;
2107: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;

Line 2114: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));

2110: --
2111: y:= y+1;
2112: p_collXMLTable(y).TagName := 'AVZeev'; -- 56
2113: p_collXMLTable(y).Mandatory:= 'N';
2114: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));
2115: p_collXMLTable(y).Tagvalue:=0;
2116: p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(56).balance_value ;
2117: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;
2118: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);

Line 2122: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));

2118: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);
2119: y:= y+1;
2120: p_collXMLTable(y).TagName := 'AVOnd'; -- 57..58
2121: p_collXMLTable(y).Mandatory:= 'N';
2122: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));
2123: p_collXMLTable(y).Tagvalue:=0;
2124: p_collXMLTable(y).Tagvalue:=0;
2125: FOR i in 57..58 LOOP
2126: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2139: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));

2135: --
2136: y:= y+1;
2137: p_collXMLTable(y).TagName := 'VrlAVSO'; --59
2138: p_collXMLTable(y).Mandatory:= 'N';
2139: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));
2140: p_collXMLTable(y).Tagvalue:=l_wage_tax_subsidy; -- Bug# 5754707
2141: --p_collXMLTable(y).Tagvalue:= g_col_bal_def_table(59).balance_value ; -- Bug# 5754707
2142: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue * -1;
2143: p_emp_total := p_emp_total - ROUND(p_collXMLTable(y).Tagvalue);

Line 2149: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));

2145: y:= y+1;
2146: p_collXMLTable(y).TagName := 'PrWAOAof'; -- 60..65 WAOB WGA IVA
2147: p_collXMLTable(y).Mandatory:= 'N';
2148: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2149: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
2150: ELSE
2151: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
2152: END IF;
2153: p_collXMLTable(y).Tagvalue:=0;

Line 2151: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));

2147: p_collXMLTable(y).Mandatory:= 'N';
2148: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2149: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
2150: ELSE
2151: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
2152: END IF;
2153: p_collXMLTable(y).Tagvalue:=0;
2154: FOR i in 60..65 LOOP
2155: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2165: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

2161: y:= y+1;
2162: p_collXMLTable(y).TagName := 'PrWAOAok'; -- 66..67 WAOD
2163: p_collXMLTable(y).Mandatory:= 'Y';
2164: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2165: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2166: ELSE
2167: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2168: END IF;
2169: p_collXMLTable(y).Tagvalue:=0;

Line 2167: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

2163: p_collXMLTable(y).Mandatory:= 'Y';
2164: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2165: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2166: ELSE
2167: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2168: END IF;
2169: p_collXMLTable(y).Tagvalue:=0;
2170: ELSIF g_public_org_flag = 'N' AND g_risk_cover_flag = 'Y' THEN
2171: y:= y+1;

Line 2175: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

2171: y:= y+1;
2172: p_collXMLTable(y).TagName := 'PrWAOAok'; -- 66..67 WAOD
2173: p_collXMLTable(y).Mandatory:= 'Y';
2174: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2175: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2176: ELSE
2177: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2178: END IF;
2179: p_collXMLTable(y).Tagvalue:=0;

Line 2177: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

2173: p_collXMLTable(y).Mandatory:= 'Y';
2174: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2175: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2176: ELSE
2177: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2178: END IF;
2179: p_collXMLTable(y).Tagvalue:=0;
2180: ELSE
2181: y:= y+1;

Line 2185: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

2181: y:= y+1;
2182: p_collXMLTable(y).TagName := 'PrWAOAok'; -- 66..67 WAOD
2183: p_collXMLTable(y).Mandatory:= 'N';
2184: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2185: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2186: ELSE
2187: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2188: END IF;
2189: p_collXMLTable(y).Tagvalue:=0;

Line 2187: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

2183: p_collXMLTable(y).Mandatory:= 'N';
2184: IF p_effective_date >= to_date('01012007','DDMMYYYY') THEN
2185: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
2186: ELSE
2187: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
2188: END IF;
2189: p_collXMLTable(y).Tagvalue:=0;
2190: FOR i in 66..67 LOOP
2191: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value

Line 2201: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));

2197: IF g_public_org_flag = 'N' THEN
2198: y:= y+1;
2199: p_collXMLTable(y).TagName := 'PrAWF'; -- 68..69 WEWE
2200: p_collXMLTable(y).Mandatory:= 'N';
2201: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));
2202: p_collXMLTable(y).Tagvalue:=0;
2203: FOR i in 68..69 LOOP
2204: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2205: + g_col_bal_def_table(i).balance_value2;

Line 2214: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));

2210: IF g_public_org_flag = 'Y' THEN
2211: y:= y+1;
2212: p_collXMLTable(y).TagName := 'PrUFO'; -- 70..71 UFO
2213: p_collXMLTable(y).Mandatory:= 'N';
2214: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));
2215: p_collXMLTable(y).Tagvalue:=0;
2216: FOR i in 70..71 LOOP
2217: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2218: + g_col_bal_def_table(i).balance_value2;

Line 2227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));

2223: --
2224: y:= y+1;
2225: p_collXMLTable(y).TagName := 'IngBijdrZvw'; -- 72..73 ZVW
2226: p_collXMLTable(y).Mandatory:= 'N';
2227: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));
2228: p_collXMLTable(y).Tagvalue:=0;
2229: FOR i in 72..73 LOOP
2230: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2231: + g_col_bal_def_table(i).balance_value2;

Line 2238: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));

2234: --
2235: y:= y+1;
2236: p_collXMLTable(y).TagName := 'AGHKort'; -- 74..75
2237: p_collXMLTable(y).Mandatory:= 'N';
2238: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));
2239: p_collXMLTable(y).Tagvalue:=0;
2240: FOR i in 74..75 LOOP
2241: p_collXMLTable(y).Tagvalue:= p_collXMLTable(y).Tagvalue + g_col_bal_def_table(i).balance_value
2242: + g_col_bal_def_table(i).balance_value2;

Line 2250: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));

2246: --
2247: y:= y+1;
2248: p_collXMLTable(y).TagName := 'TotTeBet';
2249: p_collXMLTable(y).Mandatory:= 'Y';
2250: p_collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));
2251: p_collXMLTable(y).Tagvalue:= p_emp_total;
2252: --
2253: --
2254: --FOR i in p_collXMLTable.first..p_collXMLTable.last LOOP

Line 3546: , p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('Saldo'))

3542: , p_action_information1 => 'CORR_BALANCE'
3543: , p_action_information2 => 'Saldo'
3544: , p_action_information3 => fnd_date.date_to_canonical(l_ret_cor_period.start_date)
3545: , p_action_information4 => fnd_date.date_to_canonical(l_ret_cor_period.End_date)
3546: , p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('Saldo'))
3547: , p_action_information6 => fnd_number.number_to_canonical(ROUND(l_corr_bal)));
3548: END LOOP;
3549: -- Employer general total
3550: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_COLLECTIVE_REPORT - TOTAL ');

Line 3566: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION

3562: ,p_action_information1 => 'TOTAL'
3563: ,p_action_information2 => 'TotGen' -- TAG NAME
3564: ,p_action_information3 => l_period_dates_rec.start_date
3565: ,p_action_information4 => l_period_dates_rec.End_date
3566: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION
3567: ,p_action_information6 => fnd_number.number_to_canonical(ROUND(l_emp_total)));
3568: ELSE
3569: --Fnd_file.put_line(FND_FILE.LOG,' ELSE (Correction Period) -- CORRECTION ');
3570: OPEN csr_payroll_get_action_id2(p_actid

Line 3858: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));

3854: --
3855: y:= 1;
3856: collXMLTable(y).TagName := 'TotLnLbPh';
3857: collXMLTable(y).Mandatory:= 'Y';
3858: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnLbPh'));
3859: collXMLTable(y).Tagvalue := 0;
3860: --
3861: y:= y+1;
3862: collXMLTable(y).TagName := 'TotLnSV';

Line 3864: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));

3860: --
3861: y:= y+1;
3862: collXMLTable(y).TagName := 'TotLnSV';
3863: collXMLTable(y).Mandatory:= 'Y';
3864: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotLnSV'));
3865: collXMLTable(y).Tagvalue := 0;
3866: --
3867: y:= y+1;
3868: collXMLTable(y).TagName := 'PrLnWAOAof';

Line 3871: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));

3867: y:= y+1;
3868: collXMLTable(y).TagName := 'PrLnWAOAof';
3869: collXMLTable(y).Mandatory:= 'Y';
3870: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
3871: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
3872: ELSE
3873: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
3874: END IF;
3875: collXMLTable(y).Tagvalue := 0;

Line 3873: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));

3869: collXMLTable(y).Mandatory:= 'Y';
3870: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
3871: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof'));
3872: ELSE
3873: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAof_2006'));
3874: END IF;
3875: collXMLTable(y).Tagvalue := 0;
3876: --
3877: y:= y+1;

Line 3881: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));

3877: y:= y+1;
3878: collXMLTable(y).TagName := 'PrLnWAOAok';
3879: collXMLTable(y).Mandatory:= 'Y';
3880: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
3881: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
3882: ELSE
3883: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
3884: END IF;
3885: collXMLTable(y).Tagvalue := 0;

Line 3883: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));

3879: collXMLTable(y).Mandatory:= 'Y';
3880: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
3881: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok'));
3882: ELSE
3883: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnWAOAok_2006'));
3884: END IF;
3885: collXMLTable(y).Tagvalue := 0;
3886: --
3887: y:= y+1;

Line 3890: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));

3886: --
3887: y:= y+1;
3888: collXMLTable(y).TagName := 'PrLnAWF';
3889: collXMLTable(y).Mandatory:= 'Y';
3890: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnAWF'));
3891: collXMLTable(y).Tagvalue := 0;
3892: --
3893: y:= y+1;
3894: collXMLTable(y).TagName := 'PrLnUFO';

Line 3896: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));

3892: --
3893: y:= y+1;
3894: collXMLTable(y).TagName := 'PrLnUFO';
3895: collXMLTable(y).Mandatory:= 'Y';
3896: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrLnUFO'));
3897: collXMLTable(y).Tagvalue := 0;
3898: --
3899: y:= y+1;
3900: collXMLTable(y).TagName := 'TotVergZvw';

Line 3902: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));

3898: --
3899: y:= y+1;
3900: collXMLTable(y).TagName := 'TotVergZvw';
3901: collXMLTable(y).Mandatory:= 'Y';
3902: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotVergZvw'));
3903: collXMLTable(y).Tagvalue := 0;
3904: --
3905: y:= y+1;
3906: collXMLTable(y).TagName := 'IngLbPh';

Line 3908: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));

3904: --
3905: y:= y+1;
3906: collXMLTable(y).TagName := 'IngLbPh';
3907: collXMLTable(y).Mandatory:= 'Y';
3908: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngLbPh'));
3909: collXMLTable(y).Tagvalue := 0;
3910: --
3911: y:= y+1;
3912: collXMLTable(y).TagName := 'EHPubUitk';

Line 3914: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));

3910: --
3911: y:= y+1;
3912: collXMLTable(y).TagName := 'EHPubUitk';
3913: collXMLTable(y).Mandatory:= 'N';
3914: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHPubUitk'));
3915: collXMLTable(y).Tagvalue := 0;
3916: --
3917: y:= y+1;
3918: collXMLTable(y).TagName := 'EHLnBestKar';

Line 3920: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));

3916: --
3917: y:= y+1;
3918: collXMLTable(y).TagName := 'EHLnBestKar';
3919: collXMLTable(y).Mandatory:= 'N';
3920: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnBestKar'));
3921: collXMLTable(y).Tagvalue := 0;
3922: --
3923: y:= y+1;
3924: collXMLTable(y).TagName := 'EHSpLn';

Line 3926: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));

3922: --
3923: y:= y+1;
3924: collXMLTable(y).TagName := 'EHSpLn';
3925: collXMLTable(y).Mandatory:= 'N';
3926: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpLn'));
3927: collXMLTable(y).Tagvalue := 0;
3928: --
3929: y:= y+1;
3930: collXMLTable(y).TagName := 'EHSpPr';

Line 3932: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));

3928: --
3929: y:= y+1;
3930: collXMLTable(y).TagName := 'EHSpPr';
3931: collXMLTable(y).Mandatory:= 'N';
3932: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHSpPr'));
3933: collXMLTable(y).Tagvalue := 0;
3934: --
3935: y:= y+1;
3936: collXMLTable(y).TagName := 'EHLnNat';

Line 3938: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));

3934: --
3935: y:= y+1;
3936: collXMLTable(y).TagName := 'EHLnNat';
3937: collXMLTable(y).Mandatory:= 'N';
3938: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHLnNat'));
3939: collXMLTable(y).Tagvalue := 0;
3940: --
3941: y:= y+1;
3942: collXMLTable(y).TagName := 'EHFeest';

Line 3944: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));

3940: --
3941: y:= y+1;
3942: collXMLTable(y).TagName := 'EHFeest';
3943: collXMLTable(y).Mandatory:= 'N';
3944: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHFeest'));
3945: collXMLTable(y).Tagvalue := 0;
3946: --
3947: y:= y+1;
3948: collXMLTable(y).TagName := 'EHBmVerg';

Line 3950: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));

3946: --
3947: y:= y+1;
3948: collXMLTable(y).TagName := 'EHBmVerg';
3949: collXMLTable(y).Mandatory:= 'N';
3950: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHBmVerg'));
3951: collXMLTable(y).Tagvalue := 0;
3952: --
3953: y:= y+1; -- new added
3954: collXMLTable(y).TagName := 'EHGebrAuto';

Line 3956: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));

3952: --
3953: y:= y+1; -- new added
3954: collXMLTable(y).TagName := 'EHGebrAuto';
3955: collXMLTable(y).Mandatory:= 'N';
3956: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHGebrAuto'));
3957: collXMLTable(y).Tagvalue := 0;
3958: --
3959: y:= y+1;
3960: collXMLTable(y).TagName := 'EHVUT';

Line 3962: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));

3958: --
3959: y:= y+1;
3960: collXMLTable(y).TagName := 'EHVUT';
3961: collXMLTable(y).Mandatory:= 'N';
3962: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('EHVUT'));
3963: collXMLTable(y).Tagvalue := 0;
3964: --
3965: y:= y+1;
3966: collXMLTable(y).TagName := 'AVBetOV';

Line 3968: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));

3964: --
3965: y:= y+1;
3966: collXMLTable(y).TagName := 'AVBetOV';
3967: collXMLTable(y).Mandatory:= 'N';
3968: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVBetOV'));
3969: collXMLTable(y).Tagvalue := 0;
3970: --
3971: y:= y+1;
3972: collXMLTable(y).TagName := 'AVLgdWerkl';

Line 3974: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));

3970: --
3971: y:= y+1;
3972: collXMLTable(y).TagName := 'AVLgdWerkl';
3973: collXMLTable(y).Mandatory:= 'N';
3974: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVLgdWerkl'));
3975: collXMLTable(y).Tagvalue := 0;
3976: --
3977: y:= y+1;
3978: collXMLTable(y).TagName := 'AVArboNP';

Line 3980: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));

3976: --
3977: y:= y+1;
3978: collXMLTable(y).TagName := 'AVArboNP';
3979: collXMLTable(y).Mandatory:= 'N';
3980: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVArboNP'));
3981: collXMLTable(y).Tagvalue := 0;
3982: --
3983: y:= y+1;
3984: collXMLTable(y).TagName := 'AVZeev';

Line 3986: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));

3982: --
3983: y:= y+1;
3984: collXMLTable(y).TagName := 'AVZeev';
3985: collXMLTable(y).Mandatory:= 'N';
3986: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVZeev'));
3987: collXMLTable(y).Tagvalue := 0;
3988: --
3989: y:= y+1;
3990: collXMLTable(y).TagName := 'AVOnd';

Line 3992: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));

3988: --
3989: y:= y+1;
3990: collXMLTable(y).TagName := 'AVOnd';
3991: collXMLTable(y).Mandatory:= 'N';
3992: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AVOnd'));
3993: collXMLTable(y).Tagvalue := 0;
3994: --
3995: y:= y+1;
3996: collXMLTable(y).TagName := 'VrlAVSO';

Line 3998: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));

3994: --
3995: y:= y+1;
3996: collXMLTable(y).TagName := 'VrlAVSO';
3997: collXMLTable(y).Mandatory:= 'N';
3998: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('VrlAVSO'));
3999: collXMLTable(y).Tagvalue := 0;
4000: --
4001: y:= y+1;
4002: collXMLTable(y).TagName := 'PrWAOAof';

Line 4005: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));

4001: y:= y+1;
4002: collXMLTable(y).TagName := 'PrWAOAof';
4003: collXMLTable(y).Mandatory:= 'N';
4004: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
4005: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
4006: ELSE
4007: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
4008: END IF;
4009: collXMLTable(y).Tagvalue := 0;

Line 4007: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));

4003: collXMLTable(y).Mandatory:= 'N';
4004: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
4005: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof'));
4006: ELSE
4007: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAof_2006'));
4008: END IF;
4009: collXMLTable(y).Tagvalue := 0;
4010: --
4011: y:= y+1;

Line 4015: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));

4011: y:= y+1;
4012: collXMLTable(y).TagName := 'PrWAOAok';
4013: collXMLTable(y).Mandatory:= 'Y';
4014: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
4015: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
4016: ELSE
4017: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
4018: END IF;
4019: collXMLTable(y).Tagvalue := 0;

Line 4017: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));

4013: collXMLTable(y).Mandatory:= 'Y';
4014: IF l_end_date >= to_date('01012007','DDMMYYYY') THEN
4015: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok'));
4016: ELSE
4017: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrWAOAok_2006'));
4018: END IF;
4019: collXMLTable(y).Tagvalue := 0;
4020: --
4021: y:= y+1;

Line 4024: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));

4020: --
4021: y:= y+1;
4022: collXMLTable(y).TagName := 'PrAWF';
4023: collXMLTable(y).Mandatory:= 'N';
4024: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrAWF'));
4025: collXMLTable(y).Tagvalue := 0;
4026: --
4027: y:= y+1;
4028: collXMLTable(y).TagName := 'PrUFO';

Line 4030: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));

4026: --
4027: y:= y+1;
4028: collXMLTable(y).TagName := 'PrUFO';
4029: collXMLTable(y).Mandatory:= 'N';
4030: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('PrUFO'));
4031: collXMLTable(y).Tagvalue := 0;
4032: --
4033: y:= y+1;
4034: collXMLTable(y).TagName := 'IngBijdrZvw';

Line 4036: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));

4032: --
4033: y:= y+1;
4034: collXMLTable(y).TagName := 'IngBijdrZvw';
4035: collXMLTable(y).Mandatory:= 'N';
4036: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('IngBijdrZvw'));
4037: collXMLTable(y).Tagvalue := 0;
4038: --
4039: y:= y+1;
4040: collXMLTable(y).TagName := 'AGHKort';

Line 4042: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));

4038: --
4039: y:= y+1;
4040: collXMLTable(y).TagName := 'AGHKort';
4041: collXMLTable(y).Mandatory:= 'N';
4042: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('AGHKort'));
4043: collXMLTable(y).Tagvalue := 0;
4044: --
4045: y:= y+1;
4046: collXMLTable(y).TagName := 'TotTeBet';

Line 4048: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));

4044: --
4045: y:= y+1;
4046: collXMLTable(y).TagName := 'TotTeBet';
4047: collXMLTable(y).Mandatory:= 'Y';
4048: collXMLTable(y).TagDesc := HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotTeBet'));
4049: collXMLTable(y).Tagvalue := 0;
4050: --
4051: END IF;
4052: --

Line 4224: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION

4220: ,p_action_information1 => 'TOTAL'
4221: ,p_action_information2 => 'TotGen' -- TAG NAME
4222: ,p_action_information3 => fnd_date.date_to_canonical(l_start_date)
4223: ,p_action_information4 => fnd_date.date_to_canonical(l_end_date)
4224: ,p_action_information5 => HR_GENERAL.decode_lookup('NL_FORM_LABELS',UPPER('TotGen')) -- TAG DESCRIPTION
4225: ,p_action_information6 => fnd_number.number_to_canonical(ROUND(l_emp_total)));
4226: --
4227: END IF;
4228: --# Exception Report

Line 4229: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));

4225: ,p_action_information6 => fnd_number.number_to_canonical(ROUND(l_emp_total)));
4226: --
4227: END IF;
4228: --# Exception Report
4229: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
4230: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
4231: --
4232: FOR csr_excpetion_rec IN csr_get_PA_exception_info(p_actid) LOOP
4233: --

Line 4239: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||

4235: --
4236: IF empr_flag = 'N' THEN
4237: --
4238: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4239: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4240: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4241: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4242: empr_flag :='Y';
4243: END IF;

Line 4240: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));

4236: IF empr_flag = 'N' THEN
4237: --
4238: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4239: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4240: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4241: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4242: empr_flag :='Y';
4243: END IF;
4244: --

Line 4256: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||

4252: --
4253: IF empe_flag = 'N' THEN
4254: --
4255: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4256: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4257: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
4258: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
4259: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4260: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

Line 4257: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||

4253: IF empe_flag = 'N' THEN
4254: --
4255: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4256: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4257: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
4258: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
4259: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4260: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4261: empe_flag := 'Y';

Line 4258: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||

4254: --
4255: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4256: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4257: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
4258: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
4259: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4260: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4261: empe_flag := 'Y';
4262: END IF;

Line 4259: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));

4255: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4256: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4257: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),32,' ') ||
4258: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_DATE'),13,' ') ||
4259: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4260: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4261: empe_flag := 'Y';
4262: END IF;
4263: --

Line 4269: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));

4265: --
4266: END LOOP;
4267: --
4268: IF l_exception_flag = 'N' THEN
4269: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));
4270: END IF;
4271: --Fnd_file.put_line(FND_FILE.LOG,' Leaving Deinit Code');
4272: --#
4273: EXCEPTION

Line 9014: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);

9010: FETCH csr_chk_exception INTO l_exception;
9011: CLOSE csr_chk_exception;
9012: --
9013: l_return_string := rpad(fnd_date.date_to_displaydate(l_start_date),15)||'- '||rpad(fnd_date.date_to_displaydate(l_end_date),15);
9014: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);
9015: l_return_string := l_return_string ||'- '||rpad(l_tax_rep_name,40);
9016: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);
9017: --
9018: RETURN(l_return_string);

Line 9016: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);

9012: --
9013: l_return_string := rpad(fnd_date.date_to_displaydate(l_start_date),15)||'- '||rpad(fnd_date.date_to_displaydate(l_end_date),15);
9014: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_WR_PERIOD_TYPE',l_payroll_type),40);
9015: l_return_string := l_return_string ||'- '||rpad(l_tax_rep_name,40);
9016: l_return_string := l_return_string ||'- '||rpad(HR_GENERAL.decode_lookup('NL_FORM_LABELS',l_exception),25);
9017: --
9018: RETURN(l_return_string);
9019: --
9020: END get_archive_details;