APPS.BEN_CWB_MATRIX_API SQL Statements

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

Line: 149

procedure update_cwb_matrix
  (p_validate                      in     boolean  default false
  ,p_cwb_matrix_id                 in     number
  ,p_effective_date                in     date
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_name                          in     varchar2 default hr_api.g_varchar2
  ,p_plan_id                       in     number   default hr_api.g_number
  ,p_matrix_typ_cd                 in     varchar2 default hr_api.g_varchar2
  ,p_person_id                     in     number   default hr_api.g_number
  ,p_row_crit_cd                   in     varchar2 default hr_api.g_varchar2
  ,p_col_crit_cd                   in     varchar2 default hr_api.g_varchar2
  ,p_alct_by_cd                    in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number          ben_cwb_matrix.object_version_number%TYPE;

Line: 167

  l_proc                           varchar2(72) := g_package||'update_cwb_matrix';

Line: 174

  savepoint update_cwb_matrix;

Line: 185

    ben_cwb_matrix_bk2.update_cwb_matrix_b
      (p_cwb_matrix_id               =>   p_cwb_matrix_id
      ,p_effective_date              =>   p_effective_date
      ,p_business_group_id           =>   p_business_group_id
      ,p_name                        =>   p_name
      ,p_plan_id                     =>   p_plan_id
      ,p_matrix_typ_cd               =>   p_matrix_typ_cd
      ,p_person_id                   =>   p_person_id
      ,p_row_crit_cd                 =>   p_row_crit_cd
      ,p_col_crit_cd                 =>   p_col_crit_cd
      ,p_alct_by_cd                  =>   p_alct_by_cd
      ,p_object_version_number       =>   p_object_version_number
      );

Line: 202

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

Line: 230

    ben_cwb_matrix_bk2.update_cwb_matrix_a
      (p_cwb_matrix_id               =>   p_cwb_matrix_id
      ,p_name                        =>   p_name
      ,p_effective_date              =>   p_effective_date
      ,p_plan_id                     =>   p_plan_id
      ,p_matrix_typ_cd               =>   p_matrix_typ_cd
      ,p_person_id                   =>   p_person_id
      ,p_row_crit_cd                 =>   p_row_crit_cd
      ,p_col_crit_cd                 =>   p_col_crit_cd
      ,p_alct_by_cd                  =>   p_alct_by_cd
      ,p_business_group_id           =>   p_business_group_id
      ,p_object_version_number       =>   l_object_version_number
      );

Line: 247

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

Line: 273

    rollback to update_cwb_matrix;

Line: 286

    rollback to update_cwb_matrix;

Line: 289

end update_cwb_matrix;

Line: 295

procedure delete_cwb_matrix
  (p_validate                      in     boolean  default false
  ,p_cwb_matrix_id                 in     number
  ,p_effective_date                in     date
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number          ben_cwb_matrix.object_version_number%TYPE;

Line: 305

  l_proc                           varchar2(72) := g_package||'delete_cwb_matrix';

Line: 312

  savepoint delete_cwb_matrix;

Line: 323

    ben_cwb_matrix_bk3.delete_cwb_matrix_b
      (p_cwb_matrix_id               =>   p_cwb_matrix_id
      ,p_effective_date              =>   p_effective_date
      ,p_object_version_number       =>   p_object_version_number
      );

Line: 332

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

Line: 350

    ben_cwb_matrix_bk3.delete_cwb_matrix_a
      (p_cwb_matrix_id               =>   p_cwb_matrix_id
      ,p_effective_date              =>   p_effective_date
      ,p_object_version_number       =>   l_object_version_number
      );

Line: 359

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

Line: 381

    rollback to delete_cwb_matrix;

Line: 394

    rollback to delete_cwb_matrix;

Line: 397

end delete_cwb_matrix;