APPS.PSP_PERIOD_FREQUENCY_SWI SQL Statements

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

Line: 125

PROCEDURE update_period_frequency
  (p_validate                     in     number   default hr_api.g_false_num
  ,p_start_date                   in     date
  ,p_unit_of_measure              in     varchar2
  ,p_period_duration              in     number
  ,p_report_type                  in     varchar2  default hr_api.g_varchar2
  ,p_period_frequency             in     varchar2
  ,p_period_frequency_id          in     number
  ,p_object_version_number        in out nocopy number
  ,p_api_warning                     out nocopy varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 145

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

Line: 151

  savepoint update_period_frequency_swi;

Line: 172

  psp_period_frequency_api.update_period_frequency
    (p_validate                     => l_validate
    ,p_start_date                   => p_start_date
    ,p_unit_of_measure              => p_unit_of_measure
    ,p_period_duration              => p_period_duration
    ,p_report_type                  => p_report_type
    ,p_period_frequency             => p_period_frequency
    ,p_period_frequency_id          => p_period_frequency_id
    ,p_object_version_number        => p_object_version_number
    ,p_api_warning                  => p_api_warning
    );

Line: 205

    rollback to update_period_frequency_swi;

Line: 220

    rollback to update_period_frequency_swi;

Line: 231

end update_period_frequency;

Line: 235

PROCEDURE delete_period_frequency
  (p_validate                     in     number   default hr_api.g_false_num
  ,p_period_frequency_id          in     number
  ,p_object_version_number        in out nocopy number
  ,p_api_warning                     out nocopy varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 250

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

Line: 256

  savepoint delete_period_frequency_swi;

Line: 277

  psp_period_frequency_api.delete_period_frequency
    (p_validate                     => l_validate
    ,p_period_frequency_id          => p_period_frequency_id
    ,p_object_version_number        => p_object_version_number
    ,p_api_warning                  => p_api_warning
    );

Line: 305

    rollback to delete_period_frequency_swi;

Line: 320

    rollback to delete_period_frequency_swi;

Line: 331

end delete_period_frequency;