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

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

2459: l_str7 := '
2460:
2461:
2462: ';
2463: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2464: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2465: if vXMLTable.COUNT > 0 then
2466: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2467: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 2464: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

2460:
2461:
2462: ';
2463: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2464: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2465: if vXMLTable.COUNT > 0 then
2466: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2467: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2468: l_str8 := vXMLTable(ctr_table).TagName;

Line 2466: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

2462: ';
2463: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2464: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2465: if vXMLTable.COUNT > 0 then
2466: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2467: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2468: l_str8 := vXMLTable(ctr_table).TagName;
2469: l_str9 := vXMLTable(ctr_table).TagValue;
2470: if (l_str9 is not null) then

Line 2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

2467: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2468: l_str8 := vXMLTable(ctr_table).TagName;
2469: l_str9 := vXMLTable(ctr_table).TagValue;
2470: if (l_str9 is not null) then
2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

2468: l_str8 := vXMLTable(ctr_table).TagName;
2469: l_str9 := vXMLTable(ctr_table).TagValue;
2470: if (l_str9 is not null) then
2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

2469: l_str9 := vXMLTable(ctr_table).TagValue;
2470: if (l_str9 is not null) then
2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then

Line 2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

2470: if (l_str9 is not null) then
2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

2471: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

2472: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2473: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

2474: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

2475: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2483: else

Line 2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

2476: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2483: else
2484: null;

Line 2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

2477: elsif (l_str9 is null and l_str8 is not null) then
2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2483: else
2484: null;
2485: end if;

Line 2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

2478: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2479: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2480: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2481: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2482: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2483: else
2484: null;
2485: end if;
2486: END LOOP;

Line 2487: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

2483: else
2484: null;
2485: end if;
2486: END LOOP;
2487: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2488: else
2489: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2490: end if;
2491: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 2489: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

2485: end if;
2486: END LOOP;
2487: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2488: else
2489: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2490: end if;
2491: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2492: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2493: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 2491: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

2487: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2488: else
2489: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2490: end if;
2491: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2492: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2493: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
2494: --return p_xfdf_blob;
2495: EXCEPTION

Line 2521: l_length_clob := dbms_lob.getlength(p_clob);

2517: begin
2518: l_buffer_len := 20000;
2519: hr_utility.set_location('Entered Procedure clob to blob',120);
2520: select userenv('LANGUAGE') into g_nls_db_char from dual;
2521: l_length_clob := dbms_lob.getlength(p_clob);
2522: l_offset := 1;
2523: while l_length_clob > 0 loop
2524: hr_utility.trace('l_length_clob '|| l_length_clob);
2525: if l_length_clob < l_buffer_len then

Line 2530: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

2526: l_chunk_len := l_length_clob;
2527: else
2528: l_chunk_len := l_buffer_len;
2529: end if;
2530: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2531: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2532: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2533: /*fnd_file.put_line(fnd_file.log,l_varchar_buffer);*/
2534: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));

Line 2537: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

2533: /*fnd_file.put_line(fnd_file.log,l_varchar_buffer);*/
2534: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
2535:
2536: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2537: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2538: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2539: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2540:
2541: l_offset := l_offset + l_chunk_len;

Line 2538: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

2534: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
2535:
2536: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2537: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2538: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2539: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2540:
2541: l_offset := l_offset + l_chunk_len;
2542: l_length_clob := l_length_clob - l_chunk_len;

Line 2543: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

2539: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2540:
2541: l_offset := l_offset + l_chunk_len;
2542: l_length_clob := l_length_clob - l_chunk_len;
2543: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
2544: end loop;
2545: hr_utility.set_location('Finished Procedure clob to blob ',130);
2546: end clob_to_blob;
2547: