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_UI_DEFS

Line 279: TYPE ui_def_nodes_tbl_type IS TABLE OF CZ_UI_DEFS%ROWTYPE INDEX BY BINARY_INTEGER;

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;
282: TYPE ui_page_refs_tbl_type IS TABLE OF CZ_UI_PAGE_REFS%ROWTYPE INDEX BY BINARY_INTEGER;
283: TYPE xml_dom_elements_tbl_type IS TABLE OF xmldom.DOMNode INDEX BY BINARY_INTEGER;

Line 371: g_UI_Context CZ_UI_DEFS%ROWTYPE;

367:
368: g_Use_Cache BOOLEAN := FALSE;
369: g_REFRESH_MODEL_PATH BOOLEAN := TRUE;
370:
371: g_UI_Context CZ_UI_DEFS%ROWTYPE;
372:
373: g_using_new_UI_refresh BOOLEAN;
374:
375: g_ELEMENT_COUNTER NUMBER;

Line 1084: SELECT * INTO g_local_ui_context(p_ui_def_id) FROM CZ_UI_DEFS

1080:
1081: PROCEDURE set_Local_UI_Context(p_ui_def_id IN NUMBER) IS
1082: BEGIN
1083: IF NOT(g_local_ui_context.EXISTS(p_ui_def_id)) THEN
1084: SELECT * INTO g_local_ui_context(p_ui_def_id) FROM CZ_UI_DEFS
1085: WHERE ui_def_id=p_ui_def_id;
1086: END IF;
1087: END set_Local_UI_Context;
1088:

Line 1089: FUNCTION get_Local_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS

1085: WHERE ui_def_id=p_ui_def_id;
1086: END IF;
1087: END set_Local_UI_Context;
1088:
1089: FUNCTION get_Local_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1090: BEGIN
1091: IF NOT(g_local_ui_context.EXISTS(p_ui_def_id)) THEN
1092: SELECT * INTO g_local_ui_context(p_ui_def_id)
1093: FROM CZ_UI_DEFS

Line 1093: FROM CZ_UI_DEFS

1089: FUNCTION get_Local_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1090: BEGIN
1091: IF NOT(g_local_ui_context.EXISTS(p_ui_def_id)) THEN
1092: SELECT * INTO g_local_ui_context(p_ui_def_id)
1093: FROM CZ_UI_DEFS
1094: WHERE ui_def_id=p_ui_def_id;
1095: END IF;
1096: RETURN g_local_ui_context(p_ui_def_id);
1097: END get_Local_UI_Context;

Line 1140: UPDATE CZ_UI_DEFS

1136: --
1137: PROCEDURE mark_UI(p_ui_def_id IN NUMBER,
1138: p_ui_status IN VARCHAR2) IS
1139: BEGIN
1140: UPDATE CZ_UI_DEFS
1141: SET ui_status=p_ui_status
1142: WHERE ui_def_id=p_ui_def_id;
1143: END mark_UI;
1144:

Line 1525: -- return CZ_UI_DEFS data of Master Template Settings

1521: RETURN l_str;
1522: END get_Short_JRAD_Name;
1523:
1524: --
1525: -- return CZ_UI_DEFS data of Master Template Settings
1526: --
1527: FUNCTION get_UI_Def_Node(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1528: BEGIN
1529: --

Line 1527: FUNCTION get_UI_Def_Node(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS

1523:
1524: --
1525: -- return CZ_UI_DEFS data of Master Template Settings
1526: --
1527: FUNCTION get_UI_Def_Node(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1528: BEGIN
1529: --
1530: -- if cache contains given ui_def_id then get it from cache
1531: --

Line 1534: FROM CZ_UI_DEFS

1530: -- if cache contains given ui_def_id then get it from cache
1531: --
1532: IF NOT(g_ui_def_nodes_tbl.EXISTS(p_ui_def_id)) THEN
1533: SELECT * INTO g_ui_def_nodes_tbl(p_ui_def_id)
1534: FROM CZ_UI_DEFS
1535: WHERE ui_def_id = p_ui_def_id;
1536: END IF;
1537: RETURN g_ui_def_nodes_tbl(p_ui_def_id);
1538: END get_UI_Def_Node;

Line 1962: SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS

1958: END IF;
1959:
1960: IF l_seeded_flag='0' OR l_seeded_flag IS NULL THEN
1961: IF p_target_ui_def_id IS NOT NULL AND p_target_ui_def_id<>0 THEN
1962: SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS
1963: WHERE ui_def_id=p_target_ui_def_id;
1964: END IF;
1965: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1966:

Line 5323: l_ui_name CZ_UI_DEFS.name%TYPE;

5319: p_is_parser_open IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
5320:
5321: l_xmldoc xmldom.DOMDocument;
5322: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5323: l_ui_name CZ_UI_DEFS.name%TYPE;
5324: l_page_name CZ_UI_PAGES.name%TYPE;
5325: l_element_path VARCHAR2(32000);
5326:
5327: BEGIN

Line 5352: SELECT name INTO l_ui_name FROM CZ_UI_DEFS

5348: IF p_is_parser_open IS NULL OR p_is_parser_open='0' THEN
5349: Close_Parser();
5350: END IF;
5351:
5352: SELECT name INTO l_ui_name FROM CZ_UI_DEFS
5353: WHERE ui_def_id=p_ui_def_id;
5354:
5355: IF l_element_path IS NULL OR l_element_path='.' THEN
5356: l_element_path := l_ui_name||'.'||'Pages'||'.'||l_page_name;

Line 5653: l_ui_def_node CZ_UI_DEFS%ROWTYPE;

5649: l_new_action_id NUMBER;
5650: l_new_rule_id NUMBER;
5651: l_persistent_rule_id NUMBER;
5652: l_new_intl_text_id NUMBER;
5653: l_ui_def_node CZ_UI_DEFS%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;

Line 5654: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;

5650: l_new_rule_id NUMBER;
5651: l_persistent_rule_id NUMBER;
5652: l_new_intl_text_id NUMBER;
5653: l_ui_def_node CZ_UI_DEFS%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;

Line 9075: FUNCTION get_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS

9071:
9072: --
9073: -- get UI context
9074: --
9075: FUNCTION get_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
9076: BEGIN
9077: RETURN get_UI_Def_Node(p_ui_def_id);
9078: END get_UI_Context;
9079:

Line 9109: RETURN CZ_UI_DEFS%ROWTYPE IS

9105: p_ui_name IN VARCHAR2 DEFAULT NULL,
9106: p_description IN VARCHAR2 DEFAULT NULL,
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;

Line 9137: g_UI_Context.ui_def_id := allocateId('CZ_UI_DEFS_S');

9133:
9134: --
9135: -- allocate a new ui_def_id for new UI
9136: --
9137: g_UI_Context.ui_def_id := allocateId('CZ_UI_DEFS_S');
9138: g_UI_Context.devl_project_id := p_model_id;
9139: g_UI_Context.component_id := p_model_id;
9140: g_UI_Context.master_template_flag := G_NO_FLAG;
9141: g_UI_Context.seeded_flag := G_NO_FLAG;

Line 9173: FROM CZ_UI_DEFS

9169: -- count number of UIs for a given model
9170: --
9171: SELECT COUNT(ui_def_id) + 1
9172: INTO g_UI_Context.tree_seq
9173: FROM CZ_UI_DEFS
9174: WHERE component_id = p_model_id AND
9175: deleted_flag = G_NO_FLAG;
9176:
9177: IF p_ui_name IS NULL THEN

Line 9193: INSERT INTO CZ_UI_DEFS

9189: -- create local UI Templates if they need to be created
9190: --
9191: create_Local_UI_Templates();
9192:
9193: INSERT INTO CZ_UI_DEFS
9194: (UI_DEF_ID,
9195: DESC_TEXT,
9196: NAME,
9197: DEVL_PROJECT_ID,

Line 9321: FROM CZ_UI_DEFS

9317: SYSDATE,
9318: DRILLDOWN_TX_TYPE,
9319: CONTENT_LAST_UPDATE_DATE,
9320: DISABLE_AUTOOVERRIDE_FLAG
9321: FROM CZ_UI_DEFS
9322: WHERE ui_def_id = g_UI_Context.from_master_template_id;
9323:
9324: --
9325: -- get root model node

Line 9340: UPDATE CZ_UI_DEFS

9336:
9337: g_UI_Context.start_page_id := l_page_ui_node.page_id;
9338: g_UI_Context.page_set_id := l_page_set_id;
9339:
9340: UPDATE CZ_UI_DEFS
9341: SET start_page_id=g_UI_Context.start_page_id,
9342: page_set_id=g_UI_Context.page_set_id
9343: WHERE ui_def_id=g_UI_Context.ui_def_id;
9344:

Line 9352: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,

9348:
9349: --
9350: -- get UI context of target UI
9351: --
9352: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
9353: p_reference_id IN NUMBER)
9354: RETURN CZ_UI_DEFS%ROWTYPE IS
9355: l_init_ui_def_id NUMBER;
9356: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

Line 9354: RETURN CZ_UI_DEFS%ROWTYPE IS

9350: -- get UI context of target UI
9351: --
9352: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
9353: p_reference_id IN NUMBER)
9354: RETURN CZ_UI_DEFS%ROWTYPE IS
9355: l_init_ui_def_id NUMBER;
9356: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
9357: l_old_context CZ_UI_DEFS%ROWTYPE;
9358: BEGIN

Line 9356: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

9352: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
9353: p_reference_id IN NUMBER)
9354: RETURN CZ_UI_DEFS%ROWTYPE IS
9355: l_init_ui_def_id NUMBER;
9356: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
9357: l_old_context CZ_UI_DEFS%ROWTYPE;
9358: BEGIN
9359: l_init_ui_def_id := p_ui_def_node.ui_def_id;
9360: l_old_context := g_UI_Context;

Line 9357: l_old_context CZ_UI_DEFS%ROWTYPE;

9353: p_reference_id IN NUMBER)
9354: RETURN CZ_UI_DEFS%ROWTYPE IS
9355: l_init_ui_def_id NUMBER;
9356: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
9357: l_old_context CZ_UI_DEFS%ROWTYPE;
9358: BEGIN
9359: l_init_ui_def_id := p_ui_def_node.ui_def_id;
9360: l_old_context := g_UI_Context;
9361:

Line 9364: FROM CZ_UI_DEFS

9360: l_old_context := g_UI_Context;
9361:
9362: SELECT *
9363: INTO l_target_ui_def_node
9364: FROM CZ_UI_DEFS
9365: WHERE ui_def_id = (SELECT MAX(ui_def_id)
9366: FROM CZ_UI_DEFS
9367: WHERE devl_project_id = p_reference_id AND
9368: ui_status IN (G_PROCESSED_UI_STATUS,G_NEW_UI_STATUS) AND

Line 9366: FROM CZ_UI_DEFS

9362: SELECT *
9363: INTO l_target_ui_def_node
9364: FROM CZ_UI_DEFS
9365: WHERE ui_def_id = (SELECT MAX(ui_def_id)
9366: FROM CZ_UI_DEFS
9367: WHERE devl_project_id = p_reference_id AND
9368: ui_status IN (G_PROCESSED_UI_STATUS,G_NEW_UI_STATUS) AND
9369: deleted_flag = G_NO_FLAG);
9370:

Line 11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

11341: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
11342:
11343: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
11344: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
11345: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
11346: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
11347: l_ui_action_id CZ_UI_ACTIONS.ui_action_id%TYPE;
11348: l_max_seq_nbr CZ_UI_PAGE_ELEMENTS.seq_nbr%TYPE;
11349: l_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

Line 12007: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b

12003: UPDATE CZ_UI_PAGE_REFS uiref
12004: SET deleted_flag=G_YES_FLAG
12005: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
12006: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
12007: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
12008: WHERE b.ui_def_id=p_ui_def_id) AND
12009: persistent_node_id=uiref.target_persistent_node_id AND deleted_flag=G_NO_FLAG)
12010: AND deleted_flag=G_NO_FLAG;
12011:

Line 12016: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b

12012: UPDATE CZ_UI_REFS uiref
12013: SET deleted_flag=G_YES_FLAG
12014: WHERE ui_def_id=p_ui_def_id AND
12015: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
12016: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
12017: WHERE b.ui_def_id=p_ui_def_id) AND
12018: persistent_node_id=uiref.ref_persistent_node_id AND deleted_flag=G_NO_FLAG)
12019: AND deleted_flag=G_NO_FLAG;
12020:

Line 14606: FUNCTION getInstanceListAMN(p_ui_def_id IN CZ_UI_DEFS.ui_def_Id%TYPE,

14602: --vsingava IM-ER
14603: -- Finds an Instance List containing the xml node passed in and returns its AMN
14604: -- This function also checks the node passed in itself i.e. if the node passed in is
14605: -- an Instance List, then the function will return its AMN
14606: FUNCTION getInstanceListAMN(p_ui_def_id IN CZ_UI_DEFS.ui_def_Id%TYPE,
14607: p_page_id IN CZ_UI_PAGES.page_id%TYPE,
14608: p_xml_node IN xmldom.DOMNode) RETURN expl_node_persistent_id_pair
14609: IS
14610:

Line 16905: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs

16901: RETURN FALSE;
16902: ELSE
16903: SELECT instantiable_flag INTO l_instantiable_flag
16904: FROM cz_ps_nodes
16905: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16906: WHERE ui_def_id = p_ui_def_id) AND
16907: persistent_node_id = p_node_persistent_id;
16908: RETURN (l_instantiable_flag IS NULL OR
16909: l_instantiable_flag NOT IN (G_OPTIONAL_INST_TYPE, G_MINMAX_INST_TYPE));

Line 16939: l_name CZ_UI_DEFS.NAME%TYPE;

16935: l_target_persistent_node_id NUMBER;
16936:
16937: FUNCTION get_ui_name(p_ui_def_id IN NUMBER)
16938: RETURN VARCHAR2 IS
16939: l_name CZ_UI_DEFS.NAME%TYPE;
16940: BEGIN
16941: SELECT name INTO l_name
16942: FROM cz_ui_defs
16943: WHERE ui_def_id = p_ui_def_id;

Line 16942: FROM cz_ui_defs

16938: RETURN VARCHAR2 IS
16939: l_name CZ_UI_DEFS.NAME%TYPE;
16940: BEGIN
16941: SELECT name INTO l_name
16942: FROM cz_ui_defs
16943: WHERE ui_def_id = p_ui_def_id;
16944: RETURN l_name;
16945: END;
16946:

Line 16953: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs

16949: l_name CZ_DEVL_PROJECTS.NAME%TYPE;
16950: BEGIN
16951: SELECT name INTO l_name
16952: FROM cz_devl_projects
16953: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16954: WHERE ui_def_id = p_ui_def_id);
16955: RETURN l_name;
16956: END;
16957:

Line 17133: UPDATE cz_ui_defs

17129: G_USER_ATTRIBUTE1_NAME,
17130: l_new_relative_path);
17131: l_resave_doc_flag := 1; -- save doc
17132: ELSE
17133: UPDATE cz_ui_defs
17134: SET ui_status = 'NEED_REFRESH'
17135: WHERE ui_def_id = l_ui_def_id;
17136: l_flag := 0; -- goto next ui
17137: END IF;

Line 17239: UPDATE cz_ui_defs

17235: -- populate cache
17236: populate_Cache;
17237:
17238: -- update the UI_TIMESTAMP_REFRESH date on the UI
17239: UPDATE cz_ui_defs
17240: SET UI_TIMESTAMP_REFRESH = SYSDATE
17241: WHERE ui_def_id = p_ui_def_id;
17242:
17243: -- populate CZ UI structures first

Line 17279: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

17275: -- internal procedure to create/refresh UI
17276: --
17277: PROCEDURE handle_UIs(p_ui_def_id IN NUMBER,
17278: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
17279: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
17280: l_ui_def_id NUMBER;
17281: l_ref_persistent_node_id NUMBER;
17282: l_init_ui_def_id NUMBER;
17283: BEGIN

Line 17304: FROM CZ_UI_DEFS

17300: ps_node_type=G_REFERENCE_TYPE AND deleted_flag='0')
17301: LOOP
17302: BEGIN
17303: SELECT NVL(MAX(ui_def_id),0) INTO l_ui_def_id
17304: FROM CZ_UI_DEFS
17305: WHERE devl_project_id=i.component_id AND
17306: ui_style=G_OA_STYLE_UI AND
17307: deleted_flag='0';
17308:

Line 17415: l_ui_context CZ_UI_DEFS%ROWTYPE;

17411: x_return_status OUT NOCOPY VARCHAR2,
17412: x_msg_count OUT NOCOPY NUMBER,
17413: x_msg_data OUT NOCOPY VARCHAR2) IS
17414:
17415: l_ui_context CZ_UI_DEFS%ROWTYPE;
17416: l_locked_models cz_security_pvt.number_type_tbl;
17417:
17418: BEGIN
17419:

Line 17427: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )

17423: Initialize(x_return_status,x_msg_count,x_msg_data);
17424:
17425: --
17426: -- get UI context
17427: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )
17428: --
17429: l_ui_context := create_UI_Context(p_model_id => p_model_id,
17430: p_master_template_id => p_master_template_id,
17431: p_ui_name => p_ui_name,

Line 17449: UPDATE CZ_UI_DEFS

17445: construct_UI(l_ui_context.ui_def_id);
17446:
17447: IF p_create_empty_ui IS NOT NULL AND p_create_empty_ui = '1' THEN
17448:
17449: UPDATE CZ_UI_DEFS
17450: SET suppress_refresh_flag = G_NO_FLAG
17451: WHERE ui_def_id = x_ui_def_id and deleted_flag = G_NO_FLAG;
17452:
17453: UPDATE CZ_UI_DEFS

Line 17453: UPDATE CZ_UI_DEFS

17449: UPDATE CZ_UI_DEFS
17450: SET suppress_refresh_flag = G_NO_FLAG
17451: WHERE ui_def_id = x_ui_def_id and deleted_flag = G_NO_FLAG;
17452:
17453: UPDATE CZ_UI_DEFS
17454: SET suppress_refresh_flag = G_NO_FLAG
17455: WHERE ui_def_Id IN (
17456: SELECT ref_ui_def_Id
17457: FROM CZ_UI_REFS

Line 17534: UNION SELECT ui_def_id FROM CZ_UI_DEFS uiDef WHERE uiDef.ui_def_id = p_ui_def_id AND uiDef.ui_style = G_OA_STYLE_UI AND deleted_flag = G_NO_FLAG )

17530: FOR uiDefCur IN (SELECT ref_ui_def_id FROM (SELECT DISTINCT ref_ui_def_id
17531: FROM CZ_UI_REFS
17532: START WITH ui_def_id = p_ui_def_id AND deleted_flag = G_NO_FLAG
17533: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = G_NO_FLAG AND PRIOR deleted_flag = G_NO_FLAG
17534: UNION SELECT ui_def_id FROM CZ_UI_DEFS uiDef WHERE uiDef.ui_def_id = p_ui_def_id AND uiDef.ui_style = G_OA_STYLE_UI AND deleted_flag = G_NO_FLAG )
17535:
17536: )
17537: LOOP
17538:

Line 17657: l_ui_context CZ_UI_DEFS%ROWTYPE;

17653: x_return_status OUT NOCOPY VARCHAR2,
17654: x_msg_count OUT NOCOPY NUMBER,
17655: x_msg_data OUT NOCOPY VARCHAR2) IS
17656:
17657: l_ui_context CZ_UI_DEFS%ROWTYPE;
17658: BEGIN
17659: --
17660: -- initialize FND variables/packages
17661: --

Line 18115: l_ui_name CZ_UI_DEFS.name%TYPE;

18111: l_element_id_tbl varchar_tbl_type;
18112: l_name_tbl varchar_tbl_type;
18113: l_target_page_ui_def_id_tbl number_tbl_type;
18114: l_target_page_id_tbl number_tbl_type;
18115: l_ui_name CZ_UI_DEFS.name%TYPE;
18116: l_page_name CZ_UI_PAGES.name%TYPE;
18117: l_pagebase_expl_id NUMBER;
18118: l_ui_def_id NUMBER;
18119: l_target_persistent_node_id NUMBER;

Line 18141: SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);

18137: FOR i IN l_name_tbl.First..l_name_tbl.Last
18138: LOOP
18139: SELECT name INTO l_page_name FROM CZ_UI_PAGES
18140: WHERE page_id=l_target_page_id_tbl(i) AND ui_def_id=l_target_page_ui_def_id_tbl(i);
18141: SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);
18142: add_Error_Message(p_message_name => 'CZ_CP_PIR_REF_UI_NOT_IN_CHAIN',
18143: p_token_name1 => 'RGNNAME',
18144: p_token_value1 => NVL(l_name_tbl(i), l_element_id_tbl(i)),
18145: p_token_name2 => 'PAGENAME',

Line 18737: l_ui_context CZ_UI_DEFS%ROWTYPE;

18733: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
18734: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
18735: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
18736: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18737: l_ui_context CZ_UI_DEFS%ROWTYPE;
18738: l_condition_id NUMBER;
18739: l_caption_text_id NUMBER;
18740: l_caption_rule_id NUMBER;
18741: l_display_condition_id NUMBER;

Line 19006: l_ui_context CZ_UI_DEFS%ROWTYPE;

19002: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
19003: ) IS
19004:
19005: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
19006: l_ui_context CZ_UI_DEFS%ROWTYPE;
19007: l_page_id CZ_UI_PAGES.page_id%TYPE;
19008: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
19009: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
19010:

Line 21675: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;

21671: x_msg_count OUT NOCOPY NUMBER, -- number of error messages
21672: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
21673: ) IS
21674:
21675: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
21676: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
21677: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
21678: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

Line 21676: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;

21672: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
21673: ) IS
21674:
21675: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
21676: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
21677: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
21678: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
21679: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
21680: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;

Line 21701: FROM CZ_UI_DEFS

21697: -- get primary_navigation, page_set_id of target UI
21698: --
21699: SELECT primary_navigation, page_set_id
21700: INTO l_target_primary_navigation, l_target_page_set_id
21701: FROM CZ_UI_DEFS
21702: WHERE ui_def_id=p_new_target_ui_def_id;
21703:
21704: IF l_target_primary_navigation <> G_MODEL_TREE_MENU THEN
21705:

Line 21856: l_ui_context CZ_UI_DEFS%ROWTYPE;

21852: p_show_all_nodes IN VARCHAR2 DEFAULT NULL,
21853: p_create_empty_ui IN VARCHAR2 DEFAULT NULL,
21854: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
21855:
21856: l_ui_context CZ_UI_DEFS%ROWTYPE;
21857: l_return_status VARCHAR2(255);
21858: l_msg_count NUMBER;
21859: l_msg_data VARCHAR2(255);
21860:

Line 21869: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )

21865: g_Use_Cache := FALSE;
21866:
21867: --
21868: -- get UI context
21869: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )
21870: --
21871: l_ui_context := create_UI_Context(p_model_id => p_model_id,
21872: p_master_template_id => p_master_template_id,
21873: p_ui_name => p_ui_name,

Line 21890: l_ui_context CZ_UI_DEFS%ROWTYPE;

21886:
21887: PROCEDURE rui(p_ui_def_id IN NUMBER,
21888: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
21889:
21890: l_ui_context CZ_UI_DEFS%ROWTYPE;
21891: l_return_status VARCHAR2(255);
21892: l_msg_count NUMBER;
21893: l_msg_data VARCHAR2(255);
21894: