APPS.PA_FP_CALC_UTILS dependencies on PA_RESOURCE_ASGN_CURR

Line 1393: FROM pa_resource_asgn_curr rtx

1389: ,rtx.total_txn_revenue bl_zero_null_revenue
1390: ,rtx.TXN_RAW_COST_RATE_OVERRIDE
1391: ,rtx.TXN_BURDEN_COST_RATE_OVERRIDE
1392: ,rtx.TXN_BILL_RATE_OVERRIDE
1393: FROM pa_resource_asgn_curr rtx
1394: WHERE rtx.resource_assignment_id = l_res_Asgn_Id_Tab(i)
1395: AND rtx.txn_currency_code = l_txn_cur_code_Tab(i)
1396: )
1397: WHERE tmp.resource_assignment_id = l_res_Asgn_Id_Tab(i)

Line 1770: in pa_resource_asgn_curr and pa_budget_lines quantity will be populated

1766: /*
1767: Bug 6429285
1768: Below if condition will handle a corner case
1769: If a rate based resource is added as non rate based resource assignment
1770: in pa_resource_asgn_curr and pa_budget_lines quantity will be populated
1771: as raw_cost and display_quantity will be null.Now if we want to enter
1772: the quantity same as raw cost (i.e existing quantity) the above if condition will fail because
1773: the user entered quantity is same as what is alreay existing*/
1774:

Line 2276: UPDATE pa_resource_asgn_curr rtx

2272: End If;
2273:
2274: If l_resource_assignment_tab.COUNT > 0 Then
2275: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
2276: UPDATE pa_resource_asgn_curr rtx
2277: SET rtx.txn_raw_cost_rate_override = l_cost_rate_override_tab(i)
2278: ,rtx.txn_burden_cost_rate_override = l_burden_rate_override_tab(i)
2279: ,rtx.txn_bill_rate_override = l_bill_rate_override_tab(i)
2280: WHERE rtx.resource_assignment_id = l_resource_assignment_tab(i)

Line 2461: UPDATE pa_resource_asgn_curr rtx

2457: IF P_PA_DEBUG_MODE = 'Y' Then
2458: print_msg('1.3: Upd Resource asgn cur with rate overrides ');
2459: End If;
2460: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
2461: UPDATE pa_resource_asgn_curr rtx
2462: SET (rtx.txn_raw_cost_rate_override
2463: ,rtx.txn_burden_cost_rate_override
2464: ,rtx.txn_bill_rate_override) =
2465: (select decode(sum(nvl(bl.txn_raw_cost,0) - nvl(bl.txn_init_raw_cost,0)),0,rtx.txn_raw_cost_rate_override,1)

Line 2541: UPDATE pa_resource_asgn_curr rtx

2537:
2538: If p_source_context <> 'BUDGET_LINE' Then
2539: --print_msg('1.1.2: update resource asgn cur to set rate overrides');
2540: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
2541: UPDATE pa_resource_asgn_curr rtx
2542: SET (rtx.txn_bill_rate_override
2543: ,rtx.txn_burden_cost_rate_override ) =
2544: (select decode(rtx.txn_bill_rate_override,NULL
2545: ,nvl(l_bill_rate_override_tab(i),rtx.txn_bill_rate_override)

Line 3369: UPDATE PA_RESOURCE_ASGN_CURR rtx

3365: IF P_PA_DEBUG_MODE = 'Y' Then
3366: print_msg('reset the override rates in new entity');
3367: End If;
3368: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3369: UPDATE PA_RESOURCE_ASGN_CURR rtx
3370: SET rtx.txn_raw_cost_rate_override = decode(l_rwRtSetFlag_Tab(i),'Y',NULL,rtx.txn_raw_cost_rate_override)
3371: ,rtx.txn_bill_rate_override = decode(l_bilRtSetFlag_Tab(i),'Y',NULL,rtx.txn_bill_rate_override)
3372: ,rtx.txn_burden_cost_rate_override = decode(l_bdRtSetFlag_Tab(i),'Y',NULL,rtx.txn_burden_cost_rate_override)
3373: WHERE rtx.resource_assignment_id = l_resource_assignment_tab(i)

Line 4118: UPDATE pa_resource_asgn_curr rtx

4114:
4115: /* bug fix:5088944: When rate base resource changed to Non-rate base then clear out any override rates present */
4116: --print_msg('Updating Resource asgn curr table clear out rate overrides');
4117: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
4118: UPDATE pa_resource_asgn_curr rtx
4119: SET rtx.txn_raw_cost_rate_override = NULL
4120: ,rtx.txn_burden_cost_rate_override = NULL
4121: ,rtx.txn_bill_rate_override = NULL
4122: WHERE rtx.resource_assignment_id = l_resource_assignment_tab(i)