1 PACKAGE PA_FP_GEN_FCST_AMT_PUB AUTHID CURRENT_USER as
2 /* $Header: PAFPFGPS.pls 120.0 2005/05/30 07:25:40 appldev noship $ */
3
4 TYPE TXN_AMT_REC_TYP IS RECORD
5 ( QUANTITY_SUM PA_BUDGET_LINES.QUANTITY%TYPE,
6 TXN_RAW_COST_SUM PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
7 TXN_BURDENED_COST_SUM PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
8 TXN_REVENUE_SUM PA_BUDGET_LINES.TXN_REVENUE%TYPE,
9 NO_OF_PERIODS NUMBER);
10
11 PROCEDURE GENERATE_FCST_AMT_WRP
12 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
13 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15 P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
16 P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
17 P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'Y',
18 P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
19 P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
20 P_UNSPENT_AMT_PERIOD IN VARCHAR2,
21 P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
22 P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
23 P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
24 P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
25 P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
26 P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
27 P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
28 P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
29 P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
30 P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
31 P_ACTUALS_FROM_PERIOD IN VARCHAR2,
32 P_ACTUALS_TO_PERIOD IN VARCHAR2,
33 P_ETC_FROM_PERIOD IN VARCHAR2,
34 P_ETC_TO_PERIOD IN VARCHAR2,
35 P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
36 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
37 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_COUNT OUT NOCOPY NUMBER,
40 X_MSG_DATA OUT NOCOPY VARCHAR2);
41
42 PROCEDURE GEN_FCST_TASK_LEVEL_AMT
43 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
44 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
45 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
46 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
47 P_ETC_FP_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
48 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
49 P_ACTUALS_FROM_PERIOD IN VARCHAR2,
50 P_ACTUALS_TO_PERIOD IN VARCHAR2,
51 P_ETC_FROM_PERIOD IN VARCHAR2,
52 P_ETC_TO_PERIOD IN VARCHAR2,
53 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
54 X_MSG_COUNT OUT NOCOPY NUMBER,
55 X_MSG_DATA OUT NOCOPY VARCHAR2);
56
57 PROCEDURE MAINTAIN_RES_ASG(
58 P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
59 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
60 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
61 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 X_MSG_DATA OUT NOCOPY VARCHAR2);
64
65 END PA_FP_GEN_FCST_AMT_PUB;