DBA Data[Home] [Help]

APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on DBMS_LOB

Line 201: DBMS_LOB.createtemporary(l_xml_header, TRUE);

197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: l_stmt_num := 90;
201: DBMS_LOB.createtemporary(l_xml_header, TRUE);
202: DBMS_LOB.createtemporary(l_xml_body, TRUE);
203: DBMS_LOB.createtemporary(l_xml_report, TRUE);
204:
205: -- Count the no. of rows in the accrual temp table

Line 202: DBMS_LOB.createtemporary(l_xml_body, TRUE);

198: END IF;
199:
200: l_stmt_num := 90;
201: DBMS_LOB.createtemporary(l_xml_header, TRUE);
202: DBMS_LOB.createtemporary(l_xml_body, TRUE);
203: DBMS_LOB.createtemporary(l_xml_report, TRUE);
204:
205: -- Count the no. of rows in the accrual temp table
206: -- l_row_count will be part of report header information

Line 203: DBMS_LOB.createtemporary(l_xml_report, TRUE);

199:
200: l_stmt_num := 90;
201: DBMS_LOB.createtemporary(l_xml_header, TRUE);
202: DBMS_LOB.createtemporary(l_xml_body, TRUE);
203: DBMS_LOB.createtemporary(l_xml_report, TRUE);
204:
205: -- Count the no. of rows in the accrual temp table
206: -- l_row_count will be part of report header information
207: l_stmt_num := 100;

Line 727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);

723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724: l_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: l_stmt_num := 10;
727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);
728: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);
729:
730: l_stmt_num := 20;
731: DBMS_LOB.createtemporary(x_xml_doc, TRUE);

Line 728: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);

724: l_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: l_stmt_num := 10;
727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);
728: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);
729:
730: l_stmt_num := 20;
731: DBMS_LOB.createtemporary(x_xml_doc, TRUE);
732:

Line 731: DBMS_LOB.createtemporary(x_xml_doc, TRUE);

727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);
728: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);
729:
730: l_stmt_num := 20;
731: DBMS_LOB.createtemporary(x_xml_doc, TRUE);
732:
733: IF (l_length_src1 > 0) THEN
734:
735: -- Get the first occurence of XML header

Line 737: l_offset := DBMS_LOB.instr (lob_loc => p_xml_src1,

733: IF (l_length_src1 > 0) THEN
734:
735: -- Get the first occurence of XML header
736: l_stmt_num := 30;
737: l_offset := DBMS_LOB.instr (lob_loc => p_xml_src1,
738: pattern => '>',
739: offset => 1,
740: nth => 1);
741:

Line 747: --DBMS_LOB.copy (x_xml_doc, p_xml_src1, l_offset + 1);

743: l_stmt_num := 40;
744:
745: /*Bug 7282242*/
746: /*Remove the header (21 characters)*/
747: --DBMS_LOB.copy (x_xml_doc, p_xml_src1, l_offset + 1);
748:
749: /*The following 3 lines of code ensures that XML data generated here uses the right encoding*/
750: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
751: l_xml_header := '';

Line 752: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);

748:
749: /*The following 3 lines of code ensures that XML data generated here uses the right encoding*/
750: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
751: l_xml_header := '';
752: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
753:
754: -- Append the root tag to the XML doc
755: l_stmt_num := 50;
756: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 2, '<' || p_root_tag || '>');

Line 756: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 2, '<' || p_root_tag || '>');

752: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
753:
754: -- Append the root tag to the XML doc
755: l_stmt_num := 50;
756: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 2, '<' || p_root_tag || '>');
757:
758: -- Append the 1st XML doc to the destination XML doc
759: l_stmt_num := 60;
760: DBMS_LOB.copy ( x_xml_doc,

Line 760: DBMS_LOB.copy ( x_xml_doc,

756: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 2, '<' || p_root_tag || '>');
757:
758: -- Append the 1st XML doc to the destination XML doc
759: l_stmt_num := 60;
760: DBMS_LOB.copy ( x_xml_doc,
761: p_xml_src1,
762: l_length_src1 - l_offset,
763: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,
764: l_offset + 1

Line 763: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,

759: l_stmt_num := 60;
760: DBMS_LOB.copy ( x_xml_doc,
761: p_xml_src1,
762: l_length_src1 - l_offset,
763: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,
764: l_offset + 1
765: );
766:
767: -- Append the 2nd XML doc to the destination XML doc

Line 770: DBMS_LOB.copy ( x_xml_doc,

766:
767: -- Append the 2nd XML doc to the destination XML doc
768: IF (l_length_src2 > 0) THEN
769: l_stmt_num := 70;
770: DBMS_LOB.copy ( x_xml_doc,
771: p_xml_src2,
772: l_length_src2 - l_offset,
773: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,
774: l_offset + 1

Line 773: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,

769: l_stmt_num := 70;
770: DBMS_LOB.copy ( x_xml_doc,
771: p_xml_src2,
772: l_length_src2 - l_offset,
773: DBMS_LOB.GETLENGTH(x_xml_doc) + 1,
774: l_offset + 1
775: );
776: END IF;
777:

Line 780: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 3, '');

776: END IF;
777:
778: -- Append the root tag to the end of XML doc
779: l_stmt_num := 80;
780: DBMS_LOB.writeappend (x_xml_doc, LENGTH(p_root_tag) + 3, '');
781:
782: END IF;
783:
784: -- Procedure level log message for exit point

Line 903: l_length := nvl(DBMS_LOB.getlength(p_xml_data), 0);

899: l_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: -- Get length of the CLOB p_xml_data
902: l_stmt_num := 10;
903: l_length := nvl(DBMS_LOB.getlength(p_xml_data), 0);
904:
905: -- Set the offset point to be the start of the CLOB data
906: l_offset := 1;
907:

Line 918: DBMS_LOB.read (p_xml_data, l_amount, l_offset, l_data);

914:
915: EXIT WHEN l_length <= 0;
916:
917: -- Read 32 KB of data and print it to the report output
918: DBMS_LOB.read (p_xml_data, l_amount, l_offset, l_data);
919:
920: FND_FILE.PUT(FND_FILE.OUTPUT, l_data);
921:
922: l_length := l_length - l_amount;