1: PACKAGE BODY OZF_FORECAST_UTIL_PVT AS
2: /* $Header: ozfvfoub.pls 120.7 2006/10/04 20:56:27 mkothari noship $*/
3: /**
4: Fri Sep 29 2006:11/16 AM RSSHARMA Fixed bug # 5572679.Part MOAC fixes. Replaced retrieval of org_if FROM environment variable CLIENT_INFO by calling MO_GLOBAL package function.
5: Comprehensive fix remaing.
3: /**
4: Fri Sep 29 2006:11/16 AM RSSHARMA Fixed bug # 5572679.Part MOAC fixes. Replaced retrieval of org_if FROM environment variable CLIENT_INFO by calling MO_GLOBAL package function.
5: Comprehensive fix remaing.
6: */
7: g_pkg_name CONSTANT VARCHAR2(30):='OZF_FORECAST_UTIL_PVT';
8:
9: -----------------------------------------------------------
10: -- CF
11: -----------------------------------------------------------
3309: SET
3310: outer.incremental_sales =
3311: (
3312: select
3313: ROUND(NVL (SUM(sales.baseline_sales * NVL(OZF_FORECAST_UTIL_PVT.get_best_fit_lift
3314: (
3315: p_obj_type,
3316: p_obj_id,
3317: p_forecast_id,
3982: SET (outer.baseline_sales, outer.incremental_sales) =
3983: (
3984: select
3985: ROUND(NVL (SUM(sales.baseline_sales) ,0) ) baseline_sales,
3986: DECODE(l_tpr_percent, NULL, 0, ROUND(NVL (SUM(sales.baseline_sales * NVL(OZF_FORECAST_UTIL_PVT.get_best_fit_lift
3987: (
3988: p_obj_type,
3989: p_obj_id,
3990: p_forecast_id,
9108:
9109: -- x_standard_cost := l_standard_cost ;
9110:
9111: -- Get Other Costs here
9112: OZF_FORECAST_UTIL_PVT.get_other_costs (p_obj_type ,
9113: p_obj_id ,
9114: p_product_attribute ,
9115: p_product_attr_value ,
9116: l_fcst_uom ,
10721:
10722:
10723: END cascade_baseline_levels;
10724:
10725: END OZF_FORECAST_UTIL_PVT ;