APPS.PAY_EVENT_QUALIFIERS_API SQL Statements

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

Line: 48

  select  event_qualifier_id
        , effective_start_date
        , effective_end_date
        , object_version_number
  from    pay_event_qualifiers_f
  where   dated_table_id = p_dated_table_id
  and     column_name    = p_column_name
  and     qualifier_name = p_qualifier_name;

Line: 181

END IF; -- Only done insert and hooks if %notfound

Line: 236

procedure update_event_qualifier
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_datetrack_update_mode        in     varchar2
  ,p_event_qualifier_id           in     number
  ,p_dated_table_id               in     number
  ,p_column_name                  in     varchar2
  ,p_qualifier_name               in     varchar2
  ,p_object_version_number        in out nocopy number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_comparison_column            in     varchar2  default hr_api.g_varchar2
  ,p_qualifier_definition         in     varchar2  default hr_api.g_varchar2
  ,p_qualifier_where_clause       in     varchar2  default hr_api.g_varchar2
  ,p_entry_qualification          in     varchar2  default hr_api.g_varchar2
  ,p_assignment_qualification     in     varchar2  default hr_api.g_varchar2
  ,p_multi_event_sql              in     varchar2  default hr_api.g_varchar2
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_event_qualifier';

Line: 279

  savepoint update_event_qualifier;

Line: 290

    pay_event_qualifiers_bk2.update_event_qualifier_b
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_update_mode      =>  p_datetrack_update_mode
      ,p_event_qualifier_id         =>  p_event_qualifier_id
      ,p_dated_table_id             =>  p_dated_table_id
      ,p_column_name                =>  p_column_name
      ,p_qualifier_name             =>  p_qualifier_name
      ,p_legislation_code           =>  p_legislation_code
      ,p_business_group_id          =>  p_business_group_id
      ,p_comparison_column          =>  p_comparison_column
      ,p_qualifier_definition       =>  p_qualifier_definition
      ,p_qualifier_where_clause     =>  p_qualifier_where_clause
      ,p_entry_qualification        =>  p_entry_qualification
      ,p_assignment_qualification   =>  p_assignment_qualification
      ,p_multi_event_sql            =>  p_multi_event_sql
      ,p_object_version_number      =>  p_object_version_number
      );

Line: 310

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

Line: 326

    ,p_datetrack_mode             =>  p_datetrack_update_mode
    ,p_event_qualifier_id         =>  p_event_qualifier_id
    ,p_object_version_number      =>  l_object_version_number
    ,p_comparison_column          =>  p_comparison_column
    ,p_qualifier_definition       =>  p_qualifier_definition
    ,p_qualifier_where_clause     =>  p_qualifier_where_clause
    ,p_entry_qualification        =>  p_entry_qualification
    ,p_assignment_qualification   =>  p_assignment_qualification
    ,p_multi_event_sql            =>  p_multi_event_sql
    ,p_effective_start_date       =>  l_effective_start_date
    ,p_effective_end_date         =>  l_effective_end_date
    );

Line: 346

    pay_event_qualifiers_bk2.update_event_qualifier_a
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_update_mode      =>  p_datetrack_update_mode
      ,p_event_qualifier_id         =>  p_event_qualifier_id
      ,p_dated_table_id             =>  p_dated_table_id
      ,p_column_name                =>  p_column_name
      ,p_qualifier_name             =>  p_qualifier_name
      ,p_legislation_code           =>  p_legislation_code
      ,p_business_group_id          =>  p_business_group_id
      ,p_comparison_column          =>  p_comparison_column
      ,p_qualifier_definition       =>  p_qualifier_definition
      ,p_qualifier_where_clause     =>  p_qualifier_where_clause
      ,p_entry_qualification        =>  p_entry_qualification
      ,p_assignment_qualification   =>  p_assignment_qualification
      ,p_multi_event_sql            =>  p_multi_event_sql
      ,p_object_version_number      =>  p_object_version_number
      ,p_effective_start_date       =>  l_effective_start_date
      ,p_effective_end_date         =>  l_effective_end_date
      );

Line: 368

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

Line: 393

    rollback to update_event_qualifier;

Line: 407

    rollback to update_event_qualifier;

Line: 413

end update_event_qualifier;

Line: 420

procedure delete_event_qualifier
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_delete_mode         in     varchar2
  ,p_event_qualifier_id            in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               varchar2(72) := g_package||'delete_event_qualifier';

Line: 450

  savepoint delete_event_qualifier;

Line: 460

    pay_event_qualifiers_bk3.delete_event_qualifier_b
     (p_effective_date                =>     l_effective_date
     ,p_datetrack_delete_mode         =>     p_datetrack_delete_mode
     ,p_event_qualifier_id            =>     p_event_qualifier_id
     ,p_object_version_number         =>     p_object_version_number
     ,p_business_group_id             =>     p_business_group_id
     ,p_legislation_code              =>     p_legislation_code
     );

Line: 472

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

Line: 485

  if p_datetrack_delete_mode = hr_api.g_zap then
  --
    pay_evq_shd.lck(p_effective_date        => l_effective_date
                   ,p_datetrack_mode        => p_datetrack_delete_mode
                   ,p_event_qualifier_id    => p_event_qualifier_id
                   ,p_object_version_number => p_object_version_number
                   ,p_validation_start_date => l_validation_start_date
                   ,p_validation_end_date   => l_validation_end_date
                   );

Line: 501

      ,p_datetrack_mode               => p_datetrack_delete_mode
      ,p_event_qualifier_id                  => p_event_qualifier_id
      ,p_object_version_number        => p_object_version_number
      ,p_effective_start_date         => l_effective_start_date
      ,p_effective_end_date           => l_effective_end_date
      );

Line: 513

    pay_event_qualifiers_bk3.delete_event_qualifier_a
      (p_effective_date            => l_effective_date
      ,p_datetrack_delete_mode     => p_datetrack_delete_mode
      ,p_event_qualifier_id        => p_event_qualifier_id
      ,p_object_version_number     => p_object_version_number
      ,p_business_group_id         => p_business_group_id
      ,p_legislation_code          => p_legislation_code
      ,p_effective_start_date      => l_effective_start_date
      ,p_effective_end_date        => l_effective_end_date
      );

Line: 546

    ROLLBACK TO delete_event_qualifier;

Line: 560

    ROLLBACK TO delete_event_qualifier;

Line: 567

end delete_event_qualifier;