[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_FCST_AMT_PVT
Source
1 PACKAGE PA_FP_GEN_FCST_AMT_PVT AUTHID CURRENT_USER as
2 /* $Header: PAFPFGVS.pls 120.1.12020000.2 2013/05/17 11:39:26 bpottipa ship $ */
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_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', --Changes done for bug#10406949,FP Bug#12800007
14 P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
15 P_CALLING_CONTEXT IN VARCHAR2,
16 X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
17 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
18 X_MSG_COUNT OUT NOCOPY NUMBER,
19 X_MSG_DATA OUT NOCOPY VARCHAR2);
20
21 PROCEDURE UPDATE_TOTAL_PLAN_AMTS
22 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
23 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
24 X_MSG_COUNT OUT NOCOPY NUMBER,
25 X_MSG_DATA OUT NOCOPY VARCHAR2);
26
27 PROCEDURE GET_ACTUAL_TXN_AMOUNT
28 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
29 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
30 P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
31 P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE DEFAULT null,--bug#16791711
32 P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
33 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
34 P_CURRENCY_FLAG IN VARCHAR2,
35 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
36 P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
37 P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
38 X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY NUMBER,
41 X_MSG_DATA OUT NOCOPY VARCHAR2);
42
43 PROCEDURE GEN_AVERAGE_OF_ACTUALS
44 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
45 P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
46 P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
47 P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE DEFAULT null,--bug#16791711
48 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
49 P_CURRENCY_FLAG IN VARCHAR2,
50 P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
51 P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
52 P_ACTUALS_THRU_DATE IN DATE,
53 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
54 P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
55 P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
56 P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
57 P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE DEFAULT null,
58 P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2);
62
63 PROCEDURE UPD_TGT_RATE_BASED_FLAG
64 (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2);
68
69 END PA_FP_GEN_FCST_AMT_PVT;