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_SE_EMPLOYMENT_STATISTICS dependencies on DBMS_LOB

Line 1895: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

1891: || l_iana_charset
1892: || '"?> ';
1893: l_str10 := '';
1894: l_str11 := '';
1895: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1896: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1897: current_index := 0;
1898:
1899: IF xml_tab.COUNT > 0

Line 1896: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

1892: || '"?> ';
1893: l_str10 := '';
1894: l_str11 := '';
1895: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1896: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1897: current_index := 0;
1898:
1899: IF xml_tab.COUNT > 0
1900: THEN

Line 1901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

1897: current_index := 0;
1898:
1899: IF xml_tab.COUNT > 0
1900: THEN
1901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1902:
1903: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
1904: LOOP
1905: l_str8 := xml_tab (table_counter).tagname;

Line 1917: DBMS_LOB.writeappend (l_xfdf_string

1913: THEN
1914: IF l_str9 IN
1915: ('LU_DETAILS')
1916: THEN
1917: DBMS_LOB.writeappend (l_xfdf_string
1918: , LENGTH (l_str2)
1919: , l_str2
1920: );
1921: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1921: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1917: DBMS_LOB.writeappend (l_xfdf_string
1918: , LENGTH (l_str2)
1919: , l_str2
1920: );
1921: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1922: , l_str8);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1924: , l_str3);
1925: ELSE

Line 1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1919: , l_str2
1920: );
1921: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1922: , l_str8);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1924: , l_str3);
1925: ELSE
1926: DBMS_LOB.writeappend (l_xfdf_string
1927: , LENGTH (l_str4)

Line 1926: DBMS_LOB.writeappend (l_xfdf_string

1922: , l_str8);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1924: , l_str3);
1925: ELSE
1926: DBMS_LOB.writeappend (l_xfdf_string
1927: , LENGTH (l_str4)
1928: , l_str4
1929: );
1930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1926: DBMS_LOB.writeappend (l_xfdf_string
1927: , LENGTH (l_str4)
1928: , l_str4
1929: );
1930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1931: , l_str8);
1932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1933: , l_str5);
1934: END IF;

Line 1932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1928: , l_str4
1929: );
1930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1931: , l_str8);
1932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1933: , l_str5);
1934: END IF;
1935: ELSE
1936: IF l_str9 IS NOT NULL

Line 1938: DBMS_LOB.writeappend (l_xfdf_string

1934: END IF;
1935: ELSE
1936: IF l_str9 IS NOT NULL
1937: THEN
1938: DBMS_LOB.writeappend (l_xfdf_string
1939: , LENGTH (l_str2)
1940: , l_str2
1941: );
1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1938: DBMS_LOB.writeappend (l_xfdf_string
1939: , LENGTH (l_str2)
1940: , l_str2
1941: );
1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1943: , l_str8);
1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1945: , l_str3);
1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

Line 1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1940: , l_str2
1941: );
1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1943: , l_str8);
1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1945: , l_str3);
1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1947: , l_str9);
1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1943: , l_str8);
1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1945: , l_str3);
1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1947: , l_str9);
1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1949: , l_str4);
1950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1945: , l_str3);
1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1947: , l_str9);
1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1949: , l_str4);
1950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1951: , l_str8);
1952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1947: , l_str9);
1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1949: , l_str4);
1950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1951: , l_str8);
1952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1953: , l_str5);
1954: ELSE

Line 1952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1948: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1949: , l_str4);
1950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1951: , l_str8);
1952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1953: , l_str5);
1954: ELSE
1955: DBMS_LOB.writeappend (l_xfdf_string
1956: , LENGTH (l_str2)

Line 1955: DBMS_LOB.writeappend (l_xfdf_string

1951: , l_str8);
1952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1953: , l_str5);
1954: ELSE
1955: DBMS_LOB.writeappend (l_xfdf_string
1956: , LENGTH (l_str2)
1957: , l_str2
1958: );
1959: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1959: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1955: DBMS_LOB.writeappend (l_xfdf_string
1956: , LENGTH (l_str2)
1957: , l_str2
1958: );
1959: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1960: , l_str8);
1961: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1962: , l_str3);
1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1961: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1957: , l_str2
1958: );
1959: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1960: , l_str8);
1961: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1962: , l_str3);
1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1964: , l_str4);
1965: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1959: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1960: , l_str8);
1961: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1962: , l_str3);
1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1964: , l_str4);
1965: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1966: , l_str8);
1967: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1965: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1961: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1962: , l_str3);
1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1964: , l_str4);
1965: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1966: , l_str8);
1967: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1968: , l_str5);
1969: END IF;

Line 1967: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1963: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1964: , l_str4);
1965: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1966: , l_str8);
1967: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1968: , l_str5);
1969: END IF;
1970: END IF;
1971:

Line 1974: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

1970: END IF;
1971:
1972: END LOOP;
1973:
1974: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1975: ELSE
1976: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1977: END IF;
1978:

Line 1976: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

1972: END LOOP;
1973:
1974: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1975: ELSE
1976: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1977: END IF;
1978:
1979: p_xfdf_clob := l_xfdf_string;
1980: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);