APPS.BIM_EDW_CMPGNS_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 34: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));

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

Line 98: dbms_output.enable(1000000);

94:
95:
96: BEGIN
97:
98: dbms_output.enable(1000000);
99:
100: OPEN c_1;
101: FETCH c_1 INTO
102: x_CAMPAIGN_SCHEDULE_ID,

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

146: x_total := x_total + 3*ceil(x_INSTANCE + 1);
147:
148: x_total := 10*x_total + 15*(x_constant + 1);
149:
150: -- dbms_output.put_line(' ');
151: dbms_output.put_line('The average row length is : ' || to_char(x_total));
152:
153: p_avg_row_len := x_total;
154:

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

147:
148: x_total := 10*x_total + 15*(x_constant + 1);
149:
150: -- dbms_output.put_line(' ');
151: dbms_output.put_line('The average row length is : ' || to_char(x_total));
152:
153: p_avg_row_len := x_total;
154:
155: END; -- procedure est_row_len.