APPS.PER_REC_ACTIVITY_FOR_API SQL Statements

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

Line: 128

procedure update_REC_ACTIVITY_FOR
  (p_validate                        in     boolean  default false
  ,p_rec_activity_for_id             in     number
  ,p_vacancy_id                      in     number   default hr_api.g_number
  ,p_rec_activity_id                 in     number   default hr_api.g_number
  ,p_object_version_number           in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 147

  savepoint UPDATE_REC_ACTIVITY_FOR;

Line: 153

    PER_REC_ACTIVITY_FOR_BK2.UPDATE_REC_ACTIVITY_FOR_B
      (
       p_rec_activity_for_id       => p_rec_activity_for_id
      ,p_vacancy_id                => p_vacancy_id
      ,p_rec_activity_id           => p_rec_activity_id
      ,p_object_version_number     => l_object_version_number
      );

Line: 163

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

Line: 182

    PER_REC_ACTIVITY_FOR_BK2.UPDATE_REC_ACTIVITY_FOR_A
      (
       p_rec_activity_for_id       => p_rec_activity_for_id
      ,p_vacancy_id                => p_vacancy_id
      ,p_rec_activity_id           => p_rec_activity_id
      ,p_object_version_number     => l_object_version_number
      );

Line: 193

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

Line: 215

    rollback to UPDATE_REC_ACTIVITY_FOR;

Line: 227

    rollback to UPDATE_REC_ACTIVITY_FOR;

Line: 230

end UPDATE_REC_ACTIVITY_FOR;

Line: 236

procedure delete_rec_activity_for
  (p_validate                      in     boolean  default false
  ,p_rec_activity_for_id           in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 251

  savepoint DELETE_REC_ACTIVITY_FOR;

Line: 257

    PER_REC_ACTIVITY_FOR_BK3.DELETE_REC_ACTIVITY_FOR_B
      (
       p_rec_activity_for_id        => p_rec_activity_for_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 265

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

Line: 285

    PER_REC_ACTIVITY_FOR_BK3.DELETE_REC_ACTIVITY_FOR_A
      (
       p_rec_activity_for_id	 =>	p_rec_activity_for_id
      ,p_object_version_number   =>     p_object_version_number
      );

Line: 293

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

Line: 314

    rollback to DELETE_REC_ACTIVITY_FOR;

Line: 325

    rollback to DELETE_REC_ACTIVITY_FOR;

Line: 328

end DELETE_REC_ACTIVITY_FOR;