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

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

Line: 246


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

Line: 259


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

Line: 265


  savepoint delete_vacancy_swi;

Line: 285


  per_vacancy_api.delete_vacancy
    (p_validate                     => l_validate
    ,p_object_version_number        => p_object_version_number
    ,p_vacancy_id                   => p_vacancy_id
    );

Line: 312


    rollback to delete_vacancy_swi;

Line: 326


    rollback to delete_vacancy_swi;

Line: 336


end delete_vacancy;

Line: 340


PROCEDURE update_vacancy
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_vacancy_id                   in     number
  ,p_object_version_number        in out nocopy number
  ,p_date_from                    in     date      default hr_api.g_date
  ,p_position_id                  in     number    default hr_api.g_number
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_grade_id                     in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_people_group_id              in     number    default hr_api.g_number
  ,p_location_id                  in     number    default hr_api.g_number
  ,p_recruiter_id                 in     number    default hr_api.g_number
  ,p_date_to                      in     date      default hr_api.g_date
  ,p_security_method              in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_number_of_openings           in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_budget_measurement_type      in     varchar2  default hr_api.g_varchar2
  ,p_budget_measurement_value     in     number    default hr_api.g_number
  ,p_vacancy_category             in     varchar2  default hr_api.g_varchar2
  ,p_manager_id                   in     number    default hr_api.g_number
  ,p_primary_posting_id           in     number    default hr_api.g_number
  ,p_assessment_id                in     number    default hr_api.g_number
  ,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_vacancy_region_type          in     varchar2  default hr_api.g_varchar2
  ,p_assignment_changed              out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 410


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

Line: 416


  savepoint update_vacancy_swi;

Line: 440


  per_vacancy_api.update_vacancy
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_vacancy_id                   => p_vacancy_id
    ,p_object_version_number        => p_object_version_number
    ,p_date_from                    => p_date_from
    ,p_position_id                  => p_position_id
    ,p_job_id                       => p_job_id
    ,p_grade_id                     => p_grade_id
    ,p_organization_id              => p_organization_id
    ,p_people_group_id              => p_people_group_id
    ,p_location_id                  => p_location_id
    ,p_recruiter_id                 => p_recruiter_id
    ,p_date_to                      => p_date_to
    ,p_security_method              => p_security_method
    ,p_description                  => p_description
    ,p_number_of_openings           => p_number_of_openings
    ,p_status                       => p_status
    ,p_budget_measurement_type      => p_budget_measurement_type
    ,p_budget_measurement_value     => p_budget_measurement_value
    ,p_vacancy_category             => p_vacancy_category
    ,p_manager_id                   => p_manager_id
    ,p_primary_posting_id           => p_primary_posting_id
    ,p_assessment_id                => p_assessment_id
    ,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_vacancy_region_type          => p_vacancy_region_type
    ,p_assignment_changed           => l_assignment_changed
    ,p_inv_pos_grade_warning        => l_inv_pos_grade_warning
    ,p_inv_job_grade_warning        => l_inv_job_grade_warning
    );

Line: 542


    rollback to update_vacancy_swi;

Line: 558


    rollback to update_vacancy_swi;

Line: 570


end update_vacancy;

Line: 592


   l_update_status VARCHAR2(30);

Line: 614


   l_update_status := hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL);

Line: 615


   if l_update_status = 'PENDING'
   then
     l_update_status := 'APPROVED';

Line: 703


     update_vacancy
       (p_validate                     =>   p_validate
       ,p_effective_date               =>   l_effective_date
       ,p_vacancy_id                   =>   l_vacancy_id
       ,p_object_version_number        =>   l_object_version_number
       ,p_date_from                    =>   hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',NULL)
       ,p_position_id                  =>   hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',NULL)
       ,p_job_id                       =>   hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
       ,p_grade_id                     =>   hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId',NULL)
       ,p_organization_id              =>   hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',NULL)
       ,p_people_group_id              =>   hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId',NULL)
       ,p_location_id                  =>   hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId',NULL)
       ,p_recruiter_id                 =>   hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId',NULL)
       ,p_date_to                      =>   hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',NULL)
       ,p_security_method              =>   hr_transaction_swi.getVarchar2Value(l_CommitNode,'SecurityMethod',NULL)
       ,p_description                  =>   hr_transaction_swi.getVarchar2Value(l_CommitNode,'Description',NULL)
       ,p_number_of_openings           =>   hr_transaction_swi.getNumberValue(l_CommitNode,'NumberOfOpenings',NULL)
       ,p_status                       =>   l_update_status
       ,p_budget_measurement_type      =>   hr_transaction_swi.getVarchar2Value(l_CommitNode,'BudgetMeasurementType',NULL)
       ,p_budget_measurement_value     =>   getNumberValueP2(l_CommitNode,'BudgetMeasurementValue',NULL)
       ,p_vacancy_category             =>   hr_transaction_swi.getVarchar2Value(l_CommitNode,'VacancyCategory',NULL)
       ,p_manager_id                   =>   hr_transaction_swi.getNumberValue(l_CommitNode,'ManagerId',NULL)
       ,p_primary_posting_id           =>   hr_transaction_swi.getNumberValue(l_CommitNode,'PrimaryPostingId',NULL)
       ,p_assessment_id                =>   hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',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_vacancy_region_type          =>   hr_transaction_swi.getVarchar2Value(l_CommitNode,'VacancyRegionType',NULL)
       ,p_assignment_changed           =>   l_assignment_changed
       ,p_return_status                =>   l_return_status
     );

Line: 813


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 814


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 821


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 828


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 831


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 832


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 846


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 847


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 862


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 863


 fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line: 870


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 877


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 898


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 905


                                              X_last_update_login=> fnd_global.login_id
                                              );

Line: 927


      select transaction_ref_id
      from hr_api_transactions hrt
      where hrt.transaction_id = p_transaction_id;

Line: 948


     elsif p_event = 'REJECTED' OR p_event = 'DELETED' OR p_event = 'CANCEL' then
        hr_utility.set_location(l_proc, 50);