APPS.BEN_BATCH_ACTN_ITEM_INFO_API SQL Statements

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

Line: 161

procedure update_batch_actn_item_info
  (p_validate                       in  boolean   default false
  ,p_batch_actn_item_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_actn_typ_id                    in  number    default hr_api.g_number
  ,p_cmpltd_dt                      in  date      default hr_api.g_date
  ,p_due_dt                         in  date      default hr_api.g_date
  ,p_rqd_flag                       in  varchar2  default hr_api.g_varchar2
  ,p_actn_cd                        in  varchar2  default hr_api.g_varchar2
  ,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_actn_item_info';

Line: 187

  savepoint update_batch_actn_item_info;

Line: 199

    ben_batch_actn_item_info_bk2.update_batch_actn_item_info_b
      (
       p_batch_actn_item_id             =>  p_batch_actn_item_id
      ,p_benefit_action_id              =>  p_benefit_action_id
      ,p_person_id                      =>  p_person_id
      ,p_actn_typ_id                    =>  p_actn_typ_id
      ,p_cmpltd_dt                      =>  p_cmpltd_dt
      ,p_due_dt                         =>  p_due_dt
      ,p_rqd_flag                       =>  p_rqd_flag
      ,p_actn_cd                        =>  p_actn_cd
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 216

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

Line: 243

    ben_batch_actn_item_info_bk2.update_batch_actn_item_info_a
      (
       p_batch_actn_item_id             =>  p_batch_actn_item_id
      ,p_benefit_action_id              =>  p_benefit_action_id
      ,p_person_id                      =>  p_person_id
      ,p_actn_typ_id                    =>  p_actn_typ_id
      ,p_cmpltd_dt                      =>  p_cmpltd_dt
      ,p_due_dt                         =>  p_due_dt
      ,p_rqd_flag                       =>  p_rqd_flag
      ,p_actn_cd                        =>  p_actn_cd
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 260

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

Line: 289

    ROLLBACK TO update_batch_actn_item_info;

Line: 301

    ROLLBACK TO update_batch_actn_item_info;

Line: 304

end update_batch_actn_item_info;

Line: 309

procedure delete_batch_actn_item_info
  (p_validate                       in  boolean  default false
  ,p_batch_actn_item_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_actn_item_info';

Line: 327

  savepoint delete_batch_actn_item_info;

Line: 340

    ben_batch_actn_item_info_bk3.delete_batch_actn_item_info_b
      (
       p_batch_actn_item_id             =>  p_batch_actn_item_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 349

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

Line: 368

    ben_batch_actn_item_info_bk3.delete_batch_actn_item_info_a
      (
       p_batch_actn_item_id             =>  p_batch_actn_item_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 377

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

Line: 402

    ROLLBACK TO delete_batch_actn_item_info;

Line: 413

    ROLLBACK TO delete_batch_actn_item_info;

Line: 416

end delete_batch_actn_item_info;