APPS.PAY_ITERATIVE_RULES_API SQL Statements

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

Line: 209

procedure update_iterative_rule
(  p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_iterative_rule_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_element_type_id              in     number    default hr_api.g_number
  ,p_result_name                  in     varchar2  default hr_api.g_varchar2
  ,p_iterative_rule_type          in     varchar2  default hr_api.g_varchar2
  ,p_input_value_id               in     number    default hr_api.g_number
  ,p_severity_level               in     varchar2  default hr_api.g_varchar2
  ,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||'update_iterative_rule';

Line: 240

  savepoint UPDATE_ITERATIVE_RULE;

Line: 252

    pay_iterative_rules_bk2.update_iterative_rule_b
      (p_effective_date          => l_effective_date
      ,p_datetrack_mode          => p_datetrack_mode
      ,p_iterative_rule_id       => p_iterative_rule_id
      ,p_object_version_number   => l_object_version_number
      ,p_element_type_id         => p_element_type_id
      ,p_result_name             => p_result_name
      ,p_iterative_rule_type     => p_iterative_rule_type
      ,p_input_value_id          => p_input_value_id
      ,p_severity_level          => p_severity_level
      ,p_business_group_id       => p_business_group_id
      ,p_legislation_code        => p_legislation_code
      );

Line: 268

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

Line: 293

    pay_iterative_rules_bk2.update_iterative_rule_a
      (p_effective_date          => l_effective_date
      ,p_datetrack_mode          => p_datetrack_mode
      ,p_iterative_rule_id       => p_iterative_rule_id
      ,p_object_version_number   => l_object_version_number
      ,p_element_type_id         => p_element_type_id
      ,p_result_name             => p_result_name
      ,p_iterative_rule_type     => p_iterative_rule_type
      ,p_input_value_id          => p_input_value_id
      ,p_severity_level          => p_severity_level
      ,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: 311

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

Line: 336

    rollback to UPDATE_ITERATIVE_RULE;

Line: 351

    rollback to UPDATE_ITERATIVE_RULE;

Line: 363

end update_iterative_rule;

Line: 391

procedure delete_iterative_rule
(  p_validate                         in     boolean   default false
  ,p_effective_date                   in     date
  ,p_datetrack_mode                   in     varchar2
  ,p_iterative_rule_id                in     number
  ,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_iterative_rule';

Line: 415

  savepoint DELETE_ITERATIVE_RULE;

Line: 427

    pay_iterative_rules_bk3.delete_iterative_rule_b
      (p_effective_date          => l_effective_date
      ,p_datetrack_mode          => p_datetrack_mode
      ,p_iterative_rule_id       => p_iterative_rule_id
      ,p_object_version_number   => l_object_version_number
      );

Line: 436

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

Line: 455

    pay_iterative_rules_bk3.delete_iterative_rule_a
      (p_effective_date          => l_effective_date
      ,p_datetrack_mode          => p_datetrack_mode
      ,p_iterative_rule_id       => p_iterative_rule_id
      ,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: 466

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

Line: 492

    rollback to DELETE_ITERATIVE_RULE;

Line: 507

    rollback to DELETE_ITERATIVE_RULE;

Line: 519

end delete_iterative_rule ;