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

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

113: END IF;
114:
115: -- Initialze variables for storing XML Data
116:
117: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
118:
119: /*Bug 7000786 - This fix ensures that XML data generated here uses the right encoding*/
120: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
121: l_xml_header := '';

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

118:
119: /*Bug 7000786 - This fix ensures that XML data generated here uses the right encoding*/
120: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
121: l_xml_header := '';
122: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
123:
124: DBMS_LOB.writeappend (l_xml_doc, 8, '');
125:
126: -- Initialize message stack

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

120: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
121: l_xml_header := '';
122: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
123:
124: DBMS_LOB.writeappend (l_xml_doc, 8, '');
125:
126: -- Initialize message stack
127:
128: FND_MSG_PUB.initialize;

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

199: END IF;
200:
201: -- write the closing tag to the XML data
202:
203: DBMS_LOB.writeappend (l_xml_doc, 9, '');
204:
205: -- write xml data to the output file
206:
207: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

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

203: DBMS_LOB.writeappend (l_xml_doc, 9, '');
204:
205: -- write xml data to the output file
206:
207: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
208: LOOP
209: EXIT WHEN l_length <= 0;
210: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
211: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);

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

206:
207: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
208: LOOP
209: EXIT WHEN l_length <= 0;
210: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
211: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);
212: l_length := l_length - l_amount;
213: l_offset := l_offset + l_amount;
214: END LOOP;

Line 228: DBMS_LOB.FREETEMPORARY (l_xml_doc);

224: END IF;
225:
226: -- free temporary memory
227:
228: DBMS_LOB.FREETEMPORARY (l_xml_doc);
229:
230: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
231:
232: -- Write the module name to fnd log file

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

393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: -- Initialize temporary variable to hold xml data
396:
397: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
398: l_offset := 21;
399:
400: l_stmt_num := 10;
401:

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

496:
497: -- remove the header (21 characters) and append the rest to xml output
498:
499: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
500: DBMS_LOB.erase (l_xml_temp, l_offset,1);
501: DBMS_LOB.append (x_xml_doc, l_xml_temp);
502: END IF;
503:
504: -- close context and free memory

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

497: -- remove the header (21 characters) and append the rest to xml output
498:
499: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
500: DBMS_LOB.erase (l_xml_temp, l_offset,1);
501: DBMS_LOB.append (x_xml_doc, l_xml_temp);
502: END IF;
503:
504: -- close context and free memory
505:

Line 508: DBMS_LOB.FREETEMPORARY (l_xml_temp);

504: -- close context and free memory
505:
506: DBMS_XMLGEN.closeContext(l_qryCtx);
507: CLOSE l_ref_cur;
508: DBMS_LOB.FREETEMPORARY (l_xml_temp);
509:
510: -- Standard call to get message count and if count is 1, get message info.
511:
512: FND_MSG_PUB.Count_And_Get

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

642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: -- Initialize temporary variable to hold xml data
645:
646: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
647: l_offset := 21;
648:
649: -- select the operating unit for which the program is launched.
650:

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

948:
949: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
950:
951: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
952: DBMS_LOB.erase (l_xml_temp, l_offset,1);
953: DBMS_LOB.append (x_xml_doc, l_xml_temp);
954: END IF;
955:
956: -- close context and free memory

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

949: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
950:
951: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
952: DBMS_LOB.erase (l_xml_temp, l_offset,1);
953: DBMS_LOB.append (x_xml_doc, l_xml_temp);
954: END IF;
955:
956: -- close context and free memory
957:

Line 960: DBMS_LOB.FREETEMPORARY (l_xml_temp);

956: -- close context and free memory
957:
958: DBMS_XMLGEN.closeContext(l_qryCtx);
959: CLOSE l_ref_cur;
960: DBMS_LOB.FREETEMPORARY (l_xml_temp);
961:
962: -- to add number of rows processed
963:
964: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

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

960: DBMS_LOB.FREETEMPORARY (l_xml_temp);
961:
962: -- to add number of rows processed
963:
964: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
965:
966: -- open ref cursor to get the number of rows processed
967:
968: l_stmt_num := 90;

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

985:
986: -- remove the header (21 characters) and append the rest to xml output
987:
988: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
989: DBMS_LOB.erase (l_xml_temp, l_offset,1);
990: DBMS_LOB.append (x_xml_doc, l_xml_temp);
991: END IF;
992:
993: -- close context and free memory

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

986: -- remove the header (21 characters) and append the rest to xml output
987:
988: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
989: DBMS_LOB.erase (l_xml_temp, l_offset,1);
990: DBMS_LOB.append (x_xml_doc, l_xml_temp);
991: END IF;
992:
993: -- close context and free memory
994:

Line 997: DBMS_LOB.FREETEMPORARY (l_xml_temp);

993: -- close context and free memory
994:
995: DBMS_XMLGEN.closeContext(l_qryCtx);
996: CLOSE l_ref_cur;
997: DBMS_LOB.FREETEMPORARY (l_xml_temp);
998:
999: -- Standard call to get message count and if count is 1, get message info.
1000:
1001: FND_MSG_PUB.Count_And_Get