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 726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;

722:
723: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
724: g_currPageRefSeqVal := g_currentPageRef;
725:
726: SELECT CZ_UI_PAGES_S.nextval INTO g_currentPage FROM dual;
727: g_currPageSeqVal := g_currentPage;
728:
729: SELECT CZ_UI_PAGE_SETS_S.nextval INTO g_currentPageSet FROM dual;
730: g_currPageSetSeqVal := g_currentPageSet;

Line 1028: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN

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

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

1028: ELSIF p_sequence_name='CZ_UI_PAGES_S' THEN
1029: IF g_currentPage 1030: g_currentPage := g_currentPage+1;
1031: ELSE
1032: SELECT CZ_UI_PAGES_S.nextval INTO g_currPageSeqVal FROM dual;
1033: g_currentPage := g_currPageSeqVal;
1034: END IF;
1035: RETURN g_currentPage;
1036: ELSIF p_sequence_name='CZ_UI_PAGE_SETS_S' THEN

Line 1107: UPDATE CZ_UI_PAGES

1103: --
1104: PROCEDURE mark_UI_Page_As_Refreshed(p_page_id IN NUMBER,
1105: p_ui_def_id IN NUMBER) IS
1106: BEGIN
1107: UPDATE CZ_UI_PAGES
1108: SET deleted_flag = DECODE(deleted_flag,G_MARK_TO_ADD,
1109: G_MARK_TO_ADD,G_MARK_TO_REFRESH),
1110: page_rev_nbr=page_rev_nbr+1
1111: WHERE page_id=p_page_id AND

Line 1122: UPDATE CZ_UI_PAGES

1118: --
1119: PROCEDURE mark_UI_Page_As_Deleted(p_page_id IN NUMBER,
1120: p_ui_def_id IN NUMBER) IS
1121: BEGIN
1122: UPDATE CZ_UI_PAGES
1123: SET deleted_flag = G_MARK_TO_DELETE
1124: WHERE page_id=p_page_id AND
1125: ui_def_id=p_ui_def_id;
1126: END mark_UI_Page_As_Deleted;

Line 1148: UPDATE CZ_UI_PAGES

1144: BEGIN
1145:
1146: IF p_hmode = G_DELETE_PAGE THEN
1147:
1148: UPDATE CZ_UI_PAGES
1149: SET page_rev_nbr = page_rev_nbr + 1,
1150: deleted_flag = G_YES_FLAG
1151: WHERE page_id = p_page_id AND
1152: ui_def_id = g_UI_Context.ui_def_id;

Line 1175: UPDATE CZ_UI_PAGES

1171: IF SQL%ROWCOUNT>0 THEN
1172: --
1173: -- update revision of deleted UI page
1174: --
1175: UPDATE CZ_UI_PAGES
1176: SET page_rev_nbr = page_rev_nbr + 1
1177: WHERE page_id = p_page_id AND
1178: ui_def_id = g_UI_Context.ui_def_id;
1179: END IF;

Line 1187: UPDATE CZ_UI_PAGES

1183: --
1184: -- update page status and page_rev_nbr
1185: -- page_rev_nbr=1 because this is first creation
1186: --
1187: UPDATE CZ_UI_PAGES
1188: SET page_rev_nbr = page_rev_nbr+1,
1189: deleted_flag = G_NO_FLAG
1190: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1191: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 1201: UPDATE CZ_UI_PAGES

1197: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
1198:
1199: ELSIF p_hmode = G_NEW_PAGE THEN
1200:
1201: UPDATE CZ_UI_PAGES
1202: SET page_rev_nbr = 1,
1203: deleted_flag = G_NO_FLAG
1204: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1205: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 1215: UPDATE CZ_UI_PAGES

1211: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
1212: ELSE
1213: NULL;
1214: /*
1215: UPDATE CZ_UI_PAGES
1216: SET deleted_flag = G_NO_FLAG
1217: WHERE page_id = p_page_id AND ui_def_id = g_UI_Context.ui_def_id AND
1218: deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
1219:

Line 1444: FROM CZ_UI_PAGES

1440: -- if it is cached then get it from cache
1441: --
1442: SELECT COUNT(page_id)
1443: INTO l_page_counter
1444: FROM CZ_UI_PAGES
1445: WHERE ui_def_id = g_UI_Context.ui_def_id;
1446:
1447: RETURN l_page_counter;
1448:

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

1449: END get_Page_Counter;
1450:
1451: --
1452: -- construct JRAD Page/Region name based on ui_def_id and page_id
1453: -- Parameters : p_page_id - identifies UI page ( -> CZ_UI_PAGES.page_id )
1454: -- Return : JRAD Page/Region name
1455: --
1456: FUNCTION generate_JRAD_Page_Name(p_page_counter IN NUMBER)
1457: RETURN VARCHAR2 IS

Line 1459: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

1455: --
1456: FUNCTION generate_JRAD_Page_Name(p_page_counter IN NUMBER)
1457: RETURN VARCHAR2 IS
1458:
1459: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
1460: l_counter NUMBER;
1461:
1462: BEGIN
1463:

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

1468: l_jrad_doc := '/oracle/apps/cz/runtime/oa/webui/regions/ui' ||
1469: TO_CHAR(g_UI_Context.ui_def_id) || '/Page_' ||TO_CHAR(g_UI_Context.ui_def_id)||'_'||
1470: TO_CHAR(p_page_counter);
1471:
1472: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
1473: WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;
1474:
1475: IF l_counter>0 THEN
1476: l_counter:=l_counter+1;

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

1476: l_counter:=l_counter+1;
1477: l_jrad_doc := l_jrad_doc||'_'||TO_CHAR(l_counter);
1478:
1479: LOOP
1480: SELECT COUNT(*) INTO l_counter FROM CZ_UI_PAGES
1481: WHERE ui_def_id=g_UI_Context.ui_def_id AND jrad_doc=l_jrad_doc;
1482: IF l_counter=0 THEN
1483: EXIT;
1484: ELSE

Line 1749: RETURN CZ_UI_PAGES%ROWTYPE IS

1745: --
1746: -- return UI page node
1747: --
1748: FUNCTION get_UI_Page_Node(p_page_id IN NUMBER)
1749: RETURN CZ_UI_PAGES%ROWTYPE IS
1750: l_page_node CZ_UI_PAGES%ROWTYPE;
1751: BEGIN
1752: SELECT * INTO l_page_node
1753: FROM CZ_UI_PAGES

Line 1750: l_page_node CZ_UI_PAGES%ROWTYPE;

1746: -- return UI page node
1747: --
1748: FUNCTION get_UI_Page_Node(p_page_id IN NUMBER)
1749: RETURN CZ_UI_PAGES%ROWTYPE IS
1750: l_page_node CZ_UI_PAGES%ROWTYPE;
1751: BEGIN
1752: SELECT * INTO l_page_node
1753: FROM CZ_UI_PAGES
1754: WHERE page_id=p_page_id AND

Line 1753: FROM CZ_UI_PAGES

1749: RETURN CZ_UI_PAGES%ROWTYPE IS
1750: l_page_node CZ_UI_PAGES%ROWTYPE;
1751: BEGIN
1752: SELECT * INTO l_page_node
1753: FROM CZ_UI_PAGES
1754: WHERE page_id=p_page_id AND
1755: ui_def_id=g_UI_Context.ui_def_id;
1756: RETURN l_page_node;
1757: END get_UI_Page_Node;

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

2323: INTO l_page_ref_node
2324: FROM CZ_UI_PAGE_REFS a
2325: WHERE ui_def_id = p_ui_node.ui_def_id AND
2326: (target_page_id,page_set_id) IN
2327: (SELECT page_id,NVL(page_set_id,a.page_set_id) FROM CZ_UI_PAGES
2328: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id AND
2329: deleted_flag NOT IN(G_YES_FLAG)) AND
2330: deleted_flag = G_NO_FLAG;
2331:

Line 2546: FROM CZ_UI_PAGES

2542: l_split_seq_nbr NUMBER;
2543: BEGIN
2544: SELECT NVL(MAX(split_seq_nbr),0)
2545: INTO l_split_seq_nbr
2546: FROM CZ_UI_PAGES
2547: WHERE ui_def_id=g_UI_Context.ui_def_id AND
2548: persistent_node_id IN
2549: (SELECT persistent_node_id FROM CZ_UI_PAGES
2550: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id);

Line 2549: (SELECT persistent_node_id FROM CZ_UI_PAGES

2545: INTO l_split_seq_nbr
2546: FROM CZ_UI_PAGES
2547: WHERE ui_def_id=g_UI_Context.ui_def_id AND
2548: persistent_node_id IN
2549: (SELECT persistent_node_id FROM CZ_UI_PAGES
2550: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id);
2551: RETURN l_split_seq_nbr;
2552: END get_Last_Split_Page_Nbr;
2553:

Line 3100: UPDATE CZ_UI_PAGES

3096:
3097: IF l_changed_target_ids_tbl.COUNT>0 THEN
3098: FOR x IN l_changed_target_ids_tbl.First..l_changed_target_ids_tbl.Last
3099: LOOP
3100: UPDATE CZ_UI_PAGES
3101: SET page_set_id=l_parent_page_set_id
3102: WHERE persistent_node_id=l_changed_target_ids_tbl(x) AND
3103: ui_def_id=p_ui_node.ui_def_id;
3104:

Line 3195: UPDATE CZ_UI_PAGES

3191:
3192: IF l_changed_target_ids_tbl.COUNT>0 THEN
3193: FOR j in l_changed_target_ids_tbl.First..l_changed_target_ids_tbl.Last
3194: LOOP
3195: UPDATE CZ_UI_PAGES
3196: SET page_set_id=l_page_set_id
3197: WHERE page_id=l_target_page_ids_tbl(j) AND
3198: ui_def_id=p_ui_node.ui_def_id;
3199:

Line 3339: UPDATE CZ_UI_PAGES

3335: page_id=p_ui_node.page_id AND
3336: element_id=p_ui_node.element_id;
3337:
3338: IF p_ui_node.parent_element_id IS NULL THEN
3339: UPDATE CZ_UI_PAGES
3340: SET pagebase_expl_node_id=p_expl_id
3341: WHERE page_id=p_ui_node.page_id AND
3342: ui_def_id=p_ui_node.ui_def_id;
3343: IF SQL%ROWCOUNT>0 THEN

Line 3514: FROM CZ_UI_PAGES

3510: END IF;
3511: END LOOP;
3512:
3513: FOR i IN (SELECT *
3514: FROM CZ_UI_PAGES
3515: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3516: deleted_flag = G_NO_FLAG)
3517: LOOP
3518: g_ui_pages_tbl(i.page_id) := i;

Line 5197: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

5193: p_element_id IN VARCHAR2,
5194: p_is_parser_open IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
5195:
5196: l_xmldoc xmldom.DOMDocument;
5197: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5198: l_ui_name CZ_UI_DEFS.name%TYPE;
5199: l_page_name CZ_UI_PAGES.name%TYPE;
5200: l_element_path VARCHAR2(32000);
5201:

Line 5199: l_page_name CZ_UI_PAGES.name%TYPE;

5195:
5196: l_xmldoc xmldom.DOMDocument;
5197: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5198: l_ui_name CZ_UI_DEFS.name%TYPE;
5199: l_page_name CZ_UI_PAGES.name%TYPE;
5200: l_element_path VARCHAR2(32000);
5201:
5202: BEGIN
5203:

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

5204: IF p_is_parser_open IS NULL OR p_is_parser_open='0' THEN
5205: Open_Parser();
5206: END IF;
5207:
5208: SELECT jrad_doc,name INTO l_page_jrad_doc,l_page_name FROM CZ_UI_PAGES
5209: WHERE ui_def_id=p_ui_def_id AND page_id=p_page_id;
5210:
5211: --
5212: -- create UI Template in JRAD repository

Line 5310: SELECT name INTO l_element_path FROM CZ_UI_PAGES

5306: IF l_run_id > 0 THEN
5307: IF NOT(xmldom.IsNull(p_xml_node)) THEN
5308: l_element_path := get_Element_XML_Path(p_xml_node => p_xml_node);
5309: ELSE -- UI rule on UI page level
5310: SELECT name INTO l_element_path FROM CZ_UI_PAGES
5311: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
5312: END IF;
5313:
5314: IF k.rule_type=33 THEN

Line 5357: FROM CZ_UI_PAGES

5353: BEGIN
5354:
5355: SELECT persistent_node_id,pagebase_expl_node_id
5356: INTO l_pagebase_persistent_node_id, l_pagebase_expl_id
5357: FROM CZ_UI_PAGES
5358: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id;
5359:
5360: BEGIN
5361: --

Line 6490: FROM CZ_UI_PAGES

6486:
6487: l_src_page_id := g_tgt_pg_to_src_pg_map(p_ui_node.page_id)(TO_NUMBER(p_ui_node.element_id));
6488:
6489: SELECT jrad_doc INTO l_jrad_doc
6490: FROM CZ_UI_PAGES
6491: WHERE ui_def_id= g_UI_Context.ui_def_id AND
6492: page_id=l_src_page_id;
6493:
6494: l_xml_node_to_move := pluck_XML_node(l_jrad_doc, l_src_page_id, p_ui_node.element_id);

Line 6510: FROM CZ_UI_PAGES

6506: SELECT ps_node_id INTO l_old_component_id
6507: FROM CZ_PS_NODES
6508: WHERE devl_project_id = g_UI_Context.devl_project_id
6509: AND persistent_node_id = (SELECT persistent_node_id
6510: FROM CZ_UI_PAGES
6511: WHERE ui_def_id = g_UI_Context.ui_Def_id
6512: AND page_id = l_src_page_id);
6513:
6514:

Line 6855: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

6851: l_ancestor_node := get_Attribute_Value(l_xml_node,
6852: 'ancestorNode');
6853: IF l_ancestor_node IS NOT NULL THEN
6854:
6855: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
6856: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;
6857:
6858: l_hgrid_element_id := find_Element_Id_Of_XMLTag(l_xml_node, 'oa:tree');
6859: IF NOT(xmldom.IsNull(l_xml_node)) THEN

Line 7502: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

7498: l_ancestor_node := get_Attribute_Value(l_xml_node,
7499: 'ancestorNode');
7500: IF l_ancestor_node IS NOT NULL THEN
7501:
7502: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
7503: WHERE page_id=p_ui_node.page_id AND ui_def_id=p_ui_node.ui_def_id;
7504:
7505: l_hgrid_element_id := find_Element_Id_Of_XMLTag(l_xml_node, 'oa:tree');
7506: IF NOT(xmldom.IsNull(l_xml_node)) THEN

Line 8957: FROM CZ_UI_PAGES

8953:
8954: BEGIN
8955:
8956: SELECT persistent_node_id INTO l_page_persistent_node_id
8957: FROM CZ_UI_PAGES
8958: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
8959:
8960: FOR i IN (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
8961: WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 8962: page_id IN(SELECT page_id FROM CZ_UI_PAGES

8958: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
8959:
8960: FOR i IN (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
8961: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8962: page_id IN(SELECT page_id FROM CZ_UI_PAGES
8963: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8964: persistent_node_id=l_page_persistent_node_id AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)) AND
8965: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
8966: persistent_node_id=(SELECT persistent_node_id FROM CZ_PS_NODES

Line 10166: FROM CZ_UI_PAGES

10162: IF p_parent_page_id IS NULL THEN
10163:
10164: SELECT MIN(page_id)
10165: INTO x_page_id
10166: FROM CZ_UI_PAGES
10167: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10168: persistent_node_id = p_parent_persistent_node_id AND
10169: NVL(split_seq_nbr,1)=1 AND
10170: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);

Line 10176: FROM CZ_UI_PAGES

10172: IF x_page_id IS NULL THEN
10173: NULL;
10174: ELSE
10175: SELECT page_set_id INTO x_page_set_id
10176: FROM CZ_UI_PAGES
10177: WHERE page_id=x_page_id AND
10178: ui_def_id = g_UI_Context.ui_def_id;
10179: END IF;
10180:

Line 10186: FROM CZ_UI_PAGES

10182:
10183: x_page_id := p_parent_page_id;
10184:
10185: SELECT page_set_id INTO x_page_set_id
10186: FROM CZ_UI_PAGES
10187: WHERE page_id=p_parent_page_id AND
10188: ui_def_id = g_UI_Context.ui_def_id;
10189:
10190: END IF;

Line 10310: l_page_node CZ_UI_PAGES%ROWTYPE;

10306: x_page_ref_id OUT NOCOPY NUMBER,
10307: p_parent_page_id IN NUMBER DEFAULT NULL)
10308: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10309:
10310: l_page_node CZ_UI_PAGES%ROWTYPE;
10311: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10312: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10313: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10314: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 10318: l_last_page_id CZ_UI_PAGES.page_id%TYPE;

10314: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
10315: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10316: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10317: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10318: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10319: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10322: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;

Line 10319: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;

10315: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
10316: l_node_depth CZ_UI_PAGE_REFS.node_depth%TYPE;
10317: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
10318: l_last_page_id CZ_UI_PAGES.page_id%TYPE;
10319: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10322: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10323: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;

Line 10323: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;

10319: l_parent_page_id CZ_UI_PAGES.page_id%TYPE;
10320: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
10321: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10322: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
10323: l_parent_ui_page_node CZ_UI_PAGES%ROWTYPE;
10324: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
10325: l_parent_page_persistent_id NUMBER;
10326: l_page_counter NUMBER;
10327: l_pagebase_expl_node_id NUMBER;

Line 10373: FROM CZ_UI_PAGES

10369: IF l_parent_page_id IS NOT NULL THEN
10370: BEGIN
10371:
10372: SELECT persistent_node_id INTO l_parent_page_persistent_id
10373: FROM CZ_UI_PAGES
10374: WHERE ui_Def_id = g_UI_Context.ui_def_id
10375: AND page_id = l_parent_page_id;
10376:
10377: IF NOT l_parent_page_persistent_id = p_node.parent_persistent_node_id THEN

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

10428: -- get num of this page in this UI
10429: --
10430: l_page_counter := get_Page_Counter() + 1;
10431:
10432: l_page_node.page_id := allocateId('CZ_UI_PAGES_S');
10433: l_page_node.ui_def_id := g_UI_Context.ui_def_id;
10434: l_page_node.NAME := 'Page-'||TO_CHAR(l_page_counter);
10435: l_page_node.persistent_node_id := p_node.persistent_node_id;
10436: l_page_node.jrad_doc := generate_JRAD_Page_Name(l_page_counter);

Line 10453: INSERT INTO CZ_UI_PAGES

10449: l_page_node.pagebase_expl_node_id := l_pagebase_expl_node_id;
10450: l_page_node.seeded_flag := G_NO_FLAG;
10451: l_page_node.deleted_flag := G_MARK_TO_ADD;
10452:
10453: INSERT INTO CZ_UI_PAGES
10454: (page_id,
10455: ui_def_id,
10456: NAME,
10457: persistent_node_id,

Line 10733: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES

10729: END IF;
10730:
10731: -- do not create UI region if already exists UI page with the same persistent_node_id
10732: BEGIN
10733: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
10734: WHERE ui_def_id=g_UI_CONTEXT.ui_def_id AND persistent_node_id=p_node.persistent_node_id AND
10735: deleted_flag NOT IN (G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG) AND rownum<2;
10736: RETURN l_ui_node;
10737: EXCEPTION

Line 11127: FROM CZ_UI_PAGES

11123:
11124: IF l_target_ui_def_node.start_page_id=-1 THEN
11125:
11126: SELECT MIN(page_id) INTO l_target_ui_def_node.start_page_id
11127: FROM CZ_UI_PAGES
11128: WHERE ui_def_id=l_target_ui_def_node.ui_def_id AND
11129: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);
11130:
11131: SELECT MIN(page_set_id) INTO l_target_ui_def_node.page_set_id

Line 11297: target_page_id NOT IN(SELECT page_id FROM CZ_UI_PAGES

11293: SET deleted_flag = G_YES_FLAG
11294: WHERE ui_def_id=p_ui_node.ui_def_id AND
11295: target_persistent_node_id=p_ui_node.persistent_node_id AND
11296: deleted_flag=G_NO_FLAG AND
11297: target_page_id NOT IN(SELECT page_id FROM CZ_UI_PAGES
11298: WHERE ui_def_id=g_UI_Context.ui_def_id);
11299:
11300: IF SQL%ROWCOUNT>0 THEN
11301: --

Line 11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;

11552: l_path_to_next_page CZ_UI_PAGE_REFS.path_to_next_page%TYPE;
11553: l_target_persistent_node_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
11554: l_target_page_id CZ_UI_PAGE_REFS.target_page_id%TYPE;
11555: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11556: l_ui_page_node CZ_UI_PAGES%ROWTYPE;
11557: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11558:
11559:
11560: BEGIN

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

11574: END delete_UI_Region;
11575:
11576:
11577: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11578: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
11579:
11580: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11581: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11582: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

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

11583: l_old_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;
11584:
11585: BEGIN
11586:
11587: SELECT page_set_id,pagebase_path INTO l_page_set_id,l_old_page_path_from_root FROM CZ_UI_PAGES
11588: WHERE page_id=p_page_id AND ui_def_id=g_UI_Context.ui_def_id;
11589:
11590: l_target_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
11591: l_page_path_from_root := get_Page_Path(p_node.ps_node_id, NULL);

Line 11594: UPDATE CZ_UI_PAGES

11590: l_target_path := get_Page_Path(p_node.ps_node_id, l_page_set_id);
11591: l_page_path_from_root := get_Page_Path(p_node.ps_node_id, NULL);
11592:
11593: IF l_page_path_from_root <> l_old_page_path_from_root THEN
11594: UPDATE CZ_UI_PAGES
11595: SET pagebase_path=l_page_path_from_root,
11596: deleted_flag=DECODE(deleted_flag,G_MARK_TO_ADD,G_MARK_TO_ADD,G_MARK_TO_REFRESH)
11597: WHERE page_id=p_page_id AND
11598: ui_def_id=g_UI_Context.ui_def_id AND

Line 11639: FROM CZ_UI_PAGES

11635: END LOOP;
11636:
11637: ELSE
11638: FOR i in (SELECT page_id
11639: FROM CZ_UI_PAGES
11640: WHERE ui_def_id = g_UI_Context.ui_def_id
11641: AND persistent_node_id = p_node.persistent_node_id
11642: AND deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG))
11643: LOOP

Line 11765: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES

11761: BEGIN
11762:
11763: BEGIN
11764:
11765: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
11766: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
11767:
11768: SELECT page_ref_id, parent_page_ref_id
11769: INTO l_page_ref_id, x_new_parent_page_ref_id

Line 11807: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES

11803: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11804:
11805: BEGIN
11806:
11807: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
11808: WHERE page_id=p_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
11809:
11810: IF l_page_set_id IS NOT NULL THEN
11811: SELECT suppress_refresh_flag INTO l_page_set_suppress_flag FROM CZ_UI_PAGE_SETS

Line 12203: UPDATE CZ_UI_PAGES

12199: END IF;
12200: END IF;
12201:
12202: IF l_refresh_ui_page THEN
12203: UPDATE CZ_UI_PAGES
12204: SET deleted_flag=G_MARK_TO_REFRESH,
12205: page_rev_nbr = page_rev_nbr + 1
12206: WHERE ui_def_id=p_ui_node.ui_def_id AND
12207: page_id=p_ui_node.page_id;

Line 12278: UPDATE CZ_UI_PAGES

12274: deleted_flag=G_NO_FLAG AND
12275: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG;
12276:
12277: IF SQL%ROWCOUNT > 0 THEN
12278: UPDATE CZ_UI_PAGES
12279: SET deleted_flag=G_MARK_TO_REFRESH,
12280: page_rev_nbr = page_rev_nbr + 1
12281: WHERE ui_def_id=p_ui_node.ui_def_id AND
12282: page_id=p_ui_node.page_id;

Line 12393: SELECT page_id INTO l_old_page_id FROM CZ_UI_PAGES

12389: is_UI_Page(p_node => p_model_node,
12390: x_drilldown => l_drilldown) THEN
12391:
12392: BEGIN
12393: SELECT page_id INTO l_old_page_id FROM CZ_UI_PAGES
12394: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12395: persistent_node_id=p_model_node.persistent_node_id AND
12396: deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
12397: rownum<2;

Line 12609: UPDATE CZ_UI_PAGES

12605: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12606: page_id=p_ui_node.page_id AND
12607: element_id=p_ui_node.element_id;
12608:
12609: UPDATE CZ_UI_PAGES
12610: SET deleted_flag=G_MARK_TO_REFRESH,
12611: page_rev_nbr=page_rev_nbr+1
12612: WHERE page_id=p_ui_node.page_id AND
12613: ui_def_id=g_UI_Context.ui_def_id;

Line 12701: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;

12697: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
12698:
12699: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
12700: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12701: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;
12702: l_page_id CZ_UI_PAGES.page_id%TYPE;
12703: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12704: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12705: l_caption_text_id NUMBER;

Line 12702: l_page_id CZ_UI_PAGES.page_id%TYPE;

12698:
12699: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
12700: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12701: l_split_seq_nbr CZ_UI_PAGES.split_seq_nbr%TYPE;
12702: l_page_id CZ_UI_PAGES.page_id%TYPE;
12703: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12704: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12705: l_caption_text_id NUMBER;
12706: l_caption CZ_INTL_TEXTS.text_str%TYPE;

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

12717:
12718: l_caption_text_id := allocateId('CZ_INTL_TEXTS_S');
12719:
12720: l_element_id := get_Element_Id();
12721: l_page_id := allocateId('CZ_UI_PAGES_S');
12722:
12723: INSERT INTO CZ_INTL_TEXTS
12724: (
12725: INTL_TEXT_ID

Line 12746: INSERT INTO CZ_UI_PAGES

12742: ,l_page_id
12743: ,NULL
12744: );
12745:
12746: INSERT INTO CZ_UI_PAGES
12747: (page_id,
12748: ui_def_id,
12749: NAME,
12750: persistent_node_id,

Line 12808: FROM CZ_UI_PAGES

12804: ENABLED_CONDITION_VALUE,
12805: EMPTY_PAGE_FLAG,
12806: SUPPRESS_REFRESH_FLAG,
12807: G_MARK_TO_ADD
12808: FROM CZ_UI_PAGES
12809: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12810: page_id=p_page_id;
12811:
12812: SELECT * INTO l_ui_node

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

13405: -- set ordering for UI elements on UI pages
13406: --
13407: PROCEDURE handle_UI_Page_Elements_Order IS
13408: BEGIN
13409: FOR i IN(SELECT page_id FROM CZ_UI_PAGES a
13410: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13411: page_set_id IN
13412: (SELECT page_set_id FROM CZ_UI_PAGE_SETS
13413: WHERE ui_def_id=g_UI_Context.ui_def_id AND

Line 13443: (SELECT page_id FROM CZ_UI_PAGES

13439: NVL(modified_flags,0) AS modified_flags FROM CZ_UI_PAGE_REFS
13440: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13441: parent_page_ref_id=p_page_ref_id AND
13442: target_page_id IN
13443: (SELECT page_id FROM CZ_UI_PAGES
13444: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13445: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,
13446: G_MARK_TO_REFRESH))
13447: AND

Line 13478: (SELECT page_id FROM CZ_UI_PAGES

13474: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13475: parent_page_ref_id IS NULL AND
13476: page_set_id=n.page_set_id AND
13477: target_page_id IN
13478: (SELECT page_id FROM CZ_UI_PAGES
13479: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13480: page_set_id=n.page_set_id AND
13481: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
13482: G_NO_FLAG)) AND

Line 13514: (SELECT page_id FROM CZ_UI_PAGES

13510: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13511: parent_page_ref_id IS NULL AND
13512: page_set_id=n.page_set_id AND
13513: target_page_id IN
13514: (SELECT page_id FROM CZ_UI_PAGES
13515: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13516: page_set_id=n.page_set_id AND
13517: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,
13518: G_NO_FLAG)) AND

Line 13724: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES

13720:
13721: l_exist_on_split_pages_flag := G_NO_FLAG;
13722:
13723: SELECT persistent_node_id,split_seq_nbr
13724: INTO l_page_persistent_node_id, px_page_split_seq_nbr FROM CZ_UI_PAGES
13725: WHERE page_id=p_parent_ui_node.page_id AND ui_def_id=g_UI_Context.ui_def_id;
13726:
13727: IF px_page_split_seq_nbr=1 THEN
13728: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual

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

13727: IF px_page_split_seq_nbr=1 THEN
13728: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
13729: WHERE EXISTS
13730: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13731: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
13732: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
13733: split_seq_nbr>1 AND deleted_flag NOT IN(G_YES_FLAG)) AND
13734: persistent_node_id=p_current_model_node.persistent_node_id AND
13735: deleted_flag NOT IN(G_YES_FLAG));

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

13736: ELSIF px_page_split_seq_nbr>1 THEN
13737: SELECT G_YES_FLAG INTO l_exist_on_split_pages_flag FROM dual
13738: WHERE EXISTS
13739: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13740: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id IN(SELECT page_id FROM CZ_UI_PAGES
13741: WHERE ui_def_id=g_UI_Context.ui_def_id AND persistent_node_id=l_page_persistent_node_id AND
13742: split_seq_nbr<>px_page_split_seq_nbr AND deleted_flag NOT IN(G_YES_FLAG)) AND
13743: persistent_node_id=p_current_model_node.persistent_node_id AND
13744: deleted_flag NOT IN(G_YES_FLAG));

Line 14004: target_page_id IN(SELECT page_id FROM CZ_UI_PAGES

14000: FOR i IN(SELECT page_ref_id,
14001: target_page_id,target_persistent_node_id,
14002: NVL(empty_page_flag,G_NO_FLAG) AS empty_page_flag FROM CZ_UI_PAGE_REFS
14003: WHERE ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG AND
14004: target_page_id IN(SELECT page_id FROM CZ_UI_PAGES
14005: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14006: NVL(suppress_refresh_flag, G_NO_FLAG)=G_NO_FLAG AND
14007: deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD) ))
14008: LOOP

Line 14021: UPDATE CZ_UI_PAGES

14017: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14018: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14019:
14020: IF SQL%ROWCOUNT>0 THEN
14021: UPDATE CZ_UI_PAGES
14022: SET empty_page_flag=G_YES_FLAG
14023: WHERE page_id=i.target_page_id AND
14024: ui_def_id=g_UI_Context.ui_def_id;
14025: END IF;

Line 14035: UPDATE CZ_UI_PAGES

14031: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14032: page_ref_id=i.page_ref_id AND NVL(modified_flags,0)=0;
14033:
14034: IF SQL%ROWCOUNT>0 THEN
14035: UPDATE CZ_UI_PAGES
14036: SET empty_page_flag=G_NO_FLAG
14037: WHERE page_id=i.target_page_id AND
14038: ui_def_id=g_UI_Context.ui_def_id;
14039: END IF;

Line 14058: (SELECT NULL FROM CZ_UI_PAGES

14054: FOR i IN(SELECT page_ref_id FROM CZ_UI_PAGE_REFS a
14055: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14056: parent_page_ref_id=p_page_ref_id AND
14057: EXISTS
14058: (SELECT NULL FROM CZ_UI_PAGES
14059: WHERE page_id=a.target_page_id AND ui_def_id=g_UI_Context.ui_def_id) AND
14060: deleted_flag IN(G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG) ORDER BY seq_nbr)
14061: LOOP
14062: l_counter := l_counter + 1;

Line 14079: FROM CZ_UI_PAGES

14075: parent_page_ref_id IS NULL AND
14076: deleted_flag=G_NO_FLAG)
14077: LOOP
14078: SELECT NVL(split_seq_nbr,1) INTO l_split_seq_nbr
14079: FROM CZ_UI_PAGES
14080: WHERE page_id=i.target_page_id AND
14081: ui_def_id=g_UI_Context.ui_def_id;
14082:
14083: IF l_split_seq_nbr > 1 THEN

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

14090: UPDATE CZ_UI_PAGE_REFS
14091: SET seq_nbr = 1
14092: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14093: page_ref_id=i.page_ref_id;
14094: SELECT MAX(split_seq_nbr) INTO l_counter FROM CZ_UI_PAGES
14095: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14096: persistent_node_id=i.target_persistent_node_id AND
14097: deleted_flag IN (G_MARK_TO_ADD,G_MARK_TO_REFRESH,G_NO_FLAG);
14098: END IF;

Line 14122: FOR i IN(SELECT page_id,pagebase_expl_node_id FROM CZ_UI_PAGES

14118: PROCEDURE check_Boundaries IS
14119: l_node_is_reachable NUMBER := -1;
14120: l_has_unreach BOOLEAN := FALSE;
14121: BEGIN
14122: FOR i IN(SELECT page_id,pagebase_expl_node_id FROM CZ_UI_PAGES
14123: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14124: deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG))
14125: LOOP
14126: FOR k IN(SELECT element_id,persistent_node_id,model_ref_expl_id,name

Line 14508: l_pagebase_expl_node_id CZ_UI_PAGES.pagebase_expl_node_id%TYPE;

14504: l_max_src_seq_nbr NUMBER;
14505: l_src_range NUMBER;
14506: l_atleast_one_parent_found BOOLEAN;
14507: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
14508: l_pagebase_expl_node_id CZ_UI_PAGES.pagebase_expl_node_id%TYPE;
14509: l_node_is_reachable NUMBER := -1;
14510: l_model_ref_expl_id NUMBER;
14511: l_count NUMBER;
14512:

Line 14669: UPDATE CZ_UI_PAGES

14665:
14666: mark_UI_Page_As_Refreshed(l_parent_ui_node.page_id, l_parent_ui_node.ui_def_id);
14667:
14668: -- update the page_rev_nbr of the other (source) page
14669: UPDATE CZ_UI_PAGES
14670: SET page_rev_nbr=page_rev_nbr+1
14671: WHERE page_id=i.page_id AND ui_def_id=i.ui_def_id;
14672:
14673: ELSE -- If parent_node not found

Line 14684: FROM CZ_UI_PAGES

14680:
14681:
14682:
14683: SELECT pagebase_expl_node_id INTO l_pagebase_expl_node_id
14684: FROM CZ_UI_PAGES
14685: WHERE ui_def_id=g_UI_Context.ui_def_id
14686: AND page_id = i.page_id
14687: AND deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);
14688:

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

15116: IF (contains_BOM_Nodes(p_ps_node.ps_node_id)) THEN
15117: --
15118: -- Add bom table here
15119: --
15120: FOR m IN(SELECT page_id, pagebase_expl_node_id FROM CZ_UI_PAGES
15121: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15122: deleted_flag IN(G_NO_FLAG, G_MARK_TO_REFRESH) AND
15123: persistent_node_id = p_ps_node.persistent_node_id)
15124: LOOP

Line 15201: FOR upg IN(SELECT page_id,pagebase_expl_node_id,persistent_node_id FROM CZ_UI_PAGES

15197: --
15198: PROCEDURE check_Ref_AMNs IS
15199: BEGIN
15200:
15201: FOR upg IN(SELECT page_id,pagebase_expl_node_id,persistent_node_id FROM CZ_UI_PAGES
15202: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15203: deleted_flag IN(G_MARK_TO_ADD, G_MARK_TO_REFRESH, G_NO_FLAG))
15204: LOOP
15205: FOR upgel IN(SELECT element_id,

Line 15220: UPDATE CZ_UI_PAGES

15216: AND psnode.ui_timestamp_move > NVL(g_UI_Context.ui_timestamp_refresh, g_UI_Context.creation_date)
15217: )
15218: )
15219: LOOP
15220: UPDATE CZ_UI_PAGES
15221: SET deleted_flag=G_MARK_TO_REFRESH
15222: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15223: page_id=upg.page_id AND deleted_flag='0';
15224: END LOOP;

Line 15438: UPDATE CZ_UI_PAGES

15434: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15435: page_id=p_page_id AND
15436: deleted_flag=G_MARK_TO_DEASSOCIATE;
15437: IF SQL%ROWCOUNT>0 THEN
15438: UPDATE CZ_UI_PAGES
15439: SET page_rev_nbr=page_rev_nbr+1
15440: WHERE page_id=p_page_id AND
15441: ui_def_id=g_UI_Context.ui_def_id;
15442: END IF;

Line 15625: UPDATE CZ_UI_PAGES

15621: END IF;
15622:
15623: END LOOP;
15624:
15625: UPDATE CZ_UI_PAGES
15626: SET page_rev_nbr=page_rev_nbr+1
15627: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15628: page_id=p_ui_page_id;
15629:

Line 15859: FROM CZ_UI_PAGES

15855: l_col_number := 0;
15856: END IF;
15857:
15858: SELECT jrad_doc INTO l_jrad_doc
15859: FROM CZ_UI_PAGES
15860: WHERE ui_def_id= g_UI_Context.ui_def_id AND
15861: page_id=p_page_id;
15862:
15863: --

Line 16193: FROM CZ_UI_PAGES

16189: --
16190: PROCEDURE handle_JRAD_Pages IS
16191: BEGIN
16192: FOR i IN (SELECT page_id, jrad_doc, deleted_flag
16193: FROM CZ_UI_PAGES
16194: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16195: deleted_flag <> G_YES_FLAG)
16196: LOOP
16197: IF i.deleted_flag IN(G_MARK_TO_DELETE,G_MARK_TO_ADD,

Line 16252: l_name CZ_UI_PAGES.NAME%TYPE;

16248:
16249: FUNCTION get_page_name(p_ui_def_id IN NUMBER, p_page_id IN NUMBER)
16250: RETURN VARCHAR2
16251: IS
16252: l_name CZ_UI_PAGES.NAME%TYPE;
16253: BEGIN
16254: SELECT NVL(name, to_char(page_id)) INTO l_name
16255: FROM cz_ui_pages
16256: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;

Line 16255: FROM cz_ui_pages

16251: IS
16252: l_name CZ_UI_PAGES.NAME%TYPE;
16253: BEGIN
16254: SELECT NVL(name, to_char(page_id)) INTO l_name
16255: FROM cz_ui_pages
16256: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;
16257: RETURN l_name;
16258: END get_page_name;
16259:

Line 16304: UPDATE CZ_UI_PAGES

16300: SET target_page_ui_def_id = NULL, target_page_id = NULL
16301: WHERE ui_def_id = p_ui_def_id AND
16302: page_id = p_page_id AND element_id = p_element_id;
16303:
16304: UPDATE CZ_UI_PAGES
16305: SET page_rev_nbr = page_rev_nbr + 1
16306: WHERE ui_def_id = p_ui_def_id AND page_id = p_page_id;
16307: END remove_target_page;
16308:

Line 16326: FROM cz_ui_pages

16322: -- target page exists ?
16323: l_target_persistent_node_id := NULL;
16324: BEGIN
16325: SELECT persistent_node_id INTO l_target_persistent_node_id
16326: FROM cz_ui_pages
16327: WHERE ui_def_id = i.target_page_ui_def_id AND
16328: page_id = i.target_page_id AND deleted_flag = G_NO_FLAG;
16329: EXCEPTION
16330: -- target page not exist

Line 16345: FROM cz_ui_pages

16341:
16342: -- target page exists. is it reachable ?
16343: IF l_target_persistent_node_id IS NOT NULL THEN
16344: SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
16345: FROM cz_ui_pages
16346: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16347: page_id = i.page_id;
16348:
16349: IF i.persistent_node_id = l_target_persistent_node_id THEN

Line 16381: FROM CZ_UI_PAGES a, CZ_UI_PAGE_ELEMENTS b

16377: b.ui_def_id AS ref_ui_def_id, b.page_id AS ref_page_id,
16378: b.name AS ref_element_name, b.element_id AS ref_element_id,
16379: b.persistent_node_id as persistent_node_id,
16380: b.model_ref_expl_id as expl_node_id
16381: FROM CZ_UI_PAGES a, CZ_UI_PAGE_ELEMENTS b
16382: WHERE a.ui_def_id = g_UI_Context.ui_def_id AND
16383: b.element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
16384: b.deleted_flag = G_NO_FLAG AND
16385: a.ui_def_id = b.target_page_ui_def_id AND

Line 16406: FROM cz_ui_pages

16402: ELSE
16403: -- check reachability of current page if page is not deleted
16404: -- get PI element's pagebase_expl_id
16405: SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
16406: FROM cz_ui_pages
16407: WHERE ui_def_id = i.ref_ui_def_id AND
16408: page_id = i.ref_page_id;
16409:
16410: IF i.persistent_node_id = i.target_persistent_node_id THEN

Line 16448: FROM CZ_UI_PAGES pg

16444: WHILE l_ui_def_id IS NOT NULL
16445: LOOP
16446: l_flag := 1;
16447: FOR i IN (SELECT page_id, jrad_doc, pagebase_expl_node_id, persistent_node_id
16448: FROM CZ_UI_PAGES pg
16449: WHERE ui_def_id = l_ui_def_id AND deleted_flag = G_NO_FLAG
16450: AND EXISTS (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
16451: WHERE ui_def_id = pg.ui_def_id AND page_id = pg.page_id AND
16452: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND

Line 16477: UPDATE CZ_UI_PAGES

16473: IF l_ui_def_id = g_UI_Context.ui_def_id THEN
16474: set_attribute(l_dom_node,
16475: G_USER_ATTRIBUTE1_NAME,
16476: l_new_relative_path);
16477: UPDATE CZ_UI_PAGES
16478: SET page_rev_nbr = page_rev_nbr + 1
16479: WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id;
16480: l_resave_doc_flag := 1; -- save doc
16481: ELSE

Line 17266: l_page_name CZ_UI_PAGES.name%TYPE;

17262: l_name_tbl varchar_tbl_type;
17263: l_target_page_ui_def_id_tbl number_tbl_type;
17264: l_target_page_id_tbl number_tbl_type;
17265: l_ui_name CZ_UI_DEFS.name%TYPE;
17266: l_page_name CZ_UI_PAGES.name%TYPE;
17267: l_pagebase_expl_id NUMBER;
17268: l_ui_def_id NUMBER;
17269: l_target_persistent_node_id NUMBER;
17270:

Line 17289: SELECT name INTO l_page_name FROM CZ_UI_PAGES

17285:
17286: IF l_name_tbl.COUNT>0 THEN
17287: FOR i IN l_name_tbl.First..l_name_tbl.Last
17288: LOOP
17289: SELECT name INTO l_page_name FROM CZ_UI_PAGES
17290: WHERE page_id=l_target_page_id_tbl(i) AND ui_def_id=l_target_page_ui_def_id_tbl(i);
17291: SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);
17292: add_Error_Message(p_message_name => 'CZ_CP_PIR_REF_UI_NOT_IN_CHAIN',
17293: p_token_name1 => 'RGNNAME',

Line 17318: FROM cz_ui_pages

17314: -- target page exists?
17315: l_target_persistent_node_id := NULL;
17316: BEGIN
17317: SELECT persistent_node_id INTO l_target_persistent_node_id
17318: FROM cz_ui_pages
17319: WHERE ui_def_id = i.target_page_ui_def_id AND
17320: page_id = i.target_page_id AND deleted_flag <> '1';
17321: EXCEPTION
17322: -- target page not exist

Line 17341: FROM cz_ui_pages

17337:
17338: -- target page exists. check if reachable
17339: IF l_target_persistent_node_id IS NOT NULL THEN
17340: SELECT pagebase_expl_node_id INTO l_pagebase_expl_id
17341: FROM cz_ui_pages
17342: WHERE ui_def_id = p_ui_def_id AND
17343: page_id = i.page_id;
17344:
17345: IF i.persistent_node_id = l_target_persistent_node_id THEN

Line 17829: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

17825: l_out_node xmldom.DOMNode;
17826: l_parent_node xmldom.DOMNode;
17827: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
17828: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
17829: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
17830: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
17831: l_ui_context CZ_UI_DEFS%ROWTYPE;
17832: l_condition_id NUMBER;
17833: l_caption_text_id NUMBER;

Line 17878: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

17874: WHERE ui_def_id=p_ui_def_id AND
17875: page_id=p_ui_page_id AND
17876: element_id=p_element_id;
17877:
17878: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
17879: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
17880:
17881: IF l_parent_element_id IS NULL OR p_element_id=G_NO_FLAG THEN -- this is UI page ( and it should be deleted )
17882:

Line 17925: UPDATE CZ_UI_PAGES

17921: -- set data for Page Sets
17922: --
17923: handle_Page_Flows();
17924:
17925: UPDATE CZ_UI_PAGES
17926: SET deleted_flag=G_YES_FLAG
17927: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG
17928: RETURNING caption_text_id,caption_rule_id,display_condition_id,enabled_condition_id
17929: INTO l_caption_text_id,l_caption_rule_id,l_display_condition_id,l_enabled_condition_id;

Line 18001: UPDATE CZ_UI_PAGES

17997: Save_Document(p_xml_doc => l_xmldoc,
17998: p_doc_name => l_jrad_doc);
17999: END IF;
18000:
18001: UPDATE CZ_UI_PAGES
18002: SET page_rev_nbr=page_rev_nbr+1
18003: WHERE ui_def_id=p_ui_def_id AND
18004: page_id=p_ui_page_id;
18005:

Line 18101: l_page_id CZ_UI_PAGES.page_id%TYPE;

18097: ) IS
18098:
18099: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
18100: l_ui_context CZ_UI_DEFS%ROWTYPE;
18101: l_page_id CZ_UI_PAGES.page_id%TYPE;
18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
18103: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18104:
18105: BEGIN

Line 18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;

18098:
18099: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
18100: l_ui_context CZ_UI_DEFS%ROWTYPE;
18101: l_page_id CZ_UI_PAGES.page_id%TYPE;
18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
18103: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18104:
18105: BEGIN
18106:

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

18143: AND page_ref_id=p_page_ref_id;
18144: END IF;
18145:
18146: --
18147: -- null out CZ_UI_PAGES.page_set_id for those UI pages in this UI
18148: -- which have no corresponding records in CZ_UI_PAGE_REFS
18149: --
18150: UPDATE CZ_UI_PAGES a
18151: SET page_set_id=NULL

Line 18150: UPDATE CZ_UI_PAGES a

18146: --
18147: -- null out CZ_UI_PAGES.page_set_id for those UI pages in this UI
18148: -- which have no corresponding records in CZ_UI_PAGE_REFS
18149: --
18150: UPDATE CZ_UI_PAGES a
18151: SET page_set_id=NULL
18152: WHERE ui_def_id=p_ui_def_id AND page_set_id IS NOT NULL AND
18153: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_REFS b
18154: WHERE b.ui_def_id=p_ui_def_id AND target_page_id=a.page_id AND

Line 18190: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18186: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
18187: ) IS
18188:
18189: l_xmldoc xmldom.DOMDocument;
18190: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18191:
18192: BEGIN
18193:
18194: --

Line 18285: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18281: l_xmldoc xmldom.DOMDocument;
18282: l_out_node xmldom.DOMNode;
18283: l_parent_node xmldom.DOMNode;
18284: l_xml_node xmldom.DOMNode;
18285: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18286: l_needs_to_be_unlocked BOOLEAN;
18287:
18288: BEGIN
18289:

Line 18437: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18433: l_target_uicont_xml_node xmldom.DOMNode;
18434: l_stacklayout_node xmldom.DOMNode;
18435: l_stacklayout_uicont_xml_node xmldom.DOMNode;
18436: l_xml_temp_node xmldom.DOMNode;
18437: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18438: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18439: l_xml_uicont_node xmldom.DOMNode;
18440: l_xml_new_node xmldom.DOMNode;
18441: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

Line 18438: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18434: l_stacklayout_node xmldom.DOMNode;
18435: l_stacklayout_uicont_xml_node xmldom.DOMNode;
18436: l_xml_temp_node xmldom.DOMNode;
18437: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18438: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18439: l_xml_uicont_node xmldom.DOMNode;
18440: l_xml_new_node xmldom.DOMNode;
18441: l_amn_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
18442: l_pagebase_persistent_node_id NUMBER;

Line 18461: INTO l_source_jrad_doc FROM CZ_UI_PAGES

18457: --
18458: -- get jrad_doc of source UI page to which this UI element belongs to
18459: --
18460: SELECT jrad_doc
18461: INTO l_source_jrad_doc FROM CZ_UI_PAGES
18462: WHERE page_id=p_source_ui_page_id AND
18463: ui_def_id=p_source_ui_def_id;
18464:
18465: --

Line 18470: FROM CZ_UI_PAGES

18466: -- get jrad_doc of source UI page to which this UI element belongs to
18467: --
18468: SELECT jrad_doc,persistent_node_id
18469: INTO l_target_jrad_doc, l_pagebase_persistent_node_id
18470: FROM CZ_UI_PAGES
18471: WHERE page_id=p_target_ui_page_id AND
18472: ui_def_id=p_target_ui_def_id;
18473:
18474: --

Line 18610: UPDATE CZ_UI_PAGES

18606: -- close XML parser
18607: --
18608: Close_Parser();
18609:
18610: UPDATE CZ_UI_PAGES
18611: SET page_rev_nbr=page_rev_nbr+1,
18612: empty_page_flag = G_NO_FLAG
18613: WHERE page_id=p_target_ui_page_id AND
18614: ui_def_id=p_target_ui_def_id;

Line 18657: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18653: ) IS
18654:
18655: l_source_xmldoc xmldom.DOMDocument;
18656: l_source_xml_node xmldom.DOMNode;
18657: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18658: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18659: l_element_id_tbl number_tbl_type;
18660: l_parent_element_id_tbl number_tbl_type;
18661: l_element_id_arr_tbl number_tbl_type;

Line 18658: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

18654:
18655: l_source_xmldoc xmldom.DOMDocument;
18656: l_source_xml_node xmldom.DOMNode;
18657: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18658: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18659: l_element_id_tbl number_tbl_type;
18660: l_parent_element_id_tbl number_tbl_type;
18661: l_element_id_arr_tbl number_tbl_type;
18662: l_new_element_id_arr_tbl number_tbl_type;

Line 18698: FROM CZ_UI_PAGES

18694: -- get jrad_doc of source UI page to which this UI element belongs to
18695: --
18696: SELECT jrad_doc,persistent_node_id
18697: INTO l_source_jrad_doc,l_persistent_node_id
18698: FROM CZ_UI_PAGES
18699: WHERE ui_def_id=p_source_ui_def_id AND
18700: page_id=p_source_ui_page_id;
18701:
18702: SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES

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

18698: FROM CZ_UI_PAGES
18699: WHERE ui_def_id=p_source_ui_def_id AND
18700: page_id=p_source_ui_page_id;
18701:
18702: SELECT COUNT(*) INTO l_copy_nbr FROM CZ_UI_PAGES
18703: WHERE ui_def_id=p_target_ui_def_id AND
18704: persistent_node_id=l_persistent_node_id;
18705:
18706: l_target_jrad_doc := '/oracle/apps/cz/runtime/oa/webui/regions/ui' ||

Line 18713: FOR i IN(SELECT * FROM CZ_UI_PAGES

18709:
18710: l_target_jrad_doc := REPLACE(l_target_jrad_doc,'_'||TO_CHAR(p_source_ui_def_id)||'_',
18711: '_'||TO_CHAR(p_target_ui_def_id)||'_');
18712:
18713: FOR i IN(SELECT * FROM CZ_UI_PAGES
18714: WHERE ui_def_id=p_source_ui_def_id AND
18715: page_id=p_source_ui_page_id)
18716: LOOP
18717:

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

18714: WHERE ui_def_id=p_source_ui_def_id AND
18715: page_id=p_source_ui_page_id)
18716: LOOP
18717:
18718: x_new_ui_page_id := allocateId('CZ_UI_PAGES_S');
18719:
18720: l_caption_text_id := copy_Intl_Text(i.caption_text_id, p_target_ui_def_id, NULL, NULL);
18721:
18722: copy_UI_Rule( i.caption_rule_id, l_caption_rule_id,

Line 18731: INSERT INTO CZ_UI_PAGES

18727:
18728: copy_UI_Rule( i.enabled_condition_id, l_enabled_condition_id,
18729: p_target_ui_def_id,x_new_ui_page_id,NULL,p_source_ui_def_id);
18730:
18731: INSERT INTO CZ_UI_PAGES
18732: (
18733: PAGE_ID
18734: ,UI_DEF_ID
18735: ,PERSISTENT_NODE_ID

Line 19061: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19057: l_source_template_xmldoc xmldom.DOMDocument;
19058: l_template_root_xml_node xmldom.DOMNode;
19059: l_xml_node xmldom.DOMNode;
19060: l_child_nodes_tbl xmldom.DOMNodeList;
19061: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19062: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19063: l_length NUMBER;
19064: l_needs_to_be_unlocked BOOLEAN;
19065:

Line 19062: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19058: l_template_root_xml_node xmldom.DOMNode;
19059: l_xml_node xmldom.DOMNode;
19060: l_child_nodes_tbl xmldom.DOMNodeList;
19061: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19062: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19063: l_length NUMBER;
19064: l_needs_to_be_unlocked BOOLEAN;
19065:
19066: BEGIN

Line 19326: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19322: l_target_uicont_xml_node xmldom.DOMNode;
19323: l_xml_temp_node xmldom.DOMNode;
19324: l_stacklayout_node xmldom.DOMNode;
19325: l_stacklayout_uicont_xml_node xmldom.DOMNode;
19326: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19327: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19328: l_needs_to_be_unlocked BOOLEAN;
19329: BEGIN
19330:

Line 19327: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19323: l_xml_temp_node xmldom.DOMNode;
19324: l_stacklayout_node xmldom.DOMNode;
19325: l_stacklayout_uicont_xml_node xmldom.DOMNode;
19326: l_source_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19327: l_target_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19328: l_needs_to_be_unlocked BOOLEAN;
19329: BEGIN
19330:
19331: --

Line 19536: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19532: l_switcher_casename VARCHAR2(255);
19533: l_switcher_xml_id VARCHAR2(255);
19534: l_uicase_name VARCHAR2(255);
19535: l_child_nodes_tbl xmldom.DOMNodeList;
19536: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19537: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19538: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
19539: l_attribute_value VARCHAR2(255);
19540: l_length NUMBER;

Line 19537: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19533: l_switcher_xml_id VARCHAR2(255);
19534: l_uicase_name VARCHAR2(255);
19535: l_child_nodes_tbl xmldom.DOMNodeList;
19536: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19537: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19538: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
19539: l_attribute_value VARCHAR2(255);
19540: l_length NUMBER;
19541: l_needs_to_be_unlocked BOOLEAN;

Line 19563: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a

19559: --
19560: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
19561: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19562:
19563: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a
19564: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id;
19565:
19566:
19567: --

Line 19778: UPDATE CZ_UI_PAGES

19774: -- close XML parser
19775: --
19776: Close_Parser();
19777:
19778: UPDATE CZ_UI_PAGES
19779: SET page_rev_nbr=page_rev_nbr+1
19780: WHERE ui_def_id=p_ui_def_id AND
19781: page_id=p_ui_page_id;
19782:

Line 19843: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19839: l_new_ui_element_id VARCHAR2(255);
19840: l_user_attribute3_value VARCHAR2(4000);
19841: l_switcher_casename VARCHAR2(255);
19842: l_child_nodes_tbl xmldom.DOMNodeList;
19843: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19844: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19845: l_attribute_value VARCHAR2(255);
19846: l_length NUMBER;
19847: l_needs_to_be_unlocked BOOLEAN;

Line 19844: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

19840: l_user_attribute3_value VARCHAR2(4000);
19841: l_switcher_casename VARCHAR2(255);
19842: l_child_nodes_tbl xmldom.DOMNodeList;
19843: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19844: l_target_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
19845: l_attribute_value VARCHAR2(255);
19846: l_length NUMBER;
19847: l_needs_to_be_unlocked BOOLEAN;
19848: BEGIN

Line 20075: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20071: l_xml_node xmldom.DOMNode;
20072: l_root_xml_node xmldom.DOMNode;
20073: l_parent_xml_node xmldom.DOMNode;
20074: l_child_nodes_tbl xmldom.DOMNodeList;
20075: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20076: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20077: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
20078: l_node_map_tbl xmldom.DOMNamedNodeMap;
20079: l_node_attr xmldom.DOMNode;

Line 20076: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;

20072: l_root_xml_node xmldom.DOMNode;
20073: l_parent_xml_node xmldom.DOMNode;
20074: l_child_nodes_tbl xmldom.DOMNodeList;
20075: l_template_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20076: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
20077: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
20078: l_node_map_tbl xmldom.DOMNamedNodeMap;
20079: l_node_attr xmldom.DOMNode;
20080: l_prev_xml_node xmldom.DOMNode;

Line 20122: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES

20118: IF (p_ui_def_id=0) THEN
20119: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
20120: WHERE template_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
20121: ELSE
20122: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
20123: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
20124:
20125: END IF;
20126:

Line 20444: UPDATE CZ_UI_PAGES

20440: SET TEMPLATE_REV_NBR=TEMPLATE_REV_NBR+1
20441: WHERE ui_def_id=p_ui_def_id AND
20442: template_id=p_ui_page_id;
20443: else
20444: UPDATE CZ_UI_PAGES
20445: SET page_rev_nbr=page_rev_nbr+1
20446: WHERE ui_def_id=p_ui_def_id AND
20447: page_id=p_ui_page_id;
20448: end if;

Line 20514: l_page_id CZ_UI_PAGES.page_id%TYPE;

20510: PROCEDURE validate_UI_Conditions(p_ui_def_id IN NUMBER,
20511: p_is_parser_open IN VARCHAR2 DEFAULT NULL) IS
20512:
20513: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
20514: l_page_id CZ_UI_PAGES.page_id%TYPE;
20515:
20516: BEGIN
20517: FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a
20518: WHERE ui_def_id=p_ui_def_id AND

Line 20533: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES

20529: (i.ui_page_id IS NOT NULL AND i.ui_page_id<>0) THEN
20530: SELECT element_id INTO l_element_id FROM CZ_UI_PAGE_ELEMENTS
20531: WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
20532: parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE) AND rownum<2;
20533: SELECT page_id INTO l_page_id FROM CZ_UI_PAGES
20534: 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);
20535: END IF;
20536:
20537: 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 20714: target_page_id IN (SELECT page_id FROM cz_ui_pages

20710:
20711: UPDATE cz_ui_page_elements
20712: SET target_page_ui_def_id = NULL, target_page_id = NULL
20713: WHERE deleted_flag = '0' AND target_page_ui_def_id = l_old_child_ui_def_id AND
20714: target_page_id IN (SELECT page_id FROM cz_ui_pages
20715: WHERE ui_def_id = l_old_child_ui_def_id AND deleted_flag = '0') AND
20716: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;
20717:
20718: EXCEPTION

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

20807: ORACLE_SCHEMA => l_oracle_schema);
20808:
20809: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
20810: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
20811: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
20812: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
20813: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
20814:
20815: SELECT template_name