[Home] [Help]
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:
657: /*
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
755: dsql('DELETE FROM '||Tables(i).name);
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
878:
879: begin
880:
881: if upper(SubSchema)='PS' then
882: Tables(1).name:='CZ_DEVL_PROJECTS'; Tables(1).pk_name:='DEVL_PROJECT_ID';
883: Tables(2).name:='CZ_DEVL_PRJ_USER_GROUPS'; Tables(2).pk_name:=NULL;
884: Tables(3).name:='CZ_FUNC_COMP_SPECS'; Tables(3).pk_name:='FUNC_COMP_ID';
885: Tables(4).name:='CZ_FUNC_COMP_REFS'; Tables(4).pk_name:=NULL;
886: Tables(5).name:='CZ_PS_PROP_VALS'; Tables(5).pk_name:=NULL;
1004: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1005: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
1006: begin
1007: select TABLE_OWNER into CZ_SCHEMA from user_synonyms
1008: where SYNONYM_NAME='CZ_DEVL_PROJECTS';
1009: exception
1010: when NO_DATA_FOUND then
1011: CZ_SCHEMA:=USER;
1012: when OTHERS then