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 1078: SELECT * INTO g_local_ui_context(p_ui_def_id) FROM CZ_UI_DEFS

1074:
1075: PROCEDURE set_Local_UI_Context(p_ui_def_id IN NUMBER) IS
1076: BEGIN
1077: IF NOT(g_local_ui_context.EXISTS(p_ui_def_id)) THEN
1078: SELECT * INTO g_local_ui_context(p_ui_def_id) FROM CZ_UI_DEFS
1079: WHERE ui_def_id=p_ui_def_id;
1080: END IF;
1081: END set_Local_UI_Context;
1082:

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

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

Line 1087: FROM CZ_UI_DEFS

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

Line 1134: UPDATE CZ_UI_DEFS

1130: --
1131: PROCEDURE mark_UI(p_ui_def_id IN NUMBER,
1132: p_ui_status IN VARCHAR2) IS
1133: BEGIN
1134: UPDATE CZ_UI_DEFS
1135: SET ui_status=p_ui_status
1136: WHERE ui_def_id=p_ui_def_id;
1137: END mark_UI;
1138:

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

1515: RETURN l_str;
1516: END get_Short_JRAD_Name;
1517:
1518: --
1519: -- return CZ_UI_DEFS data of Master Template Settings
1520: --
1521: FUNCTION get_UI_Def_Node(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1522: BEGIN
1523: --

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

1517:
1518: --
1519: -- return CZ_UI_DEFS data of Master Template Settings
1520: --
1521: FUNCTION get_UI_Def_Node(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
1522: BEGIN
1523: --
1524: -- if cache contains given ui_def_id then get it from cache
1525: --

Line 1528: FROM CZ_UI_DEFS

1524: -- if cache contains given ui_def_id then get it from cache
1525: --
1526: IF NOT(g_ui_def_nodes_tbl.EXISTS(p_ui_def_id)) THEN
1527: SELECT * INTO g_ui_def_nodes_tbl(p_ui_def_id)
1528: FROM CZ_UI_DEFS
1529: WHERE ui_def_id = p_ui_def_id;
1530: END IF;
1531: RETURN g_ui_def_nodes_tbl(p_ui_def_id);
1532: END get_UI_Def_Node;

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

1902: END IF;
1903:
1904: IF l_seeded_flag='0' OR l_seeded_flag IS NULL THEN
1905: IF p_target_ui_def_id IS NOT NULL AND p_target_ui_def_id<>0 THEN
1906: SELECT NVL(devl_project_id,0) INTO l_model_id FROM CZ_UI_DEFS
1907: WHERE ui_def_id=p_target_ui_def_id;
1908: END IF;
1909: l_ui_intl_text_id := allocateId('CZ_INTL_TEXTS_S');
1910:

Line 5198: l_ui_name CZ_UI_DEFS.name%TYPE;

5194: p_is_parser_open IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2 IS
5195:
5196: l_xmldoc xmldom.DOMDocument;
5197: l_page_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
5198: l_ui_name CZ_UI_DEFS.name%TYPE;
5199: l_page_name CZ_UI_PAGES.name%TYPE;
5200: l_element_path VARCHAR2(32000);
5201:
5202: BEGIN

Line 5227: SELECT name INTO l_ui_name FROM CZ_UI_DEFS

5223: IF p_is_parser_open IS NULL OR p_is_parser_open='0' THEN
5224: Close_Parser();
5225: END IF;
5226:
5227: SELECT name INTO l_ui_name FROM CZ_UI_DEFS
5228: WHERE ui_def_id=p_ui_def_id;
5229:
5230: IF l_element_path IS NULL OR l_element_path='.' THEN
5231: l_element_path := l_ui_name||'.'||'Pages'||'.'||l_page_name;

Line 5473: l_ui_def_node CZ_UI_DEFS%ROWTYPE;

5469: l_id NUMBER;
5470: l_new_action_id NUMBER;
5471: l_new_rule_id NUMBER;
5472: l_new_intl_text_id NUMBER;
5473: l_ui_def_node CZ_UI_DEFS%ROWTYPE;
5474: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;
5475: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;
5476:
5477: BEGIN

Line 5474: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;

5470: l_new_action_id NUMBER;
5471: l_new_rule_id NUMBER;
5472: l_new_intl_text_id NUMBER;
5473: l_ui_def_node CZ_UI_DEFS%ROWTYPE;
5474: l_prev_ui_context CZ_UI_DEFS%ROWTYPE;
5475: l_new_target_node_path CZ_UI_ACTIONS.target_node_path%TYPE;
5476:
5477: BEGIN
5478:

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

8611:
8612: --
8613: -- get UI context
8614: --
8615: FUNCTION get_UI_Context(p_ui_def_id IN NUMBER) RETURN CZ_UI_DEFS%ROWTYPE IS
8616: BEGIN
8617: RETURN get_UI_Def_Node(p_ui_def_id);
8618: END get_UI_Context;
8619:

Line 8649: RETURN CZ_UI_DEFS%ROWTYPE IS

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

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

8673:
8674: --
8675: -- allocate a new ui_def_id for new UI
8676: --
8677: g_UI_Context.ui_def_id := allocateId('CZ_UI_DEFS_S');
8678: g_UI_Context.devl_project_id := p_model_id;
8679: g_UI_Context.component_id := p_model_id;
8680: g_UI_Context.master_template_flag := G_NO_FLAG;
8681: g_UI_Context.seeded_flag := G_NO_FLAG;

Line 8713: FROM CZ_UI_DEFS

8709: -- count number of UIs for a given model
8710: --
8711: SELECT COUNT(ui_def_id) + 1
8712: INTO g_UI_Context.tree_seq
8713: FROM CZ_UI_DEFS
8714: WHERE component_id = p_model_id AND
8715: deleted_flag = G_NO_FLAG;
8716:
8717: IF p_ui_name IS NULL THEN

Line 8733: INSERT INTO CZ_UI_DEFS

8729: -- create local UI Templates if they need to be created
8730: --
8731: create_Local_UI_Templates();
8732:
8733: INSERT INTO CZ_UI_DEFS
8734: (UI_DEF_ID,
8735: DESC_TEXT,
8736: NAME,
8737: DEVL_PROJECT_ID,

Line 8861: FROM CZ_UI_DEFS

8857: SYSDATE,
8858: DRILLDOWN_TX_TYPE,
8859: CONTENT_LAST_UPDATE_DATE,
8860: DISABLE_AUTOOVERRIDE_FLAG
8861: FROM CZ_UI_DEFS
8862: WHERE ui_def_id = g_UI_Context.from_master_template_id;
8863:
8864: --
8865: -- get root model node

Line 8880: UPDATE CZ_UI_DEFS

8876:
8877: g_UI_Context.start_page_id := l_page_ui_node.page_id;
8878: g_UI_Context.page_set_id := l_page_set_id;
8879:
8880: UPDATE CZ_UI_DEFS
8881: SET start_page_id=g_UI_Context.start_page_id,
8882: page_set_id=g_UI_Context.page_set_id
8883: WHERE ui_def_id=g_UI_Context.ui_def_id;
8884:

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

8888:
8889: --
8890: -- get UI context of target UI
8891: --
8892: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
8893: p_reference_id IN NUMBER)
8894: RETURN CZ_UI_DEFS%ROWTYPE IS
8895: l_init_ui_def_id NUMBER;
8896: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

Line 8894: RETURN CZ_UI_DEFS%ROWTYPE IS

8890: -- get UI context of target UI
8891: --
8892: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
8893: p_reference_id IN NUMBER)
8894: RETURN CZ_UI_DEFS%ROWTYPE IS
8895: l_init_ui_def_id NUMBER;
8896: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
8897: l_old_context CZ_UI_DEFS%ROWTYPE;
8898: BEGIN

Line 8896: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

8892: FUNCTION get_Target_UI_Context(p_ui_def_node IN CZ_UI_DEFS%ROWTYPE,
8893: p_reference_id IN NUMBER)
8894: RETURN CZ_UI_DEFS%ROWTYPE IS
8895: l_init_ui_def_id NUMBER;
8896: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
8897: l_old_context CZ_UI_DEFS%ROWTYPE;
8898: BEGIN
8899: l_init_ui_def_id := p_ui_def_node.ui_def_id;
8900: l_old_context := g_UI_Context;

Line 8897: l_old_context CZ_UI_DEFS%ROWTYPE;

8893: p_reference_id IN NUMBER)
8894: RETURN CZ_UI_DEFS%ROWTYPE IS
8895: l_init_ui_def_id NUMBER;
8896: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
8897: l_old_context CZ_UI_DEFS%ROWTYPE;
8898: BEGIN
8899: l_init_ui_def_id := p_ui_def_node.ui_def_id;
8900: l_old_context := g_UI_Context;
8901:

Line 8904: FROM CZ_UI_DEFS

8900: l_old_context := g_UI_Context;
8901:
8902: SELECT *
8903: INTO l_target_ui_def_node
8904: FROM CZ_UI_DEFS
8905: WHERE ui_def_id = (SELECT MAX(ui_def_id)
8906: FROM CZ_UI_DEFS
8907: WHERE devl_project_id = p_reference_id AND
8908: ui_status IN (G_PROCESSED_UI_STATUS,G_NEW_UI_STATUS) AND

Line 8906: FROM CZ_UI_DEFS

8902: SELECT *
8903: INTO l_target_ui_def_node
8904: FROM CZ_UI_DEFS
8905: WHERE ui_def_id = (SELECT MAX(ui_def_id)
8906: FROM CZ_UI_DEFS
8907: WHERE devl_project_id = p_reference_id AND
8908: ui_status IN (G_PROCESSED_UI_STATUS,G_NEW_UI_STATUS) AND
8909: deleted_flag = G_NO_FLAG);
8910:

Line 10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

10862: RETURN CZ_UI_PAGE_ELEMENTS%ROWTYPE IS
10863:
10864: l_ui_node CZ_UI_PAGE_ELEMENTS%ROWTYPE;
10865: l_page_ref_node CZ_UI_PAGE_REFS%ROWTYPE;
10866: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
10867: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
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;

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

11524: UPDATE CZ_UI_PAGE_REFS uiref
11525: SET deleted_flag=G_YES_FLAG
11526: WHERE ui_def_id=p_ui_def_id AND target_ui_def_id IS NOT NULL AND
11527: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
11528: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
11529: WHERE b.ui_def_id=p_ui_def_id) AND
11530: persistent_node_id=uiref.target_persistent_node_id AND deleted_flag=G_NO_FLAG)
11531: AND deleted_flag=G_NO_FLAG;
11532:

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

11533: UPDATE CZ_UI_REFS uiref
11534: SET deleted_flag=G_YES_FLAG
11535: WHERE ui_def_id=p_ui_def_id AND
11536: NOT EXISTS(SELECT NULL FROM CZ_PS_NODES a
11537: WHERE a.devl_project_id=(SELECT b.devl_project_id FROM CZ_UI_DEFS b
11538: WHERE b.ui_def_id=p_ui_def_id) AND
11539: persistent_node_id=uiref.ref_persistent_node_id AND deleted_flag=G_NO_FLAG)
11540: AND deleted_flag=G_NO_FLAG;
11541:

Line 16241: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs

16237: RETURN FALSE;
16238: ELSE
16239: SELECT instantiable_flag INTO l_instantiable_flag
16240: FROM cz_ps_nodes
16241: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16242: WHERE ui_def_id = p_ui_def_id) AND
16243: persistent_node_id = p_node_persistent_id;
16244: RETURN (l_instantiable_flag IS NULL OR
16245: l_instantiable_flag NOT IN (G_OPTIONAL_INST_TYPE, G_MINMAX_INST_TYPE));

Line 16275: l_name CZ_UI_DEFS.NAME%TYPE;

16271: l_target_persistent_node_id NUMBER;
16272:
16273: FUNCTION get_ui_name(p_ui_def_id IN NUMBER)
16274: RETURN VARCHAR2 IS
16275: l_name CZ_UI_DEFS.NAME%TYPE;
16276: BEGIN
16277: SELECT name INTO l_name
16278: FROM cz_ui_defs
16279: WHERE ui_def_id = p_ui_def_id;

Line 16278: FROM cz_ui_defs

16274: RETURN VARCHAR2 IS
16275: l_name CZ_UI_DEFS.NAME%TYPE;
16276: BEGIN
16277: SELECT name INTO l_name
16278: FROM cz_ui_defs
16279: WHERE ui_def_id = p_ui_def_id;
16280: RETURN l_name;
16281: END;
16282:

Line 16289: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs

16285: l_name CZ_DEVL_PROJECTS.NAME%TYPE;
16286: BEGIN
16287: SELECT name INTO l_name
16288: FROM cz_devl_projects
16289: WHERE devl_project_id = (SELECT devl_project_id FROM cz_ui_defs
16290: WHERE ui_def_id = p_ui_def_id);
16291: RETURN l_name;
16292: END;
16293:

Line 16482: UPDATE cz_ui_defs

16478: SET page_rev_nbr = page_rev_nbr + 1
16479: WHERE ui_def_id = l_ui_def_id AND page_id = i.page_id;
16480: l_resave_doc_flag := 1; -- save doc
16481: ELSE
16482: UPDATE cz_ui_defs
16483: SET ui_status = 'NEED_REFRESH'
16484: WHERE ui_def_id = l_ui_def_id;
16485: l_flag := 0; -- goto next ui
16486: END IF;

Line 16527: UPDATE cz_ui_defs

16523: -- populate cache
16524: populate_Cache;
16525:
16526: -- update the UI_TIMESTAMP_REFRESH date on the UI
16527: UPDATE cz_ui_defs
16528: SET UI_TIMESTAMP_REFRESH = SYSDATE
16529: WHERE ui_def_id = p_ui_def_id;
16530:
16531: -- populate CZ UI structures first

Line 16567: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;

16563: -- internal procedure to create/refresh UI
16564: --
16565: PROCEDURE handle_UIs(p_ui_def_id IN NUMBER,
16566: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
16567: l_target_ui_def_node CZ_UI_DEFS%ROWTYPE;
16568: l_ui_def_id NUMBER;
16569: l_ref_persistent_node_id NUMBER;
16570: l_init_ui_def_id NUMBER;
16571: BEGIN

Line 16592: FROM CZ_UI_DEFS

16588: ps_node_type=G_REFERENCE_TYPE AND deleted_flag='0')
16589: LOOP
16590: BEGIN
16591: SELECT NVL(MAX(ui_def_id),0) INTO l_ui_def_id
16592: FROM CZ_UI_DEFS
16593: WHERE devl_project_id=i.component_id AND
16594: ui_style=G_OA_STYLE_UI AND
16595: deleted_flag='0';
16596:

Line 16703: l_ui_context CZ_UI_DEFS%ROWTYPE;

16699: x_return_status OUT NOCOPY VARCHAR2,
16700: x_msg_count OUT NOCOPY NUMBER,
16701: x_msg_data OUT NOCOPY VARCHAR2) IS
16702:
16703: l_ui_context CZ_UI_DEFS%ROWTYPE;
16704: l_locked_models cz_security_pvt.number_type_tbl;
16705:
16706: BEGIN
16707:

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

16711: Initialize(x_return_status,x_msg_count,x_msg_data);
16712:
16713: --
16714: -- get UI context
16715: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )
16716: --
16717: l_ui_context := create_UI_Context(p_model_id => p_model_id,
16718: p_master_template_id => p_master_template_id,
16719: p_ui_name => p_ui_name,

Line 16737: UPDATE CZ_UI_DEFS

16733: construct_UI(l_ui_context.ui_def_id);
16734:
16735: IF p_create_empty_ui IS NOT NULL AND p_create_empty_ui = '1' THEN
16736:
16737: UPDATE CZ_UI_DEFS
16738: SET suppress_refresh_flag = G_NO_FLAG
16739: WHERE ui_def_id = x_ui_def_id and deleted_flag = G_NO_FLAG;
16740:
16741: UPDATE CZ_UI_DEFS

Line 16741: UPDATE CZ_UI_DEFS

16737: UPDATE CZ_UI_DEFS
16738: SET suppress_refresh_flag = G_NO_FLAG
16739: WHERE ui_def_id = x_ui_def_id and deleted_flag = G_NO_FLAG;
16740:
16741: UPDATE CZ_UI_DEFS
16742: SET suppress_refresh_flag = G_NO_FLAG
16743: WHERE ui_def_Id IN (
16744: SELECT ref_ui_def_Id
16745: FROM CZ_UI_REFS

Line 16810: l_ui_context CZ_UI_DEFS%ROWTYPE;

16806: x_return_status OUT NOCOPY VARCHAR2,
16807: x_msg_count OUT NOCOPY NUMBER,
16808: x_msg_data OUT NOCOPY VARCHAR2) IS
16809:
16810: l_ui_context CZ_UI_DEFS%ROWTYPE;
16811: BEGIN
16812: --
16813: -- initialize FND variables/packages
16814: --

Line 17265: l_ui_name CZ_UI_DEFS.name%TYPE;

17261: l_element_id_tbl varchar_tbl_type;
17262: l_name_tbl varchar_tbl_type;
17263: l_target_page_ui_def_id_tbl number_tbl_type;
17264: l_target_page_id_tbl number_tbl_type;
17265: l_ui_name CZ_UI_DEFS.name%TYPE;
17266: l_page_name CZ_UI_PAGES.name%TYPE;
17267: l_pagebase_expl_id NUMBER;
17268: l_ui_def_id NUMBER;
17269: l_target_persistent_node_id NUMBER;

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

17287: FOR i IN l_name_tbl.First..l_name_tbl.Last
17288: LOOP
17289: SELECT name INTO l_page_name FROM CZ_UI_PAGES
17290: WHERE page_id=l_target_page_id_tbl(i) AND ui_def_id=l_target_page_ui_def_id_tbl(i);
17291: SELECT name INTO l_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=l_target_page_ui_def_id_tbl(i);
17292: add_Error_Message(p_message_name => 'CZ_CP_PIR_REF_UI_NOT_IN_CHAIN',
17293: p_token_name1 => 'RGNNAME',
17294: p_token_value1 => NVL(l_name_tbl(i), l_element_id_tbl(i)),
17295: p_token_name2 => 'PAGENAME',

Line 17831: l_ui_context CZ_UI_DEFS%ROWTYPE;

17827: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
17828: l_parent_element_id CZ_UI_PAGE_ELEMENTS.parent_element_id%TYPE;
17829: l_jrad_doc CZ_UI_PAGES.jrad_doc%TYPE;
17830: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
17831: l_ui_context CZ_UI_DEFS%ROWTYPE;
17832: l_condition_id NUMBER;
17833: l_caption_text_id NUMBER;
17834: l_caption_rule_id NUMBER;
17835: l_display_condition_id NUMBER;

Line 18100: l_ui_context CZ_UI_DEFS%ROWTYPE;

18096: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
18097: ) IS
18098:
18099: l_parent_page_ref_id CZ_UI_PAGE_REFS.parent_page_ref_id%TYPE;
18100: l_ui_context CZ_UI_DEFS%ROWTYPE;
18101: l_page_id CZ_UI_PAGES.page_id%TYPE;
18102: l_page_set_id CZ_UI_PAGES.page_set_id%TYPE;
18103: l_page_ref_type CZ_UI_PAGE_REFS.page_ref_type%TYPE;
18104:

Line 20559: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;

20555: x_msg_count OUT NOCOPY NUMBER, -- number of error messages
20556: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
20557: ) IS
20558:
20559: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
20560: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
20561: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
20562: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
20563: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;

Line 20560: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;

20556: x_msg_data OUT NOCOPY VARCHAR2 -- string which contains error messages
20557: ) IS
20558:
20559: l_target_primary_navigation CZ_UI_DEFS.primary_navigation%TYPE;
20560: l_target_page_set_id CZ_UI_DEFS.page_set_id%TYPE;
20561: l_page_ref_id CZ_UI_PAGE_REFS.page_ref_id%TYPE;
20562: l_ref_pagebase_path CZ_UI_PAGE_REFS.target_path%TYPE;
20563: l_seq_nbr CZ_UI_PAGE_REFS.seq_nbr%TYPE;
20564: l_reference_name CZ_UI_PAGE_REFS.name%TYPE;

Line 20585: FROM CZ_UI_DEFS

20581: -- get primary_navigation, page_set_id of target UI
20582: --
20583: SELECT primary_navigation, page_set_id
20584: INTO l_target_primary_navigation, l_target_page_set_id
20585: FROM CZ_UI_DEFS
20586: WHERE ui_def_id=p_new_target_ui_def_id;
20587:
20588: IF l_target_primary_navigation <> G_MODEL_TREE_MENU THEN
20589:

Line 20740: l_ui_context CZ_UI_DEFS%ROWTYPE;

20736: p_show_all_nodes IN VARCHAR2 DEFAULT NULL,
20737: p_create_empty_ui IN VARCHAR2 DEFAULT NULL,
20738: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
20739:
20740: l_ui_context CZ_UI_DEFS%ROWTYPE;
20741: l_return_status VARCHAR2(255);
20742: l_msg_count NUMBER;
20743: l_msg_data VARCHAR2(255);
20744:

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

20749: g_Use_Cache := FALSE;
20750:
20751: --
20752: -- get UI context
20753: -- ( * also function get_UI_Context() inserts data for new UI into CZ_UI_DEFS table )
20754: --
20755: l_ui_context := create_UI_Context(p_model_id => p_model_id,
20756: p_master_template_id => p_master_template_id,
20757: p_ui_name => p_ui_name,

Line 20774: l_ui_context CZ_UI_DEFS%ROWTYPE;

20770:
20771: PROCEDURE rui(p_ui_def_id IN NUMBER,
20772: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
20773:
20774: l_ui_context CZ_UI_DEFS%ROWTYPE;
20775: l_return_status VARCHAR2(255);
20776: l_msg_count NUMBER;
20777: l_msg_data VARCHAR2(255);
20778: