APPS.CZ_CX_UTIL_PVT dependencies on CZ_UI_NODES

Line 46: -- cz_ui_nodes: func_comp_id => cx_command_name

42: -- The tasks performed here are as follows.
43: -- 1. transform old fc recs to new cx rule data: cz_func_comp_specs => cz_rules
44: -- 2. update cz_rule_folders's id and type: func_comp_id, FNC => rule_id, CXT
45: -- 3. convert old ui fc data to new cx form
46: -- cz_ui_nodes: func_comp_id => cx_command_name
47: -- cz_ui_node_props: old value_str type (5,6) => new value_str type (31,32)
48: -- Note: event binding expression trees are created by Java program after
49: -- the above three tasks are finished. At the end of migration process, old fc
50: -- recs will be logically deleted by the same java program.

Line 189: FROM cz_ui_defs def, cz_ui_nodes node, cz_ui_node_props prop

185: -- convert fc to cx
186: FOR i IN model_tbl.FIRST .. model_tbl.LAST LOOP
187: FOR ui_rec IN (SELECT def.ui_def_id, node.ui_node_id,
188: node.func_comp_id, prop.value_str
189: FROM cz_ui_defs def, cz_ui_nodes node, cz_ui_node_props prop
190: WHERE def.devl_project_id = model_tbl(i)
191: AND def.deleted_flag = '0'
192: AND def.ui_def_id = node.ui_def_id
193: AND node.deleted_flag = '0'

Line 200: AND node.parent_id <> (SELECT ui_node_id FROM CZ_UI_NODES

196: AND node.ui_node_id = prop.ui_node_id
197: AND prop.key_str = 'ActionType'
198: AND prop.value_str IN (FC_OUTPUT, FC_AUTOCONFIG)
199: AND prop.deleted_flag = '0'
200: AND node.parent_id <> (SELECT ui_node_id FROM CZ_UI_NODES
201: WHERE ui_def_id=def.ui_def_id AND
202: name='Limbo' AND
203: deleted_flag='0')
204: ) LOOP

Line 222: UPDATE cz_ui_nodes

218: l_command_name := fc2rule_map(ui_rec.func_comp_id) || '_AC';
219: l_value_str := CX_AUTOCONFIG; -- AC = autoconfig
220: END IF;
221:
222: UPDATE cz_ui_nodes
223: SET cx_command_name = l_command_name, func_comp_id = NULL
224: WHERE ui_node_id = ui_rec.ui_node_id;
225: l_stat := 5.2;
226:

Line 240: UPDATE CZ_UI_NODES

236:
237: IF deluinodes_ids_tbl.COUNT > 0 THEN
238: -- collect those UI nodes ( buttons ) which have a references to unexisting Functional Companions
239: FORALL k IN deluinodes_ids_tbl.First..deluinodes_ids_tbl.Last
240: UPDATE CZ_UI_NODES
241: SET deleted_flag='1'
242: WHERE ui_def_id=deluinodes_uidefids_tbl(k) AND ui_node_id=deluinodes_ids_tbl(k);
243:
244: FORALL k IN deluinodes_ids_tbl.First..deluinodes_ids_tbl.Last