DBA Data[Home] [Help]

APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on FEM_FACTOR_TABLE_DIMS

Line 26: FROM fem_factor_table_dims

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:

Line 129: FROM fem_factor_table_dims

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

Line 174: INSERT INTO fem_factor_table_dims

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,

Line 269: DELETE FROM fem_factor_table_dims

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: