APPS.FEM_AW_SNAPSHOT_PKG SQL Statements

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

Line: 36

SELECT distinct dimension_id
FROM   fem_dim_attributes_b;

Line: 40

SELECT attribute_id
FROM   fem_dim_attributes_b
WHERE  dimension_id = v_dim_id;

Line: 60

   SELECT member_col,
          attribute_table_name
   INTO   v_member_col,
          v_dim_attr_tab
   FROM   fem_xdim_dimensions
   WHERE  dimension_id = v_dim_id;

Line: 84

         SELECT version_id
         INTO   v_old_ver_id
         FROM   fem_dim_attr_versions_b
         WHERE  attribute_id = v_attr_id
         AND    aw_snapshot_flag = 'Y';

Line: 90

         FEM_DIM_ATTR_VERSIONS_PKG.DELETE_ROW
           (x_version_id => v_old_ver_id);

Line: 96

             'DELETE FROM '||v_dim_attr_tab||
             ' WHERE attribute_id = '||v_attr_id||
             ' AND version_id = '||v_old_ver_id;

Line: 108

         SELECT version_id
         INTO   v_def_ver_id
         FROM   fem_dim_attr_versions_b
         WHERE  attribute_id = v_attr_id
         AND    default_version_flag = 'Y';

Line: 146

            SELECT source_lang,
                   version_name,
                   description,
                   version_display_code
            INTO   v_source_lang,
                   v_ver_name,
                   v_ver_desc,
                   v_ver_dc
            FROM   fem_dim_attr_versions_tl T,
                   fem_dim_attr_versions_b  B
            WHERE  T.version_id = v_def_ver_id
            AND    B.version_id = T.version_id
            AND    T.language = c_lang;

Line: 190

            SELECT fem_dim_attr_versions_b_s.NEXTVAL
            INTO v_new_ver_id FROM dual;

Line: 195

            FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
              x_rowid => v_rowid,
              x_version_id => v_new_ver_id,
              x_aw_snapshot_flag => 'Y',
              x_version_display_code => v_ver_dc,
              x_object_version_number => 1,
              x_default_version_flag => 'N',
              x_personal_flag => 'N',
              x_attribute_id => v_attr_id,
              x_version_name => v_ver_name,
              x_description => v_ver_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: 228

                 'INSERT INTO '||v_dim_attr_tab||
                   '(attribute_id,'||
                   'version_id,'||
                   v_member_col||','||
                   '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,'||
                   'object_version_number,'||
                   'aw_snapshot_flag';

Line: 244

                 'SELECT '||
                   v_attr_id||','||
                   v_new_ver_id||','||
                   v_member_col||','||
                   'dim_attribute_numeric_member,'||
                   'dim_attribute_varchar_member,'||
                   'number_assign_value,'||
                   'varchar_assign_value,'||
                   'date_assign_value,'||
                   ''''||sysdate||''','||
                   c_user_id||','||
                   c_user_id||','||
                   ''''||sysdate||''','||
                   1||','||
                   '''Y'' ';

Line: 265

                  SELECT 1
                  INTO v_vs_col_exists
                  FROM all_tab_columns
                  WHERE owner = 'FEM'
                  AND table_name = v_dim_attr_tab
                  AND column_name = 'VALUE_SET_ID';