APPS.CZ_UI_MGR dependencies on CZ_UI_PAGES

Line 158: for k in(select jrad_doc from cz_ui_pages

154:
155: --
156: -- drop jrad documents which associated with deleted pages
157: --
158: for k in(select jrad_doc from cz_ui_pages
159: where ui_def_id=v_ui and NVL(seeded_flag,'0')='0' and deleted_flag='0')
160: loop
161: begin
162: jdr_docbuilder.deleteDocument(k.jrad_doc);

Line 169: update cz_ui_pages

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
170: set deleted_flag='1'
171: where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';
172: commit;
173: