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

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

Line: 69


   select party_id ,person_id, type, status, object_version_number
   from per_competence_elements
   where competence_element_id = p_competence_element_id;

Line: 74


       select competence_id
       from per_competence_outcomes
       where outcome_id = p_outcome_id;

Line: 314


  select competence_id into l_competence_id
                       from per_competence_outcomes
                       where outcome_id = p_outcome_id;

Line: 337


        hr_competence_element_api.update_competence_element
          (p_effective_date                => l_effective_date
          ,p_competence_element_id         => p_competence_element_id
          ,p_status                        => 'ACHIEVED'
          ,p_achieved_date                 => l_max_date_from
          ,p_party_id                      => l_party_id
          ,p_object_version_number         => lv_object_version_number
        );

Line: 412


procedure update_element_outcome
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_comp_element_outcome_id       in     number
  ,p_object_version_number         in out nocopy number
  ,p_competence_element_id         in     number   default hr_api.g_number
  ,p_outcome_id                    in     number   default hr_api.g_number
  ,p_date_from                     in     date     default hr_api.g_date
  ,p_date_to                       in     date     default hr_api.g_date
  ,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_information_category          in     varchar2 default hr_api.g_varchar2
  ,p_information1                  in     varchar2 default hr_api.g_varchar2
  ,p_information2                  in     varchar2 default hr_api.g_varchar2
  ,p_information3                  in     varchar2 default hr_api.g_varchar2
  ,p_information4                  in     varchar2 default hr_api.g_varchar2
  ,p_information5                  in     varchar2 default hr_api.g_varchar2
  ,p_information6                  in     varchar2 default hr_api.g_varchar2
  ,p_information7                  in     varchar2 default hr_api.g_varchar2
  ,p_information8                  in     varchar2 default hr_api.g_varchar2
  ,p_information9                  in     varchar2 default hr_api.g_varchar2
  ,p_information10                 in     varchar2 default hr_api.g_varchar2
  ,p_information11                 in     varchar2 default hr_api.g_varchar2
  ,p_information12                 in     varchar2 default hr_api.g_varchar2
  ,p_information13                 in     varchar2 default hr_api.g_varchar2
  ,p_information14                 in     varchar2 default hr_api.g_varchar2
  ,p_information15                 in     varchar2 default hr_api.g_varchar2
  ,p_information16                 in     varchar2 default hr_api.g_varchar2
  ,p_information17                 in     varchar2 default hr_api.g_varchar2
  ,p_information18                 in     varchar2 default hr_api.g_varchar2
  ,p_information19                 in     varchar2 default hr_api.g_varchar2
  ,p_information20                 in     varchar2 default hr_api.g_varchar2
  ) is

   --
   -- Declare cursors and local variables
   --
   l_proc                     varchar2(72) := g_package||'update_element_outcome';

Line: 487


  savepoint update_element_outcome;

Line: 505


  hr_comp_element_outcome_bk2.update_element_outcome_b
    (p_effective_date		     => l_effective_date
    ,p_comp_element_outcome_id       => p_comp_element_outcome_id
    ,p_competence_element_id         => p_competence_element_id
    ,p_outcome_id                    => p_outcome_id
    ,p_date_from                     => p_date_from
    ,p_date_to                       => p_date_to
    ,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_information_category          => p_information_category
    ,p_information1                  => p_information1
    ,p_information2                  => p_information2
    ,p_information3                  => p_information3
    ,p_information4                  => p_information4
    ,p_information5                  => p_information5
    ,p_information6                  => p_information6
    ,p_information7                  => p_information7
    ,p_information8                  => p_information8
    ,p_information9                  => p_information9
    ,p_information10                 => p_information10
    ,p_information11                 => p_information11
    ,p_information12                 => p_information12
    ,p_information13                 => p_information13
    ,p_information14                 => p_information14
    ,p_information15                 => p_information15
    ,p_information16                 => p_information16
    ,p_information17                 => p_information17
    ,p_information18                 => p_information18
    ,p_information19                 => p_information19
    ,p_information20                 => p_information20
    ,p_object_version_number         => l_object_version_number
    );

Line: 559


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

Line: 643


  hr_comp_element_outcome_bk2.update_element_outcome_a
    (p_effective_date                => l_effective_date
    ,p_comp_element_outcome_id       => p_comp_element_outcome_id
    ,p_object_version_number         => l_object_version_number
    ,p_competence_element_id         => p_competence_element_id
    ,p_outcome_id                    => p_outcome_id
    ,p_date_from                     => p_date_from
    ,p_date_to                       => p_date_to
    ,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_information_category          => p_information_category
    ,p_information1                  => p_information1
    ,p_information2                  => p_information2
    ,p_information3                  => p_information3
    ,p_information4                  => p_information4
    ,p_information5                  => p_information5
    ,p_information6                  => p_information6
    ,p_information7                  => p_information7
    ,p_information8                  => p_information8
    ,p_information9                  => p_information9
    ,p_information10                 => p_information10
    ,p_information11                 => p_information11
    ,p_information12                 => p_information12
    ,p_information13                 => p_information13
    ,p_information14                 => p_information14
    ,p_information15                 => p_information15
    ,p_information16                 => p_information16
    ,p_information17                 => p_information17
    ,p_information18                 => p_information18
    ,p_information19                 => p_information19
    ,p_information20                 => p_information20
  );

Line: 697


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

Line: 727


     rollback to update_element_outcome;

Line: 742


     rollback to update_element_outcome;

Line: 750


end update_element_outcome;

Line: 758


procedure delete_element_outcome
  (p_validate                      in     boolean
  ,p_comp_element_outcome_id       in     number
  ,p_object_version_number         in out nocopy number
) IS

  --
  -- Declare cursors and local variables
  --

  cursor csr_get_competence_element_id is
     select competence_element_id
     from per_comp_element_outcomes
     where comp_element_outcome_id = p_comp_element_outcome_id;

Line: 775


     select party_id ,person_id, type, status, object_version_number
     from per_competence_elements
     where competence_element_id = l_competence_element_id;

Line: 780


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

Line: 801


  savepoint delete_element_outcome;

Line: 809


  hr_comp_element_outcome_bk3.delete_element_outcome_b
    (p_comp_element_outcome_id    =>  p_comp_element_outcome_id
    ,p_object_version_number      =>  l_object_version_number
    );

Line: 816


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

Line: 842


  hr_comp_element_outcome_bk3.delete_element_outcome_a
    (p_comp_element_outcome_id       => p_comp_element_outcome_id
    ,p_object_version_number         => l_object_version_number
    );

Line: 849


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

Line: 867


      hr_competence_element_api.update_competence_element
        (p_effective_date               => sysdate
        ,p_competence_element_id        => l_competence_element_id
        ,p_status                       => 'IN_PROGRESS'
        ,p_achieved_date                => NULL
        ,p_party_id                     => l_party_id
        ,p_object_version_number        => ll_object_version_number
    );

Line: 907


    rollback to delete_element_outcome;

Line: 920


    rollback to delete_element_outcome;

Line: 928


end delete_element_outcome;