APPS.PQH_FR_VALIDATION_PERIODS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_validation_period
  (p_validation_period_id         in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'delete_validation_period';

Line: 28

  savepoint delete_validation_period_swi;

Line: 45

  pqh_fr_validation_periods_api.delete_validation_period
    (p_validation_period_id         => p_validation_period_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 71

    rollback to delete_validation_period_swi;

Line: 85

    rollback to delete_validation_period_swi;

Line: 95

end delete_validation_period;

Line: 99

PROCEDURE insert_validation_period
  (p_effective_date               in     date
  ,p_validation_id                in     number
  ,p_start_date                   in     date      default null
  ,p_end_date                     in     date      default null
  ,p_previous_employer_id         in     number    default null
  ,p_assignment_category	  in	 varchar2  default null
  ,p_normal_hours                 in     number    default null
  ,p_frequency                    in     varchar2  default null
  ,p_period_years                 in     number    default null
  ,p_period_months                in     number    default null
  ,p_period_days                  in     number    default null
  ,p_comments                     in     varchar2  default null
  ,p_validation_status            in     varchar2  default null
  ,p_validation_period_id            out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'insert_validation_period';

Line: 129

  savepoint insert_validation_period_swi;

Line: 149

  pqh_fr_validation_periods_api.insert_validation_period
    (p_effective_date               => p_effective_date
    ,p_validation_id                => p_validation_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_previous_employer_id         => p_previous_employer_id
    ,p_assignment_category	    => p_assignment_category
    ,p_normal_hours                 => p_normal_hours
    ,p_frequency                    => p_frequency
    ,p_period_years                 => p_period_years
    ,p_period_months                => p_period_months
    ,p_period_days                  => p_period_days
    ,p_comments                     => p_comments
    ,p_validation_status            => p_validation_status
    ,p_validation_period_id         => p_validation_period_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 188

    rollback to insert_validation_period_swi;

Line: 204

    rollback to insert_validation_period_swi;

Line: 216

end insert_validation_period;

Line: 220

PROCEDURE update_validation_period
  (p_effective_date               in     date
  ,p_validation_period_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_validation_id                in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_previous_employer_id         in     number    default hr_api.g_number
  ,p_assignment_category	  in 	 varchar2  default hr_api.g_varchar2
  ,p_normal_hours                 in     number    default hr_api.g_number
  ,p_frequency                    in     varchar2  default hr_api.g_varchar2
  ,p_period_years                 in     number    default hr_api.g_number
  ,p_period_months                in     number    default hr_api.g_number
  ,p_period_days                  in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_validation_status            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_object_version_number         number;

Line: 245

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

Line: 251

  savepoint update_validation_period_swi;

Line: 269

  pqh_fr_validation_periods_api.update_validation_period
    (p_effective_date               => p_effective_date
    ,p_validation_period_id         => p_validation_period_id
    ,p_object_version_number        => p_object_version_number
    ,p_validation_id                => p_validation_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_previous_employer_id         => p_previous_employer_id
    ,p_assignment_category	    => p_assignment_category
    ,p_normal_hours                 => p_normal_hours
    ,p_frequency                    => p_frequency
    ,p_period_years                 => p_period_years
    ,p_period_months                => p_period_months
    ,p_period_days                  => p_period_days
    ,p_comments                     => p_comments
    ,p_validation_status            => p_validation_status
    );

Line: 308

    rollback to update_validation_period_swi;

Line: 323

    rollback to update_validation_period_swi;

Line: 334

end update_validation_period;