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

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

Line: 251


PROCEDURE delete_library_objective
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_objective_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: 264


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

Line: 270


  savepoint delete_library_objective_swi;

Line: 290


  hr_objective_library_api.delete_library_objective
    (p_validate                     => l_validate
    ,p_objective_id                 => p_objective_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 317


    rollback to delete_library_objective_swi;

Line: 331


    rollback to delete_library_objective_swi;

Line: 341


end delete_library_objective;

Line: 345


PROCEDURE update_library_objective
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_objective_id                 in     number
  ,p_objective_name               in     varchar2  default hr_api.g_varchar2
  ,p_valid_from                   in     date      default hr_api.g_date
  ,p_valid_to                     in     date      default hr_api.g_date
  ,p_target_date                  in     date      default hr_api.g_date
  ,p_next_review_date             in     date      default hr_api.g_date
  ,p_group_code                   in     varchar2  default hr_api.g_varchar2
  ,p_priority_code                in     varchar2  default hr_api.g_varchar2
  ,p_appraise_flag                in     varchar2  default hr_api.g_varchar2
  ,p_weighting_percent            in     number    default hr_api.g_number
  ,p_measurement_style_code       in     varchar2  default hr_api.g_varchar2
  ,p_measure_name                 in     varchar2  default hr_api.g_varchar2
  ,p_target_value                 in     number    default hr_api.g_number
  ,p_uom_code                     in     varchar2  default hr_api.g_varchar2
  ,p_measure_type_code            in     varchar2  default hr_api.g_varchar2
  ,p_measure_comments             in     varchar2  default hr_api.g_varchar2
  ,p_eligibility_type_code        in     varchar2  default hr_api.g_varchar2
  ,p_details                      in     varchar2  default hr_api.g_varchar2
  ,p_success_criteria             in     varchar2  default hr_api.g_varchar2
  ,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_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: 413


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

Line: 419


  savepoint update_library_objective_swi;

Line: 440


  hr_objective_library_api.update_library_objective
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_objective_id                 => p_objective_id
    ,p_objective_name               => p_objective_name
    ,p_valid_from                   => p_valid_from
    ,p_valid_to                     => p_valid_to
    ,p_target_date                  => p_target_date
    ,p_next_review_date             => p_next_review_date
    ,p_group_code                   => p_group_code
    ,p_priority_code                => p_priority_code
    ,p_appraise_flag                => p_appraise_flag
    ,p_weighting_percent            => p_weighting_percent
    ,p_measurement_style_code       => p_measurement_style_code
    ,p_measure_name                 => p_measure_name
    ,p_target_value                 => p_target_value
    ,p_uom_code                     => p_uom_code
    ,p_measure_type_code            => p_measure_type_code
    ,p_measure_comments             => p_measure_comments
    ,p_eligibility_type_code        => p_eligibility_type_code
    ,p_details                      => p_details
    ,p_success_criteria             => p_success_criteria
    ,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_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
    ,p_duplicate_name_warning       => l_duplicate_name_warning
    ,p_weighting_over_100_warning   => l_weighting_over_100_warning
    ,p_weighting_appraisal_warning  => l_weighting_appraisal_warning
    );

Line: 545


    rollback to update_library_objective_swi;

Line: 560


    rollback to update_library_objective_swi;

Line: 572


end update_library_objective;

Line: 759


procedure update_eligy_profile
 ( p_validate             in    number  default hr_api.g_false_num
  ,p_effective_date       in    date
  ,p_business_group_id    in    number
  ,p_name                 in     varchar2  default null
  ,p_bnft_cagr_prtn_cd     in    varchar2  default null
  ,p_stat_cd               in    varchar2  default null
  ,p_asmt_to_use_cd        in    varchar2  default null
  ,p_elig_grd_flag         in    varchar2  default 'N'
  ,p_elig_org_unit_flag    in    varchar2  default 'N'
  ,p_elig_job_flag         in    varchar2  default 'N'
  ,p_elig_pstn_flag        in    varchar2  default 'N'
  ,p_eligy_prfl_id         in   number
  ,p_object_version_number in out nocopy number
  ,p_effective_start_date   out nocopy date
  ,p_effective_end_date     out nocopy date
  ,p_datetrack_mode   in varchar2
  ,p_return_status          out nocopy varchar2
 ) is
 -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 782


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

Line: 789


  savepoint update_eligy_profile_swi;

Line: 802


  HR_OBJECTIVE_LIBRARY_api.update_eligy_profile
    (
       p_validate              =>    l_validate
      ,p_eligy_prfl_id         =>    p_eligy_prfl_id
      ,p_name                  =>    p_name
      ,p_stat_cd               =>    p_stat_cd
      ,p_asmt_to_use_cd        =>    p_asmt_to_use_cd
      ,p_elig_grd_flag         =>    p_elig_grd_flag
      ,p_elig_org_unit_flag    =>    p_elig_org_unit_flag
      ,p_elig_job_flag         =>    p_elig_job_flag
      ,p_elig_pstn_flag        =>    p_elig_pstn_flag
      ,p_object_version_number =>    p_object_version_number
      ,p_effective_start_date  =>    p_effective_start_date
      ,p_effective_end_date    =>    p_effective_end_date
      ,p_datetrack_mode        =>    p_datetrack_mode
      ,p_business_group_id     =>    p_business_group_id
      ,p_effective_date        =>    p_effective_date
   );

Line: 831


    rollback to update_eligy_profile_swi;

Line: 845


    rollback to update_eligy_profile_swi;

Line: 867


end update_eligy_profile;

Line: 1004


procedure update_eligy_object
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_obj_id                    in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_table_name                     in  varchar2  default hr_api.g_varchar2
  ,p_column_name                    in  varchar2  default hr_api.g_varchar2
  ,p_column_value                   in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1022


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

Line: 1029


  savepoint update_eligy_object_swi;

Line: 1049


    hr_objective_library_api.update_eligy_object
     (p_validate                =>  l_validate
     ,p_elig_obj_id             =>  p_elig_obj_id
     ,p_effective_start_date    =>  p_effective_start_date
     ,p_effective_end_date      =>  p_effective_end_date
     ,p_business_group_id       =>  p_business_group_id
     ,p_table_name              =>  p_table_name
     ,p_column_name             =>  p_column_name
     ,p_column_value            =>  p_column_value
     ,p_object_version_number   =>  p_object_version_number
     ,p_effective_date          =>  p_effective_date
     ,p_datetrack_mode          =>  p_datetrack_mode
     );

Line: 1072


    rollback to update_eligy_object_swi;

Line: 1082


end update_eligy_object;

Line: 1112


procedure delete_eligy_object
  (p_validate                       number default hr_api.g_false_num
  ,p_elig_obj_id                    in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in date
  ,p_datetrack_mode                 in varchar2
  ) is
--
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1126


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

Line: 1133


  savepoint delete_eligy_object_swi;

Line: 1153


    hr_objective_library_api.delete_eligy_object
     (p_validate                =>  l_validate
     ,p_elig_obj_id             =>  p_elig_obj_id
     ,p_effective_start_date    =>  p_effective_start_date
     ,p_effective_end_date      =>  p_effective_end_date
     ,p_object_version_number   =>  p_object_version_number
     ,p_effective_date          =>  p_effective_date
     ,p_datetrack_mode          =>  p_datetrack_mode
     );

Line: 1171


    rollback to delete_eligy_object_swi;

Line: 1181


end delete_eligy_object;

Line: 1322


procedure update_elig_obj_elig_prfl
  (p_validate                       in number default hr_api.g_false_num
  ,p_elig_obj_elig_prfl_id          in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_elig_obj_id                    in  number    default hr_api.g_number
  ,p_elig_prfl_id                   in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
 --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1338


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

Line: 1345


  savepoint update_elig_obj_elig_prfl_swi;

Line: 1365


  hr_objective_library_api.update_elig_obj_elig_prfl
    (p_validate                 => l_validate
    ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
    ,p_effective_start_date     => p_effective_start_date
    ,p_effective_end_date       => p_effective_end_date
    ,p_elig_obj_id              => p_elig_obj_id
    ,p_elig_prfl_id             => p_elig_prfl_id
    ,p_object_version_number    => p_object_version_number
    ,p_effective_date           => p_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    );

Line: 1386


    rollback to update_elig_obj_elig_prfl_swi;

Line: 1396


end update_elig_obj_elig_prfl;

Line: 1427


procedure delete_elig_obj_elig_prfl
  (p_validate                       in number default hr_api.g_false_num
  ,p_elig_obj_elig_prfl_id         in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1441


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

Line: 1448


  savepoint delete_elig_obj_elig_prfl_swi;

Line: 1468


  hr_objective_library_api.delete_elig_obj_elig_prfl
    (p_validate                 => l_validate
    ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
    ,p_effective_start_date     => p_effective_start_date
    ,p_effective_end_date       => p_effective_end_date
    ,p_object_version_number    => p_object_version_number
    ,p_effective_date           => p_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    );

Line: 1487


    rollback to delete_elig_obj_elig_prfl_swi;

Line: 1497


end delete_elig_obj_elig_prfl;

Line: 1642


procedure update_eligy_grade
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_grd_prte_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_eligy_prfl_id                  in  number    default hr_api.g_number
  ,p_grade_id                       in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
 --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1659


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

Line: 1666


  savepoint update_eligy_grade_swi;

Line: 1686


  hr_objective_library_api.update_eligy_grade
    (p_validate                => l_validate
    ,p_elig_grd_prte_id        => p_elig_grd_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_business_group_id       => p_business_group_id
    ,p_eligy_prfl_id           => p_eligy_prfl_id
    ,p_grade_id                => p_grade_id
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 1708


    rollback to update_eligy_grade_swi;

Line: 1718


end update_eligy_grade;

Line: 1749


procedure delete_eligy_grade
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_grd_prte_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1763


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

Line: 1770


  savepoint delete_eligy_grade_swi;

Line: 1790


  hr_objective_library_api.delete_eligy_grade
    (p_validate                => l_validate
    ,p_elig_grd_prte_id        => p_elig_grd_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 1809


    rollback to delete_eligy_grade_swi;

Line: 1819


end delete_eligy_grade;

Line: 1962


procedure update_eligy_org
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_org_unit_prte_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_eligy_prfl_id                  in  number    default hr_api.g_number
  ,p_organization_id                       in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
 ,p_datetrack_mode                 in  varchar2
  ) is
 --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 1979


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

Line: 1986


  savepoint update_eligy_org_swi;

Line: 2006


  hr_objective_library_api.update_eligy_org
    (p_validate                => l_validate
    ,p_elig_org_unit_prte_id        => p_elig_org_unit_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_business_group_id       => p_business_group_id
    ,p_eligy_prfl_id           => p_eligy_prfl_id
    ,p_organization_id         => p_organization_id
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2028


    rollback to update_eligy_org_swi;

Line: 2038


end update_eligy_org;

Line: 2069


procedure delete_eligy_org
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_org_unit_prte_id               in  number
  ,p_effective_start_date           out nocopy date
,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 2083


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

Line: 2090


  savepoint delete_eligy_org_swi;

Line: 2110


  hr_objective_library_api.delete_eligy_org
    (p_validate                => l_validate
    ,p_elig_org_unit_prte_id        => p_elig_org_unit_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2129


    rollback to delete_eligy_org_swi;

Line: 2139


end delete_eligy_org;

Line: 2282


procedure update_eligy_job
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_job_prte_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_eligy_prfl_id                  in  number    default hr_api.g_number
  ,p_job_id                       in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
 ,p_datetrack_mode                 in  varchar2
  ) is
 --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 2299


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

Line: 2306


  savepoint update_eligy_job_swi;

Line: 2326


  hr_objective_library_api.update_eligy_job
    (p_validate                => l_validate
    ,p_elig_job_prte_id        => p_elig_job_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_business_group_id       => p_business_group_id
    ,p_eligy_prfl_id           => p_eligy_prfl_id
    ,p_job_id                => p_job_id
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2348


    rollback to update_eligy_job_swi;

Line: 2358


end update_eligy_job;

Line: 2389


procedure delete_eligy_job
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_job_prte_id               in  number
  ,p_effective_start_date           out nocopy date
,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 2403


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

Line: 2410


  savepoint delete_eligy_job_swi;

Line: 2430


  hr_objective_library_api.delete_eligy_job
    (p_validate                => l_validate
    ,p_elig_job_prte_id        => p_elig_job_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2449


    rollback to delete_eligy_job_swi;

Line: 2459


end delete_eligy_job;

Line: 2602


procedure update_eligy_position
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_pstn_prte_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_eligy_prfl_id                  in  number    default hr_api.g_number
  ,p_position_id                       in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
 ,p_datetrack_mode                 in  varchar2
  ) is
 --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 2619


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

Line: 2626


  savepoint update_eligy_position_swi;

Line: 2646


  hr_objective_library_api.update_eligy_position
    (p_validate                => l_validate
    ,p_elig_pstn_prte_id        => p_elig_pstn_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_business_group_id       => p_business_group_id
    ,p_eligy_prfl_id           => p_eligy_prfl_id
    ,p_position_id             => p_position_id
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2668


    rollback to update_eligy_position_swi;

Line: 2678


end update_eligy_position;

Line: 2709


procedure delete_eligy_position
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_pstn_prte_id               in  number
  ,p_effective_start_date           out nocopy date
,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate    boolean;

Line: 2723


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

Line: 2730


  savepoint delete_eligy_position_swi;

Line: 2750


  hr_objective_library_api.delete_eligy_position
    (p_validate                => l_validate
    ,p_elig_pstn_prte_id        => p_elig_pstn_prte_id
    ,p_effective_start_date    => p_effective_start_date
    ,p_effective_end_date      => p_effective_end_date
    ,p_object_version_number   => p_object_version_number
    ,p_effective_date          => p_effective_date
    ,p_datetrack_mode          => p_datetrack_mode
    );

Line: 2769


    rollback to delete_eligy_position_swi;

Line: 2779


end delete_eligy_position;