eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_PERIODS_ALL

Line 749: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

745: P_CALENDAR_TYPE IN VARCHAR2,
746: P_RECORD_TYPE IN VARCHAR2,
747: P_RESOURCE_LIST_ID IN NUMBER,
748: P_STRUCT_VER_ID IN NUMBER,
749: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
750: P_DATA_TYPE_CODE IN VARCHAR2,
751: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
752: X_MSG_COUNT OUT NOCOPY NUMBER,
753: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1003: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1004: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1005: P_ACTUALS_THRU_DATE IN DATE,
1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1009: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1010: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1011: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1004: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1005: P_ACTUALS_THRU_DATE IN DATE,
1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1009: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1010: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1011: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1012: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1009: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1005: P_ACTUALS_THRU_DATE IN DATE,
1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1009: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1010: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1011: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1012: X_MSG_COUNT OUT NOCOPY NUMBER,
1013: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1010: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1009: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1010: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1011: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1012: X_MSG_COUNT OUT NOCOPY NUMBER,
1013: X_MSG_DATA OUT NOCOPY VARCHAR2)
1014: IS

Line 1173: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS

1169: AND NVL(quantity,0) <> NVL(init_quantity,0)
1170: AND rownum < 2 )));
1171:
1172: --Cursor used to select the start_date for PA periods
1173: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1174: SELECT start_date
1175: FROM pa_periods_all
1176: WHERE period_name = c_period
1177: AND org_id = p_fp_cols_rec.x_org_id;

Line 1175: FROM pa_periods_all

1171:
1172: --Cursor used to select the start_date for PA periods
1173: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1174: SELECT start_date
1175: FROM pa_periods_all
1176: WHERE period_name = c_period
1177: AND org_id = p_fp_cols_rec.x_org_id;
1178:
1179: --Cursor used to select the start_date for GL periods

Line 1180: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS

1176: WHERE period_name = c_period
1177: AND org_id = p_fp_cols_rec.x_org_id;
1178:
1179: --Cursor used to select the start_date for GL periods
1180: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1181: SELECT start_date
1182: FROM gl_period_statuses
1183: WHERE period_name = c_period
1184: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id

Line 1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:
1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1196: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1197: l_currency_count NUMBER;
1198: l_currency_flag VARCHAR2(2);
1199:

Line 1196: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:
1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1196: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1197: l_currency_count NUMBER;
1198: l_currency_flag VARCHAR2(2);
1199:
1200: l_msg_count NUMBER;

Line 1468: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

1464: (P_ETC_SOURCE_CODE IN VARCHAR2,
1465: P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
1466: P_TASK_ID IN NUMBER,
1467: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1468: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1469: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1470: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1471: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1472: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1892: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

1888: P_ETC_SRC_BUDGET_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1889: P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
1890: P_TASK_ID IN NUMBER,
1891: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
1892: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1893: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1894: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1895: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1896: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2160: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

2156: (P_ETC_SOURCE_CODE IN VARCHAR2,
2157: P_RESOURCE_ASSIGNMENT_ID IN NUMBER,
2158: P_TASK_ID IN NUMBER,
2159: P_RESOURCE_LIST_MEMBER_ID IN NUMBER,
2160: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2161: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2162: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2164: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2631: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

2627: P_PROJ_CURRENCY_CODE IN VARCHAR2,
2628: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2629: P_TASK_ID IN NUMBER,
2630: P_TARGET_RES_LIST_ID IN NUMBER,
2631: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2632: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2633: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2634: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2635: X_MSG_COUNT OUT NOCOPY NUMBER,