4191: || l_iana_charset
4192: || '"?>
4193: l_str10 := '
4194: l_str11 := '
4195: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
4196: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
4197: current_index := 0;
4198:
4199: IF gins_data.COUNT > 0
4192: || '"?>
4193: l_str10 := '
4194: l_str11 := '
4195: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
4196: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
4197: current_index := 0;
4198:
4199: IF gins_data.COUNT > 0
4200: THEN
4197: current_index := 0;
4198:
4199: IF gins_data.COUNT > 0
4200: THEN
4201: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
4202:
4203: FOR table_counter IN gins_data.FIRST .. gins_data.LAST
4204: LOOP
4205: l_str8 := gins_data (table_counter).tagname;
4240: ,'KU14_PERSON'
4241: ,'LE_ADDRESS'
4242: )
4243: THEN
4244: DBMS_LOB.writeappend (l_xfdf_string
4245: ,LENGTH (l_str2)
4246: ,l_str2
4247: );
4248: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4244: DBMS_LOB.writeappend (l_xfdf_string
4245: ,LENGTH (l_str2)
4246: ,l_str2
4247: );
4248: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4249: ,l_str8);
4250: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4251: ,l_str3);
4252: ELSE
4246: ,l_str2
4247: );
4248: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4249: ,l_str8);
4250: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4251: ,l_str3);
4252: ELSE
4253: DBMS_LOB.writeappend (l_xfdf_string
4254: ,LENGTH (l_str4)
4249: ,l_str8);
4250: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4251: ,l_str3);
4252: ELSE
4253: DBMS_LOB.writeappend (l_xfdf_string
4254: ,LENGTH (l_str4)
4255: ,l_str4
4256: );
4257: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4253: DBMS_LOB.writeappend (l_xfdf_string
4254: ,LENGTH (l_str4)
4255: ,l_str4
4256: );
4257: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4258: ,l_str8);
4259: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4260: ,l_str5);
4261: END IF;
4255: ,l_str4
4256: );
4257: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4258: ,l_str8);
4259: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4260: ,l_str5);
4261: END IF;
4262: ELSE
4263: IF l_str9 IS NOT NULL
4261: END IF;
4262: ELSE
4263: IF l_str9 IS NOT NULL
4264: THEN
4265: DBMS_LOB.writeappend (l_xfdf_string
4266: ,LENGTH (l_str2)
4267: ,l_str2
4268: );
4269: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4265: DBMS_LOB.writeappend (l_xfdf_string
4266: ,LENGTH (l_str2)
4267: ,l_str2
4268: );
4269: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4270: ,l_str8);
4271: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4272: ,l_str3);
4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4267: ,l_str2
4268: );
4269: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4270: ,l_str8);
4271: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4272: ,l_str3);
4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4274: ,l_str9);
4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4269: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4270: ,l_str8);
4271: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4272: ,l_str3);
4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4274: ,l_str9);
4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4276: ,l_str4);
4277: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4271: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4272: ,l_str3);
4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4274: ,l_str9);
4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4276: ,l_str4);
4277: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4278: ,l_str8);
4279: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4274: ,l_str9);
4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4276: ,l_str4);
4277: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4278: ,l_str8);
4279: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4280: ,l_str5);
4281: ELSE
4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4276: ,l_str4);
4277: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4278: ,l_str8);
4279: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4280: ,l_str5);
4281: ELSE
4282: DBMS_LOB.writeappend (l_xfdf_string
4283: ,LENGTH (l_str2)
4278: ,l_str8);
4279: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4280: ,l_str5);
4281: ELSE
4282: DBMS_LOB.writeappend (l_xfdf_string
4283: ,LENGTH (l_str2)
4284: ,l_str2
4285: );
4286: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4282: DBMS_LOB.writeappend (l_xfdf_string
4283: ,LENGTH (l_str2)
4284: ,l_str2
4285: );
4286: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4287: ,l_str8);
4288: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4289: ,l_str3);
4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4284: ,l_str2
4285: );
4286: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4287: ,l_str8);
4288: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4289: ,l_str3);
4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4291: ,l_str4);
4292: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4286: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4287: ,l_str8);
4288: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4289: ,l_str3);
4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4291: ,l_str4);
4292: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4293: ,l_str8);
4294: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4288: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4289: ,l_str3);
4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4291: ,l_str4);
4292: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4293: ,l_str8);
4294: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4295: ,l_str5);
4296: END IF;
4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4291: ,l_str4);
4292: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4293: ,l_str8);
4294: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4295: ,l_str5);
4296: END IF;
4297: END IF;
4298: END LOOP;
4296: END IF;
4297: END IF;
4298: END LOOP;
4299:
4300: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
4301: ELSE
4302: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
4303: END IF;
4304:
4298: END LOOP;
4299:
4300: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
4301: ELSE
4302: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
4303: END IF;
4304:
4305: p_xfdf_clob := l_xfdf_string;
4306: hr_utility.set_location ('Leaving WritetoCLOB ', 40);