APPS.BIM_EDW_LEADS_F_SIZE dependencies on DBMS_OUTPUT

Line 35: dbms_output.enable(1000000);

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

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

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

Line 103: dbms_output.enable(1000000);

99:
100:
101: BEGIN
102:
103: dbms_output.enable(1000000);
104:
105: OPEN c_1;
106: FETCH c_1 INTO
107: x_SALES_LEAD_LINE_ID;

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

145: x_total := x_total + 15*ceil(x_INSTANCE + 1);
146:
147: x_total := x_total + 15*(x_constant + 1);
148:
149: -- dbms_output.put_line(' ');
150: dbms_output.put_line('The average row length is : ' || to_char(x_total));
151:
152: p_avg_row_len := x_total;
153:

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

146:
147: x_total := x_total + 15*(x_constant + 1);
148:
149: -- dbms_output.put_line(' ');
150: dbms_output.put_line('The average row length is : ' || to_char(x_total));
151:
152: p_avg_row_len := x_total;
153:
154: END; -- procedure est_row_len.