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 1216: ,pa_fp_spread_calc_tmp2 tmp2

1212: ,tmp.start_date
1213: ,tmp.end_date
1214: ,NVL(tmp.delete_bl_flag,'N') delete_bl_flag
1215: FROM pa_fp_spread_calc_tmp tmp
1216: ,pa_fp_spread_calc_tmp2 tmp2
1217: ,pa_resource_assignments ra
1218: ,pa_resource_list_members rlm
1219: WHERE tmp.budget_version_id = p_budget_version_id
1220: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 1298: DELETE FROM pa_fp_spread_calc_tmp2

1294: x_msg_data := NULL;
1295: IF P_PA_DEBUG_MODE = 'Y' Then
1296: print_msg('Entered Compare_bdgtLine_Values API');
1297: End If;
1298: DELETE FROM pa_fp_spread_calc_tmp2
1299: WHERE budget_version_id = p_budget_version_id;
1300: l_res_Asgn_Id_Tab.delete;
1301: l_txn_cur_code_Tab.delete;
1302: l_start_date_tab.delete;

Line 1329: INSERT INTO pa_fp_spread_calc_tmp2

1325: IF P_PA_DEBUG_MODE = 'Y' Then
1326: print_msg('NumOf Lines inserted['||l_res_Asgn_Id_Tab.count||']');
1327: End If;
1328: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1329: INSERT INTO pa_fp_spread_calc_tmp2
1330: (BUDGET_VERSION_ID
1331: ,BUDGET_VERSION_TYPE
1332: ,RESOURCE_ASSIGNMENT_ID
1333: ,TXN_CURRENCY_CODE

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

1345: IF P_PA_DEBUG_MODE = 'Y' Then
1346: print_msg('Inserting records into sprdcalctmp2 for resource assignment context');
1347: End If;
1348: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1349: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1350: SET ( tmp.quantity
1351: ,tmp.txn_raw_cost
1352: ,tmp.txn_burdened_cost
1353: ,tmp.txn_revenue

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

1397: WHERE tmp.resource_assignment_id = l_res_Asgn_Id_Tab(i)
1398: AND tmp.txn_currency_code = l_txn_cur_code_Tab(i);
1399:
1400: /* update table with txn markup percentage */
1401: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1402: SET tmp.bill_markup_percentage = (select AVG(bl.txn_markup_percent)
1403: from pa_budget_lines bl
1404: where bl.resource_assignment_id = tmp.resource_assignment_id
1405: and bl.txn_currency_code = tmp.txn_currency_code

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

1415: IF P_PA_DEBUG_MODE = 'Y' Then
1416: print_msg('Updating calcTmp2 with budgetLine values');
1417: End If;
1418: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1419: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1420: SET (tmp.avg_cost_rate_override
1421: ,tmp.avg_burden_rate_override
1422: ,tmp.avg_bill_rate_override
1423: /* Bug fix:4693839 */

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

1454: OR tmp.start_date is NULL
1455: );
1456:
1457: FORALL i IN l_res_Asgn_Id_Tab.FIRST .. l_res_Asgn_Id_Tab.LAST
1458: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP2_N1) */ pa_fp_spread_calc_tmp2 tmp
1459: SET (tmp.quantity
1460: ,tmp.txn_raw_cost
1461: ,tmp.txn_burdened_cost
1462: ,tmp.txn_revenue

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

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

Line 3245: DELETE FROM pa_fp_spread_calc_tmp2;

3241:
3242: /* before resetting the rate base flag check whenter budget lines exists for this planning
3243: * resource with other currency. if so abort the process
3244: */
3245: DELETE FROM pa_fp_spread_calc_tmp2;
3246: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3247: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3248: (budget_version_id
3249: ,resource_assignment_id

Line 3247: INSERT INTO pa_fp_spread_calc_tmp2 tmp2

3243: * resource with other currency. if so abort the process
3244: */
3245: DELETE FROM pa_fp_spread_calc_tmp2;
3246: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3247: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3248: (budget_version_id
3249: ,resource_assignment_id
3250: ,txn_currency_code
3251: ,task_id

Line 3276: DELETE FROM pa_fp_spread_calc_tmp2;

3272: );
3273:
3274: ELSE -- source context = BUDGET LINE then
3275:
3276: DELETE FROM pa_fp_spread_calc_tmp2;
3277: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3278: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3279: (budget_version_id
3280: ,resource_assignment_id

Line 3278: INSERT INTO pa_fp_spread_calc_tmp2 tmp2

3274: ELSE -- source context = BUDGET LINE then
3275:
3276: DELETE FROM pa_fp_spread_calc_tmp2;
3277: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3278: INSERT INTO pa_fp_spread_calc_tmp2 tmp2
3279: (budget_version_id
3280: ,resource_assignment_id
3281: ,txn_currency_code
3282: ,task_id

Line 3318: FROM pa_fp_spread_calc_tmp2 tmp2

3314: ,tmp2.txn_currency_code
3315: ,tmp2.task_id
3316: ,tmp2.resource_name
3317: ,tmp2.start_date
3318: FROM pa_fp_spread_calc_tmp2 tmp2
3319: WHERE tmp2.budget_version_id = p_budget_version_id ) LOOP --{
3320:
3321: g_stage := 'PA_FP_RATE_BASE_QTY_REQD:RaId['||i.resource_assignment_id||']';
3322: g_stage := 'Currency['||i.txn_currency_code||']SDate['||i.start_date||']';

Line 8400: ,pa_fp_spread_calc_tmp2 tmp2

8396: ,bl.txn_currency_code
8397: ,bl.project_currency_code
8398: ,bl.projfunc_currency_code
8399: FROM pa_budget_lines bl
8400: ,pa_fp_spread_calc_tmp2 tmp2
8401: WHERE bl.budget_version_id = p_budget_version_id
8402: AND tmp2.budget_version_id = bl.budget_version_id
8403: AND tmp2.resource_assignment_id = bl.resource_assignment_id
8404: AND tmp2.txn_currency_code = bl.txn_currency_code

Line 8476: FROM pa_fp_spread_calc_tmp2 tmp2

8472: ,tmp2.bill_rate existing_bill_rate
8473: ,tmp2.bill_rate_override existing_bill_rate_ovride
8474: ,tmp2.bill_markup_percentage existing_markup_percentage
8475: ,tmp2.system_reference_num1 existing_compile_set_id
8476: FROM pa_fp_spread_calc_tmp2 tmp2
8477: WHERE tmp2.budget_version_id = p_budget_version_id
8478: AND tmp2.budget_line_id = p_budget_line_id;
8479: ExBlRec cur_Tmp2ExblAmts%ROWTYPE;
8480:

Line 8752: FROM pa_fp_spread_calc_tmp2 tmp2

8748: ,l_tmp2_cost_rate_ovr_tab
8749: ,l_tmp2_burden_rate_ovr_tab
8750: ,l_tmp2_compile_set_id_tab
8751: ,l_tmp2_rate_based_flag_tab /* bug fix: 4900436 */
8752: FROM pa_fp_spread_calc_tmp2 tmp2
8753: ,pa_resource_assignments ra
8754: WHERE tmp2.budget_version_id = p_budget_version_id
8755: AND ra.resource_assignment_id = tmp2.resource_assignment_id;
8756: END Populate_tmp2Plsql_tab;

Line 8858: DELETE FROM PA_FP_SPREAD_CALC_TMP2;

8854: ) IS
8855: BEGIN
8856: x_return_status := 'S';
8857: print_msg('Entered Populate_ExistingBlRecs API');
8858: DELETE FROM PA_FP_SPREAD_CALC_TMP2;
8859: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp
8860: (tmp.budget_line_id
8861: ,tmp.budget_version_id
8862: ,tmp.resource_assignment_id

Line 8859: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp

8855: BEGIN
8856: x_return_status := 'S';
8857: print_msg('Entered Populate_ExistingBlRecs API');
8858: DELETE FROM PA_FP_SPREAD_CALC_TMP2;
8859: INSERT INTO PA_FP_SPREAD_CALC_TMP2 tmp
8860: (tmp.budget_line_id
8861: ,tmp.budget_version_id
8862: ,tmp.resource_assignment_id
8863: ,tmp.txn_currency_code

Line 8918: from pa_fp_spread_calc_tmp2 tmp2

8914: /* Now store the existing budget line id on tmp1 table to read the values
8915: * from both tables */
8916: UPDATE pa_fp_spread_calc_tmp1 tmp1
8917: SET tmp1.system_reference_num1 = (select tmp2.budget_line_id
8918: from pa_fp_spread_calc_tmp2 tmp2
8919: where tmp2.budget_version_id = p_budget_version_id
8920: and tmp2.resource_assignment_id = tmp1.resource_assignment_id
8921: and tmp2.txn_currency_code = tmp1.txn_currency_code
8922: and tmp2.start_date = tmp1.start_date

Line 9566: UPDATE pa_fp_spread_calc_tmp2 tmp2

9562: l_bl_upd_markup_percentage := newRec.bill_markup_percentage;
9563: End If;
9564:
9565:
9566: UPDATE pa_fp_spread_calc_tmp2 tmp2
9567: SET tmp2.txn_currency_code = newRec.txn_currency_code
9568: ,tmp2.quantity = nvl(tmp2.quantity,0) + newRec.quantity
9569: ,tmp2.system_reference_var1 = newRec.cost_rejection_code
9570: ,tmp2.system_reference_var2 = newRec.revenue_rejection_code