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.

[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on CZ_UI_TEMPLATES

Line 581: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;

577: PRAGMA AUTONOMOUS_TRANSACTION;
578:
579: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
580: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
581: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
582: l_lock_status VARCHAR2(255);
583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(4000);
585:

Line 589: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES

585:
586: BEGIN
587: IF p_template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID OR
588: p_template_ui_def_id IS NULL THEN
589: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
590: WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
591: IF l_seeded_flag=G_YES_FLAG THEN
592: RETURN;
593: END IF;

Line 1810: FROM CZ_UI_TEMPLATES

1806: IF p_template_name IS NULL THEN
1807: BEGIN
1808: SELECT template_name||' - '||TO_CHAR(l_counter)
1809: INTO l_ui_node_name
1810: FROM CZ_UI_TEMPLATES
1811: WHERE template_id=p_template_id AND
1812: ui_def_id=g_UI_Context.ui_def_id;
1813: EXCEPTION
1814: WHEN NO_DATA_FOUND THEN

Line 1817: FROM CZ_UI_TEMPLATES

1813: EXCEPTION
1814: WHEN NO_DATA_FOUND THEN
1815: SELECT template_name||' - '||TO_CHAR(l_counter)
1816: INTO l_ui_node_name
1817: FROM CZ_UI_TEMPLATES
1818: WHERE template_id=p_template_id AND
1819: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
1820: END;
1821: ELSE

Line 1845: FROM CZ_UI_TEMPLATES

1841: RETURN g_template_jrad_name_tbl(p_template_id);
1842: ELSE
1843: IF p_template_ui_def_id IS NOT NULL THEN
1844: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1845: FROM CZ_UI_TEMPLATES
1846: WHERE template_id=p_template_id AND
1847: ui_def_id=p_template_ui_def_id;
1848: ELSE
1849: BEGIN

Line 1851: FROM CZ_UI_TEMPLATES

1847: ui_def_id=p_template_ui_def_id;
1848: ELSE
1849: BEGIN
1850: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1851: FROM CZ_UI_TEMPLATES
1852: WHERE template_id=p_template_id AND
1853: ui_def_id=g_UI_Context.ui_def_id;
1854: EXCEPTION
1855: WHEN OTHERS THEN

Line 1857: FROM CZ_UI_TEMPLATES

1853: ui_def_id=g_UI_Context.ui_def_id;
1854: EXCEPTION
1855: WHEN OTHERS THEN
1856: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1857: FROM CZ_UI_TEMPLATES
1858: WHERE template_id=p_template_id AND
1859: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
1860: END;
1861: END IF;

Line 2035: l_template_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

2031: p_ui_def_id IN NUMBER) IS
2032:
2033: l_xmldoc xmldom.DOMDocument;
2034: l_jrad_doc VARCHAR2(4000);
2035: l_template_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
2036:
2037: BEGIN
2038:
2039: l_template_jrad_doc := get_JRAD_Name(p_template_id, G_GLOBAL_TEMPLATES_UI_DEF_ID);

Line 2072: INSERT INTO CZ_UI_TEMPLATES

2068: RAISE WRONG_UI_TEMPLATE;
2069: END;
2070:
2071: BEGIN
2072: INSERT INTO CZ_UI_TEMPLATES
2073: (TEMPLATE_ID,
2074: UI_DEF_ID,
2075: TEMPLATE_NAME,
2076: TEMPLATE_TYPE,

Line 2112: FROM CZ_UI_TEMPLATES

2108: BUTTON_BAR_TEMPL_UIDEF_ID,
2109: TEMPLATE_USAGE,
2110: AMN_USAGE,
2111: G_NO_FLAG
2112: FROM CZ_UI_TEMPLATES
2113: WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
2114:
2115: g_template_jrad_name_tbl(p_template_id) := l_jrad_doc;
2116:

Line 2221: l_template_rec CZ_UI_TEMPLATES%ROWTYPE;

2217: PROCEDURE create_Local_UI_Templates IS
2218:
2219: l_handled_templates_tbl number_tbl_type;
2220: l_detailed_type_id_tbl number_tbl_type;
2221: l_template_rec CZ_UI_TEMPLATES%ROWTYPE;
2222: l_jrad_doc VARCHAR2(4000);
2223: l_template_ui_def_id NUMBER := G_GLOBAL_TEMPLATES_UI_DEF_ID;
2224: l_create_cont_entry BOOLEAN := FALSE;
2225:

Line 4184: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;

4180: p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE) IS
4181:
4182: l_seq_nbr NUMBER;
4183: l_template_id NUMBER;
4184: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;
4185: l_id_attribute_value CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4186: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
4187: l_extend_attr_value VARCHAR2(4000);
4188:

Line 4203: SELECT template_id,template_name INTO l_template_id,l_template_name FROM CZ_UI_TEMPLATES

4199: IF l_id_attribute_value IS NULL THEN
4200: RETURN;
4201: END IF;
4202:
4203: SELECT template_id,template_name INTO l_template_id,l_template_name FROM CZ_UI_TEMPLATES
4204: WHERE ui_def_id=p_ui_node.ctrl_template_ui_def_id AND
4205: jrad_doc=l_extend_attr_value AND deleted_flag=G_NO_FLAG;
4206:
4207: SELECT NVL(max(seq_nbr),0)+1 INTO l_seq_nbr FROM CZ_UI_PAGE_ELEMENTS

Line 4507: FROM CZ_UI_TEMPLATES

4503:
4504: BEGIN
4505: SELECT template_id, seeded_flag
4506: INTO l_ref_template_id, l_seeded_flag
4507: FROM CZ_UI_TEMPLATES
4508: WHERE ui_def_id=p_template_ui_def_id AND
4509: jrad_doc=l_extends_attribute AND
4510: deleted_flag=G_NO_FLAG;
4511:

Line 6304: FROM CZ_UI_TEMPLATES

6300: l_prev_node_parent_ui_cnt := xmldom.getParentNode(l_prev_node);
6301: l_prev_node_parent := xmldom.getParentNode(l_prev_node_parent_ui_cnt);
6302: BEGIN
6303: SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
6304: FROM CZ_UI_TEMPLATES
6305: WHERE template_id = l_prev_element_template_id
6306: AND ui_def_id = 0
6307: AND deleted_flag = G_NO_FLAG;
6308:

Line 6323: FROM CZ_UI_TEMPLATES

6319: l_next_node_parent_ui_cnt := xmldom.getParentNode(l_next_node);
6320: l_next_node_parent := xmldom.getParentNode(l_next_node_parent_ui_cnt);
6321: BEGIN
6322: SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
6323: FROM CZ_UI_TEMPLATES
6324: WHERE template_id = l_next_element_template_id
6325: AND ui_def_id = 0
6326: AND deleted_flag = G_NO_FLAG;
6327:

Line 6339: FROM CZ_UI_TEMPLATES

6335:
6336: IF p_ui_node.ctrl_template_id IS NOT NULL THEN
6337:
6338: SELECT layout_ui_style INTO l_lyt_ui_style
6339: FROM CZ_UI_TEMPLATES
6340: WHERE template_id = p_ui_node.ctrl_template_id
6341: AND ui_def_id = 0
6342: AND deleted_flag = G_NO_FLAG;
6343:

Line 6435: FUNCTION pluck_XML_node(p_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE,

6431: RETURN l_new_xml_root_node;
6432:
6433: END insert_node;
6434:
6435: FUNCTION pluck_XML_node(p_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE,
6436: p_page_id NUMBER,
6437: p_element_id VARCHAR2)
6438: RETURN xmldom.DOMNode IS
6439:

Line 6478: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

6474: RETURN xmldom.DOMNode IS
6475:
6476: l_src_page_id NUMBER;
6477: l_xml_node_to_move xmldom.DOMNode;
6478: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
6479: l_counter NUMBER;
6480: l_element_ids_tbl varchar2_tbl_type;
6481: l_id VARCHAR2(255);
6482: l_component_id NUMBER;

Line 6593: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;

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;
6597: l_xml_root_node xmldom.DOMNode;

Line 7010: FROM CZ_UI_TEMPLATES

7006: l_prev_node_parent_ui_cnt := xmldom.getParentNode(l_prev_node);
7007: l_prev_node_parent := xmldom.getParentNode(l_prev_node_parent_ui_cnt);
7008: BEGIN
7009: SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
7010: FROM CZ_UI_TEMPLATES
7011: WHERE template_id = l_prev_element_template_id
7012: AND ui_def_id = 0
7013: AND deleted_flag = G_NO_FLAG;
7014:

Line 7032: FROM CZ_UI_TEMPLATES

7028: l_next_node_parent := xmldom.getParentNode(l_next_node_parent_ui_cnt);
7029: --DEBUG('Here 8.14');
7030: BEGIN
7031: SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
7032: FROM CZ_UI_TEMPLATES
7033: WHERE template_id = l_next_element_template_id
7034: AND ui_def_id = 0
7035: AND deleted_flag = G_NO_FLAG;
7036:

Line 7179: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;

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;
7183: l_xml_root_node xmldom.DOMNode;

Line 7736: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

7732: l_xml_root_node xmldom.DOMNode;
7733: l_new_xml_root_node xmldom.DOMNode;
7734: l_out_xml_node xmldom.DOMNode;
7735: l_ui_contents_xml_node xmldom.DOMNode;
7736: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
7737:
7738: BEGIN
7739:
7740: l_jrad_doc := get_JRAD_Name(G_NSTD_CONTAINER_TEMPLATE_ID, G_GLOBAL_TEMPLATES_UI_DEF_ID);

Line 7816: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

7812: l_tabxml_node xmldom.DOMNode;
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;

Line 8591: FROM CZ_UI_TEMPLATES

8587: END IF;
8588:
8589: SELECT root_element_signature_id
8590: INTO g_DRILLDOWN_ELEM_SIGNATURE_ID
8591: FROM CZ_UI_TEMPLATES
8592: WHERE template_id=g_DRILLDOWN_TEMPLATE_ID AND
8593: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
8594: deleted_flag=G_NO_FLAG;
8595:

Line 8601: FROM CZ_UI_TEMPLATES

8597: g_DRILLDOWN_B_SIGNATURE_ID := g_DRILLDOWN_ELEM_SIGNATURE_ID;
8598: ELSE
8599: SELECT root_element_signature_id
8600: INTO g_DRILLDOWN_B_SIGNATURE_ID
8601: FROM CZ_UI_TEMPLATES
8602: WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
8603: template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
8604: deleted_flag=G_NO_FLAG;
8605: END IF;

Line 12441: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;

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;
12444: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12445: l_max_seq_nbr NUMBER;

Line 12442: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;

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;
12444: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12445: l_max_seq_nbr NUMBER;
12446:

Line 12562: FROM CZ_UI_TEMPLATES

12558: replace_Template_Id(p_ui_node => p_ui_node,
12559: p_model_node => p_model_node);
12560: ELSE
12561: SELECT layout_ui_style INTO l_ui_layout_ui_style
12562: FROM CZ_UI_TEMPLATES
12563: WHERE template_id=p_ui_node.ctrl_template_id AND
12564: ui_def_id=p_ui_node.ctrl_template_ui_def_id;
12565:
12566: SELECT layout_ui_style INTO l_model_layout_ui_style

Line 12567: FROM CZ_UI_TEMPLATES

12563: WHERE template_id=p_ui_node.ctrl_template_id AND
12564: ui_def_id=p_ui_node.ctrl_template_ui_def_id;
12565:
12566: SELECT layout_ui_style INTO l_model_layout_ui_style
12567: FROM CZ_UI_TEMPLATES
12568: WHERE template_id=p_model_node.template_id AND
12569: ui_def_id=p_model_node.template_ui_def_id;
12570:
12571: IF l_ui_layout_ui_style=l_model_layout_ui_style THEN

Line 12586: CZ_UI_TEMPLATES WHERE deleted_flag=G_NO_FLAG AND

12582: page_id=p_ui_node.page_id AND
12583: parent_element_id IS NOT NULL AND
12584: (ctrl_template_id,ctrl_template_ui_def_id) IN
12585: (SELECT ctrl_template_id,ctrl_template_ui_def_id FROM
12586: CZ_UI_TEMPLATES WHERE deleted_flag=G_NO_FLAG AND
12587: layout_ui_style=l_ui_layout_ui_style);
12588: EXCEPTION
12589: WHEN OTHERS THEN
12590: l_max_seq_nbr := 1;

Line 15681: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

15677: l_xml_root_node xmldom.DOMNode;
15678: l_xml_uicontent_node xmldom.DOMNode;
15679: l_xml_node_to_refresh xmldom.DOMNode;
15680: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15681: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
15682: l_col_number NUMBER := 0;
15683:
15684: PROCEDURE create_Next_XML_Level(p_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE,
15685: p_parent_xml_node xmldom.DOMNode) IS

Line 15935: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

15931: l_subtree_doc xmldom.DOMDocument;
15932: l_xml_root_node xmldom.DOMNode;
15933: l_xml_uicontent_node xmldom.DOMNode;
15934: l_page_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
15935: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
15936: l_sub_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15937: l_curr_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
15938: l_child_nodes_tbl xmldom.DOMNodeList;
15939: l_xml_node xmldom.DOMNode;

Line 18175: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.

18171: END delete_UI_Page_Ref;
18172:
18173: --
18174: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
18175: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
18176: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
18177: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
18178: -- and CZ_RULES which have seeded_flag='0'
18179: --

Line 18209: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

18205:
18206: --
18207: -- get full JRAD path of the given UI template
18208: --
18209: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
18210: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
18211:
18212: --
18213: -- open XML parser

Line 18243: DELETE FROM CZ_UI_TEMPLATES

18239: -- close XML parser
18240: --
18241: Close_Parser();
18242:
18243: DELETE FROM CZ_UI_TEMPLATES
18244: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id
18245: AND seeded_flag=G_NO_FLAG;
18246:
18247: DELETE FROM CZ_UI_REF_TEMPLATES

Line 18303: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

18299:
18300: --
18301: -- get full JRAD path of the given UI template
18302: --
18303: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
18304: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
18305:
18306: --
18307: -- open XML parser

Line 18374: UPDATE CZ_UI_TEMPLATES

18370: Close_Parser();
18371:
18372: /* *** changes for build 21p *** */
18373:
18374: UPDATE CZ_UI_TEMPLATES
18375: SET template_rev_nbr=NVL(template_rev_nbr,0)+1
18376: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
18377:
18378: --

Line 19078: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES

19074: -- initialize FND variables/packages
19075: --
19076: Initialize(x_return_status,x_msg_count,x_msg_data);
19077:
19078: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
19079: WHERE ui_def_id=p_source_ui_def_id AND template_id=p_source_template_id;
19080:
19081: --
19082: -- open XML parser

Line 19136: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');

19132: -- close XML parser
19133: --
19134: Close_Parser();
19135:
19136: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
19137:
19138: INSERT INTO CZ_UI_TEMPLATES
19139: (TEMPLATE_ID,
19140: UI_DEF_ID,

Line 19138: INSERT INTO CZ_UI_TEMPLATES

19134: Close_Parser();
19135:
19136: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
19137:
19138: INSERT INTO CZ_UI_TEMPLATES
19139: (TEMPLATE_ID,
19140: UI_DEF_ID,
19141: TEMPLATE_NAME,
19142: TEMPLATE_TYPE,

Line 19178: FROM CZ_UI_TEMPLATES

19174: TEMPLATE_REV_NBR,
19175: TEMPLATE_USAGE,
19176: AMN_USAGE,
19177: G_NO_FLAG
19178: FROM CZ_UI_TEMPLATES
19179: WHERE ui_def_id=p_source_ui_def_id AND
19180: template_id=p_source_template_id;
19181:
19182: INSERT INTO CZ_UI_REF_TEMPLATES

Line 19341: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES

19337: -- initialize FND variables/packages
19338: --
19339: Initialize(x_return_status,x_msg_count,x_msg_data);
19340:
19341: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
19342: WHERE ui_def_id=p_source_ui_def_id AND
19343: template_id=p_source_template_id;
19344:
19345: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES

Line 19345: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES

19341: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
19342: WHERE ui_def_id=p_source_ui_def_id AND
19343: template_id=p_source_template_id;
19344:
19345: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES
19346: WHERE ui_def_id=p_target_ui_def_id AND
19347: template_id=p_target_template_id;
19348:
19349: --

Line 19462: UPDATE CZ_UI_TEMPLATES

19458: Close_Parser();
19459:
19460: /* *** changes for build 21p *** */
19461:
19462: UPDATE CZ_UI_TEMPLATES
19463: SET template_rev_nbr=NVL(template_rev_nbr,0)+1
19464: WHERE ui_def_id=p_target_ui_def_id AND template_id=p_target_template_id;
19465:
19466: --

Line 19560: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES

19556:
19557: --
19558: -- get full JRAD path of the given UI template
19559: --
19560: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
19561: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19562:
19563: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a
19564: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id;

Line 19863: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES

19859:
19860: --
19861: -- get full JRAD path of the given UI template
19862: --
19863: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
19864: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19865:
19866: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES
19867: WHERE ui_def_id=p_target_template_ui_def_id AND template_id=p_target_template_id;

Line 19866: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES

19862: --
19863: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
19864: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19865:
19866: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES
19867: WHERE ui_def_id=p_target_template_ui_def_id AND template_id=p_target_template_id;
19868:
19869: --
19870: -- open XML parser

Line 20014: UPDATE CZ_UI_TEMPLATES

20010: -- close XML parser
20011: --
20012: Close_Parser();
20013:
20014: UPDATE CZ_UI_TEMPLATES
20015: SET template_rev_nbr=template_rev_nbr+1
20016: WHERE template_id=p_target_template_id AND
20017: ui_def_id=p_target_template_ui_def_id;
20018:

Line 20119: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

20115: --
20116: Initialize(x_return_status,x_msg_count,x_msg_data);
20117:
20118: IF (p_ui_def_id=0) THEN
20119: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
20120: WHERE template_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
20121: ELSE
20122: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
20123: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line 20174: FROM CZ_UI_TEMPLATES

20170: 'extends');
20171: BEGIN
20172: SELECT template_id, jrad_doc, root_element_signature_id
20173: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id
20174: FROM CZ_UI_TEMPLATES
20175: WHERE ui_def_id=p_ui_def_id AND jrad_doc=l_extends_attribute AND
20176: deleted_flag=G_NO_FLAG;
20177: EXCEPTION
20178: WHEN NO_DATA_FOUND THEN

Line 20180: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id FROM CZ_UI_TEMPLATES

20176: deleted_flag=G_NO_FLAG;
20177: EXCEPTION
20178: WHEN NO_DATA_FOUND THEN
20179: SELECT template_id, jrad_doc, root_element_signature_id
20180: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id FROM CZ_UI_TEMPLATES
20181: WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
20182: jrad_doc=l_extends_attribute AND
20183: deleted_flag=G_NO_FLAG;
20184: END;

Line 20439: UPDATE CZ_UI_TEMPLATES

20435: Close_Parser();
20436:
20437: if (p_ui_def_id=0)
20438: then
20439: UPDATE CZ_UI_TEMPLATES
20440: SET TEMPLATE_REV_NBR=TEMPLATE_REV_NBR+1
20441: WHERE ui_def_id=p_ui_def_id AND
20442: template_id=p_ui_page_id;
20443: else

Line 20817: FROM CZ_UI_TEMPLATES

20813: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
20814:
20815: SELECT template_name
20816: INTO G_DRILLDOWN_TEMPLATE_NAME
20817: FROM CZ_UI_TEMPLATES
20818: WHERE template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
20819: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
20820: END;
20821: