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',
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,
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,
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,
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);