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 587: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;

583: PRAGMA AUTONOMOUS_TRANSACTION;
584:
585: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
586: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
587: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
588: l_lock_status VARCHAR2(255);
589: l_msg_count NUMBER;
590: l_msg_data VARCHAR2(4000);
591:

Line 595: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES

591:
592: BEGIN
593: IF p_template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID OR
594: p_template_ui_def_id IS NULL THEN
595: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
596: WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
597: IF l_seeded_flag=G_YES_FLAG THEN
598: RETURN;
599: END IF;

Line 1866: FROM CZ_UI_TEMPLATES

1862: IF p_template_name IS NULL THEN
1863: BEGIN
1864: SELECT template_name||' - '||TO_CHAR(l_counter)
1865: INTO l_ui_node_name
1866: FROM CZ_UI_TEMPLATES
1867: WHERE template_id=p_template_id AND
1868: ui_def_id=g_UI_Context.ui_def_id;
1869: EXCEPTION
1870: WHEN NO_DATA_FOUND THEN

Line 1873: FROM CZ_UI_TEMPLATES

1869: EXCEPTION
1870: WHEN NO_DATA_FOUND THEN
1871: SELECT template_name||' - '||TO_CHAR(l_counter)
1872: INTO l_ui_node_name
1873: FROM CZ_UI_TEMPLATES
1874: WHERE template_id=p_template_id AND
1875: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
1876: END;
1877: ELSE

Line 1900: FROM CZ_UI_TEMPLATES

1896: RETURN g_template_jrad_name_tbl(p_template_id);
1897: ELSE
1898: IF p_template_ui_def_id IS NOT NULL THEN
1899: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1900: FROM CZ_UI_TEMPLATES
1901: WHERE template_id=p_template_id AND
1902: ui_def_id=p_template_ui_def_id;
1903: ELSE
1904: BEGIN

Line 1906: FROM CZ_UI_TEMPLATES

1902: ui_def_id=p_template_ui_def_id;
1903: ELSE
1904: BEGIN
1905: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1906: FROM CZ_UI_TEMPLATES
1907: WHERE template_id=p_template_id AND
1908: ui_def_id=g_UI_Context.ui_def_id;
1909: EXCEPTION
1910: WHEN OTHERS THEN

Line 1912: FROM CZ_UI_TEMPLATES

1908: ui_def_id=g_UI_Context.ui_def_id;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: SELECT jrad_doc INTO g_template_jrad_name_tbl(p_template_id)
1912: FROM CZ_UI_TEMPLATES
1913: WHERE template_id=p_template_id AND
1914: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
1915: END;
1916: END IF;

Line 2097: l_template_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

2093: p_ui_def_id IN NUMBER) IS
2094:
2095: l_xmldoc xmldom.DOMDocument;
2096: l_jrad_doc VARCHAR2(4000);
2097: l_template_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
2098:
2099: BEGIN
2100:
2101: l_template_jrad_doc := get_JRAD_Name(p_template_id, G_GLOBAL_TEMPLATES_UI_DEF_ID);

Line 2134: INSERT INTO CZ_UI_TEMPLATES

2130: RAISE WRONG_UI_TEMPLATE;
2131: END;
2132:
2133: BEGIN
2134: INSERT INTO CZ_UI_TEMPLATES
2135: (TEMPLATE_ID,
2136: UI_DEF_ID,
2137: TEMPLATE_NAME,
2138: TEMPLATE_TYPE,

Line 2174: FROM CZ_UI_TEMPLATES

2170: BUTTON_BAR_TEMPL_UIDEF_ID,
2171: TEMPLATE_USAGE,
2172: AMN_USAGE,
2173: G_NO_FLAG
2174: FROM CZ_UI_TEMPLATES
2175: WHERE template_id=p_template_id AND ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
2176:
2177: g_template_jrad_name_tbl(p_template_id) := l_jrad_doc;
2178:

Line 2283: l_template_rec CZ_UI_TEMPLATES%ROWTYPE;

2279: PROCEDURE create_Local_UI_Templates IS
2280:
2281: l_handled_templates_tbl number_tbl_type;
2282: l_detailed_type_id_tbl number_tbl_type;
2283: l_template_rec CZ_UI_TEMPLATES%ROWTYPE;
2284: l_jrad_doc VARCHAR2(4000);
2285: l_template_ui_def_id NUMBER := G_GLOBAL_TEMPLATES_UI_DEF_ID;
2286: l_create_cont_entry BOOLEAN := FALSE;
2287:

Line 4309: l_template_name CZ_UI_TEMPLATES.template_name%TYPE;

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

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

4324: IF l_id_attribute_value IS NULL THEN
4325: RETURN;
4326: END IF;
4327:
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

Line 4632: FROM CZ_UI_TEMPLATES

4628:
4629: BEGIN
4630: SELECT template_id, seeded_flag
4631: INTO l_ref_template_id, l_seeded_flag
4632: FROM CZ_UI_TEMPLATES
4633: WHERE ui_def_id=p_template_ui_def_id AND
4634: jrad_doc=l_extends_attribute AND
4635: deleted_flag=G_NO_FLAG;
4636:

Line 6573: FROM CZ_UI_TEMPLATES

6569: l_prev_node_parent_ui_cnt := xmldom.getParentNode(l_prev_node);
6570: l_prev_node_parent := xmldom.getParentNode(l_prev_node_parent_ui_cnt);
6571: BEGIN
6572: SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
6573: FROM CZ_UI_TEMPLATES
6574: WHERE template_id = l_prev_element_template_id
6575: AND ui_def_id = 0
6576: AND deleted_flag = G_NO_FLAG;
6577:

Line 6592: FROM CZ_UI_TEMPLATES

6588: l_next_node_parent_ui_cnt := xmldom.getParentNode(l_next_node);
6589: l_next_node_parent := xmldom.getParentNode(l_next_node_parent_ui_cnt);
6590: BEGIN
6591: SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
6592: FROM CZ_UI_TEMPLATES
6593: WHERE template_id = l_next_element_template_id
6594: AND ui_def_id = 0
6595: AND deleted_flag = G_NO_FLAG;
6596:

Line 6608: FROM CZ_UI_TEMPLATES

6604:
6605: IF p_ui_node.ctrl_template_id IS NOT NULL THEN
6606:
6607: SELECT layout_ui_style INTO l_lyt_ui_style
6608: FROM CZ_UI_TEMPLATES
6609: WHERE template_id = p_ui_node.ctrl_template_id
6610: AND ui_def_id = 0
6611: AND deleted_flag = G_NO_FLAG;
6612:

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

6700: RETURN l_new_xml_root_node;
6701:
6702: END insert_node;
6703:
6704: FUNCTION pluck_XML_node(p_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE,
6705: p_page_id NUMBER,
6706: p_element_id VARCHAR2)
6707: RETURN xmldom.DOMNode IS
6708:

Line 6747: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

6743: RETURN xmldom.DOMNode IS
6744:
6745: l_src_page_id NUMBER;
6746: l_xml_node_to_move xmldom.DOMNode;
6747: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
6748: l_counter NUMBER;
6749: l_element_ids_tbl varchar2_tbl_type;
6750: l_id VARCHAR2(255);
6751: l_component_id NUMBER;

Line 6862: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;

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

Line 7292: FROM CZ_UI_TEMPLATES

7288: l_prev_node_parent_ui_cnt := xmldom.getParentNode(l_prev_node);
7289: l_prev_node_parent := xmldom.getParentNode(l_prev_node_parent_ui_cnt);
7290: BEGIN
7291: SELECT layout_ui_style INTO l_prev_elt_lyt_ui_style
7292: FROM CZ_UI_TEMPLATES
7293: WHERE template_id = l_prev_element_template_id
7294: AND ui_def_id = 0
7295: AND deleted_flag = G_NO_FLAG;
7296:

Line 7314: FROM CZ_UI_TEMPLATES

7310: l_next_node_parent := xmldom.getParentNode(l_next_node_parent_ui_cnt);
7311: --DEBUG('Here 8.14');
7312: BEGIN
7313: SELECT layout_ui_style INTO l_next_elt_lyt_ui_style
7314: FROM CZ_UI_TEMPLATES
7315: WHERE template_id = l_next_element_template_id
7316: AND ui_def_id = 0
7317: AND deleted_flag = G_NO_FLAG;
7318:

Line 7461: l_ctrl_template_name CZ_UI_TEMPLATES.template_name%TYPE;

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

Line 8025: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

8021: l_xml_root_node xmldom.DOMNode;
8022: l_new_xml_root_node xmldom.DOMNode;
8023: l_out_xml_node xmldom.DOMNode;
8024: l_ui_contents_xml_node xmldom.DOMNode;
8025: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
8026:
8027: BEGIN
8028:
8029: l_jrad_doc := get_JRAD_Name(G_NSTD_CONTAINER_TEMPLATE_ID, G_GLOBAL_TEMPLATES_UI_DEF_ID);

Line 8105: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

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

Line 9051: FROM CZ_UI_TEMPLATES

9047: END IF;
9048:
9049: SELECT root_element_signature_id
9050: INTO g_DRILLDOWN_ELEM_SIGNATURE_ID
9051: FROM CZ_UI_TEMPLATES
9052: WHERE template_id=g_DRILLDOWN_TEMPLATE_ID AND
9053: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
9054: deleted_flag=G_NO_FLAG;
9055:

Line 9061: FROM CZ_UI_TEMPLATES

9057: g_DRILLDOWN_B_SIGNATURE_ID := g_DRILLDOWN_ELEM_SIGNATURE_ID;
9058: ELSE
9059: SELECT root_element_signature_id
9060: INTO g_DRILLDOWN_B_SIGNATURE_ID
9061: FROM CZ_UI_TEMPLATES
9062: WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
9063: template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
9064: deleted_flag=G_NO_FLAG;
9065: END IF;

Line 12919: l_ui_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;

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

Line 12920: l_model_layout_ui_style CZ_UI_TEMPLATES.layout_ui_style%TYPE;

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;
12922: l_under_root_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
12923: l_max_seq_nbr NUMBER;
12924:

Line 13040: FROM CZ_UI_TEMPLATES

13036: replace_Template_Id(p_ui_node => p_ui_node,
13037: p_model_node => p_model_node);
13038: ELSE
13039: SELECT layout_ui_style INTO l_ui_layout_ui_style
13040: FROM CZ_UI_TEMPLATES
13041: WHERE template_id=p_ui_node.ctrl_template_id AND
13042: ui_def_id=p_ui_node.ctrl_template_ui_def_id;
13043:
13044: SELECT layout_ui_style INTO l_model_layout_ui_style

Line 13045: FROM CZ_UI_TEMPLATES

13041: WHERE template_id=p_ui_node.ctrl_template_id AND
13042: ui_def_id=p_ui_node.ctrl_template_ui_def_id;
13043:
13044: SELECT layout_ui_style INTO l_model_layout_ui_style
13045: FROM CZ_UI_TEMPLATES
13046: WHERE template_id=p_model_node.template_id AND
13047: ui_def_id=p_model_node.template_ui_def_id;
13048:
13049: IF l_ui_layout_ui_style=l_model_layout_ui_style THEN

Line 13064: CZ_UI_TEMPLATES WHERE deleted_flag=G_NO_FLAG 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
13063: (SELECT ctrl_template_id,ctrl_template_ui_def_id FROM
13064: CZ_UI_TEMPLATES WHERE deleted_flag=G_NO_FLAG AND
13065: layout_ui_style=l_ui_layout_ui_style);
13066: EXCEPTION
13067: WHEN OTHERS THEN
13068: l_max_seq_nbr := 1;

Line 16345: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

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,
16349: p_parent_xml_node xmldom.DOMNode) IS

Line 16599: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

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;
16603: l_xml_node xmldom.DOMNode;

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

19077: END delete_UI_Page_Ref;
19078:
19079: --
19080: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
19081: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
19082: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
19083: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
19084: -- and CZ_RULES which have seeded_flag='0'
19085: --

Line 19115: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

19111:
19112: --
19113: -- get full JRAD path of the given UI template
19114: --
19115: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
19116: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19117:
19118: --
19119: -- open XML parser

Line 19149: DELETE FROM CZ_UI_TEMPLATES

19145: -- close XML parser
19146: --
19147: Close_Parser();
19148:
19149: DELETE FROM CZ_UI_TEMPLATES
19150: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id
19151: AND seeded_flag=G_NO_FLAG;
19152:
19153: DELETE FROM CZ_UI_REF_TEMPLATES

Line 19209: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

19205:
19206: --
19207: -- get full JRAD path of the given UI template
19208: --
19209: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
19210: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19211:
19212: --
19213: -- open XML parser

Line 19280: UPDATE CZ_UI_TEMPLATES

19276: Close_Parser();
19277:
19278: /* *** changes for build 21p *** */
19279:
19280: UPDATE CZ_UI_TEMPLATES
19281: SET template_rev_nbr=NVL(template_rev_nbr,0)+1
19282: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
19283:
19284: --

Line 20165: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES

20161: -- initialize FND variables/packages
20162: --
20163: Initialize(x_return_status,x_msg_count,x_msg_data);
20164:
20165: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
20166: WHERE ui_def_id=p_source_ui_def_id AND template_id=p_source_template_id;
20167:
20168: --
20169: -- open XML parser

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

20219: -- close XML parser
20220: --
20221: Close_Parser();
20222:
20223: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
20224:
20225: INSERT INTO CZ_UI_TEMPLATES
20226: (TEMPLATE_ID,
20227: UI_DEF_ID,

Line 20225: INSERT INTO CZ_UI_TEMPLATES

20221: Close_Parser();
20222:
20223: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
20224:
20225: INSERT INTO CZ_UI_TEMPLATES
20226: (TEMPLATE_ID,
20227: UI_DEF_ID,
20228: TEMPLATE_NAME,
20229: TEMPLATE_TYPE,

Line 20265: FROM CZ_UI_TEMPLATES

20261: TEMPLATE_REV_NBR,
20262: TEMPLATE_USAGE,
20263: AMN_USAGE,
20264: G_NO_FLAG
20265: FROM CZ_UI_TEMPLATES
20266: WHERE ui_def_id=p_source_ui_def_id AND
20267: template_id=p_source_template_id;
20268:
20269: INSERT INTO CZ_UI_REF_TEMPLATES

Line 20457: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES

20453: -- initialize FND variables/packages
20454: --
20455: Initialize(x_return_status,x_msg_count,x_msg_data);
20456:
20457: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
20458: WHERE ui_def_id=p_source_ui_def_id AND
20459: template_id=p_source_template_id;
20460:
20461: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES

Line 20461: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES

20457: SELECT jrad_doc INTO l_source_jrad_doc FROM CZ_UI_TEMPLATES
20458: WHERE ui_def_id=p_source_ui_def_id AND
20459: template_id=p_source_template_id;
20460:
20461: SELECT jrad_doc INTO l_target_jrad_doc FROM CZ_UI_TEMPLATES
20462: WHERE ui_def_id=p_target_ui_def_id AND
20463: template_id=p_target_template_id;
20464:
20465: --

Line 20578: UPDATE CZ_UI_TEMPLATES

20574: Close_Parser();
20575:
20576: /* *** changes for build 21p *** */
20577:
20578: UPDATE CZ_UI_TEMPLATES
20579: SET template_rev_nbr=NVL(template_rev_nbr,0)+1
20580: WHERE ui_def_id=p_target_ui_def_id AND template_id=p_target_template_id;
20581:
20582: --

Line 20676: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES

20672:
20673: --
20674: -- get full JRAD path of the given UI template
20675: --
20676: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
20677: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
20678:
20679: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES a
20680: WHERE ui_def_id=p_ui_def_id AND page_id=p_ui_page_id;

Line 20979: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES

20975:
20976: --
20977: -- get full JRAD path of the given UI template
20978: --
20979: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
20980: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
20981:
20982: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES
20983: WHERE ui_def_id=p_target_template_ui_def_id AND template_id=p_target_template_id;

Line 20982: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES

20978: --
20979: SELECT jrad_doc INTO l_template_jrad_doc FROM CZ_UI_TEMPLATES
20980: WHERE ui_def_id=p_template_ui_def_id AND template_id=p_template_id;
20981:
20982: SELECT jrad_doc INTO l_target_template_jrad_doc FROM CZ_UI_TEMPLATES
20983: WHERE ui_def_id=p_target_template_ui_def_id AND template_id=p_target_template_id;
20984:
20985: --
20986: -- open XML parser

Line 21130: UPDATE CZ_UI_TEMPLATES

21126: -- close XML parser
21127: --
21128: Close_Parser();
21129:
21130: UPDATE CZ_UI_TEMPLATES
21131: SET template_rev_nbr=template_rev_nbr+1
21132: WHERE template_id=p_target_template_id AND
21133: ui_def_id=p_target_template_ui_def_id;
21134:

Line 21235: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES

21231: --
21232: Initialize(x_return_status,x_msg_count,x_msg_data);
21233:
21234: IF (p_ui_def_id=0) THEN
21235: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_TEMPLATES
21236: WHERE template_id=p_ui_page_id AND ui_def_id=p_ui_def_id;
21237: ELSE
21238: SELECT jrad_doc INTO l_jrad_doc FROM CZ_UI_PAGES
21239: WHERE page_id=p_ui_page_id AND ui_def_id=p_ui_def_id;

Line 21290: FROM CZ_UI_TEMPLATES

21286: 'extends');
21287: BEGIN
21288: SELECT template_id, jrad_doc, root_element_signature_id
21289: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id
21290: FROM CZ_UI_TEMPLATES
21291: WHERE ui_def_id=p_ui_def_id AND jrad_doc=l_extends_attribute AND
21292: deleted_flag=G_NO_FLAG;
21293: EXCEPTION
21294: WHEN NO_DATA_FOUND THEN

Line 21296: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id FROM CZ_UI_TEMPLATES

21292: deleted_flag=G_NO_FLAG;
21293: EXCEPTION
21294: WHEN NO_DATA_FOUND THEN
21295: SELECT template_id, jrad_doc, root_element_signature_id
21296: INTO l_ref_template_id, l_template_jrad_doc, l_root_element_signature_id FROM CZ_UI_TEMPLATES
21297: WHERE ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID AND
21298: jrad_doc=l_extends_attribute AND
21299: deleted_flag=G_NO_FLAG;
21300: END;

Line 21555: UPDATE CZ_UI_TEMPLATES

21551: Close_Parser();
21552:
21553: if (p_ui_def_id=0)
21554: then
21555: UPDATE CZ_UI_TEMPLATES
21556: SET TEMPLATE_REV_NBR=TEMPLATE_REV_NBR+1
21557: WHERE ui_def_id=p_ui_def_id AND
21558: template_id=p_ui_page_id;
21559: else

Line 21933: FROM CZ_UI_TEMPLATES

21929: g_UIActionINCREMENT := get_Seq_Inc('CZ_UI_ACTIONS_S', l_oracle_schema);
21930:
21931: SELECT template_name
21932: INTO G_DRILLDOWN_TEMPLATE_NAME
21933: FROM CZ_UI_TEMPLATES
21934: WHERE template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
21935: ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID;
21936: END;
21937: