APPS.BIM_EDW_OPPORTUNITIES_M_SIZE dependencies on DBMS_OUTPUT

Line 30: dbms_output.enable(1000000);

26:
27:
28: BEGIN
29:
30: dbms_output.enable(1000000);
31:
32: OPEN c_cnt_rows;
33: FETCH c_cnt_rows INTO p_num_rows;
34: CLOSE c_cnt_rows;

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

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

Line 73: dbms_output.enable(1000000);

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

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

96: 5*ceil(x_INSTANCE + 1) +
97: 2*ceil(x_LEAD_ID + 1)) +
98: 15*(x_constant + 1);
99:
100: -- dbms_output.put_line(' ');
101: dbms_output.put_line('The average row length is : ' || to_char(x_total));
102:
103: p_avg_row_len := x_total;
104:

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

97: 2*ceil(x_LEAD_ID + 1)) +
98: 15*(x_constant + 1);
99:
100: -- dbms_output.put_line(' ');
101: dbms_output.put_line('The average row length is : ' || to_char(x_total));
102:
103: p_avg_row_len := x_total;
104:
105: END; -- procedure est_row_len.