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

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

712: l_str6 := '';
713: l_str7 := ' ';
714:
715:
716: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
717: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
718:
719: current_index := 0;
720:

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

713: l_str7 := ' ';
714:
715:
716: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
717: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
718:
719: current_index := 0;
720:
721: IF gtagdata.count > 0 THEN

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

719: current_index := 0;
720:
721: IF gtagdata.count > 0 THEN
722:
723: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
724:
725:
726: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
727:

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

728: l_str8 := gtagdata(table_counter).TagName;
729: l_str9 := '';
730:
731: if l_str9 is not null then
732: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

729: l_str9 := '';
730:
731: if l_str9 is not null then
732: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');

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

730:
731: if l_str9 is not null then
732: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

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

732: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');

733: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');

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

734: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

735:
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:

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

736: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');

737: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

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

738: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

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

740: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

741: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

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

742: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

743:
744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

744: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

Line 749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

745: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
753: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

746: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
753: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
754:

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

747: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
753: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
754:
755: /*

Line 752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

748: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
753: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
754:
755: /*
756: else

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

749: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
750: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
751: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
752: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
753: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
754:
755: /*
756: else
757:

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

754:
755: /*
756: else
757:
758: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

Line 759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

755: /*
756: else
757:
758: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
763: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

756: else
757:
758: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
763: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
764: */

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

757:
758: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
763: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
764: */
765: end if;

Line 762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

758: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
763: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
764: */
765: end if;
766:

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

759: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
760: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
761: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
762: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
763: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
764: */
765: end if;
766:
767: END LOOP;

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

765: end if;
766:
767: END LOOP;
768:
769: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
770:
771: ELSE
772: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
773: END IF;

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

768:
769: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
770:
771: ELSE
772: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
773: END IF;
774:
775: p_xfdf_clob := l_xfdf_string;
776: