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_REFS

Line 2436: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE

2432: FROM CZ_UI_PAGE_REFS
2433: WHERE ui_def_id=g_UI_Context.ui_def_id AND page_set_id=p_page_set_id
2434: AND seq_nbr=l_seq_nbr AND
2435: target_persistent_node_id NOT IN
2436: (SELECT ref_persistent_node_id FROM CZ_UI_REFS WHERE
2437: ui_def_id=g_UI_Context.ui_def_id AND deleted_flag=G_NO_FLAG) AND
2438: rownum<2;
2439: EXCEPTION
2440: WHEN OTHERS THEN

Line 3032: FROM CZ_UI_REFS

3028: RETURN BOOLEAN IS
3029: l_ui_ref_exists VARCHAR2(1);
3030: BEGIN
3031: SELECT 'x' INTO l_ui_ref_exists
3032: FROM CZ_UI_REFS
3033: WHERE ui_def_id=p_ui_node.ui_def_id AND
3034: ref_persistent_node_id=p_ui_node.persistent_node_id AND
3035: deleted_flag=G_NO_FLAG AND rownum<2;
3036: RETURN TRUE;

Line 3622: FROM CZ_UI_REFS

3618: g_ui_page_sets_tbl(i.page_set_id) := i;
3619: END LOOP;
3620:
3621: FOR i IN (SELECT ref_persistent_node_id
3622: FROM CZ_UI_REFS
3623: WHERE ui_def_id = g_UI_Context.ui_def_id AND
3624: deleted_flag = G_NO_FLAG)
3625: LOOP
3626: g_ui_refs_tbl(i.ref_persistent_node_id) := i.ref_persistent_node_id;

Line 11514: UPDATE CZ_UI_REFS

11510: l_ui_node.deleted_flag);
11511:
11512: BEGIN
11513:
11514: UPDATE CZ_UI_REFS
11515: SET deleted_flag=G_NO_FLAG
11516: WHERE
11517: ui_def_id = l_ui_node.ui_def_id AND
11518: ref_persistent_node_id = l_ui_node.persistent_node_id;

Line 11521: INSERT INTO CZ_UI_REFS

11517: ui_def_id = l_ui_node.ui_def_id AND
11518: ref_persistent_node_id = l_ui_node.persistent_node_id;
11519:
11520: IF SQL%ROWCOUNT=0 THEN
11521: INSERT INTO CZ_UI_REFS
11522: (ui_def_id,
11523: ref_ui_def_id,
11524: ref_persistent_node_id,
11525: model_ref_expl_id,

Line 11783: UPDATE CZ_UI_REFS

11779: IF SQL%ROWCOUNT>0 THEN
11780: --
11781: -- delete UI Ref
11782: --
11783: UPDATE CZ_UI_REFS
11784: SET deleted_flag = G_YES_FLAG
11785: WHERE ui_def_id=p_ui_node.ui_def_id AND
11786: ref_persistent_node_id=p_ui_node.persistent_node_id AND
11787: deleted_flag=G_NO_FLAG AND NOT EXISTS

Line 12012: UPDATE CZ_UI_REFS uiref

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

Line 17326: INSERT INTO CZ_UI_REFS

17322: ps_node_id=i.referring_node_id AND
17323: deleted_flag=G_NO_FLAG;
17324:
17325: BEGIN
17326: INSERT INTO CZ_UI_REFS
17327: (ui_def_id,
17328: ref_ui_def_id,
17329: ref_persistent_node_id,
17330: model_ref_expl_id,

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

17347:
17348: END IF;
17349:
17350: --
17351: -- table CZ_UI_REFS is populated in procedure construct_Single_UI()
17352: -- ( in this approach UI can have a more referenced UIs than Model Tree )
17353: --
17354: FOR i IN (SELECT DISTINCT ref_ui_def_id
17355: FROM CZ_UI_REFS

Line 17355: FROM CZ_UI_REFS

17351: -- table CZ_UI_REFS is populated in procedure construct_Single_UI()
17352: -- ( in this approach UI can have a more referenced UIs than Model Tree )
17353: --
17354: FOR i IN (SELECT DISTINCT ref_ui_def_id
17355: FROM CZ_UI_REFS
17356: WHERE ui_def_id = p_ui_def_id AND
17357: deleted_flag = G_NO_FLAG)
17358: LOOP
17359: --

Line 17457: FROM CZ_UI_REFS

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
17458: START WITH ui_def_id = x_ui_def_id
17459: AND deleted_flag = G_NO_FLAG
17460: CONNECT BY PRIOR ref_ui_def_id = ui_def_id AND deleted_flag = G_NO_FLAG)
17461: AND deleted_flag = G_NO_FLAG;

Line 17531: FROM CZ_UI_REFS

17527:
17528: BEGIN
17529:
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:

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

18127: page_id=p_page_id AND
18128: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE AND
18129: deleted_flag='0' AND target_page_ui_def_id IS NOT NULL AND
18130: target_page_id IS NOT NULL AND
18131: 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
18132: deleted_flag='0')
18133: RETURNING element_id,name,target_page_id,target_page_ui_def_id
18134: BULK COLLECT INTO l_element_id_tbl,l_name_tbl,l_target_page_id_tbl,l_target_page_ui_def_id_tbl;
18135:

Line 21824: FROM cz_ui_refs

21820:
21821: -- handle page include region
21822: -- Note the link to the old target child ui is still there at this point
21823: SELECT ref_ui_def_id INTO l_old_child_ui_def_id
21824: FROM cz_ui_refs
21825: WHERE ui_def_id = p_ui_def_id AND ref_persistent_node_id = p_ref_persistent_node_id;
21826:
21827: UPDATE cz_ui_page_elements
21828: SET target_page_ui_def_id = NULL, target_page_id = NULL