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

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

Line: 330


PROCEDURE delete_competence_element
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_competence_element_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: 343


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

Line: 347


  select object_version_number
    from per_competence_elements
   where competence_element_id = p_competence_element_id;

Line: 358


  savepoint delete_competence_element_swi;

Line: 385


  hr_competence_element_api.delete_competence_element
    (p_validate                     => l_validate
    ,p_competence_element_id        => p_competence_element_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 412


    rollback to delete_competence_element_swi;

Line: 426


    rollback to delete_competence_element_swi;

Line: 436


end delete_competence_element;

Line: 611


PROCEDURE update_competence_element
  (p_competence_element_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_competence_id                in     number    default hr_api.g_number
  ,p_proficiency_level_id         in     number    default hr_api.g_number
  ,p_high_proficiency_level_id    in     number    default hr_api.g_number
  ,p_weighting_level_id           in     number    default hr_api.g_number
  ,p_rating_level_id              in     number    default hr_api.g_number
  ,p_mandatory                    in     varchar2  default hr_api.g_varchar2
  ,p_effective_date_from          in     date      default hr_api.g_date
  ,p_effective_date_to            in     date      default hr_api.g_date
  ,p_group_competence_type        in     varchar2  default hr_api.g_varchar2
  ,p_competence_type              in     varchar2  default hr_api.g_varchar2
  ,p_normal_elapse_duration       in     number    default hr_api.g_number
  ,p_normal_elapse_duration_unit  in     varchar2  default hr_api.g_varchar2
  ,p_sequence_number              in     number    default hr_api.g_number
  ,p_source_of_proficiency_level  in     varchar2  default hr_api.g_varchar2
  ,p_line_score                   in     number    default hr_api.g_number
  ,p_certification_date           in     date      default hr_api.g_date
  ,p_certification_method         in     varchar2  default hr_api.g_varchar2
  ,p_next_certification_date      in     date      default hr_api.g_date
  ,p_comments                     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_effective_date               in     date
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_party_id                     in     number
  ,p_return_status                out    nocopy varchar2
  ,p_datetrack_update_mode        in     varchar2  default hr_api.g_correction
  ,p_appr_line_score              in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default null
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 673


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

Line: 684


  savepoint update_competence_element_swi;

Line: 713


    hr_competence_element_api.delete_competence_element
    (p_validate                     => false
    ,p_competence_element_id        => p_competence_element_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 787


    if (nvl(p_datetrack_update_mode, '#')  <> hr_api.g_update) then

    --  the competence has not been changed,
    --  so correct the existing row since datetrackmode is correct

   hr_competence_element_api.update_competence_element
    (p_competence_element_id        => p_competence_element_id
    ,p_object_version_number        => p_object_version_number
    ,p_proficiency_level_id         => p_proficiency_level_id
    ,p_high_proficiency_level_id    => p_high_proficiency_level_id
    ,p_weighting_level_id           => p_weighting_level_id
    ,p_rating_level_id              => p_rating_level_id
    ,p_mandatory                    => p_mandatory
    ,p_effective_date_from          => p_effective_date_from
    ,p_effective_date_to            => p_effective_date_to
    ,p_group_competence_type        => p_group_competence_type
    ,p_competence_type              => p_competence_type
    ,p_normal_elapse_duration       => p_normal_elapse_duration
    ,p_normal_elapse_duration_unit  => p_normal_elapse_duration_unit
    ,p_sequence_number              => p_sequence_number
    ,p_source_of_proficiency_level  => p_source_of_proficiency_level
    ,p_line_score                   => p_line_score
    ,p_certification_date           => p_certification_date
    ,p_certification_method         => p_certification_method
    ,p_next_certification_date      => p_next_certification_date
    ,p_comments                     => p_comments
    ,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_effective_date               => p_effective_date
    ,p_validate                     => false
    ,p_party_id                     => p_party_id
    ,p_appr_line_score              => p_appr_line_score
    ,p_status                       => p_status
    );

Line: 840


    elsif (p_datetrack_update_mode = hr_api.g_update) then

    --  the competence has not been changed,
    --  so update the existing row since datetrackmode is update
    --  Update implies Maintain history by end-dating the previous row and  inserting a new Row.

     l_effective_date_to:= p_effective_date_from - 1;

Line: 848


     hr_competence_element_api.update_competence_element(
      p_competence_element_id        => p_competence_element_id
     ,p_object_version_number        => p_object_version_number
     ,p_effective_date_to            => l_effective_date_to
     ,p_effective_date               => p_effective_date
     );

Line: 954


    rollback to update_competence_element_swi;

Line: 966


    rollback to update_competence_element_swi;

Line: 981


    rollback to update_competence_element_swi;

Line: 992


end update_competence_element;

Line: 996


PROCEDURE update_delivered_dates
  (p_activity_version_id          in     number
  ,p_old_start_date               in     date
  ,p_start_date                   in     date
  ,p_old_end_date                 in     date
  ,p_end_date                     in     date
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1012


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

Line: 1018


  savepoint update_delivered_dates_swi;

Line: 1038


  hr_competence_element_api.update_delivered_dates
    (p_activity_version_id          => p_activity_version_id
    ,p_old_start_date               => p_old_start_date
    ,p_start_date                   => p_start_date
    ,p_old_end_date                 => p_old_end_date
    ,p_end_date                     => p_end_date
    ,p_validate                     => l_validate
    );

Line: 1068


    rollback to update_delivered_dates_swi;

Line: 1082


    rollback to update_delivered_dates_swi;

Line: 1092


end update_delivered_dates;

Line: 1096


PROCEDURE update_personal_comp_element
  (p_competence_element_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_proficiency_level_id         in     number    default hr_api.g_number
  ,p_effective_date_from          in     date      default hr_api.g_date
  ,p_effective_date_to            in     date      default hr_api.g_date
  ,p_source_of_proficiency_level  in     varchar2  default hr_api.g_varchar2
  ,p_certification_date           in     date      default hr_api.g_date
  ,p_certification_method         in     varchar2  default hr_api.g_varchar2
  ,p_next_certification_date      in     date      default hr_api.g_date
  ,p_comments                     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_effective_date               in     date
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_ins_ovn                         out nocopy number
  ,p_ins_comp_id                     out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1142


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

Line: 1148


  savepoint update_personal_comp_ele_swi;

Line: 1169


  hr_competence_element_api.update_personal_comp_element
    (p_competence_element_id        => p_competence_element_id
    ,p_object_version_number        => l_object_version_number
    ,p_proficiency_level_id         => p_proficiency_level_id
    ,p_effective_date_from          => p_effective_date_from
    ,p_effective_date_to            => p_effective_date_to
    ,p_source_of_proficiency_level  => p_source_of_proficiency_level
    ,p_certification_date           => p_certification_date
    ,p_certification_method         => p_certification_method
    ,p_next_certification_date      => p_next_certification_date
    ,p_comments                     => p_comments
    ,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_effective_date               => p_effective_date
    ,p_validate                     => l_validate
    ,p_ins_ovn                      => p_ins_ovn
    ,p_ins_comp_id                  => p_ins_comp_id
    );

Line: 1228


    rollback to update_personal_comp_ele_swi;

Line: 1245


    rollback to update_personal_comp_ele_swi;

Line: 1258


end update_personal_comp_element;

Line: 1374


        update_competence_element
       (p_competence_element_id        => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
       ,p_object_version_number        => l_object_version_number
       ,p_competence_id                => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
       ,p_proficiency_level_id         => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
       ,p_high_proficiency_level_id    => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
       ,p_weighting_level_id           => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
       ,p_rating_level_id              => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
       ,p_mandatory                    => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
       ,p_effective_date_from          => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
       ,p_effective_date_to            => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
       ,p_group_competence_type        => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
       ,p_competence_type              => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
       ,p_normal_elapse_duration       => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
       ,p_normal_elapse_duration_unit  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
       ,p_sequence_number              => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
       ,p_source_of_proficiency_level  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
       ,p_line_score                   => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
       ,p_certification_date           => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
       ,p_certification_method         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
       ,p_next_certification_date      => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
       ,p_comments                     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
       ,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_effective_date               => l_effective_date
       ,p_validate                     => p_validate
       ,p_party_id                     => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
       ,p_status                       => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
       ,p_return_status                => l_return_status
       ,p_datetrack_update_mode        => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
      );

Line: 1427


        delete_competence_element
      ( p_validate                     => p_validate
       ,p_competence_element_id        => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
       ,p_object_version_number        => l_object_version_number
       ,p_return_status                => l_return_status
      );