244: is
245: begin
246: msc_phub_util.log('msc_hp_util.sync_ui_data('||p_plan_id||','||p_mode||')');
247:
248: delete from msc_matl_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
250: commit;
251:
252: delete from msc_res_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
245: begin
246: msc_phub_util.log('msc_hp_util.sync_ui_data('||p_plan_id||','||p_mode||')');
247:
248: delete from msc_matl_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
250: commit;
251:
252: delete from msc_res_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
253: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);