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_CALC_UTILS dependencies on PA_FP_SPREAD_CALC_TMP2

Line 1223: ,pa_fp_spread_calc_tmp2 tmp2

1219: ,tmp.start_date
1220: ,tmp.end_date
1221: ,NVL(tmp.delete_bl_flag,'N') delete_bl_flag
1222: FROM pa_fp_spread_calc_tmp tmp
1223: ,pa_fp_spread_calc_tmp2 tmp2
1224: ,pa_resource_assignments ra
1225: ,pa_resource_list_members rlm
1226: WHERE tmp.budget_version_id = p_budget_version_id
1227: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 1305: DELETE FROM pa_fp_spread_calc_tmp2

1301: x_msg_data := NULL;
1302: IF P_PA_DEBUG_MODE = 'Y' Then
1303: print_msg('Entered Compare_bdgtLine_Values API');
1304: End If;
1305: DELETE FROM pa_fp_spread_calc_tmp2
1306: WHERE budget_version_id = p_budget_version_id;
1307: l_res_Asgn_Id_Tab.delete;
1308: l_txn_cur_code_Tab.delete;
1309: l_start_date_tab.delete;

Line 1336: INSERT INTO pa_fp_spread_calc_tmp2

1332: IF P_PA_DEBUG_MODE = 'Y' Then
1333: print_msg('NumOf Lines inserted['||l_res_Asgn_Id_Tab.count||']');
1334: End If;
1335: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1336: INSERT INTO pa_fp_spread_calc_tmp2
1337: (BUDGET_VERSION_ID
1338: ,BUDGET_VERSION_TYPE
1339: ,RESOURCE_ASSIGNMENT_ID
1340: ,TXN_CURRENCY_CODE

Line 1356: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) / pa_fp_spread_calc_tmp2 tmp

1352: IF P_PA_DEBUG_MODE = 'Y' Then
1353: print_msg('Inserting records into sprdcalctmp2 for resource assignment context');
1354: End If;
1355: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1356: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1357: SET ( tmp.quantity
1358: ,tmp.txn_raw_cost
1359: ,tmp.txn_burdened_cost
1360: ,tmp.txn_revenue

Line 1408: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) / pa_fp_spread_calc_tmp2 tmp

1404: WHERE tmp.resource_assignment_id = l_res_Asgn_Id_Tab(i)
1405: AND tmp.txn_currency_code = l_txn_cur_code_Tab(i);
1406:
1407: /* update table with txn markup percentage */
1408: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1409: SET tmp.bill_markup_percentage = (select AVG(bl.txn_markup_percent)
1410: from pa_budget_lines bl
1411: where bl.resource_assignment_id = tmp.resource_assignment_id
1412: and bl.txn_currency_code = tmp.txn_currency_code

Line 1426: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) / pa_fp_spread_calc_tmp2 tmp

1422: IF P_PA_DEBUG_MODE = 'Y' Then
1423: print_msg('Updating calcTmp2 with budgetLine values');
1424: End If;
1425: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1426: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1427: SET (tmp.avg_cost_rate_override
1428: ,tmp.avg_burden_rate_override
1429: ,tmp.avg_bill_rate_override
1430: /* Bug fix:4693839 */

Line 1465: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) / pa_fp_spread_calc_tmp2 tmp

1461: OR tmp.start_date is NULL
1462: );
1463:
1464: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1465: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1466: SET (tmp.quantity
1467: ,tmp.txn_raw_cost
1468: ,tmp.txn_burdened_cost
1469: ,tmp.txn_revenue

Line 1603: FOR tmp in (select * from pa_fp_spread_calc_tmp2 where budget_version_id = p_budget_version_id) LOOP

1599: );
1600: --print_msg('Number of budgtLines got updated['||l_res_Asgn_Id_Tab.count||']');
1601: END IF; --}
1602: /** added this for debug testing
1603: FOR tmp in (select * from pa_fp_spread_calc_tmp2 where budget_version_id = p_budget_version_id) LOOP
1604: print_msg('Res['||tmp.resource_assignment_id||']blTxncur['||tmp.txn_currency_code||'blQty['||tmp.quantity||']');
1605: print_msg('RawCst['||tmp.txn_raw_cost||']BdCst['||tmp.txn_burdened_cost||']Rev['||tmp.txn_revenue||']');
1606: print_msg('cstRt['||tmp.cost_rate||']cstRtOvr['||tmp.cost_rate_override||']BdRt['||tmp.burden_cost_rate||']');
1607: print_msg('BdRtOv['||tmp.burden_cost_rate_override||']BilRt['||tmp.bill_rate||']BilRtOvr['||tmp.bill_rate_override||']');

Line 3261: DELETE FROM pa_fp_spread_calc_tmp2;

3257:
3258: /* before resetting the rate base flag check whenter budget lines exists for this planning
3259: * resource with other currency. if so abort the process
3260: */
3261: DELETE FROM pa_fp_spread_calc_tmp2;
3262: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3263: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3264: (budget_version_id
3265: ,resource_assignment_id

Line 3263: INSERT INTO pa_fp_spread_calc_tmp2 tmp2

3259: * resource with other currency. if so abort the process
3260: */
3261: DELETE FROM pa_fp_spread_calc_tmp2;
3262: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3263: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3264: (budget_version_id
3265: ,resource_assignment_id
3266: ,txn_currency_code
3267: ,task_id

Line 3292: DELETE FROM pa_fp_spread_calc_tmp2;

3288: );
3289:
3290: ELSE -- source context = BUDGET LINE then
3291:
3292: DELETE FROM pa_fp_spread_calc_tmp2;
3293: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3294: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3295: (budget_version_id
3296: ,resource_assignment_id

Line 3294: INSERT INTO pa_fp_spread_calc_tmp2 tmp2

3290: ELSE -- source context = BUDGET LINE then
3291:
3292: DELETE FROM pa_fp_spread_calc_tmp2;
3293: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3294: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3295: (budget_version_id
3296: ,resource_assignment_id
3297: ,txn_currency_code
3298: ,task_id

Line 3334: FROM pa_fp_spread_calc_tmp2 tmp2

3330: ,tmp2.txn_currency_code
3331: ,tmp2.task_id
3332: ,tmp2.resource_name
3333: ,tmp2.start_date
3334: FROM pa_fp_spread_calc_tmp2 tmp2
3335: WHERE tmp2.budget_version_id = p_budget_version_id ) LOOP --{
3336:
3337: g_stage := 'PA_FP_RATE_BASE_QTY_REQD:RaId['||i.resource_assignment_id||']';
3338: g_stage := 'Currency['||i.txn_currency_code||']SDate['||i.start_date||']';

Line 8431: ,pa_fp_spread_calc_tmp2 tmp2

8427: ,bl.txn_currency_code
8428: ,bl.project_currency_code
8429: ,bl.projfunc_currency_code
8430: FROM pa_budget_lines bl
8431: ,pa_fp_spread_calc_tmp2 tmp2
8432: WHERE bl.budget_version_id = p_budget_version_id
8433: AND tmp2.budget_version_id = bl.budget_version_id
8434: AND tmp2.resource_assignment_id = bl.resource_assignment_id
8435: AND tmp2.txn_currency_code = bl.txn_currency_code

Line 8507: FROM pa_fp_spread_calc_tmp2 tmp2

8503: ,tmp2.bill_rate existing_bill_rate
8504: ,tmp2.bill_rate_override existing_bill_rate_ovride
8505: ,tmp2.bill_markup_percentage existing_markup_percentage
8506: ,tmp2.system_reference_num1 existing_compile_set_id
8507: FROM pa_fp_spread_calc_tmp2 tmp2
8508: WHERE tmp2.budget_version_id = p_budget_version_id
8509: AND tmp2.budget_line_id = p_budget_line_id;
8510: ExBlRec cur_Tmp2ExblAmts%ROWTYPE;
8511:

Line 8783: FROM pa_fp_spread_calc_tmp2 tmp2

8779: ,l_tmp2_cost_rate_ovr_tab
8780: ,l_tmp2_burden_rate_ovr_tab
8781: ,l_tmp2_compile_set_id_tab
8782: ,l_tmp2_rate_based_flag_tab /* bug fix: 4900436 */
8783: FROM pa_fp_spread_calc_tmp2 tmp2
8784: ,pa_resource_assignments ra
8785: WHERE tmp2.budget_version_id = p_budget_version_id
8786: AND ra.resource_assignment_id = tmp2.resource_assignment_id;
8787: END Populate_tmp2Plsql_tab;

Line 9090: DELETE FROM PA_FP_SPREAD_CALC_TMP2;

9086: ) IS
9087: BEGIN
9088: x_return_status := 'S';
9089: print_msg('Entered Populate_ExistingBlRecs API');
9090: DELETE FROM PA_FP_SPREAD_CALC_TMP2;
9091: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp
9092: (tmp.budget_line_id
9093: ,tmp.budget_version_id
9094: ,tmp.resource_assignment_id

Line 9091: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp

9087: BEGIN
9088: x_return_status := 'S';
9089: print_msg('Entered Populate_ExistingBlRecs API');
9090: DELETE FROM PA_FP_SPREAD_CALC_TMP2;
9091: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp
9092: (tmp.budget_line_id
9093: ,tmp.budget_version_id
9094: ,tmp.resource_assignment_id
9095: ,tmp.txn_currency_code

Line 9150: from pa_fp_spread_calc_tmp2 tmp2

9146: /* Now store the existing budget line id on tmp1 table to read the values
9147: * from both tables */
9148: UPDATE pa_fp_spread_calc_tmp1 tmp1
9149: SET tmp1.system_reference_num1 = (select tmp2.budget_line_id
9150: from pa_fp_spread_calc_tmp2 tmp2
9151: where tmp2.budget_version_id = p_budget_version_id
9152: and tmp2.resource_assignment_id = tmp1.resource_assignment_id
9153: and tmp2.txn_currency_code = tmp1.txn_currency_code
9154: and tmp2.start_date = tmp1.start_date

Line 9800: UPDATE pa_fp_spread_calc_tmp2 tmp2

9796: l_bl_upd_markup_percentage := newRec.bill_markup_percentage;
9797: End If;
9798:
9799:
9800: UPDATE pa_fp_spread_calc_tmp2 tmp2
9801: SET tmp2.txn_currency_code = newRec.txn_currency_code
9802: ,tmp2.quantity = nvl(tmp2.quantity,0) + newRec.quantity
9803: ,tmp2.system_reference_var1 = newRec.cost_rejection_code
9804: ,tmp2.system_reference_var2 = newRec.revenue_rejection_code