eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_REFS

Line 282: TYPE ui_page_refs_tbl_type IS TABLE OF CZ_UI_PAGE_REFS%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:
285: TYPE varchar2_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY VARCHAR2(255);
286:

Line 729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;

725:
726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
727: g_currUISeqVal := g_currentUINode;
728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;
731:
732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
733: g_currPageSeqVal := g_currentPage;

Line 1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN

1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1023: g_currentUINode := g_currUISeqVal;
1024: END IF;
1025: RETURN g_currentUINode;
1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1027: IF g_currentPageRef 1028: g_currentPageRef := g_currentPageRef+1;
1029: ELSE
1030: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;

Line 1030: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;

1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1027: IF g_currentPageRef 1028: g_currentPageRef := g_currentPageRef+1;
1029: ELSE
1030: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currPageRefSeqVal FROM dual;
1031: g_currentPageRef := g_currPageRefSeqVal;
1032: END IF;
1033: RETURN g_currentPageRef;
1034: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN

Line 2374: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS

2370: --
2371: -- return page_ref node of nearest page
2372: --
2373: FUNCTION get_UI_Page_Ref_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2374: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS
2375:
2376: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
2377:
2378: BEGIN

Line 2376: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

2372: --
2373: FUNCTION get_UI_Page_Ref_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2374: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS
2375:
2376: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
2377:
2378: BEGIN
2379:
2380: IF p_ui_node.page_id IS NULL THEN

Line 2386: FROM CZ_UI_PAGE_REFS a

2382: END IF;
2383:
2384: SELECT *
2385: INTO l_page_ref_node
2386: FROM CZ_UI_PAGE_REFS a
2387: WHERE ui_def_id = p_ui_node.ui_def_id AND
2388: (target_page_id,page_set_id) IN
2389: (SELECT page_id,NVL(page_set_id,a.page_set_id) FROM CZ_UI_PAGES
2390: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id AND

Line 2423: SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS

2419: IF l_page_set_node.persistent_node_id IS NOT NULL THEN
2420: l_persistent_node_id := l_page_set_node.persistent_node_id;
2421: ELSE
2422: BEGIN
2423: SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS
2424: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2425: AND deleted_flag=G_NO_FLAG;
2426:
2427: SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS

Line 2427: SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS

2423: SELECT MIN(node_depth) INTO l_node_depth FROM CZ_UI_PAGE_REFS
2424: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2425: AND deleted_flag=G_NO_FLAG;
2426:
2427: SELECT MIN(SEQ_NBR) INTO l_seq_nbr FROM CZ_UI_PAGE_REFS
2428: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2429: AND node_depth=l_node_depth AND deleted_flag=G_NO_FLAG;
2430:
2431: SELECT DISTINCT target_persistent_node_id INTO l_persistent_node_id

Line 2432: FROM CZ_UI_PAGE_REFS

2428: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2429: AND node_depth=l_node_depth AND deleted_flag=G_NO_FLAG;
2430:
2431: SELECT DISTINCT target_persistent_node_id INTO l_persistent_node_id
2432: FROM CZ_UI_PAGE_REFS
2433: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2434: AND seq_nbr=l_seq_nbr AND
2435: target_persistent_node_id NOT IN
2436: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE

Line 3100: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

3096: --
3097: PROCEDURE merge_Page_Flows(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3098: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3099: l_changed_target_ids_tbl number_tbl_type;
3100: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3101: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3102: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3103: l_child_page_set_id NUMBER;
3104: l_child_page_ref_id NUMBER;

Line 3101: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

3097: PROCEDURE merge_Page_Flows(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3098: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3099: l_changed_target_ids_tbl number_tbl_type;
3100: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3101: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3102: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3103: l_child_page_set_id NUMBER;
3104: l_child_page_ref_id NUMBER;
3105: l_parent_page_set_id NUMBER;

Line 3127: FROM CZ_UI_PAGE_REFS

3123: -- get Page set id and page_ref_id of parent Page Flow
3124: --
3125: SELECT MIN(page_ref_id)
3126: INTO l_parent_page_ref_id
3127: FROM CZ_UI_PAGE_REFS
3128: WHERE ui_def_id=p_ui_node.ui_def_id AND
3129: target_persistent_node_id=p_ui_node.parent_persistent_node_id AND
3130: deleted_flag=G_NO_FLAG;
3131:

Line 3133: INTO l_parent_page_set_id,l_page_ref_type FROM CZ_UI_PAGE_REFS

3129: target_persistent_node_id=p_ui_node.parent_persistent_node_id AND
3130: deleted_flag=G_NO_FLAG;
3131:
3132: SELECT page_set_id,page_ref_type
3133: INTO l_parent_page_set_id,l_page_ref_type FROM CZ_UI_PAGE_REFS
3134: WHERE ui_def_id=p_ui_node.ui_def_id AND page_ref_id=l_parent_page_ref_id;
3135:
3136: --
3137: -- attach child Page Flow to the parent Page Flow

Line 3139: UPDATE CZ_UI_PAGE_REFS

3135:
3136: --
3137: -- attach child Page Flow to the parent Page Flow
3138: --
3139: UPDATE CZ_UI_PAGE_REFS
3140: SET parent_page_ref_id = l_parent_page_ref_id
3141: WHERE ui_def_id=p_ui_node.ui_def_id AND
3142: page_ref_id=l_child_page_ref_id;
3143:

Line 3144: UPDATE CZ_UI_PAGE_REFS

3140: SET parent_page_ref_id = l_parent_page_ref_id
3141: WHERE ui_def_id=p_ui_node.ui_def_id AND
3142: page_ref_id=l_child_page_ref_id;
3143:
3144: UPDATE CZ_UI_PAGE_REFS
3145: SET page_set_id = l_parent_page_set_id
3146: WHERE ui_def_id=p_ui_node.ui_def_id AND
3147: target_page_id IN
3148: (SELECT target_page_id FROM CZ_UI_PAGE_REFS

Line 3148: (SELECT target_page_id FROM CZ_UI_PAGE_REFS

3144: UPDATE CZ_UI_PAGE_REFS
3145: SET page_set_id = l_parent_page_set_id
3146: WHERE ui_def_id=p_ui_node.ui_def_id AND
3147: target_page_id IN
3148: (SELECT target_page_id FROM CZ_UI_PAGE_REFS
3149: START WITH ui_def_id=p_ui_node.ui_def_id AND
3150: page_ref_id=l_child_page_ref_id
3151: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
3152: ui_def_id=p_ui_node.ui_def_id AND

Line 3170: UPDATE CZ_UI_PAGE_REFS

3166:
3167: -- IF l_page_ref_type IN(G_PAGE_FLOW,G_SUBTABS) THEN
3168: l_model_node := get_Model_Node_By_Persist_Id(l_changed_target_ids_tbl(x), g_UI_Context.devl_project_id);
3169: l_target_path := get_Page_Path(l_model_node.ps_node_id, l_parent_page_set_id);
3170: UPDATE CZ_UI_PAGE_REFS
3171: SET target_path=l_target_path
3172: WHERE ui_def_id=p_ui_node.ui_def_id AND
3173: page_set_id=l_parent_page_set_id AND
3174: target_persistent_node_id=l_changed_target_ids_tbl(x) AND

Line 3190: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

3186: PROCEDURE split_Page_Flow(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3187: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3188: l_changed_target_ids_tbl number_tbl_type;
3189: l_target_page_ids_tbl number_tbl_type;
3190: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3191: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3192: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3193: l_page_set_type NUMBER;
3194: l_initial_page_set_id NUMBER;

Line 3191: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

3187: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3188: l_changed_target_ids_tbl number_tbl_type;
3189: l_target_page_ids_tbl number_tbl_type;
3190: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3191: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3192: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3193: l_page_set_type NUMBER;
3194: l_initial_page_set_id NUMBER;
3195: l_initial_page_ref_id NUMBER;

Line 3230: UPDATE CZ_UI_PAGE_REFS

3226: p_persistent_node_id => p_ui_node.persistent_node_id,
3227: p_model_ref_expl_id => p_ui_node.model_ref_expl_id,
3228: x_page_set_id => l_page_set_id);
3229:
3230: UPDATE CZ_UI_PAGE_REFS
3231: SET target_path='.',
3232: parent_page_ref_id=NULL,
3233: node_depth=1,
3234: seq_nbr=1

Line 3238: UPDATE CZ_UI_PAGE_REFS

3234: seq_nbr=1
3235: WHERE ui_def_id=p_ui_node.ui_def_id AND
3236: page_ref_id=l_initial_page_ref_id;
3237:
3238: UPDATE CZ_UI_PAGE_REFS
3239: SET page_set_id = l_page_set_id
3240: WHERE ui_def_id=p_ui_node.ui_def_id AND
3241: target_persistent_node_id IN
3242: (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS

Line 3242: (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS

3238: UPDATE CZ_UI_PAGE_REFS
3239: SET page_set_id = l_page_set_id
3240: WHERE ui_def_id=p_ui_node.ui_def_id AND
3241: target_persistent_node_id IN
3242: (SELECT target_persistent_node_id FROM CZ_UI_PAGE_REFS
3243: START WITH ui_def_id=p_ui_node.ui_def_id AND
3244: page_ref_id=l_initial_page_ref_id
3245: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
3246: ui_def_id=p_ui_node.ui_def_id AND

Line 3265: UPDATE CZ_UI_PAGE_REFS

3261:
3262: l_model_node := get_Model_Node_By_Persist_Id(l_changed_target_ids_tbl(j), g_UI_Context.devl_project_id);
3263: l_target_path := get_Page_Path(l_model_node.ps_node_id, l_page_set_id);
3264:
3265: UPDATE CZ_UI_PAGE_REFS
3266: SET target_path=l_target_path
3267: WHERE ui_def_id=p_ui_node.ui_def_id AND
3268: page_set_id=l_page_set_id AND
3269: target_persistent_node_id=l_changed_target_ids_tbl(j) AND

Line 3414: UPDATE CZ_UI_PAGE_REFS

3410: AND deleted_flag=G_NO_FLAG;
3411: END IF;
3412: END IF;
3413:
3414: UPDATE CZ_UI_PAGE_REFS
3415: SET target_expl_node_id=p_expl_id
3416: WHERE ui_def_id=p_ui_node.ui_def_id AND
3417: target_persistent_node_id=p_node.persistent_node_id;
3418:

Line 3606: FROM CZ_UI_PAGE_REFS

3602: END;
3603: END LOOP;
3604:
3605: FOR i IN (SELECT *
3606: FROM CZ_UI_PAGE_REFS
3607: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3608: deleted_flag = G_NO_FLAG)
3609: LOOP
3610: g_ui_page_refs_tbl(i.page_ref_id) := i;

Line 9114: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

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:
9118: BEGIN

Line 10675: FROM CZ_UI_PAGE_REFS

10671: BEGIN
10672:
10673: SELECT MIN(page_ref_id)
10674: INTO x_parent_page_ref_id
10675: FROM CZ_UI_PAGE_REFS
10676: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10677: NVL(page_set_id,-1)=NVL(x_page_set_id,-1) AND
10678: target_page_id=x_page_id AND deleted_flag=G_NO_FLAG;
10679:

Line 10681: FROM CZ_UI_PAGE_REFS

10677: NVL(page_set_id,-1)=NVL(x_page_set_id,-1) AND
10678: target_page_id=x_page_id AND deleted_flag=G_NO_FLAG;
10679:
10680: SELECT node_depth,page_ref_type INTO x_parent_node_depth, x_parent_page_set_type
10681: FROM CZ_UI_PAGE_REFS
10682: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10683: page_ref_id=x_parent_page_ref_id;
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN

Line 10718: FROM CZ_UI_PAGE_REFS

10714: --DEBUG('asp: Getting seq_nbr for ps node ' || p_node.name);
10715:
10716: IF NOT g_using_new_UI_refresh THEN
10717: SELECT COUNT(*)+1 INTO l_seq_nbr
10718: FROM CZ_UI_PAGE_REFS
10719: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10720: page_set_id = p_page_set_id AND
10721: parent_page_ref_id=p_parent_page_ref_id AND
10722: deleted_flag=G_NO_FLAG;

Line 10744: FROM CZ_UI_PAGE_REFS

10740: LOOP
10741: --DEBUG('asp: predecessor persistent_node_id = ' || l_predecessor_persistent_id);
10742:
10743: SELECT NVL(max(seq_nbr), 0) INTO l_seq_nbr
10744: FROM CZ_UI_PAGE_REFS
10745: WHERE ui_def_id = g_UI_Context.ui_def_id
10746: AND page_set_id = p_page_set_id
10747: AND parent_page_ref_id = p_parent_page_ref_id
10748: AND target_persistent_node_id = j.persistent_node_id

Line 10760: -- node of the predecesors found in cz_ui_page_refs

10756: END IF;
10757: END LOOP;
10758: END LOOP;
10759:
10760: -- node of the predecesors found in cz_ui_page_refs
10761: RETURN 1;
10762:
10763: EXCEPTION
10764: WHEN NO_DATA_FOUND THEN

Line 10767: FROM CZ_UI_PAGE_REFS

10763: EXCEPTION
10764: WHEN NO_DATA_FOUND THEN
10765: -- seq_nbrs in cz_ps_nodes are not correct
10766: SELECT NVL(count(*), 0) + 1 INTO l_seq_nbr
10767: FROM CZ_UI_PAGE_REFS
10768: WHERE ui_def_id = g_UI_Context.ui_def_Id
10769: AND page_set_id = p_page_set_id
10770: AND parent_page_ref_id = p_parent_page_ref_id
10771: AND deleted_flag = G_NO_FLAG;

Line 10792: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

10788:
10789: l_page_node CZ_UI_PAGES%ROWTYPE;
10790: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10791: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10792: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10793: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10795: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10796: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;

Line 10793: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

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

Line 10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

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

Line 10795: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;

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

Line 10801: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%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;
10804: l_parent_page_persistent_id NUMBER;
10805: l_page_counter NUMBER;

Line 11090: -- create a new record for this UI page in CZ_UI_PAGE_REFS

11086: /******** attach new UI Page to Page Set *********************/
11087: BEGIN
11088:
11089: --
11090: -- create a new record for this UI page in CZ_UI_PAGE_REFS
11091: --
11092: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
11093:
11094: l_ref_pagebase_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);

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

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

Line 11099: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND

11095:
11096: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN
11097:
11098: SELECT COUNT(*)+1 INTO l_seq_nbr
11099: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
11100: deleted_flag=G_NO_FLAG;
11101:
11102: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
11103:

Line 11107: UPDATE CZ_UI_PAGE_REFS

11103:
11104:
11105: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_set_id, l_parent_page_ref_id);
11106:
11107: UPDATE CZ_UI_PAGE_REFS
11108: SET seq_nbr = seq_nbr + 1
11109: WHERE ui_def_id = g_UI_Context.ui_def_id
11110: AND page_set_id = l_page_set_id
11111: AND parent_page_ref_id = l_parent_page_ref_id

Line 11121: INSERT INTO CZ_UI_PAGE_REFS

11117: l_seq_nbr :=p_node.tree_seq;
11118: END IF;
11119: END IF;
11120:
11121: INSERT INTO CZ_UI_PAGE_REFS
11122: (ui_def_id,
11123: page_set_id,
11124: page_ref_id,
11125: parent_page_ref_id,

Line 11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

11340: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
11341: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;

Line 11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

Line 11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
11352: l_counter NUMBER;
11353: l_persistent_node_id NUMBER;
11354: l_seq_nbr NUMBER;

Line 11599: -- create a new record for this UI page in CZ_UI_PAGE_REFS

11595: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
11596: LOOP
11597:
11598: --
11599: -- create a new record for this UI page in CZ_UI_PAGE_REFS
11600: --
11601: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
11602:
11603: IF l_target_ui_def_node.start_page_id=-1 THEN

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

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

Line 11620: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND

11616: l_target_path := get_Page_Path(p_node.ps_node_id,l_page_ref_node.page_set_id);
11617:
11618: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_LEVEL_MENU) THEN
11619: SELECT COUNT(*)+1 INTO l_seq_nbr
11620: FROM CZ_UI_PAGE_REFS WHERE ui_def_id=g_UI_Context.ui_def_id AND
11621: deleted_flag=G_NO_FLAG;
11622: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
11623:
11624: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_ref_node.page_set_id, l_page_ref_node.page_ref_id);

Line 11626: UPDATE CZ_UI_PAGE_REFS

11622: ELSIF g_UI_Context.PRIMARY_NAVIGATION IN(G_MODEL_TREE_MENU) THEN
11623:
11624: l_seq_nbr := get_new_page_ref_seq(p_node, l_page_ref_node.page_set_id, l_page_ref_node.page_ref_id);
11625:
11626: UPDATE CZ_UI_PAGE_REFS
11627: SET seq_nbr = seq_nbr + 1
11628: WHERE ui_def_id = g_UI_Context.ui_def_id
11629: AND page_set_id = l_page_ref_node.page_set_id
11630: AND parent_page_ref_id = l_page_ref_node.page_ref_id

Line 11637: INSERT INTO CZ_UI_PAGE_REFS

11633: ELSE
11634: l_seq_nbr :=p_node.tree_seq;
11635: END IF;
11636:
11637: INSERT INTO CZ_UI_PAGE_REFS
11638: (ui_def_id,
11639: page_set_id,
11640: page_ref_id,
11641: parent_page_ref_id,

Line 11771: UPDATE CZ_UI_PAGE_REFS

11767: IF l_del_flag THEN
11768: --
11769: -- delete UI Ref from Page Sets
11770: --
11771: UPDATE CZ_UI_PAGE_REFS
11772: SET deleted_flag = G_YES_FLAG
11773: WHERE ui_def_id=p_ui_node.ui_def_id AND
11774: target_persistent_node_id=p_ui_node.persistent_node_id AND
11775: deleted_flag=G_NO_FLAG AND

Line 11816: FROM CZ_UI_PAGE_REFS

11812:
11813: BEGIN
11814:
11815: SELECT MIN(page_ref_id) INTO l_page_ref_id
11816: FROM CZ_UI_PAGE_REFS
11817: WHERE ui_def_id=p_ui_node.ui_def_id AND
11818: target_page_id=p_ui_node.page_id AND
11819: deleted_flag=G_NO_FLAG;
11820:

Line 11821: UPDATE CZ_UI_PAGE_REFS

11817: WHERE ui_def_id=p_ui_node.ui_def_id AND
11818: target_page_id=p_ui_node.page_id AND
11819: deleted_flag=G_NO_FLAG;
11820:
11821: UPDATE CZ_UI_PAGE_REFS
11822: SET deleted_flag = G_YES_FLAG
11823: WHERE ui_def_id=p_ui_node.ui_def_id AND
11824: page_ref_id=l_page_ref_id
11825: RETURNING parent_page_ref_id,page_set_id,seq_nbr

Line 11832: UPDATE CZ_UI_PAGE_REFS

11828:
11829: --
11830: -- update seq nbr to seq nbr - 1
11831: --
11832: UPDATE CZ_UI_PAGE_REFS
11833: SET seq_nbr = seq_nbr - 1
11834: WHERE ui_def_id=p_ui_node.ui_def_id AND
11835: page_set_id=l_page_set_id AND
11836: parent_page_ref_id = l_parent_page_ref_id AND

Line 12003: UPDATE CZ_UI_PAGE_REFS uiref

11999:
12000: BEGIN
12001:
12002: -- delete UI References
12003: UPDATE CZ_UI_PAGE_REFS uiref
12004: SET deleted_flag=G_YES_FLAG
12005: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
12006: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
12007: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b

Line 12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

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;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;

Line 12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

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

Line 12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;

12027:
12028: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;

Line 12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;

12028: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
12036: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;

12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
12036: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12037:

Line 12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;

12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12031: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
12036: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12037:
12038:

Line 12036: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

12032: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12033: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
12034: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
12036: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12037:
12038:
12039: BEGIN
12040: --

Line 12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;

12055:
12056: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12057: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
12058:
12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12061: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12062: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12063:

Line 12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12056: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12057: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
12058:
12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12061: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12062: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12063:
12064: BEGIN

Line 12061: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

12057: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
12058:
12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12061: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12062: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12063:
12064: BEGIN
12065:

Line 12062: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

12058:
12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12061: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12062: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12063:
12064: BEGIN
12065:
12066: SELECT page_set_id,pagebase_path INTO l_page_set_id,l_old_page_path_from_root FROM CZ_UI_PAGES

Line 12082: UPDATE CZ_UI_PAGE_REFS

12078: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
12079:
12080: IF SQL%ROWCOUNT>0 THEN
12081: --DEBUG('asp: updating target path 3 for page ' || p_page_id || ' to ' || l_target_path);
12082: UPDATE CZ_UI_PAGE_REFS
12083: SET target_path=l_target_path
12084: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12085: target_page_id=p_page_id;
12086: END IF;

Line 12092: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12088:
12089: END replace_page_ref_target_path;
12090:
12091: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12092: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12093: BEGIN
12094:
12095: IF p_node.ps_node_type = G_REFERENCE_TYPE AND
12096: g_UI_Context.primary_navigation = G_MODEL_TREE_MENU THEN

Line 12099: FROM CZ_UI_PAGE_REFS

12095: IF p_node.ps_node_type = G_REFERENCE_TYPE AND
12096: g_UI_Context.primary_navigation = G_MODEL_TREE_MENU THEN
12097:
12098: FOR i in (SELECT page_set_id, page_ref_id
12099: FROM CZ_UI_PAGE_REFS
12100: WHERE ui_def_id = g_UI_Context.ui_def_id
12101: AND target_ui_def_id IS NOT NULL
12102: AND target_page_id IS NOT NULL
12103: AND target_persistent_node_id = p_node.persistent_node_id

Line 12109: UPDATE CZ_UI_PAGE_REFS

12105:
12106: LOOP
12107: l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);
12108: --DEBUG('asp: updating target path 10 for page ref ' || i.page_ref_id || ' to ' || l_target_path);
12109: UPDATE CZ_UI_PAGE_REFS
12110: SET target_path=l_target_path
12111: WHERE ui_def_id=g_UI_Context.ui_def_id
12112: AND page_set_id = i.page_set_id
12113: AND page_ref_id = i.page_ref_id;

Line 12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;

12128:
12129: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12130: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12131:
12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12135: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12136:

Line 12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12129: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12130: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12131:
12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12135: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12136:
12137: BEGIN

Line 12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

12130: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12131:
12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12135: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12136:
12137: BEGIN
12138:

Line 12135: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

12131:
12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12135: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
12136:
12137: BEGIN
12138:
12139: replace_page_ref_target_path(p_node, p_ui_node.page_id);

Line 12143: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,

12139: replace_page_ref_target_path(p_node, p_ui_node.page_id);
12140:
12141: END replace_page_ref_target_path;
12142:
12143: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
12144: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
12145: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12147:

Line 12144: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,

12140:
12141: END replace_page_ref_target_path;
12142:
12143: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
12144: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
12145: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12147:
12148:

Line 12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS

12142:
12143: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
12144: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
12145: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12147:
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;

Line 12149: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;

12145: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12147:
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:

Line 12150: l_new_parent_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;

12146: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12147:
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

Line 12151: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;

12147:
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:

Line 12167: FROM CZ_UI_PAGE_REFS

12163:
12164: BEGIN
12165: SELECT page_ref_type, node_depth
12166: INTO l_page_ref_type, l_node_depth
12167: FROM CZ_UI_PAGE_REFS
12168: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12169: page_ref_id=p_page_ref_id AND
12170: deleted_flag=G_NO_FLAG;
12171:

Line 12176: FROM CZ_UI_PAGE_REFS

12172: -- get new parent page ref id
12173: BEGIN
12174: SELECT MIN(page_ref_id)
12175: INTO x_new_parent_page_ref_id
12176: FROM CZ_UI_PAGE_REFS
12177: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12178: target_persistent_node_id=p_node.parent_persistent_node_id AND
12179: deleted_flag=G_NO_FLAG;
12180:

Line 12183: FROM CZ_UI_PAGE_REFS

12179: deleted_flag=G_NO_FLAG;
12180:
12181: SELECT node_depth
12182: INTO l_new_parent_node_depth
12183: FROM CZ_UI_PAGE_REFS
12184: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12185: page_ref_id=x_new_parent_page_ref_id;
12186:
12187: EXCEPTION

Line 12192: IF x_new_parent_page_ref_id IS NULL THEN -- parent node does not exists in CZ_UI_PAGE_REFS

12188: WHEN NO_DATA_FOUND THEN
12189: NULL;
12190: END;
12191:
12192: IF x_new_parent_page_ref_id IS NULL THEN -- parent node does not exists in CZ_UI_PAGE_REFS
12193:
12194: IF l_page_ref_type IN (G_MODEL_TREE_MENU) AND p_node.parent_id IS NOT NULL THEN
12195: --DEBUG('asp: Deleting page_ref 5 ' || p_page_ref_id);
12196: UPDATE CZ_UI_PAGE_REFS

Line 12196: UPDATE CZ_UI_PAGE_REFS

12192: IF x_new_parent_page_ref_id IS NULL THEN -- parent node does not exists in CZ_UI_PAGE_REFS
12193:
12194: IF l_page_ref_type IN (G_MODEL_TREE_MENU) AND p_node.parent_id IS NOT NULL THEN
12195: --DEBUG('asp: Deleting page_ref 5 ' || p_page_ref_id);
12196: UPDATE CZ_UI_PAGE_REFS
12197: SET deleted_flag=G_YES_FLAG
12198: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12199: page_ref_id=p_page_ref_id AND
12200: deleted_flag=G_NO_FLAG;

Line 12208: UPDATE CZ_UI_PAGE_REFS

12204:
12205: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
12206: --DEBUG('asp: Setting parent_page_ref_id of page ref ' || p_page_ref_id || ' to ' || x_new_parent_page_ref_id);
12207: --DEBUG('asp: Setting seq_nbr of page ref ' || p_page_ref_id || ' to ' || p_node.tree_seq);
12208: UPDATE CZ_UI_PAGE_REFS
12209: SET parent_page_ref_id = x_new_parent_page_ref_id,
12210: seq_nbr = p_node.tree_seq
12211: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12212: page_ref_id=p_page_ref_id;

Line 12214: UPDATE CZ_UI_PAGE_REFS

12210: seq_nbr = p_node.tree_seq
12211: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12212: page_ref_id=p_page_ref_id;
12213:
12214: UPDATE CZ_UI_PAGE_REFS
12215: SET node_depth = node_depth + (l_new_parent_node_depth-l_node_depth) + 1
12216: WHERE (ui_def_id,page_ref_id) IN
12217: (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS
12218: START WITH ui_def_id=g_UI_Context.ui_def_id AND page_ref_id=p_page_ref_id

Line 12217: (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS

12213:
12214: UPDATE CZ_UI_PAGE_REFS
12215: SET node_depth = node_depth + (l_new_parent_node_depth-l_node_depth) + 1
12216: WHERE (ui_def_id,page_ref_id) IN
12217: (SELECT ui_def_id,page_ref_id FROM CZ_UI_PAGE_REFS
12218: START WITH ui_def_id=g_UI_Context.ui_def_id AND page_ref_id=p_page_ref_id
12219: CONNECT BY PRIOR page_ref_id=parent_page_ref_id AND
12220: ui_def_id=g_UI_Context.ui_def_id AND PRIOR ui_def_id=g_UI_Context.ui_def_id AND
12221: deleted_flag=G_NO_FLAG AND PRIOR deleted_flag=G_NO_FLAG);

Line 12235: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS

12231:
12232:
12233: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12234: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12235: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12236:
12237: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12238: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12239:

Line 12237: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;

12233: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12234: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12235: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12236:
12237: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12238: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12239:
12240: BEGIN
12241:

Line 12238: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

12234: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12235: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12236:
12237: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12238: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12239:
12240: BEGIN
12241:
12242: BEGIN

Line 12249: FROM CZ_UI_PAGE_REFS

12245: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
12246:
12247: SELECT page_ref_id, parent_page_ref_id
12248: INTO l_page_ref_id, x_new_parent_page_ref_id
12249: FROM CZ_UI_PAGE_REFS
12250: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12251: page_set_id = l_page_set_id AND
12252: target_page_id = p_ui_node.page_id AND
12253: deleted_flag=G_NO_FLAG AND

Line 12276: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;

12272: l_persistent_node_id_tbl number_tbl_type;
12273: l_ps_node_id_tb number_tbl_type;
12274: l_component_id_tbl number_tbl_type;
12275: l_ps_node_type_tbl number_tbl_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;

Line 12277: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;

12273: l_ps_node_id_tb number_tbl_type;
12274: l_component_id_tbl number_tbl_type;
12275: l_ps_node_type_tbl number_tbl_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;

Line 12278: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

12274: l_component_id_tbl number_tbl_type;
12275: l_ps_node_type_tbl number_tbl_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;

Line 12279: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12275: l_ps_node_type_tbl number_tbl_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:

Line 12553: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12549: l_persistent_node_id NUMBER;
12550: l_max_seq_nbr NUMBER;
12551: l_ps_node_type NUMBER;
12552: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12553: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12554: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12555: l_template_id NUMBER;
12556: l_template_ui_def_id NUMBER;
12557:

Line 12697: FROM CZ_UI_PAGE_REFS

12693: persistent_node_id = p_ui_node.persistent_node_id AND
12694: instantiable_flag <> p_node.instantiable_flag;
12695:
12696: FOR i IN(SELECT page_set_id
12697: FROM CZ_UI_PAGE_REFS
12698: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12699: target_persistent_node_id=p_ui_node.persistent_node_id AND
12700: deleted_flag=G_NO_FLAG)
12701: LOOP

Line 12703: UPDATE CZ_UI_PAGE_REFS

12699: target_persistent_node_id=p_ui_node.persistent_node_id AND
12700: deleted_flag=G_NO_FLAG)
12701: LOOP
12702: l_target_path := get_Page_Path(p_node.ps_node_id, i.page_set_id);
12703: UPDATE CZ_UI_PAGE_REFS
12704: SET target_path=l_target_path
12705: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12706: target_persistent_node_id=p_ui_node.persistent_node_id AND
12707: deleted_flag=G_NO_FLAG AND

Line 12721: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

12717: l_persistent_node_id NUMBER;
12718: l_max_seq_nbr NUMBER;
12719: l_ps_node_type NUMBER;
12720: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12721: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12722: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12723: l_instantiable_flag CZ_UI_PAGE_ELEMENTS.instantiable_flag%TYPE;
12724: l_template_id NUMBER;
12725: l_template_ui_def_id NUMBER;

Line 12777: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

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
12781:

Line 13187: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

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

Line 13188: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

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

Line 13348: FROM CZ_UI_PAGE_REFS

13344: l_ui_node.name,
13345: l_ui_node.deleted_flag);
13346:
13347: SELECT NVL(MAX(seq_nbr),0) INTO l_seq_nbr
13348: FROM CZ_UI_PAGE_REFS
13349: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13350: target_persistent_node_id=l_ui_node.persistent_node_id AND
13351: deleted_flag=G_NO_FLAG;
13352:

Line 13353: UPDATE CZ_UI_PAGE_REFS

13349: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13350: target_persistent_node_id=l_ui_node.persistent_node_id AND
13351: deleted_flag=G_NO_FLAG;
13352:
13353: UPDATE CZ_UI_PAGE_REFS
13354: SET seq_nbr=seq_nbr+1
13355: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13356: parent_page_ref_id = (SELECT parent_page_ref_id
13357: FROM CZ_UI_PAGE_REFS

Line 13357: FROM CZ_UI_PAGE_REFS

13353: UPDATE CZ_UI_PAGE_REFS
13354: SET seq_nbr=seq_nbr+1
13355: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13356: parent_page_ref_id = (SELECT parent_page_ref_id
13357: FROM CZ_UI_PAGE_REFS
13358: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13359: target_page_id=p_page_id AND
13360: deleted_flag=G_NO_FLAG) AND
13361: seq_nbr > l_seq_nbr AND

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

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

Line 13367: INSERT INTO CZ_UI_PAGE_REFS

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

Line 13411: FROM CZ_UI_PAGE_REFS

13407: path_to_next_page,
13408: page_ref_type,
13409: target_expl_node_id,
13410: deleted_flag
13411: FROM CZ_UI_PAGE_REFS
13412: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13413: target_page_id=p_page_id AND
13414: deleted_flag=G_NO_FLAG;
13415:

Line 13780: SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS

13776: split_Page(i, l_max_controls_per_page);
13777: END LOOP;
13778:
13779: IF g_UI_Context.PRIMARY_NAVIGATION=G_MODEL_TREE_MENU THEN
13780: SELECT COUNT(*) INTO l_num_if_roots FROM CZ_UI_PAGE_REFS
13781: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13782: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13783: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13784: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG;

Line 13789: FROM CZ_UI_PAGE_REFS

13785: IF l_num_if_roots > 1 THEN
13786:
13787: SELECT target_persistent_node_id,page_set_id,page_ref_type
13788: INTO l_target_persistent_node_id,l_page_set_id,l_page_set_type
13789: FROM CZ_UI_PAGE_REFS
13790: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL
13791: AND target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13792: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND
13793: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;

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

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

Line 13797: INSERT INTO CZ_UI_PAGE_REFS

13793: deleted_flag=G_NO_FLAG) AND deleted_flag=G_NO_FLAG AND rownum<2;
13794:
13795: l_page_ref_id := allocateId('CZ_UI_PAGE_REFS_S');
13796:
13797: INSERT INTO CZ_UI_PAGE_REFS
13798: (ui_def_id,
13799: page_set_id,
13800: page_ref_id,
13801: parent_page_ref_id,

Line 13842: UPDATE CZ_UI_PAGE_REFS

13838: NULL,
13839: NULL,
13840: G_NO_FLAG);
13841:
13842: UPDATE CZ_UI_PAGE_REFS
13843: SET parent_page_ref_id=l_page_ref_id
13844: WHERE ui_def_id=g_UI_Context.ui_def_id AND parent_page_ref_id IS NULL AND
13845: target_persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES
13846: WHERE devl_project_id=g_UI_Context.devl_project_id AND parent_id IS NULL AND

Line 13917: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

13913: l_xmldoc xmldom.DOMDocument;
13914: l_counter NUMBER:=0;
13915: l_seq_nbr NUMBER;
13916: l_show_train BOOLEAN := FALSE;
13917: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
13918: l_page_ref_id NUMBER;
13919:
13920: PROCEDURE set_Page_Flow_(p_page_ref_id IN VARCHAR2) IS
13921: BEGIN

Line 13923: NVL(modified_flags,0) AS modified_flags FROM CZ_UI_PAGE_REFS

13919:
13920: PROCEDURE set_Page_Flow_(p_page_ref_id IN VARCHAR2) IS
13921: BEGIN
13922: FOR i IN(SELECT page_ref_id,target_page_id,empty_page_flag,
13923: NVL(modified_flags,0) AS modified_flags FROM CZ_UI_PAGE_REFS
13924: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13925: parent_page_ref_id=p_page_ref_id AND
13926: target_page_id IN
13927: (SELECT page_id FROM CZ_UI_PAGES

Line 13937: UPDATE CZ_UI_PAGE_REFS

13933: LOOP
13934: l_counter := l_counter + 1;
13935:
13936: IF i.modified_flags = 0 THEN
13937: UPDATE CZ_UI_PAGE_REFS
13938: SET seq_nbr = l_counter
13939: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13940: page_ref_id=i.page_ref_id;
13941: END IF;

Line 13957: NVL(modified_flags,0) AS MODIFIED_FLAGS FROM CZ_UI_PAGE_REFS

13953: deleted_flag=G_NO_FLAG)
13954: LOOP
13955: l_counter := 0;
13956: FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
13957: NVL(modified_flags,0) AS MODIFIED_FLAGS FROM CZ_UI_PAGE_REFS
13958: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13959: parent_page_ref_id IS NULL AND
13960: page_set_id=n.page_set_id AND
13961: target_page_id IN

Line 13993: FROM CZ_UI_PAGE_REFS

13989: LOOP
13990:
13991: FOR m IN(SELECT page_ref_id,seq_nbr,target_page_id,empty_page_flag,
13992: target_persistent_node_id, target_expl_node_id
13993: FROM CZ_UI_PAGE_REFS
13994: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13995: parent_page_ref_id IS NULL AND
13996: page_set_id=n.page_set_id AND
13997: target_page_id IN

Line 14014: UPDATE CZ_UI_PAGE_REFS

14010: IF l_target_path IS NULL THEN
14011: l_target_path := '.';
14012: END IF;
14013:
14014: UPDATE CZ_UI_PAGE_REFS
14015: SET target_path=l_target_path
14016: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14017: page_set_id=n.page_set_id AND
14018: target_persistent_node_id=m.target_persistent_node_id AND

Line 14486: NVL(empty_page_flag,G_NO_FLAG) AS empty_page_flag FROM CZ_UI_PAGE_REFS

14482: -- which have no UI content in it
14483: --
14484: FOR i IN(SELECT page_ref_id,
14485: target_page_id,target_persistent_node_id,
14486: NVL(empty_page_flag,G_NO_FLAG) AS empty_page_flag FROM CZ_UI_PAGE_REFS
14487: WHERE ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG AND
14488: target_page_id IN(SELECT page_id FROM CZ_UI_PAGES
14489: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14490: NVL(suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG AND

Line 14499: UPDATE CZ_UI_PAGE_REFS

14495: l_empty_page := is_Empty_Page(i.target_page_id);
14496:
14497: IF NVL(i.empty_page_flag,G_NO_FLAG)=G_NO_FLAG AND l_empty_page THEN
14498:
14499: UPDATE CZ_UI_PAGE_REFS
14500: SET empty_page_flag=G_YES_FLAG
14501: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14502: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14503:

Line 14513: UPDATE CZ_UI_PAGE_REFS

14509: END IF;
14510:
14511: ELSIF i.empty_page_flag=G_YES_FLAG AND l_empty_page=FALSE THEN
14512:
14513: UPDATE CZ_UI_PAGE_REFS
14514: SET empty_page_flag=G_NO_FLAG
14515: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14516: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14517:

Line 14538: FOR i IN(SELECT page_ref_id FROM CZ_UI_PAGE_REFS a

14534: l_split_seq_nbr NUMBER;
14535:
14536: PROCEDURE set_Page_Ref_Order_(p_page_ref_id IN VARCHAR2) IS
14537: BEGIN
14538: FOR i IN(SELECT page_ref_id FROM CZ_UI_PAGE_REFS a
14539: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14540: parent_page_ref_id=p_page_ref_id AND
14541: EXISTS
14542: (SELECT NULL FROM CZ_UI_PAGES

Line 14547: UPDATE CZ_UI_PAGE_REFS

14543: WHERE page_id=a.target_page_id AND ui_def_id=g_UI_Context.ui_def_id) AND
14544: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG) ORDER BY seq_nbr)
14545: LOOP
14546: l_counter := l_counter + 1;
14547: UPDATE CZ_UI_PAGE_REFS
14548: SET seq_nbr = l_counter
14549: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14550: page_ref_id=i.page_ref_id;
14551: set_Page_Ref_Order_(i.page_ref_id);

Line 14556: FOR i IN(SELECT page_ref_id,target_page_id,target_persistent_node_id FROM CZ_UI_PAGE_REFS

14552: END LOOP;
14553: END set_Page_Ref_Order_;
14554:
14555: BEGIN
14556: FOR i IN(SELECT page_ref_id,target_page_id,target_persistent_node_id FROM CZ_UI_PAGE_REFS
14557: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14558: page_set_id=p_page_set_id AND
14559: parent_page_ref_id IS NULL AND
14560: deleted_flag=G_NO_FLAG)

Line 14568: UPDATE CZ_UI_PAGE_REFS

14564: WHERE page_id=i.target_page_id AND
14565: ui_def_id=g_UI_Context.ui_def_id;
14566:
14567: IF l_split_seq_nbr > 1 THEN
14568: UPDATE CZ_UI_PAGE_REFS
14569: SET seq_nbr = l_split_seq_nbr
14570: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14571: page_ref_id=i.page_ref_id;
14572: l_counter := l_split_seq_nbr;

Line 14574: UPDATE CZ_UI_PAGE_REFS

14570: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14571: page_ref_id=i.page_ref_id;
14572: l_counter := l_split_seq_nbr;
14573: ELSE
14574: UPDATE CZ_UI_PAGE_REFS
14575: SET seq_nbr = 1
14576: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14577: page_ref_id=i.page_ref_id;
14578: SELECT MAX(split_seq_nbr) INTO l_counter FROM CZ_UI_PAGES

Line 15086: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

15082: l_max_prev_seq_nbr NUMBER;
15083: l_max_src_seq_nbr NUMBER;
15084: l_src_range NUMBER;
15085: l_atleast_one_parent_found BOOLEAN;
15086: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
15087: l_pagebase_expl_node_id CZ_UI_PAGES.pagebase_expl_node_id%TYPE;
15088: l_node_is_reachable NUMBER := -1;
15089: l_model_ref_expl_id NUMBER;
15090: l_count NUMBER;

Line 15106: FROM CZ_UI_PAGE_REFS

15102: -- This is a reference node and it has been moved. Reference nodes will not have pages
15103: -- in this UI which are in the tree. So have to deal with page_refs for references
15104: -- explicitly
15105: FOR i in (SELECT *
15106: FROM CZ_UI_PAGE_REFS
15107: WHERE ui_def_id = g_UI_Context.ui_def_id
15108: AND page_set_id = g_UI_Context.page_set_id
15109: AND target_ui_def_id IS NOT NULL
15110: AND target_persistent_node_id = p_ps_node.persistent_node_id)

Line 15381: l_page_ref CZ_UI_PAGE_REFS%ROWTYPE;

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;
15385: l_count NUMBER;

Line 15398: FROM CZ_UI_PAGE_REFS

15394:
15395: BEGIN
15396:
15397: SELECT min(seq_nbr), count(*) INTO l_old_seq_nbr, l_count
15398: FROM CZ_UI_PAGE_REFS
15399: WHERE ui_def_id = g_UI_Context.ui_def_id
15400: AND page_set_id = l_page_set_id
15401: AND target_persistent_node_id = p_ps_node.persistent_node_id
15402: AND deleted_flag = G_NO_FLAG;

Line 15405: FROM CZ_UI_PAGE_REFS

15401: AND target_persistent_node_id = p_ps_node.persistent_node_id
15402: AND deleted_flag = G_NO_FLAG;
15403:
15404: SELECT * INTO l_page_ref
15405: FROM CZ_UI_PAGE_REFS
15406: WHERE ui_def_id = g_UI_Context.ui_def_id
15407: AND page_set_id = l_page_set_id
15408: AND target_persistent_node_id = p_ps_node.persistent_node_id
15409: AND deleted_flag = G_NO_FLAG

Line 15434: UPDATE CZ_UI_PAGE_REFS

15430: END IF;
15431:
15432: --DEBUG('asp: l_range_min: ' || l_range_min || ', l_range_max ' || l_range_max);
15433:
15434: UPDATE CZ_UI_PAGE_REFS
15435: SET seq_nbr = seq_nbr - l_count
15436: WHERE ui_def_id = g_UI_Context.ui_def_id
15437: AND page_set_id = l_page_set_id
15438: AND parent_page_ref_id = l_page_ref.parent_page_ref_id

Line 15445: UPDATE CZ_UI_PAGE_REFS

15441: AND seq_nbr between l_range_min and l_range_max;
15442:
15443: l_diff := l_new_seq_nbr - l_old_seq_nbr;
15444:
15445: UPDATE CZ_UI_PAGE_REFS
15446: SET seq_nbr = seq_nbr + l_diff
15447: WHERE ui_def_id = g_UI_Context.ui_def_id
15448: AND page_set_id = l_page_set_id
15449: AND parent_page_ref_id = l_page_ref.parent_page_ref_id

Line 15837: UPDATE CZ_UI_PAGE_REFS

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;
15836:
15837: UPDATE CZ_UI_PAGE_REFS
15838: SET target_expl_node_id=l_expl_id
15839: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15840: target_persistent_node_id=t.psnode_persistent_node_id AND
15841: target_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 17560: -- Verify for cz_ui_page_refs.target_expl_node_id

17556: AND ui_def_id = uiDefCur.ref_ui_def_id;
17557: END LOOP; --uiPages
17558:
17559:
17560: -- Verify for cz_ui_page_refs.target_expl_node_id
17561: FOR pageRefs IN (SELECT pgref.page_ref_id,pgref.target_expl_node_id FROM CZ_UI_PAGE_REFS pgref
17562: WHERE pgref.deleted_flag = G_NO_FLAG AND pgref.ui_def_id = uiDefCur.ref_ui_def_id
17563: AND pgref.target_expl_node_id IS NOT NULL
17564: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

Line 17561: FOR pageRefs IN (SELECT pgref.page_ref_id,pgref.target_expl_node_id FROM CZ_UI_PAGE_REFS pgref

17557: END LOOP; --uiPages
17558:
17559:
17560: -- Verify for cz_ui_page_refs.target_expl_node_id
17561: FOR pageRefs IN (SELECT pgref.page_ref_id,pgref.target_expl_node_id FROM CZ_UI_PAGE_REFS pgref
17562: WHERE pgref.deleted_flag = G_NO_FLAG AND pgref.ui_def_id = uiDefCur.ref_ui_def_id
17563: AND pgref.target_expl_node_id IS NOT NULL
17564: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17565: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pgref.target_expl_node_id

Line 17570: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_REFS where target_expl_node_id : ' || pageRefs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

17566: )
17567: )
17568: LOOP
17569:
17570: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_REFS where target_expl_node_id : ' || pageRefs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17571:
17572: UPDATE CZ_UI_PAGE_REFS
17573: SET deleted_flag = G_YES_FLAG
17574: WHERE target_expl_node_id = pageRefs.target_expl_node_id

Line 17572: UPDATE CZ_UI_PAGE_REFS

17568: LOOP
17569:
17570: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_REFS where target_expl_node_id : ' || pageRefs.target_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17571:
17572: UPDATE CZ_UI_PAGE_REFS
17573: SET deleted_flag = G_YES_FLAG
17574: WHERE target_expl_node_id = pageRefs.target_expl_node_id
17575: AND page_ref_id = pageRefs.page_ref_id
17576: AND ui_def_id = uiDefCur.ref_ui_def_id;

Line 18733: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

18729: l_xml_node xmldom.DOMNode;
18730: l_element_id_tbl varchar_tbl_type;
18731: l_out_node xmldom.DOMNode;
18732: l_parent_node xmldom.DOMNode;
18733: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
18734: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
18735: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18736: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18737: l_ui_context CZ_UI_DEFS%ROWTYPE;

Line 18736: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;

18732: l_parent_node xmldom.DOMNode;
18733: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
18734: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
18735: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18736: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18737: l_ui_context CZ_UI_DEFS%ROWTYPE;
18738: l_condition_id NUMBER;
18739: l_caption_text_id NUMBER;
18740: l_caption_rule_id NUMBER;

Line 18790: FROM CZ_UI_PAGE_REFS

18786:
18787: IF l_parent_element_id IS NULL OR p_element_id=G_NO_FLAG THEN -- this is UI page ( and it should be deleted )
18788:
18789: FOR i IN(SELECT page_ref_id,page_ref_type,page_set_id,condition_id,caption_text_id,caption_rule_id
18790: FROM CZ_UI_PAGE_REFS
18791: WHERE ui_def_id=p_ui_def_id AND target_page_id=p_ui_page_id AND deleted_flag=G_NO_FLAG)
18792: LOOP
18793:
18794: UPDATE CZ_LOCALIZED_TEXTS

Line 18805: UPDATE CZ_UI_PAGE_REFS

18801: WHERE persistent_rule_id IN(i.condition_id,i.caption_rule_id) AND
18802: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18803:
18804: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN
18805: UPDATE CZ_UI_PAGE_REFS
18806: SET deleted_flag=G_YES_FLAG
18807: WHERE ui_def_id=p_ui_def_id
18808: AND deleted_flag=G_NO_FLAG
18809: AND (ui_def_id,page_ref_id,page_set_id) IN

Line 18810: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a

18806: SET deleted_flag=G_YES_FLAG
18807: WHERE ui_def_id=p_ui_def_id
18808: AND deleted_flag=G_NO_FLAG
18809: AND (ui_def_id,page_ref_id,page_set_id) IN
18810: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
18811: START WITH a.ui_def_id=p_ui_def_id AND
18812: a.page_ref_id=i.page_ref_id
18813: CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
18814: a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND

Line 18819: UPDATE CZ_UI_PAGE_REFS

18815: PRIOR a.ui_def_id=p_ui_def_id AND
18816: a.page_set_id=i.page_set_id AND
18817: PRIOR a.page_set_id=i.page_set_id);
18818: ELSE
18819: UPDATE CZ_UI_PAGE_REFS
18820: SET deleted_flag=G_YES_FLAG
18821: WHERE ui_def_id=p_ui_def_id AND page_ref_id=i.page_ref_id;
18822: END IF;
18823:

Line 19005: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;

19001: x_msg_count OUT NOCOPY NUMBER, -- number of error messages
19002: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
19003: ) IS
19004:
19005: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
19006: l_ui_context CZ_UI_DEFS%ROWTYPE;
19007: l_page_id CZ_UI_PAGES.page_id%TYPE;
19008: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
19009: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;

Line 19009: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;

19005: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
19006: l_ui_context CZ_UI_DEFS%ROWTYPE;
19007: l_page_id CZ_UI_PAGES.page_id%TYPE;
19008: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
19009: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
19010:
19011: BEGIN
19012:
19013: --

Line 19027: FROM CZ_UI_PAGE_REFS

19023: l_ui_context := get_UI_Context(p_ui_def_id => p_ui_def_id);
19024:
19025: SELECT page_set_id, page_ref_type
19026: INTO l_page_set_id, l_page_ref_type
19027: FROM CZ_UI_PAGE_REFS
19028: WHERE ui_def_id=p_ui_def_id AND page_ref_id=p_page_ref_id
19029: AND deleted_flag=G_NO_FLAG;
19030:
19031: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN

Line 19032: UPDATE CZ_UI_PAGE_REFS

19028: WHERE ui_def_id=p_ui_def_id AND page_ref_id=p_page_ref_id
19029: AND deleted_flag=G_NO_FLAG;
19030:
19031: IF l_page_ref_type IN( G_MODEL_TREE_MENU, G_MULTI_LEVEL_MENU) THEN
19032: UPDATE CZ_UI_PAGE_REFS
19033: SET deleted_flag=G_YES_FLAG
19034: WHERE ui_def_id=p_ui_def_id
19035: AND deleted_flag=G_NO_FLAG
19036: AND (ui_def_id,page_ref_id,page_set_id) IN

Line 19037: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a

19033: SET deleted_flag=G_YES_FLAG
19034: WHERE ui_def_id=p_ui_def_id
19035: AND deleted_flag=G_NO_FLAG
19036: AND (ui_def_id,page_ref_id,page_set_id) IN
19037: (SELECT a.ui_def_id,a.page_ref_id,a.page_set_id FROM CZ_UI_PAGE_REFS a
19038: START WITH a.ui_def_id=p_ui_def_id AND
19039: a.page_ref_id=p_page_ref_id
19040: CONNECT BY PRIOR a.page_ref_id=a.parent_page_ref_id AND
19041: a.deleted_flag='0' AND a.ui_def_id=p_ui_def_id AND

Line 19046: UPDATE CZ_UI_PAGE_REFS

19042: PRIOR a.ui_def_id=p_ui_def_id AND
19043: a.page_set_id=l_page_set_id AND
19044: PRIOR a.page_set_id=l_page_set_id);
19045: ELSE
19046: UPDATE CZ_UI_PAGE_REFS
19047: SET deleted_flag=G_YES_FLAG
19048: WHERE ui_def_id=p_ui_def_id
19049: AND page_ref_id=p_page_ref_id;
19050: END IF;

Line 19054: -- which have no corresponding records in CZ_UI_PAGE_REFS

19050: END IF;
19051:
19052: --
19053: -- null out CZ_UI_PAGES.page_set_id for those UI pages in this UI
19054: -- which have no corresponding records in CZ_UI_PAGE_REFS
19055: --
19056: UPDATE CZ_UI_PAGES a
19057: SET page_set_id=NULL
19058: WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND

Line 19059: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_REFS b

19055: --
19056: UPDATE CZ_UI_PAGES a
19057: SET page_set_id=NULL
19058: WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND
19059: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_REFS b
19060: WHERE b.ui_def_id=p_ui_def_id AND target_page_id=a.page_id AND
19061: deleted_flag='0');
19062:
19063: IF l_page_ref_type IN( G_PAGE_FLOW, G_SUBTABS) THEN

Line 19475: UPDATE CZ_UI_PAGE_REFS

19471: empty_page_flag = G_NO_FLAG
19472: WHERE page_id=p_target_ui_page_id AND
19473: ui_def_id=p_target_ui_def_id;
19474:
19475: UPDATE CZ_UI_PAGE_REFS
19476: SET empty_page_flag = G_NO_FLAG
19477: WHERE target_page_id=p_target_ui_page_id AND
19478: ui_def_id=p_target_ui_def_id AND
19479: deleted_flag = G_NO_FLAG AND

Line 19999: FROM CZ_UI_PAGE_REFS

19995: --
19996: Initialize(x_return_status,x_msg_count,x_msg_data);
19997:
19998: SELECT page_set_id,node_depth INTO l_target_page_set_id,l_target_node_depth
19999: FROM CZ_UI_PAGE_REFS
20000: WHERE ui_def_id=p_target_ui_def_id AND page_ref_id=p_target_parent_page_ref_id;
20001:
20002: SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS
20003: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;

Line 20002: SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS

19998: SELECT page_set_id,node_depth INTO l_target_page_set_id,l_target_node_depth
19999: FROM CZ_UI_PAGE_REFS
20000: WHERE ui_def_id=p_target_ui_def_id AND page_ref_id=p_target_parent_page_ref_id;
20001:
20002: SELECT NVL(MAX(seq_nbr),0) INTO l_target_max_seq_nbr FROM CZ_UI_PAGE_REFS
20003: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;
20004:
20005: SELECT page_ref_id,parent_page_ref_id,node_depth,seq_nbr
20006: BULK COLLECT INTO l_page_ref_id_tbl,l_parent_page_ref_id_tbl,l_node_depth_tbl,l_seq_nbr_tbl

Line 20007: FROM CZ_UI_PAGE_REFS

20003: WHERE ui_def_id=p_target_ui_def_id AND deleted_flag=G_NO_FLAG;
20004:
20005: SELECT page_ref_id,parent_page_ref_id,node_depth,seq_nbr
20006: BULK COLLECT INTO l_page_ref_id_tbl,l_parent_page_ref_id_tbl,l_node_depth_tbl,l_seq_nbr_tbl
20007: FROM CZ_UI_PAGE_REFS
20008: START WITH ui_def_id=p_source_ui_def_id AND page_ref_id=p_source_page_ref_id
20009: CONNECT BY PRIOR ui_def_id=p_source_ui_def_id AND
20010: ui_def_id=p_source_ui_def_id AND
20011: PRIOR page_ref_id=parent_page_ref_id AND

Line 20039: FOR i IN(SELECT * FROM CZ_UI_PAGE_REFS

20035: l_new_parent_page_ref_id := p_target_parent_page_ref_id;
20036: x_page_ref_id := l_new_page_ref_id;
20037: END IF;
20038:
20039: FOR i IN(SELECT * FROM CZ_UI_PAGE_REFS
20040: WHERE ui_def_id=p_source_ui_def_id AND
20041: page_ref_id=l_current_page_ref_id AND
20042: deleted_flag=G_NO_FLAG)
20043: LOOP

Line 20057: INSERT INTO CZ_UI_PAGE_REFS

20053:
20054: l_caption_text_id := copy_Intl_Text(l_caption_text_id, p_target_ui_def_id,
20055: NULL, NULL);
20056:
20057: INSERT INTO CZ_UI_PAGE_REFS
20058: (
20059: PAGE_SET_ID
20060: ,UI_DEF_ID
20061: ,PAGE_REF_ID

Line 21677: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

21673: ) IS
21674:
21675: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
21676: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
21677: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
21678: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
21680: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;
21681: l_ref_parent_persist_node_id NUMBER;

Line 21678: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;

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

Line 21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

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

Line 21680: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;

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

Line 21708: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI

21704: IF l_target_primary_navigation <> G_MODEL_TREE_MENU THEN
21705:
21706: --
21707: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
21708: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
21709: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
21710: --
21711: UPDATE CZ_UI_PAGE_REFS
21712: SET deleted_flag=G_YES_FLAG

Line 21709: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )

21705:
21706: --
21707: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
21708: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
21709: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
21710: --
21711: UPDATE CZ_UI_PAGE_REFS
21712: SET deleted_flag=G_YES_FLAG
21713: WHERE ui_def_id=p_ui_def_id AND

Line 21711: UPDATE CZ_UI_PAGE_REFS

21707: -- if target primary_navigation <> G_MODEL_TREE_MENU ( Dynamic Tree Menu )
21708: -- then delete a corresponding CZ_UI_PAGE_REFS record from source UI
21709: -- ( CZ_UI_PAGE_REFS.target_persistent_node_id=p_ref_persistent_node_id )
21710: --
21711: UPDATE CZ_UI_PAGE_REFS
21712: SET deleted_flag=G_YES_FLAG
21713: WHERE ui_def_id=p_ui_def_id AND
21714: target_persistent_node_id=p_ref_persistent_node_id AND
21715: deleted_flag=G_NO_FLAG;

Line 21735: FROM CZ_UI_PAGE_REFS

21731: WHERE ps_node_id=l_ref_parent_id AND
21732: deleted_flag=G_NO_FLAG;
21733:
21734: FOR i IN(SELECT page_ref_id,node_depth,page_set_id,page_ref_type, seq_nbr
21735: FROM CZ_UI_PAGE_REFS
21736: WHERE ui_def_id=p_ui_def_id AND
21737: target_persistent_node_id=l_ref_parent_persist_node_id AND
21738: page_ref_type=G_MODEL_TREE_MENU AND
21739: deleted_flag=G_NO_FLAG)

Line 21746: UPDATE CZ_UI_PAGE_REFS

21742: IF (i.node_depth <> 0 AND i.seq_nbr <> 0) THEN
21743: --
21744: -- update target_ui_def_id and target_page_set_id
21745: --
21746: UPDATE CZ_UI_PAGE_REFS
21747: SET target_ui_def_id=p_new_target_ui_def_id,
21748: target_page_set_id=l_target_page_set_id
21749: WHERE ui_def_id=p_ui_def_id AND
21750: parent_page_ref_id=i.page_ref_id AND

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

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

Line 21761: FROM CZ_UI_PAGE_REFS

21757:
21758: l_ref_pagebase_path := get_Page_Path(l_ref_ps_node_id, i.page_set_id);
21759:
21760: SELECT NVL(MAX(seq_nbr),0)+1 INTO l_seq_nbr
21761: FROM CZ_UI_PAGE_REFS
21762: WHERE ui_def_id=p_ui_def_id AND
21763: parent_page_ref_id=i.page_ref_id AND
21764: deleted_flag=G_NO_FLAG;
21765:

Line 21771: INSERT INTO CZ_UI_PAGE_REFS

21767: WHERE model_id=g_UI_Context.devl_project_id AND
21768: referring_node_id=p_ref_persistent_node_id AND
21769: deleted_flag=G_NO_FLAG;
21770:
21771: INSERT INTO CZ_UI_PAGE_REFS
21772: (ui_def_id,
21773: page_set_id,
21774: page_ref_id,
21775: parent_page_ref_id,

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

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