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

Line 185: l_clob_size := dbms_lob.getlength(p_xml_clob);

181:
182: debug('ar_cumulative_balance_report.process_clob(+)');
183:
184: -- get length of internal lob and open the dest. file.
185: l_clob_size := dbms_lob.getlength(p_xml_clob);
186:
187: IF (l_clob_size = 0) THEN
188: debug('CLOB is empty');
189: RETURN;

Line 201: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);

197: WHILE (l_clob_size > 0) LOOP
198:
199: -- debug('Off Set: ' || l_offset);
200:
201: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);
202:
203: --debug('Off Set: ' || l_offset);
204: --debug(l_chunk);
205:

Line 208: l_offset_temp := DBMS_LOB.INSTR(l_chunk,'

204: --debug(l_chunk);
205:
206: -- Bug 6696706 - As per input from fnd bug 6868010 this is modified
207:
208: l_offset_temp := DBMS_LOB.INSTR(l_chunk,' 209: /* added to fix bug 13987673 - begin */
210: if l_offset_temp = 0 then
211: l_offset_temp := 1;
212: end if;

Line 214: l_offset_temp := DBMS_LOB.INSTR(l_chunk,'>',l_offset_temp,1);

210: if l_offset_temp = 0 then
211: l_offset_temp := 1;
212: end if;
213: /* added to fix bug 13987673 - end */
214: l_offset_temp := DBMS_LOB.INSTR(l_chunk,'>',l_offset_temp,1);
215: l_chunk1 := dbms_lob.substr (l_chunk, l_offset_temp, 1);
216: l_chunk2 := dbms_lob.substr (l_chunk, l_chunk_size-l_offset_temp, l_offset_temp+1);
217:
218: fnd_file.put(

Line 215: l_chunk1 := dbms_lob.substr (l_chunk, l_offset_temp, 1);

211: l_offset_temp := 1;
212: end if;
213: /* added to fix bug 13987673 - end */
214: l_offset_temp := DBMS_LOB.INSTR(l_chunk,'>',l_offset_temp,1);
215: l_chunk1 := dbms_lob.substr (l_chunk, l_offset_temp, 1);
216: l_chunk2 := dbms_lob.substr (l_chunk, l_chunk_size-l_offset_temp, l_offset_temp+1);
217:
218: fnd_file.put(
219: which => fnd_file.output,

Line 216: l_chunk2 := dbms_lob.substr (l_chunk, l_chunk_size-l_offset_temp, l_offset_temp+1);

212: end if;
213: /* added to fix bug 13987673 - end */
214: l_offset_temp := DBMS_LOB.INSTR(l_chunk,'>',l_offset_temp,1);
215: l_chunk1 := dbms_lob.substr (l_chunk, l_offset_temp, 1);
216: l_chunk2 := dbms_lob.substr (l_chunk, l_chunk_size-l_offset_temp, l_offset_temp+1);
217:
218: fnd_file.put(
219: which => fnd_file.output,
220: buff => l_chunk1);

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

1980:
1981: debug('XML generation done: ' || l_rows_processed);
1982:
1983: IF l_rows_processed <> 0 THEN
1984: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1985: tempResult := l_result;
1986: ELSE
1987: l_resultOffset := 0;
1988: END IF;

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

2032:
2033: debug('Header created');
2034:
2035: IF l_rows_processed <> 0 THEN
2036: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2037: dbms_lob.copy(tempResult, l_result,
2038: dbms_lob.getlength(l_result)-l_resultOffset,
2039: l_xml_header_length,l_resultOffset);
2040: ELSE

Line 2037: dbms_lob.copy(tempResult, l_result,

2033: debug('Header created');
2034:
2035: IF l_rows_processed <> 0 THEN
2036: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2037: dbms_lob.copy(tempResult, l_result,
2038: dbms_lob.getlength(l_result)-l_resultOffset,
2039: l_xml_header_length,l_resultOffset);
2040: ELSE
2041: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

2034:
2035: IF l_rows_processed <> 0 THEN
2036: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2037: dbms_lob.copy(tempResult, l_result,
2038: dbms_lob.getlength(l_result)-l_resultOffset,
2039: l_xml_header_length,l_resultOffset);
2040: ELSE
2041: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2042: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

2037: dbms_lob.copy(tempResult, l_result,
2038: dbms_lob.getlength(l_result)-l_resultOffset,
2039: l_xml_header_length,l_resultOffset);
2040: ELSE
2041: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2042: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2043: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2044: END IF;
2045:

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

2038: dbms_lob.getlength(l_result)-l_resultOffset,
2039: l_xml_header_length,l_resultOffset);
2040: ELSE
2041: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2042: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2043: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2044: END IF;
2045:
2046: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

2039: l_xml_header_length,l_resultOffset);
2040: ELSE
2041: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2042: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2043: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2044: END IF;
2045:
2046: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2047: process_clob(tempResult);

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

2042: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2043: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2044: END IF;
2045:
2046: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2047: process_clob(tempResult);
2048: p_result := tempResult;
2049:
2050: debug('ar_cumulative_balance_report.generate_xml()-');