[Home] [Help]
PACKAGE: APPS.PA_GENERATE_FORECAST_PUB
Source
1 PACKAGE PA_GENERATE_FORECAST_PUB AS
2 /* $Header: PARRFGPS.pls 120.1 2005/08/19 17:00:19 mwasowic noship $ */
3 TYPE Budget_Lines_Rec_Type
4 IS RECORD(
5 PERIOD_NAME PA_PERIODS.PERIOD_NAME%TYPE,
6 START_DATE PA_PERIODS.START_DATE%TYPE,
7 END_DATE PA_PERIODS.END_DATE%TYPE,
8 QUANTITY PA_BUDGET_LINES.QUANTITY%TYPE,
9 RAW_COST PA_BUDGET_LINES.RAW_COST%TYPE,
10 BURDENED_COST PA_BUDGET_LINES.BURDENED_COST%TYPE,
11 REVENUE PA_BUDGET_LINES.REVENUE%TYPE,
12 COST_REJECTION_CODE PA_BUDGET_LINES.COST_REJECTION_CODE%TYPE,
13 BURDEN_REJECTION_CODE PA_BUDGET_LINES.BURDEN_REJECTION_CODE%TYPE,
14 REVENUE_REJECTION_CODE PA_BUDGET_LINES.REVENUE_REJECTION_CODE%TYPE,
15 OTHER_REJECTION_CODE PA_BUDGET_LINES.REVENUE_REJECTION_CODE%TYPE,
16 ERROR_CODE PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE);
17
18 TYPE BUDGET_LINES_TBL_TYPE IS TABLE OF BUDGET_LINES_REC_TYPE
19 INDEX BY BINARY_INTEGER;
20
21
22 PROCEDURE Maintain_Budget_Version(p_project_id IN NUMBER,
23 p_plan_processing_code IN VARCHAR2,
24 x_budget_version_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
26 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
28
29 PROCEDURE Generate_Forecast(p_project_id IN NUMBER,
30 p_debug_mode IN VARCHAR2 DEFAULT 'N',
31 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
34
35 PROCEDURE Submit_Project_Forecast(p_project_id IN NUMBER,
36 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39
40 PROCEDURE Set_Error_Details(p_return_status IN VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
42 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 x_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44 x_msg_index_out OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
45 /* Global variables */
46 G_commit_cnt NUMBER := 500;
47 FUNCTION get_forecast_gen_date(p_project_id IN pa_projects_all.project_id%TYPE)
48 RETURN DATE;
49
50 END PA_GENERATE_FORECAST_PUB;