1 PACKAGE AS_SCN_FORECAST_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvpems.pls 115.6 2002/11/15 20:43:40 clwang ship $ */
3
4 -- Start of Comments
5 -- API name: Get_Forecast_Amounts
6 -- Type: Private
7 -- Description:
8 --
9 -- Pre-reqs:
10 --
11 -- IN PARAMETERS:
12 -- p_api_version_number IN NUMBER (Standard)
13 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE (Standard)
14 -- p_check_access_flag IN VARCHAR2 (Standard - "Y" by default) to verify the access.
15 -- p_resource_id IN NUMBER (resource_id for which forecast needs to be collected
16 -- p_quota_id IN NUMBER (Plan Element ID )
17 -- p_period_name IN VARCHAR2 ( period name as in OSO)
18 -- p_to_currency_code IN VARCHAR2 ( currency code in which you want to see the amounts)
19
20 -- OUT PARAMETERS
21 -- x_return_status: (API standard)
22 -- x_msg_count: (API standard)
23 -- x_msg_data: (API standard)
24 -- x_forecast_amount_tbl - forecast out put for every sales category
25 --
26 -- Version: Current version 2.0
27 --
28 -- Note:
29 -- This API is supposed to be used by Sales Comp for Income planner for individual
30 -- when calling this api, user needs to pass in p_resource_id ,p_quota_id ,
31 -- p_period_name and p_to_currency_code
32 --
33 -- End of Comments
34
35 PROCEDURE Get_Forecast_Amounts (
36 p_api_version_number IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38 p_check_access_flag IN VARCHAR2,
39 p_resource_id IN NUMBER,
40 p_quota_id IN NUMBER,
41 p_period_name IN VARCHAR2,
42 p_to_currency_code IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_forecast_amount_tbl OUT NOCOPY AS_SCN_FORECAST_PUB.FORECAST_TBL_TYPE);
47
48
49 END AS_SCN_FORECAST_PVT;
50