DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 12: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_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,

Line 29: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

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,

Line 30: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

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,

Line 31: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE DEFAULT null,--bug#16791711

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,

Line 32: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

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,

Line 45: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

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,

Line 46: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

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,

Line 47: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE DEFAULT null,--bug#16791711

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,

Line 58: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

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: