eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UI_MGR dependencies on CZ_UI_TEMPLATES

Line 133: update cz_ui_templates

129: set deleted_flag='1'
130: where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';
131: commit;
132:
133: update cz_ui_templates
134: set deleted_flag='1'
135: where ui_def_id=v_ui and NVL(seeded_flag,'0')='0';
136: commit;
137:

Line 210: TYPE global_jrad_docs_tbl IS TABLE OF CZ_UI_TEMPLATES.jrad_doc%TYPE INDEX BY BINARY_INTEGER;

206: PROCEDURE Propagate_del_flag_gl_entities
207: IS
208:
209: TYPE global_templates_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
210: TYPE global_jrad_docs_tbl IS TABLE OF CZ_UI_TEMPLATES.jrad_doc%TYPE INDEX BY BINARY_INTEGER;
211: l_gl_template_tbl global_templates_tbl;
212: l_pb_gl_template_tbl global_templates_tbl;
213: l_gl_jrad_docs_tbl global_jrad_docs_tbl;
214: l_pb_gl_jrad_docs_tbl global_jrad_docs_tbl;

Line 228: ------collect source global templates from cz_ui_templates

224: l_msg_data VARCHAR2(2000);
225:
226: BEGIN
227:
228: ------collect source global templates from cz_ui_templates
229: ------where ui_def_id = 0 and deleted_flag = '1' and seeded_flag = '0'
230: l_gl_template_tbl.DELETE;
231: SELECT template_id, jrad_doc
232: BULK

Line 235: FROM cz_ui_templates

231: SELECT template_id, jrad_doc
232: BULK
233: COLLECT
234: INTO l_gl_template_tbl, l_gl_jrad_docs_tbl
235: FROM cz_ui_templates
236: WHERE cz_ui_templates.deleted_flag = '1'
237: AND cz_ui_templates.seeded_flag = '0'
238: AND cz_ui_templates.ui_def_id = 0;
239:

Line 236: WHERE cz_ui_templates.deleted_flag = '1'

232: BULK
233: COLLECT
234: INTO l_gl_template_tbl, l_gl_jrad_docs_tbl
235: FROM cz_ui_templates
236: WHERE cz_ui_templates.deleted_flag = '1'
237: AND cz_ui_templates.seeded_flag = '0'
238: AND cz_ui_templates.ui_def_id = 0;
239:
240: -----collect published global templates that are candidates

Line 237: AND cz_ui_templates.seeded_flag = '0'

233: COLLECT
234: INTO l_gl_template_tbl, l_gl_jrad_docs_tbl
235: FROM cz_ui_templates
236: WHERE cz_ui_templates.deleted_flag = '1'
237: AND cz_ui_templates.seeded_flag = '0'
238: AND cz_ui_templates.ui_def_id = 0;
239:
240: -----collect published global templates that are candidates
241: -----for deletion.

Line 238: AND cz_ui_templates.ui_def_id = 0;

234: INTO l_gl_template_tbl, l_gl_jrad_docs_tbl
235: FROM cz_ui_templates
236: WHERE cz_ui_templates.deleted_flag = '1'
237: AND cz_ui_templates.seeded_flag = '0'
238: AND cz_ui_templates.ui_def_id = 0;
239:
240: -----collect published global templates that are candidates
241: -----for deletion.
242: -----The published global templates that are candidates for

Line 251: FROM cz_ui_templates

247:
248: l_pb_gl_template_tbl.DELETE;
249: SELECT template_id BULK COLLECT
250: INTO l_pb_gl_template_tbl
251: FROM cz_ui_templates
252: WHERE cz_ui_templates.seeded_flag = '0'
253: AND cz_ui_templates.ui_def_id = 1
254: AND cz_ui_templates.template_id NOT IN (SELECT object_id
255: FROM cz_model_publications

Line 252: WHERE cz_ui_templates.seeded_flag = '0'

248: l_pb_gl_template_tbl.DELETE;
249: SELECT template_id BULK COLLECT
250: INTO l_pb_gl_template_tbl
251: FROM cz_ui_templates
252: WHERE cz_ui_templates.seeded_flag = '0'
253: AND cz_ui_templates.ui_def_id = 1
254: AND cz_ui_templates.template_id NOT IN (SELECT object_id
255: FROM cz_model_publications
256: WHERE object_type = 'UIT'

Line 253: AND cz_ui_templates.ui_def_id = 1

249: SELECT template_id BULK COLLECT
250: INTO l_pb_gl_template_tbl
251: FROM cz_ui_templates
252: WHERE cz_ui_templates.seeded_flag = '0'
253: AND cz_ui_templates.ui_def_id = 1
254: AND cz_ui_templates.template_id NOT IN (SELECT object_id
255: FROM cz_model_publications
256: WHERE object_type = 'UIT'
257: AND deleted_flag = '0'

Line 254: AND cz_ui_templates.template_id NOT IN (SELECT object_id

250: INTO l_pb_gl_template_tbl
251: FROM cz_ui_templates
252: WHERE cz_ui_templates.seeded_flag = '0'
253: AND cz_ui_templates.ui_def_id = 1
254: AND cz_ui_templates.template_id NOT IN (SELECT object_id
255: FROM cz_model_publications
256: WHERE object_type = 'UIT'
257: AND deleted_flag = '0'
258: AND ui_def_id = 1

Line 275: FROM cz_ui_templates t0

271:
272: -----collect published template jrad docs that are candidates for deletion and
273: -----are not part of valid publication
274: SELECT jrad_doc BULK COLLECT INTO l_pb_gl_jrad_docs_tbl
275: FROM cz_ui_templates t0
276: WHERE t0.seeded_flag = '0'
277: AND t0.ui_def_id = 1
278: AND NOT EXISTS (SELECT 1 FROM cz_model_publications
279: WHERE object_type = 'UIT'

Line 284: AND NOT EXISTS (SELECT 1 FROM cz_ui_templates t

280: AND deleted_flag = '0'
281: AND ui_def_id = 1
282: AND source_target_flag = 'T'
283: AND object_id = t0.template_id)
284: AND NOT EXISTS (SELECT 1 FROM cz_ui_templates t
285: WHERE t.seeded_flag = '0'
286: AND t.ui_def_id = 1
287: AND EXISTS (SELECT 1 FROM cz_model_publications
288: WHERE object_type = 'UIT'