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.FEM_DATA_TEMPLATE_UTIL_PKG dependencies on DBMS_LOB

Line 216: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);

212: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Convert base DT blob to clob.');
213: END IF;
214:
215: -- Create a temporary clob to hold manipulated contents
216: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
217:
218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
219:
220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));

Line 218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP

214:
215: -- Create a temporary clob to hold manipulated contents
216: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
217:
218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
219:
220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
221: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
222: l_start := l_start + l_buffer;

Line 220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));

216: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
217:
218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
219:
220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
221: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
222: l_start := l_start + l_buffer;
223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 221: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);

217:
218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
219:
220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
221: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
222: l_start := l_start + l_buffer;
223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
225: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_varchar : '||l_varchar);

Line 242: l_start_tag := DBMS_LOB.instr(l_clob, '/startSelectList/', 1, 1);

238: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
239: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
240: END IF;
241:
242: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
243: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
244: l_start_tag_length := length('/*startSelectList*/');
245: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
246: l_clob := replace(l_clob,l_sub_string, l_select_list_fem);

Line 243: l_end_tag := DBMS_LOB.instr(l_clob, '/endSelectList/', 1, 1);

239: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
240: END IF;
241:
242: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
243: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
244: l_start_tag_length := length('/*startSelectList*/');
245: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
246: l_clob := replace(l_clob,l_sub_string, l_select_list_fem);
247:

Line 245: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);

241:
242: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
243: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
244: l_start_tag_length := length('/*startSelectList*/');
245: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
246: l_clob := replace(l_clob,l_sub_string, l_select_list_fem);
247:
248: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
249: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Select List literal replacement.');

Line 256: l_start_tag := DBMS_LOB.instr(l_clob, '/startFromList/', 1, 1);

252: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
253: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
254: END IF;
255:
256: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
257: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
258: l_start_tag_length := length('/*startFromList*/');
259: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
260: l_clob := replace(l_clob,l_sub_string, l_from_list_fem);

Line 257: l_end_tag := DBMS_LOB.instr(l_clob, '/endFromList/', 1, 1);

253: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
254: END IF;
255:
256: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
257: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
258: l_start_tag_length := length('/*startFromList*/');
259: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
260: l_clob := replace(l_clob,l_sub_string, l_from_list_fem);
261:

Line 259: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);

255:
256: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
257: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
258: l_start_tag_length := length('/*startFromList*/');
259: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
260: l_clob := replace(l_clob,l_sub_string, l_from_list_fem);
261:
262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
263: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'From List literal replacement.');

Line 270: l_start_tag := DBMS_LOB.instr(l_clob, '/startWhereClause/', 1, 1);

266: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
267: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
268: END IF;
269:
270: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
271: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
272: l_start_tag_length := length('/*startWhereClause*/');
273: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
274: l_clob := replace(l_clob,l_sub_string, l_where_clause_fem);

Line 271: l_end_tag := DBMS_LOB.instr(l_clob, '/endWhereClause/', 1, 1);

267: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
268: END IF;
269:
270: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
271: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
272: l_start_tag_length := length('/*startWhereClause*/');
273: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
274: l_clob := replace(l_clob,l_sub_string, l_where_clause_fem);
275:

Line 273: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);

269:
270: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
271: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
272: l_start_tag_length := length('/*startWhereClause*/');
273: l_sub_string:= DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
274: l_clob := replace(l_clob,l_sub_string, l_where_clause_fem);
275:
276: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
277: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Where Clause literal replacement.');

Line 284: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);

280: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
281: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
282: END IF;
283:
284: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
285: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
286: l_start_tag_length := length('');
287: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
288: l_clob := replace(l_clob,l_sub_string, l_element_list_fem);

Line 285: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);

281: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
282: END IF;
283:
284: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
285: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
286: l_start_tag_length := length('');
287: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
288: l_clob := replace(l_clob,l_sub_string, l_element_list_fem);
289:

Line 287: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);

283:
284: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
285: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
286: l_start_tag_length := length('');
287: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
288: l_clob := replace(l_clob,l_sub_string, l_element_list_fem);
289:
290: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
291: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'XML SCHEMA ELEMENT (DIMENSION NAME COLUMNS) literal replacement.');

Line 298: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);

294: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
295: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
296: END IF;
297:
298: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
299: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
300: l_start_tag_length := length('');
301: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
302: l_clob := replace(l_clob,l_sub_string, l_vsmp_xml_elem);

Line 299: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);

295: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_sub_string : '||l_sub_string);
296: END IF;
297:
298: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
299: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
300: l_start_tag_length := length('');
301: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
302: l_clob := replace(l_clob,l_sub_string, l_vsmp_xml_elem);
303:

Line 301: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);

297:
298: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
299: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
300: l_start_tag_length := length('');
301: l_sub_string := DBMS_LOB.substr(l_clob,(l_end_tag - (l_start_tag+l_start_tag_length) ), l_start_tag+l_start_tag_length);
302: l_clob := replace(l_clob,l_sub_string, l_vsmp_xml_elem);
303:
304: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
305: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'XML SCHEMA ELEMENT (DIMENSION NAME COLUMNS) literal replacement.');

Line 317: DBMS_LOB.createtemporary(l_blob_out,TRUE);

313:
314: -- Finally write back temporary clob to destination blob
315: l_start:=1;
316: l_off_write:=1;
317: DBMS_LOB.createtemporary(l_blob_out,TRUE);
318:
319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
320: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Write back manipulated clob to target blob.');
321: END IF;

Line 323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP

319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
320: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Write back manipulated clob to target blob.');
321: END IF;
322:
323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
324:
325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );

Line 325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );

321: END IF;
322:
323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
324:
325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
328: l_off_write := l_off_write + l_amt_write;
329: l_start := l_start + l_buffer;

Line 327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );

323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
324:
325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
328: l_off_write := l_off_write + l_amt_write;
329: l_start := l_start + l_buffer;
330:
331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 347: DBMS_LOB.freetemporary(l_blob_out);

343: WHERE application_short_name = 'FEM'
344: AND lob_type = 'DATA_TEMPLATE'
345: AND lob_code = SUBSTR(l_base_templatecode, 1, INSTR(l_base_templatecode,'_BASE')-1);
346:
347: DBMS_LOB.freetemporary(l_blob_out);
348: DBMS_LOB.freetemporary(l_clob);
349:
350: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
351: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Manipulated clob written back to target blob.');

Line 348: DBMS_LOB.freetemporary(l_clob);

344: AND lob_type = 'DATA_TEMPLATE'
345: AND lob_code = SUBSTR(l_base_templatecode, 1, INSTR(l_base_templatecode,'_BASE')-1);
346:
347: DBMS_LOB.freetemporary(l_blob_out);
348: DBMS_LOB.freetemporary(l_clob);
349:
350: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
351: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Manipulated clob written back to target blob.');
352: END IF;