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_UI_GENERATOR dependencies on CZ_FUNC_COMP_SPECS

Line 2059: FOR i IN (SELECT func_comp_id,component_id,companion_type,name FROM CZ_FUNC_COMP_SPECS a

2055: -- companion_type IN(1,3,4,5,6,7,9,11,12,13,14,15) <=>
2056: -- combinations with AUTO-CONFIG bit = 1 or OUTPUT bit = 1
2057: --
2058:
2059: FOR i IN (SELECT func_comp_id,component_id,companion_type,name FROM CZ_FUNC_COMP_SPECS a
2060: WHERE devl_project_id=in_project_id AND companion_type IN(1,3,4,5,6,7,9,11,12,13,14,15) AND
2061: NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id AND
2062: ps_node_id=a.component_id AND ui_node_type=UI_BUTTON_TYPE AND func_comp_id=a.func_comp_id
2063: AND parent_id<>in_limbo_id AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG)

Line 7934: NOT EXISTS(SELECT NULL FROM CZ_FUNC_COMP_SPECS b WHERE b.func_comp_id=a.func_comp_id AND b.deleted_flag=NO_FLAG);

7930: --
7931: UPDATE CZ_UI_NODES a
7932: SET deleted_flag=YES_FLAG
7933: WHERE a.ui_def_id=in_ui_def_id AND a.ui_node_type=UI_BUTTON_TYPE AND a.func_comp_id IS NOT NULL AND
7934: NOT EXISTS(SELECT NULL FROM CZ_FUNC_COMP_SPECS b WHERE b.func_comp_id=a.func_comp_id AND b.deleted_flag=NO_FLAG);
7935:
7936: --
7937: -- delete buttons which are associated with a deleted CXs --
7938: --

Line 9976: (SELECT func_comp_id FROM CZ_FUNC_COMP_SPECS WHERE (companion_type=2 AND modified_flags=NO_FLAG)

9972:
9973: populate_RefSI(in_ui_def_id);
9974:
9975: UPDATE CZ_UI_NODES SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id AND ui_node_type=UI_BUTTON_TYPE AND func_comp_id IN
9976: (SELECT func_comp_id FROM CZ_FUNC_COMP_SPECS WHERE (companion_type=2 AND modified_flags=NO_FLAG)
9977: OR deleted_flag=YES_FLAG);
9978:
9979: /* *** synchronize types of Functional Companions *** */
9980: FOR h IN(SELECT a.func_comp_id,a.companion_type,

Line 9981: b.ui_node_id,b.parent_id,a.component_id,b.caption_id,a.name FROM CZ_FUNC_COMP_SPECS a,CZ_UI_NODES b

9977: OR deleted_flag=YES_FLAG);
9978:
9979: /* *** synchronize types of Functional Companions *** */
9980: FOR h IN(SELECT a.func_comp_id,a.companion_type,
9981: b.ui_node_id,b.parent_id,a.component_id,b.caption_id,a.name FROM CZ_FUNC_COMP_SPECS a,CZ_UI_NODES b
9982: WHERE b.ui_def_id=in_ui_def_id AND b.ui_node_type=UI_BUTTON_TYPE
9983: AND a.func_comp_id=b.func_comp_id AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
9984: LOOP
9985: