APPS.HR_RATE_VALUES_API SQL Statements

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

Line: 43

  select rate_uom
  from   pay_rates
  where  rate_id = p_rate_id;

Line: 48

  select currency_code
  from   per_business_groups_perf
  where  business_group_id = p_business_group_id;

Line: 264

PROCEDURE update_rate_value
  (p_validate                 IN     BOOLEAN       DEFAULT FALSE
  ,p_grade_rule_id            IN     NUMBER
  ,p_effective_date           IN     DATE
  ,p_datetrack_mode           IN     VARCHAR2
  ,p_currency_code            IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_maximum                  IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_mid_value                IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_minimum                  IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_sequence                 IN     NUMBER        DEFAULT hr_api.g_number
  ,p_value                    IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_object_version_number    IN OUT NOCOPY NUMBER
  ,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_rate_value';

Line: 297

  SAVEPOINT update_rate_value;

Line: 309

	hr_rate_value_bk2.update_rate_value_b
      (p_grade_rule_id            => p_grade_rule_id
      ,p_effective_date           => p_effective_date
      ,p_currency_code            => p_currency_code
      ,p_maximum                  => p_maximum
      ,p_mid_value                => p_mid_value
      ,p_minimum                  => p_minimum
      ,p_sequence                 => p_sequence
      ,p_value                    => p_value
      ,p_object_version_number    => l_object_version_number);

Line: 325

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

Line: 353

	hr_rate_value_bk2.update_rate_value_a
      (p_grade_rule_id            => p_grade_rule_id
      ,p_effective_date           => p_effective_date
      ,p_currency_code            => p_currency_code
      ,p_maximum                  => p_maximum
      ,p_mid_value                => p_mid_value
      ,p_minimum                  => p_minimum
      ,p_sequence                 => p_sequence
      ,p_value                    => p_value
      ,p_object_version_number    => l_object_version_number
      ,p_effective_start_date     => l_effective_start_date
      ,p_effective_end_date       => l_effective_end_date);

Line: 371

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

Line: 404

    ROLLBACK TO update_rate_value;

Line: 421

    ROLLBACK TO update_rate_value;

Line: 429

END update_rate_value;

Line: 434

PROCEDURE delete_rate_value
  (p_validate                       IN     BOOLEAN  DEFAULT FALSE
  ,p_grade_rule_id                  IN     NUMBER
  ,p_datetrack_mode                 IN     VARCHAR2
  ,p_effective_date                 IN     DATE
  ,p_object_version_number          IN OUT NOCOPY NUMBER
  ,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_rate_value';

Line: 458

  SAVEPOINT delete_rate_value;

Line: 472

	hr_rate_value_bk3.delete_rate_value_b
      (p_grade_rule_id                  => p_grade_rule_id
      ,p_object_version_number          => l_object_version_number
      ,p_effective_date                 => l_effective_date);

Line: 482

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

Line: 503

	hr_rate_value_bk3.delete_rate_value_a
      (p_grade_rule_id                  => p_grade_rule_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                 => l_effective_date);

Line: 515

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

Line: 548

    ROLLBACK TO delete_rate_value;

Line: 565

    ROLLBACK TO delete_rate_value;

Line: 572

END delete_rate_value;

Line: 606

  select rate_uom
  from   pay_rates
  where  rate_id = p_rate_id;

Line: 611

  select currency_code
  from   per_business_groups_perf
  where  business_group_id = p_business_group_id;

Line: 760

PROCEDURE update_assignment_rate_value
  (p_validate                 IN     BOOLEAN       DEFAULT FALSE
  ,p_grade_rule_id            IN     NUMBER
  ,p_effective_date           IN     DATE
  ,p_datetrack_mode           IN     VARCHAR2
  ,p_currency_code            IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_value                    IN     VARCHAR2      DEFAULT hr_api.g_varchar2
  ,p_object_version_number    IN OUT NOCOPY NUMBER
  ,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_assignment_rate_value';

Line: 788

  SAVEPOINT update_assignment_rate_value;

Line: 798

  hr_rate_values_api.update_rate_value
    (p_validate                 => p_validate
    ,p_grade_rule_id            => p_grade_rule_id
    ,p_effective_date           => l_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    ,p_currency_code            => p_currency_code
    ,p_value                    => p_value
    ,p_object_version_number    => l_object_version_number
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date);

Line: 834

    ROLLBACK TO update_assignment_rate_value;

Line: 851

    ROLLBACK TO update_assignment_rate_value;

Line: 858

END update_assignment_rate_value;