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

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

Line: 185


PROCEDURE update_agency_vacancy
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_agency_vacancy_id            in     number
  ,p_agency_id                    in     number
  ,p_vacancy_id                   in     number
  ,p_start_date                   in     date
  ,p_end_date                     in     date
  ,p_max_allowed_applicants       in     number    default hr_api.g_number
  ,p_manage_applicants_allowed    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_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 238


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

Line: 244


  savepoint update_agency_vacancy_swi;

Line: 266


  irc_agency_vacancies_api.update_agency_vacancy
    (p_validate                     => l_validate
    ,p_agency_vacancy_id            => p_agency_vacancy_id
    ,p_agency_id                    => p_agency_id
    ,p_vacancy_id                   => p_vacancy_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_max_allowed_applicants       => p_max_allowed_applicants
    ,p_manage_applicants_allowed    => p_manage_applicants_allowed
    ,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_object_version_number        => p_object_version_number
    );

Line: 330


    rollback to update_agency_vacancy_swi;

Line: 345


    rollback to update_agency_vacancy_swi;

Line: 357


end update_agency_vacancy;

Line: 361


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

Line: 374


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

Line: 378


  select object_version_number
    from irc_agency_vacancies
   where agency_vacancy_id = p_agency_vacancy_id;

Line: 386


  savepoint delete_agency_vacancy_swi;

Line: 413


  irc_agency_vacancies_api.delete_agency_vacancy
    (p_validate                     => l_validate
    ,p_agency_vacancy_id            => p_agency_vacancy_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 440


    rollback to delete_agency_vacancy_swi;

Line: 454


    rollback to delete_agency_vacancy_swi;

Line: 464


end delete_agency_vacancy;

Line: 566


     update_agency_vacancy
     (p_validate                   => p_validate
     ,p_agency_vacancy_id          => hr_transaction_swi.getNumberValue(l_CommitNode,'AgencyVacancyId',NULL)
     ,p_agency_id                  => hr_transaction_swi.getNumberValue(l_CommitNode,'AgencyId',NULL)
     ,p_vacancy_id                 => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
     ,p_start_date                 => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
     ,p_end_date                   => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
     ,p_max_allowed_applicants     => hr_transaction_swi.getNumberValue(l_CommitNode,'MaxAllowedApplicants',NULL)
     ,p_manage_applicants_allowed  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManageApplicantsAllowed',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_attribute21                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',NULL)
     ,p_attribute22                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',NULL)
     ,p_attribute23                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',NULL)
     ,p_attribute24                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',NULL)
     ,p_attribute25                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',NULL)
     ,p_attribute26                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',NULL)
     ,p_attribute27                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',NULL)
     ,p_attribute28                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',NULL)
     ,p_attribute29                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',NULL)
     ,p_attribute30                => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',NULL)
     ,p_object_version_number      => l_object_version_number
     ,p_return_status              => l_return_status
     );

Line: 614


     delete_agency_vacancy
     (p_validate               => p_validate
     ,p_object_version_number  => l_object_version_number
     ,p_agency_vacancy_id      => hr_transaction_swi.getNumberValue(l_CommitNode,'AgencyVacancyId',NULL)
     ,p_return_status          => l_return_status
     );