APPS.FEM_DIM_CAL_UTIL_PKG SQL Statements

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

Line: 139

   SELECT attribute_id,
          attribute_varchar_label,
          attribute_dimension_id,
          attribute_value_column_name,
          attribute_required_flag
   FROM fem_dim_attributes_b
   WHERE dimension_id =
      (SELECT dimension_id
       FROM fem_dimensions_b
       WHERE dimension_varchar_label = c_dim_label);

Line: 177

SELECT dimension_id
INTO v_dim_id
FROM fem_dimensions_b
WHERE dimension_varchar_label = c_dim_label;

Line: 201

   FEM_CALENDARS_PKG.INSERT_ROW(
      x_rowid => v_row_id,
      x_calendar_id => v_cal_id,
      x_enabled_flag => c_enbld_flg,
      x_calendar_display_code => p_cal_disp_code,
      x_read_only_flag => c_ro_flg,
      x_personal_flag => c_pers_flg,
      x_object_version_number => c_obj_ver_no,
      x_calendar_name => p_calendar_name,
      x_description => p_calendar_desc,
      x_creation_date => sysdate,
      x_created_by => c_user_id,
      x_last_update_date => sysdate,
      x_last_updated_by => c_user_id,
      x_last_update_login => null);

Line: 235

   SELECT MIN(version_id)
   INTO v_ver_id
   FROM fem_dim_attr_versions_b
   WHERE attribute_id = v_attr_id
   AND default_version_flag = 'Y';

Line: 251

      SELECT fem_dim_attr_versions_b_s.NEXTVAL
      INTO v_ver_id FROM dual;

Line: 254

      FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
         x_rowid => v_row_id,
         x_version_id => v_ver_id,
         x_aw_snapshot_flag => c_aw_flg,
         x_version_display_code => p_ver_disp_cd,
         x_object_version_number => c_obj_ver_no,
         x_default_version_flag => 'Y',
         x_personal_flag => c_pers_flg,
         x_attribute_id => v_attr_id,
         x_version_name => p_ver_name,
         x_description => null,
         x_creation_date => sysdate,
         x_created_by => c_user_id,
         x_last_update_date => sysdate,
         x_last_updated_by => c_user_id,
         x_last_update_login => null);

Line: 321

         SELECT member_b_table_name,
                member_col
         INTO v_xdim_tab,
              v_xdim_col
         FROM fem_xdim_dimensions
         WHERE dimension_id = v_xdim_id;

Line: 329

            'SELECT '||v_xdim_col||
            ' FROM '||v_xdim_tab||
            ' WHERE '||v_xdim_col||' = :b_attr_value';

Line: 357

         INSERT INTO fem_calendars_attr(
            attribute_id,
            version_id,
            calendar_id,
            dim_attribute_numeric_member,
            dim_attribute_varchar_member,
            number_assign_value,
            varchar_assign_value,
            date_assign_value,
            creation_date,
            created_by,
            last_updated_by,
            last_update_date,
            last_update_login,
            aw_snapshot_flag,
            object_version_number)
         VALUES(
            v_attr_id,
            v_ver_id,
            v_cal_id,
            v_attr_num,
            v_attr_vch,
            null,
            null,
            null,
            sysdate,
            c_user_id,
            c_user_id,
            sysdate,
            null,
            c_aw_flg,
            c_obj_ver_no);

Line: 395

         INSERT INTO fem_calendars_attr(
            attribute_id,
            version_id,
            calendar_id,
            dim_attribute_numeric_member,
            dim_attribute_varchar_member,
            number_assign_value,
            varchar_assign_value,
            date_assign_value,
            creation_date,
            created_by,
            last_updated_by,
            last_update_date,
            last_update_login,
            aw_snapshot_flag,
            object_version_number)
         VALUES(
            v_attr_id,
            v_ver_id,
            v_cal_id,
            null,
            null,
            v_attr_value,
            null,
            null,
            sysdate,
            c_user_id,
            c_user_id,
            sysdate,
            null,
            c_aw_flg,
            c_obj_ver_no);

Line: 433

         INSERT INTO fem_calendars_attr(
            attribute_id,
            version_id,
            calendar_id,
            dim_attribute_numeric_member,
            dim_attribute_varchar_member,
            number_assign_value,
            varchar_assign_value,
            date_assign_value,
            creation_date,
            created_by,
            last_updated_by,
            last_update_date,
            last_update_login,
            aw_snapshot_flag,
            object_version_number)
         VALUES(
            v_attr_id,
            v_ver_id,
            v_cal_id,
            null,
            null,
            null,
            v_attr_value,
            null,
            sysdate,
            c_user_id,
            c_user_id,
            sysdate,
            null,
            c_aw_flg,
            c_obj_ver_no);

Line: 471

         INSERT INTO fem_calendars_attr(
            attribute_id,
            version_id,
            calendar_id,
            dim_attribute_numeric_member,
            dim_attribute_varchar_member,
            number_assign_value,
            varchar_assign_value,
            date_assign_value,
            creation_date,
            created_by,
            last_updated_by,
            last_update_date,
            last_update_login,
            aw_snapshot_flag,
            object_version_number)
         VALUES(
            v_attr_id,
            v_ver_id,
            v_cal_id,
            null,
            null,
            null,
            null,
            v_attr_date,
            sysdate,
            c_user_id,
            c_user_id,
            sysdate,
            null,
            c_aw_flg,
            c_obj_ver_no);

Line: 645

   FEM_TIME_GROUP_TYPES_PKG.INSERT_ROW(
      x_rowid => v_row_id,
      x_time_group_type_code => p_time_grp_type_code,
      x_enabled_flag => c_enbld_flg,
      x_personal_flag => c_pers_flg,
      x_object_version_number => c_obj_ver_no,
      x_read_only_flag => p_read_only_flag,
      x_time_group_type_name => p_time_grp_type_name,
      x_description => p_time_grp_type_desc,
      x_creation_date => sysdate,
      x_created_by => c_user_id,
      x_last_update_date => sysdate,
      x_last_updated_by => c_user_id,
      x_last_update_login => null);

Line: 667

SELECT attribute_id,
       attribute_varchar_label,
       attribute_dimension_id,
       attribute_value_column_name
INTO   v_attr_id,
       v_attr_label,
       v_xdim_id,
       v_attr_col
FROM fem_dim_attributes_b
WHERE dimension_id =
   (SELECT dimension_id
    FROM fem_dimensions_b
    WHERE dimension_varchar_label = 'TIME_GROUP_TYPE')
AND attribute_varchar_label = 'PERIODS_IN_YEAR';

Line: 685

SELECT MIN(version_id)
INTO v_ver_id
FROM fem_dim_attr_versions_b
WHERE attribute_id = v_attr_id
AND default_version_flag = 'Y';

Line: 701

   SELECT fem_dim_attr_versions_b_s.NEXTVAL
   INTO v_ver_id FROM dual;

Line: 704

   FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
      x_rowid => v_row_id,
      x_version_id => v_ver_id,
      x_aw_snapshot_flag => c_aw_flg,
      x_version_display_code => p_ver_disp_cd,
      x_object_version_number => c_obj_ver_no,
      x_default_version_flag => 'Y',
      x_personal_flag => c_pers_flg,
      x_attribute_id => v_attr_id,
      x_version_name => p_ver_name,
      x_description => null,
      x_creation_date => sysdate,
      x_created_by => c_user_id,
      x_last_update_date => sysdate,
      x_last_updated_by => c_user_id,
      x_last_update_login => null);

Line: 725

INSERT INTO fem_time_grp_types_attr(
   attribute_id,
   version_id,
   time_group_type_code,
   dim_attribute_numeric_member,
   dim_attribute_value_set_id,
   dim_attribute_varchar_member,
   number_assign_value,
   varchar_assign_value,
   date_assign_value,
   creation_date,
   created_by,
   last_updated_by,
   last_update_date,
   last_update_login,
   aw_snapshot_flag,
   object_version_number)
VALUES(
   v_attr_id,
   v_ver_id,
   p_time_grp_type_code,
   null,
   null,
   null,
   p_periods_in_year,
   null,
   null,
   sysdate,
   c_user_id,
   c_user_id,
   sysdate,
   null,
   c_aw_flg,
   c_obj_ver_no);

Line: 854

   SELECT time_group_type_code
   INTO v_time_grp_type_code
   FROM fem_time_group_types_b
   WHERE time_group_type_code = p_time_grp_type_code;

Line: 876

SELECT dimension_id
INTO v_cal_per_dim_id
FROM fem_dimensions_b
where dimension_varchar_label = 'CAL_PERIOD';

Line: 884

SELECT fem_dimension_grps_b_s.NEXTVAL
INTO v_dim_grp_id
FROM dual;

Line: 891

SELECT fem_time_dimension_group_key_s.NEXTVAL
INTO v_dim_grp_key
FROM dual;

Line: 898

SELECT MAX(dimension_group_seq)+1
INTO v_dim_grp_seq
FROM fem_dimension_grps_b;

Line: 906

   FEM_DIMENSION_GRPS_PKG.INSERT_ROW(
      x_rowid => v_row_id,
      x_dimension_group_id => v_dim_grp_id,
      x_time_dimension_group_key => v_dim_grp_key,
      x_dimension_id => v_cal_per_dim_id,
      x_dimension_group_seq => v_dim_grp_seq,
      x_time_group_type_code => p_time_grp_type_code,
      x_read_only_flag => p_read_only_flag,
      x_object_version_number => c_obj_ver_no,
      x_personal_flag => c_pers_flg,
      x_enabled_flag => c_enbld_flg,
      x_dimension_group_display_code => p_dim_grp_disp_cd,
      x_dimension_group_name => p_dim_grp_name,
      x_description => p_dim_grp_desc,
      x_creation_date => sysdate,
      x_created_by => c_user_id,
      x_last_update_date => sysdate,
      x_last_updated_by => c_user_id,
      x_last_update_login => null);