APPS.MSC_GET_BIS_VALUES dependencies on MSC_UTIL

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

2886: elsif p_status = 'ONE_DONE' then
2887: v_status := v_kpi_refresh + 1;
2888: end if;
2889:
2890: MSC_UTIL.MSC_DEBUG('v_status='||v_status);
2891: update msc_plans
2892: set kpi_refresh = decode(v_status,0,0,-1,-1,kpi_refresh+1)
2893: where plan_id = p_plan_id;
2894:

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

2902: p_plan_type number) IS
2903: BEGIN
2904: if p_kpi_table =1 then
2905:
2906: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_DATE_MV_TAB table for plan id '||p_plan_id);
2907:
2908: delete from msc_bis_inv_date_mv_tab
2909: where plan_id = p_plan_id;
2910: if p_plan_type = 8 then -- should change to srp

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

3006: sr_instance_id,
3007: detail_date;
3008: end if; -- if p_plan_type =
3009: elsif p_kpi_table =2 then
3010: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_INV_CAT_MV_TAB table for plan id '||p_plan_id);
3011: delete from msc_bis_inv_cat_mv_tab
3012: where plan_id = p_plan_id;
3013:
3014: insert into msc_bis_inv_cat_mv_tab(

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

3067: mit.category_set_id,
3068: mbis.detail_date;
3069:
3070: elsif p_kpi_table = 3 then
3071: MSC_UTIL.MSC_DEBUG('refreshing MSC_DEMAND_MV_TAB table for plan id '||p_plan_id);
3072: delete from msc_demand_mv_tab
3073: where plan_id = p_plan_id;
3074:
3075: insert into msc_demand_mv_tab(

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

3099: organization_id,
3100: sr_instance_id;
3101:
3102: elsif p_kpi_table = 4 then
3103: MSC_UTIL.MSC_DEBUG('refreshing MSC_LATE_ORDER_MV_TAB table for plan id '||p_plan_id);
3104: delete from msc_late_order_mv_tab
3105: where plan_id = p_plan_id;
3106:
3107: insert into msc_late_order_mv_tab(

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

3131: organization_id,
3132: sr_instance_id;
3133:
3134: elsif p_kpi_table = 5 then
3135: MSC_UTIL.MSC_DEBUG('refreshing MSC_BIS_RES_DATE_MV_TAB table for plan id '||p_plan_id);
3136: delete from msc_bis_res_date_mv_tab
3137: where plan_id = p_plan_id;
3138:
3139: insert into msc_bis_res_date_mv_tab(

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

3219: l_req_id number;
3220: Begin
3221:
3222: if v_tree_exist =1 then
3223: MSC_UTIL.msc_debug('---- refreshing tree mv----');
3224: DBMS_SNAPSHOT.REFRESH( lv_msc_schema||'.MSC_SUPPLIER_TREE_MV');
3225: end if;
3226: OPEN plan_c;
3227: FETCH plan_c INTO v_show_kpi, v_plan_type, l_autorelease,l_generate_worksheet;

Line 3264: msc_util.msc_debug('MSCHUBA not invoked, v_show_kpi='||v_show_kpi||', v_plan_type='||v_plan_type);

3260: close c_plan_archive;
3261: l_req_id := fnd_request.submit_request('MSC','MSCHUBA',NULL, NULL, FALSE, p_plan_id, null, l_archive_flag);
3262: commit;
3263: else
3264: msc_util.msc_debug('MSCHUBA not invoked, v_show_kpi='||v_show_kpi||', v_plan_type='||v_plan_type);
3265: end if;
3266: --pabram..phub ends
3267:
3268: -- Synchronize ASCP ADF UI data.