APPS.CZ_UI_MGR dependencies on CZ_LOCALIZED_TEXTS

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 '||

173:
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:

Line 184: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' and '||

180:
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:

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:

Line 203: -----@ element_type : 8 --- caption text (cz_localized_texts)

199: -----@global entities are global rules, actions, texts that are referred in
200: -----@global templates. The global entities are stored in the table cz_ui_template_elements.
201: -----@The element type in the table cz_ui_template_elements are as follows:
202: -----@ element_type : 33,34,700 --- rule_id (cz_rules)
203: -----@ element_type : 8 --- caption text (cz_localized_texts)
204: -----@ element_type : 522 --- ui action (cz_ui_actions)
205:
206: PROCEDURE Propagate_del_flag_gl_entities
207: IS

Line 370: UPDATE cz_localized_texts

366: SET deleted_flag = '1'
367: WHERE rule_id = l_element_id_ref(i)
368: AND seeded_flag = '0';
369: ELSIF (l_element_type_ref(i) = 8) THEN
370: UPDATE cz_localized_texts
371: SET deleted_flag = '1'
372: WHERE intl_text_id = l_element_id_ref(i)
373: AND seeded_flag = '0';
374: ELSIF (l_element_type_ref(i) = 522) THEN