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

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

582: l_str7 := ' ';
583:
584: --fnd_file.put_line(fnd_file.log,'wc1');
585:
586: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
587: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
588:
589: current_index := 0;
590:

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

583:
584: --fnd_file.put_line(fnd_file.log,'wc1');
585:
586: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
587: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
588:
589: current_index := 0;
590:
591: --fnd_file.put_line(fnd_file.log,'wc2');

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

591: --fnd_file.put_line(fnd_file.log,'wc2');
592:
593: IF gtagdata.count > 0 THEN
594:
595: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
596:
597: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
598:
599: l_str8 := gtagdata(table_counter).TagName;

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

603: 'REC_8001','REC_8001_END','REC_9999','REC_9999_END') THEN
604:
605: --fnd_file.put_line(fnd_file.log,'wc4');
606: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_8001','REC_9999') THEN
607: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
608: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

604:
605: --fnd_file.put_line(fnd_file.log,'wc4');
606: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_8001','REC_9999') THEN
607: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
608: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
612: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

605: --fnd_file.put_line(fnd_file.log,'wc4');
606: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_8001','REC_9999') THEN
607: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
608: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
612: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
613: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

607: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
608: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
612: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
613: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
614: END IF;
615:

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

608: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
612: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
613: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
614: END IF;
615:
616: ELSE

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

609: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
610: ELSE
611: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
612: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
613: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
614: END IF;
615:
616: ELSE
617:

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

617:
618: if l_str9 is not null then
619: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
620:
621: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

618: if l_str9 is not null then
619: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
620:
621: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

619: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9);
620:
621: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

620:
621: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
628:

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

621: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
628:
629: else

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

622: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
628:
629: else
630:

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

623: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
624: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
625: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
626: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
628:
629: else
630:
631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

627: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
628:
629: else
630:
631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

628:
629: else
630:
631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
636: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

629: else
630:
631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
636: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
637:

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

630:
631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
636: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
637:
638: end if;

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

631: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
636: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
637:
638: end if;
639:

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

632: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
633: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
634: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
635: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
636: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
637:
638: end if;
639:
640: END IF;

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

641:
642:
643: END LOOP;
644:
645: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
646:
647: ELSE
648: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
649: END IF;

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

644:
645: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
646:
647: ELSE
648: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
649: END IF;
650:
651:
652: --fnd_file.put_line(fnd_file.log,'wc5');