DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_PERIODS_ALL

Line 36: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
33: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
35: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
36: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
37: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
38: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39: X_MSG_COUNT OUT NOCOPY NUMBER,
40: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2341: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
2339: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
2340: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2341: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2342: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
2343: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2344: X_MSG_COUNT OUT NOCOPY NUMBER,
2345: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3753: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

3749: PROCEDURE GET_ETC_FROM_SRC_BDGT
3750: (P_FP_COLS_SRC_FP_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
3751: P_FP_COLS_SRC_WP_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
3752: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
3753: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
3754: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3755: X_MSG_COUNT OUT NOCOPY NUMBER,
3756: X_MSG_DATA OUT NOCOPY VARCHAR2)
3757: IS

Line 5211: FROM PA_PERIODS_ALL PAP ,

5207: PAP.START_DATE ,
5208: PAP.END_DATE ,
5209: GLP.START_DATE ,
5210: GLP.END_DATE
5211: FROM PA_PERIODS_ALL PAP ,
5212: GL_PERIODS GLP ,
5213: GL_SETS_OF_BOOKS GSOB ,
5214: PA_IMPLEMENTATIONS_ALL PAIMP
5215: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME