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_SWI SQL Statements

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

Line: 195


PROCEDURE delete_recruitment_activity
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_object_version_number        in     number
  ,p_recruitment_activity_id      in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 208


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

Line: 214


  savepoint delete_rec_activity_swi;

Line: 234


  per_recruitment_activity_api.delete_recruitment_activity
    (p_validate                     => l_validate
    ,p_object_version_number        => p_object_version_number
    ,p_recruitment_activity_id      => p_recruitment_activity_id
    );

Line: 261


    rollback to delete_rec_activity_swi;

Line: 275


    rollback to delete_rec_activity_swi;

Line: 285


end delete_recruitment_activity;

Line: 289


PROCEDURE update_recruitment_activity
  (p_validate                     in     number    default hr_api.g_false_num
  ,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     clob      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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 344


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

Line: 350


  savepoint update_rec_activity_swi;

Line: 371


  per_recruitment_activity_api.update_recruitment_activity
    (p_validate                     => l_validate
    ,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                   => p_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                 => p_date_closing
    ,p_date_end                     => p_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        => p_object_version_number
    );

Line: 439


    rollback to update_rec_activity_swi;

Line: 454


    rollback to update_rec_activity_swi;

Line: 465


end update_recruitment_activity;

Line: 492


     select recruitment_activity_for_id, object_version_number
     from per_recruitment_activity_for
     where recruitment_activity_id = rec_act_id;

Line: 497


     select object_version_number
     from per_recruitment_activities
     where recruitment_activity_id = rec_act_id;

Line: 576


     update_recruitment_activity
     (p_validate                     => p_validate
     ,p_recruitment_activity_id      => l_recruitment_activity_id
     ,p_authorising_person_id        => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
     ,p_run_by_organization_id       => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
     ,p_internal_contact_person_id   => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
     ,p_parent_recruitment_activity  => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
     ,p_currency_code                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
     ,p_date_start                   => l_posting_date
     ,p_name                         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
     ,p_actual_cost                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
     ,p_contact_telephone_number     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
     ,p_date_closing                 => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
     ,p_date_end                     => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
     ,p_external_contact             => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
     ,p_planned_cost                 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
     ,p_recruiting_site_id           => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
     ,p_recruiting_site_response     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
     ,p_last_posted_date             => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
     ,p_type                         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
     ,p_attribute_category           => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
     ,p_attribute1                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
     ,p_attribute2                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
     ,p_attribute3                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
     ,p_attribute4                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
     ,p_attribute5                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
     ,p_attribute6                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
     ,p_attribute7                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
     ,p_attribute8                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
     ,p_attribute9                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
     ,p_attribute10                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
     ,p_attribute11                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
     ,p_attribute12                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
     ,p_attribute13                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
     ,p_attribute14                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
     ,p_attribute15                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
     ,p_attribute16                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
     ,p_attribute17                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
     ,p_attribute18                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
     ,p_attribute19                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
     ,p_attribute20                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
     ,p_posting_content_id           => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
     ,p_status                       => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
     ,p_object_version_number        => l_object_version_number
     ,p_return_status                => l_return_status
     );

Line: 630


       per_rec_activity_for_swi.delete_rec_activity_for
       (p_validate               => p_validate
       ,p_object_version_number  => rec_act_for.object_version_number
       ,p_rec_activity_for_id    => rec_act_for.recruitment_activity_for_id
       ,p_return_status          => l_return_status
       );

Line: 640


       hr_utility.set_location('OVN is NULL for delete ' || l_proc, 36);

Line: 646


     delete_recruitment_activity
     (p_validate                     => p_validate
     ,p_object_version_number        => l_object_version_number
     ,p_recruitment_activity_id      => l_recruitment_activity_id
     ,p_return_status                => l_return_status
     );