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

APPS.CZ_UIOA_PVT dependencies on CZ_UITEMPLS_FOR_PSNODES_V

Line 277: TYPE ui_page_el_int_tbl_type IS TABLE OF CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE INDEX BY BINARY_INTEGER;

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:
279: TYPE ui_def_nodes_tbl_type IS TABLE OF CZ_UI_DEFS%ROWTYPE INDEX BY BINARY_INTEGER;
280: TYPE ui_page_sets_tbl_type IS TABLE OF CZ_UI_PAGE_SETS%ROWTYPE INDEX BY BINARY_INTEGER;
281: TYPE ui_pages_tbl_type IS TABLE OF CZ_UI_PAGES%ROWTYPE INDEX BY BINARY_INTEGER;

Line 659: FROM CZ_UITEMPLS_FOR_PSNODES_V

655: l_msg_data VARCHAR2(4000);
656: l_msg_index number;
657: BEGIN
658: FOR i IN(SELECT DISTINCT template_id, detailed_type_id
659: FROM CZ_UITEMPLS_FOR_PSNODES_V
660: WHERE devl_project_id=p_model_id AND
661: ui_def_id=p_ui_def_id AND
662: template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
663: deleted_flag = G_NO_FLAG)

Line 1312: FUNCTION get_View_Name(p_ui_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

1308:
1309: --
1310: -- return name of node type
1311: --
1312: FUNCTION get_View_Name(p_ui_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
1313: x_has_children OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1314: l_view_name VARCHAR2(255);
1315: BEGIN
1316: x_has_children := G_NO_FLAG;

Line 1547: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS

1543: -- Parameters :
1544: -- p_ps_node_id - identifies node in Model tree
1545: --
1546: FUNCTION get_Model_Node(p_ps_node_id IN NUMBER)
1547: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1548: BEGIN
1549: -- if cache is populated then get it from cache
1550: IF NOT(g_model_nodes_tbl.EXISTS(p_ps_node_id)) THEN
1551: SELECT DISTINCT *

Line 1553: FROM CZ_UITEMPLS_FOR_PSNODES_V

1549: -- if cache is populated then get it from cache
1550: IF NOT(g_model_nodes_tbl.EXISTS(p_ps_node_id)) THEN
1551: SELECT DISTINCT *
1552: INTO g_model_nodes_tbl(p_ps_node_id)
1553: FROM CZ_UITEMPLS_FOR_PSNODES_V
1554: WHERE ps_node_id = p_ps_node_id AND
1555: ui_def_id=g_UI_Context.from_master_template_id AND
1556: deleted_flag = G_NO_FLAG;
1557:

Line 1600: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS

1596: -- p_ui_def_id - identifies UI Master Template Setting
1597: --
1598: FUNCTION get_Model_Node_By_Persist_Id(p_persistent_node_id IN NUMBER,
1599: p_model_id IN NUMBER)
1600: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1601: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1602: l_ps_node_id NUMBER;
1603: BEGIN
1604: -- if cache is populated then get it from cache

Line 1601: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

1597: --
1598: FUNCTION get_Model_Node_By_Persist_Id(p_persistent_node_id IN NUMBER,
1599: p_model_id IN NUMBER)
1600: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1601: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1602: l_ps_node_id NUMBER;
1603: BEGIN
1604: -- if cache is populated then get it from cache
1605: SELECT DISTINCT *

Line 1607: FROM CZ_UITEMPLS_FOR_PSNODES_V

1603: BEGIN
1604: -- if cache is populated then get it from cache
1605: SELECT DISTINCT *
1606: INTO l_node
1607: FROM CZ_UITEMPLS_FOR_PSNODES_V
1608: WHERE devl_project_id = p_model_id AND
1609: persistent_node_id = p_persistent_node_id AND
1610: ui_def_id=g_UI_Context.from_master_template_id AND
1611: deleted_flag = G_NO_FLAG;

Line 1626: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS

1622: END get_Model_Node_By_Persist_Id;
1623: --vsingava IM-ER
1624: FUNCTION getNodeByPersistentAndExplId(p_persistent_node_id IN NUMBER,
1625: p_expl_id IN NUMBER)
1626: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1627: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1628: l_reference_id NUMBER;
1629: l_model_id NUMBER;
1630: l_ps_node_type NUMBER;

Line 1627: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

1623: --vsingava IM-ER
1624: FUNCTION getNodeByPersistentAndExplId(p_persistent_node_id IN NUMBER,
1625: p_expl_id IN NUMBER)
1626: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1627: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1628: l_reference_id NUMBER;
1629: l_model_id NUMBER;
1630: l_ps_node_type NUMBER;
1631:

Line 1685: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

1681: x_child_nodes_tbl OUT NOCOPY model_nodes_tbl_type,
1682: x_non_deleted_child_nodes_tbl OUT NOCOPY model_nodes_tbl_type,
1683: p_include_deleted_nodes IN VARCHAR2 DEFAULT G_NO_FLAG) IS
1684:
1685: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1686: l_ps_node_id NUMBER;
1687:
1688: BEGIN
1689:

Line 1713: FROM CZ_UITEMPLS_FOR_PSNODES_V

1709:
1710: ELSE -- cache is not used
1711:
1712: FOR i IN (SELECT DISTINCT *
1713: FROM CZ_UITEMPLS_FOR_PSNODES_V
1714: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
1715: parent_id = p_ps_node_id AND
1716: (ui_omit = G_NO_FLAG OR p_show_all_nodes = G_YES_FLAG) AND
1717: (p_include_deleted_nodes = G_YES_FLAG OR deleted_flag = G_NO_FLAG)

Line 2313: FROM CZ_UITEMPLS_FOR_PSNODES_V

2309: IF g_UI_Context.CTRLTEMPLUSE_BOM = G_TEMPLATE_USE_LOCAL_COPY OR
2310: g_UI_Context.CTRLTEMPLUSE_NONBOM = G_TEMPLATE_USE_LOCAL_COPY THEN
2311:
2312: FOR m IN(SELECT DISTINCT detailed_type_id
2313: FROM CZ_UITEMPLS_FOR_PSNODES_V
2314: WHERE devl_project_id=g_UI_Context.devl_project_id AND
2315: ui_def_id=g_UI_Context.from_master_template_id AND
2316: deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG)
2317: LOOP

Line 2408: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

2404:
2405: l_model_path VARCHAR2(32000);
2406: l_persistent_node_id NUMBER;
2407: l_parent_id NUMBER;
2408: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
2409: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2410: l_seq_nbr NUMBER;
2411: l_node_depth NUMBER;
2412:

Line 2709: FUNCTION is_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

2705:
2706: --
2707: -- check : is it UI Page
2708: --
2709: FUNCTION is_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
2710: x_drilldown OUT NOCOPY BOOLEAN) RETURN BOOLEAN IS
2711:
2712: l_root_persistent_node_id NUMBER;
2713: BEGIN

Line 3102: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

3098: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3099: l_changed_target_ids_tbl number_tbl_type;
3100: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3101: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3102: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3103: l_child_page_set_id NUMBER;
3104: l_child_page_ref_id NUMBER;
3105: l_parent_page_set_id NUMBER;
3106: l_parent_page_ref_id NUMBER;

Line 3192: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

3188: l_changed_target_ids_tbl number_tbl_type;
3189: l_target_page_ids_tbl number_tbl_type;
3190: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3191: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3192: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3193: l_page_set_type NUMBER;
3194: l_initial_page_set_id NUMBER;
3195: l_initial_page_ref_id NUMBER;
3196: l_page_set_id NUMBER;

Line 3283: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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;
3285: l_undeleted_exist BOOLEAN;
3286:
3287: BEGIN

Line 3386: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 3425: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

3421:
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,

Line 3442: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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

Line 3555: FROM CZ_UITEMPLS_FOR_PSNODES_V

3551:
3552: flash_Cache;
3553:
3554: FOR i IN (SELECT DISTINCT *
3555: FROM CZ_UITEMPLS_FOR_PSNODES_V
3556: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
3557: devl_project_id = g_UI_Context.devl_project_id)
3558: LOOP
3559: g_model_nodes_tbl(i.ps_node_id) := i;

Line 5007: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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;
5008: l_ui_action_id NUMBER;
5009: l_drilldown_text_id NUMBER;
5010:
5011: l_view_name VARCHAR2(255);

Line 5658: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

5654: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;
5655: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;
5656: l_base_persistent_node_id NUMBER;
5657: l_base_expl_node_id NUMBER;
5658: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
5659: l_component_id NUMBER;
5660: l_expl_node_id NUMBER;
5661: l_persistent_intl_text_id NUMBER;
5662: l_persistent_intl_text_id_tmp NUMBER;

Line 6458: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

6454: p_new_xml_node IN xmldom.DOMNode,
6455: p_parent_xml_node IN xmldom.DOMNode)
6456: RETURN xmldom.DOMNode IS
6457:
6458: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
6459: l_doc xmldom.DOMDocument;
6460: l_anchor_doc xmldom.DOMDocument;
6461: l_subtree_doc xmldom.DOMDocument;
6462: l_xml_root_node xmldom.DOMNode;

Line 6861: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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;
6862: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;
6863: l_doc xmldom.DOMDocument;
6864: l_anchor_doc xmldom.DOMDocument;
6865: l_subtree_doc xmldom.DOMDocument;

Line 7460: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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;
7461: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;
7462: l_doc xmldom.DOMDocument;
7463: l_anchor_doc xmldom.DOMDocument;
7464: l_subtree_doc xmldom.DOMDocument;

Line 8106: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

8102: l_xml_node xmldom.DOMNode;
8103: l_parent_xml_node xmldom.DOMNode;
8104: l_child_nodes_tbl xmldom.DOMNodeList;
8105: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
8106: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
8107: l_user_attribute4 VARCHAR2(4000);
8108: l_user_attribute VARCHAR2(4000);
8109: l_drilldown_text_id NUMBER;
8110: l_ui_action_id NUMBER;

Line 8407: p_amn_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

8403: --vsingava IM-ER
8404: PROCEDURE change_to_basic_Layout(p_xml_node xmldom.DOMNode,
8405: p_user_attribute4 VARCHAR2,
8406: p_page_id NUMBER,
8407: p_amn_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
8408: l_layout_region_type VARCHAR2(10);
8409: l_element_type VARCHAR2(10);
8410: l_new_element_type VARCHAR2(10);
8411: l_view_name VARCHAR2(255);

Line 8580: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE; --vsingava IM-ER

8576: l_user_attribute4_value VARCHAR2(2000);
8577: l_layout_region_type VARCHAR2(255);
8578: l_is_instance_list_layout BOOLEAN := FALSE;
8579: l_AMN_set BOOLEAN := FALSE;
8580: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE; --vsingava IM-ER
8581: BEGIN
8582:
8583:
8584:

Line 9111: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

9107: p_show_all_nodes IN VARCHAR2 DEFAULT NULL,
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;

Line 9444: PROCEDURE add_CX_Button(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 9863: parent_persistent_node_id FROM CZ_UITEMPLS_FOR_PSNODES_V a

9859: l_persistent_intl_text_id NUMBER;
9860: BEGIN
9861:
9862: FOR option_node IN(SELECT ps_node_id,persistent_node_id,
9863: parent_persistent_node_id FROM CZ_UITEMPLS_FOR_PSNODES_V a
9864: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9865: ui_def_id=g_UI_Context.from_master_template_id AND
9866: ps_node_type IN(G_OPTION_TYPE, G_BOM_STANDART_ITEM_TYPE) AND
9867: ui_omit=G_NO_FLAG AND deleted_flag=G_NO_FLAG AND

Line 10070: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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:

Line 10136: FUNCTION create_UI_Element(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 10303: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
10307: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;

Line 10551: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

10547: END contains_BOM_Nodes;
10548:
10549: PROCEDURE add_BOM_Node
10550: (
10551: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10552: p_page_id IN NUMBER,
10553: p_pagebase_expl_node_id IN NUMBER,
10554: p_parent_element_id IN VARCHAR2,
10555: p_pagebase_persistent_node_id IN NUMBER,

Line 10706: FUNCTION get_new_page_ref_seq(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

10702:
10703: END get_Parent_Page_Data;
10704:
10705:
10706: FUNCTION get_new_page_ref_seq(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10707: p_page_set_id IN NUMBER,
10708: p_parent_page_ref_id NUMBER) RETURN NUMBER IS
10709:
10710: l_seq_nbr NUMBER;

Line 10782: FUNCTION create_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

10778:
10779: --
10780: -- create new UI page
10781: --
10782: FUNCTION create_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
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)

Line 11188: FUNCTION create_UI_Region(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 11339: FUNCTION create_UI_Reference(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 11351: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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

Line 12056: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

12052: delete_UI_Container(p_ui_node);
12053: END delete_UI_Region;
12054:
12055:
12056: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12057: p_page_id IN CZ_UI_PAGES.page_id%TYPE) IS
12058:
12059: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
12060: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;

Line 12091: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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

Line 12130: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12134: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

Line 12145: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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

Line 12234: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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;
12238: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 12269: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12273: l_ps_node_id_tb number_tbl_type;

Line 12547: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12551: l_ps_node_type NUMBER;

Line 12552: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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

Line 12715: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12719: l_ps_node_type NUMBER;

Line 12720: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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

Line 12773: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12777: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 12846: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

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,
12849: x_new_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12850:

Line 12917: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

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;
12921: l_feature_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

Line 14195: PROCEDURE exist_On_Split_Pages(p_current_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE, -->>>

14191: END LOOP;
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:

Line 14254: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14250: l_element_id_tbl varchar_tbl_type;
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;

Line 14258: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

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;
14262: l_exist_on_split_pages_flag VARCHAR2(1);

Line 14737: PROCEDURE get_parent_ui_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

14733:
14734:
14735: -- Gets the UI Node for the parent of this PsNode
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,

Line 14745: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%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:
14745: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
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;

Line 14746: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14742: x_refresh_enabled_parent_found OUT NOCOPY BOOLEAN,
14743: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14744:
14745: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
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;

Line 14747: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14743: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14744:
14745: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
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;

Line 14930: PROCEDURE add_ui_for_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

14926: -- Determines if UI should be added for this ps node.
14927: -- Determines the place (l_parent_ui_node) under which to
14928: -- add UI for this node and add the UI if required
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:

Line 14935: l_parent_ps_node 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;
14938: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14939: l_insert_index NUMBER;

Line 15014: PROCEDURE propogate_ps_node_remove(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

15010:
15011: END add_ui_for_node;
15012:
15013:
15014: PROCEDURE propogate_ps_node_remove(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
15015:
15016: l_new_parent_persistent_id NUMBER;
15017: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15018:

Line 15017: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15013:
15014: PROCEDURE propogate_ps_node_remove(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
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;

Line 15069: PROCEDURE propogate_ps_node_move(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

15065: END LOOP;
15066: END;
15067:
15068:
15069: PROCEDURE propogate_ps_node_move(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
15070: p_ord_siblings IN model_nodes_tbl_type,
15071: p_ps_node_index IN NUMBER DEFAULT NULL,
15072: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR2) IS
15073:

Line 15075: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15071: p_ps_node_index IN NUMBER DEFAULT NULL,
15072: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR2) IS
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;

Line 15319: PROCEDURE propogate_ps_node_type_changes(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

15315: END IF;
15316: END LOOP;
15317: END propogate_ps_node_move;
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;

Line 15360: FUNCTION ui_node_exits(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) RETURN BOOLEAN IS

15356:
15357: END propogate_ps_node_type_changes;
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

Line 15378: PROCEDURE reorder_tree_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

15374: RETURN FALSE;
15375:
15376: END ui_node_exits;
15377:
15378: PROCEDURE reorder_tree_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
15379:
15380: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
15381: l_page_ref CZ_UI_PAGE_REFS%ROWTYPE;
15382:

Line 15462: PROCEDURE fix_model_ref_expl_ids(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

15458: END IF;
15459:
15460: END reorder_tree_node;
15461:
15462: PROCEDURE fix_model_ref_expl_ids(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
15463: x_model_ref_expl_changed OUT NOCOPY VARCHAR2) IS
15464: l_model_ref_expl_id NUMBER;
15465:
15466: BEGIN

Line 15501: PROCEDURE propogate_changes_to_UI(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

15497: END IF;
15498:
15499: END fix_model_ref_expl_ids;
15500:
15501: PROCEDURE propogate_changes_to_UI(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
15502: p_ord_siblings IN model_nodes_tbl_type,
15503: p_ps_node_index IN NUMBER DEFAULT NULL,
15504: p_add_remove_flag IN VARCHAR2 DEFAULT G_EXISTS_FLAG,
15505: p_add_remove_timestamp IN DATE DEFAULT NULL,

Line 15512: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15508:
15509: l_added_ui BOOLEAN;
15510: l_removed_ui BOOLEAN;
15511:
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;

Line 15749: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15745: l_non_del_child_nodes_tbl model_nodes_tbl_type;
15746: l_ui_nodes_tbl ui_page_elements_tbl_type;
15747: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
15748:
15749: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15750: l_empty_siblings_tbl model_nodes_tbl_type;
15751:
15752: BEGIN
15753:

Line 16354: l_opt_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

16350:
16351: l_new_xml_node xmldom.DOMNode;
16352: l_new_opt_xml_node xmldom.DOMNode;
16353: l_xml_node_to_replace xmldom.DOMNode;
16354: l_opt_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
16355: l_element_type NUMBER;
16356:
16357: BEGIN
16358: --