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 1338: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,
1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1338: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1339: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1340: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1341: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1342: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1339: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,
1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1338: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1339: P_ACTUAL_TO_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,
1340: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
1341: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1342: X_MSG_COUNT OUT NOCOPY NUMBER,
1343: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1455: pa_periods_all pd

1451: x_txn_amt_rec.txn_raw_cost_sum,
1452: x_txn_amt_rec.txn_burdened_cost_sum,
1453: x_txn_amt_rec.txn_revenue_sum
1454: FROM PA_FP_FCST_GEN_TMP1 tmp,
1455: pa_periods_all pd
1456: WHERE tmp.data_type_code = 'TARGET_FP'
1457: AND tmp.project_element_id = P_TASK_ID
1458: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1459: AND (NVL(tmp.quantity,0) <> 0

Line 1491: pa_periods_all pd

1487: x_txn_amt_rec.txn_raw_cost_sum,
1488: x_txn_amt_rec.txn_burdened_cost_sum,
1489: x_txn_amt_rec.txn_revenue_sum
1490: FROM PA_FP_FCST_GEN_TMP1 tmp,
1491: pa_periods_all pd
1492: WHERE tmp.data_type_code = 'TARGET_FP'
1493: AND tmp.project_element_id = P_TASK_ID
1494: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1495: AND (NVL(tmp.quantity,0) <> 0

Line 1526: pa_periods_all pd

1522: x_txn_amt_rec.txn_raw_cost_sum,
1523: x_txn_amt_rec.txn_burdened_cost_sum,
1524: x_txn_amt_rec.txn_revenue_sum
1525: FROM PA_FP_FCST_GEN_TMP1 tmp,
1526: pa_periods_all pd
1527: WHERE tmp.data_type_code = 'TARGET_FP'
1528: AND tmp.project_element_id = P_TASK_ID
1529: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1530: AND (NVL(tmp.quantity,0) <> 0

Line 1542: pa_periods_all pd

1538: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1539: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1540: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1541: FROM PA_FP_FCST_GEN_TMP1 tmp,
1542: pa_periods_all pd
1543: WHERE tmp.data_type_code = 'TARGET_FP'
1544: AND tmp.project_element_id = P_TASK_ID
1545: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1546: AND (NVL(tmp.quantity,0) <> 0

Line 1558: pa_periods_all pd

1554: ELSIF P_FP_COLS_REC.x_version_type = 'COST' THEN
1555: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1556: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1557: FROM PA_FP_FCST_GEN_TMP1 tmp,
1558: pa_periods_all pd
1559: WHERE tmp.data_type_code = 'TARGET_FP'
1560: AND tmp.project_element_id = P_TASK_ID
1561: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1562: AND (NVL(tmp.quantity,0) <> 0

Line 1573: pa_periods_all pd

1569: ELSIF P_FP_COLS_REC.x_version_type = 'REVENUE' THEN
1570: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1571: COUNT(DISTINCT pd.period_name) INTO x_txn_amt_rec.no_of_periods
1572: FROM PA_FP_FCST_GEN_TMP1 tmp,
1573: pa_periods_all pd
1574: WHERE tmp.data_type_code = 'TARGET_FP'
1575: AND tmp.project_element_id = P_TASK_ID
1576: AND tmp.res_list_member_id = P_RES_LIST_MEMBER_ID
1577: AND (NVL(tmp.quantity,0) <> 0

Line 1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1957: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1958: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1959: P_ACTUALS_THRU_DATE IN DATE,
1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

Line 1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1958: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,
1959: P_ACTUALS_THRU_DATE IN DATE,
1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1966: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1959: P_ACTUALS_THRU_DATE IN DATE,
1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1966: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1967: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

1960: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1966: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1967: X_MSG_COUNT OUT NOCOPY NUMBER,
1968: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

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

1967: X_MSG_COUNT OUT NOCOPY NUMBER,
1968: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1969:
1970: --Cursor used to select the start_date for PA periods
1971: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1972: SELECT start_date
1973: FROM pa_periods_all
1974: WHERE period_name = c_period
1975: AND org_id = p_fp_cols_rec.x_org_id;

Line 1973: FROM pa_periods_all

1969:
1970: --Cursor used to select the start_date for PA periods
1971: CURSOR pa_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1972: SELECT start_date
1973: FROM pa_periods_all
1974: WHERE period_name = c_period
1975: AND org_id = p_fp_cols_rec.x_org_id;
1976:
1977: --Cursor used to select the start_date for GL periods

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

1974: WHERE period_name = c_period
1975: AND org_id = p_fp_cols_rec.x_org_id;
1976:
1977: --Cursor used to select the start_date for GL periods
1978: CURSOR gl_start_date_csr(c_period PA_PERIODS_ALL.PERIOD_NAME%TYPE) IS
1979: SELECT start_date
1980: FROM gl_period_statuses
1981: WHERE period_name = c_period
1982: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id

Line 1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1999: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2000:

Line 1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1999: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2000:
2001: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

Line 1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;

1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1999: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2000:
2001: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
2002: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 1999: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;

1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1999: l_etc_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2000:
2001: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
2002: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
2003: l_txn_revenue_sum PA_BUDGET_LINES.TXN_REVENUE%TYPE;

Line 2164: FROM pa_periods_all

2160: IF p_fp_cols_rec.x_time_phased_code ='P' THEN
2161: SELECT period_name, start_date, end_date
2162: BULK COLLECT
2163: INTO l_period_name_tab, l_start_date_tab, l_end_date_tab
2164: FROM pa_periods_all
2165: WHERE org_id = p_fp_cols_rec.x_org_id
2166: AND start_date >= l_etc_from_date
2167: AND start_date <= least(p_planning_end_date,l_etc_to_date);
2168: ELSIF p_fp_cols_rec.x_time_phased_code ='G' THEN