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_SETS

Line 280: TYPE ui_page_sets_tbl_type IS TABLE OF CZ_UI_PAGE_SETS%ROWTYPE INDEX BY BINARY_INTEGER;

276: -- fix for bug 6837809 : skudryav 28-Mar-2008
277: TYPE ui_page_el_int_tbl_type IS TABLE OF CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE INDEX BY BINARY_INTEGER;
278:
279: TYPE ui_def_nodes_tbl_type IS TABLE OF CZ_UI_DEFS%ROWTYPE INDEX BY BINARY_INTEGER;
280: TYPE ui_page_sets_tbl_type IS TABLE OF CZ_UI_PAGE_SETS%ROWTYPE INDEX BY BINARY_INTEGER;
281: TYPE ui_pages_tbl_type IS TABLE OF CZ_UI_PAGES%ROWTYPE INDEX BY BINARY_INTEGER;
282: TYPE ui_page_refs_tbl_type IS TABLE OF CZ_UI_PAGE_REFS%ROWTYPE INDEX BY BINARY_INTEGER;
283: TYPE xml_dom_elements_tbl_type IS TABLE OF xmldom.DOMNode INDEX BY BINARY_INTEGER;
284:

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 1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

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

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 1780: RETURN CZ_UI_PAGE_SETS%ROWTYPE IS

1776: --
1777: -- return UI element with element_id = p_element_id
1778: --
1779: FUNCTION get_Page_Set(p_page_set_id IN NUMBER)
1780: RETURN CZ_UI_PAGE_SETS%ROWTYPE IS
1781: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1782: BEGIN
1783: SELECT *
1784: INTO l_page_set_node

Line 1781: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

1777: -- return UI element with element_id = p_element_id
1778: --
1779: FUNCTION get_Page_Set(p_page_set_id IN NUMBER)
1780: RETURN CZ_UI_PAGE_SETS%ROWTYPE IS
1781: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1782: BEGIN
1783: SELECT *
1784: INTO l_page_set_node
1785: FROM CZ_UI_PAGE_SETS

Line 1785: FROM CZ_UI_PAGE_SETS

1781: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1782: BEGIN
1783: SELECT *
1784: INTO l_page_set_node
1785: FROM CZ_UI_PAGE_SETS
1786: WHERE page_set_id = p_page_set_id AND
1787: ui_def_id=g_UI_Context.ui_def_id;
1788: RETURN l_page_set_node;
1789: END get_Page_Set;

Line 2347: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

2343: l_model_path VARCHAR2(32000);
2344: l_persistent_node_id NUMBER;
2345: l_parent_id NUMBER;
2346: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
2347: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2348: l_seq_nbr NUMBER;
2349: l_node_depth NUMBER;
2350:
2351: BEGIN

Line 2515: FROM CZ_UI_PAGE_SETS

2511: l_page_counter NUMBER;
2512: BEGIN
2513: SELECT COUNT(*)
2514: INTO l_page_counter
2515: FROM CZ_UI_PAGE_SETS
2516: WHERE ui_def_id = g_UI_Context.ui_def_id AND
2517: deleted_flag=G_NO_FLAG;
2518: RETURN l_page_counter;
2519: END get_Page_Set_Counter;

Line 2582: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

2578: p_model_ref_expl_id IN NUMBER,
2579: x_page_set_id OUT NOCOPY NUMBER
2580: ) IS
2581:
2582: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2583: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;
2584: l_root_persistent_node_id NUMBER;
2585: l_page_set_counter NUMBER;
2586:

Line 2583: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;

2579: x_page_set_id OUT NOCOPY NUMBER
2580: ) IS
2581:
2582: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2583: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;
2584: l_root_persistent_node_id NUMBER;
2585: l_page_set_counter NUMBER;
2586:
2587: BEGIN

Line 2592: SELECT COUNT(page_set_id)+1 INTO l_page_set_counter FROM CZ_UI_PAGE_SETS

2588:
2589: IF p_page_set_type IN(G_SINGLE_LEVEL_MENU,G_MULTI_LEVEL_MENU,
2590: G_MODEL_TREE_MENU,G_PAGE_FLOW,G_SUBTABS) THEN
2591:
2592: SELECT COUNT(page_set_id)+1 INTO l_page_set_counter FROM CZ_UI_PAGE_SETS
2593: WHERE ui_def_id=p_ui_def_id AND page_set_type=p_page_set_type AND
2594: deleted_flag=G_NO_FLAG;
2595: IF p_page_set_type IN(G_PAGE_FLOW) THEN
2596: l_page_set_name := 'Page Flow - '|| TO_CHAR(l_page_set_counter);

Line 2607: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');

2603: l_page_set_counter := get_Page_Set_Counter() + 1;
2604: l_page_set_name := 'Page Set - ' || TO_CHAR(l_page_set_counter);
2605: END IF;
2606:
2607: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2608:
2609: INSERT INTO CZ_UI_PAGE_SETS
2610: (ui_def_id,
2611: page_set_id,

Line 2609: INSERT INTO CZ_UI_PAGE_SETS

2605: END IF;
2606:
2607: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2608:
2609: INSERT INTO CZ_UI_PAGE_SETS
2610: (ui_def_id,
2611: page_set_id,
2612: page_set_type,
2613: NAME,

Line 3344: UPDATE CZ_UI_PAGE_SETS

3340: SET pagebase_expl_node_id=p_expl_id
3341: WHERE page_id=p_ui_node.page_id AND
3342: ui_def_id=p_ui_node.ui_def_id;
3343: IF SQL%ROWCOUNT>0 THEN
3344: UPDATE CZ_UI_PAGE_SETS
3345: SET pagebase_expl_node_id=p_expl_id
3346: WHERE ui_def_id=g_UI_Context.ui_def_id
3347: AND persistent_node_id=p_ui_node.persistent_node_id
3348: AND deleted_flag=G_NO_FLAG;

Line 3552: FROM CZ_UI_PAGE_SETS

3548: g_ui_page_refs_tbl(i.page_ref_id) := i;
3549: END LOOP;
3550:
3551: FOR i IN (SELECT *
3552: FROM CZ_UI_PAGE_SETS
3553: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3554: deleted_flag = G_NO_FLAG)
3555: LOOP
3556: g_ui_page_sets_tbl(i.page_set_id) := i;

Line 8653: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

8649: RETURN CZ_UI_DEFS%ROWTYPE IS
8650:
8651: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
8652: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
8653: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
8654: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
8655: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
8656: l_master_template_id NUMBER;
8657:

Line 8655: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;

8651: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
8652: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
8653: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
8654: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
8655: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
8656: l_master_template_id NUMBER;
8657:
8658: BEGIN
8659: l_master_template_id := p_master_template_id; -- this is to handle bug in 9i PL/SQL

Line 10208: SELECT page_set_type INTO x_parent_page_set_type FROM CZ_UI_PAGE_SETS

10204: page_ref_id=x_parent_page_ref_id;
10205: EXCEPTION
10206: WHEN NO_DATA_FOUND THEN
10207: IF x_page_set_id IS NOT NULL THEN
10208: SELECT page_set_type INTO x_parent_page_set_type FROM CZ_UI_PAGE_SETS
10209: WHERE ui_def_id = g_UI_Context.ui_def_id AND page_set_id=x_page_set_id;
10210: END IF;
10211: x_parent_node_depth := 1;
10212: END;

Line 10317: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

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;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;

Line 10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%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;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10322: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10323: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;
10324: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

Line 10324: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10322: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10323: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;
10324: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
10325: l_parent_page_persistent_id NUMBER;
10326: l_page_counter NUMBER;
10327: l_pagebase_expl_node_id NUMBER;
10328: l_is_inst_node BOOLEAN := FALSE;

Line 10601: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

10597: --
10598:
10599: IF l_is_drilldown_node=FALSE THEN
10600:
10601: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
10602: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10603: page_set_id=l_page_set_id AND
10604: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
10605: LOOP

Line 11113: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

11109: WHEN NO_DATA_FOUND THEN
11110: RETURN l_ui_node;
11111: END;
11112:
11113: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
11114: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11115: page_set_id=l_page_ref_node.page_set_id AND
11116: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
11117: LOOP

Line 11132: FROM CZ_UI_PAGE_SETS

11128: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND
11129: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);
11130:
11131: SELECT MIN(page_set_id) INTO l_target_ui_def_node.page_set_id
11132: FROM CZ_UI_PAGE_SETS
11133: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND deleted_flag=G_NO_FLAG;
11134:
11135: END IF;
11136:

Line 11549: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

11545: -- delete UI page
11546: --
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;

Line 11673: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

11669:
11670: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
11671: l_new_parent_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
11672: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
11673: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
11674:
11675: BEGIN
11676:
11677: x_new_parent_page_ref_id := NULL;

Line 11681: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

11677: x_new_parent_page_ref_id := NULL;
11678:
11679:
11680: IF p_page_set_id IS NOT NULL THEN
11681: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
11682: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id;
11683: END IF;
11684:
11685: BEGIN

Line 11801: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

11797: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11798: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
11799: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11800: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11801: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
11802: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
11803: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11804:
11805: BEGIN

Line 11811: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

11807: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
11808: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
11809:
11810: IF l_page_set_id IS NOT NULL THEN
11811: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
11812: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=l_page_set_id;
11813: END IF;
11814:
11815: move_page_ref(p_ui_node, p_node, l_new_parent_page_ref_id);

Line 12296: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

12292: PROCEDURE check_Region_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12293: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12294:
12295: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12296: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12297: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12298: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
12299:
12300: BEGIN

Line 12298: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;

12294:
12295: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12296: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12297: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12298: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
12299:
12300: BEGIN
12301:
12302: IF (p_node.instantiable_flag IN(G_OPTIONAL_INST_TYPE,G_MINMAX_INST_TYPE)

Line 13412: (SELECT page_set_id FROM CZ_UI_PAGE_SETS

13408: BEGIN
13409: FOR i IN(SELECT page_id FROM CZ_UI_PAGES a
13410: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13411: page_set_id IN
13412: (SELECT page_set_id FROM CZ_UI_PAGE_SETS
13413: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13414: page_set_id=a.page_set_id AND
13415: page_set_type=G_SINGLE_PAGE AND
13416: deleted_flag=G_NO_FLAG) AND

Line 13466: FROM CZ_UI_PAGE_SETS

13462:
13463: BEGIN
13464:
13465: FOR n IN(SELECT page_set_id
13466: FROM CZ_UI_PAGE_SETS
13467: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13468: page_set_type IN(G_PAGE_FLOW,G_SUBTABS) AND
13469: deleted_flag=G_NO_FLAG)
13470: LOOP

Line 13502: FROM CZ_UI_PAGE_SETS

13498: END LOOP; -- loop with n index
13499:
13500:
13501: FOR n IN(SELECT page_set_id,persistent_node_id,pagebase_expl_node_id
13502: FROM CZ_UI_PAGE_SETS
13503: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13504: deleted_flag=G_NO_FLAG)
13505: LOOP
13506:

Line 14109: FOR i IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

14105: -- set ordering for UI elements on UI pages
14106: --
14107: PROCEDURE handle_SLMenu_Order IS
14108: BEGIN
14109: FOR i IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
14110: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14111: page_set_type=G_SINGLE_LEVEL_MENU AND
14112: deleted_flag=G_NO_FLAG)
14113: LOOP

Line 14801: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

14797: END ui_node_exits;
14798:
14799: PROCEDURE reorder_tree_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
14800:
14801: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
14802: l_page_ref CZ_UI_PAGE_REFS%ROWTYPE;
14803:
14804: l_old_seq_nbr NUMBER;
14805: l_new_seq_nbr NUMBER;

Line 20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', 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:
20815: SELECT template_name
20816: INTO G_DRILLDOWN_TEMPLATE_NAME