eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_RECRUITING_SITES_API SQL Statements

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

Line: 333


procedure UPDATE_RECRUITING_SITE
  (p_recruiting_site_id            in     number
  ,p_validate                      in     boolean  default false
  ,p_language_code                 in     varchar2 default hr_api.userenv_lang
  ,p_effective_date                in     date
  ,p_site_name                     in     varchar2 default hr_api.g_varchar2
  ,p_date_from                     in     date  default hr_api.g_date
  ,p_date_to                       in     date  default hr_api.g_date
  ,p_posting_username              in     varchar2  default hr_api.g_varchar2
  ,p_posting_password              in     varchar2  default hr_api.g_varchar2
  ,p_internal                      in     varchar2 default hr_api.g_varchar2
  ,p_external                      in     varchar2 default hr_api.g_varchar2
  ,p_third_party                   in     varchar2 default hr_api.g_varchar2
  ,p_redirection_url               in     varchar2 default hr_api.g_varchar2
  ,p_posting_url                   in     varchar2 default hr_api.g_varchar2
  ,p_posting_cost                  in     number   default hr_api.g_number
  ,p_posting_cost_period           in     varchar2 default hr_api.g_varchar2
  ,p_posting_cost_currency         in     varchar2 default hr_api.g_varchar2
  ,p_stylesheet           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
  ,p_object_version_number         in out nocopy number
  ,p_posting_impl_class            in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package||'UPDATE_RECRUITING_SITE';

Line: 400


  savepoint UPDATE_RECRUITING_SITE;

Line: 412


    IRC_RECRUITING_SITES_BK2.UPDATE_RECRUITING_SITE_B
      (p_recruiting_site_id => p_recruiting_site_id
      ,p_effective_date     => l_effective_date
      ,p_language_code      => l_language_code
      ,p_site_name            => p_site_name
      ,p_date_from            => p_date_from
      ,p_date_to              => p_date_to
      ,p_posting_username     => p_posting_username
      ,p_posting_password     => p_posting_password
      ,p_internal             => p_internal
      ,p_external             => p_external
      ,p_third_party          => p_third_party
      ,p_redirection_url      => p_redirection_url
      ,p_posting_url          => p_posting_url
      ,p_posting_cost         => p_posting_cost
      ,p_posting_cost_period  => p_posting_cost_period
      ,p_posting_cost_currency=> p_posting_cost_currency
      ,p_stylesheet  => p_stylesheet
      ,p_object_version_number=> l_object_version_number
      ,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
      ,p_posting_impl_class => p_posting_impl_class
      );

Line: 467


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

Line: 548


    IRC_RECRUITING_SITES_BK2.UPDATE_RECRUITING_SITE_A
      (p_recruiting_site_id => p_recruiting_site_id
      ,p_effective_date     => l_effective_date
      ,p_language_code      => l_language_code
      ,p_site_name            => p_site_name
      ,p_date_from            => p_date_from
      ,p_date_to              => p_date_to
      ,p_posting_username     => p_posting_username
      ,p_posting_password     => p_posting_password
      ,p_internal             => p_internal
      ,p_external             => p_external
      ,p_third_party          => p_third_party
      ,p_redirection_url      => p_redirection_url
      ,p_posting_url          => p_posting_url
      ,p_posting_cost         => p_posting_cost
      ,p_posting_cost_period  => p_posting_cost_period
      ,p_posting_cost_currency=> p_posting_cost_currency
      ,p_stylesheet           => p_stylesheet
      ,p_object_version_number=> l_object_version_number
      ,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
      ,p_posting_impl_class   => p_posting_impl_class
      );

Line: 603


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

Line: 625


    rollback to UPDATE_RECRUITING_SITE;

Line: 640


    rollback to UPDATE_RECRUITING_SITE;

Line: 647


end UPDATE_RECRUITING_SITE;

Line: 653


procedure DELETE_RECRUITING_SITE
  (p_validate                      in     boolean  default false
  ,p_recruiting_site_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package||'DELETE_RECRUITING_SITE';

Line: 668


  savepoint DELETE_RECRUITING_SITE;

Line: 676


    IRC_RECRUITING_SITES_BK3.DELETE_RECRUITING_SITE_B
      (p_recruiting_site_id           => p_recruiting_site_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 683


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

Line: 719


    IRC_RECRUITING_SITES_BK3.DELETE_RECRUITING_SITE_A
      (p_recruiting_site_id            => p_recruiting_site_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 726


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

Line: 747


    rollback to DELETE_RECRUITING_SITE;

Line: 759


    rollback to DELETE_RECRUITING_SITE;

Line: 762


end DELETE_RECRUITING_SITE;