APPS.PAY_ITERATIVE_RULES_SWI SQL Statements

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

Line: 127

PROCEDURE delete_iterative_rule
  (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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_object_version_number         number;

Line: 143

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

Line: 149

  savepoint delete_iterative_rule_swi;

Line: 167

  pay_iterative_rules_api.delete_iterative_rule
    (p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_iterative_rule_id            => p_iterative_rule_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 197

    rollback to delete_iterative_rule_swi;

Line: 214

    rollback to delete_iterative_rule_swi;

Line: 227

end delete_iterative_rule;

Line: 231

PROCEDURE update_iterative_rule
  (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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_object_version_number         number;

Line: 254

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

Line: 260

  savepoint update_iterative_rule_swi;

Line: 278

  pay_iterative_rules_api.update_iterative_rule
    (p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_iterative_rule_id            => p_iterative_rule_id
    ,p_object_version_number        => p_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         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 315

    rollback to update_iterative_rule_swi;

Line: 332

    rollback to update_iterative_rule_swi;

Line: 345

end update_iterative_rule;