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

Line 5317: dbms_lob.createtemporary(l_xml_doc, TRUE);

5313: END IF;
5314:
5315: -- Initialze variables for storing XML Data
5316:
5317: dbms_lob.createtemporary(l_xml_doc, TRUE);
5318:
5319: /*Bug 7305146*/
5320: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5321: l_xml_header := '';

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

5318:
5319: /*Bug 7305146*/
5320: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5321: l_xml_header := '';
5322: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5323:
5324: dbms_lob.writeappend (l_xml_doc, 8, '');
5325:
5326: -- Initialize message stack

Line 5324: dbms_lob.writeappend (l_xml_doc, 8, '');

5320: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5321: l_xml_header := '';
5322: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5323:
5324: dbms_lob.writeappend (l_xml_doc, 8, '');
5325:
5326: -- Initialize message stack
5327:
5328: fnd_msg_pub.initialize;

Line 5424: dbms_lob.writeappend (l_xml_doc, 9, '');

5420: end if;
5421:
5422: -- write the closing tag to the XML data
5423:
5424: dbms_lob.writeappend (l_xml_doc, 9, '');
5425:
5426: -- write xml data to the output file
5427:
5428: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

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

5424: dbms_lob.writeappend (l_xml_doc, 9, '');
5425:
5426: -- write xml data to the output file
5427:
5428: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
5429: loop
5430: exit when l_length <= 0;
5431: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
5432: fnd_file.put(fnd_file.output, l_buffer);

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

5427:
5428: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
5429: loop
5430: exit when l_length <= 0;
5431: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
5432: fnd_file.put(fnd_file.output, l_buffer);
5433: l_length := l_length - l_amount;
5434: l_offset := l_offset + l_amount;
5435: end loop;

Line 5448: dbms_lob.freetemporary(l_xml_doc);

5444: end if;
5445:
5446: -- free temporary memory
5447:
5448: dbms_lob.freetemporary(l_xml_doc);
5449:
5450: l_success := fnd_concurrent.set_completion_status('NORMAL', 'Request Completed Successfully');
5451:
5452: -- Write the module name to fnd log file

Line 5636: dbms_lob.createtemporary(l_xml_temp, TRUE);

5632: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5633:
5634: -- Initialize temporary variable to hold xml data
5635:
5636: dbms_lob.createtemporary(l_xml_temp, TRUE);
5637: l_offset := 21;
5638:
5639: -- Get the proile value to determine the aging basis
5640:

Line 5732: dbms_lob.erase (l_xml_temp, l_offset,1);

5728:
5729: -- remove the header (21 characters) and append the rest to xml output
5730:
5731: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
5732: dbms_lob.erase (l_xml_temp, l_offset,1);
5733: dbms_lob.append (x_xml_doc, l_xml_temp);
5734: end if;
5735:
5736: -- close context and free memory

Line 5733: dbms_lob.append (x_xml_doc, l_xml_temp);

5729: -- remove the header (21 characters) and append the rest to xml output
5730:
5731: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
5732: dbms_lob.erase (l_xml_temp, l_offset,1);
5733: dbms_lob.append (x_xml_doc, l_xml_temp);
5734: end if;
5735:
5736: -- close context and free memory
5737:

Line 5741: dbms_lob.freetemporary(l_xml_temp);

5737:
5738: dbms_xmlgen.closeContext(l_qryCtx);
5739: close l_ref_cur;
5740:
5741: dbms_lob.freetemporary(l_xml_temp);
5742:
5743: -- Standard call to get message count and if count is 1, get message info.
5744:
5745: fnd_msg_pub.Count_And_Get

Line 5911: dbms_lob.createtemporary(l_xml_temp, TRUE);

5907: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5908:
5909: -- Initialize temporary variable to hold xml data
5910:
5911: dbms_lob.createtemporary(l_xml_temp, TRUE);
5912: l_offset := 21;
5913:
5914: -- open ref cur to fetch Deferred COGS data
5915:

Line 6358: dbms_lob.erase(l_xml_temp, l_offset,1);

6354:
6355: l_count := dbms_xmlgen.getNumRowsProcessed(l_qryCtx);
6356:
6357: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
6358: dbms_lob.erase(l_xml_temp, l_offset,1);
6359: dbms_lob.append(x_xml_doc, l_xml_temp);
6360: end if;
6361:
6362: -- close context and free memory

Line 6359: dbms_lob.append(x_xml_doc, l_xml_temp);

6355: l_count := dbms_xmlgen.getNumRowsProcessed(l_qryCtx);
6356:
6357: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
6358: dbms_lob.erase(l_xml_temp, l_offset,1);
6359: dbms_lob.append(x_xml_doc, l_xml_temp);
6360: end if;
6361:
6362: -- close context and free memory
6363:

Line 6366: dbms_lob.freetemporary(l_xml_temp);

6362: -- close context and free memory
6363:
6364: dbms_xmlgen.closeContext(l_qryCtx);
6365: close l_ref_cur;
6366: dbms_lob.freetemporary(l_xml_temp);
6367:
6368: -- to add number of rows processed
6369:
6370: dbms_lob.createtemporary(l_xml_temp, TRUE);

Line 6370: dbms_lob.createtemporary(l_xml_temp, TRUE);

6366: dbms_lob.freetemporary(l_xml_temp);
6367:
6368: -- to add number of rows processed
6369:
6370: dbms_lob.createtemporary(l_xml_temp, TRUE);
6371:
6372: -- open ref cursor to get the number of rows processed
6373:
6374: l_stmt_num := 80;

Line 6397: dbms_lob.erase (l_xml_temp, l_offset,1);

6393:
6394: -- remove the header (21 characters) and append the rest to xml output
6395:
6396: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0 ) then
6397: dbms_lob.erase (l_xml_temp, l_offset,1);
6398: dbms_lob.append (x_xml_doc, l_xml_temp);
6399: end if;
6400:
6401: -- close context and free memory

Line 6398: dbms_lob.append (x_xml_doc, l_xml_temp);

6394: -- remove the header (21 characters) and append the rest to xml output
6395:
6396: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0 ) then
6397: dbms_lob.erase (l_xml_temp, l_offset,1);
6398: dbms_lob.append (x_xml_doc, l_xml_temp);
6399: end if;
6400:
6401: -- close context and free memory
6402:

Line 6405: dbms_lob.freetemporary(l_xml_temp);

6401: -- close context and free memory
6402:
6403: dbms_xmlgen.closeContext(l_qryCtx);
6404: close l_ref_cur;
6405: dbms_lob.freetemporary(l_xml_temp);
6406:
6407: -- Standard call to get message count and if count is 1, get message info.
6408:
6409: fnd_msg_pub.Count_And_Get