APPS.QPR_DELETE_ODS_DATA dependencies on QPR_MEASURE_DATA

Line 30: l_sql := 'select measure_value_id from qpr_measure_data ';

26: date_from := fnd_date.canonical_to_date(p_from_date);
27: date_to := fnd_date.canonical_to_date(p_to_date);
28:
29: l_sql := '';
30: l_sql := 'select measure_value_id from qpr_measure_data ';
31: l_sql := l_sql || ' where instance_id = :1 and measure_type_code = :2 ';
32: l_sql := l_sql || ' and time_level_value between :3 and :4';
33:
34: case p_dim_code

Line 72: delete qpr_measure_data where measure_value_id = t_meas_data(i);

68: loop
69: fetch c_get_meas_data bulk collect into t_meas_data limit lrows;
70: exit when t_meas_data.count=0;
71: forall i in t_meas_data.first..t_meas_data.last
72: delete qpr_measure_data where measure_value_id = t_meas_data(i);
73: fnd_file.put_line(fnd_file.log, 'Deleted Records = ' || t_meas_data.count);
74: t_meas_data.delete;
75: end loop;
76: commit;