APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on DBMS_LOB

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

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

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

193: WHILE (l_clob_size > 0) LOOP
194:
195: -- debug('Off Set: ' || l_offset);
196:
197: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);
198:
199: -- debug('Off Set: ' || l_offset);
200: -- debug(l_chunk);
201:

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

1951:
1952: debug('XML generation done: ' || l_rows_processed);
1953:
1954: IF l_rows_processed <> 0 THEN
1955: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1956: tempResult := l_result;
1957: ELSE
1958: l_resultOffset := 0;
1959: END IF;

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

2003:
2004: debug('Header created');
2005:
2006: IF l_rows_processed <> 0 THEN
2007: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2008: dbms_lob.copy(tempResult, l_result,
2009: dbms_lob.getlength(l_result)-l_resultOffset,
2010: l_xml_header_length,l_resultOffset);
2011: ELSE

Line 2008: dbms_lob.copy(tempResult, l_result,

2004: debug('Header created');
2005:
2006: IF l_rows_processed <> 0 THEN
2007: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2008: dbms_lob.copy(tempResult, l_result,
2009: dbms_lob.getlength(l_result)-l_resultOffset,
2010: l_xml_header_length,l_resultOffset);
2011: ELSE
2012: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

2005:
2006: IF l_rows_processed <> 0 THEN
2007: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2008: dbms_lob.copy(tempResult, l_result,
2009: dbms_lob.getlength(l_result)-l_resultOffset,
2010: l_xml_header_length,l_resultOffset);
2011: ELSE
2012: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2013: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

2008: dbms_lob.copy(tempResult, l_result,
2009: dbms_lob.getlength(l_result)-l_resultOffset,
2010: l_xml_header_length,l_resultOffset);
2011: ELSE
2012: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2013: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2014: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2015: END IF;
2016:

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

2009: dbms_lob.getlength(l_result)-l_resultOffset,
2010: l_xml_header_length,l_resultOffset);
2011: ELSE
2012: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2013: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2014: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2015: END IF;
2016:
2017: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

2010: l_xml_header_length,l_resultOffset);
2011: ELSE
2012: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2013: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2014: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2015: END IF;
2016:
2017: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2018: process_clob(tempResult);

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

2013: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2014: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2015: END IF;
2016:
2017: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2018: process_clob(tempResult);
2019: p_result := tempResult;
2020:
2021: debug('ar_cumulative_balance_report.generate_xml()-');