APPS.BEN_ELIG_SCRE_WTG_API SQL Statements

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

Line: 37

  l_last_update_date      ben_elig_scre_wtg_f.last_update_date%TYPE;

Line: 38

  l_last_updated_by       ben_elig_scre_wtg_f.last_updated_by%TYPE;

Line: 40

  Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;

Line: 71

  hr_utility.set_location('Insert: '||l_proc, 5);

Line: 72

  insert into ben_elig_scre_wtg_f
      (elig_scre_wtg_id
      ,elig_per_id
      ,elig_per_opt_id
      ,elig_rslt_id
      ,per_in_ler_id
      ,effective_start_date
      ,effective_end_date
      ,object_version_number
      ,eligy_prfl_id
      ,crit_tab_short_name
      ,crit_tab_pk_id
      ,computed_score
      ,benefit_action_id
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      )
  Values
    (l_elig_scre_wtg_id
    ,p_elig_per_id
    ,p_elig_per_opt_id
    ,p_elig_rslt_id
    ,p_per_in_ler_id
    ,l_effective_start_date
    ,l_effective_end_date
    ,l_object_version_number
    ,p_eligy_prfl_id
    ,p_crit_tab_short_name
    ,p_crit_tab_pk_id
    ,p_computed_score
    ,p_benefit_action_id
    ,l_created_by
    ,l_creation_date
    ,l_last_update_date
    ,l_last_updated_by
    );

Line: 110

  hr_utility.set_location('Dn Insert: '||l_proc, 5);

Line: 164

procedure update_perf_score_weight
(  p_validate                       in boolean    default false
  ,p_elig_scre_wtg_id               in number
  ,p_effective_date                 in date
  ,p_datetrack_mode                 in varchar2
  ,p_benefit_action_id              in number   default hr_api.g_number
  ,p_computed_score                 in number   default hr_api.g_number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_score_weight';

Line: 189

  savepoint update_score_weight;

Line: 232

    ROLLBACK TO update_score_weight;

Line: 248

    ROLLBACK TO update_score_weight;

Line: 251

end update_perf_score_weight;

Line: 253

procedure delete_perf_score_weight
(  p_validate                       in boolean    default false
  ,p_elig_scre_wtg_id               in number
  ,p_effective_date                 in date
  ,p_datetrack_mode                 in varchar2
  ,p_object_version_number          in out nocopy number
) is

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

Line: 274

  savepoint delete_score_weight;

Line: 306

    ROLLBACK TO delete_score_weight;

Line: 320

    ROLLBACK TO delete_score_weight;

Line: 323

end delete_perf_score_weight;

Line: 341

  select *
    from ben_elig_scre_wtg_f
   where eligy_prfl_id = p_eligy_prfl_id
     and crit_tab_short_name = p_crit_tab_short_name
     and crit_tab_pk_id = p_crit_tab_pk_id
     and nvl(elig_per_id,-1) = nvl(p_elig_per_id,-1)
     and nvl(elig_per_opt_id,-1) = nvl(p_elig_per_opt_id,-1)
     and nvl(elig_rslt_id,-1) = nvl(p_elig_rslt_id,-1)
     and p_effective_date between effective_start_date
     and effective_end_date;

Line: 359

  l_update                    boolean;

Line: 360

  l_update_override           boolean;

Line: 361

  l_update_change_insert      boolean;

Line: 425

            p_update               => l_update,
            p_update_override      => l_update_override,
            p_update_change_insert => l_update_change_insert);

Line: 429

           if l_update_override then
              l_datetrack_mode := hr_api.g_update_override;

Line: 431

           elsif l_update then
              l_datetrack_mode := hr_api.g_update;

Line: 437

           ben_elig_scre_wtg_api.update_perf_score_weight
           (p_validate           => false
           ,p_elig_scre_wtg_id   => l_elig_scre_wtg_id
           ,p_effective_date     => p_effective_date
           ,p_datetrack_mode     => l_datetrack_mode
           ,p_computed_score     => p_score_tab(i).computed_score
           ,p_benefit_action_id  => p_score_tab(i).benefit_action_id
           ,p_effective_start_date  => l_effective_start_date
           ,p_effective_end_date    => l_effective_end_date
           ,p_object_version_number => l_sc_wg.object_version_number);