DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on DBMS_LOB

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

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

Line 4196: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

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

Line 4201: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

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;

Line 4244: DBMS_LOB.writeappend (l_xfdf_string

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)

Line 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

Line 4250: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

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)

Line 4253: DBMS_LOB.writeappend (l_xfdf_string

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)

Line 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;

Line 4259: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

Line 4265: DBMS_LOB.writeappend (l_xfdf_string

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)

Line 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)

Line 4271: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

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)

Line 4273: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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)

Line 4275: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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)

Line 4277: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

Line 4279: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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)

Line 4282: DBMS_LOB.writeappend (l_xfdf_string

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)

Line 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)

Line 4288: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

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)

Line 4290: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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)

Line 4292: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (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)
4295: ,l_str5);
4296: END IF;

Line 4294: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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;

Line 4300: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

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:

Line 4302: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

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);