APPS.QPR_DELETE_ODS_DATA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

procedure delete_measure_data(errbuf out nocopy varchar2,
                              retcode out nocopy number,
                              p_instance_id in number,
                              p_measure_code in varchar2,
                              p_from_date in varchar2,
                              p_to_date in varchar2,
                              p_dim_code in varchar2 default 'ALL',
                              p_dummy_dim_code in varchar2 default null,
                              p_dim_value_from in varchar2,
                              p_dim_value_to in varchar2) is

  l_sql varchar2(20000) := '';

Line: 30

  l_sql := 'select measure_value_id from qpr_measure_data ';

Line: 72

      delete qpr_measure_data where measure_value_id = t_meas_data(i);

Line: 73

    fnd_file.put_line(fnd_file.log, 'Deleted Records = ' || t_meas_data.count);

Line: 74

    t_meas_data.delete;

Line: 84

    fnd_file.put_line(fnd_file.log, 'Unable to delete ODS data');

Line: 88

end delete_measure_data;

Line: 90

procedure delete_dimension_data(errbuf out nocopy varchar2,
                              retcode out nocopy number,
                              p_instance_id in number,
                              p_dim_code in varchar2,
                              p_dummy_dim_code in varchar2 default null,
                              p_dim_value_from in varchar2,
                              p_dim_value_to in varchar2) is
  l_sql varchar2(20000) := '';

Line: 105

  l_sql := 'select dim_value_id from qpr_dimension_values where instance_id = ';

Line: 125

      delete qpr_dimension_values where dim_value_id = t_dim_data(i);

Line: 126

    fnd_file.put_line(fnd_file.log, 'Deleted Records = ' || t_dim_data.count);

Line: 127

    t_dim_data.delete;

Line: 136

    fnd_file.put_line(fnd_file.log, 'Unable to delete ODS data');

Line: 140

end delete_dimension_data;