eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COMMUNICATION_PVT dependencies on DBMS_LOB

Line 1143: select fl.file_name,dbms_lob.getlength(fl.file_data)

1139:
1140: -- bug4931216
1141: -- Join directly to the base table to improve performance
1142: cursor l_get_po_attachments_csr(l_po_header_id number) is
1143: select fl.file_name,dbms_lob.getlength(fl.file_data)
1144: from fnd_documents d,
1145: fnd_attached_documents ad,
1146: fnd_doc_category_usages dcu,
1147: fnd_attachment_functions af,

Line 1186: group by fl.file_name,dbms_lob.getlength(fl.file_data)

1182: and d.datatype_id=6
1183: and af.function_name='PO_PRINTPO'
1184: and d.media_id=fl.file_id
1185: and dcu.enabled_flag = 'Y'
1186: group by fl.file_name,dbms_lob.getlength(fl.file_data)
1187: order by fl.file_name;
1188:
1189: -- bug4931216
1190: -- Join directly to the base table to improve performance

Line 1192: select fl.file_name,dbms_lob.getlength(fl.file_data)

1188:
1189: -- bug4931216
1190: -- Join directly to the base table to improve performance
1191: cursor l_get_release_attachments_csr(l_po_release_id number) is
1192: select fl.file_name,dbms_lob.getlength(fl.file_data)
1193: from fnd_documents d,
1194: fnd_attached_documents ad,
1195: fnd_doc_category_usages dcu,
1196: fnd_attachment_functions af,

Line 1236: group by fl.file_name,dbms_lob.getlength(fl.file_data)

1232: and d.datatype_id=6
1233: and af.function_name='PO_PRINTPO'
1234: and d.media_id=fl.file_id
1235: and dcu.enabled_flag = 'Y'
1236: group by fl.file_name,dbms_lob.getlength(fl.file_data)
1237: order by fl.file_name;
1238: --
1239:
1240: begin

Line 3177: l_document_length := dbms_lob.GetLength(l_document);

3173: and fdl.document_id = fad.document_id and fdl.document_id = fd.document_id and fd.media_id = fl.file_id
3174: and fad.entity_name = l_entity_name and fdl.language=l_language
3175: and fl.file_name = l_filename ;
3176:
3177: l_document_length := dbms_lob.GetLength(l_document);
3178: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3179:
3180: document_type:='application/pdf; name='||l_filename;
3181:

Line 3178: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3174: and fad.entity_name = l_entity_name and fdl.language=l_language
3175: and fl.file_name = l_filename ;
3176:
3177: l_document_length := dbms_lob.GetLength(l_document);
3178: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3179:
3180: document_type:='application/pdf; name='||l_filename;
3181:
3182: EXCEPTION

Line 3195: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3191:
3192: --Bug#3274081 Display the message to the user incase the pdf fails.
3193: document_type:='text/html; name='||l_filename;
3194: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3195: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3196:
3197: END pdf_attach_app;
3198:
3199: -- Bug 3823799. Recoded following procedure. This procedure is to

Line 3295: l_document_length := dbms_lob.GetLength(l_document);

3291: and fd.document_id = fdl.document_id
3292: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language=l_language;
3293: END IF;
3294:
3295: l_document_length := dbms_lob.GetLength(l_document);
3296: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3297: document_type:='application/pdf; name='||l_filename;
3298:
3299: EXCEPTION

Line 3296: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3292: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language=l_language;
3293: END IF;
3294:
3295: l_document_length := dbms_lob.GetLength(l_document);
3296: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3297: document_type:='application/pdf; name='||l_filename;
3298:
3299: EXCEPTION
3300: WHEN OTHERS THEN

Line 3312: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3308: -- Bug 4047688
3309: -- Removed concatenation of l_filename from document_type
3310: document_type:='text/html';
3311: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3312: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3313: END pdf_attach_supp;
3314:
3315:
3316: procedure pdf_attach(document_id in varchar2,

Line 3457: l_document_length := dbms_lob.GetLength(l_document);

3453: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language=l_language;
3454:
3455: END IF;
3456:
3457: l_document_length := dbms_lob.GetLength(l_document);
3458: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3459:
3460: document_type:='application/pdf; name='||l_filename;
3461:

Line 3458: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3454:
3455: END IF;
3456:
3457: l_document_length := dbms_lob.GetLength(l_document);
3458: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3459:
3460: document_type:='application/pdf; name='||l_filename;
3461:
3462: EXCEPTION

Line 3476: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3472: --Bug#3274081 Display the message to the user incase the pdf fails.
3473: --Bug 4047688: Removed concatenation of l_filename from document_type
3474: document_type:='text/html';
3475: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3476: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3477:
3478: END pdf_attach;
3479:
3480:

Line 3601: -- l_okc_file_data first and then use dbms_lob.copy

3597: IF (l_okc_file_id > 0)
3598: THEN
3599:
3600: -- Bug 4173198: Select file_data from fnd_lobs into local variable
3601: -- l_okc_file_data first and then use dbms_lob.copy
3602:
3603: SELECT fl.file_name, fl.file_content_type, fl.file_data
3604: INTO l_okc_file_name, l_okc_file_content_type, l_okc_file_data
3605: FROM fnd_lobs fl

Line 3610: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);

3606: WHERE fl.file_id = l_okc_file_id;
3607:
3608: document_type := l_okc_file_content_type || '; name=' || l_okc_file_name;
3609:
3610: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);
3611: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);
3612:
3613: ELSE
3614:

Line 3611: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);

3607:
3608: document_type := l_okc_file_content_type || '; name=' || l_okc_file_name;
3609:
3610: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);
3611: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);
3612:
3613: ELSE
3614:
3615: /* file does not exist; return a null */

Line 3639: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3635: END IF;
3636:
3637: document_type:='text/html; name='||l_okc_file_name;
3638: l_message := fnd_message.get_string('PO','PO_OKC_DOC_FAILED');
3639: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3640:
3641: END okc_doc_attach;
3642:
3643:

Line 3769: l_document_length := dbms_lob.GetLength(l_document);

3765: raise;
3766: End;
3767:
3768: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get blob length';
3769: l_document_length := dbms_lob.GetLength(l_document);
3770:
3771: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Copy zip blob';
3772: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3773:

Line 3772: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3768: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get blob length';
3769: l_document_length := dbms_lob.GetLength(l_document);
3770:
3771: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Copy zip blob';
3772: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3773:
3774: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Set document type';
3775: document_type:=l_filecontent_type||'; name='||l_filename;
3776:

Line 3787: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3783: END IF;
3784:
3785: document_type:='text/html; name='||l_filename;
3786: l_message := fnd_message.get_string('PO','PO_ZIP_FAILED');
3787: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3788:
3789: END zip_attach;
3790:
3791: -------------------------------------------------------------------------------

Line 5534: IF dbms_lob.getlength(l_xml_result) >0 THEN

5530:
5531:
5532:
5533:
5534: IF dbms_lob.getlength(l_xml_result) >0 THEN
5535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5536: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'inside manuplating l_xml_result');
5537: END IF;
5538: -- add charset.

Line 5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');

5535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5536: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'inside manuplating l_xml_result');
5537: END IF;
5538: -- add charset.
5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
5540: l_tempXMLResult := l_xml_result;
5541: dbms_lob.write(l_xml_result,length(''),1,'');
5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);
5543:

Line 5541: dbms_lob.write(l_xml_result,length(''),1,'');

5537: END IF;
5538: -- add charset.
5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
5540: l_tempXMLResult := l_xml_result;
5541: dbms_lob.write(l_xml_result,length(''),1,'');
5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);
5543:
5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:

Line 5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);

5538: -- add charset.
5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
5540: l_tempXMLResult := l_xml_result;
5541: dbms_lob.write(l_xml_result,length(''),1,'');
5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);
5543:
5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');

Line 5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN

5540: l_tempXMLResult := l_xml_result;
5541: dbms_lob.write(l_xml_result,length(''),1,'');
5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);
5543:
5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');
5547: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');

5542: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(''),l_resultOffset);
5543:
5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');
5547: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5549: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added header attachments to XML');
5550: END IF;

Line 5547: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

5543:
5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');
5547: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5549: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added header attachments to XML');
5550: END IF;
5551:

Line 5554: IF dbms_lob.getlength(l_line_Attachments) >0 THEN

5550: END IF;
5551:
5552: END IF;
5553:
5554: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
5555:
5556: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments,'>');
5557:
5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN

Line 5556: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments,'>');

5552: END IF;
5553:
5554: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
5555:
5556: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments,'>');
5557:
5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5559: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5560: ELSE

Line 5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN

5554: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
5555:
5556: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments,'>');
5557:
5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5559: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5560: ELSE
5561: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5562: END IF;

Line 5559: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

5555:
5556: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments,'>');
5557:
5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5559: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5560: ELSE
5561: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5562: END IF;
5563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5561: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

5557:
5558: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5559: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5560: ELSE
5561: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5562: END IF;
5563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added line attachments to XML');
5565: END IF;

Line 5570: IF dbms_lob.getlength(l_disAttachments) >0 THEN

5566:
5567:
5568: END IF;
5569:
5570: IF dbms_lob.getlength(l_disAttachments) >0 THEN
5571:
5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');
5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

Line 5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');

5568: END IF;
5569:
5570: IF dbms_lob.getlength(l_disAttachments) >0 THEN
5571:
5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');
5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

Line 5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN

5569:
5570: IF dbms_lob.getlength(l_disAttachments) >0 THEN
5571:
5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');
5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5577: END IF;

Line 5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

5570: IF dbms_lob.getlength(l_disAttachments) >0 THEN
5571:
5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');
5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5577: END IF;
5578: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

5572: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments,'>');
5573: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5574: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5577: END IF;
5578: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5579: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added distribution attachments to XML');
5580: END IF;

Line 5584: IF dbms_lob.getlength(l_fileClob) >0 THEN

5580: END IF;
5581:
5582: END IF;
5583:
5584: IF dbms_lob.getlength(l_fileClob) >0 THEN
5585:
5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');
5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

Line 5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');

5582: END IF;
5583:
5584: IF dbms_lob.getlength(l_fileClob) >0 THEN
5585:
5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');
5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

Line 5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN

5583:
5584: IF dbms_lob.getlength(l_fileClob) >0 THEN
5585:
5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');
5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5591: END IF;

Line 5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

5584: IF dbms_lob.getlength(l_fileClob) >0 THEN
5585:
5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');
5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5591: END IF;
5592: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

5586: l_variablePosition := DBMS_LOB.INSTR(l_fileClob,'>');
5587: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5588: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5591: END IF;
5592: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5593: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added file to XML');
5594: END IF;

Line 5599: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --

5595:
5596:
5597: END IF;
5598:
5599: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --
5600:
5601: --Add l_address_details to final XML
5602:
5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');

Line 5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');

5599: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --
5600:
5601: --Add l_address_details to final XML
5602:
5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');
5604: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5605: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5606: ELSE
5607: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

Line 5604: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN

5600:
5601: --Add l_address_details to final XML
5602:
5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');
5604: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5605: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5606: ELSE
5607: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5608: END IF;

Line 5605: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);

5601: --Add l_address_details to final XML
5602:
5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');
5604: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5605: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5606: ELSE
5607: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5608: END IF;
5609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5607: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

5603: l_variablePosition := DBMS_LOB.INSTR(l_address_details,'>');
5604: IF(DBMS_LOB.INSTR(l_xml_result,'') > 0) THEN
5605: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, (dbms_lob.getlength(l_xml_result)- length('') ), l_variablePosition+1);
5606: ELSE
5607: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5608: END IF;
5609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added Address details to XML');
5611: END IF;

Line 5616: IF(DBMS_LOB.INSTR(l_xml_result,'') = 0) THEN

5612:
5613:
5614: END IF; -- bug#3580225 end --
5615:
5616: IF(DBMS_LOB.INSTR(l_xml_result,'') = 0) THEN
5617: dbms_lob.write(l_xml_result,10,dbms_lob.getlength(l_xml_result),'');
5618: END IF;
5619:
5620: END IF;

Line 5617: dbms_lob.write(l_xml_result,10,dbms_lob.getlength(l_xml_result),'');

5613:
5614: END IF; -- bug#3580225 end --
5615:
5616: IF(DBMS_LOB.INSTR(l_xml_result,'') = 0) THEN
5617: dbms_lob.write(l_xml_result,10,dbms_lob.getlength(l_xml_result),'');
5618: END IF;
5619:
5620: END IF;
5621:

Line 5628: dbms_lob.write(l_xml_result,11,dbms_lob.getlength(l_xml_result)-9,'');

5624: Add the final xml query in the clob.
5625: */
5626: IF(p_test_flag = 'D') then
5627:
5628: dbms_lob.write(l_xml_result,11,dbms_lob.getlength(l_xml_result)-9,'');
5629: dbms_lob.write(l_xml_result,length(l_xml_query||' '),dbms_lob.getlength(l_xml_result)+1,l_xml_query||' ');
5630:
5631: END IF;
5632: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 5629: dbms_lob.write(l_xml_result,length(l_xml_query||' '),dbms_lob.getlength(l_xml_result)+1,l_xml_query||' ');

5625: */
5626: IF(p_test_flag = 'D') then
5627:
5628: dbms_lob.write(l_xml_result,11,dbms_lob.getlength(l_xml_result)-9,'');
5629: dbms_lob.write(l_xml_result,length(l_xml_query||' '),dbms_lob.getlength(l_xml_result)+1,l_xml_query||' ');
5630:
5631: END IF;
5632: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5633: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'END OF POXMLGEN');