[Home] [Help]
270:
271: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
272: TYPE number_tbl_type_idx_vc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
273: --TYPE varchar_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
274: TYPE ui_page_elements_tbl_type IS TABLE OF CZ_UI_PAGE_ELEMENTS%ROWTYPE INDEX BY VARCHAR2(15);--kdande; Bug 6875560; 12-Mar-2008
275:
276: -- fix for bug 6837809 : skudryav 28-Mar-2008
277: TYPE ui_page_el_int_tbl_type IS TABLE OF CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE INDEX BY BINARY_INTEGER;
278:
722: --
723: PROCEDURE Initialize_Sequences IS
724: BEGIN
725:
726: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currentUINode FROM dual;
727: g_currUISeqVal := g_currentUINode;
728:
729: SELECT CZ_UI_PAGE_REFS_S.nextval INTO g_currentPageRef FROM dual;
730: g_currPageRefSeqVal := g_currentPageRef;
1014: --
1015: FUNCTION allocateId(p_sequence_name IN VARCHAR2) RETURN NUMBER IS
1016: l_id NUMBER;
1017: BEGIN
1018: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1019: IF g_currentUINode
1021: ELSE
1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1018: IF p_sequence_name='CZ_UI_PAGE_ELEMENTS_S' THEN
1019: IF g_currentUINode
1021: ELSE
1022: SELECT CZ_UI_PAGE_ELEMENTS_S.nextval INTO g_currUISeqVal FROM dual;
1023: g_currentUINode := g_currUISeqVal;
1024: END IF;
1025: RETURN g_currentUINode;
1026: ELSIF p_sequence_name='CZ_UI_PAGE_REFS_S' THEN
1100: -- return new element_id
1101: --
1102: FUNCTION get_Element_Id RETURN VARCHAR2 IS
1103: BEGIN
1104: RETURN TO_CHAR(allocateId('CZ_UI_PAGE_ELEMENTS_S'));
1105: END get_Element_Id;
1106:
1107: --
1108: -- mark UI page as deleted
1158: ui_def_id = g_UI_Context.ui_def_id;
1159: --
1160: -- mark elements as already deleted
1161: --
1162: UPDATE CZ_UI_PAGE_ELEMENTS
1163: SET deleted_flag=G_YES_FLAG
1164: WHERE ui_def_id= g_UI_Context.ui_def_id AND
1165: page_id=p_page_id;
1166:
1167: ELSIF p_hmode = G_DELETE_ELEMENTS THEN
1168: --
1169: -- mark elements as already deleted
1170: --
1171: UPDATE CZ_UI_PAGE_ELEMENTS
1172: SET deleted_flag=G_YES_FLAG
1173: WHERE ui_def_id= g_UI_Context.ui_def_id AND
1174: page_id=p_page_id AND
1175: deleted_flag IN(G_MARK_TO_DELETE);
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);
1198:
1199: UPDATE CZ_UI_PAGE_ELEMENTS
1200: SET deleted_flag = G_NO_FLAG
1201: WHERE ui_def_id = g_UI_Context.ui_def_id AND
1202: page_id = p_page_id AND
1203: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
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);
1212:
1213: UPDATE CZ_UI_PAGE_ELEMENTS
1214: SET deleted_flag = G_NO_FLAG
1215: WHERE ui_def_id = g_UI_Context.ui_def_id AND
1216: page_id = p_page_id AND
1217: deleted_flag NOT IN(G_NO_FLAG,G_YES_FLAG,G_LIMBO_FLAG);
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:
1226: UPDATE CZ_UI_PAGE_ELEMENTS
1227: SET deleted_flag = G_NO_FLAG
1228: WHERE ui_def_id = g_UI_Context.ui_def_id AND
1229: page_id = p_page_id AND
1230: deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
1816: -- return UI element with element_id = p_element_id
1817: --
1818: FUNCTION get_UI_Element(p_element_id IN VARCHAR2,
1819: p_page_id IN NUMBER)
1820: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
1821: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
1822: BEGIN
1823: SELECT *
1824: INTO l_ui_node
1817: --
1818: FUNCTION get_UI_Element(p_element_id IN VARCHAR2,
1819: p_page_id IN NUMBER)
1820: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
1821: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
1822: BEGIN
1823: SELECT *
1824: INTO l_ui_node
1825: FROM CZ_UI_PAGE_ELEMENTS
1821: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
1822: BEGIN
1823: SELECT *
1824: INTO l_ui_node
1825: FROM CZ_UI_PAGE_ELEMENTS
1826: WHERE ui_def_id = g_UI_Context.ui_def_id AND
1827: page_id=p_page_id AND
1828: element_id = p_element_id;
1829: RETURN l_ui_node;
1848: p_template_id IN NUMBER,
1849: p_template_name IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
1850:
1851: l_counter NUMBER;
1852: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
1853:
1854: BEGIN
1855:
1856: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
1852: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
1853:
1854: BEGIN
1855:
1856: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
1857: WHERE ui_def_id=g_UI_Context.ui_def_id AND
1858: page_id=p_page_id AND
1859: ctrl_template_id=p_template_id AND
1860: deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
1920:
1921: --
1922: -- get UI Action Id associated with a given ui node
1923: --
1924: FUNCTION get_UI_Action_Id(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
1925: RETURN NUMBER IS
1926: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
1927: BEGIN
1928: SELECT ui_action_id
2369:
2370: --
2371: -- return page_ref node of nearest page
2372: --
2373: FUNCTION get_UI_Page_Ref_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2374: RETURN CZ_UI_PAGE_REFS%ROWTYPE IS
2375:
2376: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
2377:
2502: --
2503: -- the function retrurns a Model Path
2504: -- for a given persistent_node_id
2505: --
2506: FUNCTION get_Model_Path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2507: RETURN VARCHAR2 IS
2508:
2509: l_page_path VARCHAR2(32000) := '';
2510: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2506: FUNCTION get_Model_Path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2507: RETURN VARCHAR2 IS
2508:
2509: l_page_path VARCHAR2(32000) := '';
2510: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2511:
2512: PROCEDURE construct_Path(p_current_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
2513: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2514: BEGIN
2508:
2509: l_page_path VARCHAR2(32000) := '';
2510: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2511:
2512: PROCEDURE construct_Path(p_current_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
2513: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2514: BEGIN
2515:
2516: IF p_current_ui_node.pagebase_persistent_node_id <>
2509: l_page_path VARCHAR2(32000) := '';
2510: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2511:
2512: PROCEDURE construct_Path(p_current_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
2513: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
2514: BEGIN
2515:
2516: IF p_current_ui_node.pagebase_persistent_node_id <>
2517: p_current_ui_node.persistent_node_id THEN
2589: l_parent_seq_nbr NUMBER;
2590: BEGIN
2591: SELECT NVL(MAX(seq_nbr),0)
2592: INTO l_seq_nbr
2593: FROM CZ_UI_PAGE_ELEMENTS
2594: WHERE ui_def_id=g_UI_Context.ui_def_id AND
2595: parent_element_id=p_parent_element_id AND
2596: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
2597: RETURN l_seq_nbr;
2615:
2616: --
2617: -- return COUNT ( of UI pages of a given UI) + 1
2618: --
2619: FUNCTION get_Num_Elements_On_Page(p_page_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
2620: RETURN NUMBER IS
2621: l_counter NUMBER;
2622: BEGIN
2623: SELECT COUNT(element_id)
2621: l_counter NUMBER;
2622: BEGIN
2623: SELECT COUNT(element_id)
2624: INTO l_counter
2625: FROM CZ_UI_PAGE_ELEMENTS
2626: WHERE ui_def_id=p_page_node.ui_def_id AND
2627: page_id=p_page_node.page_id AND ctrl_template_id IS NOT NULL AND
2628: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
2629: RETURN l_counter;
3023:
3024: --
3025: -- check - is it UI Reference or no
3026: --
3027: FUNCTION is_UI_Reference(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
3028: RETURN BOOLEAN IS
3029: l_ui_ref_exists VARCHAR2(1);
3030: BEGIN
3031: SELECT 'x' INTO l_ui_ref_exists
3039: RETURN FALSE;
3040: END is_UI_Reference;
3041:
3042: --
3043: -- remove Instance Management Controls from CZ_UI_PAGE_ELEMENTS
3044: --
3045: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3046:
3047: l_changed_pages_tbl number_tbl_type;
3041:
3042: --
3043: -- remove Instance Management Controls from CZ_UI_PAGE_ELEMENTS
3044: --
3045: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3046:
3047: l_changed_pages_tbl number_tbl_type;
3048: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
3049: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
3044: --
3045: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3046:
3047: l_changed_pages_tbl number_tbl_type;
3048: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
3049: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
3050:
3051: BEGIN
3052:
3045: PROCEDURE remove_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3046:
3047: l_changed_pages_tbl number_tbl_type;
3048: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
3049: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
3050:
3051: BEGIN
3052:
3053: FOR i IN(SELECT page_id,element_id,parent_element_id,suppress_refresh_flag
3050:
3051: BEGIN
3052:
3053: FOR i IN(SELECT page_id,element_id,parent_element_id,suppress_refresh_flag
3054: FROM CZ_UI_PAGE_ELEMENTS
3055: WHERE ui_def_id=p_ui_node.ui_def_id AND
3056: persistent_node_id=p_ui_node.persistent_node_id AND
3057: element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
3058: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG))
3057: element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
3058: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG))
3059: LOOP
3060: IF i.suppress_refresh_flag=G_YES_FLAG THEN
3061: UPDATE CZ_UI_PAGE_ELEMENTS
3062: SET deleted_flag=G_MARK_TO_DEASSOCIATE,
3063: persistent_node_id=0
3064: WHERE ui_def_id=p_ui_node.ui_def_id AND
3065: page_id=i.page_id AND
3064: WHERE ui_def_id=p_ui_node.ui_def_id AND
3065: page_id=i.page_id AND
3066: element_id=i.element_id;
3067: ELSE
3068: SELECT suppress_refresh_flag INTO l_suppress_refresh_flag FROM CZ_UI_PAGE_ELEMENTS
3069: WHERE ui_def_id=p_ui_node.ui_def_id AND page_id=i.page_id AND
3070: element_id=i.parent_element_id;
3071: IF l_suppress_refresh_flag=G_YES_FLAG THEN
3072: UPDATE CZ_UI_PAGE_ELEMENTS
3068: SELECT suppress_refresh_flag INTO l_suppress_refresh_flag FROM CZ_UI_PAGE_ELEMENTS
3069: WHERE ui_def_id=p_ui_node.ui_def_id AND page_id=i.page_id AND
3070: element_id=i.parent_element_id;
3071: IF l_suppress_refresh_flag=G_YES_FLAG THEN
3072: UPDATE CZ_UI_PAGE_ELEMENTS
3073: SET deleted_flag=G_MARK_TO_DEASSOCIATE,
3074: persistent_node_id=0
3075: WHERE ui_def_id=p_ui_node.ui_def_id AND
3076: page_id=i.page_id AND
3075: WHERE ui_def_id=p_ui_node.ui_def_id AND
3076: page_id=i.page_id AND
3077: element_id=i.element_id;
3078: ELSE
3079: UPDATE CZ_UI_PAGE_ELEMENTS
3080: SET deleted_flag=G_MARK_TO_DELETE
3081: WHERE ui_def_id=p_ui_node.ui_def_id AND
3082: page_id=i.page_id AND
3083: element_id=i.element_id;
3093: --
3094: -- merge two Page Flows - parent and child Page Flows into one Page Flow
3095: -- p_ui_node is a first node of child Page Flow
3096: --
3097: PROCEDURE merge_Page_Flows(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3098: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3099: l_changed_target_ids_tbl number_tbl_type;
3100: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3101: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3182:
3183: --
3184: -- split one Page Flow into two Page Flows - parent and child
3185: --
3186: PROCEDURE split_Page_Flow(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3187: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3188: l_changed_target_ids_tbl number_tbl_type;
3189: l_target_page_ids_tbl number_tbl_type;
3190: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3276:
3277: --
3278: -- check - is CX valid or no ?
3279: --
3280: FUNCTION get_CX_Button_Status(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
3281: RETURN VARCHAR2 IS
3282:
3283: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3284: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;
3383: --
3384: -- refresh expl ids in UI tables
3385: --
3386: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
3387: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
3388: p_expl_id IN NUMBER) IS
3389:
3390: BEGIN
3391:
3390: BEGIN
3391:
3392:
3393: IF p_expl_id <> p_ui_node.model_ref_expl_id THEN
3394: UPDATE CZ_UI_PAGE_ELEMENTS
3395: SET model_ref_expl_id=p_expl_id
3396: WHERE ui_def_id=p_ui_node.ui_def_id AND
3397: page_id=p_ui_node.page_id AND
3398: element_id=p_ui_node.element_id;
3422: --
3423: -- refresh expl ids in UI tables
3424: --
3425: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
3426: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3427: l_model_ref_expl_id NUMBER;
3428: BEGIN
3429: l_model_ref_expl_id := get_Expl_Id(p_model_id => p_node.devl_project_id,
3430: p_ps_node_id => p_node.ps_node_id,
3437:
3438: --
3439: -- replace Template Id of UI node p_ui_node
3440: --
3441: PROCEDURE replace_Template_Id(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
3442: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
3443:
3444: l_element_signature_id NUMBER;
3445: l_counter NUMBER;
3445: l_counter NUMBER;
3446:
3447: BEGIN
3448:
3449: SELECT COUNT(*)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
3450: WHERE ui_def_id=p_ui_node.ui_def_id AND
3451: page_id=p_ui_node.page_id AND
3452: element_signature_id=p_model_node.root_element_signature_id AND
3453: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG);
3451: page_id=p_ui_node.page_id AND
3452: element_signature_id=p_model_node.root_element_signature_id AND
3453: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE, G_LIMBO_FLAG);
3454:
3455: UPDATE CZ_UI_PAGE_ELEMENTS
3456: SET ctrl_template_id=p_model_node.template_id,
3457: element_signature_id=p_model_node.root_element_signature_id,
3458: deleted_flag=DECODE(deleted_flag,G_MARK_TO_ADD,G_MARK_TO_ADD,G_MARK_TO_REFRESH),
3459: name=p_model_node.template_name||' - '||l_counter
3586: END IF;
3587: END LOOP;
3588:
3589: FOR i IN (SELECT *
3590: FROM CZ_UI_PAGE_ELEMENTS
3591: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3592: deleted_flag = G_NO_FLAG)
3593: LOOP
3594: BEGIN
4042:
4043:
4044: FUNCTION find_AMN_Element_Above(p_xml_node xmldom.DOMNode) RETURN VARCHAR2 IS
4045:
4046: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4047:
4048: PROCEDURE AMN_Element_Above(p_node xmldom.DOMNode) IS
4049:
4050: l_node xmldom.DOMNode;
4297:
4298: END remove_user_attribute;
4299:
4300: --
4301: -- this procedure adds CZ_UI_PAGE_ELEMENTS records
4302: -- which correspond to first level UI template references
4303: --
4304: PROCEDURE add_Extends_Refs(p_xml_node xmldom.DOMNode,
4305: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
4301: -- this procedure adds CZ_UI_PAGE_ELEMENTS records
4302: -- which correspond to first level UI template references
4303: --
4304: PROCEDURE add_Extends_Refs(p_xml_node xmldom.DOMNode,
4305: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
4306:
4307: l_seq_nbr NUMBER;
4308: l_template_id NUMBER;
4309: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;
4306:
4307: l_seq_nbr NUMBER;
4308: l_template_id NUMBER;
4309: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;
4310: l_id_attribute_value CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4311: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4312: l_extend_attr_value VARCHAR2(4000);
4313:
4314: BEGIN
4307: l_seq_nbr NUMBER;
4308: l_template_id NUMBER;
4309: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;
4310: l_id_attribute_value CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4311: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4312: l_extend_attr_value VARCHAR2(4000);
4313:
4314: BEGIN
4315:
4328: SELECT template_id,template_name INTO l_template_id,l_template_name FROM CZ_UI_TEMPLATES
4329: WHERE ui_def_id=NVL(p_ui_node.ctrl_template_ui_def_id,G_GLOBAL_TEMPLATES_UI_DEF_ID) AND
4330: jrad_doc=l_extend_attr_value AND deleted_flag=G_NO_FLAG;
4331:
4332: SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
4333: WHERE ui_def_id=p_ui_node.ui_def_id AND
4334: page_id=p_ui_node.page_id AND
4335: parent_element_id=p_ui_node.element_id AND
4336: deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);
4336: deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG);
4337:
4338: l_element_id := get_element_Id();
4339:
4340: INSERT INTO CZ_UI_PAGE_ELEMENTS
4341: (
4342: UI_DEF_ID
4343: ,PAGE_ID
4344: ,PERSISTENT_NODE_ID
4392:
4393: FUNCTION find_Parent_UI_Element
4394: (p_xml_node xmldom.DOMNode,
4395: p_ui_def_id IN NUMBER,
4396: p_ui_page_id IN NUMBER) RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
4397:
4398: l_ui_element CZ_UI_PAGE_ELEMENTS%ROWTYPE;
4399:
4400: PROCEDURE get_Parent_XML(p_check_xml_node xmldom.DOMNode) IS
4394: (p_xml_node xmldom.DOMNode,
4395: p_ui_def_id IN NUMBER,
4396: p_ui_page_id IN NUMBER) RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
4397:
4398: l_ui_element CZ_UI_PAGE_ELEMENTS%ROWTYPE;
4399:
4400: PROCEDURE get_Parent_XML(p_check_xml_node xmldom.DOMNode) IS
4401:
4402: l_parent_xml_node xmldom.DOMNode;
4408:
4409: IF l_id_attr_value IS NOT NULL THEN
4410:
4411: BEGIN
4412: SELECT * INTO l_ui_element FROM CZ_UI_PAGE_ELEMENTS
4413: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
4414: element_id=l_id_attr_value;
4415: RETURN;
4416: EXCEPTION
4430:
4431: IF l_id_attr_value IS NOT NULL THEN
4432:
4433: BEGIN
4434: SELECT * INTO l_ui_element FROM CZ_UI_PAGE_ELEMENTS
4435: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
4436: element_id=l_id_attr_value;
4437: RETURN;
4438: EXCEPTION
4931:
4932:
4933: IF p_counter = -1 THEN
4934: SELECT COUNT(element_id) INTO p_counter
4935: FROM CZ_UI_PAGE_ELEMENTS
4936: WHERE ui_def_id=g_UI_Context.ui_def_id
4937: AND page_id=p_ui_page_id AND
4938: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
4939: END IF;
4999: --
5000: -- set Attributes for Template
5001: --
5002: PROCEDURE set_Template_Attributes(p_xml_root_node xmldom.DOMNode,
5003: p_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
5004: p_element_signature_id NUMBER DEFAULT NULL) IS
5005:
5006: l_xml_root_element_node xmldom.DOMElement := xmldom.makeElement(p_xml_root_node);
5007: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
5203:
5204: PROCEDURE construct_XML_Path(p_xml_node xmldom.DOMNode) IS
5205:
5206: l_parent_node xmldom.DOMNode;
5207: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
5208: l_user_attribute4_value VARCHAR2(32000);
5209: l_node_name VARCHAR2(32000);
5210:
5211: BEGIN
5259:
5260: PROCEDURE construct_XML_Path(p_xml_node xmldom.DOMNode) IS
5261:
5262: l_parent_node xmldom.DOMNode;
5263: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
5264: l_user_attribute4_value VARCHAR2(32000);
5265: l_node_name VARCHAR2(32000);
5266:
5267: BEGIN
6449:
6450: return l_new_xml_node;
6451: END insert_before;
6452:
6453: FUNCTION insert_node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
6454: p_new_xml_node IN xmldom.DOMNode,
6455: p_parent_xml_node IN xmldom.DOMNode)
6456: RETURN xmldom.DOMNode IS
6457:
6512:
6513: BEGIN
6514:
6515: SELECT element_id, ctrl_template_id INTO l_prev_element_id, l_prev_element_template_id
6516: FROM CZ_UI_PAGE_ELEMENTS
6517: WHERE ui_def_id=p_ui_node.ui_def_id AND
6518: page_id = p_ui_node.page_id AND
6519: parent_element_id = p_ui_node.parent_element_id AND
6520: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
6518: page_id = p_ui_node.page_id AND
6519: parent_element_id = p_ui_node.parent_element_id AND
6520: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
6521: seq_nbr = (SELECT max(seq_nbr)
6522: FROM CZ_UI_PAGE_ELEMENTS
6523: WHERE ui_def_id=p_ui_node.ui_def_id AND
6524: page_id = p_ui_node.page_id AND
6525: parent_element_id = p_ui_node.parent_element_id AND
6526: seq_nbr
6538: --DEBUG('asp:Here 1');
6539:
6540: BEGIN
6541: SELECT element_id, ctrl_template_id INTO l_next_element_id, l_next_element_template_id
6542: FROM CZ_UI_PAGE_ELEMENTS
6543: WHERE ui_def_id=p_ui_node.ui_def_id AND
6544: page_id = p_ui_node.page_id AND
6545: parent_element_id = p_ui_node.parent_element_id AND
6546: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE) AND
6544: page_id = p_ui_node.page_id AND
6545: parent_element_id = p_ui_node.parent_element_id AND
6546: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE) AND
6547: seq_nbr = ( SELECT min(seq_nbr)
6548: FROM CZ_UI_PAGE_ELEMENTS
6549: WHERE ui_def_id=p_ui_node.ui_def_id AND
6550: page_id = p_ui_node.page_id AND
6551: parent_element_id = p_ui_node.parent_element_id AND
6552: seq_nbr>p_ui_node.seq_nbr AND
6737:
6738: END pluck_XML_node;
6739:
6740:
6741: FUNCTION move_XML_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
6742: p_parent_xml_node xmldom.DOMNode)
6743: RETURN xmldom.DOMNode IS
6744:
6745: l_src_page_id NUMBER;
6853: END IF;
6854: END LOOP;
6855: END handle_JRAD_Id;
6856:
6857: FUNCTION create_UIXML_Element_new(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
6858: p_parent_xml_node xmldom.DOMNode)
6859: RETURN xmldom.DOMNode IS
6860:
6861: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
6930: l_template_is_used_by_ref := is_Used_By_Reference(l_node.detailed_type_id,p_ui_node.ctrl_template_id);
6931:
6932: BEGIN
6933: SELECT element_id, ctrl_template_id INTO l_prev_element_id, l_prev_element_template_id
6934: FROM CZ_UI_PAGE_ELEMENTS
6935: WHERE ui_def_id=p_ui_node.ui_def_id AND
6936: page_id = p_ui_node.page_id AND
6937: parent_element_id = p_ui_node.parent_element_id AND
6938: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG) AND
6939: --jonatara:bug fix7307460
6940: NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND ctrl_template_id IS NULL) AND
6941: NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL ) AND
6942: seq_nbr = (SELECT max(seq_nbr)
6943: FROM CZ_UI_PAGE_ELEMENTS
6944: WHERE ui_def_id=p_ui_node.ui_def_id AND
6945: page_id = p_ui_node.page_id AND
6946: parent_element_id = p_ui_node.parent_element_id AND
6947: seq_nbr
6958:
6959: BEGIN
6960:
6961: SELECT element_id, ctrl_template_id INTO l_next_element_id, l_next_element_template_id
6962: FROM CZ_UI_PAGE_ELEMENTS
6963: WHERE ui_def_id=p_ui_node.ui_def_id AND
6964: page_id = p_ui_node.page_id AND
6965: parent_element_id = p_ui_node.parent_element_id AND
6966: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG, G_MARK_TO_DELETE) AND
6967: --jonatara:bug fix7307460
6968: NOT (element_type = G_UI_DRILLDOWN_NODE_TYPE AND ctrl_template_id IS NULL) AND
6969: NOT (element_signature_id IS NULL AND ctrl_template_id IS NULL) AND
6970: seq_nbr = ( SELECT min(seq_nbr)
6971: FROM CZ_UI_PAGE_ELEMENTS
6972: WHERE ui_def_id=p_ui_node.ui_def_id AND
6973: page_id = p_ui_node.page_id AND
6974: parent_element_id = p_ui_node.parent_element_id AND
6975: seq_nbr>p_ui_node.seq_nbr AND
7452:
7453: --
7454: -- create new XML JRAD element
7455: --
7456: FUNCTION create_UIXML_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
7457: p_parent_xml_node xmldom.DOMNode)
7458: RETURN xmldom.DOMNode IS
7459:
7460: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
7519: l_template_is_used_by_ref := is_Used_By_Reference(l_node.detailed_type_id,p_ui_node.ctrl_template_id);
7520:
7521: BEGIN
7522: SELECT element_id INTO l_prev_element_id
7523: FROM CZ_UI_PAGE_ELEMENTS
7524: WHERE ui_def_id=p_ui_node.ui_def_id AND
7525: parent_persistent_node_id=p_ui_node.parent_persistent_node_id AND
7526: seq_nbr=p_ui_node.seq_nbr-1 AND
7527: deleted_flag<>G_YES_FLAG;
8012:
8013: --
8014: -- add new XML region
8015: --
8016: FUNCTION create_UIXML_Region(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
8017: p_parent_xml_node xmldom.DOMNode)
8018: RETURN xmldom.DOMNode IS
8019:
8020: l_subtree_doc xmldom.DOMDocument;
8087:
8088: --
8089: -- replace XML JRAD element
8090: --
8091: FUNCTION replace_UIXML_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
8092: p_parent_xml_node xmldom.DOMNode,
8093: p_xml_node_to_replace xmldom.DOMNode)
8094: RETURN xmldom.DOMNode IS
8095:
8480: G_USER_ATTRIBUTE1_NAME);
8481:
8482: IF l_current_model_path IS NOT NULL THEN
8483:
8484: SELECT model_ref_expl_id INTO l_ui_node_expl_id FROM CZ_UI_PAGE_ELEMENTS
8485: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_ui_page_id AND element_id=p_ui_element_id;
8486:
8487: l_new_model_path := get_Runtime_Relative_Path(p_model_id => g_UI_Context.devl_project_id,
8488: p_base_persistent_node_id => p_base_persistent_node_id,
8611:
8612: BEGIN
8613:
8614: SELECT persistent_node_id, model_ref_expl_id INTO l_persistent_node_id, l_expl_id
8615: FROM CZ_UI_PAGE_ELEMENTS
8616: WHERE ui_def_id=g_UI_Context.ui_def_id AND
8617: page_id=p_page_id AND
8618: element_id=l_element_id;
8619:
9108: p_create_empty_ui IN VARCHAR2 DEFAULT NULL)
9109: RETURN CZ_UI_DEFS%ROWTYPE IS
9110:
9111: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
9112: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
9113: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
9114: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
9115: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
9116: l_master_template_id NUMBER;
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
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
9441: --
9442: -- create new CX button
9443: --
9444: PROCEDURE add_CX_Button(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
9445: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
9446:
9447: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9448: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9443: --
9444: PROCEDURE add_CX_Button(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
9445: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
9446:
9447: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9448: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9450: l_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9451: l_page_path VARCHAR2(32000);
9444: PROCEDURE add_CX_Button(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
9445: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
9446:
9447: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9448: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9450: l_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9451: l_page_path VARCHAR2(32000);
9452: l_ui_intl_text_id INTEGER;
9446:
9447: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9448: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
9449: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9450: l_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
9451: l_page_path VARCHAR2(32000);
9452: l_ui_intl_text_id INTEGER;
9453: l_counter INTEGER;
9454: l_new_node BOOLEAN := FALSE;
9527: l_parent_element_id := p_ui_node.parent_element_id;
9528: END IF;
9529: l_new_node := TRUE;
9530:
9531: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
9532: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9533: page_id=p_ui_node.page_id AND
9534: ctrl_template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
9535: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
9535: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
9536:
9537: l_name := G_DRILLDOWN_TEMPLATE_NAME||' - '||TO_CHAR(l_counter);
9538:
9539: INSERT INTO CZ_UI_PAGE_ELEMENTS
9540: (ui_def_id,
9541: persistent_node_id,
9542: parent_persistent_node_id,
9543: region_persistent_node_id,
9708: END IF;
9709:
9710: l_new_node := TRUE;
9711:
9712: INSERT INTO CZ_UI_PAGE_ELEMENTS
9713: (ui_def_id,
9714: persistent_node_id,
9715: parent_persistent_node_id,
9716: region_persistent_node_id,
9816: SELECT persistent_node_id INTO l_persistent_id FROM CZ_PS_NODES
9817: WHERE devl_project_id=l_ref_model_id AND ps_node_id=i.component_id;
9818:
9819: -- find model_ref_expl_id and persistent_node_id of pagebase
9820: SELECT model_ref_expl_id, persistent_node_id INTO l_pb_model_ref_expl_id, l_pb_persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
9821: WHERE ui_def_id=p_ui_node.ui_def_id AND page_id=p_ui_node.page_id AND
9822: element_id=p_ui_node.parent_element_id;
9823:
9824: -- save runtime relative path of CX button in associative array g_ref_cx_paths_tbl ( UI element_id <-> runtime relative path )
9847: END add_CX_Button;
9848:
9849: --
9850: -- handle CX for those nodes which have no corresponding
9851: -- records in table CZ_UI_PAGE_ELEMENTS
9852: --
9853: PROCEDURE handle_CXs_For_nonUINodes IS
9854:
9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9852: --
9853: PROCEDURE handle_CXs_For_nonUINodes IS
9854:
9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9856: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9857: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9858: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9859: l_persistent_intl_text_id NUMBER;
9860: BEGIN
9853: PROCEDURE handle_CXs_For_nonUINodes IS
9854:
9855: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9856: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9857: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9858: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9859: l_persistent_intl_text_id NUMBER;
9860: BEGIN
9861:
9871: disabled_flag=G_NO_FLAG AND
9872: deleted_flag=G_NO_FLAG))
9873: LOOP
9874: FOR parent_ui_node IN(SELECT *
9875: FROM CZ_UI_PAGE_ELEMENTS
9876: WHERE ui_def_id=g_UI_Context.ui_def_id AND
9877: persistent_node_id=option_node.parent_persistent_node_id AND
9878: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
9879: LOOP
9929: ELSE
9930: l_parent_element_id := parent_ui_node.parent_element_id;
9931: END IF;
9932:
9933: INSERT INTO CZ_UI_PAGE_ELEMENTS
9934: (ui_def_id,
9935: persistent_node_id,
9936: parent_persistent_node_id,
9937: region_persistent_node_id,
10033:
10034: END handle_CXs_For_nonUINodes;
10035:
10036:
10037: FUNCTION disabled_for_refresh(p_page_element IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) RETURN BOOLEAN
10038: IS
10039: l_dummy VARCHAR2(1);
10040: BEGIN
10041:
10041:
10042: SELECT '1' INTO l_dummy
10043: FROM DUAL
10044: WHERE '1' IN (SELECT suppress_refresh_flag
10045: FROM cz_ui_page_elements
10046: START WITH ui_def_Id = p_page_element.ui_def_id
10047: AND page_id = p_page_element.page_id
10048: AND element_id = p_page_element.element_id
10049: CONNECT BY PRIOR parent_element_id IS NOT NULL
10058: END disabled_for_refresh;
10059:
10060: --
10061: -- handle CX for those nodes which have no corresponding
10062: -- records in table CZ_UI_PAGE_ELEMENTS
10063: --
10064: PROCEDURE handle_CXs IS
10065:
10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
10063: --
10064: PROCEDURE handle_CXs IS
10065:
10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
10067: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10068: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10069: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10070: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10071: l_invalid_flag VARCHAR2(1);
10064: PROCEDURE handle_CXs IS
10065:
10066: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
10067: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10068: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10069: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10070: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10071: l_invalid_flag VARCHAR2(1);
10072:
10073: BEGIN
10074:
10075:
10076: FOR i in (SELECT DISTINCT page_id
10077: FROM cz_ui_page_elements
10078: WHERE ui_def_Id = g_UI_Context.ui_def_id
10079: AND element_type = G_UI_CX_BUTTON_NODE_TYPE
10080: AND deleted_flag = G_NO_FLAG)
10081: LOOP
10099: LOOP
10100: BEGIN
10101:
10102: SELECT e.element_id INTO l_element_id
10103: FROM CZ_UI_PAGE_ELEMENTS e
10104: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10105: persistent_node_id = i.persistent_node_id AND
10106: element_type = G_UI_CX_BUTTON_NODE_TYPE AND
10107: deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE) AND
10114: EXCEPTION
10115: WHEN NO_DATA_FOUND THEN
10116: -- No button for the action; Create one
10117: FOR j in (SELECT *
10118: FROM CZ_UI_PAGE_ELEMENTS e
10119: WHERE ui_def_id = g_UI_Context.ui_def_id AND
10120: persistent_node_id = i.persistent_node_id AND
10121: deleted_flag NOT IN (G_YES_FLAG, G_MARK_TO_DELETE))
10122: LOOP
10133: --
10134: -- create single UI element
10135: --
10136: FUNCTION create_UI_Element(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10137: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10138: p_insert_index IN NUMBER DEFAULT -1)
10139: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10140:
10141: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10135: --
10136: FUNCTION create_UI_Element(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10137: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10138: p_insert_index IN NUMBER DEFAULT -1)
10139: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10140:
10141: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10142: l_node_exists_in_ui VARCHAR2(1);
10143: l_counter NUMBER;
10137: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10138: p_insert_index IN NUMBER DEFAULT -1)
10139: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10140:
10141: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10142: l_node_exists_in_ui VARCHAR2(1);
10143: l_counter NUMBER;
10144: l_parent_seq_nbr NUMBER;
10145: l_max_prev_seq_nbr NUMBER;
10151: END IF;
10152:
10153: BEGIN
10154: SELECT G_YES_FLAG INTO l_node_exists_in_ui FROM dual
10155: WHERE EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
10156: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10157: page_id=p_parent_ui_node.page_id AND
10158: parent_element_id=p_parent_ui_node.element_id AND
10159: persistent_node_id=p_node.persistent_node_id AND
10175: IF p_insert_index > 0 THEN
10176: l_max_prev_seq_nbr := p_insert_index-1;
10177: l_ui_node.seq_nbr := p_insert_index;
10178: ELSE
10179: SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
10180: START WITH ui_def_id=g_UI_Context.ui_def_id AND
10181: page_id=p_parent_ui_node.page_id AND
10182: element_id=p_parent_ui_node.element_id AND
10183: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
10189:
10190: l_ui_node.seq_nbr := l_max_prev_seq_nbr + 1;
10191: END IF;
10192:
10193: UPDATE CZ_UI_PAGE_ELEMENTS
10194: SET seq_nbr=seq_nbr+1
10195: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10196: page_id=p_parent_ui_node.page_id AND
10197: seq_nbr>l_max_prev_seq_nbr AND
10236: p_ps_node_type => p_node.ps_node_type);
10237: l_ui_node.element_signature_id := p_node.root_element_signature_id;
10238: l_ui_node.deleted_flag := G_MARK_TO_ADD;
10239:
10240: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
10241: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10242: page_id=l_ui_node.page_id AND
10243: ctrl_template_id=l_ui_node.ctrl_template_id AND
10244: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
10246: l_ui_node.name := p_node.template_name||' - '||TO_CHAR(l_counter);
10247:
10248: --DEBUG('asp:Inserting ' || l_ui_node.element_id || ' at seq ' || l_ui_node.seq_nbr);
10249:
10250: INSERT INTO CZ_UI_PAGE_ELEMENTS
10251: (ui_def_id,
10252: persistent_node_id,
10253: parent_persistent_node_id,
10254: region_persistent_node_id,
10297:
10298: --
10299: -- add Instance Management Controls
10300: --
10301: PROCEDURE add_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10302: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
10304:
10305: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10298: --
10299: -- add Instance Management Controls
10300: --
10301: PROCEDURE add_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10302: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
10304:
10305: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10306: l_element_type CZ_UI_PAGE_ELEMENTS.element_type%TYPE;
10301: PROCEDURE add_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10302: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
10304:
10305: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10306: l_element_type CZ_UI_PAGE_ELEMENTS.element_type%TYPE;
10307: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10308: l_parent_seq_nbr NUMBER;
10309: l_seq_nbr NUMBER;
10302: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
10304:
10305: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10306: l_element_type CZ_UI_PAGE_ELEMENTS.element_type%TYPE;
10307: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10308: l_parent_seq_nbr NUMBER;
10309: l_seq_nbr NUMBER;
10310: l_counter NUMBER;
10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
10304:
10305: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10306: l_element_type CZ_UI_PAGE_ELEMENTS.element_type%TYPE;
10307: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10308: l_parent_seq_nbr NUMBER;
10309: l_seq_nbr NUMBER;
10310: l_counter NUMBER;
10311: l_max_prev_seq_nbr NUMBER;
10315: IF p_parent_ui_node.suppress_refresh_flag=G_YES_FLAG THEN
10316: RETURN;
10317: END IF;
10318:
10319: SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
10320: START WITH ui_def_id=g_UI_Context.ui_def_id AND
10321: page_id=p_parent_ui_node.page_id AND
10322: element_id=p_parent_ui_node.element_id AND
10323: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
10328: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
10329:
10330: l_seq_nbr := l_max_prev_seq_nbr + 1;
10331:
10332: UPDATE CZ_UI_PAGE_ELEMENTS
10333: SET seq_nbr=seq_nbr+1
10334: WHERE ui_def_id=g_UI_Context.ui_def_id AND
10335: page_id=p_parent_ui_node.page_id AND
10336: seq_nbr>l_max_prev_seq_nbr AND
10349: l_ui_node_name := get_UI_Node_Name(p_page_id => p_parent_ui_node.page_id,
10350: p_template_id => p_node.template_id,
10351: p_template_name => p_node.template_name);
10352:
10353: INSERT INTO CZ_UI_PAGE_ELEMENTS
10354: (ui_def_id,
10355: persistent_node_id,
10356: parent_persistent_node_id,
10357: region_persistent_node_id,
10388: G_MARK_DO_NOT_REFRESH);
10389:
10390: -- delete drilldown associated with the same persistent_node_id
10391: --
10392: UPDATE CZ_UI_PAGE_ELEMENTS
10393: SET deleted_flag=G_MARK_TO_DELETE
10394: WHERE ui_def_id = p_parent_ui_node.ui_def_id AND
10395: persistent_node_id=p_ui_node.persistent_node_id AND
10396: element_type=G_UI_PAGEDRILLDOWN_NODE_TYPE AND
10402:
10403: --
10404: -- create Drilldown button
10405: --
10406: PROCEDURE create_Drilldown_Button(p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10407: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10403: --
10404: -- create Drilldown button
10405: --
10406: PROCEDURE create_Drilldown_Button(p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10407: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10406: PROCEDURE create_Drilldown_Button(p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10407: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10412: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10413: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10414:
10408: p_page_set_id IN NUMBER) IS
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10412: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10413: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10414:
10415: BEGIN
10416:
10409:
10410: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10411: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10412: l_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10413: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10414:
10415: BEGIN
10416:
10417: IF p_parent_ui_node.suppress_refresh_flag=G_YES_FLAG THEN
10433: ELSE
10434: l_ui_node_name := 'Drilldown Button - '||TO_CHAR(l_seq_nbr);
10435: END IF;
10436:
10437: INSERT INTO CZ_UI_PAGE_ELEMENTS
10438: (ui_def_id,
10439: persistent_node_id,
10440: parent_persistent_node_id,
10441: region_persistent_node_id,
10554: p_parent_element_id IN VARCHAR2,
10555: p_pagebase_persistent_node_id IN NUMBER,
10556: p_check_child_bom_nodes IN VARCHAR2 DEFAULT NULL) IS
10557:
10558: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10559: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10560: BEGIN
10561:
10562: IF p_check_child_bom_nodes IS NULL OR p_check_child_bom_nodes=G_YES_FLAG THEN
10555: p_pagebase_persistent_node_id IN NUMBER,
10556: p_check_child_bom_nodes IN VARCHAR2 DEFAULT NULL) IS
10557:
10558: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
10559: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
10560: BEGIN
10561:
10562: IF p_check_child_bom_nodes IS NULL OR p_check_child_bom_nodes=G_YES_FLAG THEN
10563: IF NOT(contains_BOM_Nodes(p_node.ps_node_id)) THEN
10572: --DEBUG('asp:Inserting BOM Node ' || l_bom_element_id|| ' at seq ' || 1);
10573: --
10574: -- shift all UI elements down , because BOM table will have seq_nbr=1
10575: --
10576: UPDATE CZ_UI_PAGE_ELEMENTS
10577: SET seq_nbr=seq_nbr+1
10578: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id AND
10579: deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);
10580:
10578: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=p_page_id AND
10579: deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);
10580:
10581:
10582: INSERT INTO CZ_UI_PAGE_ELEMENTS
10583: (ui_def_id,
10584: persistent_node_id,
10585: parent_persistent_node_id,
10586: region_persistent_node_id,
10783: x_page_set_id OUT NOCOPY NUMBER,
10784: x_page_set_type OUT NOCOPY NUMBER,
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;
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;
10794: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
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;
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;
10803: l_ui_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
10804: l_parent_page_persistent_id NUMBER;
10989:
10990: g_ELEMENT_COUNTER := 0;
10991: l_page_ui_node.name := 'Page Region - 1';
10992:
10993: INSERT INTO CZ_UI_PAGE_ELEMENTS
10994: (ui_def_id,
10995: persistent_node_id,
10996: parent_persistent_node_id,
10997: region_persistent_node_id,
11048: END IF;
11049:
11050: IF NVL(g_UI_Context.suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG THEN
11051: FOR i IN(SELECT *
11052: FROM CZ_UI_PAGE_ELEMENTS
11053: WHERE ui_def_id=l_page_ui_node.ui_def_id AND
11054: page_id=l_last_page_id AND
11055: persistent_node_id=l_page_ui_node.parent_persistent_node_id AND
11056: element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE) AND
11185: --
11186: -- create nested Region
11187: --
11188: FUNCTION create_UI_Region(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11189: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11190: p_insert_index IN NUMBER DEFAULT -1)
11191: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11192:
11193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11187: --
11188: FUNCTION create_UI_Region(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11189: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11190: p_insert_index IN NUMBER DEFAULT -1)
11191: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11192:
11193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11194: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
11195: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11189: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11190: p_insert_index IN NUMBER DEFAULT -1)
11191: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11192:
11193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11194: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
11195: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11196: l_counter NUMBER;
11197: l_parent_seq_nbr NUMBER;
11190: p_insert_index IN NUMBER DEFAULT -1)
11191: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11192:
11193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11194: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
11195: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11196: l_counter NUMBER;
11197: l_parent_seq_nbr NUMBER;
11198: l_last_seq_nbr NUMBER;
11191: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11192:
11193: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11194: l_bom_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
11195: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
11196: l_counter NUMBER;
11197: l_parent_seq_nbr NUMBER;
11198: l_last_seq_nbr NUMBER;
11199: l_prev_seq_nbr NUMBER;
11224: l_ui_node.pagebase_persistent_node_id := p_parent_ui_node.persistent_node_id;
11225: l_ui_node.page_id := p_parent_ui_node.page_id;
11226:
11227: IF p_insert_index = -1 THEN
11228: SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
11229: START WITH ui_def_id=g_UI_Context.ui_def_id AND
11230: page_id=p_parent_ui_node.page_id AND
11231: element_id=p_parent_ui_node.element_id AND
11232: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
11240: END IF;
11241:
11242: l_ui_node.seq_nbr := l_max_prev_seq_nbr + 1;
11243:
11244: UPDATE CZ_UI_PAGE_ELEMENTS
11245: SET seq_nbr=seq_nbr+1
11246: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11247: page_id=p_parent_ui_node.page_id AND
11248: seq_nbr>l_max_prev_seq_nbr AND
11262: p_ps_node_type => p_node.ps_node_type);
11263: l_ui_node.element_signature_id := 6007;
11264: l_ui_node.deleted_flag := G_MARK_TO_ADD;
11265:
11266: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
11267: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11268: page_id=l_ui_node.page_id AND
11269: ctrl_template_id=l_ui_node.ctrl_template_id AND
11270: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
11270: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
11271:
11272: l_ui_node.name :='Nested Region - '||TO_CHAR(l_counter);
11273:
11274: INSERT INTO CZ_UI_PAGE_ELEMENTS
11275: (ui_def_id,
11276: persistent_node_id,
11277: parent_persistent_node_id,
11278: region_persistent_node_id,
11336: --
11337: -- create new UI Reference
11338: --
11339: FUNCTION create_UI_Reference(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11340: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
11341: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11337: -- create new UI Reference
11338: --
11339: FUNCTION create_UI_Reference(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11340: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
11341: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11339: FUNCTION create_UI_Reference(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11340: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
11341: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
11350: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
11352: l_counter NUMBER;
11378: l_ui_node.pagebase_persistent_node_id := p_parent_ui_node.pagebase_persistent_node_id;
11379: l_ui_node.page_id := p_parent_ui_node.page_id;
11380:
11381:
11382: SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
11383: START WITH ui_def_id=g_UI_Context.ui_def_id AND
11384: page_id=p_parent_ui_node.page_id AND
11385: element_id=p_parent_ui_node.element_id AND
11386: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE)
11391: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
11392:
11393: l_ui_node.seq_nbr := l_max_prev_seq_nbr + 1;
11394:
11395: UPDATE CZ_UI_PAGE_ELEMENTS
11396: SET seq_nbr=seq_nbr+1
11397: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11398: page_id=p_parent_ui_node.page_id AND
11399: seq_nbr>l_max_prev_seq_nbr AND
11418: l_ui_node.ctrl_template_ui_def_id := p_node.template_ui_def_id;
11419: l_ui_node.element_signature_id := p_node.root_element_signature_id;
11420: l_ui_node.deleted_flag := G_MARK_TO_ADD;
11421:
11422: SELECT COUNT(element_id)+1 INTO l_counter FROM CZ_UI_PAGE_ELEMENTS
11423: WHERE ui_def_id=g_UI_Context.ui_def_id AND
11424: page_id=l_ui_node.page_id AND
11425: ctrl_template_id=l_ui_node.ctrl_template_id AND
11426: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
11434: IF p_node.detailed_type_id IN(CZ_TYPES.UMANDATORY_REF_TYPEID) THEN
11435: BEGIN
11436:
11437: SELECT NVL(MAX(seq_nbr),0) INTO l_max_seq_nbr
11438: FROM CZ_UI_PAGE_ELEMENTS
11439: WHERE ui_def_id=l_ui_node.ui_def_id
11440: AND parent_element_id=l_ui_node.parent_element_id
11441: AND deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD)
11442: AND element_type IN(G_UI_BOMADDINST_NODE_TYPE);
11441: AND deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD)
11442: AND element_type IN(G_UI_BOMADDINST_NODE_TYPE);
11443:
11444: SELECT persistent_node_id INTO l_persistent_node_id
11445: FROM CZ_UI_PAGE_ELEMENTS
11446: WHERE ui_def_id=l_ui_node.ui_def_id AND
11447: parent_element_id=l_ui_node.parent_element_id AND
11448: seq_nbr=l_max_seq_nbr AND
11449: ROWNUM<2;
11469: END;
11470: END IF;
11471:
11472: --
11473: -- model nodes must have associated record in CZ_UI_PAGE_ELEMENTS
11474: --
11475: INSERT INTO CZ_UI_PAGE_ELEMENTS
11476: (ui_def_id,
11477: persistent_node_id,
11471:
11472: --
11473: -- model nodes must have associated record in CZ_UI_PAGE_ELEMENTS
11474: --
11475: INSERT INTO CZ_UI_PAGE_ELEMENTS
11476: (ui_def_id,
11477: persistent_node_id,
11478: parent_persistent_node_id,
11479: region_persistent_node_id,
11681:
11682: --
11683: -- delete UI element recursively
11684: --
11685: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11686: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11687: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11688:
11689: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11682: --
11683: -- delete UI element recursively
11684: --
11685: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11686: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11687: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11688:
11689: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11690: l_del_flag BOOLEAN := FALSE;
11685: PROCEDURE delete_UI_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11686: p_suppress_refresh_flag IN CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE DEFAULT NULL,
11687: p_delete_in_model IN BOOLEAN DEFAULT NULL) IS
11688:
11689: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11690: l_del_flag BOOLEAN := FALSE;
11691: BEGIN
11692:
11693: --
11695: -- belong to
11696: --
11697: IF p_suppress_refresh_flag IS NULL THEN
11698: FOR i IN (SELECT persistent_node_id,region_persistent_node_id,suppress_refresh_flag
11699: FROM CZ_UI_PAGE_ELEMENTS
11700: START WITH ui_def_id = p_ui_node.ui_def_id AND
11701: deleted_flag IN
11702: (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,
11703: G_MARK_TO_DELETE) AND element_id = p_ui_node.element_id
11730:
11731: --
11732: -- delete UI element
11733: --
11734: UPDATE CZ_UI_PAGE_ELEMENTS
11735: SET deleted_flag = G_MARK_TO_DELETE
11736: WHERE ui_def_id = p_ui_node.ui_def_id AND
11737: element_id IN
11738: (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
11734: UPDATE CZ_UI_PAGE_ELEMENTS
11735: SET deleted_flag = G_MARK_TO_DELETE
11736: WHERE ui_def_id = p_ui_node.ui_def_id AND
11737: element_id IN
11738: (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
11739: START WITH ui_def_id=p_ui_node.ui_def_id AND element_id=p_ui_node.element_id
11740: CONNECT BY PRIOR ui_def_id=p_ui_node.ui_def_id AND ui_def_id=p_ui_node.ui_def_id AND
11741: PRIOR element_id=parent_element_id AND
11742: deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE) AND
11748: IF p_delete_in_model THEN
11749: --
11750: -- deassociate UI element from model node
11751: --
11752: UPDATE CZ_UI_PAGE_ELEMENTS
11753: SET deleted_flag = G_MARK_TO_DEASSOCIATE,
11754: persistent_node_id = 0
11755: WHERE ui_def_id = p_ui_node.ui_def_id AND
11756: element_id IN
11753: SET deleted_flag = G_MARK_TO_DEASSOCIATE,
11754: persistent_node_id = 0
11755: WHERE ui_def_id = p_ui_node.ui_def_id AND
11756: element_id IN
11757: (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
11758: START WITH ui_def_id=p_ui_node.ui_def_id AND element_id=p_ui_node.element_id
11759: CONNECT BY PRIOR ui_def_id=p_ui_node.ui_def_id AND
11760: PRIOR element_id=parent_element_id AND
11761: deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH,G_MARK_TO_DELETE) AND
11784: SET deleted_flag = G_YES_FLAG
11785: WHERE ui_def_id=p_ui_node.ui_def_id AND
11786: ref_persistent_node_id=p_ui_node.persistent_node_id AND
11787: deleted_flag=G_NO_FLAG AND NOT EXISTS
11788: (SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
11789: WHERE ui_def_id=p_ui_node.ui_def_id AND
11790: persistent_node_id=p_ui_node.persistent_node_id AND
11791: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH));
11792: END IF;
11802:
11803: --
11804: -- remove UI Page Ref record
11805: --
11806: PROCEDURE remove_UI_Page_Ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11807:
11808: l_page_ref_id NUMBER;
11809: l_parent_page_ref_id NUMBER;
11810: l_page_set_id NUMBER;
11842: WHEN OTHERS THEN
11843: NULL;
11844: END remove_UI_Page_Ref;
11845:
11846: PROCEDURE delete_Related_Buttons(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11847: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11848: BEGIN
11849:
11850: FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
11843: NULL;
11844: END remove_UI_Page_Ref;
11845:
11846: PROCEDURE delete_Related_Buttons(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11847: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11848: BEGIN
11849:
11850: FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
11851: FROM CZ_UI_PAGE_ELEMENTS a
11847: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11848: BEGIN
11849:
11850: FOR i IN(SELECT element_id,parent_element_id,page_id,suppress_refresh_flag
11851: FROM CZ_UI_PAGE_ELEMENTS a
11852: WHERE ui_def_id=p_ui_node.ui_def_id AND
11853: persistent_node_id=p_ui_node.persistent_node_id AND
11854: element_type IN(G_UI_BOMADDINST_NODE_TYPE,
11855: G_UI_NONBOMADDINST_NODE_TYPE,
11860: IF i.parent_element_id IS NOT NULL THEN
11861: BEGIN
11862: l_suppress_refresh_flag := G_NO_FLAG;
11863: SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
11864: FROM CZ_UI_PAGE_ELEMENTS
11865: WHERE ui_def_id = p_ui_node.ui_def_id AND
11866: page_id = i.page_id AND
11867: element_id=i.parent_element_id;
11868: EXCEPTION
11871: END;
11872: END IF;
11873:
11874: IF l_suppress_refresh_flag=G_YES_FLAG OR i.suppress_refresh_flag=G_YES_FLAG THEN
11875: UPDATE CZ_UI_PAGE_ELEMENTS
11876: SET deleted_flag = G_MARK_TO_DEASSOCIATE,
11877: persistent_node_id=0
11878: WHERE ui_def_id = p_ui_node.ui_def_id AND
11879: page_id = i.page_id AND
11878: WHERE ui_def_id = p_ui_node.ui_def_id AND
11879: page_id = i.page_id AND
11880: element_id = i.element_id;
11881: ELSE
11882: UPDATE CZ_UI_PAGE_ELEMENTS
11883: SET deleted_flag = G_MARK_TO_DELETE
11884: WHERE ui_def_id = p_ui_node.ui_def_id AND
11885: page_id = i.page_id AND
11886: element_id = i.element_id;
11894:
11895: --
11896: -- delete UI container
11897: --
11898: PROCEDURE delete_UI_Container(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
11899: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11900: l_element_id_tbl varchar_tbl_type;
11901: l_parent_element_id_tbl varchar_tbl_type;
11902: l_persistent_node_id_tbl number_tbl_type;
11901: l_parent_element_id_tbl varchar_tbl_type;
11902: l_persistent_node_id_tbl number_tbl_type;
11903: l_suppress_refresh_flag_tbl varchar_tbl_type;
11904: l_page_id_tbl number_tbl_type;
11905: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11906:
11907: BEGIN
11908:
11909: --
11913:
11914: SELECT element_id, parent_element_id, persistent_node_id,page_id, NVL(suppress_refresh_flag,G_NO_FLAG)
11915: BULK COLLECT INTO l_element_id_tbl, l_parent_element_id_tbl, l_persistent_node_id_tbl,
11916: l_page_id_tbl, l_suppress_refresh_flag_tbl
11917: FROM CZ_UI_PAGE_ELEMENTS
11918: WHERE ui_def_id=p_ui_node.ui_def_id AND
11919: page_id=p_ui_node.page_id AND
11920: deleted_flag NOT IN(G_YES_FLAG);
11921:
11935:
11936: SELECT element_id,persistent_node_id,page_id, suppress_refresh_flag
11937: BULK COLLECT INTO l_element_id_tbl, l_persistent_node_id_tbl,
11938: l_page_id_tbl, l_suppress_refresh_flag_tbl
11939: FROM CZ_UI_PAGE_ELEMENTS
11940: START WITH ui_def_id=p_ui_node.ui_def_id AND
11941: page_id=p_ui_node.page_id AND
11942: element_id=p_ui_node.element_id
11943: CONNECT BY PRIOR element_id=parent_element_id AND
11958: BEGIN
11959: l_suppress_refresh_flag := G_NO_FLAG;
11960: IF l_parent_element_id_tbl(i) IS NOT NULL THEN
11961: SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
11962: FROM CZ_UI_PAGE_ELEMENTS
11963: WHERE ui_def_id = p_ui_node.ui_def_id AND
11964: page_id = p_ui_node.page_id AND
11965: element_id=l_parent_element_id_tbl(i);
11966: END IF;
11969: NULL;
11970: END;
11971:
11972: IF l_suppress_refresh_flag=G_YES_FLAG OR l_suppress_refresh_flag_tbl(i)=G_YES_FLAG THEN
11973: UPDATE CZ_UI_PAGE_ELEMENTS
11974: SET deleted_flag = G_MARK_TO_DEASSOCIATE,
11975: persistent_node_id=0
11976: WHERE ui_def_id = p_ui_node.ui_def_id AND
11977: page_id = p_ui_node.page_id AND
11976: WHERE ui_def_id = p_ui_node.ui_def_id AND
11977: page_id = p_ui_node.page_id AND
11978: element_id = l_element_id_tbl(i);
11979: ELSE
11980: UPDATE CZ_UI_PAGE_ELEMENTS
11981: SET deleted_flag = G_MARK_TO_DELETE
11982: WHERE ui_def_id = p_ui_node.ui_def_id AND
11983: page_id = p_ui_node.page_id AND
11984: element_id = l_element_id_tbl(i);
11994: END delete_UI_Container;
11995:
11996: PROCEDURE handle_Deleted_Nodes(p_ui_def_id IN NUMBER) IS
11997:
11998: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
11999:
12000: BEGIN
12001:
12002: -- delete UI References
12022:
12023: --
12024: -- delete UI page
12025: --
12026: PROCEDURE delete_UI_Page(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12027:
12028: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12029: l_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12030: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
12046:
12047: --
12048: -- delete UI region
12049: --
12050: PROCEDURE delete_UI_Region(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12051: BEGIN
12052: delete_UI_Container(p_ui_node);
12053: END delete_UI_Region;
12054:
12125: END IF;
12126: END replace_page_ref_target_path;
12127:
12128:
12129: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12130: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12131:
12132: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12133: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12229:
12230: END move_page_ref;
12231:
12232:
12233: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12234: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12235: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
12236:
12237: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12264:
12265: --
12266: -- change instantiability of Page
12267: --
12268: PROCEDURE check_Page_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12269: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12270:
12271: l_changed_pages_tbl number_tbl_type;
12272: l_persistent_node_id_tbl number_tbl_type;
12277: l_parent_ref_persist_id CZ_UI_PAGE_REFS.target_persistent_node_id%TYPE;
12278: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12279: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12281: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
12282: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12283:
12284: BEGIN
12285:
12278: l_new_parent_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12279: l_curr_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12280: l_page_set_suppress_flag CZ_UI_PAGE_SETS.suppress_refresh_flag%TYPE;
12281: l_mark_flag CZ_UI_PAGE_ELEMENTS.deleted_flag%TYPE;
12282: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12283:
12284: BEGIN
12285:
12286: SELECT page_set_id INTO l_page_set_id FROM CZ_UI_PAGES
12296: IF p_node.parent_persistent_node_id<>p_ui_node.parent_persistent_node_id AND
12297: p_ui_node.instantiable_flag=p_node.instantiable_flag AND
12298: p_ui_node.instantiable_flag IN(G_OPTIONAL_INST_TYPE,G_MINMAX_INST_TYPE,G_MANDATORY_INST_TYPE) THEN
12299:
12300: FOR i IN(SELECT page_id,element_id,parent_element_id,suppress_refresh_flag FROM CZ_UI_PAGE_ELEMENTS
12301: WHERE ui_def_id=p_ui_node.ui_def_id AND
12302: persistent_node_id=p_ui_node.parent_persistent_node_id AND
12303: ((region_persistent_node_id=persistent_node_id OR
12304: pagebase_persistent_node_id=persistent_node_id) AND
12308: ,G_3COLS_CONTAINER_TEMPLATE_ID)) AND
12309: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE))
12310: LOOP
12311: IF i.suppress_refresh_flag=G_YES_FLAG THEN
12312: UPDATE CZ_UI_PAGE_ELEMENTS
12313: SET deleted_flag=G_MARK_TO_DEASSOCIATE,
12314: persistent_node_id=0
12315: WHERE ui_def_id=p_ui_node.ui_def_id AND
12316: page_id=i.page_id AND
12318: element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,
12319: G_UI_BOMADDINST_NODE_TYPE,
12320: G_UI_PAGEDRILLDOWN_NODE_TYPE);
12321: ELSE
12322: UPDATE CZ_UI_PAGE_ELEMENTS
12323: SET deleted_flag=G_MARK_TO_DELETE
12324: WHERE ui_def_id=p_ui_node.ui_def_id AND
12325: page_id=i.page_id AND
12326: persistent_node_id=p_ui_node.persistent_node_id AND
12332: mark_UI_Page_As_Refreshed(i.page_id, p_ui_node.ui_def_id);
12333:
12334: END LOOP;
12335:
12336: FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
12337: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12338: persistent_node_id=p_node.parent_persistent_node_id AND
12339: ((region_persistent_node_id=persistent_node_id OR
12340: pagebase_persistent_node_id=persistent_node_id) AND
12380:
12381: IF g_UI_Context.PRIMARY_NAVIGATION IN(G_SINGLE_PAGE,G_SUBTABS) OR
12382: l_new_parent_page_ref_id IS NULL THEN
12383:
12384: FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
12385: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12386: persistent_node_id=p_node.parent_persistent_node_id AND
12387: (region_persistent_node_id=persistent_node_id OR
12388: pagebase_persistent_node_id=persistent_node_id) AND
12418:
12419: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
12420:
12421: --
12422: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12423: -- CZ_PS_NODES.instantiable_flag
12424: --
12425: FOR n IN(SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS a
12426: WHERE ui_def_id=p_ui_node.ui_def_id AND
12421: --
12422: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12423: -- CZ_PS_NODES.instantiable_flag
12424: --
12425: FOR n IN(SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS a
12426: WHERE ui_def_id=p_ui_node.ui_def_id AND
12427: persistent_node_id=p_ui_node.persistent_node_id AND
12428: element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
12429: deleted_flag=G_NO_FLAG AND NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG AND
12426: WHERE ui_def_id=p_ui_node.ui_def_id AND
12427: persistent_node_id=p_ui_node.persistent_node_id AND
12428: element_type IN(G_UI_NONBOMADDINST_NODE_TYPE,G_UI_BOMADDINST_NODE_TYPE) AND
12429: deleted_flag=G_NO_FLAG AND NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG AND
12430: EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
12431: WHERE ui_def_id=p_ui_node.ui_def_id AND
12432: page_id=a.page_id AND
12433: element_id=a.parent_element_id AND
12434: NVL(suppress_refresh_flag,G_NO_FLAG)=G_NO_FLAG)
12438: l_ui_node_name := get_UI_Node_Name(p_page_id => n.page_id,
12439: p_template_id => p_node.template_id,
12440: p_template_name => p_node.template_name);
12441:
12442: UPDATE CZ_UI_PAGE_ELEMENTS a
12443: SET ctrl_template_id = p_node.template_id,
12444: ctrl_template_ui_def_id = p_node.template_ui_def_id,
12445: instantiable_flag = p_node.instantiable_flag,
12446: name=l_ui_node_name,
12460: mark_UI_Page_As_Refreshed(l_changed_pages_tbl(i), g_UI_Context.ui_def_id);
12461: END LOOP;
12462: END IF;
12463:
12464: FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS a
12465: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12466: persistent_node_id=p_node.parent_persistent_node_id AND
12467: (region_persistent_node_id=persistent_node_id OR
12468: pagebase_persistent_node_id=persistent_node_id) AND
12471: ctrl_template_id IN( G_CONTAINER_TEMPLATE_ID
12472: ,G_NSTD_CONTAINER_TEMPLATE_ID
12473: ,G_2COLS_CONTAINER_TEMPLATE_ID
12474: ,G_3COLS_CONTAINER_TEMPLATE_ID) AND
12475: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS b
12476: WHERE b.ui_def_id=g_UI_Context.ui_def_id AND
12477: b.page_id=a.page_id AND
12478: b.region_persistent_node_id=a.region_persistent_node_id AND
12479: b.persistent_node_id=p_ui_node.persistent_node_id AND
12495: p_ui_node.instantiable_flag=G_MANDATORY_INST_TYPE THEN
12496:
12497: g_check_boundaries_tbl(g_UI_Context.ui_def_id) := G_YES_FLAG;
12498:
12499: FOR parent_ui_node IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
12500: WHERE ui_def_id=g_UI_Context.ui_def_id AND
12501: persistent_node_id=p_node.parent_persistent_node_id AND
12502: ((region_persistent_node_id=persistent_node_id OR
12503: pagebase_persistent_node_id=persistent_node_id) AND
12524:
12525: END IF;
12526:
12527: --
12528: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12529: -- CZ_PS_NODES.instantiable_flag
12530: --
12531: UPDATE CZ_UI_PAGE_ELEMENTS
12532: SET instantiable_flag = p_node.instantiable_flag,
12527: --
12528: -- synchronize CZ_UI_PAGE_ELEMENTS.instantiable_flag with
12529: -- CZ_PS_NODES.instantiable_flag
12530: --
12531: UPDATE CZ_UI_PAGE_ELEMENTS
12532: SET instantiable_flag = p_node.instantiable_flag,
12533: parent_persistent_node_id=p_node.parent_persistent_node_id
12534: WHERE ui_def_id = p_ui_node.ui_def_id AND
12535: persistent_node_id = p_ui_node.persistent_node_id AND
12542:
12543: --
12544: -- change instantiability of Page
12545: --
12546: PROCEDURE check_Reference_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12547: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12548: l_refresh_ui_page BOOLEAN:=FALSE;
12549: l_persistent_node_id NUMBER;
12550: l_max_seq_nbr NUMBER;
12550: l_max_seq_nbr NUMBER;
12551: l_ps_node_type NUMBER;
12552: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12553: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12554: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12555: l_template_id NUMBER;
12556: l_template_ui_def_id NUMBER;
12557:
12558: BEGIN
12573: WHERE devl_project_id=p_node.reference_id AND
12574: parent_id IS NULL AND
12575: deleted_flag=G_NO_FLAG;
12576:
12577: FOR i IN(SELECT persistent_node_id FROM CZ_UI_PAGE_ELEMENTS
12578: WHERE ui_def_id=p_ui_node.ui_def_id
12579: AND parent_element_id=p_ui_node.parent_element_id
12580: AND persistent_node_id<>p_ui_node.persistent_node_id AND
12581: deleted_flag IN(G_NO_FLAG,G_MARK_TO_REFRESH,G_MARK_TO_ADD))
12600: l_ui_node_name := get_UI_Node_Name(p_page_id => p_ui_node.page_id,
12601: p_template_id => l_template_id,
12602: p_template_name => p_node.template_name);
12603:
12604: UPDATE CZ_UI_PAGE_ELEMENTS
12605: SET ctrl_template_id = l_template_id,
12606: ctrl_template_ui_def_id = l_template_ui_def_id,
12607: element_type = G_UI_DRILLDOWN_NODE_TYPE,
12608: instantiable_flag = p_node.instantiable_flag,
12631:
12632: --
12633: -- synchronize UI template with actual detailed node type
12634: --
12635: UPDATE CZ_UI_PAGE_ELEMENTS
12636: SET ctrl_template_id = p_node.template_id,
12637: ctrl_template_ui_def_id = p_node.template_ui_def_id,
12638: instantiable_flag = p_node.instantiable_flag,
12639: name=l_ui_node_name,
12662:
12663: --
12664: -- synchronize UI template with actual detailed node type
12665: --
12666: UPDATE CZ_UI_PAGE_ELEMENTS
12667: SET ctrl_template_id = p_node.template_id,
12668: ctrl_template_ui_def_id = p_node.template_ui_def_id,
12669: instantiable_flag = p_node.instantiable_flag,
12670: element_type = G_UI_NONBOMADDINST_NODE_TYPE,
12686: WHERE ui_def_id=p_ui_node.ui_def_id AND
12687: page_id=p_ui_node.page_id;
12688: END IF;
12689:
12690: UPDATE CZ_UI_PAGE_ELEMENTS
12691: SET instantiable_flag = p_node.instantiable_flag
12692: WHERE ui_def_id = p_ui_node.ui_def_id AND
12693: persistent_node_id = p_ui_node.persistent_node_id AND
12694: instantiable_flag <> p_node.instantiable_flag;
12710:
12711: END check_Reference_Changes;
12712:
12713:
12714: PROCEDURE check_Connector_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12715: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12716: l_refresh_ui_page BOOLEAN:=FALSE;
12717: l_persistent_node_id NUMBER;
12718: l_max_seq_nbr NUMBER;
12718: l_max_seq_nbr NUMBER;
12719: l_ps_node_type NUMBER;
12720: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12721: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12722: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12723: l_instantiable_flag CZ_UI_PAGE_ELEMENTS.instantiable_flag%TYPE;
12724: l_template_id NUMBER;
12725: l_template_ui_def_id NUMBER;
12726:
12719: l_ps_node_type NUMBER;
12720: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12721: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12722: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12723: l_instantiable_flag CZ_UI_PAGE_ELEMENTS.instantiable_flag%TYPE;
12724: l_template_id NUMBER;
12725: l_template_ui_def_id NUMBER;
12726:
12727: BEGIN
12742: ELSE
12743: l_instantiable_flag := G_MINMAX_INST_TYPE;
12744: END IF;
12745:
12746: UPDATE CZ_UI_PAGE_ELEMENTS
12747: SET ctrl_template_id = l_template_id,
12748: ctrl_template_ui_def_id = l_template_ui_def_id,
12749: instantiable_flag = l_instantiable_flag,
12750: name=l_ui_node_name,
12768:
12769: --
12770: -- change instantiability of UI region
12771: --
12772: PROCEDURE check_Region_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12773: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12774:
12775: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12776: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12771: --
12772: PROCEDURE check_Region_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12773: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12774:
12775: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12776: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12777: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
12778: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;
12779:
12791: x_page_set_type => l_page_set_type,
12792: x_page_ref_id => l_page_ref_id,
12793: p_parent_page_id => p_ui_node.page_id);
12794:
12795: UPDATE CZ_UI_PAGE_ELEMENTS
12796: SET deleted_flag=G_MARK_TO_DELETE
12797: WHERE ui_def_id=p_ui_node.ui_def_id AND
12798: page_id=p_ui_node.page_id AND
12799: element_id=p_ui_node.element_id;
12797: WHERE ui_def_id=p_ui_node.ui_def_id AND
12798: page_id=p_ui_node.page_id AND
12799: element_id=p_ui_node.element_id;
12800:
12801: UPDATE CZ_UI_PAGE_ELEMENTS
12802: SET page_id = l_page_ui_node.page_id,
12803: pagebase_persistent_node_id = l_page_ui_node.persistent_node_id,
12804: deleted_flag=G_MARK_TO_ADD
12805: WHERE (ui_def_id,page_id,element_id) IN
12803: pagebase_persistent_node_id = l_page_ui_node.persistent_node_id,
12804: deleted_flag=G_MARK_TO_ADD
12805: WHERE (ui_def_id,page_id,element_id) IN
12806: (SELECT ui_def_id,page_id,element_id FROM
12807: CZ_UI_PAGE_ELEMENTS
12808: START WITH ui_def_id=p_ui_node.ui_def_id AND
12809: page_id=p_ui_node.page_id AND
12810: element_id=p_ui_node.element_id
12811: CONNECT BY
12817: page_id=p_ui_node.page_id AND
12818: deleted_flag <> G_YES_FLAG)
12819: AND element_id <> p_ui_node.element_id;
12820:
12821: UPDATE CZ_UI_PAGE_ELEMENTS
12822: SET parent_element_id=l_page_ui_node.element_id
12823: WHERE ui_def_id=p_ui_node.ui_def_id AND
12824: page_id=l_page_ui_node.page_id AND
12825: parent_element_id=p_ui_node.element_id;
12840:
12841: --
12842: -- add new UI node
12843: --
12844: PROCEDURE add_New_UI_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12845: p_insert_index IN NUMBER DEFAULT -1,
12846: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12847: p_suppress_refresh_flag IN VARCHAR2,
12848: x_new_ui_pages_tbl IN OUT NOCOPY ui_page_elements_tbl_type,
12845: p_insert_index IN NUMBER DEFAULT -1,
12846: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12847: p_suppress_refresh_flag IN VARCHAR2,
12848: x_new_ui_pages_tbl IN OUT NOCOPY ui_page_elements_tbl_type,
12849: x_new_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12850:
12851: l_old_page_id NUMBER;
12852: l_page_set_id NUMBER;
12853: l_page_set_type NUMBER;
12912:
12913: --
12914: -- check UI Node changes
12915: --
12916: PROCEDURE check_UI_Node_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12917: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12918:
12919: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12920: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12917: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12918:
12919: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12920: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12921: l_feature_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
12922: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12923: l_max_seq_nbr NUMBER;
12924:
12925: CURSOR l_ui_bom_tab_cur IS
12918:
12919: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12920: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12921: l_feature_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
12922: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12923: l_max_seq_nbr NUMBER;
12924:
12925: CURSOR l_ui_bom_tab_cur IS
12926: SELECT * FROM CZ_UI_PAGE_ELEMENTS
12922: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12923: l_max_seq_nbr NUMBER;
12924:
12925: CURSOR l_ui_bom_tab_cur IS
12926: SELECT * FROM CZ_UI_PAGE_ELEMENTS
12927: WHERE ui_def_id=p_ui_node.ui_def_id AND
12928: parent_element_id=p_ui_node.element_id AND
12929: persistent_node_id=p_model_node.persistent_node_id AND
12930: element_type=G_UI_BOMADDINST_NODE_TYPE AND
13054: p_model_node => p_model_node);
13055: ELSE
13056:
13057: BEGIN
13058: SELECT NVL(MAX(seq_nbr),0)+1 INTO l_max_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
13059: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13060: page_id=p_ui_node.page_id AND
13061: parent_element_id IS NOT NULL AND
13062: (ctrl_template_id,ctrl_template_ui_def_id) IN
13077: p_model_node => p_model_node);
13078:
13079: ELSE
13080:
13081: UPDATE CZ_UI_PAGE_ELEMENTS
13082: SET deleted_flag=G_MARK_TO_DELETE
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;
13091: ui_def_id=g_UI_Context.ui_def_id;
13092:
13093: l_feature_element_id := get_Element_Id();
13094:
13095: INSERT INTO CZ_UI_PAGE_ELEMENTS
13096: (
13097: UI_DEF_ID
13098: ,PAGE_ID
13099: ,PERSISTENT_NODE_ID
13133: ,ELEMENT_TYPE
13134: ,NAME
13135: ,ELEMENT_SIGNATURE_ID
13136: ,SUPPRESS_REFRESH_FLAG
13137: FROM CZ_UI_PAGE_ELEMENTS
13138: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13139: page_id=p_ui_node.page_id AND
13140: element_id=p_ui_node.element_id;
13141:
13138: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13139: page_id=p_ui_node.page_id AND
13140: element_id=p_ui_node.element_id;
13141:
13142: UPDATE CZ_UI_PAGE_ELEMENTS
13143: SET parent_element_id=l_feature_element_id
13144: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13145: page_id=p_ui_node.page_id AND
13146: parent_element_id=p_ui_node.element_id;
13177: --
13178: -- create new split UI Page
13179: --
13180: FUNCTION clone_UI_Page(p_page_id IN NUMBER)
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;
13179: --
13180: FUNCTION clone_UI_Page(p_page_id IN NUMBER)
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;
13180: FUNCTION clone_UI_Page(p_page_id IN NUMBER)
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;
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
13297: FROM CZ_UI_PAGE_ELEMENTS
13298: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13299: page_id=p_page_id AND
13300: parent_element_id IS NULL AND
13301: deleted_flag IN(G_NO_FLAG,G_MARK_TO_ADD,G_MARK_TO_REFRESH);
13304: l_ui_node.page_id := l_page_id;
13305: l_ui_node.name := l_ui_node.name||' - '||l_element_id;
13306: l_ui_node.deleted_flag := G_MARK_TO_ADD;
13307:
13308: INSERT INTO CZ_UI_PAGE_ELEMENTS
13309: (ui_def_id,
13310: persistent_node_id,
13311: parent_persistent_node_id,
13312: region_persistent_node_id,
13417:
13418: END clone_UI_Page;
13419:
13420: PROCEDURE collect_UI_Elements
13421: (p_ui_page_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
13422: p_max_controls_per_page IN NUMBER,
13423: x_new_pages_tbl OUT NOCOPY number_tbl_type,
13424: x_elements_tbl OUT NOCOPY ui_page_elements_tbl_type,
13425: x_new_parent_elements_tbl OUT NOCOPY varchar_tbl_type) IS
13423: x_new_pages_tbl OUT NOCOPY number_tbl_type,
13424: x_elements_tbl OUT NOCOPY ui_page_elements_tbl_type,
13425: x_new_parent_elements_tbl OUT NOCOPY varchar_tbl_type) IS
13426:
13427: l_ui_page_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13428: l_counter NUMBER:=0;
13429:
13430: BEGIN
13431:
13432: l_ui_page_node := p_ui_page_node;
13433:
13434: FOR k IN(SELECT page_id,TO_NUMBER(element_id) AS element_id,
13435: TO_NUMBER(parent_element_id) AS parent_element_id,seq_nbr
13436: FROM CZ_UI_PAGE_ELEMENTS
13437: WHERE ui_def_id = p_ui_page_node.ui_def_id AND
13438: page_id = p_ui_page_node.page_id AND
13439: parent_element_id IS NOT NULL AND
13440: element_type <> G_UI_REGION_NODE_TYPE AND
13466:
13467: END collect_UI_Elements;
13468:
13469: PROCEDURE handle_Direct_Child_Nodes
13470: (p_ui_page_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
13471: p_elements_tbl IN OUT NOCOPY ui_page_elements_tbl_type,
13472: p_parent_elements_tbl IN OUT NOCOPY varchar_tbl_type) IS
13473:
13474: l_current_element_id NUMBER;
13480: IF l_current_element_id IS NULL THEN
13481: EXIT;
13482: END IF;
13483:
13484: UPDATE CZ_UI_PAGE_ELEMENTS
13485: SET page_id = p_elements_tbl(l_current_element_id).page_id
13486: WHERE ui_def_id = p_ui_page_node.ui_def_id AND
13487: page_id = p_ui_page_node.page_id AND
13488: element_id = TO_CHAR(l_current_element_id);
13487: page_id = p_ui_page_node.page_id AND
13488: element_id = TO_CHAR(l_current_element_id);
13489:
13490: IF p_parent_elements_tbl.EXISTS(l_current_element_id) THEN
13491: UPDATE CZ_UI_PAGE_ELEMENTS
13492: SET parent_element_id = p_parent_elements_tbl(l_current_element_id)
13493: WHERE ui_def_id = p_ui_page_node.ui_def_id AND
13494: page_id = p_ui_page_node.page_id AND
13495: element_id = TO_CHAR(l_current_element_id);
13510: EXIT;
13511: END IF;
13512:
13513: IF p_parent_elements_tbl.EXISTS(l_current_element_id) THEN
13514: UPDATE CZ_UI_PAGE_ELEMENTS
13515: SET parent_element_id = p_parent_elements_tbl(l_current_element_id)
13516: WHERE ui_def_id = p_ui_page_node.ui_def_id AND
13517: page_id = p_elements_tbl(l_current_element_id).page_id AND
13518: element_id = TO_CHAR(l_current_element_id);
13530: x_nested_page_elements_tbl OUT NOCOPY varchar_tbl_type) IS
13531:
13532: BEGIN
13533:
13534: FOR i IN(SELECT DISTINCT parent_element_id FROM CZ_UI_PAGE_ELEMENTS a
13535: WHERE ui_def_id = p_ui_def_id AND
13536: page_id = p_new_page_id AND
13537: parent_element_id IS NOT NULL AND
13538: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13534: FOR i IN(SELECT DISTINCT parent_element_id FROM CZ_UI_PAGE_ELEMENTS a
13535: WHERE ui_def_id = p_ui_def_id AND
13536: page_id = p_new_page_id AND
13537: parent_element_id IS NOT NULL AND
13538: NOT EXISTS(SELECT NULL FROM CZ_UI_PAGE_ELEMENTS
13539: WHERE ui_def_id = p_ui_def_id AND
13540: page_id = p_new_page_id AND
13541: element_id=a.parent_element_id))
13542: LOOP
13556: l_num_element_id NUMBER;
13557:
13558: BEGIN
13559:
13560: FOR i IN(SELECT element_id,parent_element_id,element_type FROM CZ_UI_PAGE_ELEMENTS
13561: START WITH ui_def_id = p_ui_def_id AND
13562: page_id= p_page_id AND
13563: element_id=p_element_id
13564: CONNECT BY PRIOR ui_def_id = p_ui_def_id AND
13603: END IF;
13604:
13605: l_nested_rgn_elements_tbl.DELETE;
13606:
13607: SELECT element_id INTO l_page_root_element_id FROM CZ_UI_PAGE_ELEMENTS
13608: WHERE ui_def_id=p_ui_def_id AND
13609: page_id=l_new_page_id AND
13610: parent_element_id IS NULL AND
13611: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE);
13640: l_new_parent_element_id := l_rgn_subtree_tbl(TO_NUMBER(l_parent_elements_tbl(l_old_element_id)));
13641: ELSE
13642: l_new_parent_element_id := l_page_root_element_id;
13643: END IF;
13644: INSERT INTO CZ_UI_PAGE_ELEMENTS
13645: (UI_DEF_ID
13646: ,PAGE_ID
13647: ,PERSISTENT_NODE_ID
13648: ,ELEMENT_ID
13680: ,ELEMENT_TYPE
13681: ,NAME
13682: ,ELEMENT_SIGNATURE_ID
13683: ,SUPPRESS_REFRESH_FLAG
13684: FROM CZ_UI_PAGE_ELEMENTS
13685: WHERE ui_def_id=p_ui_def_id AND
13686: page_id=p_page_id AND
13687: element_id=TO_CHAR(l_old_element_id);
13688:
13685: WHERE ui_def_id=p_ui_def_id AND
13686: page_id=p_page_id AND
13687: element_id=TO_CHAR(l_old_element_id);
13688:
13689: UPDATE CZ_UI_PAGE_ELEMENTS
13690: SET parent_element_id=l_new_element_id
13691: WHERE ui_def_id=p_ui_def_id AND
13692: page_id=l_new_page_id AND
13693: parent_element_id=TO_CHAR(l_old_element_id);
13707: -- split a single Page
13708: -- Parameters :
13709: -- p_ui_node - identifies UI node of page
13710: --
13711: PROCEDURE split_Page(p_ui_page_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
13712: p_max_controls_per_page IN NUMBER ) IS
13713:
13714: l_elements_tbl ui_page_elements_tbl_type;
13715: l_new_pages_tbl number_tbl_type;
13765: --
13766: -- split UI Pages
13767: --
13768: FOR i IN (SELECT *
13769: FROM CZ_UI_PAGE_ELEMENTS
13770: WHERE ui_def_id = g_UI_Context.ui_def_id AND
13771: parent_element_id IS NULL AND
13772: persistent_node_id=pagebase_persistent_node_id AND
13773: NVL(suppress_refresh_flag, G_NO_FLAG) = G_NO_FLAG AND
13858: l_counter NUMBER:=0;
13859:
13860: PROCEDURE set_UI_Order_(p_element_id IN VARCHAR2) IS
13861: BEGIN
13862: FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
13863: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13864: page_id=p_page_id AND
13865: parent_element_id=p_element_id AND
13866: deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
13865: parent_element_id=p_element_id AND
13866: deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
13867: LOOP
13868: l_counter := l_counter + 1;
13869: UPDATE CZ_UI_PAGE_ELEMENTS
13870: SET seq_nbr = l_counter
13871: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13872: element_id=i.element_id;
13873: set_UI_Order_(i.element_id);
13874: END LOOP;
13875: END set_UI_Order_;
13876:
13877: BEGIN
13878: FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
13879: WHERE ui_def_id=g_UI_Context.ui_def_id AND
13880: page_id=p_page_id AND
13881: parent_element_id IS NULL AND
13882: deleted_flag=G_NO_FLAG ORDER BY seq_nbr)
14027: -- get child UI Nodes
14028: --
14029: PROCEDURE get_Child_UI_Nodes
14030: (
14031: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
14032: p_child_nodes_tbl IN OUT NOCOPY model_nodes_tbl_type,
14033: x_ui_nodes_tbl OUT NOCOPY ui_page_elements_tbl_type,
14034: p_suppress_refresh_flag IN VARCHAR2
14035: ) IS
14051:
14052: END IF;
14053:
14054: FOR i IN (SELECT *
14055: FROM CZ_UI_PAGE_ELEMENTS
14056: WHERE ui_def_id = p_parent_ui_node.ui_def_id AND
14057: page_id=p_parent_ui_node.page_id AND
14058: parent_element_id=p_parent_ui_node.element_id AND
14059: deleted_flag IN (G_NO_FLAG,
14138: p_suppress_refresh_flag IN VARCHAR2
14139: ) IS
14140:
14141: l_current_ui_index NUMBER;
14142: l_current_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14143:
14144: BEGIN
14145:
14146:
14192:
14193: END delete_UI_Nodes;
14194:
14195: PROCEDURE exist_On_Split_Pages(p_current_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE, -->>>
14196: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
14197: px_page_split_seq_nbr OUT NOCOPY NUMBER,
14198: l_exist_on_split_pages_flag OUT NOCOPY VARCHAR2) IS
14199:
14200: l_page_persistent_node_id NUMBER;
14210:
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));
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
14251: l_page_id_tbl number_tbl_type;
14252: l_suppress_refresh_flag_tbl varchar_tbl_type;
14253:
14254: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14255: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14256: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14257: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14258: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14259: l_seq_nbr NUMBER;
14252: l_suppress_refresh_flag_tbl varchar_tbl_type;
14253:
14254: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14255: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14256: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14257: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14258: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14259: l_seq_nbr NUMBER;
14260: l_max_split_nbr NUMBER;
14253:
14254: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14255: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14256: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14257: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14258: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14259: l_seq_nbr NUMBER;
14260: l_max_split_nbr NUMBER;
14261: l_page_split_seq_nbr NUMBER;
14402: -- handle next level of UI tree ( recursion )
14403: --
14404: SELECT element_id, page_id, suppress_refresh_flag
14405: BULK COLLECT INTO l_element_id_tbl, l_page_id_tbl, l_suppress_refresh_flag_tbl
14406: FROM CZ_UI_PAGE_ELEMENTS
14407: WHERE ui_def_id = g_UI_Context.ui_def_id AND
14408: page_id=p_page_id AND
14409: parent_element_id = l_ui_node.element_id AND
14410: deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
14453: RETURN BOOLEAN IS
14454: l_flag VARCHAR2(1);
14455: BEGIN
14456: SELECT G_YES_FLAG INTO l_flag
14457: FROM CZ_UI_PAGE_ELEMENTS
14458: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14459: page_id=p_page_id AND
14460: parent_element_id IS NOT NULL AND
14461: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE) AND
14612: l_user_attribute4_value VARCHAR2(2000);
14613: l_user_attribute1_value VARCHAR2(2000);
14614: l_layout_region_type VARCHAR2(255);
14615: l_id_pair expl_node_persistent_id_pair;
14616: l_element_with_AMN CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
14617:
14618: BEGIN
14619:
14620: l_node := p_xml_node;
14634: END IF;
14635:
14636: SELECT persistent_node_id, model_ref_expl_id
14637: INTO l_id_pair.persistent_node_id, l_id_pair.expl_node_id
14638: FROM cz_ui_page_elements
14639: WHERE ui_def_Id = p_ui_def_id
14640: AND page_Id = p_page_id
14641: AND element_Id = l_element_with_AMN;
14642:
14653:
14654: -- Finds an Instance List enclosing the xml node passed in and returns its AMN
14655: -- This function does not check the node passed in itself. It starts checking from
14656: -- its parent
14657: FUNCTION getEnclosingInstanceListAMN(p_ui_element CZ_UI_PAGE_ELEMENTS%ROWTYPE,
14658: p_xml_node xmldom.DOMNode) RETURN expl_node_persistent_id_pair
14659: IS
14660:
14661: l_node xmldom.DOMNode;
14662: l_user_attribute4_value VARCHAR2(2000);
14663: l_user_attribute1_value VARCHAR2(2000);
14664: l_layout_region_type VARCHAR2(255);
14665: l_id_pair expl_node_persistent_id_pair;
14666: l_element_with_AMN CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
14667:
14668: BEGIN
14669:
14670: l_node := xmldom.getParentNode(p_xml_node);
14689:
14690: l_xml_doc := l_null_xml_doc;
14691:
14692: FOR k IN(SELECT *
14693: FROM CZ_UI_PAGE_ELEMENTS
14694: WHERE ui_def_id=g_UI_Context.ui_def_id AND
14695: page_id=i.page_id AND
14696: deleted_flag NOT IN(G_LIMBO_FLAG,G_MARK_TO_DELETE,G_YES_FLAG))
14697: LOOP
14736: --
14737: PROCEDURE get_parent_ui_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14738: p_ord_siblings IN model_nodes_tbl_type,
14739: p_ps_node_index IN NUMBER,
14740: x_parent_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE,
14741: x_insert_index OUT NOCOPY NUMBER,
14742: x_refresh_enabled_parent_found OUT NOCOPY BOOLEAN,
14743: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14744:
14746: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14747: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14748: l_pred_persistent_node_id NUMBER := NULL;
14749: l_succ_persistent_node_id NUMBER := NULL;
14750: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14751: l_parent_element_id NUMBER;
14752: l_page_id NUMBER;
14753: l_added BOOLEAN;
14754:
14783: -- contain the predecessor and successor of this node.
14784:
14785: IF l_pred_persistent_node_id IS NOT NULL AND l_succ_persistent_node_id IS NOT NULL THEN
14786: FOR i IN (SELECT *
14787: FROM CZ_UI_PAGE_ELEMENTS pe1
14788: WHERE ui_def_Id = g_UI_Context.ui_def_id
14789: AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
14790: AND persistent_node_id = l_pred_persistent_node_id
14791: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14790: AND persistent_node_id = l_pred_persistent_node_id
14791: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14792: AND parent_element_id IS NOT NULL
14793: AND EXISTS ( SELECT 1
14794: FROM CZ_UI_PAGE_ELEMENTS pe2
14795: WHERE ui_def_Id = g_UI_Context.ui_def_id
14796: AND pe2.page_id = pe1.page_id
14797: AND pe2.parent_element_id = pe1.parent_element_id
14798: AND pe2.persistent_node_id = l_succ_persistent_node_id
14817:
14818:
14819: IF l_pred_persistent_node_id IS NOT NULL AND NOT x_refresh_enabled_parent_found THEN
14820: FOR i IN (SELECT *
14821: FROM CZ_UI_PAGE_ELEMENTS pe1
14822: WHERE ui_def_Id = g_UI_Context.ui_def_id
14823: AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
14824: AND persistent_node_id = l_pred_persistent_node_id
14825: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14842:
14843: IF l_succ_persistent_node_id IS NOT NULL AND NOT x_refresh_enabled_parent_found THEN
14844:
14845: FOR i IN (SELECT *
14846: FROM CZ_UI_PAGE_ELEMENTS pe1
14847: WHERE ui_def_Id = g_UI_Context.ui_def_id
14848: AND region_persistent_node_id = l_parent_ps_node.persistent_node_id
14849: AND persistent_node_id = l_succ_persistent_node_id
14850: AND deleted_flag = G_NO_FLAG
14871: l_parent_element_id := NULL;
14872: l_page_id := NULL;
14873:
14874: FOR i IN (SELECT parent_element_id, page_id, count(parent_element_id) max_count
14875: FROM CZ_UI_PAGE_ELEMENTS pe
14876: WHERE ui_def_Id = g_UI_Context.ui_def_id
14877: AND parent_persistent_node_id = l_parent_ps_node.persistent_node_id
14878: AND pagebase_persistent_node_id <> persistent_node_id
14879: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH)
14903:
14904: IF NOT x_refresh_enabled_parent_found THEN
14905:
14906: FOR j IN (SELECT *
14907: FROM CZ_UI_PAGE_ELEMENTS
14908: WHERE ui_def_id = g_UI_Context.ui_def_id AND
14909: persistent_node_Id = l_parent_ps_node.persistent_node_id AND
14910: deleted_flag IN(G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH) AND
14911: element_type IN(G_UI_PAGE_NODE_TYPE,G_UI_REGION_NODE_TYPE))
14929:
14930: PROCEDURE add_ui_for_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14931: p_ord_siblings IN model_nodes_tbl_type,
14932: p_ps_node_index IN NUMBER DEFAULT NULL,
14933: x_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
14934:
14935: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14936: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14937: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14932: p_ps_node_index IN NUMBER DEFAULT NULL,
14933: x_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
14934:
14935: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14936: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14937: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14938: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14939: l_insert_index NUMBER;
14940: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14933: x_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
14934:
14935: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14936: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14937: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14938: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14939: l_insert_index NUMBER;
14940: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14941: l_parent_node_found BOOLEAN;
14936: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14937: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14938: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14939: l_insert_index NUMBER;
14940: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
14941: l_parent_node_found BOOLEAN;
14942: l_atleast_one_parent_found BOOLEAN;
14943: l_nodes_tbl model_nodes_tbl_type;
14944: l_seq_nodes_tbl ui_page_el_int_tbl_type; -- fix for bug 6837809 : skudryav 28-Mar-2008
15015:
15016: l_new_parent_persistent_id NUMBER;
15017: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15018:
15019: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15020: l_insert_index NUMBER;
15021: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15022: l_parent_node_found BOOLEAN;
15023:
15017: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15018:
15019: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15020: l_insert_index NUMBER;
15021: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15022: l_parent_node_found BOOLEAN;
15023:
15024: BEGIN
15025:
15027:
15028: --DEBUG('asp:Deleting UI for ps node ' || p_ps_node.name);
15029:
15030: FOR i IN (SELECT *
15031: FROM CZ_UI_PAGE_ELEMENTS pe
15032: WHERE ui_def_Id = g_UI_Context.ui_def_id
15033: AND persistent_node_id = p_ps_node.persistent_node_id
15034: AND deleted_flag = G_NO_FLAG)
15035: LOOP
15073:
15074: l_new_parent_persistent_id NUMBER;
15075: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15076:
15077: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15078: l_insert_index NUMBER;
15079: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15080: l_parent_node_found BOOLEAN;
15081: l_diff NUMBER;
15075: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15076:
15077: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15078: l_insert_index NUMBER;
15079: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15080: l_parent_node_found BOOLEAN;
15081: l_diff NUMBER;
15082: l_max_prev_seq_nbr NUMBER;
15083: l_max_src_seq_nbr NUMBER;
15115:
15116: END IF;
15117:
15118: FOR i IN (SELECT *
15119: FROM CZ_UI_PAGE_ELEMENTS pe
15120: WHERE ui_def_Id = g_UI_Context.ui_def_id
15121: AND persistent_node_id = p_ps_node.persistent_node_id
15122: AND region_persistent_node_id <> l_parent_ps_node.persistent_node_id
15123: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_DELETE))
15174:
15175: IF l_insert_index > 0 THEN
15176: l_max_prev_seq_nbr := l_insert_index-1;
15177: ELSE
15178: SELECT NVL(MAX(seq_nbr),0) INTO l_max_prev_seq_nbr FROM CZ_UI_PAGE_ELEMENTS
15179: START WITH ui_def_id=g_UI_Context.ui_def_id AND
15180: page_id=l_parent_ui_node.page_id AND
15181: element_id=l_parent_ui_node.element_id AND
15182: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG)
15188:
15189: l_insert_index := l_max_prev_seq_nbr + 1;
15190: END IF;
15191:
15192: SELECT NVL(MAX(seq_nbr),0), NVL(COUNT(seq_nbr), 0) INTO l_max_src_seq_nbr, l_count FROM CZ_UI_PAGE_ELEMENTS
15193: START WITH ui_def_id=g_UI_Context.ui_def_id AND
15194: page_id=i.page_id AND
15195: element_id=i.element_id AND
15196: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG)
15202:
15203: l_src_range := l_max_src_seq_nbr - i.seq_nbr + 1;
15204:
15205: -- move the elements after the insert point by adding the range value computed above
15206: UPDATE CZ_UI_PAGE_ELEMENTS
15207: SET seq_nbr=seq_nbr+l_src_range
15208: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15209: page_id=l_parent_ui_node.page_id AND
15210: seq_nbr>l_max_prev_seq_nbr AND
15211: deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG);
15212:
15213: l_diff := l_insert_index - i.seq_nbr;
15214:
15215: UPDATE CZ_UI_PAGE_ELEMENTS
15216: SET seq_nbr=seq_nbr + l_diff,
15217: page_id=l_parent_ui_node.page_id,
15218: pagebase_persistent_node_id=l_parent_ui_node.pagebase_persistent_node_id,
15219: deleted_flag=DECODE(deleted_flag, G_MARK_TO_DELETE, G_NO_FLAG, deleted_flag)
15223: seq_nbr <= l_max_src_seq_nbr AND
15224: deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);
15225:
15226: IF i.deleted_flag <> G_MARK_TO_DELETE THEN
15227: UPDATE CZ_UI_PAGE_ELEMENTS
15228: SET seq_nbr=seq_nbr - l_count
15229: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15230: page_id=i.page_id AND
15231: seq_nbr > l_max_src_seq_nbr AND
15231: seq_nbr > l_max_src_seq_nbr AND
15232: deleted_flag NOT IN(G_YES_FLAG, G_LIMBO_FLAG);
15233: END IF;
15234:
15235: UPDATE CZ_UI_PAGE_ELEMENTS
15236: SET parent_element_id = l_parent_ui_node.element_id,
15237: parent_persistent_node_id = l_parent_ps_node.persistent_node_id,
15238: region_persistent_node_id = l_parent_ui_node.persistent_node_id,
15239: deleted_flag = G_MARK_TO_MOVE
15279: -- So we have to disassociate this UI controls from the PS Node
15280:
15281: DEBUG('asp: Cannot move UI for ' || p_ps_node.name || '. Disassociating from PS Node');
15282:
15283: UPDATE CZ_UI_PAGE_ELEMENTS
15284: SET deleted_flag = G_MARK_TO_DEASSOCIATE,
15285: persistent_node_id = 0
15286: WHERE ui_def_id = i.ui_def_id
15287: AND page_id = i.page_id
15285: persistent_node_id = 0
15286: WHERE ui_def_id = i.ui_def_id
15287: AND page_id = i.page_id
15288: AND element_id IN
15289: (SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
15290: START WITH ui_def_id=i.ui_def_id
15291: AND page_id=i.page_id
15292: AND element_id=i.element_id
15293: CONNECT BY PRIOR ui_def_id=i.ui_def_id AND
15300: -- refresh might be enough.
15301:
15302: DEBUG('asp: Cannot move UI for ' || p_ps_node.name || '. Marking it for refresh');
15303:
15304: UPDATE CZ_UI_PAGE_ELEMENTS
15305: SET deleted_flag = G_MARK_TO_REFRESH
15306: WHERE ui_def_id = i.ui_def_id
15307: AND page_id = i.page_id
15308: AND element_id = i.element_id
15318:
15319: PROCEDURE propogate_ps_node_type_changes(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
15320: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR) IS
15321:
15322: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15323: l_model_ref_expl_id NUMBER;
15324:
15325: BEGIN
15326:
15330: p_ps_node_id => p_ps_node.ps_node_id,
15331: p_component_id => p_ps_node.component_id,
15332: p_ps_node_type => p_ps_node.ps_node_type);
15333: FOR i IN (SELECT *
15334: FROM CZ_UI_PAGE_ELEMENTS pe
15335: WHERE ui_def_Id = g_UI_Context.ui_def_id
15336: AND persistent_node_id = p_ps_node.persistent_node_id
15337: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_MOVE))
15338: LOOP
15358:
15359:
15360: FUNCTION ui_node_exits(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) RETURN BOOLEAN IS
15361:
15362: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15363:
15364: BEGIN
15365:
15366: SELECT element_id into l_element_id FROM CZ_UI_PAGE_ELEMENTS
15362: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15363:
15364: BEGIN
15365:
15366: SELECT element_id into l_element_id FROM CZ_UI_PAGE_ELEMENTS
15367: WHERE ui_def_id=g_UI_Context.ui_def_id
15368: AND persistent_node_id=p_ps_node.persistent_node_id
15369: AND deleted_flag=G_NO_FLAG and rownum < 2;
15370: -- need to return the element_id instead
15473: p_component_id => p_ps_node.component_id,
15474: p_ps_node_type => p_ps_node.ps_node_type);
15475:
15476: FOR i in (SELECT *
15477: FROM CZ_UI_PAGE_ELEMENTS
15478: WHERE ui_def_id = g_UI_Context.ui_def_id
15479: AND persistent_node_id = p_ps_node.persistent_node_id
15480: AND deleted_flag NOT IN (G_YES_FLAG, G_LIMBO_FLAG))
15481: LOOP
15512: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15513: l_nodes_tbl model_nodes_tbl_type;
15514: l_seq_nodes_tbl ui_page_el_int_tbl_type; -- fix for bug 6837809 : skudryav 28-Mar-2008
15515: l_non_del_child_nodes_tbl model_nodes_tbl_type;
15516: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15517:
15518: l_timestamp_add DATE;
15519: l_timestamp_remove DATE;
15520: l_add_remove_flag VARCHAR2(1);
15524: l_model_ref_expl_changed1 VARCHAR2(1) := 'U';
15525: l_model_ref_expl_changed2 VARCHAR2(1) := 'U';
15526: l_check_for_bom_table BOOLEAN;
15527:
15528: l_bom_table_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15529: l_page_id NUMBER;
15530:
15531: l_bom_parent_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15532: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15527:
15528: l_bom_table_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15529: l_page_id NUMBER;
15530:
15531: l_bom_parent_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15532: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15533:
15534: BEGIN
15535:
15528: l_bom_table_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15529: l_page_id NUMBER;
15530:
15531: l_bom_parent_element CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15532: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
15533:
15534: BEGIN
15535:
15536: l_added_ui := FALSE;
15643: l_check_for_bom_table := TRUE;
15644:
15645: BEGIN
15646: SELECT element_id, page_Id INTO l_bom_table_id, l_page_id
15647: FROM cz_ui_page_elements
15648: WHERE ui_def_Id = g_UI_Context.ui_def_id
15649: AND persistent_node_id = p_ps_node.persistent_node_id
15650: AND deleted_flag IN (G_NO_FLAG, G_MARK_TO_REFRESH)
15651: AND element_type = G_UI_BOMADDINST_NODE_TYPE
15679: -- mark the flag so that we dont do the same for other children
15680: l_check_for_bom_table := FALSE;
15681:
15682: IF NOT(contains_BOM_Nodes(p_ps_node.ps_node_id)) THEN
15683: UPDATE CZ_UI_PAGE_ELEMENTS
15684: SET deleted_flag=G_MARK_TO_DELETE
15685: WHERE ui_def_id=g_UI_Context.ui_def_id
15686: AND page_id = l_page_id
15687: AND element_Id = l_bom_table_id;
15702: persistent_node_id = p_ps_node.persistent_node_id)
15703: LOOP
15704: SELECT element_id, suppress_refresh_flag
15705: INTO l_bom_parent_element, l_suppress_refresh_flag
15706: FROM CZ_UI_PAGE_ELEMENTS
15707: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=m.page_id AND
15708: parent_element_id IS NULL AND persistent_node_id=p_ps_node.persistent_node_id AND
15709: pagebase_persistent_node_id=region_persistent_node_id AND
15710: pagebase_persistent_node_id=p_ps_node.persistent_node_id AND
15784: l_xml_doc xmldom.DOMDocument;
15785: l_xml_node xmldom.DOMNode;
15786: l_null_xml_doc xmldom.DOMDocument;
15787: l_instance_list_amn expl_node_persistent_id_pair;
15788: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15789:
15790: BEGIN
15791:
15792: FOR t IN (SELECT ps_node_id,persistent_node_id as psnode_persistent_node_id,ps_node_type,component_id
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)
15813: a.page_id=b.page_id AND
15814: b.persistent_node_id = t.psnode_persistent_node_id)
15815: LOOP
15816:
15817: UPDATE CZ_UI_PAGE_ELEMENTS
15818: SET model_ref_expl_id=l_expl_id
15819: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15820: page_id=upgel.page_id AND
15821: persistent_node_id=t.psnode_persistent_node_id AND
15865: END IF;
15866:
15867: l_xml_node := find_XML_Node_By_Attribute(l_xml_doc, G_ID_ATTRIBUTE, upgel.element_id);
15868:
15869: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
15870: WHERE ui_def_id=g_UI_Context.ui_def_id AND
15871: page_id=upgel.page_id AND
15872: element_id=upgel.element_id;
15873:
15909: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15910: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15911: ps_node_type IN(258,259,436,437) AND
15912: deleted_flag=G_YES_FLAG AND EXISTS(SELECT NULL
15913: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15914: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15915: LOOP
15916: UPDATE CZ_PS_NODES
15917: SET deleted_flag=G_YES_FLAG
15924: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES a
15925: WHERE devl_project_id=g_UI_Context.devl_project_id AND
15926: ps_node_type IN(258,259,436,437) AND ui_omit=G_YES_FLAG AND
15927: deleted_flag=G_NO_FLAG AND EXISTS(SELECT NULL
15928: FROM CZ_UI_PAGE_ELEMENTS WHERE ui_def_id=g_UI_Context.ui_def_id AND
15929: persistent_node_id=a.persistent_node_id AND deleted_flag=G_NO_FLAG))
15930: LOOP
15931: UPDATE CZ_PS_NODES
15932: SET deleted_flag=G_YES_FLAG
15945:
15946: IF l_ui_timestamp_refresh IS NULL THEN
15947:
15948: FOR i IN (SELECT ui_def_id, element_id,page_id, suppress_refresh_flag
15949: FROM CZ_UI_PAGE_ELEMENTS
15950: WHERE ui_def_id = g_UI_Context.ui_def_id AND
15951: parent_element_id IS NULL AND
15952: deleted_flag IN (G_NO_FLAG, G_MARK_TO_ADD, G_MARK_TO_REFRESH))
15953: LOOP
16035:
16036: BEGIN
16037:
16038: backup_nodes_to_move(p_page_id);
16039: FOR i IN(SELECT element_id,deleted_flag FROM CZ_UI_PAGE_ELEMENTS
16040: WHERE ui_def_id= g_UI_Context.ui_def_id AND
16041: page_id=p_page_id AND
16042: deleted_flag IN(G_MARK_TO_DELETE,G_MARK_TO_DEASSOCIATE))
16043: LOOP
16092: p_hmode => G_DELETE_ELEMENTS);
16093: END IF;
16094:
16095: IF l_deassociated_nodes_exist THEN
16096: UPDATE CZ_UI_PAGE_ELEMENTS
16097: SET deleted_flag=G_NO_FLAG
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;
16138: p_token_value => p_jrad_doc,
16139: p_fatal_error => TRUE);
16140: RAISE WRONG_UI_TEMPLATE;
16141: ELSE
16142: UPDATE CZ_UI_PAGE_ELEMENTS
16143: SET deleted_flag=G_MARK_TO_DELETE
16144: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16145: page_id=p_page_id AND
16146: deleted_flag NOT IN(G_MARK_TO_DELETE,G_YES_FLAG);
16192: l_suppress_refresh_tbl varchar_tbl_type;
16193: l_suppress_el_flag_tbl varchar_tbl_type;
16194: l_delete_node BOOLEAN := FALSE;
16195: l_deassociate_cx BOOLEAN := FALSE;
16196: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
16197:
16198: BEGIN
16199: FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
16200: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16195: l_deassociate_cx BOOLEAN := FALSE;
16196: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
16197:
16198: BEGIN
16199: FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
16200: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16201: page_id=p_ui_page_id AND
16202: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
16203: deleted_flag IN(G_NO_FLAG, G_MARK_TO_REFRESH))
16209: l_suppress_refresh_flag := G_NO_FLAG;
16210: IF i.parent_element_id IS NOT NULL THEN
16211: BEGIN
16212: SELECT NVL(suppress_refresh_flag,G_NO_FLAG) INTO l_suppress_refresh_flag
16213: FROM CZ_UI_PAGE_ELEMENTS
16214: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16215: page_id=p_ui_page_id AND
16216: element_id=i.parent_element_id;
16217: END;
16267: IF l_deassociate_cx THEN
16268: set_Attribute(l_node, G_USER_ATTRIBUTE1_NAME, 'model_path=*');
16269: set_Attribute(l_node, G_USER_ATTRIBUTE2_NAME, '0');
16270:
16271: UPDATE CZ_UI_PAGE_ELEMENTS
16272: SET persistent_node_id=0
16273: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16274: page_id=p_ui_page_id AND
16275: element_id=l_attribute_value;
16275: element_id=l_attribute_value;
16276: ELSE
16277: l_parent_node:=xmldom.getParentNode(l_node);
16278: l_out_node:=xmldom.removeChild(l_parent_node,l_node);
16279: UPDATE CZ_UI_PAGE_ELEMENTS
16280: SET deleted_flag=G_YES_FLAG
16281: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16282: page_id=p_ui_page_id AND
16283: element_id=l_attribute_value;
16340: l_subtree_doc xmldom.DOMDocument;
16341: l_xml_root_node xmldom.DOMNode;
16342: l_xml_uicontent_node xmldom.DOMNode;
16343: l_xml_node_to_refresh xmldom.DOMNode;
16344: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
16345: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
16346: l_col_number NUMBER := 0;
16347:
16348: PROCEDURE create_Next_XML_Level(p_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
16344: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
16345: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
16346: l_col_number NUMBER := 0;
16347:
16348: PROCEDURE create_Next_XML_Level(p_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
16349: p_parent_xml_node xmldom.DOMNode) IS
16350:
16351: l_new_xml_node xmldom.DOMNode;
16352: l_new_opt_xml_node xmldom.DOMNode;
16358: --
16359: -- get child UI nodes
16360: --
16361: FOR i IN (SELECT *
16362: FROM CZ_UI_PAGE_ELEMENTS a
16363: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16364: page_id = p_page_id AND
16365: parent_element_id = p_ui_node.element_id
16366: -- parent_persistent_node_id = p_ui_node.persistent_node_id
16435: END LOOP;
16436:
16437: END create_Next_XML_Level;
16438:
16439: PROCEDURE refresh_UI_Node(p_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
16440: p_xml_parent_node xmldom.DOMNode) IS
16441:
16442: l_xml_node_to_replace xmldom.DOMNode;
16443: l_new_xml_node xmldom.DOMNode;
16443: l_new_xml_node xmldom.DOMNode;
16444:
16445: BEGIN
16446:
16447: FOR i IN(SELECT * FROM CZ_UI_PAGE_ELEMENTS
16448: WHERE ui_def_id=p_page_ui_node.ui_def_id
16449: AND parent_element_id=p_page_ui_node.element_id
16450: AND persistent_node_id=p_page_ui_node.persistent_node_id
16451: AND (element_type IS NULL OR element_type <> G_UI_CX_BUTTON_NODE_TYPE)
16486: g_dom_elements_tbl.DELETE;
16487:
16488: SELECT *
16489: INTO l_page_ui_node
16490: FROM CZ_UI_PAGE_ELEMENTS
16491: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16492: page_id = p_page_id AND
16493: parent_element_id IS NULL AND
16494: -- element_type=G_UI_PAGE_NODE_TYPE AND
16594:
16595: l_subtree_doc xmldom.DOMDocument;
16596: l_xml_root_node xmldom.DOMNode;
16597: l_xml_uicontent_node xmldom.DOMNode;
16598: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
16599: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
16600: l_sub_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16601: l_curr_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16602: l_child_nodes_tbl xmldom.DOMNodeList;
16596: l_xml_root_node xmldom.DOMNode;
16597: l_xml_uicontent_node xmldom.DOMNode;
16598: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
16599: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
16600: l_sub_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16601: l_curr_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16602: l_child_nodes_tbl xmldom.DOMNodeList;
16603: l_xml_node xmldom.DOMNode;
16604: l_length NUMBER;
16597: l_xml_uicontent_node xmldom.DOMNode;
16598: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
16599: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
16600: l_sub_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16601: l_curr_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
16602: l_child_nodes_tbl xmldom.DOMNodeList;
16603: l_xml_node xmldom.DOMNode;
16604: l_length NUMBER;
16605: l_col_number NUMBER;
16612: --
16613: -- get child UI nodes
16614: --
16615: FOR i IN (SELECT *
16616: FROM CZ_UI_PAGE_ELEMENTS
16617: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16618: page_id = p_page_id AND
16619: parent_element_id = p_element_id AND
16620: ctrl_template_id IS NOT NULL AND
16704: END IF;
16705:
16706: SELECT *
16707: INTO l_page_ui_node
16708: FROM CZ_UI_PAGE_ELEMENTS
16709: WHERE ui_def_id = g_UI_Context.ui_def_id AND
16710: page_id = p_page_id AND
16711: persistent_node_id = pagebase_persistent_node_id AND
16712: parent_element_id IS NULL AND
16806: BEGIN
16807:
16808: IF g_UI_Context.control_layout IN(1,2) THEN
16809: SELECT COUNT(element_id) INTO g_Num_Elements_On_Page
16810: FROM CZ_UI_PAGE_ELEMENTS
16811: WHERE ui_def_id=g_UI_Context.ui_def_id AND
16812: page_id=p_page_id AND
16813: (element_type IS NULL OR ctrl_template_id IS NOT NULL) AND
16814: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
16866: handle_JRAD_Page(p_page_id => i.page_id,
16867: p_page_jrad_doc => i.jrad_doc,
16868: p_page_status => i.deleted_flag);
16869: ELSE
16870: FOR n IN(SELECT G_YES_FLAG FROM CZ_UI_PAGE_ELEMENTS
16871: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_id=i.page_id AND
16872: element_type=G_UI_CX_BUTTON_NODE_TYPE AND
16873: deleted_flag=G_NO_FLAG AND rownum<2)
16874: LOOP
16959: ,p_page_id IN NUMBER
16960: ,p_element_id IN VARCHAR2)
16961: IS
16962: BEGIN
16963: UPDATE CZ_UI_PAGE_ELEMENTS
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:
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
16973: PROCEDURE handle_page_include_region(p_element CZ_UI_PAGE_ELEMENTS%ROWTYPE,
16974: p_base_persistent_node_Id NUMBER,
16975: p_base_expl_Id NUMBER)
16976: IS
16977:
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
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
17180: target_page_ui_def_id IS NOT NULL AND
17181: target_page_id IS NOT NULL AND deleted_flag='0'))
17183: EXIT WHEN l_flag = 0;
17184: l_xmldoc := parse_JRAD_Document(i.jrad_doc);
17185: l_resave_doc_flag := 0;
17186:
17187: FOR j IN (SELECT * FROM CZ_UI_PAGE_ELEMENTS
17188: WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id AND
17189: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
17190: deleted_flag='0')
17191: LOOP
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:
17595: AND page_set_id = pageSets.page_set_id
17596: AND ui_def_id = uiDefCur.ref_ui_def_id;
17597: END LOOP; --pageRefs
17598:
17599: -- Verify for cz_ui_page_elements.model_ref_expl_id
17600: FOR uiPges IN (SELECT element_id,model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS pge
17601: WHERE pge.deleted_flag = G_NO_FLAG AND pge.ui_def_id = uiDefCur.ref_ui_def_id
17602: AND pge.model_ref_expl_id IS NOT NULL
17603: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17596: AND ui_def_id = uiDefCur.ref_ui_def_id;
17597: END LOOP; --pageRefs
17598:
17599: -- Verify for cz_ui_page_elements.model_ref_expl_id
17600: FOR uiPges IN (SELECT element_id,model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS pge
17601: WHERE pge.deleted_flag = G_NO_FLAG AND pge.ui_def_id = uiDefCur.ref_ui_def_id
17602: AND pge.model_ref_expl_id IS NOT NULL
17603: AND NOT EXISTS (SELECT 1 FROM CZ_MODEL_REF_EXPLS
17604: WHERE deleted_flag = G_NO_FLAG AND model_ref_expl_id = pge.model_ref_expl_id
17605: )
17606: )
17607: LOOP
17608:
17609: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_ELEMENTS where model_ref_expl_id : ' || uiPges.model_ref_expl_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17610:
17611: UPDATE CZ_UI_PAGE_ELEMENTS
17612: SET deleted_flag = G_YES_FLAG
17613: WHERE model_ref_expl_id = uiPges.model_ref_expl_id
17607: LOOP
17608:
17609: log_message( 'UI_REFRESH' , 'UPDATE deleted_flag of CZ_UI_PAGE_ELEMENTS where model_ref_expl_id : ' || uiPges.model_ref_expl_id || ' and ui_def_id : '|| uiDefCur.ref_ui_def_id);
17610:
17611: UPDATE CZ_UI_PAGE_ELEMENTS
17612: SET deleted_flag = G_YES_FLAG
17613: WHERE model_ref_expl_id = uiPges.model_ref_expl_id
17614: AND element_id = uiPges.element_id
17615: AND ui_def_id = uiDefCur.ref_ui_def_id;
17828: l_user_attribute_value VARCHAR2(4000);
17829: l_new_element_id VARCHAR2(255);
17830: l_target_model_path VARCHAR2(4000);
17831: l_name VARCHAR2(4000);
17832: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
17833: l_model_ref_expl_id NUMBER;
17834: l_num_copy NUMBER;
17835: l_id NUMBER;
17836:
17867: l_user_attribute_value := get_Attribute_Value(p_xml_node, G_USER_ATTRIBUTE1_NAME);
17868:
17869: IF l_user_attribute_value IS NOT NULL AND l_new_element_id IS NOT NULL THEN
17870:
17871: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
17872: WHERE ui_def_id=p_target_ui_def_id AND
17873: page_id=p_target_ui_page_id AND
17874: element_id=l_new_element_id;
17875: SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS
17871: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
17872: WHERE ui_def_id=p_target_ui_def_id AND
17873: page_id=p_target_ui_page_id AND
17874: element_id=l_new_element_id;
17875: SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_UI_PAGE_ELEMENTS
17876: WHERE ui_def_id=l_ui_node.ui_def_id AND page_id=l_ui_node.page_id AND
17877: parent_element_id IS NULL AND deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
17878: l_target_model_path := CZ_DEVELOPER_UTILS_PVT.runtime_relative_path(p_base_expl_id => l_model_ref_expl_id,
17879: p_base_pers_id => l_ui_node.pagebase_persistent_node_id,
17912: IF l_user_attribute_value IS NOT NULL THEN
17913:
17914: l_name := get_User_Attribute(l_user_attribute_value ,'name');
17915:
17916: SELECT COUNT(*)+1 INTO l_num_copy FROM CZ_UI_PAGE_ELEMENTS
17917: WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
17918: name like l_name||'%' AND deleted_flag=G_NO_FLAG;
17919:
17920: l_name := l_name||' ('||TO_CHAR(l_num_copy)||')';
17928: l_user_attribute_value);
17929: END IF;
17930:
17931: IF l_new_element_id IS NOT NULL THEN
17932: UPDATE CZ_UI_PAGE_ELEMENTS
17933: SET name=l_name
17934: WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
17935: element_id = l_new_element_id;
17936: END IF;
18119: l_target_persistent_node_id NUMBER;
18120:
18121: BEGIN
18122:
18123: UPDATE CZ_UI_PAGE_ELEMENTS
18124: SET target_page_ui_def_id=NULL,
18125: target_page_id=NULL
18126: WHERE ui_def_id=p_ui_def_id AND
18127: page_id=p_page_id AND
18154: -- Find all Page Include Regions of current UI
18155: --
18156: FOR i IN (SELECT page_id, element_id, target_page_ui_def_id, target_page_id,
18157: model_ref_expl_id, persistent_node_id, name
18158: FROM CZ_UI_PAGE_ELEMENTS
18159: WHERE ui_def_id = p_ui_def_id AND page_id=p_page_id AND
18160: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
18161: target_page_ui_def_id IS NOT NULL AND target_page_id IS NOT NULL AND
18162: deleted_flag = '0')
18171: EXCEPTION
18172: -- target page not exist
18173: WHEN NO_DATA_FOUND THEN
18174: -- l_target_persistent_node_id := NULL;
18175: UPDATE CZ_UI_PAGE_ELEMENTS
18176: SET target_page_ui_def_id = NULL, target_page_id = NULL
18177: WHERE ui_def_id = p_ui_def_id AND
18178: page_id = i.page_id AND element_id = i.element_id;
18179:
18207: p_token_value1 => NVL(i.NAME, i.element_id),
18208: p_token_name2 => 'PAGE_NAME',
18209: p_token_value2 => get_page_name(p_ui_def_id,i.page_id),
18210: p_fatal_error => FALSE);
18211: UPDATE CZ_UI_PAGE_ELEMENTS
18212: SET target_page_ui_def_id = NULL, target_page_id = NULL
18213: WHERE ui_def_id = p_ui_def_id AND
18214: page_id = i.page_id AND element_id = i.element_id;
18215: END IF;
18237:
18238: l_child_nodes_tbl xmldom.DOMNodeList;
18239: l_child_xml_node xmldom.DOMNode;
18240: l_parent_xml_node xmldom.DOMNode;
18241: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
18242:
18243: l_user_attribute_value VARCHAR2(4000);
18244: l_user_attribute3_value VARCHAR2(4000);
18245:
18359: END IF;
18360:
18361: END IF;
18362:
18363: FOR i IN(SELECT parent_element_id FROM CZ_UI_PAGE_ELEMENTS
18364: WHERE ui_def_id=p_source_ui_def_id AND
18365: page_id=p_source_ui_page_id AND
18366: element_id=l_current_element_id)
18367: LOOP
18381: l_parent_element_id := p_parent_element_id;
18382: END IF;
18383:
18384: IF l_ui_page_elements_exists THEN
18385: INSERT INTO CZ_UI_PAGE_ELEMENTS
18386: (ui_def_id,
18387: persistent_node_id,
18388: parent_persistent_node_id,
18389: region_persistent_node_id,
18423: suppress_refresh_flag,
18424: deleted_flag,
18425: target_page_ui_def_id,
18426: target_page_id
18427: FROM CZ_UI_PAGE_ELEMENTS
18428: WHERE ui_def_id=p_source_ui_def_id AND
18429: page_id=p_source_ui_page_id AND
18430: element_id=l_current_element_id;
18431:
18482: -- will have correct paths
18483:
18484: SELECT persistent_node_id, model_ref_expl_id
18485: INTO l_amn_persistent_node_id, l_amn_expl_node_id
18486: FROM cz_ui_page_elements
18487: WHERE ui_Def_id = p_target_ui_def_id
18488: AND page_Id = p_target_ui_page_id
18489: AND element_id = l_amn_parent_element_id;
18490:
18525: l_user_attribute_value := get_Attribute_Value(p_xml_node, G_USER_ATTRIBUTE1_NAME);
18526:
18527: IF l_user_attribute_value IS NOT NULL AND l_ui_page_elements_exists THEN
18528:
18529: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
18530: WHERE ui_def_id=p_target_ui_def_id AND
18531: page_id=p_target_ui_page_id AND
18532: element_id=l_new_element_id;
18533:
18550:
18551: IF l_user_attribute_value IS NOT NULL THEN
18552:
18553: SELECT COUNT(element_id) INTO l_view_counter
18554: FROM CZ_UI_PAGE_ELEMENTS
18555: WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
18556: deleted_flag NOT IN(G_YES_FLAG,G_MARK_TO_DELETE);
18557:
18558: l_view_name := get_User_Attribute(l_user_attribute_value ,'nodeView');
18592: -- for computing paths for elements within this subtree
18593:
18594: SELECT persistent_node_id, model_ref_expl_id
18595: INTO l_base_persistent_node_id, l_base_expl_node_id
18596: FROM cz_ui_page_elements
18597: WHERE ui_Def_id = p_target_ui_Def_id
18598: AND page_Id = p_target_ui_page_id
18599: AND element_Id = l_amn_parent_element_id;
18600: END IF;
18600: END IF;
18601:
18602: l_name := get_User_Attribute(l_user_attribute_value ,'name');
18603:
18604: SELECT COUNT(*)+1 INTO l_num_copy FROM CZ_UI_PAGE_ELEMENTS
18605: WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
18606: name like l_name||'%' AND deleted_flag=G_NO_FLAG;
18607:
18608: l_name := l_name||' ('||TO_CHAR(l_num_copy)||')';
18616: l_user_attribute_value);
18617: END IF;
18618:
18619: IF l_new_element_id IS NOT NULL THEN
18620: UPDATE CZ_UI_PAGE_ELEMENTS
18621: SET name=l_name
18622: WHERE ui_def_id=p_target_ui_def_id AND page_id=p_target_ui_page_id AND
18623: element_id = l_new_element_id;
18624: END IF;
18710: DEBUG('copy_User_Attributes() : '||SQLERRM);
18711: END copy_User_Attributes;
18712:
18713: --
18714: -- This procedure sets/propogates deleted_flag='1' from a given UI element to its subtree in CZ_UI_PAGE_ELEMENTS table.
18715: -- Also the procedure parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18716: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18717: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.
18718: -- If parameter p_delete_xml = '1' then it also deletes a corresponding XML elements.
18730: l_element_id_tbl varchar_tbl_type;
18731: l_out_node xmldom.DOMNode;
18732: l_parent_node xmldom.DOMNode;
18733: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
18734: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
18735: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18736: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18737: l_ui_context CZ_UI_DEFS%ROWTYPE;
18738: l_condition_id NUMBER;
18756:
18757: --
18758: -- propogate deleted_flag in UI subtree
18759: --
18760: UPDATE CZ_UI_PAGE_ELEMENTS
18761: SET deleted_flag=G_LIMBO_FLAG
18762: WHERE (ui_def_id,page_id,element_id) IN
18763: (SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS
18764: START WITH ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND element_id=p_element_id
18759: --
18760: UPDATE CZ_UI_PAGE_ELEMENTS
18761: SET deleted_flag=G_LIMBO_FLAG
18762: WHERE (ui_def_id,page_id,element_id) IN
18763: (SELECT ui_def_id,page_id,element_id FROM CZ_UI_PAGE_ELEMENTS
18764: START WITH ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND element_id=p_element_id
18765: CONNECT BY PRIOR ui_def_id=p_ui_def_id AND
18766: PRIOR page_id=p_ui_page_id AND page_id=p_ui_page_id AND
18767: PRIOR element_id=parent_element_id AND
18775: END IF;
18776:
18777: SELECT parent_element_id
18778: INTO l_parent_element_id
18779: FROM CZ_UI_PAGE_ELEMENTS
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:
18945: x_msg_count OUT NOCOPY NUMBER, -- number of error messages
18946: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
18947: ) IS
18948:
18949: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
18950:
18951: BEGIN
18952:
18953: --
18957:
18958: --
18959: -- get element_id of root element of UI page
18960: --
18961: FOR i IN(SELECT element_id FROM CZ_UI_PAGE_ELEMENTS
18962: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
18963: parent_element_id IS NULL AND deleted_flag=G_NO_FLAG)
18964: LOOP
18965: --
18975: x_msg_data => x_msg_data);
18976: END LOOP;
18977:
18978: -- handle page include region
18979: UPDATE cz_ui_page_elements
18980: SET target_page_ui_def_id = NULL, target_page_id = NULL
18981: WHERE target_page_ui_def_id = p_ui_def_id AND target_page_id = p_ui_page_id AND
18982: deleted_flag = '0' AND element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;
18983: EXCEPTION
19337: l_stacklayout_node xmldom.DOMNode;
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;
19371:
19372:
19373: BEGIN
19374: SELECT element_id INTO l_amn_parent_element_id
19375: FROM CZ_UI_PAGE_ELEMENTS
19376: WHERE ui_def_id=p_target_ui_def_id AND
19377: page_id=p_target_ui_page_id AND
19378: element_id=p_target_parent_element_id;
19379: EXCEPTION
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;
19521: l_pagebase_persistent_node_id NUMBER;
19522: l_length NUMBER;
19523: l_caseid_to_copy BOOLEAN;
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;
19521: l_pagebase_persistent_node_id NUMBER;
19522: l_length NUMBER;
19523: l_caseid_to_copy BOOLEAN;
19524:
19679:
19680: BEGIN
19681:
19682: SELECT element_id INTO l_source_element_id
19683: FROM CZ_UI_PAGE_ELEMENTS
19684: WHERE ui_def_id=p_source_ui_def_id AND page_id=p_source_ui_page_id AND
19685: parent_element_id IS NULL AND deleted_flag=G_NO_FLAG;
19686:
19687: --
19879:
19880: set_Local_UI_Context(p_target_ui_def_id);
19881:
19882: SELECT element_id INTO l_source_element_id
19883: FROM CZ_UI_PAGE_ELEMENTS
19884: WHERE ui_def_id=p_source_ui_def_id AND page_id=p_source_ui_page_id AND
19885: parent_element_id IS NULL AND deleted_flag=G_NO_FLAG;
19886:
19887: --
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;
20658:
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;
21197: l_root_attr_names_tbl varchar_tbl_type;
21269: p_ui_page_id => p_ui_page_id);
21270:
21271: IF l_ui_node.persistent_node_id IS NULL OR l_ui_node.persistent_node_id=0 THEN
21272: l_ui_node.element_id := l_ui_node.parent_element_id;
21273: UPDATE CZ_UI_PAGE_ELEMENTS
21274: SET deleted_flag=G_YES_FLAG
21275: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id AND
21276: element_id=p_element_id;
21277: ELSE
21625: --
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
21637:
21638: BEGIN
21639:
21640: IF i.ui_page_element_id IS NOT NULL AND i.ui_page_element_id<>'0' THEN
21641: SELECT element_id INTO l_element_id FROM CZ_UI_PAGE_ELEMENTS
21642: WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
21643: element_id=i.ui_page_element_id AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
21644: ELSIF (i.ui_page_element_id IS NULL OR i.ui_page_element_id='0') AND
21645: (i.ui_page_id IS NOT NULL AND i.ui_page_id<>0) THEN
21642: WHERE ui_def_id=p_ui_def_id AND page_id=i.ui_page_id AND
21643: element_id=i.ui_page_element_id AND deleted_flag NOT IN(G_YES_FLAG,G_LIMBO_FLAG,G_MARK_TO_DELETE);
21644: ELSIF (i.ui_page_element_id IS NULL OR i.ui_page_element_id='0') AND
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);
21823: SELECT ref_ui_def_id INTO l_old_child_ui_def_id
21824: FROM cz_ui_refs
21825: WHERE ui_def_id = p_ui_def_id AND ref_persistent_node_id = p_ref_persistent_node_id;
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
21921: STATUS => l_status,
21922: INDUSTRY => l_industry,
21923: ORACLE_SCHEMA => l_oracle_schema);
21924:
21925: g_UINodeINCREMENT := get_Seq_Inc('CZ_UI_PAGE_ELEMENTS_S', l_oracle_schema);
21926: g_PageRefINCREMENT := get_Seq_Inc('CZ_UI_PAGE_REFS_S', l_oracle_schema);
21927: g_PageINCREMENT := get_Seq_Inc('CZ_UI_PAGES_S', l_oracle_schema);
21928: g_PageSetINCREMENT := get_Seq_Inc('CZ_UI_PAGE_SETS_S', l_oracle_schema);
21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);