10888: element_version_id ,
10889: display_sequence ,
10890: level_sequence ,
10891: sub_level_seq
10892: FROM pa_proj_elem_ver_tmp
10893: ORDER BY display_sequence ,
10894: level_sequence ,
10895: sub_level_Seq;
10896: BEGIN
10931: SET a.display_sequence = t_disp_seq ,
10932: a.level_sequence = t_level_seq
10933: WHERE a.element_version_id = p_elem_ver_id ;
10934:
10935: delete from pa_proj_elem_ver_tmp;
10936:
10937: INSERT
10938: INTO pa_proj_elem_ver_tmp
10939: (
10934:
10935: delete from pa_proj_elem_ver_tmp;
10936:
10937: INSERT
10938: INTO pa_proj_elem_ver_tmp
10939: (
10940: project_id ,
10941: task_id ,
10942: parent_task_id ,