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

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

788: l_str7 := ' ';
789:
790: --fnd_file.put_line(fnd_file.log,'wc1');
791:
792: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
793: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
794:
795: current_index := 0;
796:

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

789:
790: --fnd_file.put_line(fnd_file.log,'wc1');
791:
792: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
793: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
794:
795: current_index := 0;
796:
797: --fnd_file.put_line(fnd_file.log,'wc2');

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

797: --fnd_file.put_line(fnd_file.log,'wc2');
798:
799: IF gtagdata.count > 0 THEN
800:
801: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
802:
803: --fnd_file.put_line(fnd_file.log,'wc3');
804: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
805:

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

811: 'REC_6004','REC_6004_END','REC_6005','REC_6005_END','REC_9999','REC_9999_END') THEN
812:
813: --fnd_file.put_line(fnd_file.log,'wc4');
814: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_5000','REC_6000','REC_6001','REC_6002','REC_6004','REC_6005','REC_9999') THEN
815: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

812:
813: --fnd_file.put_line(fnd_file.log,'wc4');
814: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_5000','REC_6000','REC_6001','REC_6002','REC_6004','REC_6005','REC_9999') THEN
815: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
820: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

813: --fnd_file.put_line(fnd_file.log,'wc4');
814: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_5000','REC_6000','REC_6001','REC_6002','REC_6004','REC_6005','REC_9999') THEN
815: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
820: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
821: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

815: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
820: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
821: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
822: END IF;
823:

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

816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
820: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
821: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
822: END IF;
823:
824: ELSE

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

817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
818: ELSE
819: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
820: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
821: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
822: END IF;
823:
824: ELSE
825:

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

825:
826: if l_str9 is not null then
827: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
828:
829: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

826: if l_str9 is not null then
827: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
828:
829: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

827: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
828:
829: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

828:
829: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else

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

829: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else
837:

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

830: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else
837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

831: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
832: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
833: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else
837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

834: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else
837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

835: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
836: else
837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
843: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

836: else
837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
843: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
844:

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

837:
838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
843: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
844:
845: end if;

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

838: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
843: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
844:
845: end if;
846:

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

839: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
840: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
841: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
842: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
843: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
844:
845: end if;
846:
847: END IF;

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

848:
849:
850: END LOOP;
851:
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
853:
854: ELSE
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
856: END IF;

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

851:
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
853:
854: ELSE
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
856: END IF;
857:
858:
859: --fnd_file.put_line(fnd_file.log,'wc5');