APPS.BEN_PL_EXTRACT_ID_API SQL Statements

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

Line: 198

procedure update_pl_extract_id
  (
   p_validate                       in  boolean       default false
  ,p_pl_extract_identifier_id       in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_pl_id                          in  number        default hr_api.g_number
  ,p_plip_id                        in  number        default hr_api.g_number
  ,p_oipl_id                        in  number        default hr_api.g_number
  ,p_third_party_identifier         in  varchar2      default hr_api.g_varchar2
  ,p_organization_id                in  number        default hr_api.g_number
  ,p_job_id                         in  number        default hr_api.g_number
  ,p_position_id                    in  number        default hr_api.g_number
  ,p_people_group_id                in  number        default hr_api.g_number
  ,p_grade_id                       in  number        default hr_api.g_number
  ,p_payroll_id                     in  number        default hr_api.g_number
  ,p_home_state                     in  varchar2      default hr_api.g_varchar2
  ,p_home_zip                       in  varchar2      default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_business_group_id              in  number        default hr_api.g_number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                     varchar2(72) := g_package||'update_pl_extract_id';

Line: 235

  savepoint update_pl_extract_id;

Line: 247

    ben_pl_extract_id_bk2.update_pl_extract_id_b
     (
       p_pl_extract_identifier_id      => p_pl_extract_identifier_id
      ,p_pl_id                         => p_pl_id
      ,p_plip_id                       => p_plip_id
      ,p_oipl_id                       => p_oipl_id
      ,p_third_party_identifier        => p_third_party_identifier
      ,p_organization_id               => p_organization_id
      ,p_job_id                        => p_job_id
      ,p_position_id                   => p_position_id
      ,p_people_group_id               => p_people_group_id
      ,p_grade_id                      => p_grade_id
      ,p_payroll_id                    => p_payroll_id
      ,p_home_state                    => p_home_state
      ,p_home_zip                      => p_home_zip
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_effective_date                => trunc(p_effective_date)
      ,p_datetrack_mode                => p_datetrack_mode
      );

Line: 270

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

Line: 306

    ben_pl_extract_id_bk2.update_pl_extract_id_a
      (
       p_pl_extract_identifier_id         => p_pl_extract_identifier_id
      ,p_effective_start_date             => l_effective_start_date
      ,p_effective_end_date               => l_effective_end_date
      ,p_pl_id                            => p_pl_id
      ,p_plip_id                          => p_plip_id
      ,p_oipl_id                          => p_oipl_id
      ,p_third_party_identifier           => p_third_party_identifier
      ,p_organization_id                  => p_organization_id
      ,p_job_id                           => p_job_id
      ,p_position_id                      => p_position_id
      ,p_people_group_id                  => p_people_group_id
      ,p_grade_id                         => p_grade_id
      ,p_payroll_id                       => p_payroll_id
      ,p_home_state                       => p_home_state
      ,p_home_zip                         => p_home_zip
      ,p_object_version_number            => l_object_version_number
      ,p_business_group_id                => p_business_group_id
      ,p_effective_date                   => trunc(p_effective_date)
      ,p_datetrack_mode                   => p_datetrack_mode
      );

Line: 331

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

Line: 362

    ROLLBACK TO update_pl_extract_id;

Line: 374

    ROLLBACK TO update_pl_extract_id;

Line: 380

end update_pl_extract_id;

Line: 385

procedure delete_pl_extract_id
  (p_validate                       in  boolean  default false
  ,p_pl_extract_identifier_id       in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                     varchar2(72) := g_package||'delete_pl_extract_id';

Line: 408

  savepoint delete_pl_extract_id;

Line: 421

    ben_pl_extract_id_bk3.delete_pl_extract_id_b
      (
       p_pl_extract_identifier_id            =>  p_pl_extract_identifier_id
      ,p_object_version_number               =>  p_object_version_number
      ,p_effective_date                      =>  trunc(p_effective_date)
      ,p_datetrack_mode                      =>  p_datetrack_mode
      );

Line: 431

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

Line: 453

    ben_pl_extract_id_bk3.delete_pl_extract_id_a
      (p_pl_extract_identifier_id       =>  p_pl_extract_identifier_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode
      );

Line: 464

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

Line: 489

    ROLLBACK TO delete_pl_extract_id;

Line: 502

    ROLLBACK TO delete_pl_extract_id;

Line: 508

end delete_pl_extract_id;