DBA Data[Home] [Help]

APPS.PAY_FI_MTRR dependencies on DBMS_LOB

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

830: l_str10 := '';
831: l_str11 := '
';
832:
833:
834: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
835: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
836:
837: current_index := 0;
838:

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

831: l_str11 := '';
832:
833:
834: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
835: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
836:
837: current_index := 0;
838:
839: IF gtagdata.count > 0 THEN

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

837: current_index := 0;
838:
839: IF gtagdata.count > 0 THEN
840:
841: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
842:
843: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
844:
845: l_str8 := gtagdata(table_counter).TagName;

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

846: l_str9 := gtagdata(table_counter).TagValue;
847:
848: if l_str9 is not null then
849:
850: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

847:
848: if l_str9 is not null then
849:
850: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

848: if l_str9 is not null then
849:
850: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

849:
850: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else

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

850: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else
858:

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

851: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else
858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

852: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
853: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
854: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else
858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

855: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else
858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

856: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
857: else
858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
864: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

857: else
858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
864: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
865:

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

858:
859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
864: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
865:
866: end if;

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

859: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
864: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
865:
866: end if;
867:

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

860: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
861: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
862: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
863: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
864: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
865:
866: end if;
867:
868: END LOOP;

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

866: end if;
867:
868: END LOOP;
869:
870: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
871: ELSE
872: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
873: END IF;
874:

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

868: END LOOP;
869:
870: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
871: ELSE
872: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
873: END IF;
874:
875: p_xfdf_clob := l_xfdf_string;
876: