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

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

1901: || l_iana_charset
1902: || '"?> ';
1903: l_str10 := '';
1904: l_str11 := '';
1905: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1906: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1907: current_index := 0;
1908:
1909: IF xml_tab.COUNT > 0

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

1902: || '"?> ';
1903: l_str10 := '';
1904: l_str11 := '';
1905: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1906: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1907: current_index := 0;
1908:
1909: IF xml_tab.COUNT > 0
1910: THEN

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

1907: current_index := 0;
1908:
1909: IF xml_tab.COUNT > 0
1910: THEN
1911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1912:
1913: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
1914: LOOP
1915: l_str8 := xml_tab (table_counter).tagname;

Line 1929: DBMS_LOB.writeappend (l_xfdf_string

1925: THEN
1926: IF l_str9 IN
1927: ('SSST_DETAILS')
1928: THEN
1929: DBMS_LOB.writeappend (l_xfdf_string
1930: , LENGTH (l_str2)
1931: , l_str2
1932: );
1933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1929: DBMS_LOB.writeappend (l_xfdf_string
1930: , LENGTH (l_str2)
1931: , l_str2
1932: );
1933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1934: , l_str8);
1935: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1936: , l_str3);
1937: ELSE

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

1931: , l_str2
1932: );
1933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1934: , l_str8);
1935: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1936: , l_str3);
1937: ELSE
1938: DBMS_LOB.writeappend (l_xfdf_string
1939: , LENGTH (l_str4)

Line 1938: DBMS_LOB.writeappend (l_xfdf_string

1934: , l_str8);
1935: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1936: , l_str3);
1937: ELSE
1938: DBMS_LOB.writeappend (l_xfdf_string
1939: , LENGTH (l_str4)
1940: , l_str4
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_str4)
1940: , l_str4
1941: );
1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1943: , l_str8);
1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1945: , l_str5);
1946: END IF;

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

1940: , l_str4
1941: );
1942: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1943: , l_str8);
1944: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1945: , l_str5);
1946: END IF;
1947: ELSE
1948: IF l_str9 IS NOT NULL

Line 1950: DBMS_LOB.writeappend (l_xfdf_string

1946: END IF;
1947: ELSE
1948: IF l_str9 IS NOT NULL
1949: THEN
1950: DBMS_LOB.writeappend (l_xfdf_string
1951: , LENGTH (l_str2)
1952: , l_str2
1953: );
1954: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1950: DBMS_LOB.writeappend (l_xfdf_string
1951: , LENGTH (l_str2)
1952: , l_str2
1953: );
1954: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1955: , l_str8);
1956: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1957: , l_str3);
1958: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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

1952: , l_str2
1953: );
1954: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1955: , l_str8);
1956: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1957: , l_str3);
1958: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1959: , l_str9);
1960: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

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

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

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

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

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

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

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

Line 1967: DBMS_LOB.writeappend (l_xfdf_string

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

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

1967: DBMS_LOB.writeappend (l_xfdf_string
1968: , LENGTH (l_str2)
1969: , l_str2
1970: );
1971: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1972: , l_str8);
1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1974: , l_str3);
1975: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1969: , l_str2
1970: );
1971: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1972: , l_str8);
1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1974: , l_str3);
1975: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1976: , l_str4);
1977: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1971: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1972: , l_str8);
1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1974: , l_str3);
1975: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1976: , l_str4);
1977: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1978: , l_str8);
1979: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1974: , l_str3);
1975: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1976: , l_str4);
1977: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1978: , l_str8);
1979: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1980: , l_str5);
1981: END IF;

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

1975: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1976: , l_str4);
1977: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1978: , l_str8);
1979: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1980: , l_str5);
1981: END IF;
1982: END IF;
1983: END LOOP;

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

1981: END IF;
1982: END IF;
1983: END LOOP;
1984:
1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1986: ELSE
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1988: END IF;
1989: p_xfdf_clob := l_xfdf_string;

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

1983: END LOOP;
1984:
1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1986: ELSE
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1988: END IF;
1989: p_xfdf_clob := l_xfdf_string;
1990: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1991: EXCEPTION