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 720: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;

716: --
717: PROCEDURE Initialize_Sequences IS
718: BEGIN
719:
720: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
721: g_currUISeqVal := g_currentUINode;
722:
723: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
724: g_currPageRefSeqVal := g_currentPageRef;

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

719:
720: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
721: g_currUISeqVal := g_currentUINode;
722:
723: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
724: g_currPageRefSeqVal := g_currentPageRef;
725:
726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
727: g_currPageSeqVal := g_currentPage;

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

722:
723: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
724: g_currPageRefSeqVal := g_currentPageRef;
725:
726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
727: g_currPageSeqVal := g_currentPage;
728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;

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

725:
726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
727: g_currPageSeqVal := g_currentPage;
728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;
731:
732: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
733: g_currUIActionSeqVal := g_currentUIAction;

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

728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;
731:
732: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currentUIAction FROM dual;
733: g_currUIActionSeqVal := g_currentUIAction;
734:
735: END Initialize_Sequences;
736:

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

1012: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1013: IF g_currentUINode 1014: g_currentUINode := g_currentUINode+1;
1015: ELSE
1016: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1017: g_currentUINode := g_currUISeqVal;
1018: END IF;
1019: RETURN g_currentUINode;
1020: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN

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

1020: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1021: IF g_currentPageRef 1022: g_currentPageRef := g_currentPageRef+1;
1023: ELSE
1024: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;
1025: g_currentPageRef := g_currPageRefSeqVal;
1026: END IF;
1027: RETURN g_currentPageRef;
1028: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN

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

1028: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN
1029: IF g_currentPage 1030: g_currentPage := g_currentPage+1;
1031: ELSE
1032: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1033: g_currentPage := g_currPageSeqVal;
1034: END IF;
1035: RETURN g_currentPage;
1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

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

1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN
1037: IF g_currentPageSet 1038: g_currentPageSet := g_currentPageSet+1;
1039: ELSE
1040: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currPageSetSeqVal FROM dual;
1041: g_currentPageSet := g_currPageSetSeqVal;
1042: END IF;
1043: RETURN g_currentPageSet;
1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN

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

1044: ELSIF p_sequence_name='CZ_UI_ACTIONS_S' THEN
1045: IF g_currentUIAction 1046: g_currentUIAction := g_currentUIAction+1;
1047: ELSE
1048: SELECT CZ_UI_ACTIONS_S.nextval INTO g_currUIActionSeqVal FROM dual;
1049: g_currentUIAction := g_currUIActionSeqVal;
1050: END IF;
1051: RETURN g_currentUIAction;
1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN

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

1052: ELSIF p_sequence_name='CZ_INTL_TEXTS_S' THEN
1053: IF g_currentIntlText 1054: g_currentIntlText := g_currentIntlText+1;
1055: ELSE
1056: SELECT CZ_INTL_TEXTS_S.nextval INTO g_currIntlTextSeqVal FROM dual;
1057: g_currentIntlText := g_currIntlTextSeqVal;
1058: END IF;
1059: RETURN g_currentIntlText;
1060: ELSE

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

1057: g_currentIntlText := g_currIntlTextSeqVal;
1058: END IF;
1059: RETURN g_currentIntlText;
1060: ELSE
1061: EXECUTE IMMEDIATE 'SELECT ' || p_sequence_name || '.NEXTVAL FROM dual' INTO l_id;
1062: RETURN l_id;
1063: END IF;
1064:
1065: EXCEPTION

Line 9569: FROM DUAL

9565: l_dummy VARCHAR2(1);
9566: BEGIN
9567:
9568: SELECT '1' INTO l_dummy
9569: FROM DUAL
9570: WHERE '1' IN (SELECT suppress_refresh_flag
9571: FROM cz_ui_page_elements
9572: START WITH ui_def_Id = p_page_element.ui_def_id
9573: AND page_id = p_page_element.page_id

Line 9680: SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual

9676: RETURN l_ui_node;
9677: END IF;
9678:
9679: BEGIN
9680: SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual
9681: WHERE EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
9682: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9683: page_id=p_parent_ui_node.page_id AND
9684: parent_element_id=p_parent_ui_node.element_id AND

Line 13728: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

13724: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES
13725: WHERE page_id=p_parent_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
13726:
13727: IF px_page_split_seq_nbr=1 THEN
13728: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
13729: WHERE EXISTS
13730: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13731: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
13732: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND

Line 13737: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

13733: split_seq_nbr>1 AND deleted_flag NOT IN(G_YES_FLAG)) AND
13734: persistent_node_id=p_current_model_node.persistent_node_id AND
13735: deleted_flag NOT IN(G_YES_FLAG));
13736: ELSIF px_page_split_seq_nbr>1 THEN
13737: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
13738: WHERE EXISTS
13739: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13740: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
13741: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND