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_UIOA_PVT dependencies on DUAL

Line 726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;

722: --
723: PROCEDURE Initialize_Sequences IS
724: BEGIN
725:
726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
727: g_currUISeqVal := g_currentUINode;
728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;

Line 729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;

725:
726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
727: g_currUISeqVal := g_currentUINode;
728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;
731:
732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
733: g_currPageSeqVal := g_currentPage;

Line 732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;

728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;
731:
732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
733: g_currPageSeqVal := g_currentPage;
734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;

Line 735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;

731:
732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
733: g_currPageSeqVal := g_currentPage;
734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;
737:
738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
739: g_currUIActionSeqVal := g_currentUIAction;

Line 738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;

734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;
737:
738: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
739: g_currUIActionSeqVal := g_currentUIAction;
740:
741: END Initialize_Sequences;
742:

Line 1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;

1018: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1019: IF g_currentUINode 1020: g_currentUINode := g_currentUINode+1;
1021: ELSE
1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1023: g_currentUINode := g_currUISeqVal;
1024: END IF;
1025: RETURN g_currentUINode;
1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN

Line 1030: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;

1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1027: IF g_currentPageRef 1028: g_currentPageRef := g_currentPageRef+1;
1029: ELSE
1030: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;
1031: g_currentPageRef := g_currPageRefSeqVal;
1032: END IF;
1033: RETURN g_currentPageRef;
1034: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN

Line 1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;

1034: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN
1035: IF g_currentPage 1036: g_currentPage := g_currentPage+1;
1037: ELSE
1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1039: g_currentPage := g_currPageSeqVal;
1040: END IF;
1041: RETURN g_currentPage;
1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

Line 1046: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;

1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1043: IF g_currentPageSet 1044: g_currentPageSet := g_currentPageSet+1;
1045: ELSE
1046: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1047: g_currentPageSet := g_currPageSetSeqVal;
1048: END IF;
1049: RETURN g_currentPageSet;
1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

Line 1054: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;

1050: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1051: IF g_currentUIAction 1052: g_currentUIAction := g_currentUIAction+1;
1053: ELSE
1054: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;
1055: g_currentUIAction := g_currUIActionSeqVal;
1056: END IF;
1057: RETURN g_currentUIAction;
1058: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

Line 1062: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;

1058: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN
1059: IF g_currentIntlText 1060: g_currentIntlText := g_currentIntlText+1;
1061: ELSE
1062: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;
1063: g_currentIntlText := g_currIntlTextSeqVal;
1064: END IF;
1065: RETURN g_currentIntlText;
1066: ELSE

Line 1067: EXECUTE IMMEDIATE 'SELECT ' || p_sequence_name || '.NEXTVAL FROM dual' INTO l_id;

1063: g_currentIntlText := g_currIntlTextSeqVal;
1064: END IF;
1065: RETURN g_currentIntlText;
1066: ELSE
1067: EXECUTE IMMEDIATE 'SELECT ' || p_sequence_name || '.NEXTVAL FROM dual' INTO l_id;
1068: RETURN l_id;
1069: END IF;
1070:
1071: EXCEPTION

Line 10043: FROM DUAL

10039: l_dummy VARCHAR2(1);
10040: BEGIN
10041:
10042: SELECT '1' INTO l_dummy
10043: FROM DUAL
10044: WHERE '1' IN (SELECT suppress_refresh_flag
10045: FROM cz_ui_page_elements
10046: START WITH ui_def_Id = p_page_element.ui_def_id
10047: AND page_id = p_page_element.page_id

Line 10154: SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual

10150: RETURN l_ui_node;
10151: END IF;
10152:
10153: BEGIN
10154: SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual
10155: WHERE EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
10156: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10157: page_id=p_parent_ui_node.page_id AND
10158: parent_element_id=p_parent_ui_node.element_id AND

Line 14212: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

14208: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES
14209: WHERE page_id=p_parent_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
14210:
14211: IF px_page_split_seq_nbr=1 THEN
14212: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
14213: WHERE EXISTS
14214: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
14215: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
14216: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND

Line 14221: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

14217: split_seq_nbr>1 AND deleted_flag NOT IN(G_YES_FLAG)) AND
14218: persistent_node_id=p_current_model_node.persistent_node_id AND
14219: deleted_flag NOT IN(G_YES_FLAG));
14220: ELSIF px_page_split_seq_nbr>1 THEN
14221: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
14222: WHERE EXISTS
14223: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
14224: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
14225: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND