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 254: ,pa_resource_assignments ra

250: SELECT tmp.resource_assignment_id
251: ,rl.alias resource_name
252: ,tmp.txn_currency_code
253: FROM pa_fp_spread_calc_tmp tmp
254: ,pa_resource_assignments ra
255: ,pa_resource_list_members rl
256: WHERE tmp.budget_version_id = p_budget_version_id
257: AND ra.resource_assignment_id = tmp.resource_assignment_id
258: AND rl.resource_list_member_id = ra.resource_list_member_id

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

287: * 5:TABLE ACCESS BY INDEX ROWID PA_FP_SPREAD_CALC_TMP :(cost=6,rows=82)
288: * 6:INDEX RANGE SCAN PA_FP_SPREAD_CALC_TMP_N2 :(cost=2,rows=33)
289: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
290: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
291: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
292: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
293: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
294: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
295: **/

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

288: * 6:INDEX RANGE SCAN PA_FP_SPREAD_CALC_TMP_N2 :(cost=2,rows=33)
289: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
290: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
291: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
292: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
293: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
294: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
295: **/
296: CURSOR cur_blDatesCheck IS

Line 301: ,pa_resource_assignments ra

297: SELECT tmp.resource_assignment_id
298: ,rl.alias resource_name
299: ,tmp.txn_currency_code
300: FROM pa_fp_spread_calc_tmp tmp
301: ,pa_resource_assignments ra
302: ,pa_resource_list_members rl
303: WHERE tmp.budget_version_id = p_budget_version_id
304: AND ra.resource_assignment_id = tmp.resource_assignment_id
305: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 1217: ,pa_resource_assignments ra

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

Line 2188: ,pa_resource_assignments ra

2184: ,NVL(tmp.MFC_COST_CHANGE_FLAG,'N') mfc_cost_change_flag
2185: ,NVL(tmp.RLM_ID_CHANGE_FLAG,'N') rlm_id_change_flag
2186: ,NVL(tmp.system_reference_var1 ,'N') ra_in_multi_cur_flag
2187: FROM pa_fp_spread_calc_tmp tmp
2188: ,pa_resource_assignments ra
2189: WHERE tmp.budget_version_id = p_budget_version_id
2190: AND tmp.resource_assignment_id = ra.resource_assignment_id
2191: AND ra.rate_based_flag = 'N'
2192: AND ( (NVL(tmp.bl_txn_raw_cost,0) = nvl(tmp.bl_quantity,0)

Line 2356: ,pa_resource_assignments ra

2352: ,NVL(tmp.RLM_ID_CHANGE_FLAG,'N') rlm_id_change_flag
2353: ,NVL(tmp.system_reference_var1 ,'N') ra_in_multi_cur_flag
2354: ,NVL(tmp.DELETE_BL_FLAG,'N') delete_bl_flag
2355: FROM pa_fp_spread_calc_tmp tmp
2356: ,pa_resource_assignments ra
2357: WHERE tmp.budget_version_id = p_budget_version_id
2358: AND tmp.resource_assignment_id = ra.resource_assignment_id
2359: AND nvl(ra.rate_based_flag,'N') = 'N'
2360: AND NVL(tmp.quantity_changed_flag,'N') = 'N'

Line 2678: ,pa_resource_assignments ra

2674: ,NVL(tmp.raw_cost_changed_flag,'N') raw_cost_changed_flag
2675: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2676: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2677: FROM pa_fp_spread_calc_tmp tmp
2678: ,pa_resource_assignments ra
2679: ,pa_resource_list_members rlm
2680: WHERE ra.budget_version_id = p_budget_version_id
2681: AND ra.resource_assignment_id = tmp.resource_assignment_id
2682: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 2724: ,pa_resource_assignments ra

2720: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2721: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2722: ,tmp.bill_markup_percentage
2723: FROM pa_fp_spread_calc_tmp tmp
2724: ,pa_resource_assignments ra
2725: ,pa_resource_list_members rlm
2726: WHERE ra.budget_version_id = p_budget_version_id
2727: AND ra.resource_assignment_id = tmp.resource_assignment_id
2728: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3360: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3356: IF P_PA_DEBUG_MODE = 'Y' Then
3357: print_msg(g_stage);
3358: End If;
3359: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
3360: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3361: SET ra.rate_based_flag = 'Y'
3362: ,ra.unit_of_measure = l_uom_tab(i)
3363: WHERE ra.resource_assignment_id = l_resource_assignment_tab(i)
3364: AND l_reset_rate_based_flag_tab(i) = 'Y';

Line 3427: from pa_resource_assignments ra

3423: ,tmp.resource_UOM) =
3424: (select nvl(ra.rate_based_flag,'N' )
3425: ,nvl(ra.resource_rate_based_flag,'N')
3426: ,l_uom_tab(i)
3427: from pa_resource_assignments ra
3428: where ra.resource_assignment_id = tmp.resource_assignment_id)
3429: /* bug fix:5116157: to store the reset flag so that correct rate base flag and uom can pass to PJI*/
3430: ,tmp.system_reference_var3 = NVL(l_reset_rate_based_flag_tab(i),'N') -- Reset_Rate_Base_Flag
3431: /* bug fix:5726773 */

Line 3542: ,pa_resource_assignments ra

3538: ,NVL(tmp.raw_cost_changed_flag,'N') raw_cost_changed_flag
3539: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
3540: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
3541: FROM pa_fp_spread_calc_tmp tmp
3542: ,pa_resource_assignments ra
3543: ,pa_resource_list_members rlm
3544: WHERE ra.budget_version_id = p_budget_version_id
3545: AND ra.resource_assignment_id = tmp.resource_assignment_id
3546: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3557: ,pa_resource_assignments ra

3553: SELECT 'Y'
3554: FROM dual
3555: WHERE EXISTS (select null
3556: from pa_budget_lines bl
3557: ,pa_resource_assignments ra
3558: where ra.resource_assignment_id = p_ra_id
3559: and bl.resource_assignment_id = ra.resource_assignment_id
3560: and NVL(ra.rate_based_flag,'N') = 'Y'
3561: /* Bug fix:4083873 and bl.txn_currency_code = p_txn_cur_code */

Line 3590: ,pa_resource_assignments ra

3586: ,tmp.end_date
3587: ,tmp.bl_quantity
3588: ,rlm.unit_of_measure uom
3589: FROM pa_fp_spread_calc_tmp tmp
3590: ,pa_resource_assignments ra
3591: ,pa_resource_list_members rlm
3592: WHERE tmp.budget_version_id = p_budget_version_id
3593: AND ra.resource_assignment_id = tmp.resource_assignment_id
3594: AND rlm.resource_list_member_id = ra.resource_list_member_id

Line 3619: l_webadi_task_id pa_resource_assignments.task_id%TYPE;

3615: l_reset_plsql_tab_flag VARCHAR2(10) := 'N';
3616:
3617: -- bug 4431269: added the followings
3618: -- variables to be used to call process_errors in web adi flow.
3619: l_webadi_task_id pa_resource_assignments.task_id%TYPE;
3620: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
3621: l_webAdi_context VARCHAR2(250) ;
3622:
3623: /* bug fix:5726773 */

Line 3620: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

3616:
3617: -- bug 4431269: added the followings
3618: -- variables to be used to call process_errors in web adi flow.
3619: l_webadi_task_id pa_resource_assignments.task_id%TYPE;
3620: l_webadi_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
3621: l_webAdi_context VARCHAR2(250) ;
3622:
3623: /* bug fix:5726773 */
3624: SKIP_RECORD EXCEPTION;

Line 3870: FROM pa_resource_assignments pra

3866: SELECT pra.task_id,
3867: pra.resource_list_member_id
3868: INTO l_webadi_task_id,
3869: l_webadi_rlm_id
3870: FROM pa_resource_assignments pra
3871: WHERE pra.resource_assignment_id = i.resource_assignment_id
3872: AND pra.budget_version_id = p_budget_version_id;
3873: -- populating the error tables.
3874: --print_msg('1100.1.1.1:Web ADI context populating errors');

Line 3928: FROM pa_resource_assignments pra

3924: SELECT pra.task_id,
3925: pra.resource_list_member_id
3926: INTO l_webadi_task_id,
3927: l_webadi_rlm_id
3928: FROM pa_resource_assignments pra
3929: WHERE pra.resource_assignment_id = i.resource_assignment_id
3930: AND pra.budget_version_id = p_budget_version_id;
3931: -- populating the error tables.
3932: --print_msg('1100.1.1.1:Web ADI context populating errors');

Line 4125: from pa_resource_assignments ra

4121: ,rtx.txn_bill_rate_override = NULL
4122: WHERE rtx.resource_assignment_id = l_resource_assignment_tab(i)
4123: AND rtx.txn_currency_code = l_txn_currency_code_tab(i)
4124: AND EXISTS ( select null
4125: from pa_resource_assignments ra
4126: where ra.rate_based_flag = 'Y'
4127: and ra.resource_assignment_id = rtx.resource_assignment_id
4128: );
4129:

Line 4135: UPDATE PA_RESOURCE_ASSIGNMENTS ra

4131: IF P_PA_DEBUG_MODE = 'Y' Then
4132: print_msg('Updating RA with Non-Rate base flag');
4133: End If;
4134: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
4135: UPDATE PA_RESOURCE_ASSIGNMENTS ra
4136: SET ra.rate_based_flag = 'N'
4137: ,ra.unit_of_measure = 'DOLLARS'
4138: WHERE ra.resource_assignment_id = l_resource_assignment_tab(i);
4139:

Line 4168: from pa_resource_assignments ra

4164: ,tmp.resource_uom) =
4165: (select nvl(ra.rate_based_flag,'N' )
4166: ,nvl(ra.resource_rate_based_flag,'N')
4167: ,l_uom_tab(i)
4168: from pa_resource_assignments ra
4169: where ra.resource_assignment_id = tmp.resource_assignment_id)
4170: WHERE tmp.resource_assignment_id = l_resource_assignment_tab(i)
4171: AND tmp.txn_currency_code = l_txn_currency_code_tab(i)
4172: AND ((p_source_context = 'RESOURCE_ASSIGNMENT')

Line 4235: FROM pa_resource_assignments ra

4231: ,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
4232: ,DECODE(ra.spread_curve_id,6,ra.sp_fixed_date,ra.planning_end_date) planning_end_date
4233: ,tmp.task_name
4234: ,tmp.resource_name
4235: FROM pa_resource_assignments ra
4236: ,pa_fp_spread_calc_tmp tmp
4237: WHERE ra.budget_version_id = p_budget_verson_id
4238: AND ra.resource_assignment_id = tmp.resource_assignment_id
4239: AND NOT EXISTS

Line 4330: ,pa_resource_assignments ra

4326: ,ra.planning_start_date
4327: ,ra.planning_end_date
4328: ,rl.alias resource_name
4329: FROM pa_fp_spread_calc_tmp tmp
4330: ,pa_resource_assignments ra
4331: ,pa_resource_list_members rl
4332: WHERE tmp.budget_version_id = p_budget_version_id
4333: AND ra.resource_assignment_id = tmp.resource_assignment_id
4334: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 5320: from pa_resource_assignments ra

5316: ,ra.planning_start_date,tmp.SYSTEM_REFERENCE_DAT1))
5317: ,decode(tmp.SYSTEM_REFERENCE_DAT2,NULL,NULL
5318: ,decode(sign(trunc(tmp.SYSTEM_REFERENCE_DAT2)-trunc(ra.planning_end_date)),1
5319: ,ra.planning_end_date,tmp.SYSTEM_REFERENCE_DAT2))
5320: from pa_resource_assignments ra
5321: where ra.resource_assignment_id = tmp.resource_assignment_id
5322: and ra.budget_version_id = tmp.budget_version_id)
5323: WHERE tmp.resource_assignment_id = p_resource_assignment_id_tab(i)
5324: AND NVL(tmp.system_reference_var1,'N') = 'Y'

Line 5781: from pa_resource_assignments ra

5777: and tmp1.OLD_PLAN_END_DATE is not null
5778: and rownum = 1
5779: ),tmp.OLD_PLAN_END_DATE)
5780: ,tmp.NEW_PLAN_START_DATE = decode(tmp.NEW_PLAN_START_DATE,NULL,(select ra.planning_start_date
5781: from pa_resource_assignments ra
5782: where ra.resource_assignment_id = tmp.resource_assignment_id
5783: ),tmp.NEW_PLAN_START_DATE)
5784: ,tmp.NEW_PLAN_END_DATE = decode(tmp.NEW_PLAN_END_DATE,NULL,(select ra.planning_end_date
5785: from pa_resource_assignments ra

Line 5785: from pa_resource_assignments ra

5781: from pa_resource_assignments ra
5782: where ra.resource_assignment_id = tmp.resource_assignment_id
5783: ),tmp.NEW_PLAN_START_DATE)
5784: ,tmp.NEW_PLAN_END_DATE = decode(tmp.NEW_PLAN_END_DATE,NULL,(select ra.planning_end_date
5785: from pa_resource_assignments ra
5786: where ra.resource_assignment_id = tmp.resource_assignment_id
5787: ),tmp.NEW_PLAN_END_DATE)
5788: WHERE tmp.budget_version_id = p_budget_version_id;
5789: --print_msg('synch_Upd: NumOfRowUpdated['||sql%rowcount||']');

Line 5909: from pa_resource_assignments ra

5905: where tmp1.resource_assignment_id = tmp.resource_assignment_id
5906: and tmp1.rlm_id_change_flag = 'Y'))
5907: ,(tmp.task_id,tmp.resource_name) =
5908: (select ra.task_id,rlm.alias
5909: from pa_resource_assignments ra
5910: ,pa_resource_list_members rlm
5911: where ra.resource_assignment_id = tmp.resource_assignment_id
5912: and rlm.resource_list_member_id = ra.resource_list_member_id
5913: )

Line 5916: from pa_resource_assignments ra

5912: and rlm.resource_list_member_id = ra.resource_list_member_id
5913: )
5914: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5915: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5916: from pa_resource_assignments ra
5917: ,pa_tasks t
5918: where ra.resource_assignment_id = tmp.resource_assignment_id
5919: and t.task_id(+) = ra.task_id
5920: ),'N')

Line 5922: from pa_resource_assignments ra

5918: where ra.resource_assignment_id = tmp.resource_assignment_id
5919: and t.task_id(+) = ra.task_id
5920: ),'N')
5921: ,tmp.task_name = (select t.task_name
5922: from pa_resource_assignments ra
5923: ,pa_tasks t
5924: where ra.resource_assignment_id = tmp.resource_assignment_id
5925: and t.task_id = ra.task_id
5926: )

Line 5947: from pa_resource_assignments ra

5943: /* This is done to avoid executing the cursors multiple times for passing token values */
5944: UPDATE pa_fp_spread_calc_tmp tmp
5945: SET (tmp.task_id,tmp.resource_name) =
5946: (select ra.task_id,rlm.alias
5947: from pa_resource_assignments ra
5948: ,pa_resource_list_members rlm
5949: where ra.resource_assignment_id = tmp.resource_assignment_id
5950: and rlm.resource_list_member_id = ra.resource_list_member_id
5951: )

Line 5954: from pa_resource_assignments ra

5950: and rlm.resource_list_member_id = ra.resource_list_member_id
5951: )
5952: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5953: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5954: from pa_resource_assignments ra
5955: ,pa_tasks t
5956: where ra.resource_assignment_id = tmp.resource_assignment_id
5957: and t.task_id(+) = ra.task_id
5958: ),'N')

Line 5960: from pa_resource_assignments ra

5956: where ra.resource_assignment_id = tmp.resource_assignment_id
5957: and t.task_id(+) = ra.task_id
5958: ),'N')
5959: ,tmp.task_name = (select t.task_name
5960: from pa_resource_assignments ra
5961: ,pa_tasks t
5962: where ra.resource_assignment_id = tmp.resource_assignment_id
5963: and t.task_id = ra.task_id
5964: )

Line 6139: ,pa_resource_assignments ra

6135: ,tmp.old_mfc_cost_type_id
6136: ,tmp.new_mfc_cost_type_id
6137: FROM pa_fp_spread_calc_tmp tmp
6138: ,pa_resource_list_members rl
6139: ,pa_resource_assignments ra
6140: WHERE tmp.budget_version_id = p_budget_version_id
6141: AND ra.resource_assignment_id = tmp.resource_assignment_id
6142: AND rl.resource_list_member_id = ra.resource_list_member_id
6143: /** Bug fix: ORA-00979: not a GROUP BY expression in Package PA_FP_CALC_UTILS

Line 8336: ,pa_resource_assignments ra

8332: ,r.BL_CREATION_DATE
8333: ,NVL(ra.rate_based_flag,'N')
8334: FROM pa_fp_rollup_tmp r
8335: ,pa_budget_lines b
8336: ,pa_resource_assignments ra
8337: WHERE r.budget_line_id = b.budget_line_id
8338: AND b.budget_version_id = p_budget_version_id
8339: AND b.budget_version_id = r.budget_version_id --Bug 7520706
8340: AND ra.budget_version_id = r.budget_version_id --Bug 7520706

Line 8753: ,pa_resource_assignments ra

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