APPS.PQH_FR_VALIDATION_EVENTS_API SQL Statements

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

Line: 12

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) is
  --
  -- Declare cursors and local variables
  --

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

Line: 37

  savepoint Insert_Validation_event;

Line: 46

   PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_b
   (p_effective_date               => l_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);

Line: 59

        (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
        ,p_hook_type   => 'BP');

Line: 82

     PQH_FR_VALIDATION_EVENTS_BK1.Insert_Validation_event_a
     (p_effective_date               => l_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);

Line: 94

        (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
        ,p_hook_type   => 'AP'
        );

Line: 122

    rollback to Insert_Validation_event;

Line: 136

    rollback to Insert_Validation_event;

Line: 139

end Insert_Validation_event;

Line: 146

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) Is

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

Line: 166

  savepoint Update_Validation_event;

Line: 176

   PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_b
  (p_effective_date                => l_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: 190

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

Line: 212

   PQH_FR_VALIDATION_EVENTS_BK2.Update_Validation_event_a
  (p_effective_date                => l_effective_date
  ,p_validation_event_id        => p_validation_event_id
  ,p_object_version_number      => l_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: 226

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

Line: 250

    rollback to Update_Validation_event;

Line: 263

    rollback to Update_Validation_event;

Line: 266

end Update_Validation_event;

Line: 272

procedure delete_Validation_event
  (
  p_validation_event_id                        in     number
  ,p_object_version_number                in     number
  ) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_Validation_event';

Line: 287

  savepoint delete_Validation_event;

Line: 292

  PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_b
  (p_validation_event_id            => p_validation_event_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 299

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

Line: 314

   PQH_FR_VALIDATION_EVENTS_BK3.Delete_Validation_event_a
  (p_validation_event_id            => p_validation_event_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 322

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

Line: 341

    rollback to delete_Validation_event;

Line: 352

    rollback to delete_Validation_event;

Line: 355

end delete_Validation_event;