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_PAGES

Line 281: TYPE ui_pages_tbl_type IS TABLE OF CZ_UI_PAGES%ROWTYPE INDEX BY BINARY_INTEGER;

277: TYPE ui_page_el_int_tbl_type IS TABLE OF CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE INDEX BY BINARY_INTEGER;
278:
279: TYPE ui_def_nodes_tbl_type IS TABLE OF CZ_UI_DEFS%ROWTYPE INDEX BY BINARY_INTEGER;
280: TYPE ui_page_sets_tbl_type IS TABLE OF CZ_UI_PAGE_SETS%ROWTYPE INDEX BY BINARY_INTEGER;
281: TYPE ui_pages_tbl_type IS TABLE OF CZ_UI_PAGES%ROWTYPE INDEX BY BINARY_INTEGER;
282: TYPE ui_page_refs_tbl_type IS TABLE OF CZ_UI_PAGE_REFS%ROWTYPE INDEX BY BINARY_INTEGER;
283: TYPE xml_dom_elements_tbl_type IS TABLE OF xmldom.DOMNode INDEX BY BINARY_INTEGER;
284:
285: TYPE varchar2_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY VARCHAR2(255);

Line 732: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;

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;
734:
735: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
736: g_currPageSetSeqVal := g_currentPageSet;

Line 1034: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN

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
1035: IF g_currentPage 1036: g_currentPage := g_currentPage+1;
1037: ELSE
1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;

Line 1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;

1034: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN
1035: IF g_currentPage 1036: g_currentPage := g_currentPage+1;
1037: ELSE
1038: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1039: g_currentPage := g_currPageSeqVal;
1040: END IF;
1041: RETURN g_currentPage;
1042: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

Line 1113: UPDATE CZ_UI_PAGES

1109: --
1110: PROCEDURE mark_UI_Page_As_Refreshed(p_page_id IN NUMBER,
1111: p_ui_def_id IN NUMBER) IS
1112: BEGIN
1113: UPDATE CZ_UI_PAGES
1114: SET deleted_flag = DECODE(deleted_flag,G_MARK_TO_ADD,
1115: G_MARK_TO_ADD,G_MARK_TO_REFRESH),
1116: page_rev_nbr=page_rev_nbr+1
1117: WHERE page_id=p_page_id AND

Line 1128: UPDATE CZ_UI_PAGES

1124: --
1125: PROCEDURE mark_UI_Page_As_Deleted(p_page_id IN NUMBER,
1126: p_ui_def_id IN NUMBER) IS
1127: BEGIN
1128: UPDATE CZ_UI_PAGES
1129: SET deleted_flag = G_MARK_TO_DELETE
1130: WHERE page_id=p_page_id AND
1131: ui_def_id=p_ui_def_id;
1132: END mark_UI_Page_As_Deleted;

Line 1154: UPDATE CZ_UI_PAGES

1150: BEGIN
1151:
1152: IF p_hmode = G_DELETE_PAGE THEN
1153:
1154: UPDATE CZ_UI_PAGES
1155: SET page_rev_nbr = page_rev_nbr + 1,
1156: deleted_flag = G_YES_FLAG
1157: WHERE page_id = p_page_id AND
1158: ui_def_id = g_UI_Context.ui_def_id;

Line 1181: UPDATE CZ_UI_PAGES

1177: IF SQL%ROWCOUNT>0 THEN
1178: --
1179: -- update revision of deleted UI page
1180: --
1181: UPDATE CZ_UI_PAGES
1182: SET page_rev_nbr = page_rev_nbr + 1
1183: WHERE page_id = p_page_id AND
1184: ui_def_id = g_UI_Context.ui_def_id;
1185: END IF;

Line 1193: UPDATE CZ_UI_PAGES

1189: --
1190: -- update page status and page_rev_nbr
1191: -- page_rev_nbr=1 because this is first creation
1192: --
1193: UPDATE CZ_UI_PAGES
1194: SET page_rev_nbr = page_rev_nbr+1,
1195: deleted_flag = G_NO_FLAG
1196: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1197: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 1207: UPDATE CZ_UI_PAGES

1203: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
1204:
1205: ELSIF p_hmode = G_NEW_PAGE THEN
1206:
1207: UPDATE CZ_UI_PAGES
1208: SET page_rev_nbr = 1,
1209: deleted_flag = G_NO_FLAG
1210: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1211: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 1221: UPDATE CZ_UI_PAGES

1217: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
1218: ELSE
1219: NULL;
1220: /*
1221: UPDATE CZ_UI_PAGES
1222: SET deleted_flag = G_NO_FLAG
1223: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1224: deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
1225:

Line 1450: FROM CZ_UI_PAGES

1446: -- if it is cached then get it from cache
1447: --
1448: SELECT COUNT(page_id)
1449: INTO l_page_counter
1450: FROM CZ_UI_PAGES
1451: WHERE ui_def_id = g_UI_Context.ui_def_id;
1452:
1453: RETURN l_page_counter;
1454:

Line 1459: -- Parameters : p_page_id - identifies UI page ( -> CZ_UI_PAGES.page_id )

1455: END get_Page_Counter;
1456:
1457: --
1458: -- construct JRAD Page/Region name based on ui_def_id and page_id
1459: -- Parameters : p_page_id - identifies UI page ( -> CZ_UI_PAGES.page_id )
1460: -- Return : JRAD Page/Region name
1461: --
1462: FUNCTION generate_JRAD_Page_Name(p_page_counter IN NUMBER)
1463: RETURN VARCHAR2 IS

Line 1465: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

1461: --
1462: FUNCTION generate_JRAD_Page_Name(p_page_counter IN NUMBER)
1463: RETURN VARCHAR2 IS
1464:
1465: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
1466: l_counter NUMBER;
1467:
1468: BEGIN
1469:

Line 1478: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES

1474: l_jrad_doc := '/oracle/apps/cz/runtime/oa/webui/regions/ui' ||
1475: TO_CHAR(g_UI_Context.ui_def_id) || '/Page_' ||TO_CHAR(g_UI_Context.ui_def_id)||'_'||
1476: TO_CHAR(p_page_counter);
1477:
1478: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
1479: WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;
1480:
1481: IF l_counter>0 THEN
1482: l_counter:=l_counter+1;

Line 1486: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES

1482: l_counter:=l_counter+1;
1483: l_jrad_doc := l_jrad_doc||'_'||TO_CHAR(l_counter);
1484:
1485: LOOP
1486: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
1487: WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;
1488: IF l_counter=0 THEN
1489: EXIT;
1490: ELSE

Line 1805: RETURN CZ_UI_PAGES%ROWTYPE IS

1801: --
1802: -- return UI page node
1803: --
1804: FUNCTION get_UI_Page_Node(p_page_id IN NUMBER)
1805: RETURN CZ_UI_PAGES%ROWTYPE IS
1806: l_page_node CZ_UI_PAGES%ROWTYPE;
1807: BEGIN
1808: SELECT * INTO l_page_node
1809: FROM CZ_UI_PAGES

Line 1806: l_page_node CZ_UI_PAGES%ROWTYPE;

1802: -- return UI page node
1803: --
1804: FUNCTION get_UI_Page_Node(p_page_id IN NUMBER)
1805: RETURN CZ_UI_PAGES%ROWTYPE IS
1806: l_page_node CZ_UI_PAGES%ROWTYPE;
1807: BEGIN
1808: SELECT * INTO l_page_node
1809: FROM CZ_UI_PAGES
1810: WHERE page_id=p_page_id AND

Line 1809: FROM CZ_UI_PAGES

1805: RETURN CZ_UI_PAGES%ROWTYPE IS
1806: l_page_node CZ_UI_PAGES%ROWTYPE;
1807: BEGIN
1808: SELECT * INTO l_page_node
1809: FROM CZ_UI_PAGES
1810: WHERE page_id=p_page_id AND
1811: ui_def_id=g_UI_Context.ui_def_id;
1812: RETURN l_page_node;
1813: END get_UI_Page_Node;

Line 2389: (SELECT page_id,NVL(page_set_id,a.page_set_id) FROM CZ_UI_PAGES

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
2391: deleted_flag NOT IN(G_YES_FLAG)) AND
2392: deleted_flag = G_NO_FLAG;
2393:

Line 2608: FROM CZ_UI_PAGES

2604: l_split_seq_nbr NUMBER;
2605: BEGIN
2606: SELECT NVL(MAX(split_seq_nbr),0)
2607: INTO l_split_seq_nbr
2608: FROM CZ_UI_PAGES
2609: WHERE ui_def_id=g_UI_Context.ui_def_id AND
2610: persistent_node_id IN
2611: (SELECT persistent_node_id FROM CZ_UI_PAGES
2612: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id);

Line 2611: (SELECT persistent_node_id FROM CZ_UI_PAGES

2607: INTO l_split_seq_nbr
2608: FROM CZ_UI_PAGES
2609: WHERE ui_def_id=g_UI_Context.ui_def_id AND
2610: persistent_node_id IN
2611: (SELECT persistent_node_id FROM CZ_UI_PAGES
2612: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id);
2613: RETURN l_split_seq_nbr;
2614: END get_Last_Split_Page_Nbr;
2615:

Line 3162: UPDATE CZ_UI_PAGES

3158:
3159: IF l_changed_target_ids_tbl.COUNT>0 THEN
3160: FOR x IN l_changed_target_ids_tbl.First..l_changed_target_ids_tbl.Last
3161: LOOP
3162: UPDATE CZ_UI_PAGES
3163: SET page_set_id=l_parent_page_set_id
3164: WHERE persistent_node_id=l_changed_target_ids_tbl(x) AND
3165: ui_def_id=p_ui_node.ui_def_id;
3166:

Line 3257: UPDATE CZ_UI_PAGES

3253:
3254: IF l_changed_target_ids_tbl.COUNT>0 THEN
3255: FOR j in l_changed_target_ids_tbl.First..l_changed_target_ids_tbl.Last
3256: LOOP
3257: UPDATE CZ_UI_PAGES
3258: SET page_set_id=l_page_set_id
3259: WHERE page_id=l_target_page_ids_tbl(j) AND
3260: ui_def_id=p_ui_node.ui_def_id;
3261:

Line 3401: UPDATE CZ_UI_PAGES

3397: page_id=p_ui_node.page_id AND
3398: element_id=p_ui_node.element_id;
3399:
3400: IF p_ui_node.parent_element_id IS NULL THEN
3401: UPDATE CZ_UI_PAGES
3402: SET pagebase_expl_node_id=p_expl_id
3403: WHERE page_id=p_ui_node.page_id AND
3404: ui_def_id=p_ui_node.ui_def_id;
3405: IF SQL%ROWCOUNT>0 THEN

Line 3576: FROM CZ_UI_PAGES

3572: END IF;
3573: END LOOP;
3574:
3575: FOR i IN (SELECT *
3576: FROM CZ_UI_PAGES
3577: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3578: deleted_flag = G_NO_FLAG)
3579: LOOP
3580: g_ui_pages_tbl(i.page_id) := i;

Line 5322: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

5318: p_element_id IN VARCHAR2,
5319: p_is_parser_open IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
5320:
5321: l_xmldoc xmldom.DOMDocument;
5322: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5323: l_ui_name CZ_UI_DEFS.name%TYPE;
5324: l_page_name CZ_UI_PAGES.name%TYPE;
5325: l_element_path VARCHAR2(32000);
5326:

Line 5324: l_page_name CZ_UI_PAGES.name%TYPE;

5320:
5321: l_xmldoc xmldom.DOMDocument;
5322: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5323: l_ui_name CZ_UI_DEFS.name%TYPE;
5324: l_page_name CZ_UI_PAGES.name%TYPE;
5325: l_element_path VARCHAR2(32000);
5326:
5327: BEGIN
5328:

Line 5333: SELECT jrad_doc,name INTO l_page_jrad_doc,l_page_name FROM CZ_UI_PAGES

5329: IF p_is_parser_open IS NULL OR p_is_parser_open='0' THEN
5330: Open_Parser();
5331: END IF;
5332:
5333: SELECT jrad_doc,name INTO l_page_jrad_doc,l_page_name FROM CZ_UI_PAGES
5334: WHERE ui_def_id=p_ui_def_id AND page_id=p_page_id;
5335:
5336: --
5337: -- create UI Template in JRAD repository

Line 5446: SELECT name INTO l_element_path FROM CZ_UI_PAGES

5442: IF l_run_id > 0 THEN
5443: IF NOT(xmldom.IsNull(p_xml_node)) THEN
5444: l_element_path := get_Element_XML_Path(p_xml_node => p_xml_node);
5445: ELSE -- UI rule on UI page level
5446: SELECT name INTO l_element_path FROM CZ_UI_PAGES
5447: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
5448: END IF;
5449:
5450: IF k.rule_type=33 THEN

Line 5622: FROM CZ_UI_PAGES

5618: BEGIN
5619:
5620: SELECT persistent_node_id,pagebase_expl_node_id
5621: INTO l_pagebase_persistent_node_id, l_pagebase_expl_id
5622: FROM CZ_UI_PAGES
5623: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id;
5624:
5625: RETURN get_Runtime_Relative_Path(p_model_id, l_pagebase_persistent_node_id, l_pagebase_expl_id, p_persistent_node_id, p_ui_node_expl_id);
5626:

Line 5706: FROM CZ_UI_PAGES

5702: ELSE
5703: -- base AMN is not passed, so continue using the AMN of the page as earlier
5704: SELECT persistent_node_id, pagebase_expl_node_id
5705: INTO l_base_persistent_node_id, l_base_expl_node_id
5706: FROM CZ_UI_PAGES
5707: WHERE ui_def_Id = p_target_ui_def_id
5708: AND page_Id = p_target_ui_page_id;
5709: END IF;
5710:

Line 6759: FROM CZ_UI_PAGES

6755:
6756: l_src_page_id := g_tgt_pg_to_src_pg_map(p_ui_node.page_id)(TO_NUMBER(p_ui_node.element_id));
6757:
6758: SELECT jrad_doc INTO l_jrad_doc
6759: FROM CZ_UI_PAGES
6760: WHERE ui_def_id= g_UI_Context.ui_def_id AND
6761: page_id=l_src_page_id;
6762:
6763: l_xml_node_to_move := pluck_XML_node(l_jrad_doc, l_src_page_id, p_ui_node.element_id);

Line 6779: FROM CZ_UI_PAGES

6775: SELECT ps_node_id INTO l_old_component_id
6776: FROM CZ_PS_NODES
6777: WHERE devl_project_id = g_UI_Context.devl_project_id
6778: AND persistent_node_id = (SELECT persistent_node_id
6779: FROM CZ_UI_PAGES
6780: WHERE ui_def_id = g_UI_Context.ui_Def_id
6781: AND page_id = l_src_page_id);
6782:
6783:

Line 7137: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

7133: l_ancestor_node := get_Attribute_Value(l_xml_node,
7134: 'ancestorNode');
7135: IF l_ancestor_node IS NOT NULL THEN
7136:
7137: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
7138: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;
7139:
7140: l_hgrid_element_id := find_Element_Id_Of_XMLTag(l_xml_node, 'oa:tree');
7141: IF NOT(xmldom.IsNull(l_xml_node)) THEN

Line 7791: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

7787: l_ancestor_node := get_Attribute_Value(l_xml_node,
7788: 'ancestorNode');
7789: IF l_ancestor_node IS NOT NULL THEN
7790:
7791: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
7792: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;
7793:
7794: l_hgrid_element_id := find_Element_Id_Of_XMLTag(l_xml_node, 'oa:tree');
7795: IF NOT(xmldom.IsNull(l_xml_node)) THEN

Line 8685: FROM CZ_UI_PAGES

8681: DEBUG('In refresh all model paths: ' || p_page_Id);
8682:
8683: SELECT persistent_node_id,pagebase_expl_node_id
8684: INTO l_pagebase_persistent_node_id, l_pagebase_expl_id
8685: FROM CZ_UI_PAGES
8686: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id;
8687:
8688: refresh_paths_recursive (l_root_node,
8689: l_pagebase_persistent_node_id,

Line 9417: FROM CZ_UI_PAGES

9413:
9414: BEGIN
9415:
9416: SELECT persistent_node_id INTO l_page_persistent_node_id
9417: FROM CZ_UI_PAGES
9418: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
9419:
9420: FOR i IN (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
9421: WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 9422: page_id IN(SELECT page_id FROM CZ_UI_PAGES

9418: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
9419:
9420: FOR i IN (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
9421: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9422: page_id IN(SELECT page_id FROM CZ_UI_PAGES
9423: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9424: persistent_node_id=l_page_persistent_node_id AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)) AND
9425: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
9426: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

Line 10645: FROM CZ_UI_PAGES

10641: IF p_parent_page_id IS NULL THEN
10642:
10643: SELECT MIN(page_id)
10644: INTO x_page_id
10645: FROM CZ_UI_PAGES
10646: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10647: persistent_node_id = p_parent_persistent_node_id AND
10648: NVL(split_seq_nbr,1)=1 AND
10649: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 10655: FROM CZ_UI_PAGES

10651: IF x_page_id IS NULL THEN
10652: NULL;
10653: ELSE
10654: SELECT page_set_id INTO x_page_set_id
10655: FROM CZ_UI_PAGES
10656: WHERE page_id=x_page_id AND
10657: ui_def_id = g_UI_Context.ui_def_id;
10658: END IF;
10659:

Line 10665: FROM CZ_UI_PAGES

10661:
10662: x_page_id := p_parent_page_id;
10663:
10664: SELECT page_set_id INTO x_page_set_id
10665: FROM CZ_UI_PAGES
10666: WHERE page_id=p_parent_page_id AND
10667: ui_def_id = g_UI_Context.ui_def_id;
10668:
10669: END IF;

Line 10789: l_page_node CZ_UI_PAGES%ROWTYPE;

10785: x_page_ref_id OUT NOCOPY NUMBER,
10786: p_parent_page_id IN NUMBER DEFAULT NULL)
10787: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
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;

Line 10797: l_last_page_id CZ_UI_PAGES.page_id%TYPE;

10793: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10795: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10796: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10797: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10798: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;
10799: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10800: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10801: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;

Line 10798: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;

10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10795: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10796: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10797: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10798: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;
10799: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10800: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10801: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10802: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;

Line 10802: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;

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;
10806: l_pagebase_expl_node_id NUMBER;

Line 10852: FROM CZ_UI_PAGES

10848: IF l_parent_page_id IS NOT NULL THEN
10849: BEGIN
10850:
10851: SELECT persistent_node_id INTO l_parent_page_persistent_id
10852: FROM CZ_UI_PAGES
10853: WHERE ui_Def_id = g_UI_Context.ui_def_id
10854: AND page_id = l_parent_page_id;
10855:
10856: IF NOT l_parent_page_persistent_id = p_node.parent_persistent_node_id THEN

Line 10911: l_page_node.page_id := allocateId('CZ_UI_PAGES_S');

10907: -- get num of this page in this UI
10908: --
10909: l_page_counter := get_Page_Counter() + 1;
10910:
10911: l_page_node.page_id := allocateId('CZ_UI_PAGES_S');
10912: l_page_node.ui_def_id := g_UI_Context.ui_def_id;
10913: l_page_node.NAME := 'Page-'||TO_CHAR(l_page_counter);
10914: l_page_node.persistent_node_id := p_node.persistent_node_id;
10915: l_page_node.jrad_doc := generate_JRAD_Page_Name(l_page_counter);

Line 10932: INSERT INTO CZ_UI_PAGES

10928: l_page_node.pagebase_expl_node_id := l_pagebase_expl_node_id;
10929: l_page_node.seeded_flag := G_NO_FLAG;
10930: l_page_node.deleted_flag := G_MARK_TO_ADD;
10931:
10932: INSERT INTO CZ_UI_PAGES
10933: (page_id,
10934: ui_def_id,
10935: NAME,
10936: persistent_node_id,

Line 11212: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES

11208: END IF;
11209:
11210: -- do not create UI region if already exists UI page with the same persistent_node_id
11211: BEGIN
11212: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
11213: WHERE ui_def_id=g_UI_CONTEXT.ui_def_id AND persistent_node_id=p_node.persistent_node_id AND
11214: deleted_flag NOT IN (G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG) AND rownum<2;
11215: RETURN l_ui_node;
11216: EXCEPTION

Line 11606: FROM CZ_UI_PAGES

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
11606: FROM CZ_UI_PAGES
11607: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND
11608: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);
11609:
11610: SELECT MIN(page_set_id) INTO l_target_ui_def_node.page_set_id

Line 11776: target_page_id NOT IN(SELECT page_id FROM CZ_UI_PAGES

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
11776: target_page_id NOT IN(SELECT page_id FROM CZ_UI_PAGES
11777: WHERE ui_def_id=g_UI_Context.ui_def_id);
11778:
11779: IF SQL%ROWCOUNT>0 THEN
11780: --

Line 12035: l_ui_page_node CZ_UI_PAGES%ROWTYPE;

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

Line 12057: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS

12053: END delete_UI_Region;
12054:
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;

Line 12066: SELECT page_set_id,pagebase_path INTO l_page_set_id,l_old_page_path_from_root FROM CZ_UI_PAGES

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
12067: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
12068:
12069: l_target_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
12070: l_page_path_from_root := get_Page_Path(p_node.ps_node_id, NULL);

Line 12073: UPDATE CZ_UI_PAGES

12069: l_target_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
12070: l_page_path_from_root := get_Page_Path(p_node.ps_node_id, NULL);
12071:
12072: IF l_page_path_from_root <> l_old_page_path_from_root THEN
12073: UPDATE CZ_UI_PAGES
12074: SET pagebase_path=l_page_path_from_root,
12075: deleted_flag=DECODE(deleted_flag,G_MARK_TO_ADD,G_MARK_TO_ADD,G_MARK_TO_REFRESH)
12076: WHERE page_id=p_page_id AND
12077: ui_def_id=g_UI_Context.ui_def_id AND

Line 12118: FROM CZ_UI_PAGES

12114: END LOOP;
12115:
12116: ELSE
12117: FOR i in (SELECT page_id
12118: FROM CZ_UI_PAGES
12119: WHERE ui_def_id = g_UI_Context.ui_def_id
12120: AND persistent_node_id = p_node.persistent_node_id
12121: AND deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG))
12122: LOOP

Line 12244: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES

12240: BEGIN
12241:
12242: BEGIN
12243:
12244: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
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

Line 12286: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES

12282: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12283:
12284: BEGIN
12285:
12286: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
12287: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
12288:
12289: IF l_page_set_id IS NOT NULL THEN
12290: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

Line 12683: UPDATE CZ_UI_PAGES

12679: END IF;
12680: END IF;
12681:
12682: IF l_refresh_ui_page THEN
12683: UPDATE CZ_UI_PAGES
12684: SET deleted_flag=G_MARK_TO_REFRESH,
12685: page_rev_nbr = page_rev_nbr + 1
12686: WHERE ui_def_id=p_ui_node.ui_def_id AND
12687: page_id=p_ui_node.page_id;

Line 12758: UPDATE CZ_UI_PAGES

12754: deleted_flag=G_NO_FLAG AND
12755: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;
12756:
12757: IF SQL%ROWCOUNT > 0 THEN
12758: UPDATE CZ_UI_PAGES
12759: SET deleted_flag=G_MARK_TO_REFRESH,
12760: page_rev_nbr = page_rev_nbr + 1
12761: WHERE ui_def_id=p_ui_node.ui_def_id AND
12762: page_id=p_ui_node.page_id;

Line 12870: SELECT page_id INTO l_old_page_id FROM CZ_UI_PAGES

12866: is_UI_Page(p_node => p_model_node,
12867: x_drilldown => l_drilldown) THEN
12868:
12869: BEGIN
12870: SELECT page_id INTO l_old_page_id FROM CZ_UI_PAGES
12871: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12872: persistent_node_id=p_model_node.persistent_node_id AND
12873: deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
12874: rownum<2;

Line 13087: UPDATE CZ_UI_PAGES

13083: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13084: page_id=p_ui_node.page_id AND
13085: element_id=p_ui_node.element_id;
13086:
13087: UPDATE CZ_UI_PAGES
13088: SET deleted_flag=G_MARK_TO_REFRESH,
13089: page_rev_nbr=page_rev_nbr+1
13090: WHERE page_id=p_ui_node.page_id AND
13091: ui_def_id=g_UI_Context.ui_def_id;

Line 13185: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;

13181: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
13182:
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;

Line 13186: l_page_id CZ_UI_PAGES.page_id%TYPE;

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

Line 13205: l_page_id := allocateId('CZ_UI_PAGES_S');

13201:
13202: l_caption_text_id := allocateId('CZ_INTL_TEXTS_S');
13203:
13204: l_element_id := get_Element_Id();
13205: l_page_id := allocateId('CZ_UI_PAGES_S');
13206:
13207: INSERT INTO CZ_INTL_TEXTS
13208: (
13209: INTL_TEXT_ID

Line 13230: INSERT INTO CZ_UI_PAGES

13226: ,l_page_id
13227: ,NULL
13228: );
13229:
13230: INSERT INTO CZ_UI_PAGES
13231: (page_id,
13232: ui_def_id,
13233: NAME,
13234: persistent_node_id,

Line 13292: FROM CZ_UI_PAGES

13288: ENABLED_CONDITION_VALUE,
13289: EMPTY_PAGE_FLAG,
13290: SUPPRESS_REFRESH_FLAG,
13291: G_MARK_TO_ADD
13292: FROM CZ_UI_PAGES
13293: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13294: page_id=p_page_id;
13295:
13296: SELECT * INTO l_ui_node

Line 13893: FOR i IN(SELECT page_id FROM CZ_UI_PAGES a

13889: -- set ordering for UI elements on UI pages
13890: --
13891: PROCEDURE handle_UI_Page_Elements_Order IS
13892: BEGIN
13893: FOR i IN(SELECT page_id FROM CZ_UI_PAGES a
13894: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13895: page_set_id IN
13896: (SELECT page_set_id FROM CZ_UI_PAGE_SETS
13897: WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 13927: (SELECT page_id FROM CZ_UI_PAGES

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
13928: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13929: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,
13930: G_MARK_TO_REFRESH))
13931: AND

Line 13962: (SELECT page_id FROM CZ_UI_PAGES

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
13962: (SELECT page_id FROM CZ_UI_PAGES
13963: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13964: page_set_id=n.page_set_id AND
13965: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
13966: G_NO_FLAG)) AND

Line 13998: (SELECT page_id FROM CZ_UI_PAGES

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
13998: (SELECT page_id FROM CZ_UI_PAGES
13999: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14000: page_set_id=n.page_set_id AND
14001: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
14002: G_NO_FLAG)) AND

Line 14208: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES

14204:
14205: l_exist_on_split_pages_flag := G_NO_FLAG;
14206:
14207: SELECT persistent_node_id,split_seq_nbr
14208: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES
14209: WHERE page_id=p_parent_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
14210:
14211: IF px_page_split_seq_nbr=1 THEN
14212: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

Line 14215: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES

14211: IF px_page_split_seq_nbr=1 THEN
14212: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
14213: WHERE EXISTS
14214: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
14215: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
14216: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
14217: split_seq_nbr>1 AND deleted_flag NOT IN(G_YES_FLAG)) AND
14218: persistent_node_id=p_current_model_node.persistent_node_id AND
14219: deleted_flag NOT IN(G_YES_FLAG));

Line 14224: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES

14220: ELSIF px_page_split_seq_nbr>1 THEN
14221: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
14222: WHERE EXISTS
14223: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
14224: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
14225: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
14226: split_seq_nbr<>px_page_split_seq_nbr AND deleted_flag NOT IN(G_YES_FLAG)) AND
14227: persistent_node_id=p_current_model_node.persistent_node_id AND
14228: deleted_flag NOT IN(G_YES_FLAG));

Line 14488: target_page_id IN(SELECT page_id FROM CZ_UI_PAGES

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
14491: deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD) ))
14492: LOOP

Line 14505: UPDATE CZ_UI_PAGES

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:
14504: IF SQL%ROWCOUNT>0 THEN
14505: UPDATE CZ_UI_PAGES
14506: SET empty_page_flag=G_YES_FLAG
14507: WHERE page_id=i.target_page_id AND
14508: ui_def_id=g_UI_Context.ui_def_id;
14509: END IF;

Line 14519: UPDATE CZ_UI_PAGES

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:
14518: IF SQL%ROWCOUNT>0 THEN
14519: UPDATE CZ_UI_PAGES
14520: SET empty_page_flag=G_NO_FLAG
14521: WHERE page_id=i.target_page_id AND
14522: ui_def_id=g_UI_Context.ui_def_id;
14523: END IF;

Line 14542: (SELECT NULL FROM CZ_UI_PAGES

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

Line 14563: FROM CZ_UI_PAGES

14559: parent_page_ref_id IS NULL AND
14560: deleted_flag=G_NO_FLAG)
14561: LOOP
14562: SELECT NVL(split_seq_nbr,1) INTO l_split_seq_nbr
14563: FROM CZ_UI_PAGES
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

Line 14578: SELECT MAX(split_seq_nbr) INTO l_counter FROM CZ_UI_PAGES

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
14579: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14580: persistent_node_id=i.target_persistent_node_id AND
14581: deleted_flag IN (G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG);
14582: END IF;

Line 14607: p_page_id IN CZ_UI_PAGES.page_id%TYPE,

14603: -- Finds an Instance List containing the xml node passed in and returns its AMN
14604: -- This function also checks the node passed in itself i.e. if the node passed in is
14605: -- an Instance List, then the function will return its AMN
14606: FUNCTION getInstanceListAMN(p_ui_def_id IN CZ_UI_DEFS.ui_def_Id%TYPE,
14607: p_page_id IN CZ_UI_PAGES.page_id%TYPE,
14608: p_xml_node IN xmldom.DOMNode) RETURN expl_node_persistent_id_pair
14609: IS
14610:
14611: l_node xmldom.DOMNode;

Line 14685: FOR i IN(SELECT page_id,pagebase_expl_node_id, jrad_doc FROM CZ_UI_PAGES --vsingava IM-ER

14681: l_null_xml_doc xmldom.DOMDocument;
14682: l_instance_list_amn expl_node_persistent_id_pair;
14683:
14684: BEGIN
14685: FOR i IN(SELECT page_id,pagebase_expl_node_id, jrad_doc FROM CZ_UI_PAGES --vsingava IM-ER
14686: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14687: deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG))
14688: LOOP
14689:

Line 15087: l_pagebase_expl_node_id CZ_UI_PAGES.pagebase_expl_node_id%TYPE;

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

Line 15248: UPDATE CZ_UI_PAGES

15244:
15245: mark_UI_Page_As_Refreshed(l_parent_ui_node.page_id, l_parent_ui_node.ui_def_id);
15246:
15247: -- update the page_rev_nbr of the other (source) page
15248: UPDATE CZ_UI_PAGES
15249: SET page_rev_nbr=page_rev_nbr+1
15250: WHERE page_id=i.page_id AND ui_def_id=i.ui_def_id;
15251:
15252: ELSE -- If parent_node not found

Line 15263: FROM CZ_UI_PAGES

15259:
15260:
15261:
15262: SELECT pagebase_expl_node_id INTO l_pagebase_expl_node_id
15263: FROM CZ_UI_PAGES
15264: WHERE ui_def_id=g_UI_Context.ui_def_id
15265: AND page_id = i.page_id
15266: AND deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);
15267:

Line 15699: FOR m IN(SELECT page_id, pagebase_expl_node_id FROM CZ_UI_PAGES

15695: IF (contains_BOM_Nodes(p_ps_node.ps_node_id)) THEN
15696: --
15697: -- Add bom table here
15698: --
15699: FOR m IN(SELECT page_id, pagebase_expl_node_id FROM CZ_UI_PAGES
15700: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15701: deleted_flag IN(G_NO_FLAG, G_MARK_TO_REFRESH) AND
15702: persistent_node_id = p_ps_node.persistent_node_id)
15703: LOOP

Line 15810: FOR upgel IN(SELECT b.*,a.pagebase_expl_node_id,a.jrad_doc FROM CZ_UI_PAGES a,CZ_UI_PAGE_ELEMENTS b

15806: WHERE model_id=g_UI_Context.devl_project_id AND deleted_flag='0' AND
15807: ((t.ps_node_type NOT IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND component_id=t.component_id) OR
15808: (t.ps_node_type IN(G_REFERENCE_TYPE,G_CONNECTOR_TYPE) AND referring_node_id=t.ps_node_id));
15809:
15810: FOR upgel IN(SELECT b.*,a.pagebase_expl_node_id,a.jrad_doc FROM CZ_UI_PAGES a,CZ_UI_PAGE_ELEMENTS b
15811: WHERE a.ui_def_id=g_UI_Context.ui_def_id AND b.ui_def_id=g_UI_Context.ui_def_id AND
15812: a.deleted_flag IN(G_MARK_TO_ADD, G_MARK_TO_REFRESH, G_NO_FLAG) AND
15813: a.page_id=b.page_id AND
15814: b.persistent_node_id = t.psnode_persistent_node_id)

Line 15824: UPDATE CZ_UI_PAGES

15820: page_id=upgel.page_id AND
15821: persistent_node_id=t.psnode_persistent_node_id AND
15822: model_ref_expl_id<>l_expl_id;
15823:
15824: UPDATE CZ_UI_PAGES
15825: SET pagebase_expl_node_id=l_expl_id
15826: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15827: page_id=upgel.page_id AND
15828: persistent_node_id=t.psnode_persistent_node_id AND

Line 15850: UPDATE CZ_UI_PAGES

15846: target_persistent_node_id=t.psnode_persistent_node_id AND
15847: target_expl_node_id<>l_expl_id;
15848:
15849: IF upgel.deleted_flag=G_NO_FLAG THEN
15850: UPDATE CZ_UI_PAGES
15851: SET deleted_flag=G_MARK_TO_REFRESH
15852: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15853: page_id=upgel.page_id AND
15854: deleted_flag=G_NO_FLAG;

Line 16102: UPDATE CZ_UI_PAGES

16098: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16099: page_id=p_page_id AND
16100: deleted_flag=G_MARK_TO_DEASSOCIATE;
16101: IF SQL%ROWCOUNT>0 THEN
16102: UPDATE CZ_UI_PAGES
16103: SET page_rev_nbr=page_rev_nbr+1
16104: WHERE page_id=p_page_id AND
16105: ui_def_id=g_UI_Context.ui_def_id;
16106: END IF;

Line 16289: UPDATE CZ_UI_PAGES

16285: END IF;
16286:
16287: END LOOP;
16288:
16289: UPDATE CZ_UI_PAGES
16290: SET page_rev_nbr=page_rev_nbr+1
16291: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16292: page_id=p_ui_page_id;
16293:

Line 16523: FROM CZ_UI_PAGES

16519: l_col_number := 0;
16520: END IF;
16521:
16522: SELECT jrad_doc INTO l_jrad_doc
16523: FROM CZ_UI_PAGES
16524: WHERE ui_def_id= g_UI_Context.ui_def_id AND
16525: page_id=p_page_id;
16526:
16527: --

Line 16857: FROM CZ_UI_PAGES

16853: --
16854: PROCEDURE handle_JRAD_Pages IS
16855: BEGIN
16856: FOR i IN (SELECT page_id, jrad_doc, deleted_flag
16857: FROM CZ_UI_PAGES
16858: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16859: deleted_flag <> G_YES_FLAG)
16860: LOOP
16861: IF i.deleted_flag IN(G_MARK_TO_DELETE,G_MARK_TO_ADD,

Line 16916: l_name CZ_UI_PAGES.NAME%TYPE;

16912:
16913: FUNCTION get_page_name(p_ui_def_id IN NUMBER, p_page_id IN NUMBER)
16914: RETURN VARCHAR2
16915: IS
16916: l_name CZ_UI_PAGES.NAME%TYPE;
16917: BEGIN
16918: SELECT NVL(name, to_char(page_id)) INTO l_name
16919: FROM cz_ui_pages
16920: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;

Line 16919: FROM cz_ui_pages

16915: IS
16916: l_name CZ_UI_PAGES.NAME%TYPE;
16917: BEGIN
16918: SELECT NVL(name, to_char(page_id)) INTO l_name
16919: FROM cz_ui_pages
16920: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;
16921: RETURN l_name;
16922: END get_page_name;
16923:

Line 16968: UPDATE CZ_UI_PAGES

16964: SET target_page_ui_def_id = NULL, target_page_id = NULL
16965: WHERE ui_def_id = p_ui_def_id AND
16966: page_id = p_page_id AND element_id = p_element_id;
16967:
16968: UPDATE CZ_UI_PAGES
16969: SET page_rev_nbr = page_rev_nbr + 1
16970: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;
16971: END remove_target_page;
16972: --vsingava IM-ER

Line 16979: l_name CZ_UI_PAGES.name%TYPE;

16975: p_base_expl_Id NUMBER)
16976: IS
16977:
16978: l_target_persistent_node_id NUMBER;
16979: l_name CZ_UI_PAGES.name%TYPE;
16980: l_page_Id CZ_UI_PAGES.page_Id%TYPE;
16981: l_ui_def_id NUMBER;
16982: l_instance_list_amn expl_node_persistent_id_pair;
16983: l_reachable BOOLEAN;

Line 16980: l_page_Id CZ_UI_PAGES.page_Id%TYPE;

16976: IS
16977:
16978: l_target_persistent_node_id NUMBER;
16979: l_name CZ_UI_PAGES.name%TYPE;
16980: l_page_Id CZ_UI_PAGES.page_Id%TYPE;
16981: l_ui_def_id NUMBER;
16982: l_instance_list_amn expl_node_persistent_id_pair;
16983: l_reachable BOOLEAN;
16984: l_base_expl_id NUMBER;

Line 16997: FROM cz_ui_pages

16993: l_base_persistent_node_id := p_base_persistent_node_Id;
16994:
16995: BEGIN
16996: SELECT persistent_node_id, name, page_Id INTO l_target_persistent_node_id, l_name, l_page_Id
16997: FROM cz_ui_pages
16998: WHERE ui_def_id = p_element.target_page_ui_def_id AND
16999: page_id = p_element.target_page_id AND deleted_flag <> '1';
17000: EXCEPTION
17001: -- target page not exist

Line 17156: FROM CZ_UI_PAGES a, CZ_UI_PAGE_ELEMENTS b

17152: b.ui_def_id AS ref_ui_def_id, b.page_id AS ref_page_id,
17153: b.name AS ref_element_name, b.element_id AS ref_element_id,
17154: b.persistent_node_id as persistent_node_id,
17155: b.model_ref_expl_id as expl_node_id
17156: FROM CZ_UI_PAGES a, CZ_UI_PAGE_ELEMENTS b
17157: WHERE a.ui_def_id = g_UI_Context.ui_def_id AND
17158: b.element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
17159: b.deleted_flag = G_NO_FLAG AND
17160: a.ui_def_id = b.target_page_ui_def_id AND

Line 17175: FROM CZ_UI_PAGES pg

17171: WHILE l_ui_def_id IS NOT NULL
17172: LOOP
17173: l_flag := 1;
17174: FOR i IN (SELECT page_id, jrad_doc, pagebase_expl_node_id, persistent_node_id
17175: FROM CZ_UI_PAGES pg
17176: WHERE ui_def_id = l_ui_def_id AND deleted_flag = '0'
17177: AND EXISTS (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
17178: WHERE ui_def_id = pg.ui_def_id AND page_id = pg.page_id AND
17179: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND

Line 17197: UPDATE CZ_UI_PAGES

17193: handle_page_include_region(j, i.persistent_node_id, i.pagebase_expl_node_id);
17194: END LOOP;
17195:
17196: IF l_resave_doc_flag = 1 THEN
17197: UPDATE CZ_UI_PAGES
17198: SET page_rev_nbr = page_rev_nbr + 1
17199: WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id;
17200:
17201: save_document(l_xmldoc, i.jrad_doc);

Line 17523: --bug14029835 , Added procedure that checks the data in cz_ui_page_elements, cz_ui_pages

17519: WHEN OTHERS THEN
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:

Line 17540: -- Verify for cz_ui_pages.pagebase_expl_node_id

17536: )
17537: LOOP
17538:
17539:
17540: -- Verify for cz_ui_pages.pagebase_expl_node_id
17541: FOR uiPages IN (SELECT uipg.page_id,uipg.pagebase_expl_node_id FROM CZ_UI_PAGES uipg
17542: WHERE deleted_flag = G_NO_FLAG AND ui_def_id = uiDefCur.ref_ui_def_id
17543: AND uipg.pagebase_expl_node_id IS NOT NULL
17544: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS

Line 17541: FOR uiPages IN (SELECT uipg.page_id,uipg.pagebase_expl_node_id FROM CZ_UI_PAGES uipg

17537: LOOP
17538:
17539:
17540: -- Verify for cz_ui_pages.pagebase_expl_node_id
17541: FOR uiPages IN (SELECT uipg.page_id,uipg.pagebase_expl_node_id FROM CZ_UI_PAGES uipg
17542: WHERE deleted_flag = G_NO_FLAG AND ui_def_id = uiDefCur.ref_ui_def_id
17543: AND uipg.pagebase_expl_node_id IS NOT NULL
17544: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17545: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = uipg.pagebase_expl_node_id

Line 17550: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGES where pagebase_expl_node_id : ' || uiPages.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);

17546: )
17547: )
17548: LOOP
17549:
17550: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGES where pagebase_expl_node_id : ' || uiPages.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17551:
17552: UPDATE CZ_UI_PAGES
17553: SET deleted_flag = G_YES_FLAG
17554: WHERE pagebase_expl_node_id = uiPages.pagebase_expl_node_id

Line 17552: UPDATE CZ_UI_PAGES

17548: LOOP
17549:
17550: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGES where pagebase_expl_node_id : ' || uiPages.pagebase_expl_node_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17551:
17552: UPDATE CZ_UI_PAGES
17553: SET deleted_flag = G_YES_FLAG
17554: WHERE pagebase_expl_node_id = uiPages.pagebase_expl_node_id
17555: AND page_id = uiPages.page_id
17556: AND ui_def_id = uiDefCur.ref_ui_def_id;

Line 18116: l_page_name CZ_UI_PAGES.name%TYPE;

18112: l_name_tbl varchar_tbl_type;
18113: l_target_page_ui_def_id_tbl number_tbl_type;
18114: l_target_page_id_tbl number_tbl_type;
18115: l_ui_name CZ_UI_DEFS.name%TYPE;
18116: l_page_name CZ_UI_PAGES.name%TYPE;
18117: l_pagebase_expl_id NUMBER;
18118: l_ui_def_id NUMBER;
18119: l_target_persistent_node_id NUMBER;
18120:

Line 18139: SELECT name INTO l_page_name FROM CZ_UI_PAGES

18135:
18136: IF l_name_tbl.COUNT>0 THEN
18137: FOR i IN l_name_tbl.First..l_name_tbl.Last
18138: LOOP
18139: SELECT name INTO l_page_name FROM CZ_UI_PAGES
18140: WHERE page_id=l_target_page_id_tbl(i) AND ui_def_id=l_target_page_ui_def_id_tbl(i);
18141: SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);
18142: add_Error_Message(p_message_name => 'CZ_CP_PIR_REF_UI_NOT_IN_CHAIN',
18143: p_token_name1 => 'RGNNAME',

Line 18168: FROM cz_ui_pages

18164: -- target page exists?
18165: l_target_persistent_node_id := NULL;
18166: BEGIN
18167: SELECT persistent_node_id INTO l_target_persistent_node_id
18168: FROM cz_ui_pages
18169: WHERE ui_def_id = i.target_page_ui_def_id AND
18170: page_id = i.target_page_id AND deleted_flag <> '1';
18171: EXCEPTION
18172: -- target page not exist

Line 18191: FROM cz_ui_pages

18187:
18188: -- target page exists. check if reachable
18189: IF l_target_persistent_node_id IS NOT NULL THEN
18190: SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
18191: FROM cz_ui_pages
18192: WHERE ui_def_id = p_ui_def_id AND
18193: page_id = i.page_id;
18194:
18195: IF i.persistent_node_id = l_target_persistent_node_id THEN

Line 18735: l_jrad_doc CZ_UI_PAGES.jrad_doc%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;
18738: l_condition_id NUMBER;
18739: l_caption_text_id NUMBER;

Line 18784: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

18780: WHERE ui_def_id=p_ui_def_id AND
18781: page_id=p_ui_page_id AND
18782: element_id=p_element_id;
18783:
18784: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
18785: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
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:

Line 18831: UPDATE CZ_UI_PAGES

18827: -- set data for Page Sets
18828: --
18829: handle_Page_Flows();
18830:
18831: UPDATE CZ_UI_PAGES
18832: SET deleted_flag=G_YES_FLAG
18833: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG
18834: RETURNING caption_text_id,caption_rule_id,display_condition_id,enabled_condition_id
18835: INTO l_caption_text_id,l_caption_rule_id,l_display_condition_id,l_enabled_condition_id;

Line 18907: UPDATE CZ_UI_PAGES

18903: Save_Document(p_xml_doc => l_xmldoc,
18904: p_doc_name => l_jrad_doc);
18905: END IF;
18906:
18907: UPDATE CZ_UI_PAGES
18908: SET page_rev_nbr=page_rev_nbr+1
18909: WHERE ui_def_id=p_ui_def_id AND
18910: page_id=p_ui_page_id;
18911:

Line 19007: l_page_id CZ_UI_PAGES.page_id%TYPE;

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;
19010:
19011: BEGIN

Line 19008: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;

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;
19010:
19011: BEGIN
19012:

Line 19053: -- null out CZ_UI_PAGES.page_set_id for those UI pages in this UI

19049: AND page_ref_id=p_page_ref_id;
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

Line 19056: UPDATE CZ_UI_PAGES a

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

Line 19096: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19092: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
19093: ) IS
19094:
19095: l_xmldoc xmldom.DOMDocument;
19096: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19097:
19098: BEGIN
19099:
19100: --

Line 19191: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19187: l_xmldoc xmldom.DOMDocument;
19188: l_out_node xmldom.DOMNode;
19189: l_parent_node xmldom.DOMNode;
19190: l_xml_node xmldom.DOMNode;
19191: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19192: l_needs_to_be_unlocked BOOLEAN;
19193:
19194: BEGIN
19195:

Line 19342: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19338: l_stacklayout_uicont_xml_node xmldom.DOMNode;
19339: l_xml_uicont_node xmldom.DOMNode;
19340: l_xml_new_node xmldom.DOMNode;
19341: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
19342: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19343: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19344: l_pagebase_persistent_node_id NUMBER;
19345: l_pagebase_expl_node_id NUMBER;
19346: l_length NUMBER;

Line 19343: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19339: l_xml_uicont_node xmldom.DOMNode;
19340: l_xml_new_node xmldom.DOMNode;
19341: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
19342: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19343: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19344: l_pagebase_persistent_node_id NUMBER;
19345: l_pagebase_expl_node_id NUMBER;
19346: l_length NUMBER;
19347: l_base_persistent_node_id NUMBER;

Line 19362: INTO l_source_jrad_doc FROM CZ_UI_PAGES

19358: --
19359: -- get jrad_doc of source UI page to which this UI element belongs to
19360: --
19361: SELECT jrad_doc
19362: INTO l_source_jrad_doc FROM CZ_UI_PAGES
19363: WHERE page_id=p_source_ui_page_id AND
19364: ui_def_id=p_source_ui_def_id;
19365:
19366: SELECT jrad_doc, persistent_node_id, pagebase_expl_node_id

Line 19368: FROM CZ_UI_PAGES

19364: ui_def_id=p_source_ui_def_id;
19365:
19366: SELECT jrad_doc, persistent_node_id, pagebase_expl_node_id
19367: INTO l_target_jrad_doc, l_pagebase_persistent_node_id, l_pagebase_expl_node_id
19368: FROM CZ_UI_PAGES
19369: WHERE page_id=p_target_ui_page_id AND
19370: ui_def_id=p_target_ui_def_id;
19371:
19372:

Line 19469: UPDATE CZ_UI_PAGES

19465:
19466: Save_Document(p_xml_doc => p_target_xmldoc,
19467: p_doc_name => l_target_jrad_doc);
19468:
19469: UPDATE CZ_UI_PAGES
19470: SET page_rev_nbr=page_rev_nbr+1,
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;

Line 19515: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19511: l_out_xml_node xmldom.DOMNode;
19512: l_target_uicont_xml_node xmldom.DOMNode;
19513: l_stacklayout_node xmldom.DOMNode;
19514: l_stacklayout_uicont_xml_node xmldom.DOMNode;
19515: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19516: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19517: l_xml_uicont_node xmldom.DOMNode;
19518: l_xml_new_node xmldom.DOMNode;
19519: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

Line 19516: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19512: l_target_uicont_xml_node xmldom.DOMNode;
19513: l_stacklayout_node xmldom.DOMNode;
19514: l_stacklayout_uicont_xml_node xmldom.DOMNode;
19515: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19516: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19517: l_xml_uicont_node xmldom.DOMNode;
19518: l_xml_new_node xmldom.DOMNode;
19519: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
19520: l_new_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

Line 19538: INTO l_source_jrad_doc FROM CZ_UI_PAGES

19534: --
19535: -- get jrad_doc of source UI page to which this UI element belongs to
19536: --
19537: SELECT jrad_doc
19538: INTO l_source_jrad_doc FROM CZ_UI_PAGES
19539: WHERE page_id=p_source_ui_page_id AND
19540: ui_def_id=p_source_ui_def_id;
19541:
19542: --

Line 19547: FROM CZ_UI_PAGES

19543: -- get jrad_doc of source UI page to which this UI element belongs to
19544: --
19545: SELECT jrad_doc,persistent_node_id
19546: INTO l_target_jrad_doc, l_pagebase_persistent_node_id
19547: FROM CZ_UI_PAGES
19548: WHERE page_id=p_target_ui_page_id AND
19549: ui_def_id=p_target_ui_def_id;
19550:
19551: --

Line 19659: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19655: x_new_jrad_doc OUT NOCOPY VARCHAR2
19656: ) IS
19657:
19658: l_source_xml_node xmldom.DOMNode;
19659: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19660: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19661: l_element_id_tbl number_tbl_type;
19662: l_parent_element_id_tbl number_tbl_type;
19663: l_element_id_arr_tbl number_tbl_type;

Line 19660: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19656: ) IS
19657:
19658: l_source_xml_node xmldom.DOMNode;
19659: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19660: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19661: l_element_id_tbl number_tbl_type;
19662: l_parent_element_id_tbl number_tbl_type;
19663: l_element_id_arr_tbl number_tbl_type;
19664: l_new_element_id_arr_tbl number_tbl_type;

Line 19692: FROM CZ_UI_PAGES

19688: -- get jrad_doc of source UI page to which this UI element belongs to
19689: --
19690: SELECT jrad_doc,persistent_node_id, pagebase_expl_node_id
19691: INTO l_source_jrad_doc,l_persistent_node_id, l_pagebase_expl_node_id
19692: FROM CZ_UI_PAGES
19693: WHERE ui_def_id=p_source_ui_def_id AND
19694: page_id=p_source_ui_page_id;
19695:
19696: SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES

Line 19696: SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES

19692: FROM CZ_UI_PAGES
19693: WHERE ui_def_id=p_source_ui_def_id AND
19694: page_id=p_source_ui_page_id;
19695:
19696: SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES
19697: WHERE ui_def_id=p_target_ui_def_id AND
19698: persistent_node_id=l_persistent_node_id;
19699:
19700: l_target_jrad_doc := '/oracle/apps/cz/runtime/oa/webui/regions/ui' ||

Line 19709: FOR i IN(SELECT * FROM CZ_UI_PAGES

19705: '_'||TO_CHAR(p_target_ui_def_id)||'_');
19706:
19707: x_new_jrad_doc := l_target_jrad_doc;
19708:
19709: FOR i IN(SELECT * FROM CZ_UI_PAGES
19710: WHERE ui_def_id=p_source_ui_def_id AND
19711: page_id=p_source_ui_page_id)
19712: LOOP
19713:

Line 19714: x_new_ui_page_id := allocateId('CZ_UI_PAGES_S');

19710: WHERE ui_def_id=p_source_ui_def_id AND
19711: page_id=p_source_ui_page_id)
19712: LOOP
19713:
19714: x_new_ui_page_id := allocateId('CZ_UI_PAGES_S');
19715:
19716: l_caption_text_id := copy_Intl_Text(i.caption_text_id, p_target_ui_def_id, NULL, NULL);
19717:
19718: copy_UI_Rule( i.caption_rule_id, l_caption_rule_id,

Line 19727: INSERT INTO CZ_UI_PAGES

19723:
19724: copy_UI_Rule( i.enabled_condition_id, l_enabled_condition_id,
19725: p_target_ui_def_id,x_new_ui_page_id,NULL,p_source_ui_def_id);
19726:
19727: INSERT INTO CZ_UI_PAGES
19728: (
19729: PAGE_ID
19730: ,UI_DEF_ID
19731: ,PERSISTENT_NODE_ID

Line 19850: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19846: ) IS
19847:
19848: l_source_xmldoc xmldom.DOMDocument;
19849: l_source_xml_node xmldom.DOMNode;
19850: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19851: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19852: l_element_id_tbl number_tbl_type;
19853: l_parent_element_id_tbl number_tbl_type;
19854: l_element_id_arr_tbl number_tbl_type;

Line 19851: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19847:
19848: l_source_xmldoc xmldom.DOMDocument;
19849: l_source_xml_node xmldom.DOMNode;
19850: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19851: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19852: l_element_id_tbl number_tbl_type;
19853: l_parent_element_id_tbl number_tbl_type;
19854: l_element_id_arr_tbl number_tbl_type;
19855: l_new_element_id_arr_tbl number_tbl_type;

Line 19892: FROM CZ_UI_PAGES

19888: -- get jrad_doc of source UI page to which this UI element belongs to
19889: --
19890: SELECT jrad_doc,persistent_node_id
19891: INTO l_source_jrad_doc,l_persistent_node_id
19892: FROM CZ_UI_PAGES
19893: WHERE ui_def_id=p_source_ui_def_id AND
19894: page_id=p_source_ui_page_id;
19895:
19896: --

Line 20148: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20144: l_source_template_xmldoc xmldom.DOMDocument;
20145: l_template_root_xml_node xmldom.DOMNode;
20146: l_xml_node xmldom.DOMNode;
20147: l_child_nodes_tbl xmldom.DOMNodeList;
20148: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20149: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20150: l_length NUMBER;
20151: l_needs_to_be_unlocked BOOLEAN;
20152:

Line 20149: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20145: l_template_root_xml_node xmldom.DOMNode;
20146: l_xml_node xmldom.DOMNode;
20147: l_child_nodes_tbl xmldom.DOMNodeList;
20148: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20149: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20150: l_length NUMBER;
20151: l_needs_to_be_unlocked BOOLEAN;
20152:
20153: BEGIN

Line 20442: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20438: l_target_uicont_xml_node xmldom.DOMNode;
20439: l_xml_temp_node xmldom.DOMNode;
20440: l_stacklayout_node xmldom.DOMNode;
20441: l_stacklayout_uicont_xml_node xmldom.DOMNode;
20442: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20443: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20444: l_needs_to_be_unlocked BOOLEAN;
20445: BEGIN
20446:

Line 20443: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20439: l_xml_temp_node xmldom.DOMNode;
20440: l_stacklayout_node xmldom.DOMNode;
20441: l_stacklayout_uicont_xml_node xmldom.DOMNode;
20442: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20443: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20444: l_needs_to_be_unlocked BOOLEAN;
20445: BEGIN
20446:
20447: --

Line 20652: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20648: l_switcher_casename VARCHAR2(255);
20649: l_switcher_xml_id VARCHAR2(255);
20650: l_uicase_name VARCHAR2(255);
20651: l_child_nodes_tbl xmldom.DOMNodeList;
20652: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20653: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20654: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
20655: l_attribute_value VARCHAR2(255);
20656: l_length NUMBER;

Line 20653: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20649: l_switcher_xml_id VARCHAR2(255);
20650: l_uicase_name VARCHAR2(255);
20651: l_child_nodes_tbl xmldom.DOMNodeList;
20652: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20653: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20654: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
20655: l_attribute_value VARCHAR2(255);
20656: l_length NUMBER;
20657: l_needs_to_be_unlocked BOOLEAN;

Line 20679: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a

20675: --
20676: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
20677: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
20678:
20679: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a
20680: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id;
20681:
20682:
20683: --

Line 20894: UPDATE CZ_UI_PAGES

20890: -- close XML parser
20891: --
20892: Close_Parser();
20893:
20894: UPDATE CZ_UI_PAGES
20895: SET page_rev_nbr=page_rev_nbr+1
20896: WHERE ui_def_id=p_ui_def_id AND
20897: page_id=p_ui_page_id;
20898:

Line 20959: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20955: l_new_ui_element_id VARCHAR2(255);
20956: l_user_attribute3_value VARCHAR2(4000);
20957: l_switcher_casename VARCHAR2(255);
20958: l_child_nodes_tbl xmldom.DOMNodeList;
20959: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20960: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20961: l_attribute_value VARCHAR2(255);
20962: l_length NUMBER;
20963: l_needs_to_be_unlocked BOOLEAN;

Line 20960: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20956: l_user_attribute3_value VARCHAR2(4000);
20957: l_switcher_casename VARCHAR2(255);
20958: l_child_nodes_tbl xmldom.DOMNodeList;
20959: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20960: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20961: l_attribute_value VARCHAR2(255);
20962: l_length NUMBER;
20963: l_needs_to_be_unlocked BOOLEAN;
20964: BEGIN

Line 21191: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

21187: l_xml_node xmldom.DOMNode;
21188: l_root_xml_node xmldom.DOMNode;
21189: l_parent_xml_node xmldom.DOMNode;
21190: l_child_nodes_tbl xmldom.DOMNodeList;
21191: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
21192: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
21193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
21194: l_node_map_tbl xmldom.DOMNamedNodeMap;
21195: l_node_attr xmldom.DOMNode;

Line 21192: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

21188: l_root_xml_node xmldom.DOMNode;
21189: l_parent_xml_node xmldom.DOMNode;
21190: l_child_nodes_tbl xmldom.DOMNodeList;
21191: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
21192: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
21193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
21194: l_node_map_tbl xmldom.DOMNamedNodeMap;
21195: l_node_attr xmldom.DOMNode;
21196: l_prev_xml_node xmldom.DOMNode;

Line 21238: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

21234: IF (p_ui_def_id=0) THEN
21235: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
21236: WHERE template_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
21237: ELSE
21238: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
21239: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
21240:
21241: END IF;
21242:

Line 21560: UPDATE CZ_UI_PAGES

21556: SET TEMPLATE_REV_NBR=TEMPLATE_REV_NBR+1
21557: WHERE ui_def_id=p_ui_def_id AND
21558: template_id=p_ui_page_id;
21559: else
21560: UPDATE CZ_UI_PAGES
21561: SET page_rev_nbr=page_rev_nbr+1
21562: WHERE ui_def_id=p_ui_def_id AND
21563: page_id=p_ui_page_id;
21564: end if;

Line 21630: l_page_id CZ_UI_PAGES.page_id%TYPE;

21626: PROCEDURE validate_UI_Conditions(p_ui_def_id IN NUMBER,
21627: p_is_parser_open IN VARCHAR2 DEFAULT NULL) IS
21628:
21629: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
21630: l_page_id CZ_UI_PAGES.page_id%TYPE;
21631:
21632: BEGIN
21633: FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a
21634: WHERE ui_def_id=p_ui_def_id AND

Line 21649: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES

21645: (i.ui_page_id IS NOT NULL AND i.ui_page_id<>0) THEN
21646: SELECT element_id INTO l_element_id FROM CZ_UI_PAGE_ELEMENTS
21647: WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
21648: parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE) AND rownum<2;
21649: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
21650: WHERE page_id=i.ui_page_id AND ui_def_id=p_ui_def_id AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
21651: END IF;
21652:
21653: validate_UI_Condition(p_ui_def_id,i.rule_id,i.rule_type, i.ui_page_id,i.ui_page_element_id, p_is_parser_open);

Line 21830: target_page_id IN (SELECT page_id FROM cz_ui_pages

21826:
21827: UPDATE cz_ui_page_elements
21828: SET target_page_ui_def_id = NULL, target_page_id = NULL
21829: WHERE deleted_flag = '0' AND target_page_ui_def_id = l_old_child_ui_def_id AND
21830: target_page_id IN (SELECT page_id FROM cz_ui_pages
21831: WHERE ui_def_id = l_old_child_ui_def_id AND deleted_flag = '0') AND
21832: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;
21833:
21834: EXCEPTION

Line 21927: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);

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:
21931: SELECT template_name