DBA Data[Home] [Help]

APPS.BEN_EXT_RSLT_API SQL Statements

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

Line: 30

  ,p_program_update_date            in  date      default null
  ,p_request_id                     in  number    default null
  ,p_output_type                    in  varchar2  default null
  ,p_xdo_template_id                in  number    default null
  ,p_object_version_number          out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
Line: 77

      ,p_program_update_date            =>  p_program_update_date
      ,p_request_id                     =>  p_request_id
      ,p_output_type                    =>  p_output_type
      ,p_xdo_template_id                =>  p_xdo_template_id
      ,p_effective_date               => trunc(p_effective_date)
      );
Line: 113

    ,p_program_update_date           => p_program_update_date
    ,p_request_id                    => p_request_id
    ,p_output_type                    =>  p_output_type
    ,p_xdo_template_id                =>  p_xdo_template_id
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    );
Line: 143

      ,p_program_update_date            =>  p_program_update_date
      ,p_request_id                     =>  p_request_id
      ,p_output_type                    =>  p_output_type
      ,p_xdo_template_id                =>  p_xdo_template_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );
Line: 207

procedure update_EXT_RSLT
  (p_validate                       in  boolean   default false
  ,p_ext_rslt_id                    in  number
  ,p_run_strt_dt                    in  date      default hr_api.g_date
  ,p_run_end_dt                     in  date      default hr_api.g_date
  ,p_ext_stat_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_tot_rec_num                    in  number    default hr_api.g_number
  ,p_tot_per_num                    in  number    default hr_api.g_number
  ,p_tot_err_num                    in  number    default hr_api.g_number
  ,p_eff_dt                         in  date      default hr_api.g_date
  ,p_ext_strt_dt                    in  date      default hr_api.g_date
  ,p_ext_end_dt                     in  date      default hr_api.g_date
  ,p_output_name                    in  varchar2  default hr_api.g_varchar2
  ,p_drctry_name                    in  varchar2  default hr_api.g_varchar2
  ,p_ext_dfn_id                     in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_program_application_id         in  number    default hr_api.g_number
  ,p_program_id                     in  number    default hr_api.g_number
  ,p_program_update_date            in  date      default hr_api.g_date
  ,p_request_id                     in  number    default hr_api.g_number
  ,p_output_type                    in  varchar2  default hr_api.g_varchar2
  ,p_xdo_template_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_EXT_RSLT';
Line: 244

  savepoint update_EXT_RSLT;
Line: 256

    ben_EXT_RSLT_bk2.update_EXT_RSLT_b
      (
       p_ext_rslt_id                    =>  p_ext_rslt_id
      ,p_run_strt_dt                    =>  p_run_strt_dt
      ,p_run_end_dt                     =>  p_run_end_dt
      ,p_ext_stat_cd                    =>  p_ext_stat_cd
      ,p_tot_rec_num                    =>  p_tot_rec_num
      ,p_tot_per_num                    =>  p_tot_per_num
      ,p_tot_err_num                    =>  p_tot_err_num
      ,p_eff_dt                         =>  p_eff_dt
      ,p_ext_strt_dt                    =>  p_ext_strt_dt
      ,p_ext_end_dt                     =>  p_ext_end_dt
      ,p_output_name                    =>  p_output_name
      ,p_drctry_name                    =>  p_drctry_name
      ,p_ext_dfn_id                     =>  p_ext_dfn_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
      ,p_request_id                     =>  p_request_id
      ,p_output_type                    =>  p_output_type
      ,p_xdo_template_id                =>  p_xdo_template_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );
Line: 284

        (p_module_name => 'UPDATE_EXT_RSLT'
        ,p_hook_type   => 'BP'
        );
Line: 310

    ,p_program_update_date           => p_program_update_date
    ,p_request_id                    => p_request_id
    ,p_output_type                    =>  p_output_type
      ,p_xdo_template_id                =>  p_xdo_template_id
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    );
Line: 322

    ben_EXT_RSLT_bk2.update_EXT_RSLT_a
      (
       p_ext_rslt_id                    =>  p_ext_rslt_id
      ,p_run_strt_dt                    =>  p_run_strt_dt
      ,p_run_end_dt                     =>  p_run_end_dt
      ,p_ext_stat_cd                    =>  p_ext_stat_cd
      ,p_tot_rec_num                    =>  p_tot_rec_num
      ,p_tot_per_num                    =>  p_tot_per_num
      ,p_tot_err_num                    =>  p_tot_err_num
      ,p_eff_dt                         =>  p_eff_dt
      ,p_ext_strt_dt                    =>  p_ext_strt_dt
      ,p_ext_end_dt                     =>  p_ext_end_dt
      ,p_output_name                    =>  p_output_name
      ,p_drctry_name                    =>  p_drctry_name
      ,p_ext_dfn_id                     =>  p_ext_dfn_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
      ,p_request_id                     =>  p_request_id
      ,p_output_type                    =>  p_output_type
      ,p_xdo_template_id                =>  p_xdo_template_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );
Line: 350

        (p_module_name => 'UPDATE_EXT_RSLT'
        ,p_hook_type   => 'AP'
        );
Line: 379

    ROLLBACK TO update_EXT_RSLT;
Line: 391

    ROLLBACK TO update_EXT_RSLT;
Line: 394

end update_EXT_RSLT;
Line: 399

procedure delete_EXT_RSLT
  (p_validate                       in  boolean  default false
  ,p_ext_rslt_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_EXT_RSLT';
Line: 417

  savepoint delete_EXT_RSLT;
Line: 430

    ben_EXT_RSLT_bk3.delete_EXT_RSLT_b
      (
       p_ext_rslt_id                    =>  p_ext_rslt_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );
Line: 439

        (p_module_name => 'DELETE_EXT_RSLT'
        ,p_hook_type   => 'BP'
        );
Line: 458

    ben_EXT_RSLT_bk3.delete_EXT_RSLT_a
      (
       p_ext_rslt_id                    =>  p_ext_rslt_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );
Line: 467

        (p_module_name => 'DELETE_EXT_RSLT'
        ,p_hook_type   => 'AP'
        );
Line: 492

    ROLLBACK TO delete_EXT_RSLT;
Line: 503

    ROLLBACK TO delete_EXT_RSLT;
Line: 506

end delete_EXT_RSLT;