APPS.MSC_GET_BIS_VALUES dependencies on MSC_GET_BIS_VALUES

Line 1: PACKAGE BODY Msc_Get_Bis_Values AS

1: PACKAGE BODY Msc_Get_Bis_Values AS
2: /* $Header: MSCBISUB.pls 120.7.12010000.3 2008/09/10 20:04:44 pabram ship $ */
3:
4: g_plan_start_date DATE;
5: g_period_zero_date date;

Line 537: v_tp_cost := msc_get_bis_values.get_tp_cost(p_plan_id,

533: p_out1 := v_production;
534: p_out2 := v_purchasing;
535: p_out3 := v_penalty;
536: p_out4 := v_inventory;
537: v_tp_cost := msc_get_bis_values.get_tp_cost(p_plan_id,
538: p_instance_id, p_organization_id, p_product_family_id, null, null);
539: p_out5 := v_tp_cost;
540: elsif p_chart = SERVICE_LEVEL then
541: p_out1 := v_service;

Line 634: v_tp_cost := msc_get_bis_values.get_tp_cost(p_plan_id,

630: l_start_date,
631: l_end_date, g_use_old_demand_qty);
632: else
633: if p_chart = COST_BREAKDOWN then
634: v_tp_cost := msc_get_bis_values.get_tp_cost(p_plan_id,
635: p_instance_id, p_organization_id, p_product_family_id, l_start_date, l_end_date);
636: end if;
637: if p_organization_id is not null then
638: if p_product_family_id is not null then

Line 1150: l_value1 := msc_get_bis_values.late_orders(p_plan_id,

1146:
1147: return 100;
1148: else
1149:
1150: l_value1 := msc_get_bis_values.late_orders(p_plan_id,
1151: p_instance_id,p_organization_id,NULL,NULL,
1152: p_inventory_item_id, p_project_id, p_task_id,
1153: p_category_id,p_category_name,p_category_set_id,
1154: p_product_family_id);

Line 1621: l_value1 :=msc_get_bis_values.late_orders(

1617: if l_value2 = 0 or l_value2 is null then
1618: l_value :=100;
1619:
1620: else
1621: l_value1 :=msc_get_bis_values.late_orders(
1622: p_plan_id,p_instance_id,p_org_id,
1623: l_start_date,l_end_date,
1624: p_inventory_item_id, p_project_id, p_task_id,
1625: p_category_id,p_category_name,

Line 2778: msc_get_bis_values.refresh_data(l_err_buf, l_ret_code,p_plan_id, v_plan_type);

2774: CLOSE show_kpi;
2775:
2776: if nvl(v_show_kpi,1) = 1 then
2777: FND_FILE.PUT_LINE(FND_FILE.LOG,'--- refreshing summary data for kpi ---');
2778: msc_get_bis_values.refresh_data(l_err_buf, l_ret_code,p_plan_id, v_plan_type);
2779: else -- set kpi status as not refresh
2780: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'NOT REFRESH');
2781: end if;
2782: exception when others then

Line 2780: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'NOT REFRESH');

2776: if nvl(v_show_kpi,1) = 1 then
2777: FND_FILE.PUT_LINE(FND_FILE.LOG,'--- refreshing summary data for kpi ---');
2778: msc_get_bis_values.refresh_data(l_err_buf, l_ret_code,p_plan_id, v_plan_type);
2779: else -- set kpi status as not refresh
2780: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'NOT REFRESH');
2781: end if;
2782: exception when others then
2783: FND_FILE.PUT_LINE(FND_FILE.LOG,'refreshing kpi summary data fails');
2784: END refresh_kpi_data;

Line 3169: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');

3165: res.sr_instance_id,
3166: res.resource_date;
3167: end if;
3168: commit;
3169: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');
3170: exception when no_data_found then
3171: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');
3172: END refresh_one_table;
3173:

Line 3171: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');

3167: end if;
3168: commit;
3169: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');
3170: exception when no_data_found then
3171: msc_get_bis_values.set_kpi_refresh_status(p_plan_id,'ONE_DONE');
3172: END refresh_one_table;
3173:
3174: Procedure ui_post_plan(errbuf OUT NOCOPY VARCHAR2,
3175: retcode OUT NOCOPY NUMBER,

Line 3213: msc_get_bis_values.refresh_kpi_data(p_plan_id);

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);
3214:
3215: msc_launch_plan_pk.purge_user_notes_data(p_plan_id);
3216:
3217: msc_netchange_pkg.compare_plan_need_refresh(p_plan_id);

Line 3251: END Msc_Get_Bis_Values;

3247:
3248: End ui_post_plan;
3249:
3250:
3251: END Msc_Get_Bis_Values;