152: exception
153: when no_data_found then return;
154: end;
155:
156: delete from msc_matl_plan_data
157: where (query_id, row_index) in
158: (select
159: h.query_id,
160: decode(p_summary, 1, -1, h.row_index) row_index
160: decode(p_summary, 1, -1, h.row_index) row_index
161: from msc_hp_row_dtls h
162: where h.query_id = p_query_id
163: and h.data_flag = decode(p_summary, 1, h.data_flag, 3));
164: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
165: commit;
166:
167: insert into msc_matl_plan_data(
168: query_id,
163: and h.data_flag = decode(p_summary, 1, h.data_flag, 3));
164: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
165: commit;
166:
167: insert into msc_matl_plan_data(
168: query_id,
169: row_index,
170: analysis_date,
171: total_supply,
437: )
438: group by
439: row_index,
440: analysis_date;
441: msc_phub_util.log('insert into msc_matl_plan_data: '||sql%rowcount);
442: commit;
443:
444: update msc_hp_row_dtls
445: set data_flag = 2
481:
482: prepare_row_dtls(p_query_id, p_plan_id, p_category_set_id,
483: p_organization_filters, p_category_filters, p_item_filters, p_page_size);
484:
485: delete from msc_matl_plan_data where query_id = p_query_id;
486: commit;
487:
488: fetch_data(p_query_id, 0);
489: end initialize_data;
823: delete from msc_hp_row_dtls where query_id = p_query_id;
824: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
825: commit;
826:
827: delete from msc_matl_plan_data where query_id = p_query_id;
828: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
829: commit;
830:
831: delete from msc_hp_updates where query_id = p_query_id;
824: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
825: commit;
826:
827: delete from msc_matl_plan_data where query_id = p_query_id;
828: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
829: commit;
830:
831: delete from msc_hp_updates where query_id = p_query_id;
832: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);