APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_FORECAST_PVT

Line 1411: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1407:
1408: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1409: l_prev_Rec c_Usage_Details%ROWTYPE;
1410: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1411: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1412: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1413: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1414:
1415: l_Usage_Quantity NUMBER := 0;

Line 1412: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1408: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1409: l_prev_Rec c_Usage_Details%ROWTYPE;
1410: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1411: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1412: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1413: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1414:
1415: l_Usage_Quantity NUMBER := 0;
1416: l_Forecast_Quantity NUMBER := 0;

Line 1413: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;

1409: l_prev_Rec c_Usage_Details%ROWTYPE;
1410: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1411: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1412: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1413: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1414:
1415: l_Usage_Quantity NUMBER := 0;
1416: l_Forecast_Quantity NUMBER := 0;
1417: l_Usage_Data_Count NUMBER := 0;

Line 1482: CSP_Forecast_Pvt.Simple_Average

1478: For l_i in l_Usage_Qty_Tbl.COUNT..nvl(l_prev_rec.History_Periods,0) Loop
1479: l_Usage_Qty_Tbl(l_i) := 0;
1480: End Loop;
1481: If l_prev_rec.Forecast_Method = 1 Then
1482: CSP_Forecast_Pvt.Simple_Average
1483: (P_Usage_History => l_Usage_Qty_Tbl,
1484: P_History_Periods => l_prev_rec.History_Periods,
1485: P_Forecast_Periods => l_prev_rec.Forecast_Periods,
1486: X_Forecast_Quantities => l_Forecast_Qty_Tbl);

Line 1505: CSP_Forecast_Pvt.Weighted_Average

1501: Loop
1502:
1503: l_Weighted_Avg_Tbl(l_i) := 0;
1504: End Loop;
1505: CSP_Forecast_Pvt.Weighted_Average
1506: (P_Usage_History =>l_Usage_Qty_Tbl,
1507: P_History_Periods =>l_Prev_Rec.History_Periods,
1508: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1509: P_Weighted_Avg =>l_Weighted_Avg_Tbl,

Line 1512: CSP_Forecast_Pvt.Exponential_Smoothing

1508: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1509: P_Weighted_Avg =>l_Weighted_Avg_Tbl,
1510: X_Forecast_Quantities =>l_Forecast_Qty_Tbl);
1511: Elsif l_Prev_Rec.Forecast_Method = 3 Then
1512: CSP_Forecast_Pvt.Exponential_Smoothing
1513: (P_Usage_History =>l_Usage_Qty_Tbl,
1514: P_History_Periods =>l_Prev_Rec.History_Periods,
1515: P_Forecast_Periods => l_Prev_Rec.Forecast_Periods,
1516: P_Alpha =>l_Prev_Rec.Alpha,

Line 1520: CSP_Forecast_Pvt.Trend_Enhanced

1516: P_Alpha =>l_Prev_Rec.Alpha,
1517: X_Forecast_Quantities =>l_Forecast_Qty_Tbl);
1518:
1519: Elsif l_prev_rec.Forecast_Method = 4 Then
1520: CSP_Forecast_Pvt.Trend_Enhanced
1521: (P_Usage_History =>l_Usage_Qty_Tbl,
1522: P_History_Periods =>l_Prev_Rec.History_Periods,
1523: P_Forecast_Periods =>l_Prev_Rec.Forecast_Periods,
1524: P_Alpha =>l_Prev_Rec.Alpha,