APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on FEM_FACTOR_TABLE_FCTRS

Line 45: FROM fem_factor_table_fctrs

41: p_row_num IN NUMBER) IS
42:
43: CURSOR c_del_mem_list IS
44: SELECT row_num
45: FROM fem_factor_table_fctrs
46: WHERE object_definition_id = p_object_definition_id
47: CONNECT BY prior row_num = parent_row_num
48: START WITH row_num = p_row_num;
49:

Line 65: DELETE FROM fem_factor_table_fctrs

61: ,p_msg_text => 'Beginning Function'
62: );
63:
64: FOR row_num_rec IN c_del_mem_list LOOP
65: DELETE FROM fem_factor_table_fctrs
66: WHERE row_num = row_num_rec.row_num;
67: END LOOP;
68:
69: FEM_ENGINES_PKG.Tech_Message (

Line 140: FROM fem_factor_table_fctrs

136: parent_row_num,
137: level_num,
138: dim_member,
139: factor_value
140: FROM fem_factor_table_fctrs
141: WHERE object_definition_id = p_source_obj_def_id;
142:
143: BEGIN
144: FEM_ENGINES_PKG.Tech_Message (

Line 213: INSERT INTO fem_factor_table_fctrs

209: );
210: END LOOP;
211:
212: FOR c_ft_fctrs_rec IN c_ft_fctrs LOOP
213: INSERT INTO fem_factor_table_fctrs
214: (
215: object_definition_id,
216: row_num,
217: parent_row_num,

Line 263: DELETE FROM fem_factor_table_fctrs

259: l_api_version CONSTANT NUMBER := 1.0;
260:
261: BEGIN
262:
263: DELETE FROM fem_factor_table_fctrs
264: WHERE object_definition_id = p_obj_def_id;
265:
266: DELETE FROM fem_factor_tables
267: WHERE object_definition_id = p_obj_def_id;