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

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

56: END IF;
57:
58: -- Initialze variables
59: l_stmt_num := 0;
60: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
61:
62: -- Initialize message stack
63: l_stmt_num := 10;
64: FND_MSG_PUB.initialize;

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

114: END IF;
115:
116: -- Append the XML end tag
117: l_stmt_num := 40;
118: DBMS_LOB.writeappend (l_xml_doc, 9, '');
119:
120: -- Get length of the CLOB l_xml_doc
121: l_stmt_num := 50;
122: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);

Line 122: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);

118: DBMS_LOB.writeappend (l_xml_doc, 9, '');
119:
120: -- Get length of the CLOB l_xml_doc
121: l_stmt_num := 50;
122: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);
123: l_offset := 1;
124: l_amount := 16383;
125:
126: -- Loop until the length of CLOB data is zero

Line 130: DBMS_LOB.read (l_xml_doc, l_amount, l_offset, l_buffer);

126: -- Loop until the length of CLOB data is zero
127: l_stmt_num := 60;
128: LOOP
129: EXIT WHEN l_length <= 0;
130: DBMS_LOB.read (l_xml_doc, l_amount, l_offset, l_buffer);
131: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);
132: l_length := l_length - l_amount;
133: l_offset := l_offset + l_amount;
134: END LOOP;

Line 138: DBMS_LOB.FREETEMPORARY (l_xml_doc);

134: END LOOP;
135:
136: -- free temporary memory
137: l_stmt_num := 70;
138: DBMS_LOB.FREETEMPORARY (l_xml_doc);
139:
140: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
141:
142:

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

257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258:
259: -- Create CLOB object to store the XML data
260: l_stmt_num := 20;
261: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
262:
263: -- If it is Specific WorkOrder then get the WP entity Name
264: IF (p_range = 2) THEN
265: l_stmt_num := 30;

Line 323: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,

319: l_stmt_num := 70;
320: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
321:
322: l_stmt_num := 80;
323: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
324: pattern => '>',
325: offset => 1,
326: nth => 1);
327:

Line 331: DBMS_LOB.copy (x_xml_doc, l_xml_temp, l_offset + 1);*/

327:
328: /*Bug 7305146*/
329: /*-- Copy XML header part to the destination XML doc
330: l_stmt_num := 90;
331: DBMS_LOB.copy (x_xml_doc, l_xml_temp, l_offset + 1);*/
332:
333: -- Remove the header
334: l_stmt_num := 90;
335: DBMS_LOB.erase (l_xml_temp, l_offset,1);

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

331: DBMS_LOB.copy (x_xml_doc, l_xml_temp, l_offset + 1);*/
332:
333: -- Remove the header
334: l_stmt_num := 90;
335: DBMS_LOB.erase (l_xml_temp, l_offset,1);
336:
337: l_stmt_num := 100;
338: /*The following 3 lines of code ensures that XML data generated here uses the right encoding*/
339: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

Line 341: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);

337: l_stmt_num := 100;
338: /*The following 3 lines of code ensures that XML data generated here uses the right encoding*/
339: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
340: l_xml_header := '';
341: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
342:
343: -- append the REPORT tag to XML
344: l_stmt_num := 110;
345: DBMS_LOB.writeappend (X_xml_doc, 8, '');

Line 345: DBMS_LOB.writeappend (X_xml_doc, 8, '');

341: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
342:
343: -- append the REPORT tag to XML
344: l_stmt_num := 110;
345: DBMS_LOB.writeappend (X_xml_doc, 8, '');
346:
347: -- Append the rest to xml output
348: l_stmt_num := 120;
349: DBMS_LOB.append (x_xml_doc, l_xml_temp);

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

345: DBMS_LOB.writeappend (X_xml_doc, 8, '');
346:
347: -- Append the rest to xml output
348: l_stmt_num := 120;
349: DBMS_LOB.append (x_xml_doc, l_xml_temp);
350:
351: /* close context and free memory */
352: l_stmt_num := 130;
353: DBMS_XMLGEN.closeContext(l_ctx);

Line 355: DBMS_LOB.FREETEMPORARY (l_xml_temp);

351: /* close context and free memory */
352: l_stmt_num := 130;
353: DBMS_XMLGEN.closeContext(l_ctx);
354: CLOSE l_ref_cur;
355: DBMS_LOB.FREETEMPORARY (l_xml_temp);
356:
357: IF l_plog THEN
358: fnd_log.string(
359: fnd_log.level_procedure,

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

450:
451: --Create the CLOB object to store XML data
452: l_stmt_num := 15;
453: l_offset := 21;
454: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
455:
456: -- Standard call to check for call compatibility.
457: l_stmt_num := 20;
458: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

608: -- remove the header (21 characters) and append the rest to xml output
609: l_stmt_num := 90;
610: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
611: IF ( l_total_rows_processed > 0) THEN
612: DBMS_LOB.erase (l_xml_temp, l_offset,1);
613: DBMS_LOB.append (x_xml_doc, l_xml_temp);
614: END IF;
615:
616: -- close context and free memory

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

609: l_stmt_num := 90;
610: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
611: IF ( l_total_rows_processed > 0) THEN
612: DBMS_LOB.erase (l_xml_temp, l_offset,1);
613: DBMS_LOB.append (x_xml_doc, l_xml_temp);
614: END IF;
615:
616: -- close context and free memory
617: l_stmt_num := 100;

Line 620: DBMS_LOB.FREETEMPORARY (l_xml_temp);

616: -- close context and free memory
617: l_stmt_num := 100;
618: DBMS_XMLGEN.closeContext(l_ctx);
619: CLOSE l_ref_cur;
620: DBMS_LOB.FREETEMPORARY (l_xml_temp);
621:
622:
623: -- Add tag ROW_COUNT and total number rows
624: l_stmt_num := 110;

Line 625: DBMS_LOB.writeappend (X_xml_doc, 11, '');

621:
622:
623: -- Add tag ROW_COUNT and total number rows
624: l_stmt_num := 110;
625: DBMS_LOB.writeappend (X_xml_doc, 11, '');
626: DBMS_LOB.writeappend (X_xml_doc, 10, '');
627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));
628: DBMS_LOB.writeappend (X_xml_doc, 11, '');
629: DBMS_LOB.writeappend (X_xml_doc, 12, '');

Line 626: DBMS_LOB.writeappend (X_xml_doc, 10, '');

622:
623: -- Add tag ROW_COUNT and total number rows
624: l_stmt_num := 110;
625: DBMS_LOB.writeappend (X_xml_doc, 11, '');
626: DBMS_LOB.writeappend (X_xml_doc, 10, '');
627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));
628: DBMS_LOB.writeappend (X_xml_doc, 11, '');
629: DBMS_LOB.writeappend (X_xml_doc, 12, '');
630:

Line 627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));

623: -- Add tag ROW_COUNT and total number rows
624: l_stmt_num := 110;
625: DBMS_LOB.writeappend (X_xml_doc, 11, '');
626: DBMS_LOB.writeappend (X_xml_doc, 10, '');
627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));
628: DBMS_LOB.writeappend (X_xml_doc, 11, '');
629: DBMS_LOB.writeappend (X_xml_doc, 12, '');
630:
631: l_stmt_num := 120;

Line 628: DBMS_LOB.writeappend (X_xml_doc, 11, '');

624: l_stmt_num := 110;
625: DBMS_LOB.writeappend (X_xml_doc, 11, '');
626: DBMS_LOB.writeappend (X_xml_doc, 10, '');
627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));
628: DBMS_LOB.writeappend (X_xml_doc, 11, '');
629: DBMS_LOB.writeappend (X_xml_doc, 12, '');
630:
631: l_stmt_num := 120;
632: IF l_plog THEN

Line 629: DBMS_LOB.writeappend (X_xml_doc, 12, '');

625: DBMS_LOB.writeappend (X_xml_doc, 11, '');
626: DBMS_LOB.writeappend (X_xml_doc, 10, '');
627: DBMS_LOB.writeappend (X_xml_doc, length (to_char(l_total_rows_processed)), to_char(l_total_rows_processed));
628: DBMS_LOB.writeappend (X_xml_doc, 11, '');
629: DBMS_LOB.writeappend (X_xml_doc, 12, '');
630:
631: l_stmt_num := 120;
632: IF l_plog THEN
633: fnd_log.string(