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

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

Line: 183


PROCEDURE delete_assessment
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_assessment_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: 196


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

Line: 202


  savepoint delete_assessment_swi;

Line: 222


  hr_assessments_api.delete_assessment
    (p_validate                     => l_validate
    ,p_assessment_id                => p_assessment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 249


    rollback to delete_assessment_swi;

Line: 263


    rollback to delete_assessment_swi;

Line: 273


end delete_assessment;

Line: 277


PROCEDURE update_assessment
  (p_assessment_id                in     number
  ,p_assessment_type_id           in     number    default hr_api.g_number
  ,p_assessment_group_id          in     number    default hr_api.g_number
  ,p_assessment_period_start_date in     date      default hr_api.g_date
  ,p_assessment_period_end_date   in     date      default hr_api.g_date
  ,p_assessment_date              in     date      default hr_api.g_date
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_total_score                  in     number    default hr_api.g_number
  ,p_status                       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_object_version_number        in out nocopy number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 322


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

Line: 324


    select object_version_number from per_assessments where assessment_id = p_assessment_id;

Line: 330


  savepoint update_assessment_swi;

Line: 363


  hr_assessments_api.update_assessment
    (p_assessment_id                => p_assessment_id
    ,p_assessment_type_id           => p_assessment_type_id
    ,p_assessment_group_id          => p_assessment_group_id
    ,p_assessment_period_start_date => p_assessment_period_start_date
    ,p_assessment_period_end_date   => p_assessment_period_end_date
    ,p_assessment_date              => p_assessment_date
    ,p_comments                     => p_comments
    ,p_total_score                  => p_total_score
    ,p_status                       => p_status
    ,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_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    );

Line: 420


    rollback to update_assessment_swi;

Line: 435


    rollback to update_assessment_swi;

Line: 446


end update_assessment;

Line: 495


       ,p_group_date                   => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
       ,p_group_initiator_id           => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
       ,p_comments                     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
       ,p_total_score                  => hr_transaction_swi.getNumberValue(l_CommitNode,'TotalScore',null)
       ,p_status                       => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',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_object_version_number        => l_object_version_number
       ,p_validate                     => p_validate
       ,p_effective_date               => p_effective_date
       ,p_return_status                => l_return_status
       );

Line: 529


       update_assessment
      ( p_assessment_id                => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId')
       ,p_assessment_type_id           => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId')
       ,p_assessment_group_id          => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentGroupId')
       ,p_assessment_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssessmentPeriodStartDate')
       ,p_assessment_period_end_date   => hr_transaction_swi.getDateValue(l_CommitNode,'AssessmentPeriodEndDate')
       ,p_assessment_date              => hr_transaction_swi.getDateValue(l_CommitNode,'AssessmentDate')
       ,p_comments                     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
       ,p_total_score                  => hr_transaction_swi.getNumberValue(l_CommitNode,'TotalScore')
       ,p_status                       => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
       ,p_attribute_category           => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
       ,p_attribute1                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
       ,p_attribute2                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
       ,p_attribute3                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
       ,p_attribute4                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
       ,p_attribute5                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
       ,p_attribute6                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
       ,p_attribute7                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
       ,p_attribute8                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
       ,p_attribute9                   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
       ,p_attribute10                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
       ,p_attribute11                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
       ,p_attribute12                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
       ,p_attribute13                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
       ,p_attribute14                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
       ,p_attribute15                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
       ,p_attribute16                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
       ,p_attribute17                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
       ,p_attribute18                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
       ,p_attribute19                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
       ,p_attribute20                  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
       ,p_object_version_number        => l_object_version_number
       ,p_validate                     => p_validate
       ,p_effective_date               => p_effective_date
       ,p_return_status                => l_return_status
      );

Line: 568


       delete_assessment
      ( p_validate                     => p_validate
       ,p_assessment_id                => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId')
       ,p_object_version_number        => l_object_version_number
       ,p_return_status                => l_return_status
      );