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

Line 27: DBMS_LOB.createtemporary(l_vs_map_clob,TRUE);

23: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
24: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_clob', '<>');
25: END IF;
26:
27: DBMS_LOB.createtemporary(l_vs_map_clob,TRUE);
28: l_start:=1;
29: l_read_length := LENGTH( DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start));
30: -- WRITE THE FIRST PART OF THE CLOB
31: FOR i IN 1..CEIL(p_first_Offset/l_read_length) LOOP

Line 29: l_read_length := LENGTH( DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start));

25: END IF;
26:
27: DBMS_LOB.createtemporary(l_vs_map_clob,TRUE);
28: l_start:=1;
29: l_read_length := LENGTH( DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start));
30: -- WRITE THE FIRST PART OF THE CLOB
31: FOR i IN 1..CEIL(p_first_Offset/l_read_length) LOOP
32:
33: IF(l_start+l_read_length > p_first_Offset) THEN

Line 37: l_varchar := DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start);

33: IF(l_start+l_read_length > p_first_Offset) THEN
34: l_buffer := p_first_Offset-l_start;
35: END IF;
36:
37: l_varchar := DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start);
38: DBMS_LOB.WRITEAPPEND(l_vs_map_clob, LENGTH(l_varchar), l_varchar);
39: l_start := l_start + LENGTH(l_varchar);
40:
41: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 38: DBMS_LOB.WRITEAPPEND(l_vs_map_clob, LENGTH(l_varchar), l_varchar);

34: l_buffer := p_first_Offset-l_start;
35: END IF;
36:
37: l_varchar := DBMS_LOB.SUBSTR(p_src_clob, l_buffer, l_start);
38: DBMS_LOB.WRITEAPPEND(l_vs_map_clob, LENGTH(l_varchar), l_varchar);
39: l_start := l_start + LENGTH(l_varchar);
40:
41: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
42: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_clob', 'l_start : '||l_start);

Line 52: DBMS_LOB.writeappend(l_vs_map_clob, length(p_replace_with), p_replace_with);

48:
49: END LOOP;
50:
51: -- WRITE THE REPLACEMENT
52: DBMS_LOB.writeappend(l_vs_map_clob, length(p_replace_with), p_replace_with);
53: DBMS_LOB.writeappend(l_vs_map_clob, LENGTH(p_second_variable), p_second_variable);
54: p_src_clob:=l_vs_map_clob;
55: DBMS_LOB.freetemporary(l_vs_map_clob);
56:

Line 53: DBMS_LOB.writeappend(l_vs_map_clob, LENGTH(p_second_variable), p_second_variable);

49: END LOOP;
50:
51: -- WRITE THE REPLACEMENT
52: DBMS_LOB.writeappend(l_vs_map_clob, length(p_replace_with), p_replace_with);
53: DBMS_LOB.writeappend(l_vs_map_clob, LENGTH(p_second_variable), p_second_variable);
54: p_src_clob:=l_vs_map_clob;
55: DBMS_LOB.freetemporary(l_vs_map_clob);
56:
57: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 55: DBMS_LOB.freetemporary(l_vs_map_clob);

51: -- WRITE THE REPLACEMENT
52: DBMS_LOB.writeappend(l_vs_map_clob, length(p_replace_with), p_replace_with);
53: DBMS_LOB.writeappend(l_vs_map_clob, LENGTH(p_second_variable), p_second_variable);
54: p_src_clob:=l_vs_map_clob;
55: DBMS_LOB.freetemporary(l_vs_map_clob);
56:
57: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
58: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_clob', '<>');
59: END IF;

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

251: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
252: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Convert base DT blob to clob.');
253: END IF;
254: -- Create a temporary clob to hold manipulated contents
255: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
256: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
257: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
258: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
259: l_start := l_start + l_buffer;

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

252: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Convert base DT blob to clob.');
253: END IF;
254: -- Create a temporary clob to hold manipulated contents
255: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
256: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
257: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
258: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
259: l_start := l_start + l_buffer;
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

253: END IF;
254: -- Create a temporary clob to hold manipulated contents
255: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
256: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
257: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
258: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
259: l_start := l_start + l_buffer;
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
261: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_varchar : '||l_varchar);

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

254: -- Create a temporary clob to hold manipulated contents
255: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
256: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
257: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
258: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
259: l_start := l_start + l_buffer;
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
261: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_varchar : '||l_varchar);
262: END IF;

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

277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
278: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
279: END IF;
280:
281: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
282: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
283: l_start_tag_length := length('/*startSelectList*/');
284: 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);
285: l_clob := replace(l_clob,l_sub_string, l_select_list_gcs);

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

278: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
279: END IF;
280:
281: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
282: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
283: l_start_tag_length := length('/*startSelectList*/');
284: 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);
285: l_clob := replace(l_clob,l_sub_string, l_select_list_gcs);
286: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 284: 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);

280:
281: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
282: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
283: l_start_tag_length := length('/*startSelectList*/');
284: 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);
285: l_clob := replace(l_clob,l_sub_string, l_select_list_gcs);
286: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
287: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'SELECT literal replacement.');
288: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

290: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
291: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
292: END IF;
293:
294: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
295: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
296: l_start_tag_length := length('/*startFromList*/');
297: 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);
298: l_clob := replace(l_clob,l_sub_string, l_table_list_gcs);

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

291: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
292: END IF;
293:
294: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
295: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
296: l_start_tag_length := length('/*startFromList*/');
297: 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);
298: l_clob := replace(l_clob,l_sub_string, l_table_list_gcs);
299: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 297: 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);

293:
294: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
295: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
296: l_start_tag_length := length('/*startFromList*/');
297: 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);
298: l_clob := replace(l_clob,l_sub_string, l_table_list_gcs);
299: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
300: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'FROM literal replacement.');
301: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

303: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
304: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
305: END IF;
306:
307: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
308: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
309: l_start_tag_length := length('/*startWhereClause*/');
310: 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);
311: l_clob := replace(l_clob,l_sub_string, l_where_list_gcs);

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

304: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
305: END IF;
306:
307: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
308: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
309: l_start_tag_length := length('/*startWhereClause*/');
310: 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);
311: l_clob := replace(l_clob,l_sub_string, l_where_list_gcs);
312: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 310: 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);

306:
307: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
308: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
309: l_start_tag_length := length('/*startWhereClause*/');
310: 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);
311: l_clob := replace(l_clob,l_sub_string, l_where_list_gcs);
312: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
313: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'WHERE literal replacement.');
314: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

Line 320: l_start_tag := DBMS_LOB.instr(l_clob, '/startOrderClause/', 1, 1);

316: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
317: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
318: END IF;
319:
320: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
321: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
322: l_start_tag_length := length('/*startOrderClause*/');
323: 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);
324: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_gcs);

Line 321: l_end_tag := DBMS_LOB.instr(l_clob, '/endOrderClause/', 1, 1);

317: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
318: END IF;
319:
320: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
321: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
322: l_start_tag_length := length('/*startOrderClause*/');
323: 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);
324: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_gcs);
325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 323: 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);

319:
320: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
321: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
322: l_start_tag_length := length('/*startOrderClause*/');
323: 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);
324: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_gcs);
325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
326: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'ORDER literal replacement.');
327: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

329: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
330: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
331: END IF;
332:
333: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
334: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
335: l_start_tag_length := length('');
336: 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);
337: l_clob := replace(l_clob,l_sub_string, l_element_list_gcs);

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

330: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
331: END IF;
332:
333: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
334: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
335: l_start_tag_length := length('');
336: 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);
337: l_clob := replace(l_clob,l_sub_string, l_element_list_gcs);
338: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 336: 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);

332:
333: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
334: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
335: l_start_tag_length := length('');
336: 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);
337: l_clob := replace(l_clob,l_sub_string, l_element_list_gcs);
338: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
339: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'XML SCHEMA ELEMENT literal replacement.');
340: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

348: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
349: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
350: END IF;
351:
352: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
353: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
354: l_start_tag_length := length('/*startSelectList*/');
355: 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);
356: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN

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

349: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
350: END IF;
351:
352: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
353: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
354: l_start_tag_length := length('/*startSelectList*/');
355: 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);
356: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
357: l_clob := replace(l_clob,l_sub_string, l_select_list_dsload);

Line 355: 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);

351:
352: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);
353: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);
354: l_start_tag_length := length('/*startSelectList*/');
355: 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);
356: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
357: l_clob := replace(l_clob,l_sub_string, l_select_list_dsload);
358: ELSIF(l_base_templatecode = 'GCS_DS_TB_SOURCE_BASE') THEN
359: l_clob := replace(l_clob,l_sub_string, l_select_list_dstb);

Line 371: l_start_tag := DBMS_LOB.instr(l_clob, '/startSelectIdList/', 1, 1);

367: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
368: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
369: END IF;
370:
371: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectIdList*/', 1, 1);
372: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectIdList*/', 1, 1);
373: l_start_tag_length := length('/*startSelectIdList*/');
374: 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);
375:

Line 372: l_end_tag := DBMS_LOB.instr(l_clob, '/endSelectIdList/', 1, 1);

368: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
369: END IF;
370:
371: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectIdList*/', 1, 1);
372: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectIdList*/', 1, 1);
373: l_start_tag_length := length('/*startSelectIdList*/');
374: 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);
375:
376: IF(l_base_templatecode = 'GCS_DS_IMPACTED_BAL_SOURCE_BASE') THEN

Line 374: 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);

370:
371: l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectIdList*/', 1, 1);
372: l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectIdList*/', 1, 1);
373: l_start_tag_length := length('/*startSelectIdList*/');
374: 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);
375:
376: IF(l_base_templatecode = 'GCS_DS_IMPACTED_BAL_SOURCE_BASE') THEN
377: l_clob := replace(l_clob,l_sub_string, l_gl_posted_select_list);
378: --fix 5351083

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

386: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
387: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
388: END IF;
389:
390: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
391: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
392: l_start_tag_length := length('/*startFromList*/');
393: 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);
394: --fix 5351083

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

387: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
388: END IF;
389:
390: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
391: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
392: l_start_tag_length := length('/*startFromList*/');
393: 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);
394: --fix 5351083
395: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN

Line 393: 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);

389:
390: l_start_tag := DBMS_LOB.instr(l_clob, '/*startFromList*/', 1, 1);
391: l_end_tag := DBMS_LOB.instr(l_clob, '/*endFromList*/', 1, 1);
392: l_start_tag_length := length('/*startFromList*/');
393: 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);
394: --fix 5351083
395: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
396: --l_clob := replace(l_clob,l_sub_string, l_table_list_dsload);
397: --ELSIF(l_base_templatecode = 'GCS_DS_TB_SOURCE_BASE') THEN

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

407: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
408: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
409: END IF;
410:
411: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
412: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
413: l_start_tag_length := length('/*startWhereClause*/');
414: 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);
415: --fix 5351083

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

408: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
409: END IF;
410:
411: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
412: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
413: l_start_tag_length := length('/*startWhereClause*/');
414: 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);
415: --fix 5351083
416: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN

Line 414: 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);

410:
411: l_start_tag := DBMS_LOB.instr(l_clob, '/*startWhereClause*/', 1, 1);
412: l_end_tag := DBMS_LOB.instr(l_clob, '/*endWhereClause*/', 1, 1);
413: l_start_tag_length := length('/*startWhereClause*/');
414: 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);
415: --fix 5351083
416: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
417: -- l_clob := replace(l_clob,l_sub_string, l_where_list_dsload);
418: --ELSIF(l_base_templatecode = 'GCS_DS_TB_SOURCE_BASE') THEN

Line 432: l_start_tag := DBMS_LOB.instr(l_clob, '/startDSTBGroupbyName/', 1, 1);

428: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
429: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
430: END IF;
431:
432: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyName*/', 1, 1);
433: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyName*/', 1, 1);
434: l_start_tag_length := length('/*startDSTBGroupbyName*/');
435: 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);
436: --fix 5351083

Line 433: l_end_tag := DBMS_LOB.instr(l_clob, '/endDSTBGroupbyName/', 1, 1);

429: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
430: END IF;
431:
432: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyName*/', 1, 1);
433: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyName*/', 1, 1);
434: l_start_tag_length := length('/*startDSTBGroupbyName*/');
435: 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);
436: --fix 5351083
437: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN

Line 435: 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);

431:
432: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyName*/', 1, 1);
433: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyName*/', 1, 1);
434: l_start_tag_length := length('/*startDSTBGroupbyName*/');
435: 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);
436: --fix 5351083
437: --IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
438: -- l_clob := replace(l_clob,l_sub_string, l_select_list_dsload);
439: --ELSIF(l_base_templatecode = 'GCS_DS_TB_SOURCE_BASE') THEN

Line 453: l_start_tag := DBMS_LOB.instr(l_clob, '/startDSTBGroupbyId/', 1, 1);

449: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
450: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
451: END IF;
452:
453: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyId*/', 1, 1);
454: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyId*/', 1, 1);
455: l_start_tag_length := length('/*startDSTBGroupbyId*/');
456: 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);
457: IF(l_base_templatecode = 'GCS_DS_IMPACTED_BAL_SOURCE_BASE') THEN

Line 454: l_end_tag := DBMS_LOB.instr(l_clob, '/endDSTBGroupbyId/', 1, 1);

450: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
451: END IF;
452:
453: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyId*/', 1, 1);
454: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyId*/', 1, 1);
455: l_start_tag_length := length('/*startDSTBGroupbyId*/');
456: 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);
457: IF(l_base_templatecode = 'GCS_DS_IMPACTED_BAL_SOURCE_BASE') THEN
458: l_clob := replace(l_clob,l_sub_string, l_dstb_group_by_list);

Line 456: 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);

452:
453: l_start_tag := DBMS_LOB.instr(l_clob, '/*startDSTBGroupbyId*/', 1, 1);
454: l_end_tag := DBMS_LOB.instr(l_clob, '/*endDSTBGroupbyId*/', 1, 1);
455: l_start_tag_length := length('/*startDSTBGroupbyId*/');
456: 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);
457: IF(l_base_templatecode = 'GCS_DS_IMPACTED_BAL_SOURCE_BASE') THEN
458: l_clob := replace(l_clob,l_sub_string, l_dstb_group_by_list);
459: END IF;
460: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 468: l_start_tag := DBMS_LOB.instr(l_clob, '/startOrderClause/', 1, 1);

464: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
465: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
466: END IF;
467:
468: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
469: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
470: l_start_tag_length := length('/*startOrderClause*/');
471: 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);
472: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN

Line 469: l_end_tag := DBMS_LOB.instr(l_clob, '/endOrderClause/', 1, 1);

465: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
466: END IF;
467:
468: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
469: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
470: l_start_tag_length := length('/*startOrderClause*/');
471: 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);
472: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
473: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_dsload);

Line 471: 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);

467:
468: l_start_tag := DBMS_LOB.instr(l_clob, '/*startOrderClause*/', 1, 1);
469: l_end_tag := DBMS_LOB.instr(l_clob, '/*endOrderClause*/', 1, 1);
470: l_start_tag_length := length('/*startOrderClause*/');
471: 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);
472: IF(l_base_templatecode = 'GCS_DS_LOAD_SOURCE_BASE') THEN
473: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_dsload);
474: ELSIF(l_base_templatecode = 'GCS_DS_TB_SOURCE_BASE') THEN
475: l_clob :=replace(l_clob,l_sub_string, l_orderby_list_dstb);

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

481: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag_length : '||l_start_tag_length);
482: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
483: END IF;
484:
485: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
486: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
487: l_start_tag_length := length('');
488: 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);
489: l_clob := replace(l_clob,l_sub_string, l_element_list_dsload);

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

482: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
483: END IF;
484:
485: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
486: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
487: l_start_tag_length := length('');
488: 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);
489: l_clob := replace(l_clob,l_sub_string, l_element_list_dsload);
490: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 488: 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);

484:
485: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
486: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
487: l_start_tag_length := length('');
488: 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);
489: l_clob := replace(l_clob,l_sub_string, l_element_list_dsload);
490: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
491: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'XML SCHEMA ELEMENT (DIMENSION NAME COLUMNS) literal replacement.');
492: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

495: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_sub_string : '||l_sub_string);
496: END IF;
497: --fix 5351083
498: /*
499: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
500: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
501: l_start_tag_length := length('');
502: 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);
503: l_clob := replace(l_clob, l_sub_string, l_element_list_dstb);

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

496: END IF;
497: --fix 5351083
498: /*
499: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
500: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
501: l_start_tag_length := length('');
502: 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);
503: l_clob := replace(l_clob, l_sub_string, l_element_list_dstb);
504: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 502: 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);

498: /*
499: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
500: l_end_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
501: l_start_tag_length := length('');
502: 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);
503: l_clob := replace(l_clob, l_sub_string, l_element_list_dstb);
504: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
505: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'XML SCHEMA ELEMENT (DIMENSION ID COLUMNS) literal replacement.');
506: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start_tag : '||l_start_tag);

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

515: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
516: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'DT manipulation: '||l_base_templatecode);
517: END IF;
518:
519: l_start_tag := DBMS_LOB.instr(l_clob, '', 1, 1);
520: l_start_tag_length := length('');
521: l_remaining_str:='';
522: replace_clob(l_clob, l_vs_group_list, l_start_tag+l_start_tag_length, l_remaining_str);
523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

532:
533: -- Finally write back temporary clob to destination blob
534: l_start:=1;
535: l_off_write:=1;
536: DBMS_LOB.createtemporary(l_blob_out,TRUE);
537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
538: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Write back manipulated clob to target blob.');
539: END IF;
540:

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

537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
538: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Write back manipulated clob to target blob.');
539: END IF;
540:
541: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
542:
543: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
544: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
545: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );

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

539: END IF;
540:
541: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
542:
543: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
544: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
545: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
546: l_off_write := l_off_write + l_amt_write;
547: l_start := l_start + l_buffer;

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

541: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
542:
543: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
544: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
545: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
546: l_off_write := l_off_write + l_amt_write;
547: l_start := l_start + l_buffer;
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
549: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start : '||l_start);

Line 563: DBMS_LOB.freetemporary(l_blob_out);

559: WHERE application_short_name = 'GCS'
560: AND lob_type = 'DATA_TEMPLATE'
561: AND lob_code = SUBSTR(l_base_templatecode, 1, INSTR(l_base_templatecode,'_BASE')-1);
562:
563: DBMS_LOB.freetemporary(l_blob_out);
564: DBMS_LOB.freetemporary(l_clob);
565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
566: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Manipulated clob written back to target blob.');
567: END IF;

Line 564: DBMS_LOB.freetemporary(l_clob);

560: AND lob_type = 'DATA_TEMPLATE'
561: AND lob_code = SUBSTR(l_base_templatecode, 1, INSTR(l_base_templatecode,'_BASE')-1);
562:
563: DBMS_LOB.freetemporary(l_blob_out);
564: DBMS_LOB.freetemporary(l_clob);
565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
566: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'Manipulated clob written back to target blob.');
567: END IF;
568: