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.IEX_DUNNING_PVT dependencies on DBMS_LOB

Line 17772: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );

17768: +-----------------------------------------------------------------------*/
17769: BEGIN
17770: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
17771: LOOP
17772: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
17773: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
17774: IF (NVL (l_end, 0) < 1) THEN
17775: EXIT;
17776: END IF;

Line 17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

17773: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
17774: IF (NVL (l_end, 0) < 1) THEN
17775: EXIT;
17776: END IF;
17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

Line 18061: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

18057: DBMS_XMLQuery.closeContext(ctx);
18058: END;
18059:
18060: IF l_rows_processed <> 0 THEN
18061: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
18062: ELSE
18063: l_resultOffset := 0;
18064: END IF;
18065:

Line 18101: dbms_lob.copy(tempResult,l_result

18097: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');
18098:
18099: IF l_rows_processed <> 0 THEN
18100: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML body');
18101: dbms_lob.copy(tempResult,l_result
18102: ,dbms_lob.getlength(l_result)-l_resultOffset
18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE
18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 18102: ,dbms_lob.getlength(l_result)-l_resultOffset

18098:
18099: IF l_rows_processed <> 0 THEN
18100: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML body');
18101: dbms_lob.copy(tempResult,l_result
18102: ,dbms_lob.getlength(l_result)-l_resultOffset
18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE
18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

18101: dbms_lob.copy(tempResult,l_result
18102: ,dbms_lob.getlength(l_result)-l_resultOffset
18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE
18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
18108: END IF;
18109:

Line 18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

18102: ,dbms_lob.getlength(l_result)-l_resultOffset
18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE
18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
18108: END IF;
18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');

Line 18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE
18105: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
18108: END IF;
18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');
18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
18108: END IF;
18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');
18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
18114: print_clob(lob_loc => tempResult);
18115: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');