APPS.FEM_DIM_GROUPS_UTIL_PKG SQL Statements

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

Line: 153

         SELECT B.dimension_id
         INTO v_dimension_id
         FROM fem_dimensions_b B, fem_xdim_dimensions X
         WHERE B.dimension_varchar_label = p_dimension_varchar_label
         AND B.dimension_id = X.dimension_id
         AND X.group_use_code IN ('OPTIONAL','REQUIRED');

Line: 168

         SELECT dimension_group_id,dimension_group_seq
         INTO x_dimension_group_id, x_dim_group_sequence
         FROM fem_dimension_grps_b
         WHERE dimension_id = v_dimension_id
         AND dimension_group_display_code = p_dim_group_display_code;

Line: 183

      SELECT count(*)
      INTO v_count
      FROM fem_dimension_grps_tl
      WHERE dimension_group_name = p_dim_group_name
      AND dimension_id = v_dimension_id;

Line: 196

         SELECT count(*)
         INTO v_count
         FROM fem_dimension_grps_b
         WHERE dimension_group_seq = p_dim_group_sequence
         AND dimension_id = v_dimension_id;

Line: 210

         SELECT count(*)
         INTO v_count
         FROM fem_time_group_types_b
         WHERE time_group_type_code = p_time_group_type_code
         AND ENABLED_FLAG = 'Y'
         AND PERSONAL_FLAG = 'N';

Line: 220

            SELECT fem_time_dimension_group_key_s.nextval
            INTO v_time_dimension_group_key
            FROM dual;

Line: 226

      SELECT fem_dimension_grps_b_s.nextval
      INTO x_dimension_group_id
      FROM dual;

Line: 233

         SELECT nvl(max(dimension_group_seq)+100,1000)
         INTO x_dim_group_sequence
         FROM fem_dimension_grps_b
         WHERE dimension_id = v_dimension_id;

Line: 240

      FEM_DIMENSION_GRPS_PKG.INSERT_ROW(
         X_ROWID => v_rowid
        ,X_DIMENSION_GROUP_ID => x_dimension_group_id
        ,X_TIME_DIMENSION_GROUP_KEY => v_time_dimension_group_key
        ,X_DIMENSION_ID => v_dimension_id
        ,X_DIMENSION_GROUP_SEQ => x_dim_group_sequence
        ,X_TIME_GROUP_TYPE_CODE => p_time_group_type_code
        ,X_READ_ONLY_FLAG => 'N'
        ,X_OBJECT_VERSION_NUMBER => 1
        ,X_PERSONAL_FLAG => 'N'
        ,X_ENABLED_FLAG => 'Y'
        ,X_DIMENSION_GROUP_DISPLAY_CODE => p_dim_group_display_code
        ,X_DIMENSION_GROUP_NAME => p_dim_group_name
        ,X_DESCRIPTION  => p_dim_group_description
        ,X_CREATION_DATE => sysdate
        ,X_CREATED_BY => pc_user_id
        ,X_LAST_UPDATE_DATE => sysdate
        ,X_LAST_UPDATED_BY => pc_user_id
        ,X_LAST_UPDATE_LOGIN => pc_last_update_login);