APPS.FEM_BR_CONDITION_PVT SQL Statements

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

Line: 25

PROCEDURE DeleteConditions(
  p_obj_def_id in number
);

Line: 36

PROCEDURE DeleteCondComponentDtls(
 p_condition_obj_def_id             in number
 ,p_cond_component_obj_id         in number
 ,p_data_dim_flag                 in char
);

Line: 57

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS

  l_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';

Line: 76

  DeleteConditions(
    p_obj_def_id     => p_obj_def_id
  );

Line: 105

END DeleteObjectDefinition;

Line: 169

PROCEDURE DeleteCondComponent(
  p_condition_obj_def_id             in          number
  ,p_cond_component_obj_id         in          number
  ,p_data_dim_flag                 in          char
  ,p_init_msg_list                 in          varchar2
  ,x_return_status                 out nocopy  varchar2
  ,x_msg_count                     out nocopy  number
  ,x_msg_data                      out nocopy  varchar2
)
--------------------------------------------------------------------------------
IS

  g_api_name    constant varchar2(30)   := 'DeleteCondComponent';

Line: 205

    ,p_msg_text => 'Before DeleteCondComponentDtls'
  );

Line: 209

  DeleteCondComponentDtls(
    p_condition_obj_def_id        => p_condition_obj_def_id
    ,p_cond_component_obj_id     => p_cond_component_obj_id
    ,p_data_dim_flag => p_data_dim_flag
  );

Line: 218

    ,p_msg_text => 'After DeleteCondComponentDtls'
  );

Line: 272

END DeleteCondComponent;

Line: 293

PROCEDURE DeleteConditions(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS

  x_return_status varchar2(1);

Line: 309

    SELECT cond_component_obj_id,
           data_dim_flag
      from fem_cond_components
     where condition_obj_def_id = p_obj_def_id;

Line: 313

  l_api_name    constant varchar2(30)   := 'DeleteConditions';

Line: 330

    SELECT count(*)
      INTO v_component_rows_num
      FROM fem_cond_components
     WHERE cond_component_obj_id = v_cond_comp_obj_id;

Line: 348

      ,p_msg_text => 'before calling DeleteCondComponent'
      );

Line: 350

      DeleteCondComponent(
        p_obj_def_id
        ,v_cond_comp_obj_id
        ,v_data_dim_flag
        ,FND_API.G_FALSE
        ,x_return_status
        ,x_msg_count
        ,x_msg_data
      );

Line: 362

      ,p_msg_text => 'after calling DeleteCondComponent'
      );

Line: 375

  delete from fem_cond_components
  where condition_obj_def_id = p_obj_def_id;

Line: 378

  delete from fem_object_dependencies where object_definition_id = p_obj_def_id;

Line: 384

END DeleteConditions;

Line: 412

  insert into fem_cond_components(
    condition_obj_def_id
    ,cond_component_obj_id
    ,data_dim_flag
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,cond_component_obj_id
    ,data_dim_flag
    ,nvl(p_created_by,FND_GLOBAL.user_id)
    ,nvl(p_creation_date,sysdate)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,object_version_number
  from fem_cond_components
  where condition_obj_def_id = p_source_obj_def_id;

Line: 449

PROCEDURE DeleteCondComponentDtls(
 p_condition_obj_def_id             in number
 ,p_cond_component_obj_id         in number
 ,p_data_dim_flag                 in char
)
--------------------------------------------------------------------------------
IS

l_cond_component_obj_def_id     number;

Line: 462

l_api_name    constant varchar2(30)   := 'DeleteCondComponentDtls';

Line: 476

  SELECT count(*)
    INTO v_component_rows_num
    FROM fem_cond_components
   WHERE cond_component_obj_id = p_cond_component_obj_id
     AND condition_obj_def_id <> p_condition_obj_def_id;

Line: 496

    SELECT OBJECT_DEFINITION_ID
      INTO l_cond_component_obj_def_id
      FROM FEM_OBJECT_DEFINITION_VL
     WHERE OBJECT_ID = p_cond_component_obj_id;

Line: 546

        delete from fem_cond_data_cmp_st_dtl
         where cond_data_cmp_obj_def_id = l_cond_component_obj_def_id;

Line: 549

        delete from fem_cond_data_cmp_steps
         where cond_data_cmp_obj_def_id = l_cond_component_obj_def_id;

Line: 552

        delete from fem_cond_data_cmp_tables
         where cond_data_cmp_obj_def_id = l_cond_component_obj_def_id;

Line: 563

        delete from fem_cond_dim_cmp_dtl
         where cond_dim_cmp_obj_def_id = l_cond_component_obj_def_id;

Line: 566

        delete from fem_cond_dim_components
         where cond_dim_cmp_obj_def_id = l_cond_component_obj_def_id;

Line: 575

          ,p_msg_text => 'Before delete from fem_object_dependencies'
      );

Line: 577

      delete from fem_object_dependencies
        where object_definition_id = l_cond_component_obj_def_id;

Line: 580

      delete from fem_object_definition_vl
       where object_definition_id = l_cond_component_obj_def_id;

Line: 583

      delete from fem_object_catalog_vl
       where object_id = p_cond_component_obj_id;

Line: 589

          ,p_msg_text => 'After delete from fem_object_catalog_vl'
      );

Line: 617

END DeleteCondComponentDtls;