[Home] [Help]
PACKAGE: APPS.PA_FP_COPY_ACTUALS_PUB
Source
1 PACKAGE PA_FP_COPY_ACTUALS_PUB AUTHID CURRENT_USER as
2 /* $Header: PAFPCAPS.pls 120.0.12010000.2 2009/06/15 10:18:09 gboomina ship $ */
3 PROCEDURE COPY_ACTUALS
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_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
7 P_END_DATE IN DATE,
8 P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
9 P_COMMIT_FLAG IN VARCHAR2 default 'N',
10 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
11 X_MSG_COUNT OUT NOCOPY NUMBER,
12 X_MSG_DATA OUT NOCOPY VARCHAR2);
13
14 /* Valid values for p_calling_process
15 COPY_ACTUALS
16 FORECAST_GENERATION
17 */
18 PROCEDURE CREATE_RES_ASG (
19 P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
20 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
21 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS DEFAULT NULL,
22 p_calling_process IN VARCHAR2 default 'COPY_ACTUALS',
23 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
24 X_MSG_COUNT OUT NOCOPY NUMBER,
25 X_MSG_DATA OUT NOCOPY VARCHAR2);
26
27
28 PROCEDURE UPDATE_RES_ASG (
29 P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
30 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
31 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS DEFAULT NULL,
32 p_calling_process IN VARCHAR2 default 'COPY_ACTUALS',
33 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34 X_MSG_COUNT OUT NOCOPY NUMBER,
35 X_MSG_DATA OUT NOCOPY VARCHAR2);
36
37 /**
38 * gboomina added this method for AAI requirement
39 * This procedure is called to collect actuals for a selected resource assignments or
40 * for a whole budget version given.
41 **/
42 PROCEDURE COLLECT_ACTUALS
43 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
44 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
45 P_RESOURCE_ASSGN_IDS IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
46 P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
47 P_COMMIT_FLAG IN VARCHAR2 default 'N',
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_COPY_ACTUALS_PUB;