[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_FCST_AMT_PVT
Source
1 PACKAGE PA_FP_GEN_FCST_AMT_PVT as
2 /* $Header: PAFPFGVS.pls 120.0 2005/05/30 08:39:20 appldev noship $ */
3
4 PROCEDURE GET_TOTAL_PLAN_TXN_AMTS
5 (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
6 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7 P_BV_ID_ETC_WP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8 P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9 P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10 P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
11 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
12 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
13 P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
14 P_CALLING_CONTEXT IN VARCHAR2,
15 X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
16 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
17 X_MSG_COUNT OUT NOCOPY NUMBER,
18 X_MSG_DATA OUT NOCOPY VARCHAR2);
19
20 PROCEDURE UPDATE_TOTAL_PLAN_AMTS
21 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
22 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
23 X_MSG_COUNT OUT NOCOPY NUMBER,
24 X_MSG_DATA OUT NOCOPY VARCHAR2);
25
26 PROCEDURE GET_ACTUAL_TXN_AMOUNT
27 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
28 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
29 P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
30 P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
31 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
32 P_CURRENCY_FLAG IN VARCHAR2,
33 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
34 P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
35 P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
36 X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
37 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
38 X_MSG_COUNT OUT NOCOPY NUMBER,
39 X_MSG_DATA OUT NOCOPY VARCHAR2);
40
41 PROCEDURE GEN_AVERAGE_OF_ACTUALS
42 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
43 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
44 P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
45 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
46 P_CURRENCY_FLAG IN VARCHAR2,
47 P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
48 P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
49 P_ACTUALS_THRU_DATE IN DATE,
50 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
51 P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
52 P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
53 P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
54 P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
55 P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
56 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
57 X_MSG_COUNT OUT NOCOPY NUMBER,
58 X_MSG_DATA OUT NOCOPY VARCHAR2);
59
60 PROCEDURE UPD_TGT_RATE_BASED_FLAG
61 (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
62 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
63 X_MSG_COUNT OUT NOCOPY NUMBER,
64 X_MSG_DATA OUT NOCOPY VARCHAR2);
65
66 END PA_FP_GEN_FCST_AMT_PVT;