APPS.BIM_EDW_INTRCTNS_F_SIZE dependencies on DBMS_OUTPUT

Line 33: dbms_output.enable(1000000);

29: );
30:
31: BEGIN
32:
33: dbms_output.enable(1000000);
34:
35: OPEN c_cnt_rows;
36: FETCH c_cnt_rows INTO p_num_rows;
37: CLOSE c_cnt_rows;

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

36: FETCH c_cnt_rows INTO p_num_rows;
37: CLOSE c_cnt_rows;
38:
39:
40: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
41: END; -- procedure cnt_rows.
42:
43:
44: PROCEDURE est_row_len(p_from_date DATE,

Line 94: dbms_output.enable(1000000);

90:
91:
92: BEGIN
93:
94: dbms_output.enable(1000000);
95:
96: OPEN c_1;
97: FETCH c_1 INTO
98: x_ACTIVITY_ID,

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

131: x_total := x_total + 8*ceil(x_INSTANCE + 1);
132:
133: x_total := x_total + 15*(x_constant + 1);
134:
135: -- dbms_output.put_line(' ');
136: dbms_output.put_line('The average row length is : ' || to_char(x_total));
137: p_avg_row_len := x_total;
138:
139: END; -- procedure est_row_len.

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

132:
133: x_total := x_total + 15*(x_constant + 1);
134:
135: -- dbms_output.put_line(' ');
136: dbms_output.put_line('The average row length is : ' || to_char(x_total));
137: p_avg_row_len := x_total;
138:
139: END; -- procedure est_row_len.
140: