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

Line 138: DBMS_LOB.INSTR (lob_loc => lob_loc,

134: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
135:
136: LOOP
137: l_end :=
138: DBMS_LOB.INSTR (lob_loc => lob_loc,
139: pattern => c_endline,
140: offset => l_start,
141: nth => 1
142: );

Line 150: DBMS_LOB.SUBSTR (lob_loc => lob_loc,

146: EXIT;
147: END IF;
148:
149: l_one_line :=
150: DBMS_LOB.SUBSTR (lob_loc => lob_loc,
151: amount => l_end - l_start,
152: offset => l_start
153: );
154: l_start := l_end + c_endline_len;

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

477: END;
478: -- We are adding the LNSPORTFOLIO and PARAMETERS TAGs so we have
479: -- to offset the first line.
480: IF l_rows_processed <> 0 THEN
481: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
482: tempResult := l_result;
483: ELSE
484: l_resultOffset := 0;
485: END IF;

Line 512: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

508: l_xml_header := l_xml_header ||l_new_line||' ';
509: l_close_tag := l_new_line||''||l_new_line;
510: l_xml_header_length := length(l_xml_header);
511: IF l_rows_processed <> 0 THEN
512: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
513: dbms_lob.copy(tempResult,l_result
514: ,dbms_lob.getlength(l_result)-l_resultOffset
515: ,l_xml_header_length,l_resultOffset);
516: ELSE

Line 513: dbms_lob.copy(tempResult,l_result

509: l_close_tag := l_new_line||''||l_new_line;
510: l_xml_header_length := length(l_xml_header);
511: IF l_rows_processed <> 0 THEN
512: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
513: dbms_lob.copy(tempResult,l_result
514: ,dbms_lob.getlength(l_result)-l_resultOffset
515: ,l_xml_header_length,l_resultOffset);
516: ELSE
517: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

510: l_xml_header_length := length(l_xml_header);
511: IF l_rows_processed <> 0 THEN
512: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
513: dbms_lob.copy(tempResult,l_result
514: ,dbms_lob.getlength(l_result)-l_resultOffset
515: ,l_xml_header_length,l_resultOffset);
516: ELSE
517: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
518: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

513: dbms_lob.copy(tempResult,l_result
514: ,dbms_lob.getlength(l_result)-l_resultOffset
515: ,l_xml_header_length,l_resultOffset);
516: ELSE
517: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
518: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
519: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
520: END IF;
521:

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

514: ,dbms_lob.getlength(l_result)-l_resultOffset
515: ,l_xml_header_length,l_resultOffset);
516: ELSE
517: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
518: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
519: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
520: END IF;
521:
522: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

515: ,l_xml_header_length,l_resultOffset);
516: ELSE
517: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
518: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
519: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
520: END IF;
521:
522: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
523: print_clob(lob_loc => tempResult);

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

518: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
519: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
520: END IF;
521:
522: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
523: print_clob(lob_loc => tempResult);
524: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
525: EXCEPTION
526: WHEN OTHERS THEN

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

938: END;
939: -- We are adding the LNSPORTFOLIO and PARAMETERS TAGs so we have
940: -- to offset the first line.
941: IF l_rows_processed <> 0 THEN
942: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
943: tempResult := l_result;
944: ELSE
945: l_resultOffset := 0;
946: END IF;

Line 969: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

965: l_xml_header := l_xml_header ||l_new_line||' ';
966: l_close_tag := l_new_line||''||l_new_line;
967: l_xml_header_length := length(l_xml_header);
968: IF l_rows_processed <> 0 THEN
969: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
970: dbms_lob.copy(tempResult,l_result
971: ,dbms_lob.getlength(l_result)-l_resultOffset
972: ,l_xml_header_length,l_resultOffset);
973: ELSE

Line 970: dbms_lob.copy(tempResult,l_result

966: l_close_tag := l_new_line||''||l_new_line;
967: l_xml_header_length := length(l_xml_header);
968: IF l_rows_processed <> 0 THEN
969: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
970: dbms_lob.copy(tempResult,l_result
971: ,dbms_lob.getlength(l_result)-l_resultOffset
972: ,l_xml_header_length,l_resultOffset);
973: ELSE
974: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

967: l_xml_header_length := length(l_xml_header);
968: IF l_rows_processed <> 0 THEN
969: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
970: dbms_lob.copy(tempResult,l_result
971: ,dbms_lob.getlength(l_result)-l_resultOffset
972: ,l_xml_header_length,l_resultOffset);
973: ELSE
974: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
975: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

970: dbms_lob.copy(tempResult,l_result
971: ,dbms_lob.getlength(l_result)-l_resultOffset
972: ,l_xml_header_length,l_resultOffset);
973: ELSE
974: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
975: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
976: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
977: END IF;
978:

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

971: ,dbms_lob.getlength(l_result)-l_resultOffset
972: ,l_xml_header_length,l_resultOffset);
973: ELSE
974: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
975: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
976: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
977: END IF;
978:
979: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

972: ,l_xml_header_length,l_resultOffset);
973: ELSE
974: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
975: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
976: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
977: END IF;
978:
979: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
980: print_clob(lob_loc => tempResult);

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

975: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
976: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
977: END IF;
978:
979: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
980: print_clob(lob_loc => tempResult);
981: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
982: EXCEPTION
983: WHEN OTHERS THEN

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

1694: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_rows_processed ' || l_rows_processed);
1695: -- We are adding the LNSAGREEMENT and PARAMETERS TAGs so we have
1696: -- to offset the first line.
1697: IF l_rows_processed <> 0 THEN
1698: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1699: ELSE
1700: l_resultOffset := 0;
1701: END IF;
1702: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_resultOffset ' || l_resultOffset);

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

1714: l_close_tag := l_new_line||''||l_new_line;
1715: l_xml_header_length := length(l_xml_header);
1716: IF l_rows_processed <> 0 THEN
1717: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' l_xml_header_length ' || l_xml_header_length);
1718: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1719: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );

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

1715: l_xml_header_length := length(l_xml_header);
1716: IF l_rows_processed <> 0 THEN
1717: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' l_xml_header_length ' || l_xml_header_length);
1718: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1719: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1723: dbms_lob.copy(tempResult,l_result

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

1716: IF l_rows_processed <> 0 THEN
1717: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' l_xml_header_length ' || l_xml_header_length);
1718: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1719: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1723: dbms_lob.copy(tempResult,l_result
1724: ,dbms_lob.getlength(l_result)-l_resultOffset

Line 1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );

1718: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1719: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1723: dbms_lob.copy(tempResult,l_result
1724: ,dbms_lob.getlength(l_result)-l_resultOffset
1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE

Line 1723: dbms_lob.copy(tempResult,l_result

1719: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1723: dbms_lob.copy(tempResult,l_result
1724: ,dbms_lob.getlength(l_result)-l_resultOffset
1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE
1727: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

1720: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1721:
1722: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1723: dbms_lob.copy(tempResult,l_result
1724: ,dbms_lob.getlength(l_result)-l_resultOffset
1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE
1727: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1728: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

1723: dbms_lob.copy(tempResult,l_result
1724: ,dbms_lob.getlength(l_result)-l_resultOffset
1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE
1727: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1728: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1729: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1730: END IF;
1731:

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

1724: ,dbms_lob.getlength(l_result)-l_resultOffset
1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE
1727: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1728: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1729: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1730: END IF;
1731:
1732: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

1725: ,l_xml_header_length,l_resultOffset);
1726: ELSE
1727: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1728: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1729: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1730: END IF;
1731:
1732: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1733: p_AgreementXML := tempResult;

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

1728: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1729: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1730: END IF;
1731:
1732: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1733: p_AgreementXML := tempResult;
1734: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1735: EXCEPTION
1736: WHEN OTHERS THEN

Line 1754: l_clob_size := dbms_lob.getlength(p_clob);

1750: BEGIN
1751:
1752: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1753: -- get length of internal lob and open the dest. file.
1754: l_clob_size := dbms_lob.getlength(p_clob);
1755:
1756: IF (l_clob_size = 0) THEN
1757: LogMessage(FND_LOG.LEVEL_PROCEDURE,'CLOB is empty');
1758: RETURN;

Line 1783: l_chunk := dbms_lob.substr (p_clob, l_chunk_size, l_offset);

1779: WHILE (l_clob_size > 0) LOOP
1780:
1781: -- LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1782:
1783: l_chunk := dbms_lob.substr (p_clob, l_chunk_size, l_offset);
1784:
1785: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1786: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'l_chunk ' || l_chunk);
1787: