17: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
18:
19: procedure REDO_STATISTICS is
20: begin
21: CZ_BASE_MGR.REDO_STATISTICS('UI');
22: end;
23:
24: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
25: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
26:
27: procedure TRIGGERS_ENABLED
28: (Switch in varchar2) is
29: begin
30: CZ_BASE_MGR.TRIGGERS_ENABLED('UI',Switch);
31: end;
32:
33: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
34: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
35:
36: procedure CONSTRAINTS_ENABLED
37: (Switch in varchar2) is
38: begin
39: CZ_BASE_MGR.CONSTRAINTS_ENABLED('UI',Switch);
40: end;
41:
42: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
43: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
45: procedure REDO_SEQUENCES
46: (RedoStart_Flag in varchar2,
47: incr in integer default null) is
48: begin
49: CZ_BASE_MGR.REDO_SEQUENCES('UI',RedoStart_Flag,incr);
50: end;
51:
52: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
53: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
161: begin
162: jdr_docbuilder.deleteDocument(k.jrad_doc);
163: exception
164: when others then
165: CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE','deleteDocument "'||k.jrad_doc||'" : '||SQLERRM);
166: end;
167: end loop;
168:
169: update cz_ui_pages
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:
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:
189: COMMIT;
190:
191: exception
192: when others then
193: CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE',SQLERRM);
194: end;
195:
196: ---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
197: -----@Propagate_deleted_flag_for_global_entities
350: BEGIN
351: jdr_docbuilder.deleteDocument(l_gl_jrad_docs_tbl(i));
352: EXCEPTION
353: WHEN OTHERS THEN
354: CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE','deleteDocument "'||l_gl_jrad_docs_tbl(i)||'" : '||SQLERRM);
355: END;
356: END LOOP;
357: END IF;
358:
381: END IF;
382: COMMIT;
383: exception
384: when others then
385: CZ_BASE_MGR.LOG_REPORT('CZ_UI_MGR.PURGE',SQLERRM);
386: end;
387:
388:
389: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
392: procedure PURGE is
393: begin
394: Propogate_DeletedFlag;
395: Propagate_del_flag_gl_entities;
396: CZ_BASE_MGR.PURGE('UI');
397: end;
398:
399: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
400: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
409:
410: procedure MODIFIED
411: (AS_OF in OUT NOCOPY date) is
412: begin
413: CZ_BASE_MGR.MODIFIED('UI',AS_OF);
414: end;
415:
416: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
417: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/