APPS.PAY_ELEMENT_TYPE_USAGE_API SQL Statements

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

Line: 169

procedure update_element_type_usage
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_update_mode         in     varchar2
  ,p_inclusion_flag		   in     varchar2 default hr_api.g_varchar2
  ,p_element_type_usage_id         in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_usage_type			   in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_element_type_usage';

Line: 203

  savepoint update_element_type_usage;

Line: 213

    pay_element_type_usage_bk2.update_element_type_usage_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_inclusion_flag		       => p_inclusion_flag
      ,p_element_type_usage_id         => p_element_type_usage_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_usage_type		       => p_usage_type
      );

Line: 226

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

Line: 242

       ,p_datetrack_mode              => p_datetrack_update_mode
       ,p_inclusion_flag	      => p_inclusion_flag
       ,p_element_type_usage_id       => p_element_type_usage_id
       ,p_usage_type		      => p_usage_type
       ,p_object_version_number       => p_object_version_number
       ,p_effective_start_date        => l_effective_start_date
       ,p_effective_end_date          => l_effective_end_date
       );

Line: 256

    pay_element_type_usage_bk2.update_element_type_usage_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_inclusion_flag		       => p_inclusion_flag
      ,p_element_type_usage_id         => p_element_type_usage_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_usage_type		       => p_usage_type
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      );

Line: 271

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

Line: 296

    rollback to update_element_type_usage;

Line: 310

    rollback to update_element_type_usage;

Line: 313

end update_element_type_usage;

Line: 319

procedure delete_element_type_usage
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_delete_mode         in     varchar2
  ,p_element_type_usage_id         in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_element_type_usage';

Line: 351

  savepoint delete_element_type_usage;

Line: 361

    pay_element_type_usage_bk3.delete_element_type_usage_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_delete_mode         => p_datetrack_delete_mode
      ,p_element_type_usage_id         => p_element_type_usage_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      );

Line: 372

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

Line: 388

       ,p_datetrack_mode              => p_datetrack_delete_mode
       ,p_element_type_usage_id       => p_element_type_usage_id
       ,p_object_version_number       => p_object_version_number
       ,p_effective_start_date        => l_effective_start_date
       ,p_effective_end_date          => l_effective_end_date
       );

Line: 400

    pay_element_type_usage_bk3.delete_element_type_usage_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_delete_mode         => p_datetrack_delete_mode
      ,p_element_type_usage_id         => p_element_type_usage_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      );

Line: 413

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

Line: 438

    rollback to delete_element_type_usage;

Line: 452

    rollback to delete_element_type_usage;

Line: 455

end delete_element_type_usage;