APPS.MSC_HP_UTIL dependencies on MSC_HP_ROW_DTLS

Line 234: from msc_hp_row_dtls

230: is
231: l_plan_id number;
232: begin
233: select plan_id into l_plan_id
234: from msc_hp_row_dtls
235: where query_id=p_query_id and rownum=1;
236:
237: return l_plan_id;
238: exception

Line 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);

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);

Line 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);

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);
254: commit;
255:
256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);

Line 256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);

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);
254: commit;
255:
256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);

Line 260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);

256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;

Line 264: delete from msc_hp_row_dtls where plan_id=p_plan_id;

260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;

Line 265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);

261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;
269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);