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 303: EXISTS (SELECT 1 from pa_budget_lines bl WHERE

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

Line 348: FROM pa_budget_lines bl,

344: sum(bl.raw_cost),
345: sum(bl.burdened_cost),
346: sum(bl.revenue),
347: l_txn_src_code
348: FROM pa_budget_lines bl,
349: pa_resource_assignments ra
350: WHERE ra.resource_assignment_id = bl.resource_assignment_id
351: and ra.budget_version_id = l_source_bv_id
352: and NVL(ra.task_id,0) = p_task_id

Line 502: FROM pa_budget_lines bl,

498: sum(bl.raw_cost),
499: sum(bl.burdened_cost),
500: sum(bl.revenue),
501: l_txn_src_code
502: FROM pa_budget_lines bl,
503: pa_resource_assignments ra
504: WHERE ra.budget_version_id = l_source_bv_id
505: AND ra.resource_assignment_id = bl.resource_assignment_id
506: AND bl.COST_REJECTION_CODE IS NULL

Line 659: FROM pa_budget_lines bl,

655: sum(bl.raw_cost),
656: sum(bl.burdened_cost),
657: sum(bl.revenue),
658: l_txn_src_code
659: FROM pa_budget_lines bl,
660: pa_resource_assignments ra,
661: pa_map_wp_to_fin_tasks_v v
662: WHERE ra.resource_assignment_id = bl.resource_assignment_id
663: and ra.budget_version_id = l_source_bv_id

Line 1286: UPDATE pa_budget_lines

1282: pa_debug.set_curr_function( p_function => 'UPDATE_TOTAL_PLAN_AMTS'
1283: ,p_debug_mode => p_pa_debug_mode);
1284: END IF;
1285:
1286: UPDATE pa_budget_lines
1287: SET raw_cost = nvl(raw_cost,0) + nvl(init_raw_cost,0),
1288: burdened_cost = nvl(burdened_cost,0) + nvl(init_burdened_cost,0),
1289: revenue = nvl(revenue,0) + nvl(init_revenue,0),
1290: project_raw_cost = nvl(project_raw_cost,0) + nvl(project_init_raw_cost,0),

Line 1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1331: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1332: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%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,

Line 1417: FROM pa_budget_lines

1413: x_txn_amt_rec.quantity_sum,
1414: x_txn_amt_rec.txn_raw_cost_sum,
1415: x_txn_amt_rec.txn_burdened_cost_sum,
1416: x_txn_amt_rec.txn_revenue_sum
1417: FROM pa_budget_lines
1418: WHERE resource_assignment_id = P_RES_ASG_ID
1419: AND start_date >= p_actual_from_date
1420: AND start_date <= p_actual_to_date;
1421:

Line 1424: FROM pa_budget_lines

1420: AND start_date <= p_actual_to_date;
1421:
1422: IF l_currency_flag = 'PC' THEN
1423: SELECT COUNT(DISTINCT period_name) INTO x_txn_amt_rec.no_of_periods
1424: FROM pa_budget_lines
1425: WHERE resource_assignment_id = P_RES_ASG_ID
1426: AND start_date >= p_actual_from_date
1427: AND start_date <= p_actual_to_date;
1428: END IF;

Line 1807: FROM pa_budget_lines

1803: x_txn_amt_rec.quantity_sum,
1804: x_txn_amt_rec.txn_raw_cost_sum,
1805: x_txn_amt_rec.txn_burdened_cost_sum,
1806: x_txn_amt_rec.txn_revenue_sum
1807: FROM pa_budget_lines
1808: WHERE resource_assignment_id = P_RES_ASG_ID;
1809: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1810: IF P_FP_COLS_REC.x_version_type = 'ALL' THEN
1811: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/

Line 1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1951: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1952: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1953: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1956: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 1957: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,

1953: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1956: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 1958: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,

1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1956: P_CURRENCY_FLAG IN VARCHAR2,
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,

Line 2001: l_txn_raw_cost_sum PA_BUDGET_LINES.TXN_RAW_COST%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;
2004: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2005:

Line 2002: l_txn_burdened_cost_sum PA_BUDGET_LINES.TXN_BURDENED_COST%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;
2004: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2005:
2006: l_count NUMBER;

Line 2003: l_txn_revenue_sum PA_BUDGET_LINES.TXN_REVENUE%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;
2004: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2005:
2006: l_count NUMBER;
2007: l_msg_count NUMBER;

Line 2004: l_quantity_sum PA_BUDGET_LINES.QUANTITY%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;
2004: l_quantity_sum PA_BUDGET_LINES.QUANTITY%TYPE;
2005:
2006: l_count NUMBER;
2007: l_msg_count NUMBER;
2008: l_data VARCHAR2(2000);

Line 2432: from pa_budget_lines pbl

2428: AND ( ra.transaction_source_code is not null
2429: OR
2430: (ra.transaction_source_code is null and NOT exists
2431: (select 1
2432: from pa_budget_lines pbl
2433: where pbl.resource_assignment_id = ra.resource_assignment_id
2434: and pbl.start_date >= l_etc_start_date
2435: )
2436: )

Line 2454: from pa_budget_lines pbl

2450: AND ( ra.transaction_source_code is not null
2451: OR
2452: (ra.transaction_source_code is null and NOT exists
2453: (select 1
2454: from pa_budget_lines pbl
2455: where pbl.resource_assignment_id = ra.resource_assignment_id
2456: and NVL(pbl.quantity,0) <> NVL(pbl.init_quantity,0)
2457: )
2458: )

Line 2495: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp

2491: l_init_raw_cost_tab,
2492: l_raw_cost_tab,
2493: l_init_rev_tab,
2494: l_rev_tab
2495: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp
2496: WHERE bl.budget_version_id = l_bv_id AND
2497: tmp.txn_resource_assignment_id = bl.resource_assignment_id;
2498:
2499: IF l_budget_line_id_tab.count = 0 THEN

Line 2508: UPDATE pa_budget_lines

2504: END IF;
2505:
2506: IF P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' THEN
2507: FORALL i IN 1..l_budget_line_id_tab.count
2508: UPDATE pa_budget_lines
2509: SET init_quantity = l_init_rev_tab(i),
2510: quantity = l_rev_tab(i)
2511: WHERE budget_line_id = l_budget_line_id_tab(i);
2512: ELSE

Line 2514: UPDATE pa_budget_lines

2510: quantity = l_rev_tab(i)
2511: WHERE budget_line_id = l_budget_line_id_tab(i);
2512: ELSE
2513: FORALL i IN 1..l_budget_line_id_tab.count
2514: UPDATE pa_budget_lines
2515: SET init_quantity = l_init_raw_cost_tab(i),
2516: quantity = l_raw_cost_tab(i)
2517: WHERE budget_line_id = l_budget_line_id_tab(i);
2518: END IF;