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 1934: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

1930: || l_iana_charset
1931: || '"?> ';
1932: l_str10 := '';
1933: l_str11 := '';
1934: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1935: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1936: current_index := 0;
1937:
1938: IF xml_tab.COUNT > 0

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

1931: || '"?> ';
1932: l_str10 := '';
1933: l_str11 := '';
1934: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1935: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1936: current_index := 0;
1937:
1938: IF xml_tab.COUNT > 0
1939: THEN

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

1936: current_index := 0;
1937:
1938: IF xml_tab.COUNT > 0
1939: THEN
1940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1941:
1942: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
1943: LOOP
1944: l_str8 := xml_tab (table_counter).tagname;

Line 1958: DBMS_LOB.writeappend (l_xfdf_string

1954: THEN
1955: IF l_str9 IN
1956: ('SSST_DETAILS')
1957: THEN
1958: DBMS_LOB.writeappend (l_xfdf_string
1959: , LENGTH (l_str2)
1960: , l_str2
1961: );
1962: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

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

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

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

Line 1967: DBMS_LOB.writeappend (l_xfdf_string

1963: , l_str8);
1964: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1965: , l_str3);
1966: ELSE
1967: DBMS_LOB.writeappend (l_xfdf_string
1968: , LENGTH (l_str4)
1969: , l_str4
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_str4)
1969: , l_str4
1970: );
1971: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1972: , l_str8);
1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1974: , l_str5);
1975: END IF;

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

1969: , l_str4
1970: );
1971: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1972: , l_str8);
1973: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1974: , l_str5);
1975: END IF;
1976: ELSE
1977: IF l_str9 IS NOT NULL

Line 1979: DBMS_LOB.writeappend (l_xfdf_string

1975: END IF;
1976: ELSE
1977: IF l_str9 IS NOT NULL
1978: THEN
1979: DBMS_LOB.writeappend (l_xfdf_string
1980: , LENGTH (l_str2)
1981: , l_str2
1982: );
1983: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1979: DBMS_LOB.writeappend (l_xfdf_string
1980: , LENGTH (l_str2)
1981: , l_str2
1982: );
1983: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1984: , l_str8);
1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1986: , l_str3);
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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

1981: , l_str2
1982: );
1983: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1984: , l_str8);
1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1986: , l_str3);
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1988: , l_str9);
1989: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1983: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1984: , l_str8);
1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1986: , l_str3);
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1988: , l_str9);
1989: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1990: , l_str4);
1991: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1985: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1986: , l_str3);
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1988: , l_str9);
1989: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1990: , l_str4);
1991: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1992: , l_str8);
1993: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1988: , l_str9);
1989: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1990: , l_str4);
1991: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1992: , l_str8);
1993: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1994: , l_str5);
1995: ELSE

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

1989: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1990: , l_str4);
1991: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1992: , l_str8);
1993: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1994: , l_str5);
1995: ELSE
1996: DBMS_LOB.writeappend (l_xfdf_string
1997: , LENGTH (l_str2)

Line 1996: DBMS_LOB.writeappend (l_xfdf_string

1992: , l_str8);
1993: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1994: , l_str5);
1995: ELSE
1996: DBMS_LOB.writeappend (l_xfdf_string
1997: , LENGTH (l_str2)
1998: , l_str2
1999: );
2000: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1996: DBMS_LOB.writeappend (l_xfdf_string
1997: , LENGTH (l_str2)
1998: , l_str2
1999: );
2000: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2001: , l_str8);
2002: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2003: , l_str3);
2004: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1998: , l_str2
1999: );
2000: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2001: , l_str8);
2002: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2003: , l_str3);
2004: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2005: , l_str4);
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2000: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2001: , l_str8);
2002: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2003: , l_str3);
2004: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2005: , l_str4);
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2007: , l_str8);
2008: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

2002: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2003: , l_str3);
2004: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2005: , l_str4);
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2007: , l_str8);
2008: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2009: , l_str5);
2010: END IF;

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

2004: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2005: , l_str4);
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2007: , l_str8);
2008: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2009: , l_str5);
2010: END IF;
2011: END IF;
2012: END LOOP;

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

2010: END IF;
2011: END IF;
2012: END LOOP;
2013:
2014: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
2015: ELSE
2016: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2017: END IF;
2018: p_xfdf_clob := l_xfdf_string;

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

2012: END LOOP;
2013:
2014: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
2015: ELSE
2016: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2017: END IF;
2018: p_xfdf_clob := l_xfdf_string;
2019: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2020: EXCEPTION