APPS.FEM_DIM_HIER_UTIL_PKG SQL Statements

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

Line: 161

   SELECT value_set_id
   FROM fem_value_sets_b
   WHERE dimension_id = p_dimension_id
   AND value_set_id IN
      (p_val_set_id1,p_val_set_id2,p_val_set_id3,
       p_val_set_id4,p_val_set_id5,p_val_set_id6,
       p_val_set_id7,p_val_set_id8,p_val_set_id9);

Line: 173

   SELECT dimension_group_id
   FROM fem_dimension_grps_b
   WHERE dimension_id = p_dimension_id
   AND   dimension_group_id IN
      (p_dim_grp_id1,p_dim_grp_id2,p_dim_grp_id3,
       p_dim_grp_id4,p_dim_grp_id5,p_dim_grp_id6,
       p_dim_grp_id7,p_dim_grp_id8,p_dim_grp_id9)
   ORDER BY dimension_group_seq;

Line: 186

   SELECT lookup_code
   FROM fnd_lookup_values_vl
   WHERE lookup_type = p_lookup_type
   AND lookup_code = p_lookup_code;

Line: 249

   SELECT dimension_name,
          dimension_varchar_label,
          hierarchy_table_name,
          hier_type_allowed_code,
          group_use_code,
          decode(dimension_varchar_label,'CAL_PERIOD','C',
                                         value_set_required_flag)
   INTO v_dim_name,
        v_dim_label,
        v_dim_hier_table,
        v_hier_allowed_code,
        v_group_use_code,
        v_vs_reqd_flg
   FROM fem_xdim_dimensions X,
        fem_dimensions_vl V
   WHERE X.dimension_id = p_dimension_id
   AND   V.dimension_id = X.dimension_id;

Line: 339

      SELECT calendar_id
      INTO v_calendar_id
      FROM fem_calendars_b
      WHERE calendar_id = p_calendar_id;

Line: 382

            SELECT value_set_id
            INTO v_val_set_id
            FROM fem_value_sets_b
            WHERE dimension_id = p_dimension_id
            AND value_set_id = a_val_set_id(v_arr);

Line: 452

         SELECT dimension_group_id
         INTO v_dim_grp_id
         FROM fem_dimension_grps_b
         WHERE dimension_id = p_dimension_id
         AND   dimension_group_id = a_dim_grp_id(v_arr);

Line: 506

INSERT INTO fem_hierarchies
  (hierarchy_obj_id,
   dimension_id,
   hierarchy_type_code,
   group_sequence_enforced_code,
   multi_top_flag,
   financial_category_flag,
   multi_value_set_flag,
   calendar_id,
   period_type,
   hierarchy_usage_code,
   creation_date,
   created_by,
   last_updated_by,
   last_update_date,
   last_update_login,
   personal_flag,
   flattened_rows_flag,
   object_version_number)
VALUES
  (v_object_id,
   p_dimension_id,
   p_hier_type_code,
   p_grp_seq_code,
   p_multi_top_flg,
   p_fin_ctg_flg,
   p_multi_vs_flg,
   v_calendar_id,
   p_gl_period_type,
   p_hier_usage_code,
   sysdate,
   c_user_id,
   c_user_id,
   sysdate,
   null,
   'N',
   p_flat_rows_flag,
   1);

Line: 545

INSERT INTO fem_hier_definitions
  (hierarchy_obj_def_id,
   creation_date,
   created_by,
   last_updated_by,
   last_update_date,
   last_update_login,
   object_version_number,
   flattened_rows_completion_code)
VALUES
  (v_obj_def_id,
   sysdate,
   c_user_id,
   c_user_id,
   sysdate,
   null,
   1,'PENDING');

Line: 574

      INSERT INTO fem_hier_dimension_grps
        (dimension_group_id,
         hierarchy_obj_id,
         relative_dimension_group_seq,
         creation_date,
         created_by,
         last_updated_by,
         last_update_date,
         last_update_login,
         object_version_number)
      VALUES
        (v_dim_grp_id,
         v_object_id,
         v_dim_grp_seq,
         sysdate,
         c_user_id,
         c_user_id,
         sysdate,
         null,1);

Line: 606

      INSERT INTO fem_hier_value_sets
        (hierarchy_obj_id,
         value_set_id,
         creation_date,
         created_by,
         last_updated_by,
         last_update_date,
         last_update_login,
         object_version_number)
      VALUES
        (v_object_id,
         v_val_set_id,
         sysdate,
         c_user_id,
         c_user_id,
         sysdate,
         null,1);

Line: 627

   INSERT INTO fem_hier_value_sets
     (hierarchy_obj_id,
      value_set_id,
      creation_date,
      created_by,
      last_updated_by,
      last_update_date,
      last_update_login,
      object_version_number)
   VALUES
     (v_object_id,
      v_calendar_id,
      sysdate,
      c_user_id,
      c_user_id,
      sysdate,
      null,1);

Line: 948

   SELECT hierarchy_obj_id
   INTO v_hier_obj_id
   FROM fem_hierarchies
   WHERE hierarchy_obj_id = p_hier_obj_id;

Line: 982

INSERT INTO fem_hier_definitions
  (hierarchy_obj_def_id,
   creation_date,
   created_by,
   last_updated_by,
   last_update_date,
   last_update_login,
   object_version_number,
   flattened_rows_completion_code)
VALUES
  (v_obj_def_id,
   sysdate,
   c_user_id,
   c_user_id,
   sysdate,
   null,
   1,'PENDING');

Line: 1081

SELECT B.dimension_id,
       X.hier_type_allowed_code
INTO v_cal_per_dim_id,
     v_hier_allowed_code
FROM fem_xdim_dimensions X,
     fem_dimensions_b B
WHERE B.dimension_varchar_label = 'CAL_PERIOD'
AND   B.dimension_id = X.dimension_id;

Line: 1095

   SELECT Y.dimension_group_id,
          Q.dimension_group_id
   INTO v_year_grp_id,
        v_qtr_grp_id
   FROM fem_dimension_grps_b Y,
        fem_dimension_grps_b Q
   WHERE Y.dimension_group_display_code = 'Year'
   AND   Q.dimension_group_display_code = 'Quarter'
   AND   Y.dimension_id = 1
   AND   Q.dimension_id = 1;