APPS.PQH_FR_VALIDATION_EVENTS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_validation_event
  (p_validation_event_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_event';

Line: 28

  savepoint delete_validation_event_swi;

Line: 45

  pqh_fr_validation_events_api.delete_validation_event
    (p_validation_event_id          => p_validation_event_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 71

    rollback to delete_validation_event_swi;

Line: 85

    rollback to delete_validation_event_swi;

Line: 95

end delete_validation_event;

Line: 99

PROCEDURE insert_validation_event
  (p_effective_date               in     date
  ,p_validation_id                in     number
  ,p_event_type                   in     varchar2
  ,p_event_code                   in     varchar2
  ,p_start_date                   in     date      default null
  ,p_end_date                     in     date      default null
  ,p_comments                     in     varchar2  default null
  ,p_validation_event_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_event';

Line: 123

  savepoint insert_validation_event_swi;

Line: 143

  pqh_fr_validation_events_api.insert_validation_event
    (p_effective_date               => p_effective_date
    ,p_validation_id                => p_validation_id
    ,p_event_type                   => p_event_type
    ,p_event_code                   => p_event_code
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_comments                     => p_comments
    ,p_validation_event_id          => p_validation_event_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 176

    rollback to insert_validation_event_swi;

Line: 192

    rollback to insert_validation_event_swi;

Line: 204

end insert_validation_event;

Line: 208

PROCEDURE update_validation_event
  (p_effective_date               in     date
  ,p_validation_event_id          in     number
  ,p_object_version_number        in out nocopy number
  ,p_validation_id                in     number    default hr_api.g_number
  ,p_event_type                   in     varchar2  default hr_api.g_varchar2
  ,p_event_code                   in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_comments                     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: 227

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

Line: 233

  savepoint update_validation_event_swi;

Line: 251

  pqh_fr_validation_events_api.update_validation_event
    (p_effective_date               => p_effective_date
    ,p_validation_event_id          => p_validation_event_id
    ,p_object_version_number        => p_object_version_number
    ,p_validation_id                => p_validation_id
    ,p_event_type                   => p_event_type
    ,p_event_code                   => p_event_code
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_comments                     => p_comments
    );

Line: 284

    rollback to update_validation_event_swi;

Line: 299

    rollback to update_validation_event_swi;

Line: 310

end update_validation_event;