673: and projv1s.parent_structure_version_id=temp.struct_version_id
674: and projv1s.parent_structure_version_id=p_wbs_version_id_to;
675:
676: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
677: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
678: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
674: and projv1s.parent_structure_version_id=p_wbs_version_id_to;
675:
676: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
677: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
678: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
675:
676: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
677: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
678: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
676: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
677: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
678: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
677: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
678: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
679: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
680: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
681: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
682: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
683: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
684: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
685: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
686: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
694: begin
817: and projv1b.parent_structure_version_id=temp.struct_version_id
818: and projv1b.parent_structure_version_id=p_wbs_version_id_to;
819:
820: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
821: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
822: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
818: and projv1b.parent_structure_version_id=p_wbs_version_id_to;
819:
820: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
821: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
822: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
819:
820: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
821: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
822: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
820: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
821: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
822: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
821: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
822: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
823: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
824: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
825: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
826: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
827: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
828: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
829: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
837:
830: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
837:
838: begin
1068: and projsup.proj_element_id= xbs.sup_emt_id
1069: and xbs.struct_version_id= p_wbs_version_id_from;
1070:
1071: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1072: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1073: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1069: and xbs.struct_version_id= p_wbs_version_id_from;
1070:
1071: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1072: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1073: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1070:
1071: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1072: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1073: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1071: struct_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1072: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1073: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1072: prg_grouptab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1073: sup_project_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1074: sup_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1075: sup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1076: struct_version_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1077: sub_leaf_flagtab SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1078: sup_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1079: sub_leveltab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1080: relationship_typetab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1088:
1081: struct_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1088:
1089: begin