APPS.FEM_FACTOR_TABLES_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

     SELECT count(*) into l_count
     FROM   fem_factor_table_dims
     WHERE  object_definition_id = p_object_definition_id
     AND    dim_usage_code = 'MATCH'
     AND    level_num > p_level_num;

Line: 40

   PROCEDURE delete_member (p_object_definition_id IN NUMBER,
                            p_row_num IN NUMBER) IS

     CURSOR c_del_mem_list IS
     SELECT row_num
     FROM   fem_factor_table_fctrs
     WHERE  object_definition_id = p_object_definition_id
     CONNECT BY prior row_num = parent_row_num
     START WITH row_num = p_row_num;

Line: 50

     l_api_name  CONSTANT  VARCHAR2(30) := 'delete_member';

Line: 65

       DELETE FROM fem_factor_table_fctrs
       WHERE row_num = row_num_rec.row_num;

Line: 85

   END delete_member;

Line: 119

      SELECT
        object_definition_id,
        level_num,
        dimension_id,
        dim_usage_code,
        force_percent_flag,
        hier_object_id,
        hier_obj_def_id,
        hier_group_id,
        hier_relation_code
      FROM fem_factor_table_dims
      WHERE object_definition_id = p_source_obj_def_id;

Line: 133

      SELECT
        object_definition_id,
        row_num,
        parent_row_num,
        level_num,
        dim_member,
        factor_value
      FROM fem_factor_table_fctrs
      WHERE object_definition_id =  p_source_obj_def_id;

Line: 150

     INSERT INTO fem_factor_tables
     (
       object_definition_id,
       factor_type,
       created_by,
       creation_date,
       last_updated_by,
       last_update_login,
       last_update_date,
       object_version_number
     )
     SELECT
       p_target_obj_def_id  AS object_definition_id,
       factor_type,
       p_created_by,
       p_creation_date,
       fnd_global.user_id,
       fnd_global.login_id,
       sysdate,
       0
     FROM fem_factor_tables
     WHERE object_definition_id = p_source_obj_def_id;

Line: 174

       INSERT INTO fem_factor_table_dims
       (
         object_definition_id,
         level_num,
         dimension_id,
         dim_usage_code,
         force_percent_flag,
         hier_object_id,
         hier_obj_def_id,
         hier_group_id,
         hier_relation_code,
         creation_date,
         created_by,
         last_updated_by,
         last_update_login,
         last_update_date,
         object_version_number
       )
       VALUES
       (
         p_target_obj_def_id,
         c_dim_rec.level_num,
         c_dim_rec.dimension_id,
         c_dim_rec.dim_usage_code,
         c_dim_rec.force_percent_flag,
         c_dim_rec.hier_object_id,
         c_dim_rec.hier_obj_def_id,
         c_dim_rec.hier_group_id,
         c_dim_rec.hier_relation_code,
         p_creation_date,
         p_created_by,
         fnd_global.user_id,
         fnd_global.login_id,
         sysdate,
         0
       );

Line: 213

       INSERT INTO fem_factor_table_fctrs
       (
         object_definition_id,
         row_num,
         parent_row_num,
         level_num,
         dim_member,
         factor_value,
         creation_date,
         created_by,
         last_updated_by,
         last_update_login,
         last_update_date,
         object_version_number
       )
       VALUES
       (
         p_target_obj_def_id,
         c_ft_fctrs_rec.row_num,
         c_ft_fctrs_rec.parent_row_num,
         c_ft_fctrs_rec.level_num,
         c_ft_fctrs_rec.dim_member,
         c_ft_fctrs_rec.factor_value,
         p_creation_date,
         p_created_by,
         fnd_global.login_id,
         fnd_global.user_id,
         sysdate,
         0
       );

Line: 254

   PROCEDURE DeleteObjectDefinition ( p_obj_def_id  IN NUMBER ) IS

     l_ver_count NUMBER := 0;

Line: 258

     l_api_name  CONSTANT  VARCHAR2(30) := 'DeleteObjectDefinition';

Line: 263

     DELETE FROM fem_factor_table_fctrs
     WHERE object_definition_id = p_obj_def_id;

Line: 266

     DELETE FROM fem_factor_tables
     WHERE object_definition_id = p_obj_def_id;

Line: 269

     DELETE FROM fem_factor_table_dims
     WHERE object_definition_id = p_obj_def_id;

Line: 272

   END DeleteObjectDefinition;

Line: 277

    select nvl((select 'Y' from FEM_HIERARCHIES where hierarchy_obj_id  = p_hier_obj_id and dimension_id = p_dimension_id),'N') into  l_valid_flag from dual;

Line: 284

    select nvl((select 'Y' from FEM_HIER_DIMENSION_GRPS where hierarchy_obj_id  = p_hier_obj_id and dimension_group_id = p_group_id),'N') into  l_valid_flag from dual;

Line: 301

   select member_b_table_name,member_col into l_member_table_name,l_member_col from fem_xdim_dimensions where dimension_id = p_dimension_id;

Line: 302

   l_query := 'select ''Y'' from ' || l_member_table_name ||
            ' WHERE DIMENSION_GROUP_ID IN (SELECT DIMENSION_GROUP_ID FROM FEM_HIER_DIMENSION_GRPS WHERE HIERARCHY_OBJ_ID = ' || p_hier_object_id ||
            ') AND DIMENSION_GROUP_ID = ' || p_group_id ||
            ' AND ' || l_member_col || ' = ' || p_member_id ;

Line: 307

   l_main_query:= 'select nvl((' || l_query || '),''N'') from dual';

Line: 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;