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_RESOURCE_ASSIGNMENTS

Line 261: ,pa_resource_assignments ra

257: SELECT tmp.resource_assignment_id
258: ,rl.alias resource_name
259: ,tmp.txn_currency_code
260: FROM pa_fp_spread_calc_tmp tmp
261: ,pa_resource_assignments ra
262: ,pa_resource_list_members rl
263: WHERE tmp.budget_version_id = p_budget_version_id
264: AND ra.resource_assignment_id = tmp.resource_assignment_id
265: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 298: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)

294: * 5:TABLE ACCESS BY INDEX ROWID PA_FP_SPREAD_CALC_TMP :(cost=6,rows=82)
295: * 6:INDEX RANGE SCAN PA_FP_SPREAD_CALC_TMP_N2 :(cost=2,rows=33)
296: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
297: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
298: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
299: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
300: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
301: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
302: **/

Line 299: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)

295: * 6:INDEX RANGE SCAN PA_FP_SPREAD_CALC_TMP_N2 :(cost=2,rows=33)
296: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
297: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
298: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
299: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
300: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
301: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
302: **/
303: CURSOR cur_blDatesCheck IS

Line 308: ,pa_resource_assignments ra

304: SELECT tmp.resource_assignment_id
305: ,rl.alias resource_name
306: ,tmp.txn_currency_code
307: FROM pa_fp_spread_calc_tmp tmp
308: ,pa_resource_assignments ra
309: ,pa_resource_list_members rl
310: WHERE tmp.budget_version_id = p_budget_version_id
311: AND ra.resource_assignment_id = tmp.resource_assignment_id
312: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 1224: ,pa_resource_assignments ra

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
1228: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 2197: ,pa_resource_assignments ra

2193: ,NVL(tmp.MFC_COST_CHANGE_FLAG,'N') mfc_cost_change_flag
2194: ,NVL(tmp.RLM_ID_CHANGE_FLAG,'N') rlm_id_change_flag
2195: ,NVL(tmp.system_reference_var1 ,'N') ra_in_multi_cur_flag
2196: FROM pa_fp_spread_calc_tmp tmp
2197: ,pa_resource_assignments ra
2198: WHERE tmp.budget_version_id = p_budget_version_id
2199: AND tmp.resource_assignment_id = ra.resource_assignment_id
2200: AND ra.rate_based_flag = 'N'
2201: AND ( (NVL(tmp.bl_txn_raw_cost,0) = nvl(tmp.bl_quantity,0)

Line 2365: ,pa_resource_assignments ra

2361: ,NVL(tmp.RLM_ID_CHANGE_FLAG,'N') rlm_id_change_flag
2362: ,NVL(tmp.system_reference_var1 ,'N') ra_in_multi_cur_flag
2363: ,NVL(tmp.DELETE_BL_FLAG,'N') delete_bl_flag
2364: FROM pa_fp_spread_calc_tmp tmp
2365: ,pa_resource_assignments ra
2366: WHERE tmp.budget_version_id = p_budget_version_id
2367: AND tmp.resource_assignment_id = ra.resource_assignment_id
2368: AND nvl(ra.rate_based_flag,'N') = 'N'
2369: AND NVL(tmp.quantity_changed_flag,'N') = 'N'

Line 2687: ,pa_resource_assignments ra

2683: ,NVL(tmp.raw_cost_changed_flag,'N') raw_cost_changed_flag
2684: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2685: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2686: FROM pa_fp_spread_calc_tmp tmp
2687: ,pa_resource_assignments ra
2688: ,pa_resource_list_members rlm
2689: WHERE ra.budget_version_id = p_budget_version_id
2690: AND ra.resource_assignment_id = tmp.resource_assignment_id
2691: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 2733: ,pa_resource_assignments ra

2729: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2730: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2731: ,tmp.bill_markup_percentage
2732: FROM pa_fp_spread_calc_tmp tmp
2733: ,pa_resource_assignments ra
2734: ,pa_resource_list_members rlm
2735: WHERE ra.budget_version_id = p_budget_version_id
2736: AND ra.resource_assignment_id = tmp.resource_assignment_id
2737: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3383: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3379: print_msg('Not resetting the rate_based_flag and UOM');
3380: END IF;
3381: ELSE
3382: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3383: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3384: SET ra.rate_based_flag = 'Y'
3385: ,ra.unit_of_measure = l_uom_tab(i)
3386: WHERE ra.resource_assignment_id = l_resource_assignment_tab(i)
3387: AND l_reset_rate_based_flag_tab(i) = 'Y';

Line 3455: from pa_resource_assignments ra

3451: ,tmp.resource_UOM) =
3452: (select nvl(ra.rate_based_flag,'N' )
3453: ,nvl(ra.resource_rate_based_flag,'N')
3454: ,l_uom_tab(i)
3455: from pa_resource_assignments ra
3456: where ra.resource_assignment_id = tmp.resource_assignment_id)
3457: /* bug fix:5116157: to store the reset flag so that correct rate base flag and uom can pass to PJI*/
3458: ,tmp.system_reference_var3 = NVL(l_reset_rate_based_flag_tab(i),'N') -- Reset_Rate_Base_Flag
3459: /* bug fix:5726773 */

Line 3570: ,pa_resource_assignments ra

3566: ,NVL(tmp.raw_cost_changed_flag,'N') raw_cost_changed_flag
3567: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
3568: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
3569: FROM pa_fp_spread_calc_tmp tmp
3570: ,pa_resource_assignments ra
3571: ,pa_resource_list_members rlm
3572: WHERE ra.budget_version_id = p_budget_version_id
3573: AND ra.resource_assignment_id = tmp.resource_assignment_id
3574: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3585: ,pa_resource_assignments ra

3581: SELECT 'Y'
3582: FROM dual
3583: WHERE EXISTS (select null
3584: from pa_budget_lines bl
3585: ,pa_resource_assignments ra
3586: where ra.resource_assignment_id = p_ra_id
3587: and bl.resource_assignment_id = ra.resource_assignment_id
3588: and NVL(ra.rate_based_flag,'N') = 'Y'
3589: /* Bug fix:4083873 and bl.txn_currency_code = p_txn_cur_code */

Line 3618: ,pa_resource_assignments ra

3614: ,tmp.end_date
3615: ,tmp.bl_quantity
3616: ,rlm.unit_of_measure uom
3617: FROM pa_fp_spread_calc_tmp tmp
3618: ,pa_resource_assignments ra
3619: ,pa_resource_list_members rlm
3620: WHERE tmp.budget_version_id = p_budget_version_id
3621: AND ra.resource_assignment_id = tmp.resource_assignment_id
3622: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3647: l_webadi_task_id pa_resource_assignments.task_id%TYPE;

3643: l_reset_plsql_tab_flag VARCHAR2(10) := 'N';
3644:
3645: -- bug 4431269: added the followings
3646: -- variables to be used to call process_errors in web adi flow.
3647: l_webadi_task_id pa_resource_assignments.task_id%TYPE;
3648: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
3649: l_webAdi_context VARCHAR2(250) ;
3650:
3651: /* bug fix:5726773 */

Line 3648: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

3644:
3645: -- bug 4431269: added the followings
3646: -- variables to be used to call process_errors in web adi flow.
3647: l_webadi_task_id pa_resource_assignments.task_id%TYPE;
3648: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
3649: l_webAdi_context VARCHAR2(250) ;
3650:
3651: /* bug fix:5726773 */
3652: SKIP_RECORD EXCEPTION;

Line 3898: FROM pa_resource_assignments pra

3894: SELECT pra.task_id,
3895: pra.resource_list_member_id
3896: INTO l_webadi_task_id,
3897: l_webadi_rlm_id
3898: FROM pa_resource_assignments pra
3899: WHERE pra.resource_assignment_id = i.resource_assignment_id
3900: AND pra.budget_version_id = p_budget_version_id;
3901: -- populating the error tables.
3902: --print_msg('1100.1.1.1:Web ADI context populating errors');

Line 3956: FROM pa_resource_assignments pra

3952: SELECT pra.task_id,
3953: pra.resource_list_member_id
3954: INTO l_webadi_task_id,
3955: l_webadi_rlm_id
3956: FROM pa_resource_assignments pra
3957: WHERE pra.resource_assignment_id = i.resource_assignment_id
3958: AND pra.budget_version_id = p_budget_version_id;
3959: -- populating the error tables.
3960: --print_msg('1100.1.1.1:Web ADI context populating errors');

Line 4153: from pa_resource_assignments ra

4149: ,rtx.txn_bill_rate_override = NULL
4150: WHERE rtx.resource_assignment_id = l_resource_assignment_tab(i)
4151: AND rtx.txn_currency_code = l_txn_currency_code_tab(i)
4152: AND EXISTS ( select null
4153: from pa_resource_assignments ra
4154: where ra.rate_based_flag = 'Y'
4155: and ra.resource_assignment_id = rtx.resource_assignment_id
4156: );
4157:

Line 4163: UPDATE PA_RESOURCE_ASSIGNMENTS ra

4159: IF P_PA_DEBUG_MODE = 'Y' Then
4160: print_msg('Updating RA with Non-Rate base flag');
4161: End If;
4162: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
4163: UPDATE PA_RESOURCE_ASSIGNMENTS ra
4164: SET ra.rate_based_flag = 'N'
4165: ,ra.unit_of_measure = 'DOLLARS'
4166: WHERE ra.resource_assignment_id = l_resource_assignment_tab(i);
4167:

Line 4196: from pa_resource_assignments ra

4192: ,tmp.resource_uom) =
4193: (select nvl(ra.rate_based_flag,'N' )
4194: ,nvl(ra.resource_rate_based_flag,'N')
4195: ,l_uom_tab(i)
4196: from pa_resource_assignments ra
4197: where ra.resource_assignment_id = tmp.resource_assignment_id)
4198: WHERE tmp.resource_assignment_id = l_resource_assignment_tab(i)
4199: AND tmp.txn_currency_code = l_txn_currency_code_tab(i)
4200: AND ((p_source_context = 'RESOURCE_ASSIGNMENT')

Line 4264: FROM pa_resource_assignments ra

4260: ,decode(LEAST(NVL(g_etc_start_date,ra.planning_start_date),ra.planning_end_date),ra.planning_end_date,ra.planning_start_date,NVL(g_etc_start_date,ra.planning_start_date))) planning_start_date --Bug#6936782
4261: ,DECODE(ra.spread_curve_id,6,ra.sp_fixed_date,ra.planning_end_date) planning_end_date
4262: ,tmp.task_name
4263: ,tmp.resource_name
4264: FROM pa_resource_assignments ra
4265: ,pa_fp_spread_calc_tmp tmp
4266: WHERE ra.budget_version_id = p_budget_verson_id
4267: AND ra.resource_assignment_id = tmp.resource_assignment_id
4268: AND NOT EXISTS

Line 4359: ,pa_resource_assignments ra

4355: ,ra.planning_start_date
4356: ,ra.planning_end_date
4357: ,rl.alias resource_name
4358: FROM pa_fp_spread_calc_tmp tmp
4359: ,pa_resource_assignments ra
4360: ,pa_resource_list_members rl
4361: WHERE tmp.budget_version_id = p_budget_version_id
4362: AND ra.resource_assignment_id = tmp.resource_assignment_id
4363: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 5349: from pa_resource_assignments ra

5345: ,ra.planning_start_date,tmp.SYSTEM_REFERENCE_DAT1))
5346: ,decode(tmp.SYSTEM_REFERENCE_DAT2,NULL,NULL
5347: ,decode(sign(trunc(tmp.SYSTEM_REFERENCE_DAT2)-trunc(ra.planning_end_date)),1
5348: ,ra.planning_end_date,tmp.SYSTEM_REFERENCE_DAT2))
5349: from pa_resource_assignments ra
5350: where ra.resource_assignment_id = tmp.resource_assignment_id
5351: and ra.budget_version_id = tmp.budget_version_id)
5352: WHERE tmp.resource_assignment_id = p_resource_assignment_id_tab(i)
5353: AND NVL(tmp.system_reference_var1,'N') = 'Y'

Line 5810: from pa_resource_assignments ra

5806: and tmp1.OLD_PLAN_END_DATE is not null
5807: and rownum = 1
5808: ),tmp.OLD_PLAN_END_DATE)
5809: ,tmp.NEW_PLAN_START_DATE = decode(tmp.NEW_PLAN_START_DATE,NULL,(select ra.planning_start_date
5810: from pa_resource_assignments ra
5811: where ra.resource_assignment_id = tmp.resource_assignment_id
5812: ),tmp.NEW_PLAN_START_DATE)
5813: ,tmp.NEW_PLAN_END_DATE = decode(tmp.NEW_PLAN_END_DATE,NULL,(select ra.planning_end_date
5814: from pa_resource_assignments ra

Line 5814: from pa_resource_assignments ra

5810: from pa_resource_assignments ra
5811: where ra.resource_assignment_id = tmp.resource_assignment_id
5812: ),tmp.NEW_PLAN_START_DATE)
5813: ,tmp.NEW_PLAN_END_DATE = decode(tmp.NEW_PLAN_END_DATE,NULL,(select ra.planning_end_date
5814: from pa_resource_assignments ra
5815: where ra.resource_assignment_id = tmp.resource_assignment_id
5816: ),tmp.NEW_PLAN_END_DATE)
5817: WHERE tmp.budget_version_id = p_budget_version_id;
5818: --print_msg('synch_Upd: NumOfRowUpdated['||sql%rowcount||']');

Line 5938: from pa_resource_assignments ra

5934: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5935: and tmp1.rlm_id_change_flag = 'Y'))
5936: ,(tmp.task_id,tmp.resource_name) =
5937: (select ra.task_id,rlm.alias
5938: from pa_resource_assignments ra
5939: ,pa_resource_list_members rlm
5940: where ra.resource_assignment_id = tmp.resource_assignment_id
5941: and rlm.resource_list_member_id = ra.resource_list_member_id
5942: )

Line 5945: from pa_resource_assignments ra

5941: and rlm.resource_list_member_id = ra.resource_list_member_id
5942: )
5943: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5944: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5945: from pa_resource_assignments ra
5946: ,pa_tasks t
5947: where ra.resource_assignment_id = tmp.resource_assignment_id
5948: and t.task_id(+) = ra.task_id
5949: ),'N')

Line 5951: from pa_resource_assignments ra

5947: where ra.resource_assignment_id = tmp.resource_assignment_id
5948: and t.task_id(+) = ra.task_id
5949: ),'N')
5950: ,tmp.task_name = (select t.task_name
5951: from pa_resource_assignments ra
5952: ,pa_tasks t
5953: where ra.resource_assignment_id = tmp.resource_assignment_id
5954: and t.task_id = ra.task_id
5955: )

Line 5976: from pa_resource_assignments ra

5972: /* This is done to avoid executing the cursors multiple times for passing token values */
5973: UPDATE pa_fp_spread_calc_tmp tmp
5974: SET (tmp.task_id,tmp.resource_name) =
5975: (select ra.task_id,rlm.alias
5976: from pa_resource_assignments ra
5977: ,pa_resource_list_members rlm
5978: where ra.resource_assignment_id = tmp.resource_assignment_id
5979: and rlm.resource_list_member_id = ra.resource_list_member_id
5980: )

Line 5983: from pa_resource_assignments ra

5979: and rlm.resource_list_member_id = ra.resource_list_member_id
5980: )
5981: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5982: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5983: from pa_resource_assignments ra
5984: ,pa_tasks t
5985: where ra.resource_assignment_id = tmp.resource_assignment_id
5986: and t.task_id(+) = ra.task_id
5987: ),'N')

Line 5989: from pa_resource_assignments ra

5985: where ra.resource_assignment_id = tmp.resource_assignment_id
5986: and t.task_id(+) = ra.task_id
5987: ),'N')
5988: ,tmp.task_name = (select t.task_name
5989: from pa_resource_assignments ra
5990: ,pa_tasks t
5991: where ra.resource_assignment_id = tmp.resource_assignment_id
5992: and t.task_id = ra.task_id
5993: )

Line 6168: ,pa_resource_assignments ra

6164: ,tmp.old_mfc_cost_type_id
6165: ,tmp.new_mfc_cost_type_id
6166: FROM pa_fp_spread_calc_tmp tmp
6167: ,pa_resource_list_members rl
6168: ,pa_resource_assignments ra
6169: WHERE tmp.budget_version_id = p_budget_version_id
6170: AND ra.resource_assignment_id = tmp.resource_assignment_id
6171: AND rl.resource_list_member_id = ra.resource_list_member_id
6172: /** Bug fix: ORA-00979: not a GROUP BY expression in Package PA_FP_CALC_UTILS

Line 8367: ,pa_resource_assignments ra

8363: ,r.BL_CREATION_DATE
8364: ,NVL(ra.rate_based_flag,'N')
8365: FROM pa_fp_rollup_tmp r
8366: ,pa_budget_lines b
8367: ,pa_resource_assignments ra
8368: WHERE r.budget_line_id = b.budget_line_id
8369: AND b.budget_version_id = p_budget_version_id
8370: AND b.budget_version_id = r.budget_version_id --Bug 7520706
8371: AND ra.budget_version_id = r.budget_version_id --Bug 7520706

Line 8784: ,pa_resource_assignments ra

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;
8788: