eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_FORECAST_PVT dependencies on CSP_FORECAST_PVT

Line 1: Package Body CSP_FORECAST_PVT AS

1: Package Body CSP_FORECAST_PVT AS
2: /* $Header: cspvpfob.pls 120.1 2006/02/03 00:54:34 hhaugeru noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_FORECAST_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_FORECAST_PVT';

1: Package Body CSP_FORECAST_PVT AS
2: /* $Header: cspvpfob.pls 120.1 2006/02/03 00:54:34 hhaugeru noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_FORECAST_PVT';
6:
7:
8: FUNCTION period_end_date(
9: p_organization_id IN NUMBER,

Line 39: x_period_start_dates OUT NOCOPY csp_forecast_pvt.t_date_table) IS

35: p_start_date IN DATE,
36: p_period_type IN NUMBER,
37: p_number_of_periods IN NUMBER,
38: p_organization_id IN NUMBER,
39: x_period_start_dates OUT NOCOPY csp_forecast_pvt.t_date_table) IS
40:
41: l_count NUMBER := 0;
42: l_start_date DATE;
43:

Line 111: p_usage_history IN csp_forecast_pvt.t_number_table,

107: end if;
108: end;
109:
110: PROCEDURE simple_average(
111: p_usage_history IN csp_forecast_pvt.t_number_table,
112: p_history_periods IN NUMBER,
113: p_forecast_periods IN NUMBER,
114: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
115:

Line 114: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

110: PROCEDURE simple_average(
111: p_usage_history IN csp_forecast_pvt.t_number_table,
112: p_history_periods IN NUMBER,
113: p_forecast_periods IN NUMBER,
114: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
115:
116: l_count NUMBER;
117: l_total_quantity NUMBER := 0;
118: l_forecast NUMBER;

Line 131: p_usage_history IN csp_forecast_pvt.t_number_table,

127: end loop;
128: end simple_average;
129:
130: PROCEDURE weighted_average(
131: p_usage_history IN csp_forecast_pvt.t_number_table,
132: p_history_periods IN NUMBER,
133: p_forecast_periods IN NUMBER,
134: p_weighted_avg IN csp_forecast_pvt.t_number_table,
135: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

Line 134: p_weighted_avg IN csp_forecast_pvt.t_number_table,

130: PROCEDURE weighted_average(
131: p_usage_history IN csp_forecast_pvt.t_number_table,
132: p_history_periods IN NUMBER,
133: p_forecast_periods IN NUMBER,
134: p_weighted_avg IN csp_forecast_pvt.t_number_table,
135: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
136:
137: l_count NUMBER;
138: l_count1 NUMBER := 0;

Line 135: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

131: p_usage_history IN csp_forecast_pvt.t_number_table,
132: p_history_periods IN NUMBER,
133: p_forecast_periods IN NUMBER,
134: p_weighted_avg IN csp_forecast_pvt.t_number_table,
135: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
136:
137: l_count NUMBER;
138: l_count1 NUMBER := 0;
139: l_forecast NUMBER := 0;

Line 152: p_usage_history IN csp_forecast_pvt.t_number_table,

148: end loop;
149: end weighted_average;
150:
151: PROCEDURE exponential_smoothing(
152: p_usage_history IN csp_forecast_pvt.t_number_table,
153: p_history_periods IN NUMBER,
154: p_forecast_periods IN NUMBER,
155: p_alpha IN NUMBER,
156: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

Line 156: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

152: p_usage_history IN csp_forecast_pvt.t_number_table,
153: p_history_periods IN NUMBER,
154: p_forecast_periods IN NUMBER,
155: p_alpha IN NUMBER,
156: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
157:
158: l_count NUMBER := 0;
159: l_forecast NUMBER := 0;
160: l_actual NUMBER := 0;

Line 173: p_usage_history IN csp_forecast_pvt.t_number_table,

169: end loop;
170: end exponential_smoothing;
171:
172: PROCEDURE trend_enhanced(
173: p_usage_history IN csp_forecast_pvt.t_number_table,
174: p_history_periods IN NUMBER,
175: p_forecast_periods IN NUMBER,
176: p_alpha IN NUMBER,
177: p_beta IN NUMBER,

Line 178: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS

174: p_history_periods IN NUMBER,
175: p_forecast_periods IN NUMBER,
176: p_alpha IN NUMBER,
177: p_beta IN NUMBER,
178: x_forecast_quantities OUT NOCOPY csp_forecast_pvt.t_number_table) IS
179:
180: l_count NUMBER := 0;
181: l_forecast NUMBER := 0;
182: l_actual NUMBER := 0;