[Home] [Help]
641: ,'CZ_GRID_COLS'
642: ,'CZ_GRID_CELLS') then
643: raise SKIP_IT;
644: end if;
645: if Tables(i).name='CZ_PS_NODES' then
646: --Resolve problems with logically deleted ps nodes
647:
648: -- NOTES:
649: -- 1. This change relies on ps_nodes to be done after devl_projects
648: -- NOTES:
649: -- 1. This change relies on ps_nodes to be done after devl_projects
650: -- 2. With this change ps_nodes will only be deleted if they belong to
651: -- deleted projects. Other logically deleted ps_nodes will be left around.
652: exec('cz_ps_nodes', 'where deleted_flag = ''1'' and not exists (select 1 from '||
653: 'cz_devl_projects where '||
654: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
655: 'ps_node_id', TRUE);
656:
650: -- 2. With this change ps_nodes will only be deleted if they belong to
651: -- deleted projects. Other logically deleted ps_nodes will be left around.
652: exec('cz_ps_nodes', 'where deleted_flag = ''1'' and not exists (select 1 from '||
653: 'cz_devl_projects where '||
654: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
655: 'ps_node_id', TRUE);
656:
657: /*
658: exec('delete from cz_ps_nodes a where a.deleted_flag = ''1'' and not exists (select NULL from cz_expression_nodes b where a.ps_node_id = b.ps_node_id '||
654: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
655: 'ps_node_id', TRUE);
656:
657: /*
658: exec('delete from cz_ps_nodes a where a.deleted_flag = ''1'' and not exists (select NULL from cz_expression_nodes b where a.ps_node_id = b.ps_node_id '||
659: 'and b.deleted_flag = ''0'') and a.deleted_flag = ''1'' and '||
660: ' ps_node_id not in'||
661: '(select distinct ps_node_id from '||
662: ' (select PRIMARY_OPT_ID as ps_node_id from CZ_DES_CHART_CELLS '||
674: ' select PS_NODE_ID as ps_node_id from CZ_GRID_CELLS '||
675: ' where deleted_flag=''0''))');
676:
677: for k in (select ps_node_id from CZ_EXPRESSION_NODES where deleted_flag='0') loop
678: update cz_ps_nodes set parent_id=0 where ps_node_id=k.ps_node_id and deleted_flag='1';
679: CheckSize(SQL%ROWCOUNT);
680: end loop; */
681:
682: else
746:
747: begin
748: get_TABLE_NAMES(Subschema_Name,Tables);
749: Proc_Name:='CZ_'||Subschema_Name||'_MGR.RESET_CLEAR';
750: delete from CZ_PS_NODES where ps_node_id>0;
751: delete from CZ_DEVL_PROJECTS where devl_project_id>0;
752: i:=1;
753: loop
754: if Tables(i).name not in ('CZ_PS_NODES','CZ_DEVL_PROJECTS') then
750: delete from CZ_PS_NODES where ps_node_id>0;
751: delete from CZ_DEVL_PROJECTS where devl_project_id>0;
752: i:=1;
753: loop
754: if Tables(i).name not in ('CZ_PS_NODES','CZ_DEVL_PROJECTS') then
755: dsql('DELETE FROM '||Tables(i).name);
756: end if;
757: i:=i+1;
758: if i>Tables.Last then
901: Tables(20).name:='CZ_POPULATOR_MAPS'; Tables(20).pk_name:='POP_MAP_ID';
902: Tables(21).name:='CZ_RULE_FOLDERS'; Tables(21).pk_name:='RULE_FOLDER_ID';
903: Tables(22).name:='CZ_DES_CHART_CELLS'; Tables(22).pk_name:=NULL;
904: Tables(23).name:='CZ_DES_CHART_FEATURES'; Tables(23).pk_name:=NULL;
905: Tables(24).name:='CZ_PS_NODES'; Tables(24).pk_name:='PS_NODE_ID';
906: Tables(25).name:='CZ_MODEL_REF_EXPLS'; Tables(25).pk_name:='MODEL_REF_EXPL_ID';
907: Tables(26).name:='CZ_ARCHIVES'; Tables(26).pk_name:=NULL;
908: Tables(27).name:='CZ_ARCHIVE_REFS'; Tables(27).pk_name:=NULL;
909: Tables(28).name:='CZ_RP_ENTRIES'; Tables(28).pk_name:=NULL;