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

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

Line: 85


        ben_prtn_elig_prfl_api.insert_prtn_elig
          (
           p_pgm_id                    => p_pgm_id
          ,p_pl_id                     => p_pl_id
          ,p_plip_id                   => p_plip_id
          ,p_ptip_id                   => p_ptip_id
          ,p_oipl_id                   => p_oipl_id
          ,p_effective_date            => p_effective_date
          ,p_business_group_id         => p_business_group_id
          ,p_prtn_elig_id              => l_prtn_elig_id
          );

Line: 265


  update ben_pgm_f c
  set    c.elig_apls_flag = 'Y'
  where exists
        (select a.pgm_id
         from   ben_prtn_elig_f a,
                ben_prtn_eligy_rl_f b
         where  b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
         and    a.prtn_elig_id = b.prtn_elig_id
         and    a.pgm_id = c.pgm_id);

Line: 276


  update ben_plip_f c
  set    c.elig_apls_flag = 'Y'
  where exists
        (select a.plip_id
         from   ben_prtn_elig_f a,
                ben_prtn_eligy_rl_f b
         where  b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
         and    a.prtn_elig_id = b.prtn_elig_id
         and    a.plip_id = c.plip_id);

Line: 287


  update ben_ptip_f c
  set    c.elig_apls_flag = 'Y'
  where exists
        (select a.ptip_id
         from   ben_prtn_elig_f a,
                ben_prtn_eligy_rl_f b
         where  b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
         and    a.prtn_elig_id = b.prtn_elig_id
         and    a.ptip_id = c.ptip_id);

Line: 298


  update ben_pl_f c
  set    c.elig_apls_flag = 'Y'
  where exists
        (select a.pl_id
         from   ben_prtn_elig_f a,
                ben_prtn_eligy_rl_f b
         where  b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
         and    a.prtn_elig_id = b.prtn_elig_id
         and    a.pl_id = c.pl_id);

Line: 309


  update ben_oipl_f c
  set    c.elig_apls_flag = 'Y'
  where exists
        (select a.oipl_id
         from   ben_prtn_elig_f a,
                ben_prtn_eligy_rl_f b
         where  b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
         and    a.prtn_elig_id = b.prtn_elig_id
         and    a.oipl_id = c.oipl_id);

Line: 367


procedure update_ELIGIBILITY_RULE
  (p_validate                       in  boolean   default false
  ,p_prtn_eligy_rl_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_prtn_elig_id                   in  number    default hr_api.g_number
  ,p_formula_id                     in  number    default hr_api.g_number
  ,p_drvbl_fctr_apls_flag           in  varchar2  default hr_api.g_varchar2
  ,p_mndtry_flag                    in  varchar2  default hr_api.g_varchar2
  ,p_ordr_to_aply_num               in  number    default hr_api.g_number
  ,p_cer_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_cer_attribute30                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
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ELIGIBILITY_RULE';

Line: 427


  savepoint update_ELIGIBILITY_RULE;

Line: 439


    ben_ELIGIBILITY_RULE_bk2.update_ELIGIBILITY_RULE_b
      (
       p_prtn_eligy_rl_id               =>  p_prtn_eligy_rl_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_prtn_elig_id                   =>  p_prtn_elig_id
      ,p_formula_id                     =>  p_formula_id
      ,p_drvbl_fctr_apls_flag           =>  p_drvbl_fctr_apls_flag
      ,p_mndtry_flag                    =>  p_mndtry_flag
      ,p_ordr_to_aply_num               =>  p_ordr_to_aply_num
      ,p_cer_attribute_category         =>  p_cer_attribute_category
      ,p_cer_attribute1                 =>  p_cer_attribute1
      ,p_cer_attribute2                 =>  p_cer_attribute2
      ,p_cer_attribute3                 =>  p_cer_attribute3
      ,p_cer_attribute4                 =>  p_cer_attribute4
      ,p_cer_attribute5                 =>  p_cer_attribute5
      ,p_cer_attribute6                 =>  p_cer_attribute6
      ,p_cer_attribute7                 =>  p_cer_attribute7
      ,p_cer_attribute8                 =>  p_cer_attribute8
      ,p_cer_attribute9                 =>  p_cer_attribute9
      ,p_cer_attribute10                =>  p_cer_attribute10
      ,p_cer_attribute11                =>  p_cer_attribute11
      ,p_cer_attribute12                =>  p_cer_attribute12
      ,p_cer_attribute13                =>  p_cer_attribute13
      ,p_cer_attribute14                =>  p_cer_attribute14
      ,p_cer_attribute15                =>  p_cer_attribute15
      ,p_cer_attribute16                =>  p_cer_attribute16
      ,p_cer_attribute17                =>  p_cer_attribute17
      ,p_cer_attribute18                =>  p_cer_attribute18
      ,p_cer_attribute19                =>  p_cer_attribute19
      ,p_cer_attribute20                =>  p_cer_attribute20
      ,p_cer_attribute21                =>  p_cer_attribute21
      ,p_cer_attribute22                =>  p_cer_attribute22
      ,p_cer_attribute23                =>  p_cer_attribute23
      ,p_cer_attribute24                =>  p_cer_attribute24
      ,p_cer_attribute25                =>  p_cer_attribute25
      ,p_cer_attribute26                =>  p_cer_attribute26
      ,p_cer_attribute27                =>  p_cer_attribute27
      ,p_cer_attribute28                =>  p_cer_attribute28
      ,p_cer_attribute29                =>  p_cer_attribute29
      ,p_cer_attribute30                =>  p_cer_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 486


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

Line: 545


    ben_ELIGIBILITY_RULE_bk2.update_ELIGIBILITY_RULE_a
      (
       p_prtn_eligy_rl_id               =>  p_prtn_eligy_rl_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_prtn_elig_id                   =>  p_prtn_elig_id
      ,p_formula_id                     =>  p_formula_id
      ,p_drvbl_fctr_apls_flag           =>  p_drvbl_fctr_apls_flag
      ,p_mndtry_flag                    =>  p_mndtry_flag
      ,p_ordr_to_aply_num               =>  p_ordr_to_aply_num
      ,p_cer_attribute_category         =>  p_cer_attribute_category
      ,p_cer_attribute1                 =>  p_cer_attribute1
      ,p_cer_attribute2                 =>  p_cer_attribute2
      ,p_cer_attribute3                 =>  p_cer_attribute3
      ,p_cer_attribute4                 =>  p_cer_attribute4
      ,p_cer_attribute5                 =>  p_cer_attribute5
      ,p_cer_attribute6                 =>  p_cer_attribute6
      ,p_cer_attribute7                 =>  p_cer_attribute7
      ,p_cer_attribute8                 =>  p_cer_attribute8
      ,p_cer_attribute9                 =>  p_cer_attribute9
      ,p_cer_attribute10                =>  p_cer_attribute10
      ,p_cer_attribute11                =>  p_cer_attribute11
      ,p_cer_attribute12                =>  p_cer_attribute12
      ,p_cer_attribute13                =>  p_cer_attribute13
      ,p_cer_attribute14                =>  p_cer_attribute14
      ,p_cer_attribute15                =>  p_cer_attribute15
      ,p_cer_attribute16                =>  p_cer_attribute16
      ,p_cer_attribute17                =>  p_cer_attribute17
      ,p_cer_attribute18                =>  p_cer_attribute18
      ,p_cer_attribute19                =>  p_cer_attribute19
      ,p_cer_attribute20                =>  p_cer_attribute20
      ,p_cer_attribute21                =>  p_cer_attribute21
      ,p_cer_attribute22                =>  p_cer_attribute22
      ,p_cer_attribute23                =>  p_cer_attribute23
      ,p_cer_attribute24                =>  p_cer_attribute24
      ,p_cer_attribute25                =>  p_cer_attribute25
      ,p_cer_attribute26                =>  p_cer_attribute26
      ,p_cer_attribute27                =>  p_cer_attribute27
      ,p_cer_attribute28                =>  p_cer_attribute28
      ,p_cer_attribute29                =>  p_cer_attribute29
      ,p_cer_attribute30                =>  p_cer_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 594


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

Line: 625


    ROLLBACK TO update_ELIGIBILITY_RULE;

Line: 637


    ROLLBACK TO update_ELIGIBILITY_RULE;

Line: 643


end update_ELIGIBILITY_RULE;

Line: 648


procedure delete_ELIGIBILITY_RULE
  (p_validate                       in  boolean  default false
  ,p_prtn_eligy_rl_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
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ELIGIBILITY_RULE';

Line: 666


    select pgm_id,
           ptip_id,
           plip_id,
           pl_id,
           oipl_id
    from   ben_prtn_elig_f a,
           ben_prtn_eligy_rl_f b
    where  a.prtn_elig_id = b.prtn_elig_id
    and    b.prtn_eligy_rl_id = p_prtn_eligy_rl_id;

Line: 688


  savepoint delete_ELIGIBILITY_RULE;

Line: 701


    ben_ELIGIBILITY_RULE_bk3.delete_ELIGIBILITY_RULE_b
      (
       p_prtn_eligy_rl_id               =>  p_prtn_eligy_rl_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 711


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

Line: 733


    ben_ELIGIBILITY_RULE_bk3.delete_ELIGIBILITY_RULE_a
      (
       p_prtn_eligy_rl_id               =>  p_prtn_eligy_rl_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                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 745


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

Line: 758


    update ben_pgm_f c
    set    c.elig_apls_flag = 'N'
    where not exists
          (select a.pgm_id
           from   ben_prtn_elig_f a,
                  ben_prtn_elig_prfl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.pgm_id = a.pgm_id)
    and not exists
          (select a.pgm_id
           from   ben_prtn_elig_f a,
                  ben_prtn_eligy_rl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.pgm_id = a.pgm_id)
    and c.pgm_id = l_c1.pgm_id;

Line: 778


    update ben_plip_f c
    set    c.elig_apls_flag = 'N'
    where not exists
          (select a.plip_id
           from   ben_prtn_elig_f a,
                  ben_prtn_elig_prfl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.plip_id = a.plip_id)
    and not exists
          (select a.plip_id
           from   ben_prtn_elig_f a,
                  ben_prtn_eligy_rl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.plip_id = a.plip_id)
    and c.plip_id = l_c1.plip_id;

Line: 798


    update ben_ptip_f c
      set    c.elig_apls_flag = 'N'
      where not exists
            (select a.ptip_id
             from   ben_prtn_elig_f a,
                    ben_prtn_elig_prfl_f b
             where  a.prtn_elig_id = b.prtn_elig_id
             and    c.ptip_id = a.ptip_id)
      and not exists
            (select a.ptip_id
             from   ben_prtn_elig_f a,
                    ben_prtn_eligy_rl_f b
             where  a.prtn_elig_id = b.prtn_elig_id
             and    c.ptip_id = a.ptip_id)
      and c.ptip_id = l_c1.ptip_id;

Line: 818


    update ben_pl_f c
    set    c.elig_apls_flag = 'N'
    where not exists
          (select a.pl_id
           from   ben_prtn_elig_f a,
                  ben_prtn_elig_prfl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.pl_id = a.pl_id)
    and not exists
          (select a.pl_id
           from   ben_prtn_elig_f a,
                  ben_prtn_eligy_rl_f b
           where  a.prtn_elig_id = b.prtn_elig_id
           and    c.pl_id = a.pl_id)
    and c.pl_id = l_c1.pl_id;

Line: 838


    update ben_oipl_f c
      set    c.elig_apls_flag = 'N'
      where not exists
            (select a.oipl_id
             from   ben_prtn_elig_f a,
                    ben_prtn_elig_prfl_f b
             where  a.prtn_elig_id = b.prtn_elig_id
             and    c.oipl_id = a.oipl_id)
      and not exists
            (select a.oipl_id
             from   ben_prtn_elig_f a,
                    ben_prtn_eligy_rl_f b
             where  a.prtn_elig_id = b.prtn_elig_id
             and    c.oipl_id = a.oipl_id)
      and c.oipl_id = l_c1.oipl_id;

Line: 873


    ROLLBACK TO delete_ELIGIBILITY_RULE;

Line: 886


    ROLLBACK TO delete_ELIGIBILITY_RULE;

Line: 893


end delete_ELIGIBILITY_RULE;