22: ,p_msg_text => 'Begining Function'
23: );
24:
25: SELECT count(*) into l_count
26: FROM fem_factor_table_dims
27: WHERE object_definition_id = p_object_definition_id
28: AND dim_usage_code = 'MATCH'
29: AND level_num > p_level_num;
30:
125: hier_object_id,
126: hier_obj_def_id,
127: hier_group_id,
128: hier_relation_code
129: FROM fem_factor_table_dims
130: WHERE object_definition_id = p_source_obj_def_id;
131:
132: CURSOR c_ft_fctrs IS
133: SELECT
170: FROM fem_factor_tables
171: WHERE object_definition_id = p_source_obj_def_id;
172:
173: FOR c_dim_rec IN c_ft_dims LOOP
174: INSERT INTO fem_factor_table_dims
175: (
176: object_definition_id,
177: level_num,
178: dimension_id,
265:
266: DELETE FROM fem_factor_tables
267: WHERE object_definition_id = p_obj_def_id;
268:
269: DELETE FROM fem_factor_table_dims
270: WHERE object_definition_id = p_obj_def_id;
271:
272: END DeleteObjectDefinition;
273: