[Home] [Help]
PACKAGE: APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB
Source
1 PACKAGE PA_FP_WP_GEN_BUDGET_AMT_PUB as
2 /* $Header: PAFPWPGS.pls 120.0 2005/05/29 13:32:24 appldev noship $ */
3 PROCEDURE GENERATE_WP_BUDGET_AMT
4 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6 P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE DEFAULT 'Budget',
7 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE
8 DEFAULT 'WORKPLAN_RESOURCES',
9 P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
10 P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
11 P_RETAIN_MANUAL_FLAG IN VARCHAR2 DEFAULT NULL,
12 P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
13 P_INC_CHG_DOC_FLAG IN VARCHAR2 DEFAULT 'N',
14 P_INC_BILL_EVENT_FLAG IN VARCHAR2 DEFAULT 'N',
15 P_INC_OPEN_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
16 P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp
17 DEFAULT PA_PLSQL_DATATYPES.EmptyIdTab,
18 P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'Y',
19 P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
20 P_CALLING_CONTEXT IN VARCHAR2 DEFAULT 'BUDGET_GENERATION',
21 P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE DEFAULT NULL,
22 P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE DEFAULT NULL,
23 P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE DEFAULT NULL,
24 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
25 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
26 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER,
29 X_MSG_DATA OUT NOCOPY VARCHAR2);
30
31 PROCEDURE MAINTAIN_BUDGET_LINES
32 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
33 P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
34 P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
35 P_CALLING_CONTEXT IN VARCHAR2 DEFAULT 'BUDGET_GENERATION',
36 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
37 P_RETAIN_MANUAL_FLAG IN VARCHAR2 DEFAULT 'N',
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_COUNT OUT NOCOPY NUMBER,
40 X_MSG_DATA OUT NOCOPY VARCHAR2);
41
42 PROCEDURE GET_CALC_API_FLAG_PARAMS
43 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
44 P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
45 P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
46 P_CALLING_CONTEXT IN VARCHAR2 DEFAULT 'BUDGET_GENERATION',
47 X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,
48 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49 X_MSG_COUNT OUT NOCOPY NUMBER,
50 X_MSG_DATA OUT NOCOPY VARCHAR2);
51
52 END PA_FP_WP_GEN_BUDGET_AMT_PUB;