DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_INTL_TEXTS

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 533: cz_intl_texts.ui_def_id,

529:
530: FOR v_ui IN
531: (
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%'

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 545: cz_intl_texts.ui_def_id,

541: AND cz_ui_defs.deleted_flag='0'
542:
543: UNION ALL
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%'

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 557: cz_intl_texts.ui_def_id,

553: AND cz_ui_defs.deleted_flag='0'
554:
555: UNION ALL
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%'

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 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 798: -- kdande; 10-Jan-2008; Bug 6730553; Changed cz_localized_texts_s to cz_intl_texts_s as cz_localized_texts_s is obsolete.

794: BEGIN
795:
796: l_rule_id:=next_rule_id;
797:
798: -- kdande; 10-Jan-2008; Bug 6730553; Changed cz_localized_texts_s to cz_intl_texts_s as cz_localized_texts_s is obsolete.
799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;
800:
801: SELECT name , nvl(initial_value, initial_num_value ) INTO l_ps_node_name , initialvalue from cz_ps_nodes where ps_node_id=p_ps_node_id;
802:

Line 799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;

795:
796: l_rule_id:=next_rule_id;
797:
798: -- kdande; 10-Jan-2008; Bug 6730553; Changed cz_localized_texts_s to cz_intl_texts_s as cz_localized_texts_s is obsolete.
799: SELECT cz_intl_texts_s.nextval INTO l_intl_text_id FROM Dual ;
800:
801: SELECT name , nvl(initial_value, initial_num_value ) INTO l_ps_node_name , initialvalue from cz_ps_nodes where ps_node_id=p_ps_node_id;
802:
803: -- INSERTING into cz_rules