APPS.BIM_EDW_EVENTS_M_SIZE dependencies on DBMS_OUTPUT

Line 39: dbms_output.enable(1000000);

35:
36:
37: BEGIN
38:
39: dbms_output.enable(1000000);
40:
41: OPEN c_cnt_rows;
42: FETCH c_cnt_rows INTO p_num_rows;
43: CLOSE c_cnt_rows;

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

41: OPEN c_cnt_rows;
42: FETCH c_cnt_rows INTO p_num_rows;
43: CLOSE c_cnt_rows;
44:
45: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
46: END; -- procedure cnt_rows.
47:
48:
49: PROCEDURE est_row_len(p_from_date DATE,

Line 206: dbms_output.enable(1000000);

202:
203:
204: BEGIN
205:
206: dbms_output.enable(1000000);
207:
208: OPEN c_1;
209: FETCH c_1 INTO
210: x_event_offer_name,

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

346: x_total := x_total + 3*ceil(x_INSTANCE + 1);
347:
348: x_total := 2*x_total + 15*(x_constant + 1);
349:
350: -- dbms_output.put_line(' ');
351: dbms_output.put_line('The average row length is : ' || to_char(x_total));
352:
353: p_avg_row_len := x_total;
354:

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

347:
348: x_total := 2*x_total + 15*(x_constant + 1);
349:
350: -- dbms_output.put_line(' ');
351: dbms_output.put_line('The average row length is : ' || to_char(x_total));
352:
353: p_avg_row_len := x_total;
354:
355: END; -- procedure est_row_len.