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 5436: dbms_lob.createtemporary(l_xml_doc, TRUE);

5432: -- END IF;
5433:
5434: -- Initialze variables for storing XML Data
5435:
5436: dbms_lob.createtemporary(l_xml_doc, TRUE);
5437:
5438: /*Bug 7305146*/
5439: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5440: l_xml_header := '';

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

5437:
5438: /*Bug 7305146*/
5439: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5440: l_xml_header := '';
5441: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5442:
5443: dbms_lob.writeappend (l_xml_doc, 8, '');
5444:
5445: -- Initialize message stack

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

5439: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5440: l_xml_header := '';
5441: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5442:
5443: dbms_lob.writeappend (l_xml_doc, 8, '');
5444:
5445: -- Initialize message stack
5446:
5447: fnd_msg_pub.initialize;

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

5541: end if;
5542:
5543: -- write the closing tag to the XML data
5544:
5545: dbms_lob.writeappend (l_xml_doc, 9, '');
5546:
5547: -- write xml data to the output file
5548:
5549: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);

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

5545: dbms_lob.writeappend (l_xml_doc, 9, '');
5546:
5547: -- write xml data to the output file
5548:
5549: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
5550: loop
5551: exit when l_length <= 0;
5552: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
5553: fnd_file.put(fnd_file.output, l_buffer);

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

5548:
5549: l_length := nvl(dbms_lob.getlength(l_xml_doc),0);
5550: loop
5551: exit when l_length <= 0;
5552: dbms_lob.read (l_xml_doc, l_amount, l_offset, l_buffer);
5553: fnd_file.put(fnd_file.output, l_buffer);
5554: l_length := l_length - l_amount;
5555: l_offset := l_offset + l_amount;
5556: end loop;

Line 5566: dbms_lob.freetemporary(l_xml_doc);

5562: debug(l_stmt_num||'-Completed writing to output file');
5563:
5564: -- free temporary memory
5565:
5566: dbms_lob.freetemporary(l_xml_doc);
5567:
5568: l_success := fnd_concurrent.set_completion_status('NORMAL', 'Request Completed Successfully');
5569:
5570: -- Write the module name to fnd log file

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

5747: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5748:
5749: -- Initialize temporary variable to hold xml data
5750:
5751: dbms_lob.createtemporary(l_xml_temp, TRUE);
5752: l_offset := 21;
5753:
5754: -- Get the proile value to determine the aging basis
5755:

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

5845:
5846: -- remove the header (21 characters) and append the rest to xml output
5847:
5848: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
5849: dbms_lob.erase (l_xml_temp, l_offset,1);
5850: dbms_lob.append (x_xml_doc, l_xml_temp);
5851: end if;
5852:
5853: -- close context and free memory

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

5846: -- remove the header (21 characters) and append the rest to xml output
5847:
5848: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
5849: dbms_lob.erase (l_xml_temp, l_offset,1);
5850: dbms_lob.append (x_xml_doc, l_xml_temp);
5851: end if;
5852:
5853: -- close context and free memory
5854:

Line 5858: dbms_lob.freetemporary(l_xml_temp);

5854:
5855: dbms_xmlgen.closeContext(l_qryCtx);
5856: close l_ref_cur;
5857:
5858: dbms_lob.freetemporary(l_xml_temp);
5859:
5860: -- Standard call to get message count and if count is 1, get message info.
5861:
5862: fnd_msg_pub.Count_And_Get

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

6022: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6023:
6024: -- Initialize temporary variable to hold xml data
6025:
6026: dbms_lob.createtemporary(l_xml_temp, TRUE);
6027: l_offset := 21;
6028:
6029: -- open ref cur to fetch Deferred COGS data
6030:

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

6691:
6692: l_count := dbms_xmlgen.getNumRowsProcessed(l_qryCtx);
6693:
6694: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
6695: dbms_lob.erase(l_xml_temp, l_offset,1);
6696: dbms_lob.append(x_xml_doc, l_xml_temp);
6697: end if;
6698:
6699: -- close context and free memory

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

6692: l_count := dbms_xmlgen.getNumRowsProcessed(l_qryCtx);
6693:
6694: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0) then
6695: dbms_lob.erase(l_xml_temp, l_offset,1);
6696: dbms_lob.append(x_xml_doc, l_xml_temp);
6697: end if;
6698:
6699: -- close context and free memory
6700:

Line 6703: dbms_lob.freetemporary(l_xml_temp);

6699: -- close context and free memory
6700:
6701: dbms_xmlgen.closeContext(l_qryCtx);
6702: close l_ref_cur;
6703: dbms_lob.freetemporary(l_xml_temp);
6704:
6705: -- to add number of rows processed
6706:
6707: dbms_lob.createtemporary(l_xml_temp, TRUE);

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

6703: dbms_lob.freetemporary(l_xml_temp);
6704:
6705: -- to add number of rows processed
6706:
6707: dbms_lob.createtemporary(l_xml_temp, TRUE);
6708:
6709: -- open ref cursor to get the number of rows processed
6710:
6711: l_stmt_num := 80;

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

6730:
6731: -- remove the header (21 characters) and append the rest to xml output
6732:
6733: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0 ) then
6734: dbms_lob.erase (l_xml_temp, l_offset,1);
6735: dbms_lob.append (x_xml_doc, l_xml_temp);
6736: end if;
6737:
6738: -- close context and free memory

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

6731: -- remove the header (21 characters) and append the rest to xml output
6732:
6733: if(dbms_xmlgen.getNumRowsProcessed(l_qryCtx) > 0 ) then
6734: dbms_lob.erase (l_xml_temp, l_offset,1);
6735: dbms_lob.append (x_xml_doc, l_xml_temp);
6736: end if;
6737:
6738: -- close context and free memory
6739:

Line 6742: dbms_lob.freetemporary(l_xml_temp);

6738: -- close context and free memory
6739:
6740: dbms_xmlgen.closeContext(l_qryCtx);
6741: close l_ref_cur;
6742: dbms_lob.freetemporary(l_xml_temp);
6743:
6744: -- Standard call to get message count and if count is 1, get message info.
6745:
6746: fnd_msg_pub.Count_And_Get