APPS.BIM_EDW_IH_REASN_M_SIZE dependencies on DBMS_OUTPUT

Line 24: dbms_output.enable(1000000);

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

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

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

Line 70: dbms_output.enable(1000000);

66:
67:
68: BEGIN
69:
70: dbms_output.enable(1000000);
71:
72: OPEN c_1;
73: FETCH c_1 INTO
74: X_REASON_ID,

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

91: x_total := x_total + 2*ceil(x_INSTANCE + 1);
92:
93: x_total := x_total + 15*(x_constant + 1);
94:
95: -- dbms_output.put_line(' ');
96: dbms_output.put_line('The average row length is : ' || to_char(x_total));
97:
98: p_avg_row_len := x_total;
99:

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

92:
93: x_total := x_total + 15*(x_constant + 1);
94:
95: -- dbms_output.put_line(' ');
96: dbms_output.put_line('The average row length is : ' || to_char(x_total));
97:
98: p_avg_row_len := x_total;
99:
100: END; -- procedure est_row_len.