1015: l_str10 := '
1016: l_str11 := '
1017:
1018:
1019: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1020: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1021:
1022: current_index := 0;
1023:
1016: l_str11 := '';
1017:
1018:
1019: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1020: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1021:
1022: current_index := 0;
1023:
1024: IF xml_tab.count > 0 THEN
1022: current_index := 0;
1023:
1024: IF xml_tab.count > 0 THEN
1025:
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1027:
1028:
1029: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
1030:
1034: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS','END_ORG_DETAILS','END_EMP_DETAILS'
1035: ) THEN
1036:
1037: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: ) THEN
1036:
1037: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1036:
1037: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1045: END IF;
1046:
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1045: END IF;
1046:
1047: ELSE
1040: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1041: ELSE
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1045: END IF;
1046:
1047: ELSE
1048:
1047: ELSE
1048:
1049: if l_str9 is not null then
1050:
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048:
1049: if l_str9 is not null then
1050:
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: if l_str9 is not null then
1050:
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050:
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058: else
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1066:
1059:
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1066:
1067: end if;
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1066:
1067: end if;
1068:
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1066:
1067: end if;
1068:
1069: END IF;
1069: END IF;
1070:
1071: END LOOP;
1072:
1073: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1074:
1075: ELSE
1076: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1077: END IF;
1072:
1073: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1074:
1075: ELSE
1076: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1077: END IF;
1078:
1079: p_xfdf_clob := l_xfdf_string;
1080: