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
695: insert into PA_XBS_DENORM_temp
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
695: insert into PA_XBS_DENORM_temp
696: (
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
839: OPEN c_temp( p_wbs_version_id_to );
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
839: OPEN c_temp( p_wbs_version_id_to );
840: FETCH c_temp bulk collect into
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
1090: OPEN c_temp( p_wbs_version_id_from,p_wbs_version_id_to );
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
1090: OPEN c_temp( p_wbs_version_id_from,p_wbs_version_id_to );
1091: FETCH c_temp bulk collect into