APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_FORECAST_PVT

Line 1391: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1387:
1388: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1389: l_prev_Rec c_Usage_Details%ROWTYPE;
1390: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1391: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1392: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1393: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1394:
1395: l_Usage_Quantity NUMBER := 0;

Line 1392: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1388: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1389: l_prev_Rec c_Usage_Details%ROWTYPE;
1390: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1391: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1392: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1393: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1394:
1395: l_Usage_Quantity NUMBER := 0;
1396: l_Forecast_Quantity NUMBER := 0;

Line 1393: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1389: l_prev_Rec c_Usage_Details%ROWTYPE;
1390: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1391: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1392: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1393: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1394:
1395: l_Usage_Quantity NUMBER := 0;
1396: l_Forecast_Quantity NUMBER := 0;
1397: l_Usage_Data_Count NUMBER := 0;

Line 1462: CSP_Forecast_Pvt.Simple_Average

1458: For l_i in l_Usage_Qty_Tbl.COUNT..nvl(l_prev_rec.History_Periods,0) Loop
1459: l_Usage_Qty_Tbl(l_i) := 0;
1460: End Loop;
1461: If l_prev_rec.Forecast_Method = 1 Then
1462: CSP_Forecast_Pvt.Simple_Average
1463: (P_Usage_History => l_Usage_Qty_Tbl,
1464: P_History_Periods => l_prev_rec.History_Periods,
1465: P_Forecast_Periods => l_prev_rec.Forecast_Periods,
1466: X_Forecast_Quantities => l_Forecast_Qty_Tbl);

Line 1485: CSP_Forecast_Pvt.Weighted_Average

1481: Loop
1482:
1483: l_Weighted_Avg_Tbl(l_i) := 0;
1484: End Loop;
1485: CSP_Forecast_Pvt.Weighted_Average
1486: (P_Usage_History =>l_Usage_Qty_Tbl,
1487: P_History_Periods =>l_Prev_Rec.History_Periods,
1488: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1489: P_Weighted_Avg =>l_Weighted_Avg_Tbl,

Line 1492: CSP_Forecast_Pvt.Exponential_Smoothing

1488: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1489: P_Weighted_Avg =>l_Weighted_Avg_Tbl,
1490: X_Forecast_Quantities =>l_Forecast_Qty_Tbl);
1491: Elsif l_Prev_Rec.Forecast_Method = 3 Then
1492: CSP_Forecast_Pvt.Exponential_Smoothing
1493: (P_Usage_History =>l_Usage_Qty_Tbl,
1494: P_History_Periods =>l_Prev_Rec.History_Periods,
1495: P_Forecast_Periods => l_Prev_Rec.Forecast_Periods,
1496: P_Alpha =>l_Prev_Rec.Alpha,

Line 1500: CSP_Forecast_Pvt.Trend_Enhanced

1496: P_Alpha =>l_Prev_Rec.Alpha,
1497: X_Forecast_Quantities =>l_Forecast_Qty_Tbl);
1498:
1499: Elsif l_prev_rec.Forecast_Method = 4 Then
1500: CSP_Forecast_Pvt.Trend_Enhanced
1501: (P_Usage_History =>l_Usage_Qty_Tbl,
1502: P_History_Periods =>l_Prev_Rec.History_Periods,
1503: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1504: P_Alpha =>l_Prev_Rec.Alpha,