[Home] [Help]
257: ,decode(ra.bom_resource_id,NULL,NULL,
258: decode(nvl(ra.incur_by_res_class_code,ra.resource_class_code),'EQUIPMENT',ra.bom_resource_id,NULL))
259: ,nvl(ra.incur_by_role_id,ra.project_role_id)
260: ,ra.person_type_code
261: FROM pa_resource_assignments ra
262: --,pa_budget_versions bv
263: --,pa_proj_fp_options fp
264: --,pa_expenditure_types et
265: --,pa_non_labor_resources nlr
283: l_stage := 'Update the tmp table with exp,event,cate,Ids';
284: UPDATE pa_rbs_plans_in_tmp tmp
285: SET tmp.expenditure_type_id = (select et.expenditure_type_id
286: from pa_expenditure_types et
287: ,pa_resource_assignments ra
288: where et.expenditure_type = ra.expenditure_type
289: and ra.resource_assignment_id = tmp.source_id
290: and rownum =1 )
291: ,tmp.non_labor_resource_id = (select nlr.non_labor_resource_id
289: and ra.resource_assignment_id = tmp.source_id
290: and rownum =1 )
291: ,tmp.non_labor_resource_id = (select nlr.non_labor_resource_id
292: from pa_non_labor_resources nlr
293: ,pa_resource_assignments ra
294: where nlr.non_labor_resource = ra.non_labor_resource
295: and ra.resource_assignment_id = tmp.source_id
296: and rownum = 1)
297: ,tmp.expenditure_category_id = (select ec.expenditure_category_id
295: and ra.resource_assignment_id = tmp.source_id
296: and rownum = 1)
297: ,tmp.expenditure_category_id = (select ec.expenditure_category_id
298: from pa_expenditure_categories ec
299: ,pa_resource_assignments ra
300: where ec.expenditure_category = ra.expenditure_category
301: and ra.resource_assignment_id = tmp.source_id
302: and rownum = 1)
303: ,tmp.event_type_id = (select ev.event_type_id
301: and ra.resource_assignment_id = tmp.source_id
302: and rownum = 1)
303: ,tmp.event_type_id = (select ev.event_type_id
304: from pa_event_types ev
305: ,pa_resource_assignments ra
306: where ra.event_type = ev.event_type
307: and ra.resource_assignment_id = tmp.source_id
308: and rownum = 1)
309: ,tmp.resource_class_id = (select rc.resource_class_id
307: and ra.resource_assignment_id = tmp.source_id
308: and rownum = 1)
309: ,tmp.resource_class_id = (select rc.resource_class_id
310: from pa_resource_classes_b rc
311: ,pa_resource_assignments ra
312: where nvl(ra.incur_by_res_class_code,ra.resource_class_code) = rc.resource_class_code
313: and ra.resource_assignment_id = tmp.source_id
314: and rownum = 1) ;
315:
663: ,PLANNING_END_DATE
664: ,ra.project_id
665: ,ra.budget_version_id
666: ,l_financial_res_class_rlm_id
667: FROM pa_resource_assignments ra
668: WHERE ra.budget_version_id = p_budget_version_id;
669:
670: ELSE
671:
752: ,PLANNING_START_DATE
753: ,PLANNING_END_DATE
754: ,ra.project_id
755: ,ra.budget_version_id
756: FROM pa_resource_assignments ra
757: WHERE ra.budget_version_id = p_budget_version_id;
758:
759: END IF;
760:
2626: CURSOR check_ResAsgn_Exists(p_budget_version_id Number) IS
2627: SELECT 'Y'
2628: FROM dual
2629: WHERE EXISTS (select null
2630: from pa_resource_assignments ra
2631: where ra.budget_version_id = p_budget_version_id);
2632:
2633: CURSOR rbs_name IS
2634: SELECT rbs1.name old_rbs_name
2799: If l_txn_source_id_tab.count > 0 AND l_return_status = 'S' Then
2800: l_stage := 'Update Resource assignments with new RBS details';
2801: Print_msg(g_debug_flag,l_stage,l_proc_name);
2802: FORALL j IN l_txn_source_id_tab.FIRST ..l_txn_source_id_tab.LAST
2803: UPDATE pa_resource_assignments ra
2804: SET ra.rbs_element_id = NVL(l_rbs_element_id_tab(j),ra.rbs_element_id)
2805: ,ra.txn_accum_header_id = NVL(l_txn_accum_header_id_tab(j),ra.txn_accum_header_id)
2806: WHERE ra.budget_version_id = i.budget_version_id
2807: AND ra.project_id = i.project_id