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 653: FROM CZ_UITEMPLS_FOR_PSNODES_V

649: l_msg_data VARCHAR2(4000);
650: l_msg_index number;
651: BEGIN
652: FOR i IN(SELECT DISTINCT template_id, detailed_type_id
653: FROM CZ_UITEMPLS_FOR_PSNODES_V
654: WHERE devl_project_id=p_model_id AND
655: ui_def_id=p_ui_def_id AND
656: template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
657: deleted_flag = G_NO_FLAG)

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

1302:
1303: --
1304: -- return name of node type
1305: --
1306: FUNCTION get_View_Name(p_ui_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
1307: x_has_children OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1308: l_view_name VARCHAR2(255);
1309: BEGIN
1310: x_has_children := G_NO_FLAG;

Line 1541: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS

1537: -- Parameters :
1538: -- p_ps_node_id - identifies node in Model tree
1539: --
1540: FUNCTION get_Model_Node(p_ps_node_id IN NUMBER)
1541: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1542: BEGIN
1543: -- if cache is populated then get it from cache
1544: IF NOT(g_model_nodes_tbl.EXISTS(p_ps_node_id)) THEN
1545: SELECT DISTINCT *

Line 1547: FROM CZ_UITEMPLS_FOR_PSNODES_V

1543: -- if cache is populated then get it from cache
1544: IF NOT(g_model_nodes_tbl.EXISTS(p_ps_node_id)) THEN
1545: SELECT DISTINCT *
1546: INTO g_model_nodes_tbl(p_ps_node_id)
1547: FROM CZ_UITEMPLS_FOR_PSNODES_V
1548: WHERE ps_node_id = p_ps_node_id AND
1549: ui_def_id=g_UI_Context.from_master_template_id AND
1550: deleted_flag = G_NO_FLAG;
1551:

Line 1594: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS

1590: -- p_ui_def_id - identifies UI Master Template Setting
1591: --
1592: FUNCTION get_Model_Node_By_Persist_Id(p_persistent_node_id IN NUMBER,
1593: p_model_id IN NUMBER)
1594: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1595: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1596: l_ps_node_id NUMBER;
1597: BEGIN
1598: -- if cache is populated then get it from cache

Line 1595: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

1591: --
1592: FUNCTION get_Model_Node_By_Persist_Id(p_persistent_node_id IN NUMBER,
1593: p_model_id IN NUMBER)
1594: RETURN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE IS
1595: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1596: l_ps_node_id NUMBER;
1597: BEGIN
1598: -- if cache is populated then get it from cache
1599: SELECT DISTINCT *

Line 1601: FROM CZ_UITEMPLS_FOR_PSNODES_V

1597: BEGIN
1598: -- if cache is populated then get it from cache
1599: SELECT DISTINCT *
1600: INTO l_node
1601: FROM CZ_UITEMPLS_FOR_PSNODES_V
1602: WHERE devl_project_id = p_model_id AND
1603: persistent_node_id = p_persistent_node_id AND
1604: ui_def_id=g_UI_Context.from_master_template_id AND
1605: deleted_flag = G_NO_FLAG;

Line 1629: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

1625: x_child_nodes_tbl OUT NOCOPY model_nodes_tbl_type,
1626: x_non_deleted_child_nodes_tbl OUT NOCOPY model_nodes_tbl_type,
1627: p_include_deleted_nodes IN VARCHAR2 DEFAULT G_NO_FLAG) IS
1628:
1629: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
1630: l_ps_node_id NUMBER;
1631:
1632: BEGIN
1633:

Line 1657: FROM CZ_UITEMPLS_FOR_PSNODES_V

1653:
1654: ELSE -- cache is not used
1655:
1656: FOR i IN (SELECT DISTINCT *
1657: FROM CZ_UITEMPLS_FOR_PSNODES_V
1658: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
1659: parent_id = p_ps_node_id AND
1660: (ui_omit = G_NO_FLAG OR p_show_all_nodes = G_YES_FLAG) AND
1661: (p_include_deleted_nodes = G_YES_FLAG OR deleted_flag = G_NO_FLAG)

Line 2251: FROM CZ_UITEMPLS_FOR_PSNODES_V

2247: IF g_UI_Context.CTRLTEMPLUSE_BOM = G_TEMPLATE_USE_LOCAL_COPY OR
2248: g_UI_Context.CTRLTEMPLUSE_NONBOM = G_TEMPLATE_USE_LOCAL_COPY THEN
2249:
2250: FOR m IN(SELECT DISTINCT detailed_type_id
2251: FROM CZ_UITEMPLS_FOR_PSNODES_V
2252: WHERE devl_project_id=g_UI_Context.devl_project_id AND
2253: ui_def_id=g_UI_Context.from_master_template_id AND
2254: deleted_flag=G_NO_FLAG AND ui_omit=G_NO_FLAG)
2255: LOOP

Line 2346: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

2342:
2343: l_model_path VARCHAR2(32000);
2344: l_persistent_node_id NUMBER;
2345: l_parent_id NUMBER;
2346: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
2347: l_page_set_node CZ_UI_PAGE_SETS%ROWTYPE;
2348: l_seq_nbr NUMBER;
2349: l_node_depth NUMBER;
2350:

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

2643:
2644: --
2645: -- check : is it UI Page
2646: --
2647: FUNCTION is_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
2648: x_drilldown OUT NOCOPY BOOLEAN) RETURN BOOLEAN IS
2649:
2650: l_root_persistent_node_id NUMBER;
2651: BEGIN

Line 3040: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

3036: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3037: l_changed_target_ids_tbl number_tbl_type;
3038: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3039: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3040: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3041: l_child_page_set_id NUMBER;
3042: l_child_page_ref_id NUMBER;
3043: l_parent_page_set_id NUMBER;
3044: l_parent_page_ref_id NUMBER;

Line 3130: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

3126: l_changed_target_ids_tbl number_tbl_type;
3127: l_target_page_ids_tbl number_tbl_type;
3128: l_ui_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
3129: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
3130: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3131: l_page_set_type NUMBER;
3132: l_initial_page_set_id NUMBER;
3133: l_initial_page_ref_id NUMBER;
3134: l_page_set_id NUMBER;

Line 3221: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

3217: --
3218: FUNCTION get_CX_Button_Status(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
3219: RETURN VARCHAR2 IS
3220:
3221: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3222: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;
3223: l_undeleted_exist BOOLEAN;
3224:
3225: BEGIN

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

3320:
3321: --
3322: -- refresh expl ids in UI tables
3323: --
3324: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
3325: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
3326: p_expl_id IN NUMBER) IS
3327:
3328: BEGIN

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

3359:
3360: --
3361: -- refresh expl ids in UI tables
3362: --
3363: PROCEDURE sync_Expl_Ids(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
3364: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
3365: l_model_ref_expl_id NUMBER;
3366: BEGIN
3367: l_model_ref_expl_id := get_Expl_Id(p_model_id => p_node.devl_project_id,

Line 3380: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

3376: --
3377: -- replace Template Id of UI node p_ui_node
3378: --
3379: PROCEDURE replace_Template_Id(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
3380: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
3381:
3382: l_element_signature_id NUMBER;
3383: l_counter NUMBER;
3384:

Line 3493: FROM CZ_UITEMPLS_FOR_PSNODES_V

3489:
3490: flash_Cache;
3491:
3492: FOR i IN (SELECT DISTINCT *
3493: FROM CZ_UITEMPLS_FOR_PSNODES_V
3494: WHERE ui_def_id=g_UI_Context.from_master_template_id AND
3495: devl_project_id = g_UI_Context.devl_project_id)
3496: LOOP
3497: g_model_nodes_tbl(i.ps_node_id) := i;

Line 4882: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

4878: p_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
4879: p_element_signature_id NUMBER DEFAULT NULL) IS
4880:
4881: l_xml_root_element_node xmldom.DOMElement := xmldom.makeElement(p_xml_root_node);
4882: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
4883: l_ui_action_id NUMBER;
4884: l_drilldown_text_id NUMBER;
4885:
4886: l_view_name VARCHAR2(255);

Line 6189: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

6185: p_new_xml_node IN xmldom.DOMNode,
6186: p_parent_xml_node IN xmldom.DOMNode)
6187: RETURN xmldom.DOMNode IS
6188:
6189: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
6190: l_doc xmldom.DOMDocument;
6191: l_anchor_doc xmldom.DOMDocument;
6192: l_subtree_doc xmldom.DOMDocument;
6193: l_xml_root_node xmldom.DOMNode;

Line 6592: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

6588: FUNCTION create_UIXML_Element_new(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
6589: p_parent_xml_node xmldom.DOMNode)
6590: RETURN xmldom.DOMNode IS
6591:
6592: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
6593: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;
6594: l_doc xmldom.DOMDocument;
6595: l_anchor_doc xmldom.DOMDocument;
6596: l_subtree_doc xmldom.DOMDocument;

Line 7178: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

7174: FUNCTION create_UIXML_Element(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
7175: p_parent_xml_node xmldom.DOMNode)
7176: RETURN xmldom.DOMNode IS
7177:
7178: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
7179: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;
7180: l_doc xmldom.DOMDocument;
7181: l_anchor_doc xmldom.DOMDocument;
7182: l_subtree_doc xmldom.DOMDocument;

Line 7817: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

7813: l_xml_node xmldom.DOMNode;
7814: l_parent_xml_node xmldom.DOMNode;
7815: l_child_nodes_tbl xmldom.DOMNodeList;
7816: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
7817: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
7818: l_user_attribute4 VARCHAR2(4000);
7819: l_user_attribute VARCHAR2(4000);
7820: l_drilldown_text_id NUMBER;
7821: l_ui_action_id NUMBER;

Line 8651: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

8647: p_show_all_nodes IN VARCHAR2 DEFAULT NULL,
8648: p_create_empty_ui IN VARCHAR2 DEFAULT NULL)
8649: RETURN CZ_UI_DEFS%ROWTYPE IS
8650:
8651: l_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
8652: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
8653: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
8654: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
8655: l_page_set_type CZ_UI_PAGE_SETS.page_set_type%TYPE;

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

8980:
8981: --
8982: -- create new CX button
8983: --
8984: PROCEDURE add_CX_Button(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
8985: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
8986:
8987: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
8988: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;

Line 9393: parent_persistent_node_id FROM CZ_UITEMPLS_FOR_PSNODES_V a

9389:
9390: BEGIN
9391:
9392: FOR option_node IN(SELECT ps_node_id,persistent_node_id,
9393: parent_persistent_node_id FROM CZ_UITEMPLS_FOR_PSNODES_V a
9394: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9395: ui_def_id=g_UI_Context.from_master_template_id AND
9396: ps_node_type IN(G_OPTION_TYPE, G_BOM_STANDART_ITEM_TYPE) AND
9397: ui_omit=G_NO_FLAG AND deleted_flag=G_NO_FLAG AND

Line 9596: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

9592: l_ui_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
9593: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9594: l_parent_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9595: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
9596: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
9597: l_invalid_flag VARCHAR2(1);
9598:
9599: BEGIN
9600:

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

9658:
9659: --
9660: -- create single UI element
9661: --
9662: FUNCTION create_UI_Element(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
9663: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
9664: p_insert_index IN NUMBER DEFAULT -1)
9665: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
9666:

Line 9829: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

9825: -- add Instance Management Controls
9826: --
9827: PROCEDURE add_Instance_Controls(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
9828: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
9829: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
9830:
9831: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
9832: l_element_type CZ_UI_PAGE_ELEMENTS.element_type%TYPE;
9833: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;

Line 10072: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

10068: END contains_BOM_Nodes;
10069:
10070: PROCEDURE add_BOM_Node
10071: (
10072: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10073: p_page_id IN NUMBER,
10074: p_pagebase_expl_node_id IN NUMBER,
10075: p_parent_element_id IN VARCHAR2,
10076: p_pagebase_persistent_node_id IN NUMBER,

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

10223:
10224: END get_Parent_Page_Data;
10225:
10226:
10227: FUNCTION get_new_page_ref_seq(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10228: p_page_set_id IN NUMBER,
10229: p_parent_page_ref_id NUMBER) RETURN NUMBER IS
10230:
10231: l_seq_nbr NUMBER;

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

10299:
10300: --
10301: -- create new UI page
10302: --
10303: FUNCTION create_UI_Page(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10304: x_page_set_id OUT NOCOPY NUMBER,
10305: x_page_set_type OUT NOCOPY NUMBER,
10306: x_page_ref_id OUT NOCOPY NUMBER,
10307: p_parent_page_id IN NUMBER DEFAULT NULL)

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

10705:
10706: --
10707: -- create nested Region
10708: --
10709: FUNCTION create_UI_Region(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10710: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
10711: p_insert_index IN NUMBER DEFAULT -1)
10712: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10713:

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

10856:
10857: --
10858: -- create new UI Reference
10859: --
10860: FUNCTION create_UI_Reference(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
10861: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
10862: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10863:
10864: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line 10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

10868: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
10869: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
10870: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
10871: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
10872: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
10873: l_counter NUMBER;
10874: l_persistent_node_id NUMBER;
10875: l_seq_nbr NUMBER;
10876: l_max_prev_seq_nbr NUMBER;

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

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

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

11608: END IF;
11609:
11610: END replace_page_ref_target_path;
11611:
11612: PROCEDURE replace_page_ref_target_path(p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11613: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11614: BEGIN
11615:
11616: IF p_node.ps_node_type = G_REFERENCE_TYPE AND

Line 11651: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

11647: END replace_page_ref_target_path;
11648:
11649:
11650: PROCEDURE replace_page_ref_target_path(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11651: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11652:
11653: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11654: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
11655: l_page_path_from_root CZ_UI_PAGE_REFS.target_path%TYPE;

Line 11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

11662: END replace_page_ref_target_path;
11663:
11664: PROCEDURE move_page_ref(p_page_set_id IN CZ_UI_PAGE_REFS.page_set_id%TYPE,
11665: p_page_ref_id IN CZ_UI_PAGE_REFS.page_ref_id%TYPE,
11666: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11667: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11668:
11669:
11670: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;

Line 11755: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

11751: END move_page_ref;
11752:
11753:
11754: PROCEDURE move_page_ref(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11755: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
11756: x_new_parent_page_ref_id OUT NOCOPY CZ_UI_PAGE_REFS.page_ref_id%TYPE) IS
11757:
11758: l_page_set_id CZ_UI_PAGE_REFS.page_set_id%TYPE;
11759: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 11790: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

11786: --
11787: -- change instantiability of Page
11788: --
11789: PROCEDURE check_Page_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
11790: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
11791:
11792: l_changed_pages_tbl number_tbl_type;
11793: l_persistent_node_id_tbl number_tbl_type;
11794: l_ps_node_id_tb number_tbl_type;

Line 12067: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

12063: --
12064: -- change instantiability of Page
12065: --
12066: PROCEDURE check_Reference_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12067: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12068: l_refresh_ui_page BOOLEAN:=FALSE;
12069: l_persistent_node_id NUMBER;
12070: l_max_seq_nbr NUMBER;
12071: l_ps_node_type NUMBER;

Line 12072: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

12068: l_refresh_ui_page BOOLEAN:=FALSE;
12069: l_persistent_node_id NUMBER;
12070: l_max_seq_nbr NUMBER;
12071: l_ps_node_type NUMBER;
12072: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12073: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12074: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12075: l_template_id NUMBER;
12076: l_template_ui_def_id NUMBER;

Line 12235: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

12231: END check_Reference_Changes;
12232:
12233:
12234: PROCEDURE check_Connector_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12235: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12236: l_refresh_ui_page BOOLEAN:=FALSE;
12237: l_persistent_node_id NUMBER;
12238: l_max_seq_nbr NUMBER;
12239: l_ps_node_type NUMBER;

Line 12240: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

12236: l_refresh_ui_page BOOLEAN:=FALSE;
12237: l_persistent_node_id NUMBER;
12238: l_max_seq_nbr NUMBER;
12239: l_ps_node_type NUMBER;
12240: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
12241: l_target_path CZ_UI_PAGE_REFS.target_path%TYPE;
12242: l_ui_node_name CZ_UI_PAGE_ELEMENTS.name%TYPE;
12243: l_instantiable_flag CZ_UI_PAGE_ELEMENTS.instantiable_flag%TYPE;
12244: l_template_id NUMBER;

Line 12293: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

12289: --
12290: -- change instantiability of UI region
12291: --
12292: PROCEDURE check_Region_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12293: p_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12294:
12295: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12296: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
12297: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;

Line 12369: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,

12365: -- add new UI node
12366: --
12367: PROCEDURE add_New_UI_Node(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12368: p_insert_index IN NUMBER DEFAULT -1,
12369: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
12370: p_suppress_refresh_flag IN VARCHAR2,
12371: x_new_ui_pages_tbl IN OUT NOCOPY ui_page_elements_tbl_type,
12372: x_new_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
12373:

Line 12439: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS

12435: --
12436: -- check UI Node changes
12437: --
12438: PROCEDURE check_UI_Node_Changes(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
12439: p_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
12440:
12441: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12442: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;
12443: l_feature_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;

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

13707: END LOOP;
13708:
13709: END delete_UI_Nodes;
13710:
13711: PROCEDURE exist_On_Split_Pages(p_current_model_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE, -->>>
13712: p_parent_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE,
13713: px_page_split_seq_nbr OUT NOCOPY NUMBER,
13714: l_exist_on_split_pages_flag OUT NOCOPY VARCHAR2) IS
13715:

Line 13770: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

13766: l_element_id_tbl varchar_tbl_type;
13767: l_page_id_tbl number_tbl_type;
13768: l_suppress_refresh_flag_tbl varchar_tbl_type;
13769:
13770: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
13771: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13772: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13773: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
13774: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

Line 13774: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

13770: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
13771: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13772: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
13773: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;
13774: l_current_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
13775: l_seq_nbr NUMBER;
13776: l_max_split_nbr NUMBER;
13777: l_page_split_seq_nbr NUMBER;
13778: l_exist_on_split_pages_flag VARCHAR2(1);

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

14154:
14155:
14156: -- Gets the UI Node for the parent of this PsNode
14157: --
14158: PROCEDURE get_parent_ui_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14159: p_ord_siblings IN model_nodes_tbl_type,
14160: p_ps_node_index IN NUMBER,
14161: x_parent_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE,
14162: x_insert_index OUT NOCOPY NUMBER,

Line 14166: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14162: x_insert_index OUT NOCOPY NUMBER,
14163: x_refresh_enabled_parent_found OUT NOCOPY BOOLEAN,
14164: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14165:
14166: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14167: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14168: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14169: l_pred_persistent_node_id NUMBER := NULL;
14170: l_succ_persistent_node_id NUMBER := NULL;

Line 14167: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14163: x_refresh_enabled_parent_found OUT NOCOPY BOOLEAN,
14164: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14165:
14166: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14167: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14168: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14169: l_pred_persistent_node_id NUMBER := NULL;
14170: l_succ_persistent_node_id NUMBER := NULL;
14171: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line 14168: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14164: x_atleast_one_parent_found OUT NOCOPY BOOLEAN) IS
14165:
14166: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14167: l_predecessor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14168: l_successor CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14169: l_pred_persistent_node_id NUMBER := NULL;
14170: l_succ_persistent_node_id NUMBER := NULL;
14171: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14172: l_parent_element_id NUMBER;

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

14347: -- Determines if UI should be added for this ps node.
14348: -- Determines the place (l_parent_ui_node) under which to
14349: -- add UI for this node and add the UI if required
14350:
14351: PROCEDURE add_ui_for_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14352: p_ord_siblings IN model_nodes_tbl_type,
14353: p_ps_node_index IN NUMBER DEFAULT NULL,
14354: x_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
14355:

Line 14356: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14352: p_ord_siblings IN model_nodes_tbl_type,
14353: p_ps_node_index IN NUMBER DEFAULT NULL,
14354: x_ui_node OUT NOCOPY CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
14355:
14356: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14357: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14358: l_temp_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14359: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
14360: l_insert_index NUMBER;

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

14431:
14432: END add_ui_for_node;
14433:
14434:
14435: PROCEDURE propogate_ps_node_remove(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
14436:
14437: l_new_parent_persistent_id NUMBER;
14438: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14439:

Line 14438: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14434:
14435: PROCEDURE propogate_ps_node_remove(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
14436:
14437: l_new_parent_persistent_id NUMBER;
14438: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14439:
14440: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14441: l_insert_index NUMBER;
14442: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

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

14486: END LOOP;
14487: END;
14488:
14489:
14490: PROCEDURE propogate_ps_node_move(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14491: p_ord_siblings IN model_nodes_tbl_type,
14492: p_ps_node_index IN NUMBER DEFAULT NULL,
14493: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR2) IS
14494:

Line 14496: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14492: p_ps_node_index IN NUMBER DEFAULT NULL,
14493: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR2) IS
14494:
14495: l_new_parent_persistent_id NUMBER;
14496: l_parent_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14497:
14498: l_parent_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14499: l_insert_index NUMBER;
14500: l_suppress_refresh_flag CZ_UI_PAGE_ELEMENTS.suppress_refresh_flag%TYPE;

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

14736: END IF;
14737: END LOOP;
14738: END propogate_ps_node_move;
14739:
14740: PROCEDURE propogate_ps_node_type_changes(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14741: x_model_ref_expl_id_changed OUT NOCOPY VARCHAR) IS
14742:
14743: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
14744: l_model_ref_expl_id NUMBER;

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

14777:
14778: END propogate_ps_node_type_changes;
14779:
14780:
14781: FUNCTION ui_node_exits(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) RETURN BOOLEAN IS
14782:
14783: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
14784:
14785: BEGIN

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

14795: RETURN FALSE;
14796:
14797: END ui_node_exits;
14798:
14799: PROCEDURE reorder_tree_node(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE) IS
14800:
14801: l_page_set_id CZ_UI_PAGE_SETS.page_set_id%TYPE;
14802: l_page_ref CZ_UI_PAGE_REFS%ROWTYPE;
14803:

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

14879: END IF;
14880:
14881: END reorder_tree_node;
14882:
14883: PROCEDURE fix_model_ref_expl_ids(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14884: x_model_ref_expl_changed OUT NOCOPY VARCHAR2) IS
14885: l_model_ref_expl_id NUMBER;
14886:
14887: BEGIN

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

14918: END IF;
14919:
14920: END fix_model_ref_expl_ids;
14921:
14922: PROCEDURE propogate_changes_to_UI(p_ps_node IN CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE,
14923: p_ord_siblings IN model_nodes_tbl_type,
14924: p_ps_node_index IN NUMBER DEFAULT NULL,
14925: p_add_remove_flag IN VARCHAR2 DEFAULT G_EXISTS_FLAG,
14926: p_add_remove_timestamp IN DATE DEFAULT NULL,

Line 14933: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

14929:
14930: l_added_ui BOOLEAN;
14931: l_removed_ui BOOLEAN;
14932:
14933: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
14934: l_nodes_tbl model_nodes_tbl_type;
14935: l_seq_nodes_tbl ui_page_el_int_tbl_type; -- fix for bug 6837809 : skudryav 28-Mar-2008
14936: l_non_del_child_nodes_tbl model_nodes_tbl_type;
14937: l_new_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;

Line 15170: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15166: l_non_del_child_nodes_tbl model_nodes_tbl_type;
15167: l_ui_nodes_tbl ui_page_elements_tbl_type;
15168: l_next_level_ui_pages_tbl ui_page_elements_tbl_type;
15169:
15170: l_ps_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15171: l_empty_siblings_tbl model_nodes_tbl_type;
15172:
15173: BEGIN
15174:

Line 15690: l_opt_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;

15686:
15687: l_new_xml_node xmldom.DOMNode;
15688: l_new_opt_xml_node xmldom.DOMNode;
15689: l_xml_node_to_replace xmldom.DOMNode;
15690: l_opt_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
15691: l_element_type NUMBER;
15692:
15693: BEGIN
15694: --