APPS.MSC_RES_PLAN_PKG dependencies on MSC_RES_PLAN_DATA

Line 273: delete from msc_res_plan_data

269: exception
270: when no_data_found then return;
271: end;
272:
273: delete from msc_res_plan_data
274: where (query_id, row_index) in
275: (select
276: h.query_id,
277: decode(p_summary, 1, -1, h.row_index) row_index

Line 281: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);

277: decode(p_summary, 1, -1, h.row_index) row_index
278: from msc_hp_row_dtls h
279: where h.query_id = p_query_id
280: and h.data_flag = decode(p_summary, 1, h.data_flag, 3));
281: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
282: commit;
283:
284: l_constrained_plan := msc_phub_util.is_plan_constrained(l_plan_id);
285: msc_phub_util.log('l_constrained_plan = '||l_constrained_plan);

Line 287: insert into msc_res_plan_data(

283:
284: l_constrained_plan := msc_phub_util.is_plan_constrained(l_plan_id);
285: msc_phub_util.log('l_constrained_plan = '||l_constrained_plan);
286:
287: insert into msc_res_plan_data(
288: query_id,
289: row_index,
290: analysis_date,
291: required_hours,

Line 540: msc_phub_util.log('insert into msc_res_plan_data: '||sql%rowcount);

536: )
537: group by
538: row_index,
539: analysis_date;
540: msc_phub_util.log('insert into msc_res_plan_data: '||sql%rowcount);
541: commit;
542:
543: update msc_hp_row_dtls
544: set data_flag = 2

Line 586: delete from msc_res_plan_data where query_id = p_query_id;

582: prepare_row_dtls(p_query_id, p_plan_id,
583: p_organization_filters, p_department_filters, p_resource_filters, p_exception_filters, p_item_filters,
584: p_page_size);
585:
586: delete from msc_res_plan_data where query_id = p_query_id;
587: commit;
588:
589: fetch_data(p_query_id, 0);
590: end initialize_data;

Line 1125: delete from msc_res_plan_data where query_id = p_query_id;

1121: delete from msc_hp_row_dtls where query_id = p_query_id;
1122: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
1123: commit;
1124:
1125: delete from msc_res_plan_data where query_id = p_query_id;
1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
1127: commit;
1128:
1129: delete from msc_hp_updates where query_id = p_query_id;

Line 1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);

1122: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
1123: commit;
1124:
1125: delete from msc_res_plan_data where query_id = p_query_id;
1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
1127: commit;
1128:
1129: delete from msc_hp_updates where query_id = p_query_id;
1130: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);