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

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

85: l_cost_group_id := TO_NUMBER(p_cost_group_id);
86:
87: l_stmt_num := 20;
88: -- Create CLOB object to store AML data
89: DBMS_LOB.createtemporary(l_xml_doc, TRUE);
90:
91: -- Initialize message stack
92: FND_MSG_PUB.initialize;
93:

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

173: l_msg_data := 'Failed generating XML data of the report output';
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: DBMS_LOB.writeappend (l_xml_doc, 9, '');
178:
179: -- Get length of the CLOB l_xml_doc
180: l_stmt_num := 60;
181: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);

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

177: DBMS_LOB.writeappend (l_xml_doc, 9, '');
178:
179: -- Get length of the CLOB l_xml_doc
180: l_stmt_num := 60;
181: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);
182: l_offset := 1;
183: l_amount := 16383;
184:
185: -- Loop until the length of CLOB data is zero

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

186: l_stmt_num := 70;
187: LOOP
188: EXIT WHEN l_length <= 0;
189: -- Read 32 KB of data and print it to the report output
190: DBMS_LOB.read (l_xml_doc, l_amount, l_offset, l_buffer);
191: FND_FILE.PUT (FND_FILE.OUTPUT, l_buffer);
192: l_length := l_length - l_amount;
193: l_offset := l_offset + l_amount;
194: END LOOP;

Line 196: DBMS_LOB.FREETEMPORARY (l_xml_doc);

192: l_length := l_length - l_amount;
193: l_offset := l_offset + l_amount;
194: END LOOP;
195:
196: DBMS_LOB.FREETEMPORARY (l_xml_doc);
197:
198: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
199:
200: IF l_plog THEN

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

320: -- Initialize API return status to success
321: l_stmt_num := 20;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
325:
326: -------------------------------------------------------------------------------
327: -- Open reference cursor for fetching data related to report parameter values
328: -------------------------------------------------------------------------------

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

370: l_stmt_num := 60;
371: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
372:
373: l_stmt_num := 70;
374: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
375: pattern => '>',
376: offset => 1,
377: nth => 1);
378:

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

378:
379: /*Bug 7305146
380: -- Copy XML header part to the destination XML doc
381: l_stmt_num := 80;
382: DBMS_LOB.copy (x_xml_doc, l_xml_temp, l_offset + 1);*/
383:
384: -- Remove the header
385: l_stmt_num := 80;
386: DBMS_LOB.erase (l_xml_temp, l_offset,1);

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

382: DBMS_LOB.copy (x_xml_doc, l_xml_temp, l_offset + 1);*/
383:
384: -- Remove the header
385: l_stmt_num := 80;
386: DBMS_LOB.erase (l_xml_temp, l_offset,1);
387:
388: l_stmt_num := 90;
389: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
390: l_xml_header := '';

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

387:
388: l_stmt_num := 90;
389: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
390: l_xml_header := '';
391: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
392:
393: -- append the REPORT tag to XML
394: l_stmt_num := 100;
395: DBMS_LOB.writeappend (X_xml_doc, 8, '');

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

391: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
392:
393: -- append the REPORT tag to XML
394: l_stmt_num := 100;
395: DBMS_LOB.writeappend (X_xml_doc, 8, '');
396:
397: l_stmt_num := 110;
398: -- Append the rest to xml output
399: DBMS_LOB.append (x_xml_doc, l_xml_temp);

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

395: DBMS_LOB.writeappend (X_xml_doc, 8, '');
396:
397: l_stmt_num := 110;
398: -- Append the rest to xml output
399: DBMS_LOB.append (x_xml_doc, l_xml_temp);
400:
401: -- close context and free memory
402: l_stmt_num := 120;
403: DBMS_XMLGEN.closeContext(l_ctx);

Line 405: DBMS_LOB.FREETEMPORARY (l_xml_temp);

401: -- close context and free memory
402: l_stmt_num := 120;
403: DBMS_XMLGEN.closeContext(l_ctx);
404: CLOSE l_ref_cur;
405: DBMS_LOB.FREETEMPORARY (l_xml_temp);
406:
407: IF l_plog THEN
408: fnd_log.string(
409: fnd_log.level_procedure,

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

865:
866: l_stmt_num := 20;
867:
868: l_offset := 21;
869: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call ( l_api_version,
873: p_api_version,

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

1014: l_total_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1015:
1016: l_stmt_num := 180;
1017: IF ( l_total_rows_processed > 0) THEN
1018: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1019: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1020: END IF;
1021:
1022: -- close context and free memory

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

1015:
1016: l_stmt_num := 180;
1017: IF ( l_total_rows_processed > 0) THEN
1018: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1019: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1020: END IF;
1021:
1022: -- close context and free memory
1023: l_stmt_num := 190;

Line 1026: DBMS_LOB.FREETEMPORARY (l_xml_temp);

1022: -- close context and free memory
1023: l_stmt_num := 190;
1024: DBMS_XMLGEN.closeContext(l_ctx);
1025: CLOSE l_ref_cur;
1026: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1027:
1028: l_stmt_num := 200;
1029: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1030:

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

1025: CLOSE l_ref_cur;
1026: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1027:
1028: l_stmt_num := 200;
1029: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1030:
1031: l_stmt_num := 210;
1032: -- create new context to get the total number rows processes
1033: open l_ref_cur FOR select l_total_rows_processed row_count from DUAL;

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

1045:
1046: -- Check the number of rows more than zero then add XML result
1047: l_stmt_num := 240;
1048: IF ( l_total_rows_processed > 0) THEN
1049: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1050: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1051: END IF;
1052:
1053: l_stmt_num := 250;

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

1046: -- Check the number of rows more than zero then add XML result
1047: l_stmt_num := 240;
1048: IF ( l_total_rows_processed > 0) THEN
1049: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1050: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1051: END IF;
1052:
1053: l_stmt_num := 250;
1054: -- close context and free memory

Line 1057: DBMS_LOB.FREETEMPORARY (l_xml_temp);

1053: l_stmt_num := 250;
1054: -- close context and free memory
1055: DBMS_XMLGEN.closeContext(l_ctx);
1056: CLOSE l_ref_cur;
1057: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1058:
1059: IF l_plog THEN
1060: fnd_log.string(
1061: fnd_log.level_procedure,