DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on DBMS_LOB

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

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

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

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

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

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;

Line 4036: DBMS_LOB.writeappend (l_xfdf_string

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)

Line 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

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

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)

Line 4045: DBMS_LOB.writeappend (l_xfdf_string

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)

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

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

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

Line 4057: DBMS_LOB.writeappend (l_xfdf_string

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)

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

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

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)

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

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)

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

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)

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

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

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

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)

Line 4074: DBMS_LOB.writeappend (l_xfdf_string

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)

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

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

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)

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

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)

Line 4084: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (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)
4087: ,l_str5);
4088: END IF;

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

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;

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

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:

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

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