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,
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,
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,
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,
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,
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,
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: