APPS.BIM_EDW_MKTSGMTS_M_SIZE dependencies on DBMS_OUTPUT

Line 25: dbms_output.enable(1000000);

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

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

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

Line 74: dbms_output.enable(1000000);

70:
71:
72: BEGIN
73:
74: dbms_output.enable(1000000);
75:
76: OPEN c_1;
77: FETCH c_1 INTO
78: X_CELL_NAME,

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

100: x_total := x_total + 2*ceil(x_INSTANCE + 1);
101:
102: x_total := x_total + 15*(x_constant + 1);
103:
104: -- dbms_output.put_line(' ');
105: dbms_output.put_line('The average row length is : ' || to_char(x_total));
106:
107: p_avg_row_len := x_total;
108:

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

101:
102: x_total := x_total + 15*(x_constant + 1);
103:
104: -- dbms_output.put_line(' ');
105: dbms_output.put_line('The average row length is : ' || to_char(x_total));
106:
107: p_avg_row_len := x_total;
108:
109: END; -- procedure est_row_len.