[Home] [Help]
709:
710: --Changed this query for fetching correct tasks in case of split structures.
711: select a.element_version_id , a.proj_element_id , c.element_number bulk collect
712: into l_elem_ver_id_tbl,l_task_id_tbl , l_task_num_tbl
713: from pa_proj_element_versions a , pa_proj_elem_ver_structure s, pa_proj_elements c, pa_proj_element_versions d,
714: pa_proj_structure_types PPST, pa_integration_settings pis
715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id
2435: set pm_project_reference = P_PROJECT_IN_REC.pm_project_reference ,
2436: pm_product_code = 'PRIMAVERA'
2437: where project_id = P_PROJECT_IN_REC.pa_project_id;
2438:
2439: update pa_proj_elements a
2440: set ( pm_source_reference ) =
2441: ( select b.task_ref
2442: from pa_wbs_seq_tmp b
2443: where b.task_id = a.proj_element_id )
2454:
2455:
2456: select a.proj_element_id , a.element_version_id
2457: bulk collect into X_DELETE_TASK_ID_TBL, X_DELETE_TASK_VER_ID_TBL
2458: from PA_PROJ_ELEMENT_VERSIONS a , pa_proj_elements c
2459: where a.project_id = P_PROJECT_IN_REC.pa_project_id
2460: and a.parent_structure_version_id = P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2461: and a.object_type = 'PA_TASKS'
2462: and a.proj_element_id = c.proj_element_id