1 PACKAGE PA_FP_GEN_FCST_AMT_PUB5 AUTHID CURRENT_USER as
2 /* $Header: PAFPFG5S.pls 120.0.12020000.2 2013/05/17 10:21:36 bpottipa ship $ */
3
4 PROCEDURE GET_ETC_EARNED_VALUE_AMTS(
5 P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
6 P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
7 P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
8 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
9 P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
10 P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
11 P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
12 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
13 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
14 P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
15 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
16 X_MSG_COUNT OUT NOCOPY NUMBER,
17 X_MSG_DATA OUT NOCOPY VARCHAR2);
18
19 PROCEDURE GET_ETC_EARNED_VALUE_AMTS_BLK(
20 P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
21 P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
22 P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
23 P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
24 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
25 P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
26 P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
27 P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
28 P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
29 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
30 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
31 P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
32 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
33 X_MSG_COUNT OUT NOCOPY NUMBER,
34 X_MSG_DATA OUT NOCOPY VARCHAR2);
35
36
37 END PA_FP_GEN_FCST_AMT_PUB5;
[Home] [Help]