APPS.MSC_GET_BIS_VALUES dependencies on MSC_UTIL

Line 2879: MSC_UTIL.MSC_DEBUG('v_status='||v_status);

2875: elsif p_status = 'ONE_DONE' then
2876: v_status := v_kpi_refresh + 1;
2877: end if;
2878:
2879: MSC_UTIL.MSC_DEBUG('v_status='||v_status);
2880: update msc_plans
2881: set kpi_refresh = decode(v_status,0,0,-1,-1,kpi_refresh+1)
2882: where plan_id = p_plan_id;
2883:

Line 2895: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_DATE_MV_TAB table for plan id '||p_plan_id);

2891: p_plan_type number) IS
2892: BEGIN
2893: if p_kpi_table =1 then
2894:
2895: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_DATE_MV_TAB table for plan id '||p_plan_id);
2896:
2897: delete from msc_bis_inv_date_mv_tab
2898: where plan_id = p_plan_id;
2899: if p_plan_type = 8 then -- should change to srp

Line 2999: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);

2995: sr_instance_id,
2996: detail_date;
2997: end if; -- if p_plan_type =
2998: elsif p_kpi_table =2 then
2999: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3000: delete from msc_bis_inv_cat_mv_tab
3001: where plan_id = p_plan_id;
3002:
3003: insert into msc_bis_inv_cat_mv_tab(

Line 3060: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);

3056: mit.category_set_id,
3057: mbis.detail_date;
3058:
3059: elsif p_kpi_table = 3 then
3060: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);
3061: delete from msc_demand_mv_tab
3062: where plan_id = p_plan_id;
3063:
3064: insert into msc_demand_mv_tab(

Line 3092: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);

3088: organization_id,
3089: sr_instance_id;
3090:
3091: elsif p_kpi_table = 4 then
3092: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);
3093: delete from msc_late_order_mv_tab
3094: where plan_id = p_plan_id;
3095:
3096: insert into msc_late_order_mv_tab(

Line 3124: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_RES_DATE_MV_TAB table for plan id '||p_plan_id);

3120: organization_id,
3121: sr_instance_id;
3122:
3123: elsif p_kpi_table = 5 then
3124: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_RES_DATE_MV_TAB table for plan id '||p_plan_id);
3125: delete from msc_bis_res_date_mv_tab
3126: where plan_id = p_plan_id;
3127:
3128: insert into msc_bis_res_date_mv_tab(

Line 3209: MSC_UTIL.msc_debug('---- refreshing tree mv----');

3205: l_req_id number;
3206: Begin
3207:
3208: if v_tree_exist =1 then
3209: MSC_UTIL.msc_debug('---- refreshing tree mv----');
3210: DBMS_SNAPSHOT.REFRESH( lv_msc_schema||'.MSC_SUPPLIER_TREE_MV');
3211: end if;
3212:
3213: msc_get_bis_values.refresh_kpi_data(p_plan_id);