APPS.BIM_EDW_OFFERS_M_SIZE dependencies on DBMS_OUTPUT

Line 28: dbms_output.enable(1000000);

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

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

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

Line 84: dbms_output.enable(1000000);

80: FROM qp_list_headers_vl;
81:
82: BEGIN
83:
84: dbms_output.enable(1000000);
85:
86: OPEN c_1;
87: FETCH c_1 INTO
88: x_activity_offer_id,

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

116: ceil(x_list_header_id + 1) +
117: ceil(x_description + 1) +
118: 15*(x_constant + 1);
119:
120: -- dbms_output.put_line(' ');
121: dbms_output.put_line('The average row length is : ' || to_char(x_total));
122:
123: p_avg_row_len := x_total;
124:

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

117: ceil(x_description + 1) +
118: 15*(x_constant + 1);
119:
120: -- dbms_output.put_line(' ');
121: dbms_output.put_line('The average row length is : ' || to_char(x_total));
122:
123: p_avg_row_len := x_total;
124:
125: END; -- procedure est_row_len.