DBA Data[Home] [Help]

APPS.CZ_CX_UTIL_PVT dependencies on CZ_RULE_FOLDERS

Line 44: -- 2. update cz_rule_folders's id and type: func_comp_id, FNC => rule_id, CXT

40: -- Converting old functional companion data to configurator extension foramt.
41: -- Returns return_status 1 if the conversion process is successful, 0 otherwise.
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

Line 110: FROM cz_rule_folders

106:
107: FOR i IN model_tbl.FIRST .. model_tbl.LAST LOOP
108: SELECT rule_folder_id, tree_seq
109: BULK COLLECT INTO fc_tbl, seq_tbl
110: FROM cz_rule_folders
111: WHERE devl_project_id = model_tbl(i)
112: AND object_type = 'FNC' AND deleted_flag = '0';
113: l_stat := 3.1;
114:

Line 123: UPDATE cz_rule_folders

119: SET rule_folder_type = l_rule_id
120: WHERE func_comp_id = fc_tbl(j);
121: l_stat := 3.2;
122:
123: UPDATE cz_rule_folders
124: SET rule_folder_id = l_rule_id, object_type = 'CXT'
125: WHERE rule_folder_id = fc_tbl(j) AND object_type = 'FNC';
126: l_stat := 3.3;
127: