APPS.CZ_UI_MGR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 55

procedure Propogate_DeletedFlag is

Type UI_type is table of CZ_UI_DEFS.ui_def_id%TYPE;

Line: 64

for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui and deleted_flag='1')
loop
   for m in(select  ui_node_id from cz_ui_nodes
            start with ui_node_id=n.ui_node_id
            connect by prior ui_node_id=parent_id)
   loop
      update cz_ui_nodes
      set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=m.ui_node_id;

Line: 73

      update cz_ui_node_props
      set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=m.ui_node_id;

Line: 79

select ui_def_id bulk collect into UIs
from CZ_UI_DEFS where (devl_project_id in(select devl_project_id from cz_devl_projects where
deleted_flag='1' and devl_project_id<>0) or deleted_flag='1') and NVL(seeded_flag,'0')='0' and ui_def_id<>0;

Line: 88

      update cz_ui_defs
      set deleted_flag='1' where ui_def_id=v_ui;

Line: 92

      update cz_ui_properties
      set deleted_flag='1' where ui_def_id=v_ui;

Line: 96

      for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui)
      loop

          update cz_ui_nodes
          set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=n.ui_node_id;

Line: 102

          update cz_ui_node_props
          set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=n.ui_node_id;

Line: 108

     update cz_ui_page_elements
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 113

     update cz_ui_page_sets
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 118

     update cz_ui_page_refs
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 123

     update cz_ui_refs
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 128

     update cz_ui_actions
     set deleted_flag='1'
     where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';

Line: 133

     update cz_ui_templates
     set deleted_flag='1'
     where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';

Line: 138

     update cz_ui_ref_templates
     set deleted_flag='1'
     where template_ui_def_id=v_ui ;

Line: 143

     update cz_ui_images
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 148

     delete from cz_ui_images
     where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';

Line: 151

     update cz_ui_cont_type_templs
     set deleted_flag='1'
     where ui_def_id=v_ui;

Line: 158

     for k in(select jrad_doc from cz_ui_pages
              where ui_def_id=v_ui and NVL(seeded_flag,'0')='0' and deleted_flag='0')
     loop
        begin
            jdr_docbuilder.deleteDocument(k.jrad_doc);

Line: 165

                 CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE','deleteDocument "'||k.jrad_doc||'" : '||SQLERRM);

Line: 169

     update cz_ui_pages
     set deleted_flag='1'
     where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';

Line: 177

   CZ_BASE_MGR.exec('update CZ_LOCALIZED_TEXTS a set deleted_flag=''1'' where deleted_flag=''0'' and NVL(seeded_flag,''0'')='''||'0'||''' AND '||
    'exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''1'') and '||
    'not exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''0'')');

Line: 184

CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' and '||
 'exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''1'') and '||
 'not exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''0'')',
'language','intl_text_id',TRUE);

Line: 230

    l_gl_template_tbl.DELETE;

Line: 231

    SELECT template_id, jrad_doc
    BULK
    COLLECT
    INTO   l_gl_template_tbl, l_gl_jrad_docs_tbl
    FROM   cz_ui_templates
    WHERE  cz_ui_templates.deleted_flag = '1'
    AND    cz_ui_templates.seeded_flag  = '0'
    AND    cz_ui_templates.ui_def_id    =  0;

Line: 248

    l_pb_gl_template_tbl.DELETE;

Line: 249

    SELECT template_id  BULK COLLECT
    INTO   l_pb_gl_template_tbl
    FROM   cz_ui_templates
    WHERE  cz_ui_templates.seeded_flag  = '0'
    AND    cz_ui_templates.ui_def_id    =  1
    AND    cz_ui_templates.template_id NOT IN (SELECT object_id
							     FROM   cz_model_publications
							     WHERE  object_type   = 'UIT'
								AND   deleted_flag  = '0'
								AND   ui_def_id     = 1
								AND   source_target_flag = 'T');

Line: 274

    SELECT jrad_doc   BULK COLLECT INTO  l_pb_gl_jrad_docs_tbl
    FROM   cz_ui_templates t0
    WHERE  t0.seeded_flag  = '0'
    AND    t0.ui_def_id    =  1
    AND NOT EXISTS (SELECT 1 FROM cz_model_publications
                    WHERE  object_type   = 'UIT'
                    AND   deleted_flag  = '0'
                    AND   ui_def_id     = 1
                    AND   source_target_flag = 'T'
                    AND object_id = t0.template_id)
    AND NOT EXISTS (SELECT 1 FROM   cz_ui_templates t
                    WHERE  t.seeded_flag  = '0'
                    AND    t.ui_def_id    =  1
                    AND EXISTS (SELECT 1 FROM   cz_model_publications
                                WHERE  object_type   = 'UIT'
                                AND   deleted_flag  = '0'
                                AND   ui_def_id     = 1
                                AND   source_target_flag = 'T'
                                AND object_id = t.template_id)
                    AND t.jrad_doc = t0.jrad_doc) ;

Line: 311

      l_element_id_ref.DELETE;

Line: 312

	l_element_type_ref.DELETE;

Line: 313

	l_templ_id_ref.DELETE;

Line: 316

	    l_element_id_tbl.DELETE;

Line: 317

          l_element_type_tbl.DELETE;

Line: 318

	    l_templ_id_tbl.DELETE;

Line: 319

	    SELECT element_id,element_type,template_id
	     BULK
	    COLLECT
		INTO l_element_id_tbl,l_element_type_tbl,l_templ_id_tbl
	     FROM  cz_ui_template_elements
	    WHERE  cz_ui_template_elements.template_id = l_gl_template_tbl(i)
	     AND   cz_ui_template_elements.seeded_flag = '0';

Line: 338

          UPDATE cz_ui_template_elements
		 SET deleted_flag = '1'
           WHERE template_id  = l_gl_template_tbl(i)
		     AND seeded_flag = '0';

Line: 351

              jdr_docbuilder.deleteDocument(l_gl_jrad_docs_tbl(i));

Line: 354

                 CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE','deleteDocument "'||l_gl_jrad_docs_tbl(i)||'" : '||SQLERRM);

Line: 365

			UPDATE cz_rules
			SET    deleted_flag = '1'
			WHERE  rule_id = l_element_id_ref(i)
			AND seeded_flag = '0';

Line: 370

			UPDATE cz_localized_texts
			SET    deleted_flag = '1'
			WHERE  intl_text_id = l_element_id_ref(i)
			AND seeded_flag = '0';

Line: 375

			UPDATE cz_ui_actions
			SET    deleted_flag = '1'
			WHERE  ui_action_id = l_element_id_ref(i)
			AND seeded_flag = '0';

Line: 394

Propogate_DeletedFlag;