APPS.BIM_EDW_SRCLSTS_M_SIZE dependencies on DBMS_OUTPUT

Line 29: dbms_output.enable(1000000);

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

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

31: OPEN c_cnt_rows;
32: FETCH c_cnt_rows INTO p_num_rows;
33: CLOSE c_cnt_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 107: dbms_output.enable(1000000);

103: from ams_list_src_types;
104:
105: BEGIN
106:
107: dbms_output.enable(1000000);
108:
109: OPEN c_1;
110: FETCH c_1 INTO
111: x_name,

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

158:
159:
160: x_total := x_total + ceil(x_list_source_type +1) + 15*(x_constant + 1);
161:
162: -- dbms_output.put_line(' ');
163: dbms_output.put_line('The average row length is : ' || to_char(x_total));
164:
165: p_avg_row_len := x_total;
166:

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

159:
160: x_total := x_total + ceil(x_list_source_type +1) + 15*(x_constant + 1);
161:
162: -- dbms_output.put_line(' ');
163: dbms_output.put_line('The average row length is : ' || to_char(x_total));
164:
165: p_avg_row_len := x_total;
166:
167: END; -- procedure est_row_len.