APPS.PAY_DATETRACKED_EVENTS_API SQL Statements

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

Line: 19

  ,p_update_type                    in     varchar2
  ,p_column_name                    in     varchar2
  ,p_business_group_id              in     number
  ,p_legislation_code               in     varchar2
  ,p_proration_style                in     varchar2 default null
  ,p_datetracked_event_id              out nocopy number
  ,p_object_version_number             out nocopy number
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'create_datetracked_event';

Line: 51

  ,p_update_type                 => p_update_type
  ,p_column_name                 => p_column_name
  ,p_business_group_id           => p_business_group_id
  ,p_legislation_code            => p_legislation_code
  ,p_proration_style             => p_proration_style
  );

Line: 71

  ,p_update_type                 => p_update_type
  ,p_column_name                 => p_column_name
  ,p_business_group_id           => p_business_group_id
  ,p_legislation_code            => p_legislation_code
  ,p_datetracked_event_id        => l_datetracked_event_id
  ,p_object_version_number       => l_object_version_number
  ,p_proration_style             => p_proration_style
  );

Line: 87

  ,p_update_type                 => p_update_type
  ,p_column_name                 => p_column_name
  ,p_business_group_id           => p_business_group_id
  ,p_legislation_code            => p_legislation_code
  ,p_datetracked_event_id        => l_datetracked_event_id
  ,p_object_version_number       => l_object_version_number
  ,p_proration_style             => p_proration_style
  );

Line: 128

procedure update_datetracked_event
  (p_validate                       in     boolean default false
  ,p_effective_date               in     date
  ,p_datetracked_event_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_event_group_id               in     number    default hr_api.g_number
  ,p_dated_table_id               in     number    default hr_api.g_number
  ,p_update_type                  in     varchar2  default hr_api.g_varchar2
  ,p_column_name                  in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_proration_style              in     varchar2  default hr_api.g_varchar2
  )  IS
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package ||'update_datetracked_event';

Line: 152

    savepoint update_datetracked_event;

Line: 160

  pay_datetracked_events_bk2.update_datetracked_event_b
    (p_effective_date              => p_effective_date
    ,p_datetracked_event_id        => p_datetracked_event_id
    ,p_object_version_number       => l_object_version_number
    ,p_event_group_id              => p_event_group_id
    ,p_dated_table_id              => p_dated_table_id
    ,p_update_type                 => p_update_type
    ,p_column_name                 => p_column_name
    ,p_business_group_id           => p_business_group_id
    ,p_legislation_code            => p_legislation_code
    ,p_proration_style             => p_proration_style
    );

Line: 175

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

Line: 186

    ,p_update_type                 => p_update_type
    ,p_column_name                 => p_column_name
    ,p_business_group_id           => p_business_group_id
    ,p_legislation_code            => p_legislation_code
    ,p_proration_style             => p_proration_style
    );

Line: 198

  pay_datetracked_events_bk2.update_datetracked_event_a
    (p_effective_date              => p_effective_date
    ,p_datetracked_event_id        => p_datetracked_event_id
    ,p_object_version_number       => l_object_version_number
    ,p_event_group_id              => p_event_group_id
    ,p_dated_table_id              => p_dated_table_id
    ,p_update_type                 => p_update_type
    ,p_column_name                 => p_column_name
    ,p_business_group_id           => p_business_group_id
    ,p_legislation_code            => p_legislation_code
    ,p_proration_style             => p_proration_style
    );

Line: 214

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

Line: 233

    ROLLBACK TO update_datetracked_event;

Line: 235

end update_datetracked_event;

Line: 245

procedure delete_datetracked_event
  (p_validate                       in     boolean default false
  ,p_datetracked_event_id                 in     number
  ,p_object_version_number                in     number
  ) IS
 --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_datetracked_event';

Line: 260

    savepoint delete_datetracked_event;

Line: 269

  pay_datetracked_events_bk3.delete_datetracked_event_b
  ( p_datetracked_event_id        => p_datetracked_event_id
   ,p_object_version_number       => l_object_version_number
  );

Line: 276

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

Line: 291

  pay_datetracked_events_bk3.delete_datetracked_event_a
  ( p_datetracked_event_id        => p_datetracked_event_id
   ,p_object_version_number       => l_object_version_number
  );

Line: 298

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

Line: 311

    ROLLBACK TO delete_datetracked_event;

Line: 313

end delete_datetracked_event;