3983: || l_iana_charset
3984: || '"?>
3985: l_str10 := '
3986: l_str11 := '
3987: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
3988: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
3989: current_index := 0;
3990:
3991: IF gins_data.COUNT > 0
3984: || '"?>
3985: l_str10 := '
3986: l_str11 := '
3987: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
3988: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
3989: current_index := 0;
3990:
3991: IF gins_data.COUNT > 0
3992: THEN
3989: current_index := 0;
3990:
3991: IF gins_data.COUNT > 0
3992: THEN
3993: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
3994:
3995: FOR table_counter IN gins_data.FIRST .. gins_data.LAST
3996: LOOP
3997: l_str8 := gins_data (table_counter).tagname;
4032: ,'KU14_PERSON'
4033: ,'LE_ADDRESS'
4034: )
4035: THEN
4036: DBMS_LOB.writeappend (l_xfdf_string
4037: ,LENGTH (l_str2)
4038: ,l_str2
4039: );
4040: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4036: DBMS_LOB.writeappend (l_xfdf_string
4037: ,LENGTH (l_str2)
4038: ,l_str2
4039: );
4040: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4041: ,l_str8);
4042: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4043: ,l_str3);
4044: ELSE
4038: ,l_str2
4039: );
4040: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4041: ,l_str8);
4042: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4043: ,l_str3);
4044: ELSE
4045: DBMS_LOB.writeappend (l_xfdf_string
4046: ,LENGTH (l_str4)
4041: ,l_str8);
4042: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4043: ,l_str3);
4044: ELSE
4045: DBMS_LOB.writeappend (l_xfdf_string
4046: ,LENGTH (l_str4)
4047: ,l_str4
4048: );
4049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4045: DBMS_LOB.writeappend (l_xfdf_string
4046: ,LENGTH (l_str4)
4047: ,l_str4
4048: );
4049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4050: ,l_str8);
4051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4052: ,l_str5);
4053: END IF;
4047: ,l_str4
4048: );
4049: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4050: ,l_str8);
4051: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4052: ,l_str5);
4053: END IF;
4054: ELSE
4055: IF l_str9 IS NOT NULL
4053: END IF;
4054: ELSE
4055: IF l_str9 IS NOT NULL
4056: THEN
4057: DBMS_LOB.writeappend (l_xfdf_string
4058: ,LENGTH (l_str2)
4059: ,l_str2
4060: );
4061: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4057: DBMS_LOB.writeappend (l_xfdf_string
4058: ,LENGTH (l_str2)
4059: ,l_str2
4060: );
4061: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4062: ,l_str8);
4063: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4064: ,l_str3);
4065: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4059: ,l_str2
4060: );
4061: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4062: ,l_str8);
4063: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4064: ,l_str3);
4065: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4066: ,l_str9);
4067: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4061: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4062: ,l_str8);
4063: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4064: ,l_str3);
4065: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4066: ,l_str9);
4067: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4068: ,l_str4);
4069: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4063: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4064: ,l_str3);
4065: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4066: ,l_str9);
4067: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4068: ,l_str4);
4069: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4070: ,l_str8);
4071: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4065: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
4066: ,l_str9);
4067: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4068: ,l_str4);
4069: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4070: ,l_str8);
4071: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4072: ,l_str5);
4073: ELSE
4067: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4068: ,l_str4);
4069: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4070: ,l_str8);
4071: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4072: ,l_str5);
4073: ELSE
4074: DBMS_LOB.writeappend (l_xfdf_string
4075: ,LENGTH (l_str2)
4070: ,l_str8);
4071: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4072: ,l_str5);
4073: ELSE
4074: DBMS_LOB.writeappend (l_xfdf_string
4075: ,LENGTH (l_str2)
4076: ,l_str2
4077: );
4078: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4074: DBMS_LOB.writeappend (l_xfdf_string
4075: ,LENGTH (l_str2)
4076: ,l_str2
4077: );
4078: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4079: ,l_str8);
4080: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4081: ,l_str3);
4082: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4076: ,l_str2
4077: );
4078: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4079: ,l_str8);
4080: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4081: ,l_str3);
4082: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4083: ,l_str4);
4084: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4078: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4079: ,l_str8);
4080: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4081: ,l_str3);
4082: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4083: ,l_str4);
4084: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4085: ,l_str8);
4086: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4080: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
4081: ,l_str3);
4082: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4083: ,l_str4);
4084: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4085: ,l_str8);
4086: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4087: ,l_str5);
4088: END IF;
4082: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
4083: ,l_str4);
4084: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
4085: ,l_str8);
4086: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
4087: ,l_str5);
4088: END IF;
4089: END IF;
4090: END LOOP;
4088: END IF;
4089: END IF;
4090: END LOOP;
4091:
4092: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
4093: ELSE
4094: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
4095: END IF;
4096:
4090: END LOOP;
4091:
4092: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
4093: ELSE
4094: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
4095: END IF;
4096:
4097: p_xfdf_clob := l_xfdf_string;
4098: hr_utility.set_location ('Leaving WritetoCLOB ', 40);