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_COLL_CAMP_SCHD_RPT_PKG dependencies on DBMS_LOB

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

44: +-----------------------------------------------------------------------*/
45: BEGIN
46: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
47: LOOP
48: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
49: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
50: IF (NVL (l_end, 0) < 1) THEN
51: EXIT;
52: END IF;

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

49: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
50: IF (NVL (l_end, 0) < 1) THEN
51: EXIT;
52: END IF;
53: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
54: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
55: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
56: l_start := l_end + c_endline_len;
57: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

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

258: END;
259: IF l_rows_processed <> 0 THEN
260: FND_FILE.put_line( FND_FILE.LOG,'8') ;
261: --get the length og the rowset header
262: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
263: FND_FILE.put_line( FND_FILE.LOG,'9') ;
264: ELSE
265: l_resultOffset := 0;
266: END IF;

Line 317: l_xml_header_length := dbms_lob.getlength(l_xml_header);

313: -- END IF;
314: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_sysdate,'YYYY-MM-DD')||'';
315: l_xml_header := l_xml_header ||l_new_line||' ';
316: l_close_tag := l_new_line||''||l_new_line;
317: l_xml_header_length := dbms_lob.getlength(l_xml_header);
318: tempResult :=l_xml_header;
319: IF l_rows_processed <> 0 THEN
320: --copy result set to tempResult
321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);

Line 321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);

317: l_xml_header_length := dbms_lob.getlength(l_xml_header);
318: tempResult :=l_xml_header;
319: IF l_rows_processed <> 0 THEN
320: --copy result set to tempResult
321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
322: ELSE
323: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
324: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);

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

319: IF l_rows_processed <> 0 THEN
320: --copy result set to tempResult
321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
322: ELSE
323: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
324: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
326: END IF;
327: --append the close tag to tempResult

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

320: --copy result set to tempResult
321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
322: ELSE
323: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
324: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
326: END IF;
327: --append the close tag to tempResult
328: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);

Line 325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);

321: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
322: ELSE
323: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
324: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
326: END IF;
327: --append the close tag to tempResult
328: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
329: --print to the o/p file

Line 328: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);

324: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
325: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
326: END IF;
327: --append the close tag to tempResult
328: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
329: --print to the o/p file
330: print_clob(lob_loc => tempResult);
331: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;
332: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || '-end');