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_DEFS

Line 227: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS

223: l_msg VARCHAR2(2000);
224: l_api_name constant VARCHAR2(30) := 'UPG_UI_CONT_TYPE_TMPLS';
225: BEGIN
226:
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

Line 263: FROM cz_ui_defs ui,

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

Line 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)

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
290: AND NOT EXISTS
291: (SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS

Line 336: UPDATE cz_ui_defs SET deleted_flag='1' WHERE ui_style = 0

332:
333:
334: --DHTML UI's will not be supported in fusion .Mark these as deleted
335:
336: UPDATE cz_ui_defs SET deleted_flag='1' WHERE ui_style = 0
337: AND deleted_flag ='0'
338: AND devl_project_id =p_dev_project_id
339: RETURNING ui_def_id BULK COLLECT INTO v_cz_ids_tbl;
340:

Line 353: cz_ui_defs ui

349: --As Functional Companions are not supported in FCE models, Model Conversion should warn on detecting them.
350: --Bug 6489541
351: FOR v_ui IN(SELECT DISTINCT a.ui_def_id
352: FROM cz_ui_nodes a,
353: cz_ui_defs ui
354: WHERE a.deleted_flag = '0'
355: AND ui.deleted_flag = '0'
356: AND a.ui_def_id = ui.ui_def_id
357: AND ui.devl_project_id = p_dev_project_id

Line 368: FROM cz_ui_defs ui

364: --Display message "UI will use the default Icons, Message Templates, and Utility Templates for functions specific to Fusion Engine. These can be overridden in the UI Definition."
365:
366: FOR v_ui IN
367: (SELECT ui.ui_def_id
368: FROM cz_ui_defs ui
369: WHERE ui.deleted_flag ='0'
370: AND ui.devl_project_id = p_dev_project_id)
371: LOOP
372:

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 491: cz_ui_defs ui ,

487: ru.ui_page_element_id,
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)

Line 493: cz_ui_defs ui2,

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'
497: AND ex.rule_id = ru.rule_id

Line 536: FROM cz_intl_texts,cz_ui_defs

532: SELECT text_str,
533: cz_intl_texts.ui_def_id,
534: 'NodeUnsatisfied' lceprop,
535: 'UserInputRequired' fceprop
536: FROM cz_intl_texts,cz_ui_defs
537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
538: AND model_id = p_dev_project_id
539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
540: AND cz_ui_defs.devl_project_id=p_dev_project_id

Line 539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id

535: 'UserInputRequired' fceprop
536: FROM cz_intl_texts,cz_ui_defs
537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
538: AND model_id = p_dev_project_id
539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
540: AND cz_ui_defs.devl_project_id=p_dev_project_id
541: AND cz_ui_defs.deleted_flag='0'
542:
543: UNION ALL

Line 540: AND cz_ui_defs.devl_project_id=p_dev_project_id

536: FROM cz_intl_texts,cz_ui_defs
537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
538: AND model_id = p_dev_project_id
539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
540: AND cz_ui_defs.devl_project_id=p_dev_project_id
541: AND cz_ui_defs.deleted_flag='0'
542:
543: UNION ALL
544: SELECT text_str,

Line 541: AND cz_ui_defs.deleted_flag='0'

537: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'NODEUNSATISFIED%'
538: AND model_id = p_dev_project_id
539: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
540: AND cz_ui_defs.devl_project_id=p_dev_project_id
541: AND cz_ui_defs.deleted_flag='0'
542:
543: UNION ALL
544: SELECT text_str,
545: cz_intl_texts.ui_def_id,

Line 548: FROM cz_intl_texts,cz_ui_defs

544: SELECT text_str,
545: cz_intl_texts.ui_def_id,
546: 'Unsatisfied' lceprop,
547: 'UserInputRequired' fceprop
548: FROM cz_intl_texts,cz_ui_defs
549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
550: AND model_id = p_dev_project_id
551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
552: AND cz_ui_defs.devl_project_id=p_dev_project_id

Line 551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id

547: 'UserInputRequired' fceprop
548: FROM cz_intl_texts,cz_ui_defs
549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
550: AND model_id = p_dev_project_id
551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
552: AND cz_ui_defs.devl_project_id=p_dev_project_id
553: AND cz_ui_defs.deleted_flag='0'
554:
555: UNION ALL

Line 552: AND cz_ui_defs.devl_project_id=p_dev_project_id

548: FROM cz_intl_texts,cz_ui_defs
549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
550: AND model_id = p_dev_project_id
551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
552: AND cz_ui_defs.devl_project_id=p_dev_project_id
553: AND cz_ui_defs.deleted_flag='0'
554:
555: UNION ALL
556: SELECT text_str,

Line 553: AND cz_ui_defs.deleted_flag='0'

549: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'UNSATISFIED%'
550: AND model_id = p_dev_project_id
551: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
552: AND cz_ui_defs.devl_project_id=p_dev_project_id
553: AND cz_ui_defs.deleted_flag='0'
554:
555: UNION ALL
556: SELECT text_str,
557: cz_intl_texts.ui_def_id,

Line 560: FROM cz_intl_texts,cz_ui_defs

556: SELECT text_str,
557: cz_intl_texts.ui_def_id,
558: 'SubtreeUnsatisfied' lceprop,
559: 'UserInputRequiredInSubtree' fceprop
560: FROM cz_intl_texts,cz_ui_defs
561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
562: AND model_id = p_dev_project_id
563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
564: AND cz_ui_defs.devl_project_id=p_dev_project_id

Line 563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id

559: 'UserInputRequiredInSubtree' fceprop
560: FROM cz_intl_texts,cz_ui_defs
561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
562: AND model_id = p_dev_project_id
563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
564: AND cz_ui_defs.devl_project_id=p_dev_project_id
565: AND cz_ui_defs.deleted_flag='0'
566:
567: )

Line 564: AND cz_ui_defs.devl_project_id=p_dev_project_id

560: FROM cz_intl_texts,cz_ui_defs
561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
562: AND model_id = p_dev_project_id
563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
564: AND cz_ui_defs.devl_project_id=p_dev_project_id
565: AND cz_ui_defs.deleted_flag='0'
566:
567: )
568: LOOP

Line 565: AND cz_ui_defs.deleted_flag='0'

561: WHERE UPPER(text_str) LIKE '%'||fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%'
562: AND model_id = p_dev_project_id
563: AND cz_intl_texts.ui_def_id=cz_ui_defs.ui_def_id
564: AND cz_ui_defs.devl_project_id=p_dev_project_id
565: AND cz_ui_defs.deleted_flag='0'
566:
567: )
568: LOOP
569: --Refer TD section 4.1.5.2

Line 586: AND ui_def_id IN ( SELECT ui_def_id FROM cz_ui_defs

582: set localized_str=REPLACE(REPLACE(REPLACE(localized_str,fnd_global.local_chr(38)||'NODEUNSATISFIED',fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'UNSATISFIED%'
583: ,fnd_global.local_chr(38)||'USERINPUTREQUIRED'),fnd_global.local_chr(38)||'SUBTREEUNSATISFIED%',fnd_global.local_chr(38)||'USERINPUTREQUIREDINSUBTREE')
584: WHERE UPPER(localized_str) LIKE '%'||fnd_global.local_chr(38)||'%UNSATISFIED%'
585: AND model_id = p_dev_project_id
586: AND ui_def_id IN ( SELECT ui_def_id FROM cz_ui_defs
587: WHERE deleted_flag='0' AND cz_localized_texts.ui_def_id = ui_def_id
588: AND devl_project_id=p_dev_project_id
589: )
590: AND deleted_flag='0';

Line 599: cz_ui_defs ui

595: (SELECT DISTINCT template_id , decode(template_id,820,'NodeUnsatisfied' ,836,'Unsatisfied',849,'SubtreeUnsatisfied') lceprop ,
596: decode(template_id,820,'InputRequired' ,836,'InputRequired',849,'InputRequiredInSubtree') fceprop,ru.name ,ui.ui_def_id, ru.ui_page_element_id
597: FROM cz_expression_nodes ex,
598: cz_rules ru,
599: cz_ui_defs ui
600: WHERE template_id IN(820, 836, 849)
601: AND ex.deleted_flag ='0'
602: AND ex.rule_id = ru.rule_id
603: AND ru.deleted_flag ='0'

Line 644: cz_ui_defs ui

640: (SELECT template_id , (select name from cz_rules where rule_id=template_id) name , REPLACE(REPLACE((select 'Definition'||name from cz_rules where rule_id=template_id),'DefinitionMaxSelected','DefinitionMaxSelections')
641: ,'DefinitionMinSelected','DefinitionMinSelections') ruleName,ui.ui_def_id , ru.ui_page_element_id
642: FROM cz_expression_nodes ex,
643: cz_rules ru,
644: cz_ui_defs ui
645: WHERE template_id IN (894,818,812,847,893,817,811,846,813,814,815,816)
646: AND ex.deleted_flag ='0'
647: AND ex.rule_id = ru.rule_id
648: AND ru.deleted_flag ='0'

Line 667: cz_ui_defs ui

663: (
664: SELECT ex.expr_node_id
665: FROM cz_expression_nodes ex,
666: cz_rules ru,
667: cz_ui_defs ui
668: WHERE template_id IN (894,818,812,847,893,817,811,846,813,814,815,816)
669: AND ex.deleted_flag ='0'
670: AND ex.rule_id = ru.rule_id
671: AND ru.deleted_flag ='0'

Line 683: from cz_intl_texts intl, cz_ui_defs ui , cz_rules ru where

679:
680:
681: FOR v_ui IN
682: (select intl.ui_def_id , ru.name lceprop , REPLACE(REPLACE('Definition'||ru.name ,'DefinitionMaxSelected','DefinitionMaxSelections'),'DefinitionMinSelected','DefinitionMinSelections') fceprop, intl.ui_page_element_id
683: from cz_intl_texts intl, cz_ui_defs ui , cz_rules ru where
684: ru.rule_id in (894,818,812,893,817,811,813,814,815,816)
685: and text_str like '%'||fnd_global.local_chr(38)||upper(ru.name)||'%'
686: and intl.ui_def_id = ui.ui_def_id
687: and intl.deleted_flag='0'

Line 701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )

697:
698:
699: UPDATE cz_localized_texts intl SET localized_str = REPLACE(REPLACE(REPLACE(REPLACE(localized_str , ' '||fnd_global.local_chr(38)||'MIN' , ' '||fnd_global.local_chr(38)||'DEFINITIONMIN')
700: ,' '||fnd_global.local_chr(38)||'MAX' , ' '||fnd_global.local_chr(38)||'DEFINITIONMAX'),'DEFINITIONMAXSELECTED','DEFINITIONMAXSELECTIONS'),'DEFINITIONMINSELECTED','DEFINITIONMINSELECTIONS')
701: WHERE ui_def_id IN(select ui_def_id from cz_ui_defs WHERE deleted_flag='0' AND devl_project_id= p_dev_project_id )
702: AND model_id = p_dev_project_id
703: AND EXISTS (
704: SELECT 1 FROM cz_rules WHERE rule_id IN (894,818,812,893,817,811,813,814,815,816)
705: AND localized_str LIKE '%'||fnd_global.local_chr(38)||upper(name)||'%' )

Line 2478: select name INTO l_qualified from cz_ui_defs where ui_def_id = (select max(ui_def_id) from cz_ui_page_elements where element_id = to_char(inParent_id));

2474: l_qualified VARCHAR2(2000) := ' ';
2475: BEGIN
2476:
2477: IF inParent_id IS NOT NULL THEN
2478: select name INTO l_qualified from cz_ui_defs where ui_def_id = (select max(ui_def_id) from cz_ui_page_elements where element_id = to_char(inParent_id));
2479: l_qualified:=l_qualified||'.Pages';
2480: FOR parent_node IN (SELECT distinct(name) , element_id FROM cz_ui_page_elements
2481: WHERE deleted_flag = '0'
2482: START WITH element_id = to_char(inParent_id)