DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on MSC_HUB_QUERY

Line 221: insert into msc_hub_query(

217: p_plan_type number, p_aggr_type number, p_category_set_id number) is
218: begin
219: if p_category_set_id is not null then
220: if p_plan_type = 10 then
221: insert into msc_hub_query(
222: query_id,
223: number1, -- plan_id
224: number2, -- plan_run_id
225: number3, -- owning_inst_id

Line 247: insert into msc_hub_query(

243: and f.inventory_item_id = ic.inventory_item_id(+)
244: and ic.category_set_id(+) = p_category_set_id;
245:
246: else
247: insert into msc_hub_query(
248: query_id,
249: number1, -- plan_id
250: number2, -- plan_run_id
251: number3, -- sr_instance_id