APPS.BIM_EDW_CMPFRCST_F_SIZE dependencies on DBMS_OUTPUT

Line 53: dbms_output.enable(1000000);

49:
50:
51: BEGIN
52:
53: dbms_output.enable(1000000);
54:
55: OPEN c_cnt_rows;
56: FETCH c_cnt_rows INTO p_num_rows;
57: CLOSE c_cnt_rows;

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

56: FETCH c_cnt_rows INTO p_num_rows;
57: CLOSE c_cnt_rows;
58:
59:
60: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
61: END; -- procedure cnt_rows.
62:
63:
64: PROCEDURE est_row_len(p_from_date DATE,

Line 101: dbms_output.enable(1000000);

97:
98:
99: BEGIN
100:
101: dbms_output.enable(1000000);
102:
103: OPEN c_1;
104: FETCH c_1 INTO
105: x_CAMPAIGN_ID,

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

127: x_total := x_total + 8*ceil(x_INSTANCE + 1);
128:
129: x_total := x_total + 20*(x_constant + 1);
130:
131: -- dbms_output.put_line(' ');
132: dbms_output.put_line('The average row length is : ' || to_char(x_total));
133:
134: p_avg_row_len := x_total;
135:

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

128:
129: x_total := x_total + 20*(x_constant + 1);
130:
131: -- dbms_output.put_line(' ');
132: dbms_output.put_line('The average row length is : ' || to_char(x_total));
133:
134: p_avg_row_len := x_total;
135:
136: END; -- procedure est_row_len.