eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_BASE_MGR dependencies on CZ_PS_NODES

Line 647: if Tables(i).name='CZ_PS_NODES' then

643: ,'CZ_GRID_CELLS') then
644: raise SKIP_IT;
645: end if;
646:
647: if Tables(i).name='CZ_PS_NODES' then
648: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);
649: --Resolve problems with logically deleted ps nodes
650:
651: -- NOTES:

Line 648: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);

644: raise SKIP_IT;
645: end if;
646:
647: if Tables(i).name='CZ_PS_NODES' then
648: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);
649: --Resolve problems with logically deleted ps nodes
650:
651: -- NOTES:
652: -- 1. This change relies on ps_nodes to be done after devl_projects

Line 655: exec('cz_ps_nodes', 'where deleted_flag = ''1'' and not exists (select 1 from '||

651: -- NOTES:
652: -- 1. This change relies on ps_nodes to be done after devl_projects
653: -- 2. With this change ps_nodes will only be deleted if they belong to
654: -- deleted projects. Other logically deleted ps_nodes will be left around.
655: exec('cz_ps_nodes', 'where deleted_flag = ''1'' and not exists (select 1 from '||
656: 'cz_devl_projects where '||
657: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
658: 'ps_node_id', TRUE);
659:

Line 657: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',

653: -- 2. With this change ps_nodes will only be deleted if they belong to
654: -- deleted projects. Other logically deleted ps_nodes will be left around.
655: exec('cz_ps_nodes', 'where deleted_flag = ''1'' and not exists (select 1 from '||
656: 'cz_devl_projects where '||
657: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
658: 'ps_node_id', TRUE);
659:
660: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);
661:

Line 660: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);

656: 'cz_devl_projects where '||
657: 'devl_project_id = cz_ps_nodes.devl_project_id and deleted_flag = ''0'')',
658: 'ps_node_id', TRUE);
659:
660: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);
661:
662: /*
663: 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 '||
664: 'and b.deleted_flag = ''0'') and a.deleted_flag = ''1'' and '||

Line 663: 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:
660: WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,2);
661:
662: /*
663: 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 '||
664: 'and b.deleted_flag = ''0'') and a.deleted_flag = ''1'' and '||
665: ' ps_node_id not in'||
666: '(select distinct ps_node_id from '||
667: ' (select PRIMARY_OPT_ID as ps_node_id from CZ_DES_CHART_CELLS '||

Line 683: update cz_ps_nodes set parent_id=0 where ps_node_id=k.ps_node_id and deleted_flag='1';

679: ' select PS_NODE_ID as ps_node_id from CZ_GRID_CELLS '||
680: ' where deleted_flag=''0''))');
681:
682: for k in (select ps_node_id from CZ_EXPRESSION_NODES where deleted_flag='0') loop
683: update cz_ps_nodes set parent_id=0 where ps_node_id=k.ps_node_id and deleted_flag='1';
684: CheckSize(SQL%ROWCOUNT);
685: end loop; */
686:
687: else

Line 755: delete from CZ_PS_NODES where ps_node_id>0;

751:
752: begin
753: get_TABLE_NAMES(Subschema_Name,Tables);
754: Proc_Name:='CZ_'||Subschema_Name||'_MGR.RESET_CLEAR';
755: delete from CZ_PS_NODES where ps_node_id>0;
756: delete from CZ_DEVL_PROJECTS where devl_project_id>0;
757: i:=1;
758: loop
759: if Tables(i).name not in ('CZ_PS_NODES','CZ_DEVL_PROJECTS') then

Line 759: if Tables(i).name not in ('CZ_PS_NODES','CZ_DEVL_PROJECTS') then

755: delete from CZ_PS_NODES where ps_node_id>0;
756: delete from CZ_DEVL_PROJECTS where devl_project_id>0;
757: i:=1;
758: loop
759: if Tables(i).name not in ('CZ_PS_NODES','CZ_DEVL_PROJECTS') then
760: dsql('DELETE FROM '||Tables(i).name);
761: end if;
762: i:=i+1;
763: if i>Tables.Last then

Line 932: Tables(24).name:='CZ_PS_NODES'; Tables(24).pk_name:='PS_NODE_ID';

928: Tables(20).name:='CZ_POPULATOR_MAPS'; Tables(20).pk_name:='POP_MAP_ID';
929: Tables(21).name:='CZ_RULE_FOLDERS'; Tables(21).pk_name:='RULE_FOLDER_ID';
930: Tables(22).name:='CZ_DES_CHART_CELLS'; Tables(22).pk_name:=NULL;
931: Tables(23).name:='CZ_DES_CHART_FEATURES'; Tables(23).pk_name:=NULL;
932: Tables(24).name:='CZ_PS_NODES'; Tables(24).pk_name:='PS_NODE_ID';
933: Tables(25).name:='CZ_MODEL_REF_EXPLS'; Tables(25).pk_name:='MODEL_REF_EXPL_ID';
934: Tables(26).name:='CZ_ARCHIVES'; Tables(26).pk_name:='ARCHIVE_ID';
935: Tables(27).name:='CZ_ARCHIVE_REFS'; Tables(27).pk_name:=NULL;
936: Tables(28).name:='CZ_RP_ENTRIES'; Tables(28).pk_name:='OBJECT_ID';