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_BUDGET_LINES

Line 308: EXISTS (SELECT 1 from pa_budget_lines bl WHERE

304: ra.task_id
305: FROM pa_resource_assignments ra
306: WHERE ra.budget_version_id = l_source_bv_id
307: AND NVL(ra.task_id,0) = p_task_id AND
308: EXISTS (SELECT 1 from pa_budget_lines bl WHERE
309: ra.resource_assignment_id =
310: bl.resource_assignment_id AND
311: rownum < 2));
312: /* hr_utility.trace('no fo recs inserted in tmp1:'||sql%rowcount);

Line 353: FROM pa_budget_lines bl,

349: sum(bl.raw_cost),
350: sum(bl.burdened_cost),
351: sum(bl.revenue),
352: l_txn_src_code
353: FROM pa_budget_lines bl,
354: pa_resource_assignments ra
355: WHERE ra.resource_assignment_id = bl.resource_assignment_id
356: and ra.budget_version_id = l_source_bv_id
357: and NVL(ra.task_id,0) = p_task_id

Line 509: FROM pa_budget_lines bl,

505: sum(bl.raw_cost),
506: sum(bl.burdened_cost),
507: sum(bl.revenue),
508: l_txn_src_code
509: FROM pa_budget_lines bl,
510: pa_resource_assignments ra
511: WHERE ra.budget_version_id = l_source_bv_id
512: AND ra.resource_assignment_id = bl.resource_assignment_id
513: AND bl.COST_REJECTION_CODE IS NULL

Line 668: FROM pa_budget_lines bl,

664: sum(bl.raw_cost),
665: sum(bl.burdened_cost),
666: sum(bl.revenue),
667: l_txn_src_code
668: FROM pa_budget_lines bl,
669: pa_resource_assignments ra,
670: pa_map_wp_to_fin_tasks_tmp v -- changed pa_map_wp_to_fin_tasks_v for bug#10406949 ->FP Bug#12800007
671: WHERE ra.resource_assignment_id = bl.resource_assignment_id
672: and ra.budget_version_id = l_source_bv_id

Line 1299: UPDATE pa_budget_lines

1295: pa_debug.set_curr_function( p_function => 'UPDATE_TOTAL_PLAN_AMTS'
1296: ,p_debug_mode => p_pa_debug_mode);
1297: END IF;
1298:
1299: UPDATE pa_budget_lines
1300: SET raw_cost = nvl(raw_cost,0) + nvl(init_raw_cost,0),
1301: burdened_cost = nvl(burdened_cost,0) + nvl(init_burdened_cost,0),
1302: revenue = nvl(revenue,0) + nvl(init_revenue,0),
1303: project_raw_cost = nvl(project_raw_cost,0) + nvl(project_init_raw_cost,0),

Line 1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
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,

Line 1432: FROM pa_budget_lines

1428: x_txn_amt_rec.quantity_sum,
1429: x_txn_amt_rec.txn_raw_cost_sum,
1430: x_txn_amt_rec.txn_burdened_cost_sum,
1431: x_txn_amt_rec.txn_revenue_sum
1432: FROM pa_budget_lines
1433: WHERE resource_assignment_id = P_RES_ASG_ID
1434: AND start_date >= p_actual_from_date
1435: AND start_date <= p_actual_to_date;
1436:

Line 1439: FROM pa_budget_lines

1435: AND start_date <= p_actual_to_date;
1436:
1437: IF l_currency_flag = 'PC' THEN
1438: SELECT COUNT(DISTINCT period_name) INTO x_txn_amt_rec.no_of_periods
1439: FROM pa_budget_lines
1440: WHERE resource_assignment_id = P_RES_ASG_ID
1441: AND start_date >= p_actual_from_date
1442: AND start_date <= p_actual_to_date;
1443: END IF;

Line 1834: FROM pa_budget_lines

1830: x_txn_amt_rec.quantity_sum,
1831: x_txn_amt_rec.txn_raw_cost_sum,
1832: x_txn_amt_rec.txn_burdened_cost_sum,
1833: x_txn_amt_rec.txn_revenue_sum
1834: FROM pa_budget_lines
1835: WHERE resource_assignment_id = P_RES_ASG_ID;
1836: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1837: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1838: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/

Line 1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1982: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1983: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 1988: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,

1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 1989: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,

1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 2032: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%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;
2035: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2036:

Line 2033: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%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;
2035: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2036:
2037: l_count NUMBER;

Line 2034: l_txn_revenue_sum PA_BUDGET_LINES.TXN_REVENUE%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;
2035: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2036:
2037: l_count NUMBER;
2038: l_msg_count NUMBER;

Line 2035: l_quantity_sum PA_BUDGET_LINES.QUANTITY%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;
2035: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2036:
2037: l_count NUMBER;
2038: l_msg_count NUMBER;
2039: l_data VARCHAR2(2000);

Line 2465: from pa_budget_lines pbl

2461: AND ( ra.transaction_source_code is not null
2462: OR
2463: (ra.transaction_source_code is null and NOT exists
2464: (select 1
2465: from pa_budget_lines pbl
2466: where pbl.resource_assignment_id = ra.resource_assignment_id
2467: and pbl.start_date >= l_etc_start_date
2468: )
2469: )

Line 2487: from pa_budget_lines pbl

2483: AND ( ra.transaction_source_code is not null
2484: OR
2485: (ra.transaction_source_code is null and NOT exists
2486: (select 1
2487: from pa_budget_lines pbl
2488: where pbl.resource_assignment_id = ra.resource_assignment_id
2489: and NVL(pbl.quantity,0) <> NVL(pbl.init_quantity,0)
2490: )
2491: )

Line 2528: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp

2524: l_init_raw_cost_tab,
2525: l_raw_cost_tab,
2526: l_init_rev_tab,
2527: l_rev_tab
2528: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp
2529: WHERE bl.budget_version_id = l_bv_id AND
2530: tmp.txn_resource_assignment_id = bl.resource_assignment_id;
2531:
2532: IF l_budget_line_id_tab.count = 0 THEN

Line 2541: UPDATE pa_budget_lines

2537: END IF;
2538:
2539: IF P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' THEN
2540: FORALL i IN 1..l_budget_line_id_tab.count
2541: UPDATE pa_budget_lines
2542: SET init_quantity = l_init_rev_tab(i),
2543: quantity = l_rev_tab(i)
2544: WHERE budget_line_id = l_budget_line_id_tab(i);
2545: ELSE

Line 2547: UPDATE pa_budget_lines

2543: quantity = l_rev_tab(i)
2544: WHERE budget_line_id = l_budget_line_id_tab(i);
2545: ELSE
2546: FORALL i IN 1..l_budget_line_id_tab.count
2547: UPDATE pa_budget_lines
2548: SET init_quantity = l_init_raw_cost_tab(i),
2549: quantity = l_raw_cost_tab(i)
2550: WHERE budget_line_id = l_budget_line_id_tab(i);
2551: END IF;