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.EDW_SIZE_WRAPPER dependencies on FND_FILE

Line 103: fnd_file.put_line(FND_FILE.LOG, g_message) ;

99: CLOSE c_check_pack;
100: IF l_package_found = 0 THEN
101: g_message := 'Package ' || l_pack_name || ' (for object ' || p_log_name
102: || ') not existing in the database. ';
103: fnd_file.put_line(FND_FILE.LOG, g_message) ;
104: fnd_file.put_line(FND_FILE.LOG, ' ') ;
105: ELSE
106: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
107:

Line 104: fnd_file.put_line(FND_FILE.LOG, ' ') ;

100: IF l_package_found = 0 THEN
101: g_message := 'Package ' || l_pack_name || ' (for object ' || p_log_name
102: || ') not existing in the database. ';
103: fnd_file.put_line(FND_FILE.LOG, g_message) ;
104: fnd_file.put_line(FND_FILE.LOG, ' ') ;
105: ELSE
106: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
107:
108: l_cursor_id := dbms_sql.open_cursor;

Line 166: fnd_file.put_line(FND_FILE.LOG, g_message) ;

162: CLOSE c_check_pack;
163: IF l_package_found = 0 THEN
164: g_message := 'Package ' || l_pack_name || ' (for object ' || g_log_name
165: || ') not existing in the database. ';
166: fnd_file.put_line(FND_FILE.LOG, g_message) ;
167: fnd_file.put_line(FND_FILE.LOG, ' ') ;
168: -- RAISE PACKAGE_NOT_FOUND;
169: ELSE
170: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';

Line 167: fnd_file.put_line(FND_FILE.LOG, ' ') ;

163: IF l_package_found = 0 THEN
164: g_message := 'Package ' || l_pack_name || ' (for object ' || g_log_name
165: || ') not existing in the database. ';
166: fnd_file.put_line(FND_FILE.LOG, g_message) ;
167: fnd_file.put_line(FND_FILE.LOG, ' ') ;
168: -- RAISE PACKAGE_NOT_FOUND;
169: ELSE
170: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
171:

Line 205: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

201:
202: END LOOP;
203: CLOSE c_get_all_objects;
204:
205: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;
207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;

Line 206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;

202: END LOOP;
203: CLOSE c_get_all_objects;
204:
205: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;
207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;
210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '

Line 207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

203: CLOSE c_get_all_objects;
204:
205: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;
207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;
210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '
211: || ceil(g_all_table_space/1024/1024)) ;

Line 208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '

204:
205: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;
207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;
210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '
211: || ceil(g_all_table_space/1024/1024)) ;
212: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '

206: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary ') ;
207: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;
210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '
211: || ceil(g_all_table_space/1024/1024)) ;
212: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
213:
214: END IF;

Line 212: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

208: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of indeces for all objects is (MB): '
209: || ceil(g_all_index_space/1024/1024)) ;
210: fnd_file.put_line(FND_FILE.OUTPUT, 'The total space of tables for all objects is (MB): '
211: || ceil(g_all_table_space/1024/1024)) ;
212: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
213:
214: END IF;
215:
216: EXCEPTION

Line 219: fnd_file.put_line(FND_FILE.LOG, g_message) ;

215:
216: EXCEPTION
217: WHEN TABLE_NOT_FOUND THEN
218: g_message := 'No table is found from EDW_SIZE_INPUT. ';
219: fnd_file.put_line(FND_FILE.LOG, g_message) ;
220: fnd_file.put_line(FND_FILE.LOG, ' ') ;
221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name
223: || ' not found from table EDW_SIZE_INPUT. ';

Line 220: fnd_file.put_line(FND_FILE.LOG, ' ') ;

216: EXCEPTION
217: WHEN TABLE_NOT_FOUND THEN
218: g_message := 'No table is found from EDW_SIZE_INPUT. ';
219: fnd_file.put_line(FND_FILE.LOG, g_message) ;
220: fnd_file.put_line(FND_FILE.LOG, ' ') ;
221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name
223: || ' not found from table EDW_SIZE_INPUT. ';
224: fnd_file.put_line(FND_FILE.LOG, g_message) ;

Line 224: fnd_file.put_line(FND_FILE.LOG, g_message) ;

220: fnd_file.put_line(FND_FILE.LOG, ' ') ;
221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name
223: || ' not found from table EDW_SIZE_INPUT. ';
224: fnd_file.put_line(FND_FILE.LOG, g_message) ;
225: fnd_file.put_line(FND_FILE.LOG, ' ') ;
226: WHEN PACKAGE_NOT_FOUND THEN
227: g_message := 'Package ' || l_pack_name
228: || ' not existing in the database. ';

Line 225: fnd_file.put_line(FND_FILE.LOG, ' ') ;

221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name
223: || ' not found from table EDW_SIZE_INPUT. ';
224: fnd_file.put_line(FND_FILE.LOG, g_message) ;
225: fnd_file.put_line(FND_FILE.LOG, ' ') ;
226: WHEN PACKAGE_NOT_FOUND THEN
227: g_message := 'Package ' || l_pack_name
228: || ' not existing in the database. ';
229: fnd_file.put_line(FND_FILE.LOG, g_message) ;

Line 229: fnd_file.put_line(FND_FILE.LOG, g_message) ;

225: fnd_file.put_line(FND_FILE.LOG, ' ') ;
226: WHEN PACKAGE_NOT_FOUND THEN
227: g_message := 'Package ' || l_pack_name
228: || ' not existing in the database. ';
229: fnd_file.put_line(FND_FILE.LOG, g_message) ;
230: fnd_file.put_line(FND_FILE.LOG, ' ') ;
231: WHEN PARAMETER_NULL THEN
232: g_message := 'The parameter can not be null. ';
233: fnd_file.put_line(FND_FILE.LOG, g_message) ;

Line 230: fnd_file.put_line(FND_FILE.LOG, ' ') ;

226: WHEN PACKAGE_NOT_FOUND THEN
227: g_message := 'Package ' || l_pack_name
228: || ' not existing in the database. ';
229: fnd_file.put_line(FND_FILE.LOG, g_message) ;
230: fnd_file.put_line(FND_FILE.LOG, ' ') ;
231: WHEN PARAMETER_NULL THEN
232: g_message := 'The parameter can not be null. ';
233: fnd_file.put_line(FND_FILE.LOG, g_message) ;
234: fnd_file.put_line(FND_FILE.LOG, ' ') ;

Line 233: fnd_file.put_line(FND_FILE.LOG, g_message) ;

229: fnd_file.put_line(FND_FILE.LOG, g_message) ;
230: fnd_file.put_line(FND_FILE.LOG, ' ') ;
231: WHEN PARAMETER_NULL THEN
232: g_message := 'The parameter can not be null. ';
233: fnd_file.put_line(FND_FILE.LOG, g_message) ;
234: fnd_file.put_line(FND_FILE.LOG, ' ') ;
235: WHEN OTHERS THEN
236: IF sqlerrm = 'ORA-06502' or sqlerrm = 'ORA-06550' THEN
237: g_message := 'Package ' || l_pack_name || ' has error ' || sqlerrm;

Line 234: fnd_file.put_line(FND_FILE.LOG, ' ') ;

230: fnd_file.put_line(FND_FILE.LOG, ' ') ;
231: WHEN PARAMETER_NULL THEN
232: g_message := 'The parameter can not be null. ';
233: fnd_file.put_line(FND_FILE.LOG, g_message) ;
234: fnd_file.put_line(FND_FILE.LOG, ' ') ;
235: WHEN OTHERS THEN
236: IF sqlerrm = 'ORA-06502' or sqlerrm = 'ORA-06550' THEN
237: g_message := 'Package ' || l_pack_name || ' has error ' || sqlerrm;
238: fnd_file.put_line(FND_FILE.LOG, g_message) ;

Line 238: fnd_file.put_line(FND_FILE.LOG, g_message) ;

234: fnd_file.put_line(FND_FILE.LOG, ' ') ;
235: WHEN OTHERS THEN
236: IF sqlerrm = 'ORA-06502' or sqlerrm = 'ORA-06550' THEN
237: g_message := 'Package ' || l_pack_name || ' has error ' || sqlerrm;
238: fnd_file.put_line(FND_FILE.LOG, g_message) ;
239: fnd_file.put_line(FND_FILE.LOG, ' ') ;
240: ELSE
241: errbuf := sqlerrm;
242: retcode := sqlcode;

Line 239: fnd_file.put_line(FND_FILE.LOG, ' ') ;

235: WHEN OTHERS THEN
236: IF sqlerrm = 'ORA-06502' or sqlerrm = 'ORA-06550' THEN
237: g_message := 'Package ' || l_pack_name || ' has error ' || sqlerrm;
238: fnd_file.put_line(FND_FILE.LOG, g_message) ;
239: fnd_file.put_line(FND_FILE.LOG, ' ') ;
240: ELSE
241: errbuf := sqlerrm;
242: retcode := sqlcode;
243: fnd_file.put_line(FND_FILE.LOG, errbuf) ;

Line 243: fnd_file.put_line(FND_FILE.LOG, errbuf) ;

239: fnd_file.put_line(FND_FILE.LOG, ' ') ;
240: ELSE
241: errbuf := sqlerrm;
242: retcode := sqlcode;
243: fnd_file.put_line(FND_FILE.LOG, errbuf) ;
244: fnd_file.put_line(FND_FILE.LOG, ' ') ;
245: END IF;
246:
247: END function_call; -- procedure function_call.

Line 244: fnd_file.put_line(FND_FILE.LOG, ' ') ;

240: ELSE
241: errbuf := sqlerrm;
242: retcode := sqlcode;
243: fnd_file.put_line(FND_FILE.LOG, errbuf) ;
244: fnd_file.put_line(FND_FILE.LOG, ' ') ;
245: END IF;
246:
247: END function_call; -- procedure function_call.
248:

Line 409: fnd_file.put_line(FND_FILE.LOG, g_message) ;

405: g_to_date,
406: sysdate, 0, 0, 0, sysdate);
407: g_message := 'Object logical name: ' || g_log_name ||
408: ', one record is inserted';
409: fnd_file.put_line(FND_FILE.LOG, g_message) ;
410: ELSE
411: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,
412: OWNER = g_schema,
413: AVG_ROW_LEN_STAGE = l_TBL_s,

Line 442: fnd_file.put_line(FND_FILE.LOG, g_message) ;

438: where table_name = g_table_name
439: and owner = g_schema;
440: g_message := 'Object logical name: ' || g_log_name ||
441: ', record is updated';
442: fnd_file.put_line(FND_FILE.LOG, g_message) ;
443: END IF;
444:
445: print_f(g_schema,
446: l_from_date,

Line 569: fnd_file.put_line(FND_FILE.LOG, g_message) ;

565: g_to_date,
566: sysdate, 0, 0, 0, sysdate);
567: g_message := 'Object logical name: ' || g_log_name ||
568: ', one record is inserted';
569: fnd_file.put_line(FND_FILE.LOG, g_message) ;
570: ELSE
571: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,
572: OWNER = g_schema,
573: AVG_ROW_LEN_STAGE = l_TBL_s,

Line 605: fnd_file.put_line(FND_FILE.LOG, g_message) ;

601: where table_name = g_table_name
602: and owner = g_schema;
603: g_message := 'Object logical name: ' || g_log_name ||
604: ', record is updated' ;
605: fnd_file.put_line(FND_FILE.LOG, g_message) ;
606: END IF; -- l_count.
607:
608: print_m(g_schema,
609: l_from_date,

Line 807: fnd_file.put_line(FND_FILE.LOG, g_message ) ;

803: v_TEMP_TABLE_SIZE ,
804: v_TOTAL_PEM_SPACE ,
805: v_TOTAL_TMP_SPACE );
806: g_message := 'Information for object ' || g_log_name || 'is printed. ';
807: fnd_file.put_line(FND_FILE.LOG, g_message ) ;
808:
809: ELSIF g_table_type = 'DIMENSION' then
810: OPEN c_get_object_m;
811: FETCH c_get_object_m INTO g_log_name,

Line 860: fnd_file.put_line(FND_FILE.LOG, g_message ) ;

856: v_TEMP_TABLE_SIZE ,
857: v_TOTAL_PEM_SPACE ,
858: v_TOTAL_TMP_SPACE );
859: g_message := 'Information for object ' || g_log_name || 'is printed. ';
860: fnd_file.put_line(FND_FILE.LOG, g_message ) ;
861:
862: END IF;
863: ELSE
864: OPEN c_get_objects;

Line 900: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

896: l_FROM_DATE := to_char(v_FROM_DATE, 'DD-MON-YYYY');
897: l_TO_DATE := to_char(v_TO_DATE, 'DD-MON-YYYY');
898:
899: IF g_table_type = 'FACT' THEN
900: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
901: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
902: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
903: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
904: print_f(g_schema,

Line 901: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

897: l_TO_DATE := to_char(v_TO_DATE, 'DD-MON-YYYY');
898:
899: IF g_table_type = 'FACT' THEN
900: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
901: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
902: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
903: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
904: print_f(g_schema,
905: l_FROM_DATE,

Line 903: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

899: IF g_table_type = 'FACT' THEN
900: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
901: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
902: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
903: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
904: print_f(g_schema,
905: l_FROM_DATE,
906: l_TO_DATE,
907: v_TEMP_SIZE_SOURCE ,

Line 924: fnd_file.put_line(FND_FILE.LOG, g_message ) ;

920: v_TOTAL_PEM_SPACE ,
921: v_TOTAL_TMP_SPACE );
922: null;
923: g_message := 'Information for object ' || g_log_name || 'is printed. ';
924: fnd_file.put_line(FND_FILE.LOG, g_message ) ;
925: v_total_idx_space := v_total_idx_space + v_INDEX_SIZE_STAGE + v_INDEX_SIZE;
926: v_total_tbl_space := v_total_tbl_space + v_TABLE_SIZE_STAGE + v_TABLE_SIZE;
927: ELSE
928: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 928: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

924: fnd_file.put_line(FND_FILE.LOG, g_message ) ;
925: v_total_idx_space := v_total_idx_space + v_INDEX_SIZE_STAGE + v_INDEX_SIZE;
926: v_total_tbl_space := v_total_tbl_space + v_TABLE_SIZE_STAGE + v_TABLE_SIZE;
927: ELSE
928: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
929: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
930: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
931: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
932: print_m(g_schema,

Line 929: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

925: v_total_idx_space := v_total_idx_space + v_INDEX_SIZE_STAGE + v_INDEX_SIZE;
926: v_total_tbl_space := v_total_tbl_space + v_TABLE_SIZE_STAGE + v_TABLE_SIZE;
927: ELSE
928: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
929: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
930: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
931: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
932: print_m(g_schema,
933: l_FROM_DATE,

Line 931: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

927: ELSE
928: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
929: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
930: || V_TABLE_LOGICAL_NAME || '(' || g_table_type || ')') ;
931: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
932: print_m(g_schema,
933: l_FROM_DATE,
934: l_TO_DATE,
935: v_AVG_ROW_LEN_STAGE ,

Line 954: fnd_file.put_line(FND_FILE.LOG, g_message ) ;

950: v_TEMP_TABLE_SIZE ,
951: v_TOTAL_PEM_SPACE ,
952: v_TOTAL_TMP_SPACE );
953: g_message := 'Information for object ' || g_log_name || 'is printed. ';
954: fnd_file.put_line(FND_FILE.LOG, g_message ) ;
955: v_total_idx_space := v_total_idx_space + v_INDEX_SIZE_STAGE +
956: v_INDEX_SIZE_LEVEL + v_INDEX_SIZE;
957: v_total_tbl_space := v_total_tbl_space + v_TABLE_SIZE_STAGE +
958: v_TABLE_SIZE_LEVEL + v_TABLE_SIZE;

Line 962: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

958: v_TABLE_SIZE_LEVEL + v_TABLE_SIZE;
959: END IF;
960: END LOOP;
961: CLOSE c_get_objects;
962: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;
964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;

Line 963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;

959: END IF;
960: END LOOP;
961: CLOSE c_get_objects;
962: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;
964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;
967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '

Line 964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

960: END LOOP;
961: CLOSE c_get_objects;
962: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;
964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;
967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '
968: || ceil(v_total_tbl_space/1024/1024)) ;

Line 965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '

961: CLOSE c_get_objects;
962: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;
964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;
967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '
968: || ceil(v_total_tbl_space/1024/1024)) ;
969: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '

963: fnd_file.put_line(FND_FILE.OUTPUT, 'In Summary') ;
964: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;
967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '
968: || ceil(v_total_tbl_space/1024/1024)) ;
969: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
970: END IF;
971:

Line 969: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

965: fnd_file.put_line(FND_FILE.OUTPUT, 'The total index space of all objects is (MB): '
966: || ceil(v_total_idx_space/1024/1024)) ;
967: fnd_file.put_line(FND_FILE.OUTPUT, 'The total table space of all objects is (MB): '
968: || ceil(v_total_tbl_space/1024/1024)) ;
969: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
970: END IF;
971:
972: EXCEPTION
973: WHEN NO_INFORMATION THEN

Line 975: fnd_file.put_line(FND_FILE.LOG, g_message || g_log_name) ;

971:
972: EXCEPTION
973: WHEN NO_INFORMATION THEN
974: g_message := 'No information found for object: ';
975: fnd_file.put_line(FND_FILE.LOG, g_message || g_log_name) ;
976: fnd_file.put_line(FND_FILE.LOG, ' ') ;
977: WHEN OTHERS THEN
978: errbuf := sqlerrm;
979: retcode := sqlcode;

Line 976: fnd_file.put_line(FND_FILE.LOG, ' ') ;

972: EXCEPTION
973: WHEN NO_INFORMATION THEN
974: g_message := 'No information found for object: ';
975: fnd_file.put_line(FND_FILE.LOG, g_message || g_log_name) ;
976: fnd_file.put_line(FND_FILE.LOG, ' ') ;
977: WHEN OTHERS THEN
978: errbuf := sqlerrm;
979: retcode := sqlcode;
980: fnd_file.put_line(FND_FILE.LOG, errbuf) ;

Line 980: fnd_file.put_line(FND_FILE.LOG, errbuf) ;

976: fnd_file.put_line(FND_FILE.LOG, ' ') ;
977: WHEN OTHERS THEN
978: errbuf := sqlerrm;
979: retcode := sqlcode;
980: fnd_file.put_line(FND_FILE.LOG, errbuf) ;
981: fnd_file.put_line(FND_FILE.LOG, ' ') ;
982:
983: END show_results; -- procedure show_results.
984:

Line 981: fnd_file.put_line(FND_FILE.LOG, ' ') ;

977: WHEN OTHERS THEN
978: errbuf := sqlerrm;
979: retcode := sqlcode;
980: fnd_file.put_line(FND_FILE.LOG, errbuf) ;
981: fnd_file.put_line(FND_FILE.LOG, ' ') ;
982:
983: END show_results; -- procedure show_results.
984:
985: PROCEDURE print_f (v_TABLE_OWNER VARCHAR2,

Line 1006: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1002: v_TOTAL_TMP_SPACE NUMBER) AS
1003:
1004: BEGIN
1005:
1006: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1007: IF g_log_name = 'ALL' THEN
1008: null;
1009: ELSE
1010: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

Line 1010: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

1006: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1007: IF g_log_name = 'ALL' THEN
1008: null;
1009: ELSE
1010: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
1011: || g_log_name || '(' || g_table_type || ')') ;
1012: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1013: END IF;
1014:

Line 1012: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

1008: null;
1009: ELSE
1010: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
1011: || g_log_name || '(' || g_table_type || ')') ;
1012: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1013: END IF;
1014:
1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;

Line 1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1011: || g_log_name || '(' || g_table_type || ')') ;
1012: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1013: END IF;
1014:
1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;

1012: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1013: END IF;
1014:
1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;

Line 1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1013: END IF;
1014:
1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;

1014:
1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '

Line 1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1015: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;

Line 1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;

1016: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1017: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;

Line 1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '

1018: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1019: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1020: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;

Line 1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;

1021: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1022: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space on Source Side (bytes): '
1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '

Line 1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '

1023: || v_TEMP_SIZE_SOURCE) ;
1024: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '
1031: || v_AVG_ROW_LEN) ;

Line 1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1025: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '
1031: || v_AVG_ROW_LEN) ;
1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '

Line 1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '

1026: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1027: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Interface Table (bytes): '
1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '
1031: || v_AVG_ROW_LEN) ;
1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '
1034: || v_AVG_ROW_LEN_IND_S) ;

Line 1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1028: || v_AVG_ROW_LEN_STAGE) ;
1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '
1031: || v_AVG_ROW_LEN) ;
1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '
1034: || v_AVG_ROW_LEN_IND_S) ;
1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '

Line 1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '

1029: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1030: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Fact (bytes): '
1031: || v_AVG_ROW_LEN) ;
1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '
1034: || v_AVG_ROW_LEN_IND_S) ;
1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;

Line 1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1031: || v_AVG_ROW_LEN) ;
1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '
1034: || v_AVG_ROW_LEN_IND_S) ;
1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;

Line 1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '

1032: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1033: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for Interface Table (bytes): '
1034: || v_AVG_ROW_LEN_IND_S) ;
1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1034: || v_AVG_ROW_LEN_IND_S) ;
1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;

Line 1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;

1035: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1036: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index for the Fact (bytes): '
1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;

Line 1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '

1037: || v_AVG_ROW_LEN_IND) ;
1038: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1039: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): ' || v_TABLE_SIZE_STAGE) ;
1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;

1040: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;

Line 1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1041: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index for Interface Table (bytes): '
1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;

1042: || v_INDEX_SIZE_STAGE) ;
1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;

Line 1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1043: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;

1044: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Fact (bytes): ' || v_TABLE_SIZE) ;
1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '

Line 1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1045: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;

Line 1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;

1046: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Fact (bytes): ' || v_INDEX_SIZE) ;
1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1047: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '

Line 1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '

1048: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1049: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1056: || v_TOTAL_PEM_SPACE) ;

Line 1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1050: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1056: || v_TOTAL_PEM_SPACE) ;
1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '

Line 1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '

1051: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1052: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1056: || v_TOTAL_PEM_SPACE) ;
1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1059: || v_TOTAL_TMP_SPACE) ;

Line 1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1053: || v_TEMP_TABLE_SIZE) ;
1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1056: || v_TOTAL_PEM_SPACE) ;
1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1059: || v_TOTAL_TMP_SPACE) ;
1060: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1061: END print_f;

Line 1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '

1054: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1055: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1056: || v_TOTAL_PEM_SPACE) ;
1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1059: || v_TOTAL_TMP_SPACE) ;
1060: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1061: END print_f;
1062:

Line 1060: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1056: || v_TOTAL_PEM_SPACE) ;
1057: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1058: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1059: || v_TOTAL_TMP_SPACE) ;
1060: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1061: END print_f;
1062:
1063: PROCEDURE print_m (v_TABLE_OWNER VARCHAR2,
1064: v_FROM_DATE VARCHAR2,

Line 1087: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1083: v_TOTAL_TMP_SPACE NUMBER) IS
1084:
1085: BEGIN
1086:
1087: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1088: IF g_log_name = 'ALL' THEN
1089: null;
1090: ELSE
1091: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

Line 1091: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '

1087: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1088: IF g_log_name = 'ALL' THEN
1089: null;
1090: ELSE
1091: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
1092: || g_log_name || '(' || g_table_type || ')') ;
1093: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1094: END IF;
1095:

Line 1093: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;

1089: null;
1090: ELSE
1091: fnd_file.put_line(FND_FILE.OUTPUT, 'Size Estimation Result for Table: '
1092: || g_log_name || '(' || g_table_type || ')') ;
1093: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1094: END IF;
1095:
1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;

Line 1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1092: || g_log_name || '(' || g_table_type || ')') ;
1093: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1094: END IF;
1095:
1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;

1093: fnd_file.put_line(FND_FILE.OUTPUT, '------------------------------------------------') ;
1094: END IF;
1095:
1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;

Line 1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1094: END IF;
1095:
1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;

1095:
1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;

Line 1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1096: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;

1097: fnd_file.put(FND_FILE.OUTPUT, 'Schema: ' || v_TABLE_OWNER) ;
1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '

Line 1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1098: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;

Line 1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;

1099: fnd_file.put(FND_FILE.OUTPUT, 'From Date: ' || v_FROM_DATE) ;
1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1100: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '

Line 1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '

1101: fnd_file.put(FND_FILE.OUTPUT, 'To Date: ' || v_TO_DATE) ;
1102: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '
1109: || v_AVG_ROW_LEN_LEVEL) ;

Line 1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1103: fnd_file.put(FND_FILE.OUTPUT, 'Number of Rows: ' || v_NUM_ROWS) ;
1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '
1109: || v_AVG_ROW_LEN_LEVEL) ;
1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '

Line 1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '

1104: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1105: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Interface Tables (bytes): '
1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '
1109: || v_AVG_ROW_LEN_LEVEL) ;
1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '
1112: || v_AVG_ROW_LEN) ;

Line 1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1106: || v_AVG_ROW_LEN_STAGE) ;
1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '
1109: || v_AVG_ROW_LEN_LEVEL) ;
1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '
1112: || v_AVG_ROW_LEN) ;
1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '

Line 1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '

1107: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1108: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of All Level Tables (bytes): '
1109: || v_AVG_ROW_LEN_LEVEL) ;
1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '
1112: || v_AVG_ROW_LEN) ;
1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '
1115: || v_AVG_ROW_LEN_IND_S) ;

Line 1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1109: || v_AVG_ROW_LEN_LEVEL) ;
1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '
1112: || v_AVG_ROW_LEN) ;
1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '
1115: || v_AVG_ROW_LEN_IND_S) ;
1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '

Line 1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '

1110: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1111: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of the Dimension (bytes): '
1112: || v_AVG_ROW_LEN) ;
1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '
1115: || v_AVG_ROW_LEN_IND_S) ;
1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '
1118: || v_AVG_ROW_LEN_IND_L) ;

Line 1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1112: || v_AVG_ROW_LEN) ;
1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '
1115: || v_AVG_ROW_LEN_IND_S) ;
1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '
1118: || v_AVG_ROW_LEN_IND_L) ;
1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '

Line 1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '

1113: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1114: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Interface Tables (bytes): '
1115: || v_AVG_ROW_LEN_IND_S) ;
1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '
1118: || v_AVG_ROW_LEN_IND_L) ;
1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '
1121: || v_AVG_ROW_LEN_IND) ;

Line 1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1115: || v_AVG_ROW_LEN_IND_S) ;
1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '
1118: || v_AVG_ROW_LEN_IND_L) ;
1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '
1121: || v_AVG_ROW_LEN_IND) ;
1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '

Line 1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '

1116: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1117: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of All Level Tables (bytes): '
1118: || v_AVG_ROW_LEN_IND_L) ;
1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '
1121: || v_AVG_ROW_LEN_IND) ;
1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '
1124: || v_TABLE_SIZE_STAGE) ;

Line 1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1118: || v_AVG_ROW_LEN_IND_L) ;
1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '
1121: || v_AVG_ROW_LEN_IND) ;
1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '
1124: || v_TABLE_SIZE_STAGE) ;
1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '

Line 1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '

1119: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1120: fnd_file.put(FND_FILE.OUTPUT, 'Avg Row Length of Index of the Dimension (bytes): '
1121: || v_AVG_ROW_LEN_IND) ;
1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '
1124: || v_TABLE_SIZE_STAGE) ;
1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '
1127: || v_INDEX_SIZE_STAGE) ;

Line 1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1121: || v_AVG_ROW_LEN_IND) ;
1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '
1124: || v_TABLE_SIZE_STAGE) ;
1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '
1127: || v_INDEX_SIZE_STAGE) ;
1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '

Line 1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '

1122: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1123: fnd_file.put(FND_FILE.OUTPUT, 'Size of Interface Table (bytes): '
1124: || v_TABLE_SIZE_STAGE) ;
1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '
1127: || v_INDEX_SIZE_STAGE) ;
1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '
1130: || v_TABLE_SIZE_LEVEL) ;

Line 1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1124: || v_TABLE_SIZE_STAGE) ;
1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '
1127: || v_INDEX_SIZE_STAGE) ;
1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '
1130: || v_TABLE_SIZE_LEVEL) ;
1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '

Line 1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '

1125: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1126: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Interface Table (bytes): '
1127: || v_INDEX_SIZE_STAGE) ;
1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '
1130: || v_TABLE_SIZE_LEVEL) ;
1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;

Line 1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1127: || v_INDEX_SIZE_STAGE) ;
1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '
1130: || v_TABLE_SIZE_LEVEL) ;
1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;

Line 1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '

1128: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1129: fnd_file.put(FND_FILE.OUTPUT, 'Size of Level Table (bytes): '
1130: || v_TABLE_SIZE_LEVEL) ;
1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1130: || v_TABLE_SIZE_LEVEL) ;
1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;

1131: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;

Line 1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1132: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of Level Table (bytes): '
1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;

1133: || v_INDEX_SIZE_LEVEL) ;
1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;

Line 1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1134: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;

1135: fnd_file.put(FND_FILE.OUTPUT, 'Size of the Dimension (bytes): ' || v_TABLE_SIZE) ;
1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '

Line 1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1136: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;

Line 1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;

1137: fnd_file.put(FND_FILE.OUTPUT, 'Size of Index of the Dimension (bytes): ' || v_INDEX_SIZE) ;
1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

Line 1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1138: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '

Line 1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '

1139: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Space (bytes): ' || v_TEMP_SIZE) ;
1140: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1147: || v_TOTAL_PEM_SPACE) ;

Line 1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1141: fnd_file.put(FND_FILE.OUTPUT, 'Size of Rollback Segments (bytes): ' || v_RB_SIZE) ;
1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1147: || v_TOTAL_PEM_SPACE) ;
1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '

Line 1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '

1142: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1143: fnd_file.put(FND_FILE.OUTPUT, 'Size of Temporary Table Space (bytes): '
1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1147: || v_TOTAL_PEM_SPACE) ;
1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1150: || v_TOTAL_TMP_SPACE) ;

Line 1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1144: || v_TEMP_TABLE_SIZE) ;
1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1147: || v_TOTAL_PEM_SPACE) ;
1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1150: || v_TOTAL_TMP_SPACE) ;
1151: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1152:

Line 1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '

1145: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1146: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Permanent Space (bytes): '
1147: || v_TOTAL_PEM_SPACE) ;
1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1150: || v_TOTAL_TMP_SPACE) ;
1151: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1152:
1153: END print_m; -- procedure print_m.

Line 1151: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;

1147: || v_TOTAL_PEM_SPACE) ;
1148: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1149: fnd_file.put(FND_FILE.OUTPUT, 'Total Size of Temporary Space (bytes): '
1150: || v_TOTAL_TMP_SPACE) ;
1151: fnd_file.new_line(FND_FILE.OUTPUT, 2) ;
1152:
1153: END print_m; -- procedure print_m.
1154:
1155: