APPS.BIM_EDW_TGSMT_M_SIZE dependencies on DBMS_OUTPUT

Line 27: dbms_output.enable(1000000);

23:
24:
25: BEGIN
26:
27: dbms_output.enable(1000000);
28:
29: OPEN c_cnt_rows;
30: FETCH c_cnt_rows INTO p_num_rows;
31: CLOSE c_cnt_rows;

Line 35: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));

31: CLOSE c_cnt_rows;
32:
33: p_num_rows := 9*p_num_rows;
34:
35: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
36: END; -- procedure cnt_rows.
37:
38:
39: PROCEDURE est_row_len(p_from_date DATE,

Line 81: dbms_output.enable(1000000);

77:
78:
79: BEGIN
80:
81: dbms_output.enable(1000000);
82:
83: OPEN c_1;
84: FETCH c_1 INTO
85: X_CELL_NAME,

Line 114: -- dbms_output.put_line(' ');

110: x_total := x_total + 3*ceil(x_INSTANCE + 1);
111:
112: x_total := 9*x_total + 15*(x_constant + 1);
113:
114: -- dbms_output.put_line(' ');
115: dbms_output.put_line('The average row length is : ' || to_char(x_total));
116:
117: p_avg_row_len := x_total;
118:

Line 115: dbms_output.put_line('The average row length is : ' || to_char(x_total));

111:
112: x_total := 9*x_total + 15*(x_constant + 1);
113:
114: -- dbms_output.put_line(' ');
115: dbms_output.put_line('The average row length is : ' || to_char(x_total));
116:
117: p_avg_row_len := x_total;
118:
119: END; -- procedure est_row_len.