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_REFS

Line 2374: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE

2370: FROM CZ_UI_PAGE_REFS
2371: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2372: AND seq_nbr=l_seq_nbr AND
2373: target_persistent_node_id NOT IN
2374: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE
2375: ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG) AND
2376: rownum<2;
2377: EXCEPTION
2378: WHEN OTHERS THEN

Line 2970: FROM CZ_UI_REFS

2966: RETURN BOOLEAN IS
2967: l_ui_ref_exists VARCHAR2(1);
2968: BEGIN
2969: SELECT 'x' INTO l_ui_ref_exists
2970: FROM CZ_UI_REFS
2971: WHERE ui_def_id=p_ui_node.ui_def_id AND
2972: ref_persistent_node_id=p_ui_node.persistent_node_id AND
2973: deleted_flag=G_NO_FLAG AND rownum<2;
2974: RETURN TRUE;

Line 3560: FROM CZ_UI_REFS

3556: g_ui_page_sets_tbl(i.page_set_id) := i;
3557: END LOOP;
3558:
3559: FOR i IN (SELECT ref_persistent_node_id
3560: FROM CZ_UI_REFS
3561: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3562: deleted_flag = G_NO_FLAG)
3563: LOOP
3564: g_ui_refs_tbl(i.ref_persistent_node_id) := i.ref_persistent_node_id;

Line 11035: UPDATE CZ_UI_REFS

11031: l_ui_node.deleted_flag);
11032:
11033: BEGIN
11034:
11035: UPDATE CZ_UI_REFS
11036: SET deleted_flag=G_NO_FLAG
11037: WHERE
11038: ui_def_id = l_ui_node.ui_def_id AND
11039: ref_persistent_node_id = l_ui_node.persistent_node_id;

Line 11042: INSERT INTO CZ_UI_REFS

11038: ui_def_id = l_ui_node.ui_def_id AND
11039: ref_persistent_node_id = l_ui_node.persistent_node_id;
11040:
11041: IF SQL%ROWCOUNT=0 THEN
11042: INSERT INTO CZ_UI_REFS
11043: (ui_def_id,
11044: ref_ui_def_id,
11045: ref_persistent_node_id,
11046: model_ref_expl_id,

Line 11304: UPDATE CZ_UI_REFS

11300: IF SQL%ROWCOUNT>0 THEN
11301: --
11302: -- delete UI Ref
11303: --
11304: UPDATE CZ_UI_REFS
11305: SET deleted_flag = G_YES_FLAG
11306: WHERE ui_def_id=p_ui_node.ui_def_id AND
11307: ref_persistent_node_id=p_ui_node.persistent_node_id AND
11308: deleted_flag=G_NO_FLAG AND NOT EXISTS

Line 11533: UPDATE CZ_UI_REFS uiref

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

Line 16614: INSERT INTO CZ_UI_REFS

16610: ps_node_id=i.referring_node_id AND
16611: deleted_flag=G_NO_FLAG;
16612:
16613: BEGIN
16614: INSERT INTO CZ_UI_REFS
16615: (ui_def_id,
16616: ref_ui_def_id,
16617: ref_persistent_node_id,
16618: model_ref_expl_id,

Line 16639: -- table CZ_UI_REFS is populated in procedure construct_Single_UI()

16635:
16636: END IF;
16637:
16638: --
16639: -- table CZ_UI_REFS is populated in procedure construct_Single_UI()
16640: -- ( in this approach UI can have a more referenced UIs than Model Tree )
16641: --
16642: FOR i IN (SELECT DISTINCT ref_ui_def_id
16643: FROM CZ_UI_REFS

Line 16643: FROM CZ_UI_REFS

16639: -- table CZ_UI_REFS is populated in procedure construct_Single_UI()
16640: -- ( in this approach UI can have a more referenced UIs than Model Tree )
16641: --
16642: FOR i IN (SELECT DISTINCT ref_ui_def_id
16643: FROM CZ_UI_REFS
16644: WHERE ui_def_id = p_ui_def_id AND
16645: deleted_flag = G_NO_FLAG)
16646: LOOP
16647: --

Line 16745: FROM CZ_UI_REFS

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
16746: START WITH ui_def_id = x_ui_def_id
16747: AND deleted_flag = G_NO_FLAG
16748: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = G_NO_FLAG)
16749: AND deleted_flag = G_NO_FLAG;

Line 17281: target_page_ui_def_id NOT IN (SELECT ref_ui_def_id FROM CZ_UI_REFS WHERE ui_def_id=p_ui_def_id AND

17277: page_id=p_page_id AND
17278: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
17279: deleted_flag='0' AND target_page_ui_def_id IS NOT NULL AND
17280: target_page_id IS NOT NULL AND
17281: target_page_ui_def_id NOT IN (SELECT ref_ui_def_id FROM CZ_UI_REFS WHERE ui_def_id=p_ui_def_id AND
17282: deleted_flag='0')
17283: RETURNING element_id,name,target_page_id,target_page_ui_def_id
17284: BULK COLLECT INTO l_element_id_tbl,l_name_tbl,l_target_page_id_tbl,l_target_page_ui_def_id_tbl;
17285:

Line 20708: FROM cz_ui_refs

20704:
20705: -- handle page include region
20706: -- Note the link to the old target child ui is still there at this point
20707: SELECT ref_ui_def_id INTO l_old_child_ui_def_id
20708: FROM cz_ui_refs
20709: WHERE ui_def_id = p_ui_def_id AND ref_persistent_node_id = p_ref_persistent_node_id;
20710:
20711: UPDATE cz_ui_page_elements
20712: SET target_page_ui_def_id = NULL, target_page_id = NULL