APPS.PAY_TIME_DEFINITION_SWI SQL Statements

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

Line: 141

PROCEDURE update_time_definition
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_time_definition_id           in     number
  ,p_definition_name              in     varchar2  default hr_api.g_varchar2
  ,p_period_type                  in     varchar2  default hr_api.g_varchar2
  ,p_period_unit                  in     varchar2  default hr_api.g_varchar2
  ,p_day_adjustment               in     varchar2  default hr_api.g_varchar2
  ,p_dynamic_code                 in     varchar2  default hr_api.g_varchar2
  ,p_number_of_years              in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_period_time_definition_id    in     number    default hr_api.g_number
  ,p_creator_id                   in     number    default hr_api.g_number
  ,p_creator_type                 in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 166

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

Line: 172

  savepoint update_time_definition_swi;

Line: 193

  pay_time_definition_api.update_time_definition
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_time_definition_id           => p_time_definition_id
    ,p_definition_name              => p_definition_name
    ,p_period_type                  => p_period_type
    ,p_period_unit                  => p_period_unit
    ,p_day_adjustment               => p_day_adjustment
    ,p_dynamic_code                 => p_dynamic_code
    ,p_number_of_years              => p_number_of_years
    ,p_start_date                   => p_start_date
    ,p_period_time_definition_id    => p_period_time_definition_id
    ,p_creator_id                   => p_creator_id
    ,p_creator_type                 => p_creator_type
    ,p_object_version_number        => p_object_version_number
    );

Line: 231

    rollback to update_time_definition_swi;

Line: 246

    rollback to update_time_definition_swi;

Line: 257

end update_time_definition;

Line: 261

PROCEDURE delete_time_definition
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_time_definition_id           in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 275

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

Line: 281

  savepoint delete_time_definition_swi;

Line: 301

  pay_time_definition_api.delete_time_definition
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_time_definition_id           => p_time_definition_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 329

    rollback to delete_time_definition_swi;

Line: 343

    rollback to delete_time_definition_swi;

Line: 353

end delete_time_definition;