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

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

Line: 524


procedure update_library_objective
  (p_validate                      in   boolean    default false
  ,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_duplicate_name_warning           out nocopy   boolean
  ,p_weighting_over_100_warning       out nocopy   boolean
  ,p_weighting_appraisal_warning      out nocopy   boolean
  ) is

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

Line: 665


  savepoint update_library_objective;

Line: 685


   hr_objective_library_bk2.update_library_objective_b
  (p_effective_date                => l_effective_date
  ,p_objective_id                  => p_objective_id
  ,p_objective_name                => p_objective_name
  ,p_valid_from                    => l_valid_from
  ,p_valid_to                      => l_valid_to
  ,p_target_date                   => l_target_date
  ,p_next_review_date              => l_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         => l_object_version_number
  );

Line: 744


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

Line: 822


  hr_objective_library_bk2.update_library_objective_a
  (p_effective_date                => l_effective_date
  ,p_objective_id                  => p_objective_id
  ,p_objective_name                => p_objective_name
  ,p_valid_from                    => l_valid_from
  ,p_valid_to                      => l_valid_to
  ,p_target_date                   => l_target_date
  ,p_next_review_date              => l_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: 883


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

Line: 952


      ROLLBACK TO update_library_objective;

Line: 969


    rollback to update_library_objective;

Line: 982


end update_library_objective;

Line: 1012


procedure delete_library_objective
  (p_validate                      in   boolean         default false
  ,p_objective_id                  in   number
  ,p_object_version_number         in   number
  ) is

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

Line: 1050


     savepoint delete_library_objective;

Line: 1056


    hr_objective_library_bk3.delete_library_objective_b
    (p_objective_id           => p_objective_id
    ,p_object_version_number  => p_object_version_number
    );

Line: 1063


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

Line: 1086


  hr_objective_library_bk3.delete_library_objective_a
    (p_objective_id           => p_objective_id
    ,p_object_version_number  => p_object_version_number
    );

Line: 1093


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

Line: 1117


    rollback to delete_library_objective;

Line: 1129


    rollback to delete_library_objective;

Line: 1137


 end delete_library_objective;

Line: 1235


procedure update_eligy_profile
 ( p_validate             in    boolean   default false
  ,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
 ) is
  l_object_version_number  ben_eligy_prfl_f.object_version_number%type;

Line: 1260


  ben_eligy_profile_api.update_eligy_profile
    (
       p_validate              =>    p_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 =>	 l_object_version_number
      ,p_effective_start_date  =>	 l_effective_start_date
      ,p_effective_end_date    =>	 l_effective_end_date
      ,p_datetrack_mode        =>    p_datetrack_mode
      ,p_business_group_id     =>    p_business_group_id
      ,p_effective_date        =>    p_effective_date
   );

Line: 1283


end update_eligy_profile;

Line: 1382


procedure update_eligy_object
  (p_validate                       in boolean    default false
  ,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

    l_object_version_number ben_elig_obj_f.object_version_number%TYPE;

Line: 1404


    ben_elig_obj_api.update_ELIG_OBJ
     (p_validate 		=>  p_validate
     ,p_elig_obj_id		=>  p_elig_obj_id
     ,p_effective_start_date    =>  l_effective_start_date
     ,p_effective_end_date	=>  l_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	=>  l_object_version_number
     ,p_effective_date 		=>  p_effective_date
     ,p_datetrack_mode		=>  p_datetrack_mode
     );

Line: 1422


end update_eligy_object;

Line: 1452


procedure delete_eligy_object
  (p_validate                       in boolean        default false
  ,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

    l_object_version_number ben_elig_obj_f.object_version_number%TYPE;

Line: 1470


    ben_elig_obj_api.delete_ELIG_OBJ
     (p_validate                =>  p_validate
     ,p_elig_obj_id             =>  p_elig_obj_id
     ,p_effective_start_date    =>  l_effective_start_date
     ,p_effective_end_date      =>  l_effective_end_date
     ,p_object_version_number   =>  l_object_version_number
     ,p_effective_date          =>  p_effective_date
     ,p_datetrack_mode          =>  p_datetrack_mode
     );

Line: 1484


end delete_eligy_object;

Line: 1582


procedure update_elig_obj_elig_prfl
  (p_validate                       in boolean    default false
  ,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

   l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

Line: 1602


    ben_ELIG_OBJ_ELIG_PROFL_api.update_ELIG_OBJ_ELIG_PROFL
    (p_validate                 => p_validate
    ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    ,p_elig_obj_id              => p_elig_obj_id
    ,p_elig_prfl_id             => p_elig_prfl_id
    ,p_object_version_number    => l_object_version_number
    ,p_effective_date           => p_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    );

Line: 1618


end update_elig_obj_elig_prfl;

Line: 1648


procedure delete_elig_obj_elig_prfl
  (p_validate                       in boolean    default false
  ,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

   l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

Line: 1666


    ben_ELIG_OBJ_ELIG_PROFL_api.delete_ELIG_OBJ_ELIG_PROFL
    (p_validate                 => p_validate
    ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    ,p_object_version_number    => l_object_version_number
    ,p_effective_date           => p_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    );

Line: 1681


end delete_elig_obj_elig_prfl;

Line: 1782


procedure update_eligy_grade
  (p_validate                       in boolean    default false
  ,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

  l_object_version_number ben_elig_grd_prte_f.object_version_number%TYPE;

Line: 1803


   ben_ELIG_GRD_PRTE_api.update_ELIG_GRD_PRTE
   (p_validate  		    => p_validate
   ,p_elig_grd_prte_id              => p_elig_grd_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_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         => l_object_version_number
   ,p_effective_date   	 	    => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
   ,p_excld_flag                    => 'N'
   );

Line: 1822


end update_eligy_grade;

Line: 1853


procedure delete_eligy_grade
  (p_validate                       in boolean    default false
  ,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


  l_object_version_number ben_elig_grd_prte_f.object_version_number%TYPE;

Line: 1872


   ben_ELIG_GRD_PRTE_api.delete_ELIG_GRD_PRTE
   (p_validate                      => p_validate
   ,p_elig_grd_prte_id              => p_elig_grd_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_effective_end_date
   ,p_object_version_number         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
   );

Line: 1886


end delete_eligy_grade;

Line: 1987


procedure update_eligy_org
  (p_validate                       in boolean    default false
  ,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

  l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;

Line: 2008


   ben_ELIG_org_unit_PRTE_api.update_ELIG_org_unit_PRTE
   (p_validate                      => p_validate
   ,p_elig_org_unit_prte_id         => p_elig_org_unit_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_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         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
   ,p_excld_flag              	    => 'N'
   );

Line: 2027


end update_eligy_org;

Line: 2058


procedure delete_eligy_org
  (p_validate                       in boolean    default false
  ,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


  l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;

Line: 2077


   ben_ELIG_org_unit_PRTE_api.delete_ELIG_org_unit_PRTE
   (p_validate                      => p_validate
   ,p_elig_org_unit_prte_id         => p_elig_org_unit_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_effective_end_date
   ,p_object_version_number         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
);

Line: 2091


end delete_eligy_org;

Line: 2192


procedure update_eligy_job
  (p_validate                       in boolean    default false
  ,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

  l_object_version_number ben_elig_job_prte_f.object_version_number%TYPE;

Line: 2213


   ben_ELIGY_JOB_PRTE_api.update_ELIGY_JOB_PRTE
   (p_validate                      => p_validate
   ,p_elig_job_prte_id              => p_elig_job_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_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         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
   ,p_excld_flag                    => 'N'
   );

Line: 2232


end update_eligy_job;

Line: 2263


procedure delete_eligy_job
  (p_validate                       in boolean    default false
  ,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


  l_object_version_number ben_elig_job_prte_f.object_version_number%TYPE;

Line: 2282


   ben_ELIGY_JOB_PRTE_api.delete_ELIGY_JOB_PRTE
   (p_validate                      => p_validate
   ,p_elig_job_prte_id              => p_elig_job_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_effective_end_date
   ,p_object_version_number         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
);

Line: 2296


end delete_eligy_job;

Line: 2397


procedure update_eligy_position
  (p_validate                       in boolean    default false
  ,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

  l_object_version_number ben_elig_pstn_prte_f.object_version_number%TYPE;

Line: 2418


   ben_ELIG_PSTN_PRTE_api.update_ELIG_PSTN_PRTE
   (p_validate                      => p_validate
   ,p_elig_pstn_prte_id              => p_elig_pstn_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_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         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
   ,p_excld_flag              	    => 'N'
   );

Line: 2437


end update_eligy_position;

Line: 2468


procedure delete_eligy_position
  (p_validate                       in boolean    default false
  ,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


  l_object_version_number ben_elig_pstn_prte_f.object_version_number%TYPE;

Line: 2487


   ben_ELIG_PSTN_PRTE_api.delete_ELIG_PSTN_PRTE
   (p_validate                      => p_validate
   ,p_elig_pstn_prte_id              => p_elig_pstn_prte_id
   ,p_effective_start_date          => l_effective_start_date
   ,p_effective_end_date            => l_effective_end_date
   ,p_object_version_number         => l_object_version_number
   ,p_effective_date                => p_effective_date
   ,p_datetrack_mode                => p_datetrack_mode
);

Line: 2501


end delete_eligy_position;