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 CZ_UI_PAGE_REFS_S

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 1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN

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

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 10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

10790: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10791: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10792: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10793: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10795: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10796: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10797: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10798: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;

Line 11092: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

11088:
11089: --
11090: -- create a new record for this UI page in CZ_UI_PAGE_REFS
11091: --
11092: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
11093:
11094: l_ref_pagebase_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
11095:
11096: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN

Line 11601: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

11597:
11598: --
11599: -- create a new record for this UI page in CZ_UI_PAGE_REFS
11600: --
11601: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
11602:
11603: IF l_target_ui_def_node.start_page_id=-1 THEN
11604:
11605: SELECT MIN(page_id) INTO l_target_ui_def_node.start_page_id

Line 12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

12026: PROCEDURE delete_UI_Page(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12027:
12028: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

Line 13188: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

13184: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13185: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;
13186: l_page_id CZ_UI_PAGES.page_id%TYPE;
13187: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
13188: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
13189: l_caption_text_id NUMBER;
13190: l_caption CZ_INTL_TEXTS.text_str%TYPE;
13191:
13192: BEGIN

Line 13366: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

13362: deleted_flag=G_NO_FLAG;
13363:
13364: l_seq_nbr := l_seq_nbr + 1;
13365:
13366: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
13367: INSERT INTO CZ_UI_PAGE_REFS
13368: (ui_def_id,
13369: page_set_id,
13370: page_ref_id,

Line 13795: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

13791: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13792: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13793: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;
13794:
13795: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
13796:
13797: INSERT INTO CZ_UI_PAGE_REFS
13798: (ui_def_id,
13799: page_set_id,

Line 21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

21675: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
21676: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
21677: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
21678: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
21680: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;
21681: l_ref_parent_persist_node_id NUMBER;
21682: l_ref_ps_node_id NUMBER;
21683: l_ref_parent_id NUMBER;

Line 21756: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');

21752: deleted_flag=G_NO_FLAG;
21753:
21754: IF SQL%ROWCOUNT=0 THEN
21755:
21756: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
21757:
21758: l_ref_pagebase_path := get_Page_Path(l_ref_ps_node_id, i.page_set_id);
21759:
21760: SELECT NVL(MAX(seq_nbr),0)+1 INTO l_seq_nbr

Line 21926: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);

21922: INDUSTRY => l_industry,
21923: ORACLE_SCHEMA => l_oracle_schema);
21924:
21925: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
21926: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
21927: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
21930: