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

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

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

10311: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10312: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10313: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10314: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10315: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10316: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10317: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10318: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10319: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;

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

10609:
10610: --
10611: -- create a new record for this UI page in CZ_UI_PAGE_REFS
10612: --
10613: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
10614:
10615: l_ref_pagebase_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
10616:
10617: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN

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

11118:
11119: --
11120: -- create a new record for this UI page in CZ_UI_PAGE_REFS
11121: --
11122: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
11123:
11124: IF l_target_ui_def_node.start_page_id=-1 THEN
11125:
11126: SELECT MIN(page_id) INTO l_target_ui_def_node.start_page_id

Line 11551: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

11547: PROCEDURE delete_UI_Page(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11548:
11549: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
11550: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11551: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
11552: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
11553: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
11554: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
11555: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

Line 12704: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

12700: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12701: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;
12702: l_page_id CZ_UI_PAGES.page_id%TYPE;
12703: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12704: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12705: l_caption_text_id NUMBER;
12706: l_caption CZ_INTL_TEXTS.text_str%TYPE;
12707:
12708: BEGIN

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

12878: deleted_flag=G_NO_FLAG;
12879:
12880: l_seq_nbr := l_seq_nbr + 1;
12881:
12882: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
12883: INSERT INTO CZ_UI_PAGE_REFS
12884: (ui_def_id,
12885: page_set_id,
12886: page_ref_id,

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

13307: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13308: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13309: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;
13310:
13311: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
13312:
13313: INSERT INTO CZ_UI_PAGE_REFS
13314: (ui_def_id,
13315: page_set_id,

Line 20563: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

20559: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
20560: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
20561: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
20562: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
20563: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
20564: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;
20565: l_ref_parent_persist_node_id NUMBER;
20566: l_ref_ps_node_id NUMBER;
20567: l_ref_parent_id NUMBER;

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

20636: deleted_flag=G_NO_FLAG;
20637:
20638: IF SQL%ROWCOUNT=0 THEN
20639:
20640: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
20641:
20642: l_ref_pagebase_path := get_Page_Path(l_ref_ps_node_id, i.page_set_id);
20643:
20644: SELECT NVL(MAX(seq_nbr),0)+1 INTO l_seq_nbr

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

20806: INDUSTRY => l_industry,
20807: ORACLE_SCHEMA => l_oracle_schema);
20808:
20809: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
20810: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
20811: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
20813: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
20814: