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

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

74: END IF;
75:
76: -- Initialze variables for storing XML Data
77:
78: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
79:
80: /*Bug 7305146*/
81: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
82: l_xml_header := '';

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

79:
80: /*Bug 7305146*/
81: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
82: l_xml_header := '';
83: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
84:
85: DBMS_LOB.writeappend (l_xml_doc, 8, '');
86:
87: -- Initialize message stack

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

81: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
82: l_xml_header := '';
83: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
84:
85: DBMS_LOB.writeappend (l_xml_doc, 8, '');
86:
87: -- Initialize message stack
88: FND_MSG_PUB.initialize;
89:

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

142: END IF;
143:
144: -- write the closing tag to the XML data
145:
146: DBMS_LOB.writeappend (l_xml_doc, 9, '');
147:
148: -- write xml data to the output file
149:
150: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

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

146: DBMS_LOB.writeappend (l_xml_doc, 9, '');
147:
148: -- write xml data to the output file
149:
150: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
151: LOOP
152: EXIT WHEN l_length <= 0;
153: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
154: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);

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

149:
150: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
151: LOOP
152: EXIT WHEN l_length <= 0;
153: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
154: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);
155: l_length := l_length - l_amount;
156: l_offset := l_offset + l_amount;
157: END LOOP;

Line 170: DBMS_LOB.FREETEMPORARY (l_xml_doc);

166:
167: -- free temporary memory
168:
169: DBMS_XMLGEN.closeContext(l_qryCtx);
170: DBMS_LOB.FREETEMPORARY (l_xml_doc);
171:
172: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
173:
174: -- Write the module name to fnd log file

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

298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: -- Initialize temporary variable to hold xml data
301:
302: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
303: l_offset := 21;
304:
305: -- select the operating unit for which the program is launched.
306:

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

373:
374: -- remove the header (21 characters) and append the rest to xml output
375:
376: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
377: DBMS_LOB.erase (l_xml_temp, l_offset,1);
378: DBMS_LOB.append (x_xml_doc, l_xml_temp);
379: END IF;
380:
381: -- close context and free memory

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

374: -- remove the header (21 characters) and append the rest to xml output
375:
376: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
377: DBMS_LOB.erase (l_xml_temp, l_offset,1);
378: DBMS_LOB.append (x_xml_doc, l_xml_temp);
379: END IF;
380:
381: -- close context and free memory
382:

Line 385: DBMS_LOB.FREETEMPORARY (l_xml_temp);

381: -- close context and free memory
382:
383: DBMS_XMLGEN.closeContext(l_qryCtx);
384: CLOSE l_ref_cur;
385: DBMS_LOB.FREETEMPORARY (l_xml_temp);
386:
387: -- Standard call to get message count and if count is 1, get message info.
388:
389: FND_MSG_PUB.Count_And_Get

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

504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Initialize temporary variable to hold xml data
507:
508: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
509: l_offset := 21;
510:
511: -- select the operating unit for which the program is launched.
512:

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

666:
667: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
668:
669: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
670: DBMS_LOB.erase (l_xml_temp, l_offset,1);
671: DBMS_LOB.append (x_xml_doc, l_xml_temp);
672: END IF;
673:
674: -- close context and free memory

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

667: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
668:
669: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
670: DBMS_LOB.erase (l_xml_temp, l_offset,1);
671: DBMS_LOB.append (x_xml_doc, l_xml_temp);
672: END IF;
673:
674: -- close context and free memory
675:

Line 678: DBMS_LOB.FREETEMPORARY (l_xml_temp);

674: -- close context and free memory
675:
676: DBMS_XMLGEN.closeContext(l_qryCtx);
677: CLOSE l_ref_cur;
678: DBMS_LOB.FREETEMPORARY (l_xml_temp);
679:
680: -- to add number of rows processed
681:
682: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

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

678: DBMS_LOB.FREETEMPORARY (l_xml_temp);
679:
680: -- to add number of rows processed
681:
682: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
683:
684: -- open ref cursor to add number of rows processed
685:
686: l_stmt_num := 60;

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

704:
705: -- remove the header (21 characters) and append the rest to xml output
706:
707: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
708: DBMS_LOB.erase (l_xml_temp, l_offset,1);
709: DBMS_LOB.append (x_xml_doc, l_xml_temp);
710: END IF;
711:
712: -- close context and free memory

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

705: -- remove the header (21 characters) and append the rest to xml output
706:
707: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
708: DBMS_LOB.erase (l_xml_temp, l_offset,1);
709: DBMS_LOB.append (x_xml_doc, l_xml_temp);
710: END IF;
711:
712: -- close context and free memory
713:

Line 716: DBMS_LOB.FREETEMPORARY (l_xml_temp);

712: -- close context and free memory
713:
714: DBMS_XMLGEN.closeContext(l_qryCtx);
715: CLOSE l_ref_cur;
716: DBMS_LOB.FREETEMPORARY (l_xml_temp);
717:
718: -- Standard call to get message count and if count is 1, get message info.
719:
720: FND_MSG_PUB.Count_And_Get