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

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

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

1832: --
1833: -- return UI element with element_id = p_element_id
1834: --
1835: FUNCTION get_Page_Set(p_page_set_id IN NUMBER)
1836: RETURN CZ_UI_PAGE_SETS%ROWTYPE IS
1837: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1838: BEGIN
1839: SELECT *
1840: INTO l_page_set_node

Line 1837: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

1833: -- return UI element with element_id = p_element_id
1834: --
1835: FUNCTION get_Page_Set(p_page_set_id IN NUMBER)
1836: RETURN CZ_UI_PAGE_SETS%ROWTYPE IS
1837: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1838: BEGIN
1839: SELECT *
1840: INTO l_page_set_node
1841: FROM CZ_UI_PAGE_SETS

Line 1841: FROM CZ_UI_PAGE_SETS

1837: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
1838: BEGIN
1839: SELECT *
1840: INTO l_page_set_node
1841: FROM CZ_UI_PAGE_SETS
1842: WHERE page_set_id = p_page_set_id AND
1843: ui_def_id=g_UI_Context.ui_def_id;
1844: RETURN l_page_set_node;
1845: END get_Page_Set;

Line 2409: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

2405: l_model_path VARCHAR2(32000);
2406: l_persistent_node_id NUMBER;
2407: l_parent_id NUMBER;
2408: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
2409: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2410: l_seq_nbr NUMBER;
2411: l_node_depth NUMBER;
2412:
2413: BEGIN

Line 2577: FROM CZ_UI_PAGE_SETS

2573: l_page_counter NUMBER;
2574: BEGIN
2575: SELECT COUNT(*)
2576: INTO l_page_counter
2577: FROM CZ_UI_PAGE_SETS
2578: WHERE ui_def_id = g_UI_Context.ui_def_id AND
2579: deleted_flag=G_NO_FLAG;
2580: RETURN l_page_counter;
2581: END get_Page_Set_Counter;

Line 2644: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

2640: p_model_ref_expl_id IN NUMBER,
2641: x_page_set_id OUT NOCOPY NUMBER
2642: ) IS
2643:
2644: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2645: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;
2646: l_root_persistent_node_id NUMBER;
2647: l_page_set_counter NUMBER;
2648:

Line 2645: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;

2641: x_page_set_id OUT NOCOPY NUMBER
2642: ) IS
2643:
2644: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2645: l_page_set_name CZ_UI_PAGE_SETS.name%TYPE;
2646: l_root_persistent_node_id NUMBER;
2647: l_page_set_counter NUMBER;
2648:
2649: BEGIN

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

2650:
2651: IF p_page_set_type IN(G_SINGLE_LEVEL_MENU,G_MULTI_LEVEL_MENU,
2652: G_MODEL_TREE_MENU,G_PAGE_FLOW,G_SUBTABS) THEN
2653:
2654: SELECT COUNT(page_set_id)+1 INTO l_page_set_counter FROM CZ_UI_PAGE_SETS
2655: WHERE ui_def_id=p_ui_def_id AND page_set_type=p_page_set_type AND
2656: deleted_flag=G_NO_FLAG;
2657: IF p_page_set_type IN(G_PAGE_FLOW) THEN
2658: l_page_set_name := 'Page Flow - '|| TO_CHAR(l_page_set_counter);

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

2665: l_page_set_counter := get_Page_Set_Counter() + 1;
2666: l_page_set_name := 'Page Set - ' || TO_CHAR(l_page_set_counter);
2667: END IF;
2668:
2669: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2670:
2671: INSERT INTO CZ_UI_PAGE_SETS
2672: (ui_def_id,
2673: page_set_id,

Line 2671: INSERT INTO CZ_UI_PAGE_SETS

2667: END IF;
2668:
2669: x_page_set_id := allocateId('CZ_UI_PAGE_SETS_S');
2670:
2671: INSERT INTO CZ_UI_PAGE_SETS
2672: (ui_def_id,
2673: page_set_id,
2674: page_set_type,
2675: NAME,

Line 3406: UPDATE CZ_UI_PAGE_SETS

3402: SET pagebase_expl_node_id=p_expl_id
3403: WHERE page_id=p_ui_node.page_id AND
3404: ui_def_id=p_ui_node.ui_def_id;
3405: IF SQL%ROWCOUNT>0 THEN
3406: UPDATE CZ_UI_PAGE_SETS
3407: SET pagebase_expl_node_id=p_expl_id
3408: WHERE ui_def_id=g_UI_Context.ui_def_id
3409: AND persistent_node_id=p_ui_node.persistent_node_id
3410: AND deleted_flag=G_NO_FLAG;

Line 3614: FROM CZ_UI_PAGE_SETS

3610: g_ui_page_refs_tbl(i.page_ref_id) := i;
3611: END LOOP;
3612:
3613: FOR i IN (SELECT *
3614: FROM CZ_UI_PAGE_SETS
3615: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3616: deleted_flag = G_NO_FLAG)
3617: LOOP
3618: g_ui_page_sets_tbl(i.page_set_id) := i;

Line 9113: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

9109: RETURN CZ_UI_DEFS%ROWTYPE IS
9110:
9111: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
9112: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
9113: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
9114: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
9115: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
9116: l_master_template_id NUMBER;
9117:

Line 9115: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;

9111: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
9112: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
9113: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
9114: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
9115: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
9116: l_master_template_id NUMBER;
9117:
9118: BEGIN
9119: l_master_template_id := p_master_template_id; -- this is to handle bug in 9i PL/SQL

Line 10687: SELECT page_set_type INTO x_parent_page_set_type FROM CZ_UI_PAGE_SETS

10683: page_ref_id=x_parent_page_ref_id;
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN
10686: IF x_page_set_id IS NOT NULL THEN
10687: SELECT page_set_type INTO x_parent_page_set_type FROM CZ_UI_PAGE_SETS
10688: WHERE ui_def_id = g_UI_Context.ui_def_id AND page_set_id=x_page_set_id;
10689: END IF;
10690: x_parent_node_depth := 1;
10691: END;

Line 10796: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

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

Line 10799: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%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;
10799: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10800: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10801: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10802: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;
10803: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

Line 10803: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;

10799: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10800: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10801: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10802: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;
10803: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
10804: l_parent_page_persistent_id NUMBER;
10805: l_page_counter NUMBER;
10806: l_pagebase_expl_node_id NUMBER;
10807: l_is_inst_node BOOLEAN := FALSE;

Line 11080: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

11076: --
11077:
11078: IF l_is_drilldown_node=FALSE THEN
11079:
11080: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
11081: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11082: page_set_id=l_page_set_id AND
11083: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
11084: LOOP

Line 11592: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

11588: WHEN NO_DATA_FOUND THEN
11589: RETURN l_ui_node;
11590: END;
11591:
11592: FOR m IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
11593: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11594: page_set_id=l_page_ref_node.page_set_id AND
11595: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
11596: LOOP

Line 11611: FROM CZ_UI_PAGE_SETS

11607: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND
11608: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);
11609:
11610: SELECT MIN(page_set_id) INTO l_target_ui_def_node.page_set_id
11611: FROM CZ_UI_PAGE_SETS
11612: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND deleted_flag=G_NO_FLAG;
11613:
11614: END IF;
11615:

Line 12028: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

12024: -- delete UI page
12025: --
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;

Line 12152: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

12148:
12149: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
12150: l_new_parent_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
12151: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
12152: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12153:
12154: BEGIN
12155:
12156: x_new_parent_page_ref_id := NULL;

Line 12160: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

12156: x_new_parent_page_ref_id := NULL;
12157:
12158:
12159: IF p_page_set_id IS NOT NULL THEN
12160: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
12161: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id;
12162: END IF;
12163:
12164: BEGIN

Line 12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;

12276: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12277: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12278: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12279: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12281: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
12282: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12283:
12284: BEGIN

Line 12290: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

12286: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
12287: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
12288:
12289: IF l_page_set_id IS NOT NULL THEN
12290: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS
12291: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=l_page_set_id;
12292: END IF;
12293:
12294: move_page_ref(p_ui_node, p_node, l_new_parent_page_ref_id);

Line 12776: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

12772: PROCEDURE check_Region_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12773: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12774:
12775: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12776: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12777: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12778: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
12779:
12780: BEGIN

Line 12778: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;

12774:
12775: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12776: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12777: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12778: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
12779:
12780: BEGIN
12781:
12782: IF (p_node.instantiable_flag IN(G_OPTIONAL_INST_TYPE,G_MINMAX_INST_TYPE)

Line 13896: (SELECT page_set_id FROM CZ_UI_PAGE_SETS

13892: BEGIN
13893: FOR i IN(SELECT page_id FROM CZ_UI_PAGES a
13894: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13895: page_set_id IN
13896: (SELECT page_set_id FROM CZ_UI_PAGE_SETS
13897: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13898: page_set_id=a.page_set_id AND
13899: page_set_type=G_SINGLE_PAGE AND
13900: deleted_flag=G_NO_FLAG) AND

Line 13950: FROM CZ_UI_PAGE_SETS

13946:
13947: BEGIN
13948:
13949: FOR n IN(SELECT page_set_id
13950: FROM CZ_UI_PAGE_SETS
13951: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13952: page_set_type IN(G_PAGE_FLOW,G_SUBTABS) AND
13953: deleted_flag=G_NO_FLAG)
13954: LOOP

Line 13986: FROM CZ_UI_PAGE_SETS

13982: END LOOP; -- loop with n index
13983:
13984:
13985: FOR n IN(SELECT page_set_id,persistent_node_id,pagebase_expl_node_id
13986: FROM CZ_UI_PAGE_SETS
13987: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13988: deleted_flag=G_NO_FLAG)
13989: LOOP
13990:

Line 14593: FOR i IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS

14589: -- set ordering for UI elements on UI pages
14590: --
14591: PROCEDURE handle_SLMenu_Order IS
14592: BEGIN
14593: FOR i IN(SELECT page_set_id FROM CZ_UI_PAGE_SETS
14594: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14595: page_set_type=G_SINGLE_LEVEL_MENU AND
14596: deleted_flag=G_NO_FLAG)
14597: LOOP

Line 15380: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

15376: END ui_node_exits;
15377:
15378: PROCEDURE reorder_tree_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
15379:
15380: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
15381: l_page_ref CZ_UI_PAGE_REFS%ROWTYPE;
15382:
15383: l_old_seq_nbr NUMBER;
15384: l_new_seq_nbr NUMBER;

Line 15831: UPDATE CZ_UI_PAGE_SETS

15827: page_id=upgel.page_id AND
15828: persistent_node_id=t.psnode_persistent_node_id AND
15829: pagebase_expl_node_id<>l_expl_id;
15830:
15831: UPDATE CZ_UI_PAGE_SETS
15832: SET pagebase_expl_node_id=l_expl_id
15833: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15834: persistent_node_id=t.psnode_persistent_node_id AND
15835: pagebase_expl_node_id<>l_expl_id;

Line 17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.

17520: NULL;
17521: END log_message;
17522:
17523: --bug14029835 , Added procedure that checks the data in cz_ui_page_elements, cz_ui_pages
17524: -- cz_ui_page_refs, cz_ui_page_sets , cz_ui_actions with cz_model_ref_Expls table.
17525: -- Logically deletes the invalid elements.
17526: PROCEDURE delete_Invalid_UI_Elements(p_ui_def_id IN NUMBER) IS
17527:
17528: BEGIN

Line 17580: -- Verify for cz_ui_page_sets.pagebase_expl_node_id

17576: AND ui_def_id = uiDefCur.ref_ui_def_id;
17577: END LOOP; --pageRefs
17578:
17579:
17580: -- Verify for cz_ui_page_sets.pagebase_expl_node_id
17581: FOR pageSets IN (SELECT pgset.page_set_id,pgset.pagebase_expl_node_id FROM CZ_UI_PAGE_SETS pgset
17582: WHERE pgset.deleted_flag = G_NO_FLAG AND pgset.ui_def_id = uiDefCur.ref_ui_def_id
17583: AND pgset.pagebase_expl_node_id IS NOT NULL
17584: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

Line 17581: FOR pageSets IN (SELECT pgset.page_set_id,pgset.pagebase_expl_node_id FROM CZ_UI_PAGE_SETS pgset

17577: END LOOP; --pageRefs
17578:
17579:
17580: -- Verify for cz_ui_page_sets.pagebase_expl_node_id
17581: FOR pageSets IN (SELECT pgset.page_set_id,pgset.pagebase_expl_node_id FROM CZ_UI_PAGE_SETS pgset
17582: WHERE pgset.deleted_flag = G_NO_FLAG AND pgset.ui_def_id = uiDefCur.ref_ui_def_id
17583: AND pgset.pagebase_expl_node_id IS NOT NULL
17584: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17585: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgset.pagebase_expl_node_id

Line 17590: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_SETS where pagebase_expl_node_id : ' || pageSets.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

17586: )
17587: )
17588: LOOP
17589:
17590: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_SETS where pagebase_expl_node_id : ' || pageSets.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17591:
17592: UPDATE CZ_UI_PAGE_SETS
17593: SET deleted_flag = G_YES_FLAG
17594: WHERE pagebase_expl_node_id = pageSets.pagebase_expl_node_id

Line 17592: UPDATE CZ_UI_PAGE_SETS

17588: LOOP
17589:
17590: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_SETS where pagebase_expl_node_id : ' || pageSets.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17591:
17592: UPDATE CZ_UI_PAGE_SETS
17593: SET deleted_flag = G_YES_FLAG
17594: WHERE pagebase_expl_node_id = pageSets.pagebase_expl_node_id
17595: AND page_set_id = pageSets.page_set_id
17596: AND ui_def_id = uiDefCur.ref_ui_def_id;

Line 21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', 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:
21931: SELECT template_name
21932: INTO G_DRILLDOWN_TEMPLATE_NAME