PACKAGE: APPS.OZF_FORECAST_UTIL_PVT_W

Source

1 package ozf_forecast_util_pvt_w as
2   /* $Header: ozfwfous.pls 120.0 2005/11/04 18:50 mkothari noship $ */
3   function get_best_fit_lift(p_obj_type  VARCHAR2
4     , p_obj_id  NUMBER
5     , p_forecast_id  NUMBER
6     , p_base_quantity_ref  VARCHAR2
7     , p_market_type  VARCHAR2
8     , p_market_id  NUMBER
9     , p_product_attribute_context  VARCHAR2
10     , p_product_attribute  VARCHAR2
11     , p_product_attr_value  VARCHAR2
12     , p_product_id  NUMBER
13     , p_tpr_percent  NUMBER
14     , p_report_date  date
15   ) return number;
16   procedure create_forecast(p_api_version  NUMBER
17     , p_init_msg_list  VARCHAR2
18     , p_commit  VARCHAR2
19     , p_obj_type  VARCHAR2
20     , p_obj_id  NUMBER
21     , p_fcst_uom  VARCHAR2
22     , p_start_date  date
23     , p_end_date  date
24     , p_base_quantity_type  VARCHAR2
25     , p_base_quantity_ref  VARCHAR2
26     , p_last_scenario_id  NUMBER
27     , p_offer_code  VARCHAR2
28     , x_forecast_id in out nocopy  NUMBER
29     , x_activity_metric_id out nocopy  NUMBER
30     , x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
33   );
34   procedure create_base_sales(p_api_version  NUMBER
35     , p_init_msg_list  VARCHAR2
36     , p_commit  VARCHAR2
37     , p_obj_type  VARCHAR2
38     , p_obj_id  NUMBER
39     , p_forecast_id  NUMBER
40     , p_activity_metric_id  NUMBER
41     , p_level  VARCHAR2
42     , p_dimention  VARCHAR2
43     , p_fcst_uom  VARCHAR2
44     , p_start_date  date
45     , p_end_date  date
46     , p_period_level  VARCHAR2
47     , p_base_quantity_type  VARCHAR2
48     , p_base_quantity_ref  VARCHAR2
49     , p_last_forecast_id  NUMBER
50     , p_base_quantity_start_date  date
51     , p_base_quantity_end_date  date
52     , p_offer_code  VARCHAR2
53     , p19_a0 out nocopy  NUMBER
54     , p19_a1 out nocopy  NUMBER
55     , x_return_status out nocopy  VARCHAR2
56     , x_msg_count out nocopy  NUMBER
57     , x_msg_data out nocopy  VARCHAR2
58   );
59 end ozf_forecast_util_pvt_w;