[Home] [Help]
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:
285: TYPE varchar2_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY VARCHAR2(255);
286:
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;
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
1023: ELSE
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
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
2308: --
2309: -- return page_ref node of nearest page
2310: --
2311: FUNCTION get_UI_Page_Ref_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2312: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS
2313:
2314: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
2315:
2316: BEGIN
2310: --
2311: FUNCTION get_UI_Page_Ref_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2312: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS
2313:
2314: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
2315:
2316: BEGIN
2317:
2318: IF p_ui_node.page_id IS NULL THEN
2320: END IF;
2321:
2322: SELECT *
2323: INTO l_page_ref_node
2324: FROM CZ_UI_PAGE_REFS a
2325: WHERE ui_def_id = p_ui_node.ui_def_id AND
2326: (target_page_id,page_set_id) IN
2327: (SELECT page_id,NVL(page_set_id,a.page_set_id) FROM CZ_UI_PAGES
2328: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id AND
2357: IF l_page_set_node.persistent_node_id IS NOT NULL THEN
2358: l_persistent_node_id := l_page_set_node.persistent_node_id;
2359: ELSE
2360: BEGIN
2361: SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS
2362: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2363: AND deleted_flag=G_NO_FLAG;
2364:
2365: SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS
2361: SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS
2362: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2363: AND deleted_flag=G_NO_FLAG;
2364:
2365: SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS
2366: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2367: AND node_depth=l_node_depth AND deleted_flag=G_NO_FLAG;
2368:
2369: SELECT DISTINCT target_persistent_node_id INTO l_persistent_node_id
2366: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2367: AND node_depth=l_node_depth AND deleted_flag=G_NO_FLAG;
2368:
2369: SELECT DISTINCT target_persistent_node_id INTO l_persistent_node_id
2370: FROM CZ_UI_PAGE_REFS
2371: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2372: AND seq_nbr=l_seq_nbr AND
2373: target_persistent_node_id NOT IN
2374: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE
3034: --
3035: PROCEDURE merge_Page_Flows(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3036: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3037: l_changed_target_ids_tbl number_tbl_type;
3038: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3039: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3040: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3041: l_child_page_set_id NUMBER;
3042: l_child_page_ref_id NUMBER;
3035: PROCEDURE merge_Page_Flows(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3036: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3037: l_changed_target_ids_tbl number_tbl_type;
3038: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3039: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3040: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3041: l_child_page_set_id NUMBER;
3042: l_child_page_ref_id NUMBER;
3043: l_parent_page_set_id NUMBER;
3061: -- get Page set id and page_ref_id of parent Page Flow
3062: --
3063: SELECT MIN(page_ref_id)
3064: INTO l_parent_page_ref_id
3065: FROM CZ_UI_PAGE_REFS
3066: WHERE ui_def_id=p_ui_node.ui_def_id AND
3067: target_persistent_node_id=p_ui_node.parent_persistent_node_id AND
3068: deleted_flag=G_NO_FLAG;
3069:
3067: target_persistent_node_id=p_ui_node.parent_persistent_node_id AND
3068: deleted_flag=G_NO_FLAG;
3069:
3070: SELECT page_set_id,page_ref_type
3071: INTO l_parent_page_set_id,l_page_ref_type FROM CZ_UI_PAGE_REFS
3072: WHERE ui_def_id=p_ui_node.ui_def_id AND page_ref_id=l_parent_page_ref_id;
3073:
3074: --
3075: -- attach child Page Flow to the parent Page Flow
3073:
3074: --
3075: -- attach child Page Flow to the parent Page Flow
3076: --
3077: UPDATE CZ_UI_PAGE_REFS
3078: SET parent_page_ref_id = l_parent_page_ref_id
3079: WHERE ui_def_id=p_ui_node.ui_def_id AND
3080: page_ref_id=l_child_page_ref_id;
3081:
3078: SET parent_page_ref_id = l_parent_page_ref_id
3079: WHERE ui_def_id=p_ui_node.ui_def_id AND
3080: page_ref_id=l_child_page_ref_id;
3081:
3082: UPDATE CZ_UI_PAGE_REFS
3083: SET page_set_id = l_parent_page_set_id
3084: WHERE ui_def_id=p_ui_node.ui_def_id AND
3085: target_page_id IN
3086: (SELECT target_page_id FROM CZ_UI_PAGE_REFS
3082: UPDATE CZ_UI_PAGE_REFS
3083: SET page_set_id = l_parent_page_set_id
3084: WHERE ui_def_id=p_ui_node.ui_def_id AND
3085: target_page_id IN
3086: (SELECT target_page_id FROM CZ_UI_PAGE_REFS
3087: START WITH ui_def_id=p_ui_node.ui_def_id AND
3088: page_ref_id=l_child_page_ref_id
3089: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
3090: ui_def_id=p_ui_node.ui_def_id AND
3104:
3105: -- IF l_page_ref_type IN(G_PAGE_FLOW,G_SUBTABS) THEN
3106: l_model_node := get_Model_Node_By_Persist_Id(l_changed_target_ids_tbl(x), g_UI_Context.devl_project_id);
3107: l_target_path := get_Page_Path(l_model_node.ps_node_id, l_parent_page_set_id);
3108: UPDATE CZ_UI_PAGE_REFS
3109: SET target_path=l_target_path
3110: WHERE ui_def_id=p_ui_node.ui_def_id AND
3111: page_set_id=l_parent_page_set_id AND
3112: target_persistent_node_id=l_changed_target_ids_tbl(x) AND
3124: PROCEDURE split_Page_Flow(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3125: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3126: l_changed_target_ids_tbl number_tbl_type;
3127: l_target_page_ids_tbl number_tbl_type;
3128: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3129: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3130: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3131: l_page_set_type NUMBER;
3132: l_initial_page_set_id NUMBER;
3125: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3126: l_changed_target_ids_tbl number_tbl_type;
3127: l_target_page_ids_tbl number_tbl_type;
3128: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3129: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3130: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3131: l_page_set_type NUMBER;
3132: l_initial_page_set_id NUMBER;
3133: l_initial_page_ref_id NUMBER;
3164: p_persistent_node_id => p_ui_node.persistent_node_id,
3165: p_model_ref_expl_id => p_ui_node.model_ref_expl_id,
3166: x_page_set_id => l_page_set_id);
3167:
3168: UPDATE CZ_UI_PAGE_REFS
3169: SET target_path='.',
3170: parent_page_ref_id=NULL,
3171: node_depth=1,
3172: seq_nbr=1
3172: seq_nbr=1
3173: WHERE ui_def_id=p_ui_node.ui_def_id AND
3174: page_ref_id=l_initial_page_ref_id;
3175:
3176: UPDATE CZ_UI_PAGE_REFS
3177: SET page_set_id = l_page_set_id
3178: WHERE ui_def_id=p_ui_node.ui_def_id AND
3179: target_persistent_node_id IN
3180: (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS
3176: UPDATE CZ_UI_PAGE_REFS
3177: SET page_set_id = l_page_set_id
3178: WHERE ui_def_id=p_ui_node.ui_def_id AND
3179: target_persistent_node_id IN
3180: (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS
3181: START WITH ui_def_id=p_ui_node.ui_def_id AND
3182: page_ref_id=l_initial_page_ref_id
3183: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
3184: ui_def_id=p_ui_node.ui_def_id AND
3199:
3200: l_model_node := get_Model_Node_By_Persist_Id(l_changed_target_ids_tbl(j), g_UI_Context.devl_project_id);
3201: l_target_path := get_Page_Path(l_model_node.ps_node_id, l_page_set_id);
3202:
3203: UPDATE CZ_UI_PAGE_REFS
3204: SET target_path=l_target_path
3205: WHERE ui_def_id=p_ui_node.ui_def_id AND
3206: page_set_id=l_page_set_id AND
3207: target_persistent_node_id=l_changed_target_ids_tbl(j) AND
3348: AND deleted_flag=G_NO_FLAG;
3349: END IF;
3350: END IF;
3351:
3352: UPDATE CZ_UI_PAGE_REFS
3353: SET target_expl_node_id=p_expl_id
3354: WHERE ui_def_id=p_ui_node.ui_def_id AND
3355: target_persistent_node_id=p_node.persistent_node_id;
3356:
3540: END;
3541: END LOOP;
3542:
3543: FOR i IN (SELECT *
3544: FROM CZ_UI_PAGE_REFS
3545: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3546: deleted_flag = G_NO_FLAG)
3547: LOOP
3548: g_ui_page_refs_tbl(i.page_ref_id) := i;
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:
8658: BEGIN
10192: BEGIN
10193:
10194: SELECT MIN(page_ref_id)
10195: INTO x_parent_page_ref_id
10196: FROM CZ_UI_PAGE_REFS
10197: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10198: NVL(page_set_id,-1)=NVL(x_page_set_id,-1) AND
10199: target_page_id=x_page_id AND deleted_flag=G_NO_FLAG;
10200:
10198: NVL(page_set_id,-1)=NVL(x_page_set_id,-1) AND
10199: target_page_id=x_page_id AND deleted_flag=G_NO_FLAG;
10200:
10201: SELECT node_depth,page_ref_type INTO x_parent_node_depth, x_parent_page_set_type
10202: FROM CZ_UI_PAGE_REFS
10203: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10204: page_ref_id=x_parent_page_ref_id;
10205: EXCEPTION
10206: WHEN NO_DATA_FOUND THEN
10235: --DEBUG('asp: Getting seq_nbr for ps node ' || p_node.name);
10236:
10237: IF NOT g_using_new_UI_refresh THEN
10238: SELECT COUNT(*)+1 INTO l_seq_nbr
10239: FROM CZ_UI_PAGE_REFS
10240: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10241: page_set_id = p_page_set_id AND
10242: parent_page_ref_id=p_parent_page_ref_id AND
10243: deleted_flag=G_NO_FLAG;
10261: LOOP
10262: --DEBUG('asp: predecessor persistent_node_id = ' || l_predecessor_persistent_id);
10263:
10264: SELECT NVL(max(seq_nbr), 0) INTO l_seq_nbr
10265: FROM CZ_UI_PAGE_REFS
10266: WHERE ui_def_id = g_UI_Context.ui_def_id
10267: AND page_set_id = p_page_set_id
10268: AND parent_page_ref_id = p_parent_page_ref_id
10269: AND target_persistent_node_id = j.persistent_node_id
10277: END IF;
10278: END LOOP;
10279: END LOOP;
10280:
10281: -- node of the predecesors found in cz_ui_page_refs
10282: RETURN 1;
10283:
10284: EXCEPTION
10285: WHEN NO_DATA_FOUND THEN
10284: EXCEPTION
10285: WHEN NO_DATA_FOUND THEN
10286: -- seq_nbrs in cz_ps_nodes are not correct
10287: SELECT NVL(count(*), 0) + 1 INTO l_seq_nbr
10288: FROM CZ_UI_PAGE_REFS
10289: WHERE ui_def_id = g_UI_Context.ui_def_Id
10290: AND page_set_id = p_page_set_id
10291: AND parent_page_ref_id = p_parent_page_ref_id
10292: AND deleted_flag = G_NO_FLAG;
10309:
10310: l_page_node CZ_UI_PAGES%ROWTYPE;
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;
10310: l_page_node CZ_UI_PAGES%ROWTYPE;
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;
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;
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;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%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;
10325: l_parent_page_persistent_id NUMBER;
10326: l_page_counter NUMBER;
10607: /******** attach new UI Page to Page Set *********************/
10608: BEGIN
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);
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
10616:
10617: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN
10618:
10619: SELECT COUNT(*)+1 INTO l_seq_nbr
10620: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
10621: deleted_flag=G_NO_FLAG;
10622:
10623: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
10624:
10624:
10625:
10626: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_set_id, l_parent_page_ref_id);
10627:
10628: UPDATE CZ_UI_PAGE_REFS
10629: SET seq_nbr = seq_nbr + 1
10630: WHERE ui_def_id = g_UI_Context.ui_def_id
10631: AND page_set_id = l_page_set_id
10632: AND parent_page_ref_id = l_parent_page_ref_id
10638: l_seq_nbr :=p_node.tree_seq;
10639: END IF;
10640: END IF;
10641:
10642: INSERT INTO CZ_UI_PAGE_REFS
10643: (ui_def_id,
10644: page_set_id,
10645: page_ref_id,
10646: parent_page_ref_id,
10861: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
10862: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10863:
10864: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10865: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10863:
10864: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10865: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10873: l_counter NUMBER;
10874: l_persistent_node_id NUMBER;
10875: l_seq_nbr NUMBER;
11116: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
11117: LOOP
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
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
11137: l_target_path := get_Page_Path(p_node.ps_node_id,l_page_ref_node.page_set_id);
11138:
11139: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN
11140: SELECT COUNT(*)+1 INTO l_seq_nbr
11141: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
11142: deleted_flag=G_NO_FLAG;
11143: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
11144:
11145: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_ref_node.page_set_id, l_page_ref_node.page_ref_id);
11143: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
11144:
11145: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_ref_node.page_set_id, l_page_ref_node.page_ref_id);
11146:
11147: UPDATE CZ_UI_PAGE_REFS
11148: SET seq_nbr = seq_nbr + 1
11149: WHERE ui_def_id = g_UI_Context.ui_def_id
11150: AND page_set_id = l_page_ref_node.page_set_id
11151: AND parent_page_ref_id = l_page_ref_node.page_ref_id
11154: ELSE
11155: l_seq_nbr :=p_node.tree_seq;
11156: END IF;
11157:
11158: INSERT INTO CZ_UI_PAGE_REFS
11159: (ui_def_id,
11160: page_set_id,
11161: page_ref_id,
11162: parent_page_ref_id,
11288: IF l_del_flag THEN
11289: --
11290: -- delete UI Ref from Page Sets
11291: --
11292: UPDATE CZ_UI_PAGE_REFS
11293: SET deleted_flag = G_YES_FLAG
11294: WHERE ui_def_id=p_ui_node.ui_def_id AND
11295: target_persistent_node_id=p_ui_node.persistent_node_id AND
11296: deleted_flag=G_NO_FLAG AND
11333:
11334: BEGIN
11335:
11336: SELECT MIN(page_ref_id) INTO l_page_ref_id
11337: FROM CZ_UI_PAGE_REFS
11338: WHERE ui_def_id=p_ui_node.ui_def_id AND
11339: target_page_id=p_ui_node.page_id AND
11340: deleted_flag=G_NO_FLAG;
11341:
11338: WHERE ui_def_id=p_ui_node.ui_def_id AND
11339: target_page_id=p_ui_node.page_id AND
11340: deleted_flag=G_NO_FLAG;
11341:
11342: UPDATE CZ_UI_PAGE_REFS
11343: SET deleted_flag = G_YES_FLAG
11344: WHERE ui_def_id=p_ui_node.ui_def_id AND
11345: page_ref_id=l_page_ref_id
11346: RETURNING parent_page_ref_id,page_set_id,seq_nbr
11349:
11350: --
11351: -- update seq nbr to seq nbr - 1
11352: --
11353: UPDATE CZ_UI_PAGE_REFS
11354: SET seq_nbr = seq_nbr - 1
11355: WHERE ui_def_id=p_ui_node.ui_def_id AND
11356: page_set_id=l_page_set_id AND
11357: parent_page_ref_id = l_parent_page_ref_id AND
11520:
11521: BEGIN
11522:
11523: -- delete UI References
11524: UPDATE CZ_UI_PAGE_REFS uiref
11525: SET deleted_flag=G_YES_FLAG
11526: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
11527: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
11528: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
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;
11554: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%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;
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;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
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;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
11557: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_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;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
11557: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11558:
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;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
11557: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11558:
11559:
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;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
11557: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11558:
11559:
11560: BEGIN
11561: --
11576:
11577: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11578: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
11579:
11580: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11581: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11582: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11583: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11584:
11577: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11578: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
11579:
11580: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11581: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11582: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11583: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11584:
11585: BEGIN
11578: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
11579:
11580: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11581: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11582: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11583: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11584:
11585: BEGIN
11586:
11579:
11580: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11581: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11582: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11583: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11584:
11585: BEGIN
11586:
11587: SELECT page_set_id,pagebase_path INTO l_page_set_id,l_old_page_path_from_root FROM CZ_UI_PAGES
11599: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
11600:
11601: IF SQL%ROWCOUNT>0 THEN
11602: --DEBUG('asp: updating target path 3 for page ' || p_page_id || ' to ' || l_target_path);
11603: UPDATE CZ_UI_PAGE_REFS
11604: SET target_path=l_target_path
11605: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11606: target_page_id=p_page_id;
11607: END IF;
11609:
11610: END replace_page_ref_target_path;
11611:
11612: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11613: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11614: BEGIN
11615:
11616: IF p_node.ps_node_type = G_REFERENCE_TYPE AND
11617: g_UI_Context.primary_navigation = G_MODEL_TREE_MENU THEN
11616: IF p_node.ps_node_type = G_REFERENCE_TYPE AND
11617: g_UI_Context.primary_navigation = G_MODEL_TREE_MENU THEN
11618:
11619: FOR i in (SELECT page_set_id, page_ref_id
11620: FROM CZ_UI_PAGE_REFS
11621: WHERE ui_def_id = g_UI_Context.ui_def_id
11622: AND target_ui_def_id IS NOT NULL
11623: AND target_page_id IS NOT NULL
11624: AND target_persistent_node_id = p_node.persistent_node_id
11626:
11627: LOOP
11628: l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);
11629: --DEBUG('asp: updating target path 10 for page ref ' || i.page_ref_id || ' to ' || l_target_path);
11630: UPDATE CZ_UI_PAGE_REFS
11631: SET target_path=l_target_path
11632: WHERE ui_def_id=g_UI_Context.ui_def_id
11633: AND page_set_id = i.page_set_id
11634: AND page_ref_id = i.page_ref_id;
11649:
11650: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11651: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11652:
11653: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11654: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11655: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11656: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11657:
11650: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11651: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11652:
11653: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11654: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11655: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11656: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11657:
11658: BEGIN
11651: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11652:
11653: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11654: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11655: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11656: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11657:
11658: BEGIN
11659:
11652:
11653: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11654: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11655: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11656: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11657:
11658: BEGIN
11659:
11660: replace_page_ref_target_path(p_node, p_ui_node.page_id);
11660: replace_page_ref_target_path(p_node, p_ui_node.page_id);
11661:
11662: END replace_page_ref_target_path;
11663:
11664: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
11665: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
11661:
11662: END replace_page_ref_target_path;
11663:
11664: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
11665: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
11669:
11663:
11664: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
11665: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
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;
11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
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:
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
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
11668:
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:
11684:
11685: BEGIN
11686: SELECT page_ref_type, node_depth
11687: INTO l_page_ref_type, l_node_depth
11688: FROM CZ_UI_PAGE_REFS
11689: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11690: page_ref_id=p_page_ref_id AND
11691: deleted_flag=G_NO_FLAG;
11692:
11693: -- get new parent page ref id
11694: BEGIN
11695: SELECT MIN(page_ref_id)
11696: INTO x_new_parent_page_ref_id
11697: FROM CZ_UI_PAGE_REFS
11698: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11699: target_persistent_node_id=p_node.parent_persistent_node_id AND
11700: deleted_flag=G_NO_FLAG;
11701:
11700: deleted_flag=G_NO_FLAG;
11701:
11702: SELECT node_depth
11703: INTO l_new_parent_node_depth
11704: FROM CZ_UI_PAGE_REFS
11705: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11706: page_ref_id=x_new_parent_page_ref_id;
11707:
11708: EXCEPTION
11709: WHEN NO_DATA_FOUND THEN
11710: NULL;
11711: END;
11712:
11713: IF x_new_parent_page_ref_id IS NULL THEN -- parent node does not exists in CZ_UI_PAGE_REFS
11714:
11715: IF l_page_ref_type IN (G_MODEL_TREE_MENU) AND p_node.parent_id IS NOT NULL THEN
11716: --DEBUG('asp: Deleting page_ref 5 ' || p_page_ref_id);
11717: UPDATE CZ_UI_PAGE_REFS
11713: IF x_new_parent_page_ref_id IS NULL THEN -- parent node does not exists in CZ_UI_PAGE_REFS
11714:
11715: IF l_page_ref_type IN (G_MODEL_TREE_MENU) AND p_node.parent_id IS NOT NULL THEN
11716: --DEBUG('asp: Deleting page_ref 5 ' || p_page_ref_id);
11717: UPDATE CZ_UI_PAGE_REFS
11718: SET deleted_flag=G_YES_FLAG
11719: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11720: page_ref_id=p_page_ref_id AND
11721: deleted_flag=G_NO_FLAG;
11725:
11726: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
11727: --DEBUG('asp: Setting parent_page_ref_id of page ref ' || p_page_ref_id || ' to ' || x_new_parent_page_ref_id);
11728: --DEBUG('asp: Setting seq_nbr of page ref ' || p_page_ref_id || ' to ' || p_node.tree_seq);
11729: UPDATE CZ_UI_PAGE_REFS
11730: SET parent_page_ref_id = x_new_parent_page_ref_id,
11731: seq_nbr = p_node.tree_seq
11732: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11733: page_ref_id=p_page_ref_id;
11731: seq_nbr = p_node.tree_seq
11732: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11733: page_ref_id=p_page_ref_id;
11734:
11735: UPDATE CZ_UI_PAGE_REFS
11736: SET node_depth = node_depth + (l_new_parent_node_depth-l_node_depth) + 1
11737: WHERE (ui_def_id,page_ref_id) IN
11738: (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS
11739: START WITH ui_def_id=g_UI_Context.ui_def_id AND page_ref_id=p_page_ref_id
11734:
11735: UPDATE CZ_UI_PAGE_REFS
11736: SET node_depth = node_depth + (l_new_parent_node_depth-l_node_depth) + 1
11737: WHERE (ui_def_id,page_ref_id) IN
11738: (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS
11739: START WITH ui_def_id=g_UI_Context.ui_def_id AND page_ref_id=p_page_ref_id
11740: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
11741: ui_def_id=g_UI_Context.ui_def_id AND PRIOR ui_def_id=g_UI_Context.ui_def_id AND
11742: deleted_flag=G_NO_FLAG AND PRIOR deleted_flag=G_NO_FLAG);
11752:
11753:
11754: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11755: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11756: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11757:
11758: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11759: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11760:
11754: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11755: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11756: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11757:
11758: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11759: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11760:
11761: BEGIN
11762:
11755: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11756: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11757:
11758: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11759: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11760:
11761: BEGIN
11762:
11763: BEGIN
11766: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
11767:
11768: SELECT page_ref_id, parent_page_ref_id
11769: INTO l_page_ref_id, x_new_parent_page_ref_id
11770: FROM CZ_UI_PAGE_REFS
11771: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11772: page_set_id = l_page_set_id AND
11773: target_page_id = p_ui_node.page_id AND
11774: deleted_flag=G_NO_FLAG AND
11793: l_persistent_node_id_tbl number_tbl_type;
11794: l_ps_node_id_tb number_tbl_type;
11795: l_component_id_tbl number_tbl_type;
11796: l_ps_node_type_tbl number_tbl_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;
11794: l_ps_node_id_tb number_tbl_type;
11795: l_component_id_tbl number_tbl_type;
11796: l_ps_node_type_tbl number_tbl_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;
11795: l_component_id_tbl number_tbl_type;
11796: l_ps_node_type_tbl number_tbl_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;
11796: l_ps_node_type_tbl number_tbl_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:
12069: l_persistent_node_id NUMBER;
12070: l_max_seq_nbr NUMBER;
12071: l_ps_node_type NUMBER;
12072: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12073: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12074: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12075: l_template_id NUMBER;
12076: l_template_ui_def_id NUMBER;
12077:
12213: persistent_node_id = p_ui_node.persistent_node_id AND
12214: instantiable_flag <> p_node.instantiable_flag;
12215:
12216: FOR i IN(SELECT page_set_id
12217: FROM CZ_UI_PAGE_REFS
12218: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12219: target_persistent_node_id=p_ui_node.persistent_node_id AND
12220: deleted_flag=G_NO_FLAG)
12221: LOOP
12219: target_persistent_node_id=p_ui_node.persistent_node_id AND
12220: deleted_flag=G_NO_FLAG)
12221: LOOP
12222: l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);
12223: UPDATE CZ_UI_PAGE_REFS
12224: SET target_path=l_target_path
12225: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12226: target_persistent_node_id=p_ui_node.persistent_node_id AND
12227: deleted_flag=G_NO_FLAG AND
12237: l_persistent_node_id NUMBER;
12238: l_max_seq_nbr NUMBER;
12239: l_ps_node_type NUMBER;
12240: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12241: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12242: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12243: l_instantiable_flag CZ_UI_PAGE_ELEMENTS.instantiable_flag%TYPE;
12244: l_template_id NUMBER;
12245: l_template_ui_def_id NUMBER;
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
12301:
12699: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%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:
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
12860: l_ui_node.name,
12861: l_ui_node.deleted_flag);
12862:
12863: SELECT NVL(MAX(seq_nbr),0) INTO l_seq_nbr
12864: FROM CZ_UI_PAGE_REFS
12865: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12866: target_persistent_node_id=l_ui_node.persistent_node_id AND
12867: deleted_flag=G_NO_FLAG;
12868:
12865: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12866: target_persistent_node_id=l_ui_node.persistent_node_id AND
12867: deleted_flag=G_NO_FLAG;
12868:
12869: UPDATE CZ_UI_PAGE_REFS
12870: SET seq_nbr=seq_nbr+1
12871: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12872: parent_page_ref_id = (SELECT parent_page_ref_id
12873: FROM CZ_UI_PAGE_REFS
12869: UPDATE CZ_UI_PAGE_REFS
12870: SET seq_nbr=seq_nbr+1
12871: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12872: parent_page_ref_id = (SELECT parent_page_ref_id
12873: FROM CZ_UI_PAGE_REFS
12874: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12875: target_page_id=p_page_id AND
12876: deleted_flag=G_NO_FLAG) AND
12877: seq_nbr > l_seq_nbr AND
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,
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,
12887: parent_page_ref_id,
12923: path_to_next_page,
12924: page_ref_type,
12925: target_expl_node_id,
12926: deleted_flag
12927: FROM CZ_UI_PAGE_REFS
12928: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12929: target_page_id=p_page_id AND
12930: deleted_flag=G_NO_FLAG;
12931:
13292: split_Page(i, l_max_controls_per_page);
13293: END LOOP;
13294:
13295: IF g_UI_Context.PRIMARY_NAVIGATION=G_MODEL_TREE_MENU THEN
13296: SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS
13297: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13298: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13299: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13300: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;
13301: IF l_num_if_roots > 1 THEN
13302:
13303: SELECT target_persistent_node_id,page_set_id,page_ref_type
13304: INTO l_target_persistent_node_id,l_page_set_id,l_page_set_type
13305: FROM CZ_UI_PAGE_REFS
13306: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
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;
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,
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,
13316: page_ref_id,
13317: parent_page_ref_id,
13354: NULL,
13355: NULL,
13356: G_NO_FLAG);
13357:
13358: UPDATE CZ_UI_PAGE_REFS
13359: SET parent_page_ref_id=l_page_ref_id
13360: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL AND
13361: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13362: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13429: l_xmldoc xmldom.DOMDocument;
13430: l_counter NUMBER:=0;
13431: l_seq_nbr NUMBER;
13432: l_show_train BOOLEAN := FALSE;
13433: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
13434: l_page_ref_id NUMBER;
13435:
13436: PROCEDURE set_Page_Flow_(p_page_ref_id IN VARCHAR2) IS
13437: BEGIN
13435:
13436: PROCEDURE set_Page_Flow_(p_page_ref_id IN VARCHAR2) IS
13437: BEGIN
13438: FOR i IN(SELECT page_ref_id,target_page_id,empty_page_flag,
13439: NVL(modified_flags,0) AS modified_flags FROM CZ_UI_PAGE_REFS
13440: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13441: parent_page_ref_id=p_page_ref_id AND
13442: target_page_id IN
13443: (SELECT page_id FROM CZ_UI_PAGES
13449: LOOP
13450: l_counter := l_counter + 1;
13451:
13452: IF i.modified_flags = 0 THEN
13453: UPDATE CZ_UI_PAGE_REFS
13454: SET seq_nbr = l_counter
13455: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13456: page_ref_id=i.page_ref_id;
13457: END IF;
13469: deleted_flag=G_NO_FLAG)
13470: LOOP
13471: l_counter := 0;
13472: FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
13473: NVL(modified_flags,0) AS MODIFIED_FLAGS FROM CZ_UI_PAGE_REFS
13474: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13475: parent_page_ref_id IS NULL AND
13476: page_set_id=n.page_set_id AND
13477: target_page_id IN
13505: LOOP
13506:
13507: FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
13508: target_persistent_node_id, target_expl_node_id
13509: FROM CZ_UI_PAGE_REFS
13510: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13511: parent_page_ref_id IS NULL AND
13512: page_set_id=n.page_set_id AND
13513: target_page_id IN
13526: IF l_target_path IS NULL THEN
13527: l_target_path := '.';
13528: END IF;
13529:
13530: UPDATE CZ_UI_PAGE_REFS
13531: SET target_path=l_target_path
13532: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13533: page_set_id=n.page_set_id AND
13534: target_persistent_node_id=m.target_persistent_node_id AND
13998: -- which have no UI content in it
13999: --
14000: FOR i IN(SELECT page_ref_id,
14001: target_page_id,target_persistent_node_id,
14002: NVL(empty_page_flag,G_NO_FLAG) AS empty_page_flag FROM CZ_UI_PAGE_REFS
14003: WHERE ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG AND
14004: target_page_id IN(SELECT page_id FROM CZ_UI_PAGES
14005: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14006: NVL(suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG AND
14011: l_empty_page := is_Empty_Page(i.target_page_id);
14012:
14013: IF NVL(i.empty_page_flag,G_NO_FLAG)=G_NO_FLAG AND l_empty_page THEN
14014:
14015: UPDATE CZ_UI_PAGE_REFS
14016: SET empty_page_flag=G_YES_FLAG
14017: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14018: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14019:
14025: END IF;
14026:
14027: ELSIF i.empty_page_flag=G_YES_FLAG AND l_empty_page=FALSE THEN
14028:
14029: UPDATE CZ_UI_PAGE_REFS
14030: SET empty_page_flag=G_NO_FLAG
14031: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14032: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14033:
14050: l_split_seq_nbr NUMBER;
14051:
14052: PROCEDURE set_Page_Ref_Order_(p_page_ref_id IN VARCHAR2) IS
14053: BEGIN
14054: FOR i IN(SELECT page_ref_id FROM CZ_UI_PAGE_REFS a
14055: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14056: parent_page_ref_id=p_page_ref_id AND
14057: EXISTS
14058: (SELECT NULL FROM CZ_UI_PAGES
14059: WHERE page_id=a.target_page_id AND ui_def_id=g_UI_Context.ui_def_id) AND
14060: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG) ORDER BY seq_nbr)
14061: LOOP
14062: l_counter := l_counter + 1;
14063: UPDATE CZ_UI_PAGE_REFS
14064: SET seq_nbr = l_counter
14065: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14066: page_ref_id=i.page_ref_id;
14067: set_Page_Ref_Order_(i.page_ref_id);
14068: END LOOP;
14069: END set_Page_Ref_Order_;
14070:
14071: BEGIN
14072: FOR i IN(SELECT page_ref_id,target_page_id,target_persistent_node_id FROM CZ_UI_PAGE_REFS
14073: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14074: page_set_id=p_page_set_id AND
14075: parent_page_ref_id IS NULL AND
14076: deleted_flag=G_NO_FLAG)
14080: WHERE page_id=i.target_page_id AND
14081: ui_def_id=g_UI_Context.ui_def_id;
14082:
14083: IF l_split_seq_nbr > 1 THEN
14084: UPDATE CZ_UI_PAGE_REFS
14085: SET seq_nbr = l_split_seq_nbr
14086: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14087: page_ref_id=i.page_ref_id;
14088: l_counter := l_split_seq_nbr;
14086: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14087: page_ref_id=i.page_ref_id;
14088: l_counter := l_split_seq_nbr;
14089: ELSE
14090: UPDATE CZ_UI_PAGE_REFS
14091: SET seq_nbr = 1
14092: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14093: page_ref_id=i.page_ref_id;
14094: SELECT MAX(split_seq_nbr) INTO l_counter FROM CZ_UI_PAGES
14503: l_max_prev_seq_nbr NUMBER;
14504: l_max_src_seq_nbr NUMBER;
14505: l_src_range NUMBER;
14506: l_atleast_one_parent_found BOOLEAN;
14507: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
14508: l_pagebase_expl_node_id CZ_UI_PAGES.pagebase_expl_node_id%TYPE;
14509: l_node_is_reachable NUMBER := -1;
14510: l_model_ref_expl_id NUMBER;
14511: l_count NUMBER;
14523: -- This is a reference node and it has been moved. Reference nodes will not have pages
14524: -- in this UI which are in the tree. So have to deal with page_refs for references
14525: -- explicitly
14526: FOR i in (SELECT *
14527: FROM CZ_UI_PAGE_REFS
14528: WHERE ui_def_id = g_UI_Context.ui_def_id
14529: AND page_set_id = g_UI_Context.page_set_id
14530: AND target_ui_def_id IS NOT NULL
14531: AND target_persistent_node_id = p_ps_node.persistent_node_id)
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;
14806: l_count NUMBER;
14815:
14816: BEGIN
14817:
14818: SELECT min(seq_nbr), count(*) INTO l_old_seq_nbr, l_count
14819: FROM CZ_UI_PAGE_REFS
14820: WHERE ui_def_id = g_UI_Context.ui_def_id
14821: AND page_set_id = l_page_set_id
14822: AND target_persistent_node_id = p_ps_node.persistent_node_id
14823: AND deleted_flag = G_NO_FLAG;
14822: AND target_persistent_node_id = p_ps_node.persistent_node_id
14823: AND deleted_flag = G_NO_FLAG;
14824:
14825: SELECT * INTO l_page_ref
14826: FROM CZ_UI_PAGE_REFS
14827: WHERE ui_def_id = g_UI_Context.ui_def_id
14828: AND page_set_id = l_page_set_id
14829: AND target_persistent_node_id = p_ps_node.persistent_node_id
14830: AND deleted_flag = G_NO_FLAG
14851: END IF;
14852:
14853: --DEBUG('asp: l_range_min: ' || l_range_min || ', l_range_max ' || l_range_max);
14854:
14855: UPDATE CZ_UI_PAGE_REFS
14856: SET seq_nbr = seq_nbr - l_count
14857: WHERE ui_def_id = g_UI_Context.ui_def_id
14858: AND page_set_id = l_page_set_id
14859: AND parent_page_ref_id = l_page_ref.parent_page_ref_id
14862: AND seq_nbr between l_range_min and l_range_max;
14863:
14864: l_diff := l_new_seq_nbr - l_old_seq_nbr;
14865:
14866: UPDATE CZ_UI_PAGE_REFS
14867: SET seq_nbr = seq_nbr + l_diff
14868: WHERE ui_def_id = g_UI_Context.ui_def_id
14869: AND page_set_id = l_page_set_id
14870: AND parent_page_ref_id = l_page_ref.parent_page_ref_id
17823: l_xml_node xmldom.DOMNode;
17824: l_element_id_tbl varchar_tbl_type;
17825: l_out_node xmldom.DOMNode;
17826: l_parent_node xmldom.DOMNode;
17827: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
17828: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
17829: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
17830: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
17831: l_ui_context CZ_UI_DEFS%ROWTYPE;
17826: l_parent_node xmldom.DOMNode;
17827: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
17828: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
17829: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
17830: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
17831: l_ui_context CZ_UI_DEFS%ROWTYPE;
17832: l_condition_id NUMBER;
17833: l_caption_text_id NUMBER;
17834: l_caption_rule_id NUMBER;
17880:
17881: IF l_parent_element_id IS NULL OR p_element_id=G_NO_FLAG THEN -- this is UI page ( and it should be deleted )
17882:
17883: FOR i IN(SELECT page_ref_id,page_ref_type,page_set_id,condition_id,caption_text_id,caption_rule_id
17884: FROM CZ_UI_PAGE_REFS
17885: WHERE ui_def_id=p_ui_def_id AND target_page_id=p_ui_page_id AND deleted_flag=G_NO_FLAG)
17886: LOOP
17887:
17888: UPDATE CZ_LOCALIZED_TEXTS
17895: WHERE persistent_rule_id IN(i.condition_id,i.caption_rule_id) AND
17896: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17897:
17898: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN
17899: UPDATE CZ_UI_PAGE_REFS
17900: SET deleted_flag=G_YES_FLAG
17901: WHERE ui_def_id=p_ui_def_id
17902: AND deleted_flag=G_NO_FLAG
17903: AND (ui_def_id,page_ref_id,page_set_id) IN
17900: SET deleted_flag=G_YES_FLAG
17901: WHERE ui_def_id=p_ui_def_id
17902: AND deleted_flag=G_NO_FLAG
17903: AND (ui_def_id,page_ref_id,page_set_id) IN
17904: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
17905: START WITH a.ui_def_id=p_ui_def_id AND
17906: a.page_ref_id=i.page_ref_id
17907: CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
17908: a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND
17909: PRIOR a.ui_def_id=p_ui_def_id AND
17910: a.page_set_id=i.page_set_id AND
17911: PRIOR a.page_set_id=i.page_set_id);
17912: ELSE
17913: UPDATE CZ_UI_PAGE_REFS
17914: SET deleted_flag=G_YES_FLAG
17915: WHERE ui_def_id=p_ui_def_id AND page_ref_id=i.page_ref_id;
17916: END IF;
17917:
18095: x_msg_count OUT NOCOPY NUMBER, -- number of error messages
18096: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
18097: ) IS
18098:
18099: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
18100: l_ui_context CZ_UI_DEFS%ROWTYPE;
18101: l_page_id CZ_UI_PAGES.page_id%TYPE;
18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
18103: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18099: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
18100: l_ui_context CZ_UI_DEFS%ROWTYPE;
18101: l_page_id CZ_UI_PAGES.page_id%TYPE;
18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
18103: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18104:
18105: BEGIN
18106:
18107: --
18117: l_ui_context := get_UI_Context(p_ui_def_id => p_ui_def_id);
18118:
18119: SELECT page_set_id, page_ref_type
18120: INTO l_page_set_id, l_page_ref_type
18121: FROM CZ_UI_PAGE_REFS
18122: WHERE ui_def_id=p_ui_def_id AND page_ref_id=p_page_ref_id
18123: AND deleted_flag=G_NO_FLAG;
18124:
18125: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN
18122: WHERE ui_def_id=p_ui_def_id AND page_ref_id=p_page_ref_id
18123: AND deleted_flag=G_NO_FLAG;
18124:
18125: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN
18126: UPDATE CZ_UI_PAGE_REFS
18127: SET deleted_flag=G_YES_FLAG
18128: WHERE ui_def_id=p_ui_def_id
18129: AND deleted_flag=G_NO_FLAG
18130: AND (ui_def_id,page_ref_id,page_set_id) IN
18127: SET deleted_flag=G_YES_FLAG
18128: WHERE ui_def_id=p_ui_def_id
18129: AND deleted_flag=G_NO_FLAG
18130: AND (ui_def_id,page_ref_id,page_set_id) IN
18131: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
18132: START WITH a.ui_def_id=p_ui_def_id AND
18133: a.page_ref_id=p_page_ref_id
18134: CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
18135: a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND
18136: PRIOR a.ui_def_id=p_ui_def_id AND
18137: a.page_set_id=l_page_set_id AND
18138: PRIOR a.page_set_id=l_page_set_id);
18139: ELSE
18140: UPDATE CZ_UI_PAGE_REFS
18141: SET deleted_flag=G_YES_FLAG
18142: WHERE ui_def_id=p_ui_def_id
18143: AND page_ref_id=p_page_ref_id;
18144: END IF;
18144: END IF;
18145:
18146: --
18147: -- null out CZ_UI_PAGES.page_set_id for those UI pages in this UI
18148: -- which have no corresponding records in CZ_UI_PAGE_REFS
18149: --
18150: UPDATE CZ_UI_PAGES a
18151: SET page_set_id=NULL
18152: WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND
18149: --
18150: UPDATE CZ_UI_PAGES a
18151: SET page_set_id=NULL
18152: WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND
18153: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_REFS b
18154: WHERE b.ui_def_id=p_ui_def_id AND target_page_id=a.page_id AND
18155: deleted_flag='0');
18156:
18157: IF l_page_ref_type IN( G_PAGE_FLOW, G_SUBTABS) THEN
18612: empty_page_flag = G_NO_FLAG
18613: WHERE page_id=p_target_ui_page_id AND
18614: ui_def_id=p_target_ui_def_id;
18615:
18616: UPDATE CZ_UI_PAGE_REFS
18617: SET empty_page_flag = G_NO_FLAG
18618: WHERE target_page_id=p_target_ui_page_id AND
18619: ui_def_id=p_target_ui_def_id AND
18620: deleted_flag = G_NO_FLAG AND
18908: --
18909: Initialize(x_return_status,x_msg_count,x_msg_data);
18910:
18911: SELECT page_set_id,node_depth INTO l_target_page_set_id,l_target_node_depth
18912: FROM CZ_UI_PAGE_REFS
18913: WHERE ui_def_id=p_target_ui_def_id AND page_ref_id=p_target_parent_page_ref_id;
18914:
18915: SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS
18916: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;
18911: SELECT page_set_id,node_depth INTO l_target_page_set_id,l_target_node_depth
18912: FROM CZ_UI_PAGE_REFS
18913: WHERE ui_def_id=p_target_ui_def_id AND page_ref_id=p_target_parent_page_ref_id;
18914:
18915: SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS
18916: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;
18917:
18918: SELECT page_ref_id,parent_page_ref_id,node_depth,seq_nbr
18919: BULK COLLECT INTO l_page_ref_id_tbl,l_parent_page_ref_id_tbl,l_node_depth_tbl,l_seq_nbr_tbl
18916: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;
18917:
18918: SELECT page_ref_id,parent_page_ref_id,node_depth,seq_nbr
18919: BULK COLLECT INTO l_page_ref_id_tbl,l_parent_page_ref_id_tbl,l_node_depth_tbl,l_seq_nbr_tbl
18920: FROM CZ_UI_PAGE_REFS
18921: START WITH ui_def_id=p_source_ui_def_id AND page_ref_id=p_source_page_ref_id
18922: CONNECT BY PRIOR ui_def_id=p_source_ui_def_id AND
18923: ui_def_id=p_source_ui_def_id AND
18924: PRIOR page_ref_id=parent_page_ref_id AND
18948: l_new_parent_page_ref_id := p_target_parent_page_ref_id;
18949: x_page_ref_id := l_new_page_ref_id;
18950: END IF;
18951:
18952: FOR i IN(SELECT * FROM CZ_UI_PAGE_REFS
18953: WHERE ui_def_id=p_source_ui_def_id AND
18954: page_ref_id=l_current_page_ref_id AND
18955: deleted_flag=G_NO_FLAG)
18956: LOOP
18966:
18967: l_caption_text_id := copy_Intl_Text(l_caption_text_id, p_target_ui_def_id,
18968: NULL, NULL);
18969:
18970: INSERT INTO CZ_UI_PAGE_REFS
18971: (
18972: PAGE_SET_ID
18973: ,UI_DEF_ID
18974: ,PAGE_REF_ID
20557: ) IS
20558:
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;
20558:
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;
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;
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;
20568: l_page_set_type NUMBER;
20588: IF l_target_primary_navigation <> G_MODEL_TREE_MENU THEN
20589:
20590: --
20591: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
20592: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
20593: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
20594: --
20595: UPDATE CZ_UI_PAGE_REFS
20596: SET deleted_flag=G_YES_FLAG
20589:
20590: --
20591: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
20592: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
20593: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
20594: --
20595: UPDATE CZ_UI_PAGE_REFS
20596: SET deleted_flag=G_YES_FLAG
20597: WHERE ui_def_id=p_ui_def_id AND
20591: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
20592: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
20593: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
20594: --
20595: UPDATE CZ_UI_PAGE_REFS
20596: SET deleted_flag=G_YES_FLAG
20597: WHERE ui_def_id=p_ui_def_id AND
20598: target_persistent_node_id=p_ref_persistent_node_id AND
20599: deleted_flag=G_NO_FLAG;
20615: WHERE ps_node_id=l_ref_parent_id AND
20616: deleted_flag=G_NO_FLAG;
20617:
20618: FOR i IN(SELECT page_ref_id,node_depth,page_set_id,page_ref_type, seq_nbr
20619: FROM CZ_UI_PAGE_REFS
20620: WHERE ui_def_id=p_ui_def_id AND
20621: target_persistent_node_id=l_ref_parent_persist_node_id AND
20622: page_ref_type=G_MODEL_TREE_MENU AND
20623: deleted_flag=G_NO_FLAG)
20626: IF (i.node_depth <> 0 AND i.seq_nbr <> 0) THEN
20627: --
20628: -- update target_ui_def_id and target_page_set_id
20629: --
20630: UPDATE CZ_UI_PAGE_REFS
20631: SET target_ui_def_id=p_new_target_ui_def_id,
20632: target_page_set_id=l_target_page_set_id
20633: WHERE ui_def_id=p_ui_def_id AND
20634: parent_page_ref_id=i.page_ref_id AND
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
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
20645: FROM CZ_UI_PAGE_REFS
20646: WHERE ui_def_id=p_ui_def_id AND
20647: parent_page_ref_id=i.page_ref_id AND
20648: deleted_flag=G_NO_FLAG;
20649:
20651: WHERE model_id=g_UI_Context.devl_project_id AND
20652: referring_node_id=p_ref_persistent_node_id AND
20653: deleted_flag=G_NO_FLAG;
20654:
20655: INSERT INTO CZ_UI_PAGE_REFS
20656: (ui_def_id,
20657: page_set_id,
20658: page_ref_id,
20659: parent_page_ref_id,
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: