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.PER_RECRUITMENT_ACTIVITY_API SQL Statements

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

Line: 285


procedure UPDATE_RECRUITMENT_ACTIVITY
  (p_validate                      in   boolean    default false
  ,p_recruitment_activity_id       in   number
  ,p_authorising_person_id         in   number     default hr_api.g_number
  ,p_run_by_organization_id        in   number     default hr_api.g_number
  ,p_internal_contact_person_id    in   number     default hr_api.g_number
  ,p_parent_recruitment_activity   in   number     default hr_api.g_number
  ,p_currency_code                 in   varchar2   default hr_api.g_varchar2
  ,p_date_start                    in   date       default hr_api.g_date
  ,p_name                          in   varchar2   default hr_api.g_varchar2
  ,p_actual_cost                   in   varchar2   default hr_api.g_varchar2
  ,p_comments                      in   long       default hr_api.g_varchar2
  ,p_contact_telephone_number      in   varchar2   default hr_api.g_varchar2
  ,p_date_closing                  in   date       default hr_api.g_date
  ,p_date_end                      in   date       default hr_api.g_date
  ,p_external_contact              in   varchar2   default hr_api.g_varchar2
  ,p_planned_cost                  in   varchar2   default hr_api.g_varchar2
  ,p_recruiting_site_id            in   number     default hr_api.g_number
  ,p_recruiting_site_response      in   varchar2   default hr_api.g_varchar2
  ,p_last_posted_date              in   date       default hr_api.g_date
  ,p_type                          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_posting_content_id            in   number     default hr_api.g_number
  ,p_status                        in   varchar2   default hr_api.g_varchar2
  ,p_object_version_number      in out nocopy  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc            varchar2(72) := g_package||'UPDATE_RECRUITMENT_ACTIVITY ';

Line: 345


  savepoint UPDATE_RECRUITMENT_ACTIVITY;

Line: 353


  PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_B (
     p_recruitment_activity_id       =>        p_recruitment_activity_id
    ,p_authorising_person_id         =>        p_authorising_person_id
    ,p_run_by_organization_id        =>        p_run_by_organization_id
    ,p_internal_contact_person_id    =>        p_internal_contact_person_id
    ,p_parent_recruitment_activity   =>        p_parent_recruitment_activity
    ,p_currency_code                 =>        p_currency_code
    ,p_date_start                    =>        l_date_start
    ,p_name                          =>        p_name
    ,p_actual_cost                   =>        p_actual_cost
    ,p_comments                      =>        p_comments
    ,p_contact_telephone_number      =>        p_contact_telephone_number
    ,p_date_closing                  =>        l_date_closing
    ,p_date_end                      =>        l_date_end
    ,p_external_contact              =>        p_external_contact
    ,p_planned_cost                  =>        p_planned_cost
    ,p_recruiting_site_id            =>        p_recruiting_site_id
    ,p_recruiting_site_response      =>        p_recruiting_site_response
    ,p_last_posted_date              =>        p_last_posted_date
    ,p_type                          =>        p_type
    ,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_posting_content_id            =>        p_posting_content_id
    ,p_status                        =>        p_status
    ,p_object_version_number         =>        l_object_version_number
  );

Line: 401


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

Line: 460


  PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_A (
     p_recruitment_activity_id          =>         p_recruitment_activity_id
    ,p_authorising_person_id            =>         p_authorising_person_id
    ,p_run_by_organization_id           =>         p_run_by_organization_id
    ,p_internal_contact_person_id       =>         p_internal_contact_person_id
    ,p_parent_recruitment_activity      =>         p_parent_recruitment_activity
    ,p_currency_code                    =>         p_currency_code
    ,p_date_start                       =>         l_date_start
    ,p_name                             =>         p_name
    ,p_actual_cost                      =>         p_actual_cost
    ,p_comments                         =>         p_comments
    ,p_contact_telephone_number         =>         p_contact_telephone_number
    ,p_date_closing                     =>         l_date_closing
    ,p_date_end                         =>         l_date_end
    ,p_external_contact                 =>         p_external_contact
    ,p_planned_cost                     =>         p_planned_cost
    ,p_recruiting_site_id               =>         p_recruiting_site_id
    ,p_recruiting_site_response         =>         p_recruiting_site_response
    ,p_last_posted_date                 =>         p_last_posted_date
    ,p_type                             =>         p_type
    ,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_posting_content_id               =>         p_posting_content_id
    ,p_status                           =>         p_status
    ,p_object_version_number            =>         l_object_version_number
  );

Line: 508


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

Line: 530


    rollback to UPDATE_RECRUITMENT_ACTIVITY ;

Line: 543


    rollback to UPDATE_RECRUITMENT_ACTIVITY ;

Line: 546


end UPDATE_RECRUITMENT_ACTIVITY;

Line: 552


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

Line: 568


  savepoint DELETE_RECRUITMENT_ACTIVITY;

Line: 576


    PER_RECRUITMENT_ACTIVITY_BK3.DELETE_RECRUITMENT_ACTIVITY_b
      ( p_object_version_number    => p_object_version_number
       ,p_recruitment_activity_id          => p_recruitment_activity_id
       );

Line: 583


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

Line: 601


    PER_RECRUITMENT_ACTIVITY_BK3.DELETE_RECRUITMENT_ACTIVITY_a
      ( p_object_version_number    => p_object_version_number
       ,p_recruitment_activity_id          => p_recruitment_activity_id
       );

Line: 608


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

Line: 629


    rollback to DELETE_RECRUITMENT_ACTIVITY ;

Line: 640


    rollback to DELETE_RECRUITMENT_ACTIVITY ;

Line: 643


end DELETE_RECRUITMENT_ACTIVITY;