APPS.BEN_EXT_WHERE_CLAUSE_API SQL Statements

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

Line: 175

procedure update_ext_where_clause
  (p_validate                       in  boolean   default false
  ,p_ext_where_clause_id            in  number
  ,p_seq_num                        in  number    default hr_api.g_number
  ,p_oper_cd                        in  varchar2  default hr_api.g_varchar2
  ,p_val                            in  varchar2  default hr_api.g_varchar2
  ,p_and_or_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_ext_data_elmt_id               in  number    default hr_api.g_number
  ,p_cond_ext_data_elmt_id          in  number    default hr_api.g_number
  ,p_ext_rcd_in_file_id             in  number    default hr_api.g_number
  ,p_ext_data_elmt_in_rcd_id        in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_cond_ext_data_elmt_in_rcd_id   in  number    default hr_api.g_number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ext_where_clause';

Line: 204

  savepoint update_ext_where_clause;

Line: 216

    ben_ext_where_clause_bk2.update_ext_where_clause_b
      (
       p_ext_where_clause_id            =>  p_ext_where_clause_id
      ,p_seq_num                        =>  p_seq_num
      ,p_oper_cd                        =>  p_oper_cd
      ,p_val                            =>  p_val
      ,p_and_or_cd                      =>  p_and_or_cd
      ,p_ext_data_elmt_id               =>  p_ext_data_elmt_id
      ,p_cond_ext_data_elmt_id          =>  p_cond_ext_data_elmt_id
      ,p_ext_rcd_in_file_id             =>  p_ext_rcd_in_file_id
      ,p_ext_data_elmt_in_rcd_id        =>  p_ext_data_elmt_in_rcd_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  p_object_version_number
      ,p_cond_ext_data_elmt_in_rcd_id   =>  p_cond_ext_data_elmt_in_rcd_id
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 236

        (p_module_name => 'UPDATE_ext_where_clause'
        ,p_hook_type   => 'BP'
        );

Line: 266

    ben_ext_where_clause_bk2.update_ext_where_clause_a
      (
       p_ext_where_clause_id            =>  p_ext_where_clause_id
      ,p_seq_num                        =>  p_seq_num
      ,p_oper_cd                        =>  p_oper_cd
      ,p_val                            =>  p_val
      ,p_and_or_cd                      =>  p_and_or_cd
      ,p_ext_data_elmt_id               =>  p_ext_data_elmt_id
      ,p_cond_ext_data_elmt_id          =>  p_cond_ext_data_elmt_id
      ,p_ext_rcd_in_file_id             =>  p_ext_rcd_in_file_id
      ,p_ext_data_elmt_in_rcd_id        =>  p_ext_data_elmt_in_rcd_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  l_object_version_number
      ,p_cond_ext_data_elmt_in_rcd_id   =>  p_cond_ext_data_elmt_in_rcd_id
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 286

        (p_module_name => 'UPDATE_ext_where_clause'
        ,p_hook_type   => 'AP'
        );

Line: 315

    ROLLBACK TO update_ext_where_clause;

Line: 327

    ROLLBACK TO update_ext_where_clause;

Line: 330

end update_ext_where_clause;

Line: 335

procedure delete_ext_where_clause
  (p_validate                       in  boolean  default false
  ,p_ext_where_clause_id            in  number
  ,p_legislation_code               in  varchar2  default null
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ext_where_clause';

Line: 354

  savepoint delete_ext_where_clause;

Line: 367

    ben_ext_where_clause_bk3.delete_ext_where_clause_b
      (
       p_ext_where_clause_id            =>  p_ext_where_clause_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      );

Line: 377

        (p_module_name => 'DELETE_ext_where_clause'
        ,p_hook_type   => 'BP'
        );

Line: 397

    ben_ext_where_clause_bk3.delete_ext_where_clause_a
      (
       p_ext_where_clause_id            =>  p_ext_where_clause_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 407

        (p_module_name => 'DELETE_ext_where_clause'
        ,p_hook_type   => 'AP'
        );

Line: 432

    ROLLBACK TO delete_ext_where_clause;

Line: 443

    ROLLBACK TO delete_ext_where_clause;

Line: 446

end delete_ext_where_clause;

Line: 491

  l_proc  varchar2(72) := 'insert_validate';

Line: 494

  SELECT seq_num, and_or_cd
  FROM ben_ext_where_clause xwc
  WHERE ( business_group_id is null
      or business_group_id = p_business_group_id )
  and (legislation_code is null
      or legislation_code = p_legislation_code )
  and (ext_rcd_in_file_id = p_ext_rcd_in_file_id
      or p_ext_rcd_in_file_id is null )
  and (ext_data_elmt_in_rcd_id  = p_ext_data_elmt_in_rcd_id
      or p_ext_data_elmt_in_rcd_id is null)
  and (ext_data_elmt_id = p_ext_data_elmt_id
      or p_ext_data_elmt_id is null)
  ORDER BY seq_num;