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

2612: l_str7 := '
2613:
2614:
2615: ';
2616: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2617: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2618: if vXMLTable.COUNT > 0 then
2619: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2620: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

2613:
2614:
2615: ';
2616: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2617: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2618: if vXMLTable.COUNT > 0 then
2619: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2620: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2621: l_str8 := vXMLTable(ctr_table).TagName;

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

2615: ';
2616: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2617: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2618: if vXMLTable.COUNT > 0 then
2619: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2620: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2621: l_str8 := vXMLTable(ctr_table).TagName;
2622: l_str9 := vXMLTable(ctr_table).TagValue;
2623: if (l_str9 is not null) then

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

2622: l_str9 := vXMLTable(ctr_table).TagValue;
2623: if (l_str9 is not null) then
2624: /* Added CDATA to handle special characters Bug No:7476344 */
2625: l_str9 := '';
2626: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

2623: if (l_str9 is not null) then
2624: /* Added CDATA to handle special characters Bug No:7476344 */
2625: l_str9 := '';
2626: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

2624: /* Added CDATA to handle special characters Bug No:7476344 */
2625: l_str9 := '';
2626: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then

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

2625: l_str9 := '';
2626: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

2626: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

2627: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2628: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

2629: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2636: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2637: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

2630: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2636: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2637: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2638: else

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

2631: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2636: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2637: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2638: else
2639: null;

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

2632: elsif (l_str9 is null and l_str8 is not null) then
2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2636: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2637: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2638: else
2639: null;
2640: end if;

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

2633: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2634: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2635: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2636: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2637: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2638: else
2639: null;
2640: end if;
2641: END LOOP;

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

2638: else
2639: null;
2640: end if;
2641: END LOOP;
2642: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2643: else
2644: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2645: end if;
2646: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

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

2640: end if;
2641: END LOOP;
2642: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2643: else
2644: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2645: end if;
2646: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2647: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2648: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

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

2642: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2643: else
2644: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2645: end if;
2646: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2647: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2648: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
2649: --return p_xfdf_blob;
2650: EXCEPTION

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

2672: begin
2673: l_buffer_len := 20000;
2674: hr_utility.set_location('Entered Procedure clob to blob',120);
2675: select userenv('LANGUAGE') into g_nls_db_char from dual;
2676: l_length_clob := dbms_lob.getlength(p_clob);
2677: l_offset := 1;
2678: while l_length_clob > 0 loop
2679: hr_utility.trace('l_length_clob '|| l_length_clob);
2680: if l_length_clob < l_buffer_len then

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

2681: l_chunk_len := l_length_clob;
2682: else
2683: l_chunk_len := l_buffer_len;
2684: end if;
2685: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2686: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2687: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2688: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
2689: 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 2692: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

2688: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
2689: 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));
2690:
2691: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2692: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2693: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2694: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2695:
2696: l_offset := l_offset + l_chunk_len;

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

2689: 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));
2690:
2691: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2692: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2693: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2694: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2695:
2696: l_offset := l_offset + l_chunk_len;
2697: l_length_clob := l_length_clob - l_chunk_len;

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

2694: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2695:
2696: l_offset := l_offset + l_chunk_len;
2697: l_length_clob := l_length_clob - l_chunk_len;
2698: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
2699: end loop;
2700: hr_utility.set_location('Finished Procedure clob to blob ',130);
2701: end clob_to_blob;
2702: