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_MODEL_CONVERT dependencies on CZ_UI_CONT_TYPE_TEMPLS

Line 231: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS

227: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
228: WHERE ui_style='7' AND seeded_flag='0' AND deleted_flag='0' and devl_project_id=p_devl_project_id)
229: LOOP
230: FORALL j IN 1..l_cont_types_tbl.COUNT
231: INSERT INTO CZ_UI_CONT_TYPE_TEMPLS
232: (
233: UI_DEF_ID
234: ,CONTENT_TYPE
235: ,TEMPLATE_ID

Line 253: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS

249: ,'0'
250: ,'0'
251: FROM dual
252: WHERE NOT EXISTS
253: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS
254: WHERE ui_def_id=i.ui_def_id AND content_type=l_cont_types_tbl(j));
255: END LOOP;
256:
257:

Line 259: -- Get the cz_ui_cont_type_templs.template_Id for content_type 543

255: END LOOP;
256:
257:
258:
259: -- Get the cz_ui_cont_type_templs.template_Id for content_type 543
260: -- Create two records with template_id from i) and content_types 560 and 561
261: -- Delete the record with content_type 543
262: FOR c_ct IN(SELECT c.*
263: FROM cz_ui_defs ui,

Line 264: cz_ui_cont_type_templs c

260: -- Create two records with template_id from i) and content_types 560 and 561
261: -- Delete the record with content_type 543
262: FOR c_ct IN(SELECT c.*
263: FROM cz_ui_defs ui,
264: cz_ui_cont_type_templs c
265: WHERE ui.deleted_flag = '0'
266: AND ui.devl_project_id = p_devl_project_id
267: AND c.ui_def_id = ui.ui_def_id
268: AND c.deleted_flag = '0'

Line 272: FROM cz_ui_cont_type_templs

268: AND c.deleted_flag = '0'
269: AND content_type = 543
270: AND NOT EXISTS
271: (SELECT 1
272: FROM cz_ui_cont_type_templs
273: WHERE ui_def_id = ui.ui_def_id
274: AND content_type =560)) LOOP
275: INSERT INTO cz_ui_cont_type_templs (UI_DEF_ID,CONTENT_TYPE,TEMPLATE_ID,DELETED_FLAG,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
276: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,MASTER_TEMPLATE_FLAG,SEEDED_FLAG,TEMPLATE_UI_DEF_ID,WRAP_TEMPLATE_FLAG)

Line 275: INSERT INTO cz_ui_cont_type_templs (UI_DEF_ID,CONTENT_TYPE,TEMPLATE_ID,DELETED_FLAG,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,

271: (SELECT 1
272: FROM cz_ui_cont_type_templs
273: WHERE ui_def_id = ui.ui_def_id
274: AND content_type =560)) LOOP
275: INSERT INTO cz_ui_cont_type_templs (UI_DEF_ID,CONTENT_TYPE,TEMPLATE_ID,DELETED_FLAG,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
276: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,MASTER_TEMPLATE_FLAG,SEEDED_FLAG,TEMPLATE_UI_DEF_ID,WRAP_TEMPLATE_FLAG)
277: VALUES
278: (
279: c_ct.UI_DEF_ID,560,c_ct.TEMPLATE_ID,c_ct.DELETED_FLAG,c_ct.CREATED_BY,c_ct.CREATION_DATE,c_ct.LAST_UPDATED_BY,

Line 285: UPDATE cz_ui_cont_type_templs uiout set content_type=561

281: );
282:
283: END LOOP;
284:
285: UPDATE cz_ui_cont_type_templs uiout set content_type=561
286: WHERE
287: ui_def_id IN (select ui.ui_def_id from cz_ui_defs ui WHERE ui.deleted_flag = '0' AND ui.devl_project_id = p_devl_project_id)
288: AND deleted_flag = '0'
289: AND content_type = 543

Line 291: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS

287: ui_def_id IN (select ui.ui_def_id from cz_ui_defs ui WHERE ui.deleted_flag = '0' AND ui.devl_project_id = p_devl_project_id)
288: AND deleted_flag = '0'
289: AND content_type = 543
290: AND NOT EXISTS
291: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS
292: WHERE ui_def_id=uiout.ui_def_id AND content_type=561) ;
293:
294: EXCEPTION WHEN OTHERS THEN
295: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);

Line 390: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text , cz_ui_template_elements te ,cz_ui_defs ui

386: 'NodeUnsatisfied' lceprop,
387: 'UserInputRequired' fceprop,
388: te.element_id ,
389: te.element_type
390: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text , cz_ui_template_elements te ,cz_ui_defs ui
391: WHERE c.ui_def_id = ui.ui_def_id
392: AND c.template_id = t.template_id
393: AND c.content_type = s.signature_id
394: AND c.deleted_flag = '0'

Line 417: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text, cz_ui_template_elements te , cz_ui_defs ui

413: 'Unsatisfied' lceprop,
414: 'UserInputRequired' fceprop,
415: te.element_id ,
416: te.element_type
417: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text, cz_ui_template_elements te , cz_ui_defs ui
418: WHERE c.ui_def_id = ui.ui_def_id
419: AND c.template_id = t.template_id
420: AND c.content_type = s.signature_id
421: AND c.deleted_flag = '0'

Line 444: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text, cz_ui_template_elements te , cz_ui_defs ui

440: 'SubtreeUnsatisfied' lceprop,
441: 'UserInputRequiredInSubtree' fceprop,
442: te.element_id ,
443: te.element_type
444: FROM cz_ui_cont_type_templs c, cz_ui_templates t , cz_signatures s ,cz_intl_texts text, cz_ui_template_elements te , cz_ui_defs ui
445: WHERE c.ui_def_id = ui.ui_def_id
446: AND c.template_id = t.template_id
447: AND c.content_type = s.signature_id
448: AND c.deleted_flag = '0'

Line 492: cz_ui_cont_type_templs ct,

488: tempel.element_type
489: FROM cz_expression_nodes ex,
490: cz_rules ru,
491: cz_ui_defs ui ,
492: cz_ui_cont_type_templs ct,
493: cz_ui_defs ui2,
494: cz_ui_templates te ,cz_ui_template_elements tempel
495: WHERE ex.template_id IN(820, 836, 849)
496: AND ex.deleted_flag = '0'