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.

[Home] [Help]

APPS.PAY_FI_DPSR dependencies on DBMS_LOB

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

688: l_str6 := '';
689: l_str7 := ' ';
690:
691:
692: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
693: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
694:
695: current_index := 0;
696:

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

689: l_str7 := ' ';
690:
691:
692: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
693: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
694:
695: current_index := 0;
696:
697: IF gtagdata.count > 0 THEN

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

695: current_index := 0;
696:
697: IF gtagdata.count > 0 THEN
698:
699: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
700:
701:
702: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
703:

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

704: l_str8 := gtagdata(table_counter).TagName;
705: l_str9 := '';
706:
707: if l_str9 is not null then
708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
709: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

705: l_str9 := '';
706:
707: if l_str9 is not null then
708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
709: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');

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

706:
707: if l_str9 is not null then
708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
709: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

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

708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
709: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

709: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');

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

710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

711:
712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:

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

712: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

713: dbms_lob.writeAppend(l_xfdf_string, 4, 'CODE');
714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

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

714: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
715: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

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

716: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

717: dbms_lob.writeAppend(l_xfdf_string, 4 , 'CODE');
718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');

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

718: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

719:
720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

720: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

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

721: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
729: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

722: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
729: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
730:

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

723: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
729: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
730:
731: /*

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

724: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
729: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
730:
731: /*
732: else

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

725: dbms_lob.writeAppend(l_xfdf_string, 5, 'VALUE');
726: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
727: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
728: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
729: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
730:
731: /*
732: else
733:

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

730:
731: /*
732: else
733:
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');

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

731: /*
732: else
733:
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

732: else
733:
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
740: */

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

733:
734: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
740: */
741: end if;

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

734: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
740: */
741: end if;
742:

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

735: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
736: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
737: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
738: dbms_lob.writeAppend(l_xfdf_string, 11 , 'RECORD_DPSR');
739: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
740: */
741: end if;
742:
743: END LOOP;

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

741: end if;
742:
743: END LOOP;
744:
745: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
746:
747: ELSE
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
749: END IF;

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

744:
745: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
746:
747: ELSE
748: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
749: END IF;
750:
751: p_xfdf_clob := l_xfdf_string;
752: