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.PER_KW_XDO_REPORT dependencies on DBMS_LOB

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

975: l_str7 := '
976:
977:
978: ';
979: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
980: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
981: if gxmltable.count > 0 then
982: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
983: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP

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

976:
977:
978: ';
979: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
980: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
981: if gxmltable.count > 0 then
982: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
983: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP
984: l_str8 := gxmltable(ctr_table).tagName;

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

978: ';
979: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
980: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
981: if gxmltable.count > 0 then
982: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
983: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP
984: l_str8 := gxmltable(ctr_table).tagName;
985: l_str9 := gxmltable(ctr_table).tagValue;
986: IF gxmltable(ctr_table).tagName IN ('count_body_value', 'count_value') THEN

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

986: IF gxmltable(ctr_table).tagName IN ('count_body_value', 'count_value') THEN
987: l_str9 := p_tot_pg_count;
988: END IF;
989: IF (l_str9 is not null) THEN
990: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

987: l_str9 := p_tot_pg_count;
988: END IF;
989: IF (l_str9 is not null) THEN
990: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

988: END IF;
989: IF (l_str9 is not null) THEN
990: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN

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

989: IF (l_str9 is not null) THEN
990: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

990: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

991: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
992: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

993: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1000: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1001: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

994: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1000: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1001: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1002: ELSE

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

995: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1000: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1001: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1002: ELSE
1003: NULL;

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

996: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1000: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1001: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1002: ELSE
1003: NULL;
1004: END IF;

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

997: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
998: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
999: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1000: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1001: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1002: ELSE
1003: NULL;
1004: END IF;
1005: END LOOP;

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

1002: ELSE
1003: NULL;
1004: END IF;
1005: END LOOP;
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1007: ELSE
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1009: END IF;
1010: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

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

1004: END IF;
1005: END LOOP;
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1007: ELSE
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1009: END IF;
1010: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1011: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1012: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

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

1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1007: ELSE
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1009: END IF;
1010: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1011: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1012: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1013: EXCEPTION
1014: WHEN OTHERS then

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

1033:
1034: begin
1035: hr_utility.set_location('Entered Procedure clob to blob',120);
1036: select userenv('LANGUAGE') into g_nls_db_char from dual;
1037: l_length_clob := dbms_lob.getlength(p_clob);
1038: l_offset := 1;
1039: while l_length_clob > 0 loop
1040: hr_utility.trace('l_length_clob '|| l_length_clob);
1041: if l_length_clob < l_buffer_len then

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

1042: l_chunk_len := l_length_clob;
1043: else
1044: l_chunk_len := l_buffer_len;
1045: end if;
1046: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1047: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1048: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1049: 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));
1050: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

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

1047: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1048: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1049: 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));
1050: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1051: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1052: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1053: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1054:
1055: l_offset := l_offset + l_chunk_len;

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

1048: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1049: 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));
1050: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1051: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1052: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1053: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1054:
1055: l_offset := l_offset + l_chunk_len;
1056: l_length_clob := l_length_clob - l_chunk_len;

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

1053: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1054:
1055: l_offset := l_offset + l_chunk_len;
1056: l_length_clob := l_length_clob - l_chunk_len;
1057: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1058: end loop;
1059: hr_utility.set_location('Finished Procedure clob to blob ',130);
1060: end;
1061: