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

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

750: l_str6 := ' ';
751: l_str7 := '
752:
753: ';
754: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
755: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));
757: if vXMLTable.count > 2 then
758: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

751: l_str7 := '
752:
753: ';
754: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
755: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));
757: if vXMLTable.count > 2 then
758: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
759: --hr_utility.trace(l_str1);

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

754: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
755: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));
757: if vXMLTable.count > 2 then
758: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
759: --hr_utility.trace(l_str1);
760: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
761: l_str8 := vXMLTable(ctr_table).TagName;
762: l_str9 := vXMLTable(ctr_table).TagValue;

Line 767: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <

763:
764: IF (l_str8='L_REPORT') THEN
765:
766: IF (l_boo=1) THEN
767: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE

Line 768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name

764: IF (l_str8='L_REPORT') THEN
765:
766: IF (l_boo=1) THEN
767: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );----

Line 769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->

765:
766: IF (l_boo=1) THEN
767: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name

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

768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
775: --hr_utility.trace(l_str5||l_str8||l_str3);
776: END IF;

Line 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name

769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
775: --hr_utility.trace(l_str5||l_str8||l_str3);
776: END IF;
777: l_boo:=l_boo*(-1);

Line 774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >

770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
775: --hr_utility.trace(l_str5||l_str8||l_str3);
776: END IF;
777: l_boo:=l_boo*(-1);
778: END IF;

Line 782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <

778: END IF;
779:
780:
781: if ((l_str9 is not null)and (l_str8 not like 'L_REPORT')) then
782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value

Line 783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name

779:
780:
781: if ((l_str9 is not null)and (l_str8 not like 'L_REPORT')) then
782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );----

Line 784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->

780:
781: if ((l_str9 is not null)and (l_str8 not like 'L_REPORT')) then
782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name

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

781: if ((l_str9 is not null)and (l_str8 not like 'L_REPORT')) then
782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >

Line 786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value

782: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);

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

783: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);
791: else

Line 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name

784: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);
791: else
792: null;

Line 789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >

785: --dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);
791: else
792: null;
793: end if;

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

792: null;
793: end if;
794:
795: END LOOP;
796: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
797: --hr_utility.trace(l_str6);
798: else
799: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
800: --hr_utility.trace(l_str7);

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

795: END LOOP;
796: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
797: --hr_utility.trace(l_str6);
798: else
799: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
800: --hr_utility.trace(l_str7);
801: end if;
802: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
803: clob_to_blob(l_xfdf_string,p_xfdf_blob);

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

798: else
799: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
800: --hr_utility.trace(l_str7);
801: end if;
802: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
803: clob_to_blob(l_xfdf_string,p_xfdf_blob);
804: ----hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
805: --return p_xfdf_blob;
806: EXCEPTION

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

829:
830: begin
831: hr_utility.set_location('Entered Procedure clob to blob',120);
832: select userenv('LANGUAGE') into g_nls_db_char from dual;
833: l_length_clob := dbms_lob.getlength(p_clob);
834: l_offset := 1;
835: while l_length_clob > 0 loop
836: hr_utility.trace('l_length_clob '|| l_length_clob);
837: if l_length_clob < l_buffer_len then

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

838: l_chunk_len := l_length_clob;
839: else
840: l_chunk_len := l_buffer_len;
841: end if;
842: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
843: -- fnd_file.put_line(fnd_file.log,l_varchar_buffer);
844: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char);
845:
846: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));

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

845:
846: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
847:
848:
849: -- dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
850: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
851: --fnd_file.put_line(fnd_file.log,l_varchar_buffer);
852: l_blob_offset := l_blob_offset + l_raw_buffer_len;
853: l_offset := l_offset + l_chunk_len;

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

846: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
847:
848:
849: -- dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
850: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
851: --fnd_file.put_line(fnd_file.log,l_varchar_buffer);
852: l_blob_offset := l_blob_offset + l_raw_buffer_len;
853: l_offset := l_offset + l_chunk_len;
854: l_length_clob := l_length_clob - l_chunk_len;

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

851: --fnd_file.put_line(fnd_file.log,l_varchar_buffer);
852: l_blob_offset := l_blob_offset + l_raw_buffer_len;
853: l_offset := l_offset + l_chunk_len;
854: l_length_clob := l_length_clob - l_chunk_len;
855: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
856: end loop;
857: hr_utility.set_location('Finished Procedure clob to blob ',130);
858: end;
859: