APPS.BEN_BATCH_LER_INFO_API SQL Statements

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

Line: 199

procedure update_batch_ler_info
  (p_validate                       in  boolean   default false
  ,p_batch_ler_id                   in  number
  ,p_benefit_action_id              in  number    default hr_api.g_number
  ,p_person_id                      in  number    default hr_api.g_number
  ,p_ler_id                         in  number    default hr_api.g_number
  ,p_lf_evt_ocrd_dt                 in  date      default hr_api.g_date
  ,p_replcd_flag                    in  varchar2  default hr_api.g_varchar2
  ,p_crtd_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_tmprl_flag                     in  varchar2  default hr_api.g_varchar2
  ,p_dltd_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_open_and_clsd_flag             in  varchar2  default hr_api.g_varchar2
  ,p_clsd_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_not_crtd_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_stl_actv_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_clpsd_flag                     in  varchar2  default hr_api.g_varchar2
  ,p_clsn_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_no_effect_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_cvrge_rt_prem_flag             in  varchar2  default hr_api.g_varchar2
  ,p_per_in_ler_id                  in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_batch_ler_info';

Line: 234

  savepoint update_batch_ler_info;

Line: 246

    ben_batch_ler_info_bk2.update_batch_ler_info_b
      (p_batch_ler_id                   => p_batch_ler_id
      ,p_benefit_action_id              => p_benefit_action_id
      ,p_person_id                      => p_person_id
      ,p_ler_id                         => p_ler_id
      ,p_lf_evt_ocrd_dt                 => p_lf_evt_ocrd_dt
      ,p_replcd_flag                    => p_replcd_flag
      ,p_crtd_flag                      => p_crtd_flag
      ,p_tmprl_flag                     => p_tmprl_flag
      ,p_dltd_flag                      => p_dltd_flag
      ,p_open_and_clsd_flag             => p_open_and_clsd_flag
      ,p_clsd_flag                      => p_clsd_flag
      ,p_not_crtd_flag                  => p_not_crtd_flag
      ,p_stl_actv_flag                  => p_stl_actv_flag
      ,p_clpsd_flag                     => p_clpsd_flag
      ,p_clsn_flag                      => p_clsn_flag
      ,p_no_effect_flag                 => p_no_effect_flag
      ,p_cvrge_rt_prem_flag             => p_cvrge_rt_prem_flag
      ,p_per_in_ler_id                  => p_per_in_ler_id
      ,p_business_group_id              => p_business_group_id
      ,p_object_version_number          => p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date));

Line: 274

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

Line: 308

    ben_batch_ler_info_bk2.update_batch_ler_info_a
      (p_batch_ler_id                   => p_batch_ler_id
      ,p_benefit_action_id              => p_benefit_action_id
      ,p_person_id                      => p_person_id
      ,p_ler_id                         => p_ler_id
      ,p_lf_evt_ocrd_dt                 => p_lf_evt_ocrd_dt
      ,p_replcd_flag                    => p_replcd_flag
      ,p_crtd_flag                      => p_crtd_flag
      ,p_tmprl_flag                     => p_tmprl_flag
      ,p_dltd_flag                      => p_dltd_flag
      ,p_open_and_clsd_flag             => p_open_and_clsd_flag
      ,p_clsd_flag                      => p_clsd_flag
      ,p_not_crtd_flag                  => p_not_crtd_flag
      ,p_stl_actv_flag                  => p_stl_actv_flag
      ,p_clpsd_flag                     => p_clpsd_flag
      ,p_clsn_flag                      => p_clsn_flag
      ,p_no_effect_flag                 => p_no_effect_flag
      ,p_cvrge_rt_prem_flag             => p_cvrge_rt_prem_flag
      ,p_per_in_ler_id                  => p_per_in_ler_id
      ,p_business_group_id              => p_business_group_id
      ,p_object_version_number          => l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date));

Line: 336

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

Line: 364

    ROLLBACK TO update_batch_ler_info;

Line: 376

    ROLLBACK TO update_batch_ler_info;

Line: 379

end update_batch_ler_info;

Line: 384

procedure delete_batch_ler_info
  (p_validate                       in  boolean  default false
  ,p_batch_ler_id                   in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_batch_ler_info';

Line: 401

  savepoint delete_batch_ler_info;

Line: 414

    ben_batch_ler_info_bk3.delete_batch_ler_info_b
      (p_batch_ler_id                   => p_batch_ler_id
      ,p_object_version_number          => p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date));

Line: 424

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

Line: 440

    ben_batch_ler_info_bk3.delete_batch_ler_info_a
      (p_batch_ler_id                   => p_batch_ler_id
      ,p_object_version_number          => l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date));

Line: 450

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

Line: 474

    ROLLBACK TO delete_batch_ler_info;

Line: 485

    ROLLBACK TO delete_batch_ler_info;

Line: 488

end delete_batch_ler_info;