DBA Data[Home] [Help]

APPS.MSC_GET_BIS_VALUES dependencies on MSC_ANALYSIS_PKG

Line 2193: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);

2189: if ( p_instance_id is null and p_organization_id is null and p_item_id is null) then
2190: from_plan_node := true;
2191: end if;
2192:
2193: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);
2194: if (l_category_set_id is null) then
2195: l_category_set_str := '';
2196: else
2197: l_category_set_str := ' AND mic.category_set_id = '||l_category_set_id;

Line 2338: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);

2334: if ( p_instance_id is null and p_organization_id is null and p_item_id is null) then
2335: from_plan_node := true;
2336: end if;
2337:
2338: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);
2339: if (l_category_set_id is null) then
2340: l_category_set_str := '';
2341: else
2342: l_category_set_str := ' AND mic.category_set_id = '||l_category_set_id;

Line 2470: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);

2466: if ( p_instance_id is null and p_organization_id is null and p_item_id is null) then
2467: from_plan_node := true;
2468: end if;
2469:
2470: l_category_set_id := MSC_ANALYSIS_PKG.get_cat_set_id(p_plan_id);
2471: if (l_category_set_id is null) then
2472: l_category_set_str := '';
2473: else
2474: l_category_set_str := ' AND mic.category_set_id = '||l_category_set_id;