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

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

1909: || l_iana_charset
1910: || '"?> ';
1911: l_str10 := NULL;
1912: l_str11 := '';
1913: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1914: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1915: current_index := 0;
1916:
1917: --logger('CLOB CLOB +== > ','In CLOB');

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

1910: || '"?> ';
1911: l_str10 := NULL;
1912: l_str11 := '';
1913: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1914: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1915: current_index := 0;
1916:
1917: --logger('CLOB CLOB +== > ','In CLOB');
1918: --logger('str1111 +== > ',l_str1);

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

1918: --logger('str1111 +== > ',l_str1);
1919: --logger('str1111 +== > ',l_str_1);
1920: IF ghpd_data.COUNT > 0
1921: THEN
1922: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1924: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1925: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1926: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST

Line 1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);

1919: --logger('str1111 +== > ',l_str_1);
1920: IF ghpd_data.COUNT > 0
1921: THEN
1922: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1924: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1925: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1926: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1927: LOOP

Line 1924: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);

1920: IF ghpd_data.COUNT > 0
1921: THEN
1922: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1924: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1925: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1926: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1927: LOOP
1928: l_str8 := ghpd_data (table_counter).tagname;

Line 1925: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);

1921: THEN
1922: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1923: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1924: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1925: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1926: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1927: LOOP
1928: l_str8 := ghpd_data (table_counter).tagname;
1929: l_str9 := ghpd_data (table_counter).tagvalue;

Line 1987: DBMS_LOB.writeappend (l_xfdf_string

1983: ,'LoneandringHandelse' -- The keyword grassnitt is removed 2008/2009
1984: ,'NyanmalanHandelse' -- The keyword grassnitt is removed 2008/2009
1985: )
1986: THEN
1987: DBMS_LOB.writeappend (l_xfdf_string
1988: ,LENGTH (l_str2)
1989: ,l_str2
1990: );
1991: DBMS_LOB.writeappend (l_xfdf_string

Line 1991: DBMS_LOB.writeappend (l_xfdf_string

1987: DBMS_LOB.writeappend (l_xfdf_string
1988: ,LENGTH (l_str2)
1989: ,l_str2
1990: );
1991: DBMS_LOB.writeappend (l_xfdf_string
1992: ,LENGTH (l_str8)
1993: ,l_str8
1994: );
1995: --logger('Adding +== > ','Attribute');

Line 1998: DBMS_LOB.writeappend (l_xfdf_string

1994: );
1995: --logger('Adding +== > ','Attribute');
1996: --logger('Adding l_str10 +== > ', l_str10);
1997: -- Add attribute column
1998: DBMS_LOB.writeappend (l_xfdf_string
1999: ,LENGTH (' Handelsenummer="')
2000: ,' Handelsenummer="'
2001: );
2002: DBMS_LOB.writeappend (l_xfdf_string

Line 2002: DBMS_LOB.writeappend (l_xfdf_string

1998: DBMS_LOB.writeappend (l_xfdf_string
1999: ,LENGTH (' Handelsenummer="')
2000: ,' Handelsenummer="'
2001: );
2002: DBMS_LOB.writeappend (l_xfdf_string
2003: ,LENGTH (l_str10)
2004: ,l_str10
2005: );
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');

Line 2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');

2002: DBMS_LOB.writeappend (l_xfdf_string
2003: ,LENGTH (l_str10)
2004: ,l_str10
2005: );
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');
2007: -- END of attribute addition
2008: DBMS_LOB.writeappend (l_xfdf_string
2009: ,LENGTH (l_str3)
2010: ,l_str3

Line 2008: DBMS_LOB.writeappend (l_xfdf_string

2004: ,l_str10
2005: );
2006: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');
2007: -- END of attribute addition
2008: DBMS_LOB.writeappend (l_xfdf_string
2009: ,LENGTH (l_str3)
2010: ,l_str3
2011: );
2012: ELSE

Line 2013: DBMS_LOB.writeappend (l_xfdf_string

2009: ,LENGTH (l_str3)
2010: ,l_str3
2011: );
2012: ELSE
2013: DBMS_LOB.writeappend (l_xfdf_string
2014: ,LENGTH (l_str2)
2015: ,l_str2
2016: );
2017: DBMS_LOB.writeappend (l_xfdf_string

Line 2017: DBMS_LOB.writeappend (l_xfdf_string

2013: DBMS_LOB.writeappend (l_xfdf_string
2014: ,LENGTH (l_str2)
2015: ,l_str2
2016: );
2017: DBMS_LOB.writeappend (l_xfdf_string
2018: ,LENGTH (l_str8)
2019: ,l_str8
2020: );
2021: DBMS_LOB.writeappend (l_xfdf_string

Line 2021: DBMS_LOB.writeappend (l_xfdf_string

2017: DBMS_LOB.writeappend (l_xfdf_string
2018: ,LENGTH (l_str8)
2019: ,l_str8
2020: );
2021: DBMS_LOB.writeappend (l_xfdf_string
2022: ,LENGTH (l_str3)
2023: ,l_str3
2024: );
2025: END IF;

Line 2027: DBMS_LOB.writeappend (l_xfdf_string

2023: ,l_str3
2024: );
2025: END IF;
2026: ELSE
2027: DBMS_LOB.writeappend (l_xfdf_string
2028: ,LENGTH (l_str4)
2029: ,l_str4
2030: );
2031: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2027: DBMS_LOB.writeappend (l_xfdf_string
2028: ,LENGTH (l_str4)
2029: ,l_str4
2030: );
2031: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2032: ,l_str8);
2033: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2034: ,l_str5);
2035: END IF;

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

2029: ,l_str4
2030: );
2031: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2032: ,l_str8);
2033: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2034: ,l_str5);
2035: END IF;
2036: ELSE
2037: IF l_str9 IS NOT NULL

Line 2039: DBMS_LOB.writeappend (l_xfdf_string

2035: END IF;
2036: ELSE
2037: IF l_str9 IS NOT NULL
2038: THEN
2039: DBMS_LOB.writeappend (l_xfdf_string
2040: ,LENGTH (l_str2)
2041: ,l_str2
2042: );
2043: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2039: DBMS_LOB.writeappend (l_xfdf_string
2040: ,LENGTH (l_str2)
2041: ,l_str2
2042: );
2043: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2044: ,l_str8);
2045: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2046: ,l_str3);
2047: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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

2041: ,l_str2
2042: );
2043: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2044: ,l_str8);
2045: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2046: ,l_str3);
2047: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
2048: ,l_str9);
2049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

2043: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2044: ,l_str8);
2045: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2046: ,l_str3);
2047: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
2048: ,l_str9);
2049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2050: ,l_str4);
2051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2045: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2046: ,l_str3);
2047: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
2048: ,l_str9);
2049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2050: ,l_str4);
2051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2052: ,l_str8);
2053: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

2047: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
2048: ,l_str9);
2049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2050: ,l_str4);
2051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2052: ,l_str8);
2053: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2054: ,l_str5);
2055: ELSE

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

2049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2050: ,l_str4);
2051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2052: ,l_str8);
2053: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2054: ,l_str5);
2055: ELSE
2056: DBMS_LOB.writeappend (l_xfdf_string
2057: ,LENGTH (l_str2)

Line 2056: DBMS_LOB.writeappend (l_xfdf_string

2052: ,l_str8);
2053: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2054: ,l_str5);
2055: ELSE
2056: DBMS_LOB.writeappend (l_xfdf_string
2057: ,LENGTH (l_str2)
2058: ,l_str2
2059: );
2060: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2056: DBMS_LOB.writeappend (l_xfdf_string
2057: ,LENGTH (l_str2)
2058: ,l_str2
2059: );
2060: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2061: ,l_str8);
2062: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2063: ,l_str3);
2064: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

2058: ,l_str2
2059: );
2060: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2061: ,l_str8);
2062: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2063: ,l_str3);
2064: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2065: ,l_str4);
2066: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

2060: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2061: ,l_str8);
2062: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2063: ,l_str3);
2064: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2065: ,l_str4);
2066: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2067: ,l_str8);
2068: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

2062: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
2063: ,l_str3);
2064: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2065: ,l_str4);
2066: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2067: ,l_str8);
2068: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2069: ,l_str5);
2070: END IF;

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

2064: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
2065: ,l_str4);
2066: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
2067: ,l_str8);
2068: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
2069: ,l_str5);
2070: END IF;
2071: END IF;
2072: END LOOP;

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

2070: END IF;
2071: END IF;
2072: END LOOP;
2073:
2074: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
2075: ELSE
2076: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2077: END IF;
2078:

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

2072: END LOOP;
2073:
2074: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
2075: ELSE
2076: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2077: END IF;
2078:
2079: p_xfdf_clob := l_xfdf_string;
2080: hr_utility.set_location ('Leaving WritetoCLOB ', 40);