APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on FEM_FACTOR_TABLES

Line 1: PACKAGE BODY FEM_FACTOR_TABLES_UTIL_PKG AS

1: PACKAGE BODY FEM_FACTOR_TABLES_UTIL_PKG AS
2: /* $Header: FEMFACTTABB.pls 120.1 2008/02/20 06:45:26 jcliving noship $ */
3:
4: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.FEM_FACTOR_TABLE_UTIL';
5: g_pkg_name CONSTANT VARCHAR2(30) := 'FEM_FACTOR_TABLE_UTIL';

Line 150: INSERT INTO fem_factor_tables

146: ,p_module => c_module_pkg||'.'||l_api_name
147: ,p_msg_text => 'Beginng Function'
148: );
149:
150: INSERT INTO fem_factor_tables
151: (
152: object_definition_id,
153: factor_type,
154: created_by,

Line 170: FROM fem_factor_tables

166: fnd_global.user_id,
167: fnd_global.login_id,
168: sysdate,
169: 0
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

Line 266: DELETE FROM fem_factor_tables

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;
268:
269: DELETE FROM fem_factor_table_dims
270: WHERE object_definition_id = p_obj_def_id;

Line 322: END fem_factor_tables_util_pkg;

318: select nvl((select object_definition_id from fem_object_definition_vl where object_id = p_hier_obj_id and display_name = p_hier_name),-1) into l_hier_obj_def_id from dual;
319: x_hier_obj_def_id := l_hier_obj_def_id;
320:
321: END GET_HIER_OBJ_DEF_ID;
322: END fem_factor_tables_util_pkg;