APPS.FEM_DIM_SNAPSHOT_UTIL_PKG SQL Statements

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

Line: 174

SELECT count(*)
INTO v_count
FROM fem_object_definition_b D, fem_object_catalog_b O
WHERE D.object_definition_id = p_dim_snapshot_obj_def_id
AND D.object_id = O.object_id
AND O.object_type_code = 'DIMENSION_SNAPSHOT';

Line: 187

   SELECT dimension_id
   INTO v_dimension_id
   FROM fem_xdim_dimensions_vl
   WHERE dimension_varchar_label = p_dimension_varchar_label;

Line: 196

   INSERT INTO fem_dsnp_rule_dims (
      DIM_SNAPSHOT_OBJ_DEF_ID
     ,DIMENSION_ID
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATE_LOGIN   )
   SELECT p_dim_snapshot_obj_def_id
         ,v_dimension_id
         ,sysdate
         ,c_user_id
         ,c_user_id
         ,sysdate
         ,c_login_id
   FROM dual;

Line: 381

SELECT count(*)
INTO v_count
FROM fem_object_definition_b D, fem_object_catalog_b O
WHERE D.object_definition_id = p_dim_snapshot_obj_def_id
AND D.object_id = O.object_id
AND O.object_type_code = 'DIMENSION_SNAPSHOT';

Line: 394

   SELECT dimension_id
   INTO v_dimension_id
   FROM fem_xdim_dimensions_vl
   WHERE dimension_varchar_label = p_dimension_varchar_label;

Line: 402

DELETE FROM fem_dsnp_rule_dims
WHERE dim_snapshot_obj_def_id = p_dim_snapshot_obj_def_id
AND dimension_id = v_dimension_id;