1 Package CSP_FORECAST_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvpfos.pls 115.9 2002/11/26 08:00:40 hhaugeru ship $ */
3
4 TYPE t_number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE t_date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
6
7 FUNCTION period_end_date(
8 p_organization_id IN NUMBER,
9 p_period_type IN NUMBER,
10 p_period_start_date IN DATE)
11 RETURN DATE;
12
13 PROCEDURE period_start_dates(
14 p_start_date IN DATE,
15 p_period_type IN NUMBER,
16 p_number_of_periods IN NUMBER,
17 p_organization_id IN NUMBER,
18 x_period_start_dates OUT NOCOPY csp_forecast_pvt.t_date_table);
19
20 PROCEDURE simple_average(
21 p_usage_history IN csp_forecast_pvt.t_number_table,
22 p_history_periods IN NUMBER,
23 p_forecast_periods IN NUMBER,
24 x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table);
25
26 PROCEDURE weighted_average(
27 p_usage_history IN csp_forecast_pvt.t_number_table,
28 p_history_periods IN NUMBER,
29 p_forecast_periods IN NUMBER,
30 p_weighted_avg IN csp_forecast_pvt.t_number_table,
31 x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table);
32
33 PROCEDURE exponential_smoothing(
34 p_usage_history IN csp_forecast_pvt.t_number_table,
35 p_history_periods IN NUMBER,
36 p_forecast_periods IN NUMBER,
37 p_alpha IN NUMBER,
38 x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table);
39
40 PROCEDURE trend_enhanced(
41 p_usage_history IN csp_forecast_pvt.t_number_table,
42 p_history_periods IN NUMBER,
43 p_forecast_periods IN NUMBER,
44 p_alpha IN NUMBER,
45 p_beta IN NUMBER,
46 x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table);
47
48 PROCEDURE create_forecast(
49 p_api_version IN NUMBER,
50 p_parts_loop_id IN NUMBER,
51 p_organization_id IN NUMBER,
52 p_subinventory_code IN VARCHAR2 DEFAULT '-',
53 p_inventory_item_id IN NUMBER,
54 p_start_date IN DATE,
55 x_start_date OUT NOCOPY DATE,
56 x_end_date OUT NOCOPY DATE,
57 x_period_type OUT NOCOPY NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2);
61
62 PROCEDURE rollback_forecast;
63
64 END csp_forecast_pvt;
65