APPS.FEM_BR_DIM_LDR_PVT SQL Statements

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

Line: 20

  PROCEDURE DeleteObjectDefinition(
    p_obj_def_id          IN          NUMBER
  )
  IS
    l_api_name    CONSTANT VARCHAR2(30)   := 'DeleteObjectDefinition';

Line: 33

    DELETE FROM fem_dim_load_dim_params WHERE loader_obj_def_id=p_obj_def_id;

Line: 34

    DELETE FROM fem_dim_load_hier_params  WHERE loader_obj_def_id=p_obj_def_id;

Line: 54

  END DeleteObjectDefinition;

Line: 93

       INSERT INTO fem_dim_load_dim_params(
           loader_obj_def_id
          ,dimension_id
          ,created_by
          ,creation_date
          ,last_updated_by
          ,last_update_date
          ,last_update_login
          ,object_version_number
          )
         SELECT
           p_target_obj_def_id
          ,dimension_id
  	  ,nvl(p_created_by,fnd_global.user_id )
          ,nvl(p_creation_date,sysdate)
          ,nvl(p_created_by,fnd_global.user_id )
          ,nvl(p_creation_date,sysdate)
          ,fnd_global.login_id
          ,0
       FROM fem_dim_load_dim_params
       WHERE loader_obj_def_id = p_source_obj_def_id;

Line: 115

       INSERT INTO fem_dim_load_hier_params(
                loader_comp_id
               ,loader_obj_def_id
               ,dimension_id
               ,hier_obj_id
               ,hier_obj_def_id
               ,created_by
               ,creation_date
               ,last_updated_by
               ,last_update_date
               ,last_update_login
               ,object_version_number
       ) SELECT
                fem_dim_loader_comp_id_seq.nextval
               ,p_target_obj_def_id
               ,dimension_id
               ,hier_obj_id
               ,hier_obj_def_id
               ,nvl(p_created_by,fnd_global.user_id )
               ,nvl(p_creation_date,sysdate)
               ,nvl(p_created_by,fnd_global.user_id )
               ,nvl(p_creation_date,sysdate)
               ,fnd_global.login_id
               ,0
       FROM    fem_dim_load_hier_params
       WHERE  LOADER_OBJ_DEF_ID = p_source_obj_def_id;

Line: 185

    SELECT SUM(no_of_rows) INTO l_no_of_rows FROM
    (SELECT COUNT(*) no_of_rows FROM fem_dim_load_hier_params WHERE loader_obj_def_id = p_obj_def_id
     UNION
    SELECT COUNT(*) no_of_rows FROM fem_dim_load_dim_params WHERE loader_obj_def_id = p_obj_def_id
    );