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

Line 118: DBMS_LOB.createtemporary(l_xml_doc, TRUE);

114: End If;
115:
116: -- Initialze variables for storing XML Data
117:
118: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
119:
120: /*Bug 7305146*/
121: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
122: l_xml_header := '';

Line 123: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);

119:
120: /*Bug 7305146*/
121: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
122: l_xml_header := '';
123: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
124:
125: DBMS_LOB.writeappend (l_xml_doc, 8, '');
126:
127: -- convert from date parameter to date type variable

Line 125: DBMS_LOB.writeappend (l_xml_doc, 8, '');

121: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
122: l_xml_header := '';
123: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
124:
125: DBMS_LOB.writeappend (l_xml_doc, 8, '');
126:
127: -- convert from date parameter to date type variable
128:
129: l_stmt_num := 30;

Line 222: DBMS_LOB.writeappend (l_xml_doc, 9, '');

218: END IF;
219:
220: -- write the closing tag to the XML data
221:
222: DBMS_LOB.writeappend (l_xml_doc, 9, '');
223:
224: -- write xml data to the output file
225:
226: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

Line 226: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

222: DBMS_LOB.writeappend (l_xml_doc, 9, '');
223:
224: -- write xml data to the output file
225:
226: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
227: LOOP
228: EXIT WHEN l_length <= 0;
229: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
230: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);

Line 229: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);

225:
226: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
227: LOOP
228: EXIT WHEN l_length <= 0;
229: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
230: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);
231: l_length := l_length - l_amount;
232: l_offset := l_offset + l_amount;
233: END LOOP;

Line 246: DBMS_LOB.FREETEMPORARY (l_xml_doc);

242: 'Completed writing to output file');
243: END IF;
244:
245: -- free temporary memory
246: DBMS_LOB.FREETEMPORARY (l_xml_doc);
247:
248: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
249:
250: -- Write the module name to fnd log file

Line 415: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412:
413: -- Initialize temporary variable to hold xml data
414:
415: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
416: l_offset := 21;
417:
418: -- select the operating unit for which the program is launched.
419:

Line 519: DBMS_LOB.erase (l_xml_temp, l_offset,1);

515:
516: -- remove the header (21 characters) and append the rest to xml output
517:
518: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
519: DBMS_LOB.erase (l_xml_temp, l_offset,1);
520: DBMS_LOB.append (x_xml_doc, l_xml_temp);
521: END IF;
522:
523: -- close context and free memory

Line 520: DBMS_LOB.append (x_xml_doc, l_xml_temp);

516: -- remove the header (21 characters) and append the rest to xml output
517:
518: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
519: DBMS_LOB.erase (l_xml_temp, l_offset,1);
520: DBMS_LOB.append (x_xml_doc, l_xml_temp);
521: END IF;
522:
523: -- close context and free memory
524:

Line 527: DBMS_LOB.FREETEMPORARY (l_xml_temp);

523: -- close context and free memory
524:
525: DBMS_XMLGEN.closeContext(l_qryCtx);
526: CLOSE l_ref_cur;
527: DBMS_LOB.FREETEMPORARY (l_xml_temp);
528:
529: -- Standard call to get message count and if count is 1, get message info.
530:
531: FND_MSG_PUB.Count_And_Get

Line 657: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

653: x_return_status := FND_API.G_RET_STS_SUCCESS;
654:
655: -- Initialize temporary variable to hold xml data
656:
657: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
658: l_offset := 21;
659:
660: -- select the operating unit for which the program is launched.
661:

Line 900: DBMS_LOB.erase (l_xml_temp, l_offset,1);

896:
897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
898:
899: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
900: DBMS_LOB.erase (l_xml_temp, l_offset,1);
901: DBMS_LOB.append (x_xml_doc, l_xml_temp);
902: END IF;
903:
904: -- close context and free memory

Line 901: DBMS_LOB.append (x_xml_doc, l_xml_temp);

897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
898:
899: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
900: DBMS_LOB.erase (l_xml_temp, l_offset,1);
901: DBMS_LOB.append (x_xml_doc, l_xml_temp);
902: END IF;
903:
904: -- close context and free memory
905:

Line 908: DBMS_LOB.FREETEMPORARY (l_xml_temp);

904: -- close context and free memory
905:
906: DBMS_XMLGEN.closeContext(l_qryCtx);
907: CLOSE l_ref_cur;
908: DBMS_LOB.FREETEMPORARY (l_xml_temp);
909:
910: -- to add number of rows processed
911:
912: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 912: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

908: DBMS_LOB.FREETEMPORARY (l_xml_temp);
909:
910: -- to add number of rows processed
911:
912: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
913:
914: -- open ref cursor to add number of rows processed
915:
916: l_stmt_num := 60;

Line 938: DBMS_LOB.erase (l_xml_temp, l_offset,1);

934:
935: -- remove the header (21 characters) and append the rest to xml output
936:
937: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
938: DBMS_LOB.erase (l_xml_temp, l_offset,1);
939: DBMS_LOB.append (x_xml_doc, l_xml_temp);
940: END IF;
941:
942: -- close context and free memory

Line 939: DBMS_LOB.append (x_xml_doc, l_xml_temp);

935: -- remove the header (21 characters) and append the rest to xml output
936:
937: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
938: DBMS_LOB.erase (l_xml_temp, l_offset,1);
939: DBMS_LOB.append (x_xml_doc, l_xml_temp);
940: END IF;
941:
942: -- close context and free memory
943:

Line 946: DBMS_LOB.FREETEMPORARY (l_xml_temp);

942: -- close context and free memory
943:
944: DBMS_XMLGEN.closeContext(l_qryCtx);
945: CLOSE l_ref_cur;
946: DBMS_LOB.FREETEMPORARY (l_xml_temp);
947:
948: -- Standard call to get message count and if count is 1, get message info.
949:
950: FND_MSG_PUB.Count_And_Get