APPS.CZ_UI_MGR dependencies on CZ_UI_NODES

Line 64: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui and deleted_flag='1')

60:
61: begin
62:
63:
64: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui and deleted_flag='1')
65: loop
66: for m in(select ui_node_id from cz_ui_nodes
67: start with ui_node_id=n.ui_node_id
68: connect by prior ui_node_id=parent_id)

Line 66: for m in(select ui_node_id from cz_ui_nodes

62:
63:
64: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui and deleted_flag='1')
65: loop
66: for m in(select ui_node_id from cz_ui_nodes
67: start with ui_node_id=n.ui_node_id
68: connect by prior ui_node_id=parent_id)
69: loop
70: update cz_ui_nodes

Line 70: update cz_ui_nodes

66: for m in(select ui_node_id from cz_ui_nodes
67: start with ui_node_id=n.ui_node_id
68: connect by prior ui_node_id=parent_id)
69: loop
70: update cz_ui_nodes
71: set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=m.ui_node_id;
72:
73: update cz_ui_node_props
74: set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=m.ui_node_id;

Line 96: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui)

92: update cz_ui_properties
93: set deleted_flag='1' where ui_def_id=v_ui;
94: commit;
95:
96: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui)
97: loop
98:
99: update cz_ui_nodes
100: set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=n.ui_node_id;

Line 99: update cz_ui_nodes

95:
96: for n in(select ui_node_id from cz_ui_nodes where ui_def_id=v_ui)
97: loop
98:
99: update cz_ui_nodes
100: set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=n.ui_node_id;
101:
102: update cz_ui_node_props
103: set deleted_flag='1' where ui_def_id=v_ui and ui_node_id=n.ui_node_id;

Line 178: 'exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''1'') and '||

174: end loop;
175: commit;
176:
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 '||
178: 'exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''1'') and '||
179: 'not exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''0'')');
180:
181:
182: end if;

Line 179: 'not exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''0'')');

175: commit;
176:
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 '||
178: 'exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''1'') and '||
179: 'not exists(select null from CZ_UI_NODES where caption_id=a.intl_text_id and deleted_flag=''0'')');
180:
181:
182: end if;
183:

Line 185: 'exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''1'') and '||

181:
182: end if;
183:
184: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' and '||
185: 'exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''1'') and '||
186: 'not exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''0'')',
187: 'language','intl_text_id',TRUE);
188:
189: COMMIT;

Line 186: 'not exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''0'')',

182: end if;
183:
184: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' and '||
185: 'exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''1'') and '||
186: 'not exists(select null from CZ_UI_NODES where caption_id=cz_localized_texts.intl_text_id and deleted_flag=''0'')',
187: 'language','intl_text_id',TRUE);
188:
189: COMMIT;
190: