APPS.QPR_DELETE_ODS_DATA dependencies on QPR_DIMENSION_VALUES

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

101: t_dim_data num_type;
102:
103: begin
104: l_sql := '';
105: l_sql := 'select dim_value_id from qpr_dimension_values where instance_id = ';
106: l_sql := l_sql || p_instance_id ;
107: if p_dim_value_from is not null and p_dim_value_to is not null then
108: l_sql := l_sql || ' and level1_value between ' ;
109: l_sql := l_sql || p_dim_value_from || ' and ' || p_dim_value_to;

Line 125: delete qpr_dimension_values where dim_value_id = t_dim_data(i);

121: loop
122: fetch c_get_dim_data bulk collect into t_dim_data limit lrows;
123: exit when t_dim_data.count=0;
124: forall i in t_dim_data.first..t_dim_data.last
125: delete qpr_dimension_values where dim_value_id = t_dim_data(i);
126: fnd_file.put_line(fnd_file.log, 'Deleted Records = ' || t_dim_data.count);
127: t_dim_data.delete;
128: end loop;
129: commit;