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

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

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

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

78: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
79: /*Bug 7305146*/
80: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
81: l_xml_header := '';
82: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
83:
84: DBMS_LOB.writeappend (l_xml_doc, 8, '');
85:
86: -- convert from date parameter to date type variable

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

80: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
81: l_xml_header := '';
82: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
83:
84: DBMS_LOB.writeappend (l_xml_doc, 8, '');
85:
86: -- convert from date parameter to date type variable
87:
88: l_stmt_num := 10;

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

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

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

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

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

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

Line 245: DBMS_LOB.FREETEMPORARY (l_xml_doc);

241: 'Completed writing to output file');
242: END IF;
243:
244: -- free temporary memory and close the context
245: DBMS_LOB.FREETEMPORARY (l_xml_doc);
246:
247: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
248:
249: -- 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: l_stmt_num := 10;
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 661: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- Initialize temporary variable to hold xml data
660:
661: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
662: l_offset := 21;
663:
664: l_stmt_num := 5;
665:

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

925:
926: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
927:
928: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
929: DBMS_LOB.erase (l_xml_temp, l_offset,1);
930: DBMS_LOB.append (x_xml_doc, l_xml_temp);
931: END IF;
932:
933:

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

926: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
927:
928: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
929: DBMS_LOB.erase (l_xml_temp, l_offset,1);
930: DBMS_LOB.append (x_xml_doc, l_xml_temp);
931: END IF;
932:
933:
934: -- close context and free memory

Line 938: DBMS_LOB.FREETEMPORARY (l_xml_temp);

934: -- close context and free memory
935:
936: DBMS_XMLGEN.closeContext(l_qryCtx);
937: CLOSE l_ref_cur;
938: DBMS_LOB.FREETEMPORARY (l_xml_temp);
939:
940: -- to add number of rows processed
941:
942: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

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

938: DBMS_LOB.FREETEMPORARY (l_xml_temp);
939:
940: -- to add number of rows processed
941:
942: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
943:
944: -- open ref cursor to get the number of rows processed
945:
946: l_stmt_num := 70;

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

963:
964: -- remove the header (21 characters) and append the rest to xml output
965:
966: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
967: DBMS_LOB.erase (l_xml_temp, l_offset,1);
968: DBMS_LOB.append (x_xml_doc, l_xml_temp);
969: END IF;
970:
971: -- close context and free memory

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

964: -- remove the header (21 characters) and append the rest to xml output
965:
966: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
967: DBMS_LOB.erase (l_xml_temp, l_offset,1);
968: DBMS_LOB.append (x_xml_doc, l_xml_temp);
969: END IF;
970:
971: -- close context and free memory
972:

Line 975: DBMS_LOB.FREETEMPORARY (l_xml_temp);

971: -- close context and free memory
972:
973: DBMS_XMLGEN.closeContext(l_qryCtx);
974: CLOSE l_ref_cur;
975: DBMS_LOB.FREETEMPORARY (l_xml_temp);
976:
977:
978: -- Standard call to get message count and if count is 1, get message info.
979: