APPS.PER_REQUISITIONS_API SQL Statements

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

Line: 263

procedure update_requisition
  (p_validate                      in     boolean  default false
  ,p_requisition_id                in     number
  ,p_object_version_number         in out nocopy number
  ,p_date_from                     in	  date     default hr_api.g_date
  ,p_person_id                     in     number   default hr_api.g_number
  ,p_comments                      in     varchar2 default hr_api.g_varchar2
  ,p_date_to                       in     date     default hr_api.g_date
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 318

  savepoint update_requisition;

Line: 328

    PER_REQUISITIONS_BK2.UPDATE_REQUISITION_b
      (
      p_requisition_id             => p_requisition_id
     ,p_object_version_number      => l_object_version_number
     ,p_date_from                  => l_date_from
     ,p_person_id                  => p_person_id
     ,p_comments                   => p_comments
     ,p_date_to			   => l_date_to
     ,p_description                => p_description
     ,p_attribute_category         => p_attribute_category
     ,p_attribute1                 => p_attribute1
     ,p_attribute2		   => p_attribute2
     ,p_attribute3                 => p_attribute3
     ,p_attribute4                 => p_attribute4
     ,p_attribute5                 => p_attribute5
     ,p_attribute6                 => p_attribute6
     ,p_attribute7                 => p_attribute7
     ,p_attribute8                 => p_attribute8
     ,p_attribute9                 => p_attribute9
     ,p_attribute10                => p_attribute10
     ,p_attribute11                => p_attribute11
     ,p_attribute12                => p_attribute12
     ,p_attribute13                => p_attribute13
     ,p_attribute14                => p_attribute14
     ,p_attribute15                => p_attribute15
     ,p_attribute16                => p_attribute16
     ,p_attribute17                => p_attribute17
     ,p_attribute18                => p_attribute18
     ,p_attribute19                => p_attribute19
     ,p_attribute20                => p_attribute20
     ,p_attribute21                => p_attribute21
     ,p_attribute22                => p_attribute22
     ,p_attribute23                => p_attribute23
     ,p_attribute24                => p_attribute24
     ,p_attribute25                => p_attribute25
     ,p_attribute26                => p_attribute26
     ,p_attribute27                => p_attribute27
     ,p_attribute28                => p_attribute28
     ,p_attribute29                => p_attribute29
     ,p_attribute30                => p_attribute30
     );

Line: 372

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

Line: 419

    PER_REQUISITIONS_BK2.UPDATE_REQUISITION_a
      (
       p_requisition_id                => p_requisition_id
      ,p_object_version_number         => l_object_version_number
      ,p_date_from                     => l_date_from
      ,p_person_id                     => p_person_id
      ,p_comments                      => p_comments
      ,p_date_to                       => l_date_to
      ,p_description                   => p_description
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2		       => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_attribute21                   => p_attribute21
      ,p_attribute22                   => p_attribute22
      ,p_attribute23                   => p_attribute23
      ,p_attribute24                   => p_attribute24
      ,p_attribute25                   => p_attribute25
      ,p_attribute26                   => p_attribute26
      ,p_attribute27                   => p_attribute27
      ,p_attribute28                   => p_attribute28
      ,p_attribute29                   => p_attribute29
      ,p_attribute30                   => p_attribute30
      );

Line: 463

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

Line: 485

    rollback to UPDATE_REQUISITION;

Line: 497

    rollback to UPDATE_REQUISITION;

Line: 500

end UPDATE_REQUISITION;

Line: 506

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

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

Line: 521

  savepoint delete_requisition;

Line: 527

    PER_REQUISITIONS_BK3.DELETE_REQUISITION_b
      (
       p_requisition_id             => p_requisition_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 535

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

Line: 555

    PER_REQUISITIONS_BK3.DELETE_REQUISITION_a
      (
       p_requisition_id                => p_requisition_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 563

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

Line: 584

    rollback to DELETE_REQUISITION;

Line: 595

    rollback to DELETE_REQUISITION;

Line: 598

end DELETE_REQUISITION;