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_PVT dependencies on PA_PERIODS_ALL

Line 1352: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,
1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1352: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1353: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1354: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1355: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1356: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1353: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,
1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1352: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1353: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1354: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1355: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1356: X_MSG_COUNT OUT NOCOPY NUMBER,
1357: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1470: pa_periods_all pd

1466: x_txn_amt_rec.txn_raw_cost_sum,
1467: x_txn_amt_rec.txn_burdened_cost_sum,
1468: x_txn_amt_rec.txn_revenue_sum
1469: FROM PA_FP_FCST_GEN_TMP1 tmp,
1470: pa_periods_all pd
1471: WHERE tmp.data_type_code = 'TARGET_FP'
1472: AND tmp.project_element_id = P_TASK_ID
1473: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1474: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1507: pa_periods_all pd

1503: x_txn_amt_rec.txn_raw_cost_sum,
1504: x_txn_amt_rec.txn_burdened_cost_sum,
1505: x_txn_amt_rec.txn_revenue_sum
1506: FROM PA_FP_FCST_GEN_TMP1 tmp,
1507: pa_periods_all pd
1508: WHERE tmp.data_type_code = 'TARGET_FP'
1509: AND tmp.project_element_id = P_TASK_ID
1510: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1511: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1543: pa_periods_all pd

1539: x_txn_amt_rec.txn_raw_cost_sum,
1540: x_txn_amt_rec.txn_burdened_cost_sum,
1541: x_txn_amt_rec.txn_revenue_sum
1542: FROM PA_FP_FCST_GEN_TMP1 tmp,
1543: pa_periods_all pd
1544: WHERE tmp.data_type_code = 'TARGET_FP'
1545: AND tmp.project_element_id = P_TASK_ID
1546: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1547: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1560: pa_periods_all pd

1556: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1557: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1558: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1559: FROM PA_FP_FCST_GEN_TMP1 tmp,
1560: pa_periods_all pd
1561: WHERE tmp.data_type_code = 'TARGET_FP'
1562: AND tmp.project_element_id = P_TASK_ID
1563: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1564: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1577: pa_periods_all pd

1573: ELSIF P_FP_COLS_REC.x_version_type = 'COST' THEN
1574: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1575: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1576: FROM PA_FP_FCST_GEN_TMP1 tmp,
1577: pa_periods_all pd
1578: WHERE tmp.data_type_code = 'TARGET_FP'
1579: AND tmp.project_element_id = P_TASK_ID
1580: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1581: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1593: pa_periods_all pd

1589: ELSIF P_FP_COLS_REC.x_version_type = 'REVENUE' THEN
1590: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1591: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1592: FROM PA_FP_FCST_GEN_TMP1 tmp,
1593: pa_periods_all pd
1594: WHERE tmp.data_type_code = 'TARGET_FP'
1595: AND tmp.project_element_id = P_TASK_ID
1596: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1597: AND nvl(tmp.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711

Line 1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1988: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1989: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1990: P_ACTUALS_THRU_DATE IN DATE,
1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

Line 1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1989: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1990: P_ACTUALS_THRU_DATE IN DATE,
1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1990: P_ACTUALS_THRU_DATE IN DATE,
1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1998: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1991: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1998: X_MSG_COUNT OUT NOCOPY NUMBER,
1999: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

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

1998: X_MSG_COUNT OUT NOCOPY NUMBER,
1999: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2000:
2001: --Cursor used to select the start_date for PA periods
2002: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
2003: SELECT start_date
2004: FROM pa_periods_all
2005: WHERE period_name = c_period
2006: AND org_id = p_fp_cols_rec.x_org_id;

Line 2004: FROM pa_periods_all

2000:
2001: --Cursor used to select the start_date for PA periods
2002: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
2003: SELECT start_date
2004: FROM pa_periods_all
2005: WHERE period_name = c_period
2006: AND org_id = p_fp_cols_rec.x_org_id;
2007:
2008: --Cursor used to select the start_date for GL periods

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

2005: WHERE period_name = c_period
2006: AND org_id = p_fp_cols_rec.x_org_id;
2007:
2008: --Cursor used to select the start_date for GL periods
2009: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
2010: SELECT start_date
2011: FROM gl_period_statuses
2012: WHERE period_name = c_period
2013: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id

Line 2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2030: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2031:

Line 2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2030: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2031:
2032: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

Line 2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;

2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2030: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2031:
2032: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
2033: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 2030: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;

2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2030: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2031:
2032: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
2033: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
2034: l_txn_revenue_sum PA_BUDGET_LINES.TXN_REVENUE%TYPE;

Line 2197: FROM pa_periods_all

2193: IF p_fp_cols_rec.x_time_phased_code ='P' THEN
2194: SELECT period_name, start_date, end_date
2195: BULK COLLECT
2196: INTO l_period_name_tab, l_start_date_tab, l_end_date_tab
2197: FROM pa_periods_all
2198: WHERE org_id = p_fp_cols_rec.x_org_id
2199: AND start_date >= l_etc_from_date
2200: AND start_date <= least(p_planning_end_date,l_etc_to_date);
2201: ELSIF p_fp_cols_rec.x_time_phased_code ='G' THEN